优化包装数据保存逻辑

Rodney Chen

2024-10-15 88101e80a5c6525a73000efe75234f937c0c3e05

 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 @@
                    //使用统一的事务DB对象
                    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();
                        }
                    }
                };