文件补充

cnf

7 天以前 1b3db8f5683373dd8e179b006e7314783dd1f9db

 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" ? "正常" : "禁用"),
                    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" ? "正常" : "禁用"),
                       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,