From 1b3db8f5683373dd8e179b006e7314783dd1f9db Mon Sep 17 00:00:00 2001 From: cnf <3200815559@qq.com> Date: 星期三, 10 九月 2025 14:42:12 +0800 Subject: [PATCH] 文件补充 --- WebApi/Gs.BaseInfo/Services/MesCustomerManager.cs | 51 +++++++++++++++++++++------------------------------ 1 files changed, 21 insertions(+), 30 deletions(-) diff --git a/WebApi/Gs.BaseInfo/Services/MesCustomerManager.cs b/WebApi/Gs.BaseInfo/Services/MesCustomerManager.cs index a00ab71..7282582 100644 --- a/WebApi/Gs.BaseInfo/Services/MesCustomerManager.cs +++ b/WebApi/Gs.BaseInfo/Services/MesCustomerManager.cs @@ -11,15 +11,11 @@ namespace Gs.BaseInfo.Services; -/// <summary> -/// 瀹㈡埛绠$悊 -/// </summary> [ApiGroup(ApiGroupNames.BaseInfo)] public class MesCustomerManager : Repository<MesCustomer>, IRomteService { private readonly IHttpContextAccessor _http; private readonly string _userCode, _userGuid, _orgFids; - public MesCustomerManager(IHttpContextAccessor httpContextAccessor) { _http = httpContextAccessor; @@ -35,6 +31,7 @@ [RequestMethod(RequestMethods.POST)] public ReturnDto<PageList<MesCustomer>> GetListPage(PageQuery query) { + var pageList = new PageList<MesCustomer>(); try { @@ -43,32 +40,26 @@ new StringBuilder(query.sortName + " " + query.sortOrder); var totalCount = 0; var itemsList = Db - .Queryable<MesCustomer, SysOrganization>((a, org) => - new object[] - { - JoinType.Left, a.FSubsidiary == org.Fid - }).Select((a, org) => new MesCustomer - { - FSubsidiary = "(" + org.FNumber + ")" + org.Name, - Fforbidstatus = a.Fforbidstatus + ":" + - (a.Fforbidstatus == "A" ? "姝e父" : "绂佺敤"), - DataType = a.DataType + ":" - + SqlFunc.IF(a.DataType == "Z") - .Return("鏆傚瓨") - .ElseIF(a.DataType == "A") - .Return("鍒涘缓") - .ElseIF(a.DataType == "B") - .Return("瀹℃牳涓�") - .ElseIF(a.DataType == "C") - .Return("宸插鏍�") - .ElseIF(a.DataType == "D") - .Return("閲嶆柊瀹℃牳") - .End(a.DataType) - }, true) - .Where(_sbWhere.ToString()) - .OrderBy(_sbBy.ToString()) - .ToPageList(query.currentPage, query.everyPageSize, - ref totalCount); + .Queryable<MesCustomer, SysOrganization>( + (a, org) => new object[] + { + JoinType.Left, a.FSubsidiary == org.Fid, + }).Select((a, org) => new MesCustomer + { + FSubsidiary = "(" + org.FNumber + ")" + org.Name, + Fforbidstatus = a.Fforbidstatus + ":" + (a.Fforbidstatus == "A" ? "姝e父" : "绂佺敤"), + DataType = a.DataType + ":" + + SqlFunc.IF(a.DataType == "Z").Return("鏆傚瓨") + .ElseIF(a.DataType == "A").Return("鍒涘缓") + .ElseIF(a.DataType == "B").Return("瀹℃牳涓�") + .ElseIF(a.DataType == "C").Return("宸插鏍�") + .ElseIF(a.DataType == "D").Return("閲嶆柊瀹℃牳") + .End(a.DataType) + }, true) + .Where(_sbWhere.ToString()) + .OrderBy(_sbBy.ToString()) + .ToPageList(query.currentPage, query.everyPageSize, + ref totalCount); pageList = new PageList<MesCustomer>(itemsList, totalCount, query.everyPageSize); return ReturnDto<PageList<MesCustomer>>.QuickReturn(pageList, -- Gitblit v1.9.3