From 731b5b8b9d5826c5e7343d0a7b5254731a522273 Mon Sep 17 00:00:00 2001
From: 快乐的昕的电脑 <快乐的昕的电脑@DESKTOP-C2BQPQU>
Date: 星期三, 22 十月 2025 15:37:15 +0800
Subject: [PATCH] 逻辑优化
---
Services/MesInvItemBarcodesManager.cs | 25 ++++++++++++++++++++++++-
1 files changed, 24 insertions(+), 1 deletions(-)
diff --git a/Services/MesInvItemBarcodesManager.cs b/Services/MesInvItemBarcodesManager.cs
index 90d20c2..66f895b 100644
--- a/Services/MesInvItemBarcodesManager.cs
+++ b/Services/MesInvItemBarcodesManager.cs
@@ -290,6 +290,8 @@
if (womdaa == null) throw new Exception("宸ュ崟鍗曞彿涓嶅瓨鍦�");
+ if (womdaa.Daa018 != "寮�宸�") throw new Exception("宸ュ崟鏈紑宸�");
+
var okQty = query.currentCjNum - query.initCjNum - query.bf;//鑹搧鏁伴噺
// 鍒涘缓鎶ュ伐璁板綍
@@ -311,12 +313,33 @@
BgPerson = query.staffNo // 鏂板锛氭姤宸ヤ汉缂栧彿
};
- // 鏇存柊宸ュ崟Daa011涓哄師鍊煎姞涓婃湰娆¤壇鍝佹暟閲�
+ // 鏇存柊宸ュ崟Daa011涓哄師鍊煎姞涓婃湰娆¤壇鍝佹暟閲忥紝Daa012涓哄師鍊煎姞涓婃湰娆′笉鑹搧鏁伴噺
Db.Updateable<Womdaa>()
.SetColumns(x => x.Daa011 == (womdaa.Daa011 ?? 0) + (okQty ?? 0))
+ .SetColumns(x => x.Daa012 == (womdaa.Daa012 ?? 0) + (query.bf ?? 0))
.Where(x => x.Daa001 == womdaa.Daa001)
.ExecuteCommand();
+ // 鍒ゆ柇鏄惁鍏ㄩ儴瀹屽伐锛岃嫢鏄垯鍐欏叆瀹為檯瀹屽伐鏃ユ湡
+ var womdaaAfter = Db.Queryable<Womdaa>()
+ .Where(s => s.Daa001 == query.orderNo)
+ .First();
+ if (womdaaAfter != null && womdaaAfter.Daa011 >= womdaaAfter.Daa008)
+ {
+ var finishTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
+ Db.Updateable<Womdaa>()
+ .SetColumns(x => x.Daa017 == DateTime.Parse(finishTime))
+ .SetColumns(x => x.Daa018 == "瀹屽伐")
+ .Where(x => x.Daa001 == womdaaAfter.Daa001)
+ .ExecuteCommand();
+
+ // 鍚屾鏇存柊MES_ORDER_STA鐨凟ND_TIME
+ Db.Updateable<object>()
+ .AS("MES_ORDER_STA")
+ .SetColumns("END_TIME", finishTime)
+ .Where($"ORDER_NO = '{womdaaAfter.Daa001}'")
+ .ExecuteCommand();
+ }
// 鎻掑叆鎶ュ伐璁板綍鍜屾潯鐮佽褰�
return Db.Insertable(mesReporting)
--
Gitblit v1.9.3