From ba1f552b1f2f795620455032df5ddbdc439a3e01 Mon Sep 17 00:00:00 2001
From: zyf <1071160500@qq.com>
Date: 星期四, 05 六月 2025 10:49:16 +0800
Subject: [PATCH] 巡检检验项根据工序查询， 入库检上对工单生产数量的逻辑变更
---
MES.Service/service/QC/RKJService.cs | 43 ++++++++++++++++++++++++++++++++++++++-----
1 files changed, 38 insertions(+), 5 deletions(-)
diff --git a/MES.Service/service/QC/RKJService.cs b/MES.Service/service/QC/RKJService.cs
index 3c53e13..1229e40 100644
--- a/MES.Service/service/QC/RKJService.cs
+++ b/MES.Service/service/QC/RKJService.cs
@@ -513,9 +513,22 @@
{
//womdaa 宸茬敓浜ч噺 DAA011鍔犱笂鏉＄爜鎶ュ伐鏁伴噺
db.Updateable<Womdaa>()
- .SetColumns(b => b.Daa011 == b.Daa011 + sumQty)
+ .SetColumns(b => b.Daa011 == SqlFunc.IsNull(b.Daa011, 0) + sumQty)
.Where(b => b.Daa001 == qsItemOqcReq.Daa001)
.ExecuteCommand();
+
+ //鍒ゆ柇鏄惁瀹屽伐
+ var complete = db.Queryable<Womdaa>()
+ .Where(a => a.Daa008 == a.Daa011 && a.Daa001== qsItemOqcReq.Daa001)
+ .Count();
+
+ if (complete > 0)
+ {
+ db.Updateable<Womdaa>()
+ .SetColumns(b => b.Daa018 == "瀹屽伐")
+ .Where(b => b.Daa001 == qsItemOqcReq.Daa001)
+ .ExecuteCommand();
+ }
}
}
else if ("涓嶅悎鏍�".Equals(FcheckResu))
@@ -812,7 +825,7 @@
});
}
- public int saveItem(RKJDto rkjDto)
+ public int saveItem(RKJDto rkjDto) //鑷姩鐢熸垚鍚堟牸鐨勬楠岄」
{
var items = rkjDto.items;
var userNo = rkjDto.userNo;
@@ -869,18 +882,32 @@
.Select((a, b) => new {b.Quantity })
.MergeTable().Sum( a=> a.Quantity);
+ /*
//鏇存柊鐢熶骇閲�
db.Updateable<Womdaa>()
- .SetColumns(b => b.Daa011 == b.Daa011 + sumQty)
+ .SetColumns(b => b.Daa011 == SqlFunc.IsNull(b.Daa011, 0) + sumQty)
.Where(b => b.Daa001 == oqcReqList.Daa001)
.ExecuteCommand();
+ //鍒ゆ柇鏄惁瀹屽伐
+ var complete = db.Queryable<Womdaa>()
+ .Where(a => a.Daa008 == a.Daa011 && a.Daa001 == oqcReqList.Daa001)
+ .Count();
+ if (complete > 0)
+ {
+ db.Updateable<Womdaa>()
+ .SetColumns(b => b.Daa018 == "瀹屽伐")
+ .Where(b => b.Daa001 == oqcReqList.Daa001)
+ .ExecuteCommand();
+ }
+
+ */
return Convert.ToInt32(rkjDto.gid);
}
- public int cleanReqResult(RKJDto dto)
+ public int cleanReqResult(RKJDto dto) //娓呴櫎妫�楠岀粨鏋�
{
if (isRk(dto.gid)) throw new Exception("宸叉湁鏉＄爜鍏ュ簱锛屼笉鍏佽娓呴櫎妫�楠岀粨鏋�");
@@ -947,7 +974,13 @@
{
//womdaa 宸茬敓浜ч噺 DAA011鎵ｉ櫎鏉＄爜鎶ュ伐鏁伴噺
db.Updateable<Womdaa>()
- .SetColumns(b => b.Daa011 == b.Daa011 - sumQty)
+ .SetColumns(b => b.Daa011 == SqlFunc.IsNull(b.Daa011, 0) - sumQty)
+ .Where(b => b.Daa001 == oqcReqList.Daa001)
+ .ExecuteCommand();
+
+ //宸ュ崟鐘舵�佹洿鏀逛负寮�宸�
+ db.Updateable<Womdaa>()
+ .SetColumns(b => b.Daa018 == "寮�宸�")
.Where(b => b.Daa001 == oqcReqList.Daa001)
.ExecuteCommand();
}
--
Gitblit v1.9.3