llj排序

xwt

3 天以前 6d3eca191a75ab2f4229e4514b36f04ec79bc0fe

llj排序

 StandardInterface/MES.Service/service/QC/LljService.cs

@@ -67,15 +67,7 @@
                        .Contains(queryObj.SearchValue.ToLower()))
          //  .OrderByDescending((a, b,
            
            .OrderBy ((a, b,e, f, g, i) => a.Id)
            //.Select((a, b,
            //        e, f, g, i) => new LtsLlj
            //        {
            //            //UserName = g.Fname,
            //            //UserName = (i.Fname!=null ||i.Fname!="") ? i.Fname : g.Fname,
            //            UserName = i.Fname != null || i.Fname != "" ? i.Fname : g.Fname,
            //            CreateUserName = e.Fname
            //        }, true)
            .OrderBy("CASE WHEN a.STATUS = '已提交' THEN 0 ELSE 1 END, a.IQC_DATE desc, a.ID asc")
            .ToPageList(queryObj.PageIndex, queryObj.Limit, ref totalCount); 

        var emergencyValues = pageList.Select(item => item.EMERGENCY).ToList(); 

 StandardInterface/MES.Service/service/QC/RKJService.cs

@@ -39,16 +39,12 @@
    {
        var db = SqlSugarHelper.GetInstance();
        return db.Queryable<MesLine>()
            .Where(t =>
                t.LineStyle == "包装" ||
                SqlFunc.ContainsArray(new[] { "V1", "V3", "V5", "V6" },
                    t.LineNo))
            .OrderBy(t => t.LineNo)
            .Select(t => new MesLine
            {
                LineNo = t.LineNo,
                LineName = t.LineName
            }).OrderBy("LINE_NO")
            })
            .ToList();
    }