From 6d3eca191a75ab2f4229e4514b36f04ec79bc0fe Mon Sep 17 00:00:00 2001
From: xwt <2740516069@qq.com>
Date: 星期三, 09 七月 2025 13:58:46 +0800
Subject: [PATCH] llj排序
---
StandardInterface/MES.Service/service/QC/LljService.cs | 15 ++++-----------
1 files changed, 4 insertions(+), 11 deletions(-)
diff --git a/StandardInterface/MES.Service/service/QC/LljService.cs b/StandardInterface/MES.Service/service/QC/LljService.cs
index 89acc75..57e31ce 100644
--- a/StandardInterface/MES.Service/service/QC/LljService.cs
+++ b/StandardInterface/MES.Service/service/QC/LljService.cs
@@ -65,17 +65,9 @@
.Contains(queryObj.SearchValue.ToLower())
|| a.ItemModel.ToLower()
.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)
+ // .OrderByDescending((a, b,
+
+ .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();
@@ -682,6 +674,7 @@
return db.Updateable<MesQaItemsDetect01>()
.SetColumns(it =>
it.FngDesc == dto.Remarks) //SetColumns鏄彲浠ュ彔鍔犵殑 鍐�2涓氨2涓瓧娈佃祴鍊�
+ .SetColumns(it => it.PHSY == dto.PHSY)//鐮村潖瀹為獙鏁�
.Where(it => it.ReleaseNo == dto.releaseNo)
.ExecuteCommand();
});
--
Gitblit v1.9.3