From 91489875fc8c9fd2b44c3791ca6f67dcf559675f Mon Sep 17 00:00:00 2001 From: zyf <1071160500@qq.com> Date: 星期三, 18 六月 2025 18:52:56 +0800 Subject: [PATCH] 修改入库检更新工单完工条件 --- MES.Service/service/QC/RKJService.cs | 6 +++++- 1 files changed, 5 insertions(+), 1 deletions(-) diff --git a/MES.Service/service/QC/RKJService.cs b/MES.Service/service/QC/RKJService.cs index 4e3bf39..43f0696 100644 --- a/MES.Service/service/QC/RKJService.cs +++ b/MES.Service/service/QC/RKJService.cs @@ -522,7 +522,11 @@ .Where(a => a.Daa008 == a.Daa011 && a.Daa001== qsItemOqcReq.Daa001) .Count(); - if (complete > 0) + var WqtQty = db.Queryable<Womdab>() + .Where(a => a.Dab001 == qsItemOqcReq.Daa001) + .Sum(a => a.Dab006- SqlFunc.IsNull(a.Dab007, 0)); + + if (complete > 0 && WqtQty == 0) //榻愬涓斿伐鍗曠敓浜ф暟閲�=宸ュ崟鏁伴噺锛屽伐鍗曟洿鏀逛负瀹屽伐 { db.Updateable<Womdaa>() .SetColumns(b => b.Daa018 == "瀹屽伐") -- Gitblit v1.9.3