From 6581234907def80093c3e9b4cdbc864714ed3f59 Mon Sep 17 00:00:00 2001
From: kyy <3283105747@qq.com>
Date: 星期二, 05 八月 2025 08:49:52 +0800
Subject: [PATCH] 1、首检生成检验项目时报请重试优化（字段长度限制所导致）
---
MES.Service/service/QC/SJService.cs | 7 ++++++-
1 files changed, 6 insertions(+), 1 deletions(-)
diff --git a/MES.Service/service/QC/SJService.cs b/MES.Service/service/QC/SJService.cs
index 5bb9e7f..a7942ca 100644
--- a/MES.Service/service/QC/SJService.cs
+++ b/MES.Service/service/QC/SJService.cs
@@ -110,6 +110,8 @@
a => a.ItemCj.Contains(queryObj.ItemCj))
.WhereIF(!string.IsNullOrEmpty(queryObj.daa001),
a => a.daa001.Contains(queryObj.daa001))
+ .WhereIF(!string.IsNullOrEmpty(queryObj.Cjr),
+ a => a.Cjr.Contains(queryObj.Cjr))
.OrderBy(a => a.BillNo, OrderByType.Desc)
.ToPageList(queryObj.PageIndex, queryObj.Limit);
@@ -186,7 +188,9 @@
return db
.Queryable<MesQualityStandard>()
- .Where(b => b.QsType == "1" && b.ItemId == itemId).Select(b =>
+ .Where(b => b.QsType == "1" && b.ItemId == itemId)
+ .OrderBy(b => b.Xh) // 鎸塜h瀛楁鍗囧簭鎺掑簭
+ .Select(b =>
new QsItemIpiItem
{
ProjName = b.ProjName,
@@ -448,6 +452,7 @@
return db.Updateable<QsItemIpiReq>()
.SetColumns(s => s.IsPass == result)
.SetColumns(s => s.StatusUser == detail.CreateBy)
+ .SetColumns(s => s.StatusDate== DateTime.Now)
.SetColumns(s => s.CompleteTime == DateTime.Now)
.Where(s => s.Id == detail.Gid)
.ExecuteCommand();
--
Gitblit v1.9.3