服务端的TigerApi 框架,基于.NET6 2024 版本
Ben Lin
2024-10-14 268c945b3c2bcaf75950531283fb9a89919b564e
Tiger.Business.MES/Transaction/PackingNode.cs
@@ -663,6 +663,7 @@
                var _woSns = woSNs.Clone();
                var _wipSns = CurWipSNs.Clone();
                var _wipHiss = wipHiss.Clone();
                var _pkgList = curPkg?.IsFinished == true ? GetPackageList(curPkg.Item) : new();
                //保存数据
                endAction = () =>
                {
@@ -672,6 +673,32 @@
                    db.Storageable(_woSns, UserCode).ExecuteCommand();
                    db.Storageable(_wipSns, UserCode).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)
                                .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.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();
                        }
                    }
                };
            }