From 88101e80a5c6525a73000efe75234f937c0c3e05 Mon Sep 17 00:00:00 2001
From: Rodney Chen <rodney.chen@hotmail.com>
Date: 星期二, 15 十月 2024 00:14:26 +0800
Subject: [PATCH] 优化包装数据保存逻辑
---
Tiger.Business.MES/Transaction/PackingNode.cs | 18 +++---------------
1 files changed, 3 insertions(+), 15 deletions(-)
diff --git a/Tiger.Business.MES/Transaction/PackingNode.cs b/Tiger.Business.MES/Transaction/PackingNode.cs
index c890d95..16cd8a8 100644
--- a/Tiger.Business.MES/Transaction/PackingNode.cs
+++ b/Tiger.Business.MES/Transaction/PackingNode.cs
@@ -649,6 +649,7 @@
wipSN.NODE_NAME = curNode.NODE_NAME;
wipSN.OPER_CODE = curNode.OPER_CODE;
wipSN.SEGMENT = curNode.SEGMENT;
+ wipSN.OPERATION_TIME = DateTime.Now;
}
var wipHiss = new List<MES_WIP_HIS>();
@@ -670,20 +671,13 @@
//浣跨敤缁熶竴鐨勪簨鍔B瀵硅薄
var db = GetCommitDB();
//鏁版嵁淇濆瓨閫昏緫
- db.Storageable(_woSns, UserCode).ExecuteCommand();
- db.Storageable(_wipSns, UserCode).ExecuteCommand();
+ db.Updateable(_woSns, UserCode).UpdateColumns(q =>new { q.UPDATE_TIME, q.UPDATE_USER, q.STATUS }).ExecuteCommand();
+ db.Updateable(_wipSns, UserCode).UpdateColumns(q => new { q.UPDATE_TIME, q.UPDATE_USER, q.STATUS, q.NODE_ID, q.NODE_NAME, q.OPER_CODE, q.SEGMENT, q.OPERATION_TIME }).ExecuteCommand();
db.Storageable(_wipHiss, UserCode).ExecuteCommand();
if (_pkgList.Any())
{
foreach (var pkg in _pkgList)
{
- ////鍖呰淇℃伅淇濆瓨鍒板湪鍒跺搧淇℃伅琛�
- //db.Updateable<MES_WIP_DATA>()
- // .SetColumns(q => q.TRAY_SN == curPkg.Item.Package.SN)
- // .SetColumns(q => q.INNER_SN == q.CARTON_SN)
- // .SetColumns(q => q.CARTON_SN == curPkg.Item.Package.SN)
- // .Where(q => q.WORK_ORDER == pkg.WORK_ORDER && q.ID == pkg.WIP_ID)
- // .ExecuteCommand();
//鍖呰淇℃伅淇濆瓨鍒扮敓浜ц繃绋嬭褰�
db.Updateable<MES_WIP_HIS>()
.SetColumns(q => q.TRAY_SN == curPkg.Item.Package.SN)
@@ -691,12 +685,6 @@
.SetColumns(q => q.CARTON_SN == curPkg.Item.Package.SN)
.Where(q => q.WORK_ORDER == pkg.WORK_ORDER && q.WIP_ID == pkg.WIP_ID && q.OPER_CODE == "EndNode")
.ExecuteCommand();
- ////鍖呰淇℃伅淇濆瓨鍒板伐鍗曟潯鐮佹槑缁嗚〃
- //db.Updateable<BIZ_MES_WO_SN>()
- // .SetColumns(q => q.TRAY_SN == curPkg.Item.Package.SN)
- // .SetColumns(q => q.OUTER_SN == curPkg.Item.Package.SN)
- // .Where(q => q.WORK_ORDER == pkg.WORK_ORDER && q.WIP_ID == pkg.WIP_ID)
- // .ExecuteCommand();
}
}
};
--
Gitblit v1.9.3