| | |
| | | |
| | | 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; |
| | |
| | | [RequestMethod(RequestMethods.POST)] |
| | | public ReturnDto<PageList<MesCustomer>> GetListPage(PageQuery query) |
| | | { |
| | | |
| | | var pageList = new PageList<MesCustomer>(); |
| | | try |
| | | { |
| | |
| | | new StringBuilder(query.sortName + " " + query.sortOrder); |
| | | var totalCount = 0; |
| | | var itemsList = Db |
| | | .Queryable<MesCustomer, SysOrganization>((a, org) => |
| | | new object[] |
| | | .Queryable<MesCustomer, SysOrganization>( |
| | | (a, org) => new object[] |
| | | { |
| | | JoinType.Left, a.FSubsidiary == org.Fid |
| | | JoinType.Left, a.FSubsidiary == org.Fid, |
| | | }).Select((a, org) => new MesCustomer |
| | | { |
| | | FSubsidiary = "(" + org.FNumber + ")" + org.Name, |
| | | Fforbidstatus = a.Fforbidstatus + ":" + |
| | | (a.Fforbidstatus == "A" ? "正常" : "禁用"), |
| | | Fforbidstatus = a.Fforbidstatus + ":" + (a.Fforbidstatus == "A" ? "正常" : "禁用"), |
| | | 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("重新审核") |
| | | + 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()) |