From 757e9a10418043eb1a5c5e41975d3eb39db66a80 Mon Sep 17 00:00:00 2001
From: 移动系统liao <liaoxujun@qq.com>
Date: 星期五, 20 六月 2025 14:27:04 +0800
Subject: [PATCH] no message
---
cylsg/cylsg.Application/CyOS/CyOSSettingController.cs | 80 ++++++++++++++++++++++++++++++++++-----
1 files changed, 69 insertions(+), 11 deletions(-)
diff --git a/cylsg/cylsg.Application/CyOS/CyOSSettingController.cs b/cylsg/cylsg.Application/CyOS/CyOSSettingController.cs
index 687476c..dcdb043 100644
--- a/cylsg/cylsg.Application/CyOS/CyOSSettingController.cs
+++ b/cylsg/cylsg.Application/CyOS/CyOSSettingController.cs
@@ -7,6 +7,7 @@
using System.Linq;
using System.Text;
using System.Threading.Tasks;
+using static SKIT.FlurlHttpClient.Wechat.Api.Models.ProductOfflineGetSameCityTemplateResponse.Types.Template.Types;
namespace cylsg.Application.CyOS
{
@@ -41,14 +42,14 @@
Name = x.Name,
Keyid = x.Keyid,
Remark = x.Remark,
- }).WithCache(3600).ToListAsync();
+ }).WithCache(60).ToListAsync();
}
/// <summary>
/// 鑾峰彇绉戠洰鍒楄〃
/// </summary>
/// <returns></returns>
[HttpGet]
-
+ [AllowAnonymous]
public async Task<List<OaSubjectSet>> getKeMuList()
{
return await _client.Queryable<OaSubjectSet>().Where(x => x.Status == true && x.FirmId == _oAServices.firmId && x.SubjectType == "璐�").Select(x => new OaSubjectSet
@@ -56,7 +57,7 @@
SubjectName = x.SubjectName,
Keyid = x.Keyid,
Remark = x.Remark,
- }).WithCache(3600).ToListAsync();
+ }).WithCache(60).ToListAsync();
}
/// <summary>
/// 鑾峰彇娴佹按鍙�
@@ -73,7 +74,7 @@
/// </summary>
/// <returns></returns>
[HttpGet]
- [AllowAnonymous]
+ //[AllowAnonymous]
public async Task<object> GeCorporateClients()
{
return await _client.Queryable<OA_CorporateClients>()
@@ -94,18 +95,57 @@
/// </summary>
/// <returns></returns>
[HttpGet]
+
public async Task<List<OaStaff>> Getdrivers()
{
- return await _client.Queryable<OaStaff>().Where(x => x.Status == "鍦ㄨ亴" && x.FirmId == _oAServices.firmId && x.BF_IsDriver).Select(x => new OaStaff
+ return await _client.Queryable<OaStaff>().Includes(x=>x.Car).Where(x => x.Status == "鍦ㄨ亴" && x.FirmId == _oAServices.firmId && x.BF_IsDriver).Select(x => new OaStaff
{
Name = x.Name,
MemberId = x.MemberId,
Keyid = x.Keyid,
+ Car=x.Car
- }).WithCache(1800).ToListAsync();
+ }).ToListAsync();
}
+ /// <summary>
+ /// 鑾峰彇杞﹁締鍒楄〃
+ /// </summary>
+ /// <returns></returns>
+ [HttpGet]
+ public async Task<List<OA_CarManage>> GetCarList()
+ {
+ var listdata= await _client.Queryable<OA_CarManage>().Includes(x => x.Staff).Where(x => x.MemberID == _oAServices.firmId ).Select(x=>new OA_CarManage
+ {
+ Keyid = x.Keyid,
+ CarNumber = x.CarNumber,
+ Staff=x.Staff
+ })
+ .ToListAsync();
+
+ foreach (var item in listdata)
+ {
+ if(item.Staff!=null)
+ {
+ if (item.Staff.Status != "鍦ㄨ亴")
+ {
+ item.Mark = "璇ュ憳宸ヤ笉灞炰簬鍦ㄨ亴鐘舵��,娲捐溅鍚庡彲鑳芥棤娉曞畬鎴愬悗缁祦绋�";
+ }
+ if (item.Staff.BF_IsDriver )
+ {
+ item.Mark+= "璇ュ憳宸ヤ笉鏄笓鑱屽徃鏈�";
+ }
+ item.CarNumber = item.CarNumber + "(" + item.Staff.Name + ")";
+ item.Staff = null;
+ }
+ item.StaffID = 0;
+
+
+ }
+
+ return listdata;
+ }
/// <summary>
/// 鑾峰彇7澶╁唴鍙告満鍒楄〃
/// </summary>
@@ -114,14 +154,16 @@
[AllowAnonymous]
public async Task<List<OaStaff>> GetDriversOfWithin7days()
{
- var list = await _client.Queryable<OA_DeliverPlan>().Where(x => SqlFunc.ToDate(x.DeliverTime) < DateTime.Now.AddDays(8).Date && SqlFunc.ToDate(x.DeliverTime) >= DateTime.Now.Date).GroupBy(x => x.DriverId).Select(x => x.DriverId).ToListAsync();
- return await _client.Queryable<OaStaff>().In(list).Where(x => x.Status == "鍦ㄨ亴" && x.FirmId == _oAServices.firmId && x.BF_IsDriver).Select(x => new OaStaff
+
+ var list = await _client.Queryable<OA_DeliverPlanPaiche>().Where(x =>( x.DeliverTime.Value.Date < DateTime.Now.AddDays(8).Date) && (x.DeliverTime.Value.Date >= DateTime.Now.Date)).Select(x => x.DriverId).ToListAsync();
+ return await _client.Queryable<OaStaff>().Includes(x=>x.Car).Where(x=>list.Contains(x.Keyid)).Where(x => x.Status == "鍦ㄨ亴" && x.FirmId == _oAServices.firmId && x.BF_IsDriver).Select(x => new OaStaff
{
Name = x.Name,
MemberId = x.MemberId,
Keyid = x.Keyid,
+ Car=x.Car
- }).WithCache(1800).ToListAsync();
+ })/*.WithCache(30)*/.ToListAsync(); //Includes(x => x.Car)鍔犵紦瀛樹細鎶ラ敊
//// return await _client.Queryable<OA_DeliverPlan>()
////.LeftJoin<OaStaff>((dp, os) => dp.DriverId == os.Keyid)
////.Where((dp, os) => SqlFunc.ToDate(dp.DeliverTime) < DateTime.Now.AddDays(8).Date
@@ -140,9 +182,25 @@
////.ToListAsync();
}
+ /// <summary>
+ /// 鑾峰彇鍛樺伐鍒楄〃
+ /// </summary>
+ /// <returns></returns>
+ [HttpGet]
+ public async Task<List<OaStaff>>GetStaffList()
+ {
+ return await _client.Queryable<OaStaff>().Where(x => x.Status == "鍦ㄨ亴" && x.FirmId == _oAServices.firmId && x.BF_IsDriver).Select(x => new OaStaff
+ {
+ Name = x.Name,
+ MemberId = x.MemberId,
+ Keyid = x.Keyid,
+
-
-
+ }).WithCache(30).ToListAsync();
+ }
}
+
+
+
}
--
Gitblit v1.9.1