| | |
| | | ACT_VALUE_1 = CurPkg.IsFinished ? "Y" : "N", |
| | | ACT_VALUE_2 = CurPkg.ToJson(), |
| | | ACT_VALUE_3 = CurPkg.IsFinished ? LabelDic[CurPkg.Item.PKG_LEVEL].ToJson() : "", |
| | | ACT_VALUE_4 = "Customer", |
| | | ELAPSED_TIME = CurStep.GetElapsedTime().TotalMilliseconds.ToInt64(), |
| | | TRACE_INFO = $"产品条码[{string.Join(",", CurPosition.CurSN)}]包装完成", |
| | | }; |
| | |
| | | .SetColumns(q => q.ACT_VALUE_1 == (CurPkg.IsFinished ? "Y" : "N")) |
| | | .SetColumns(q => q.ACT_VALUE_2 == CurPkg.ToJson()) |
| | | .SetColumns(q => q.ACT_VALUE_3 == (CurPkg.IsFinished ? LabelDic[CurPkg.Item.PKG_LEVEL].ToJson() : "")) |
| | | .SetColumns(q => q.ACT_VALUE_4 == "Customer") |
| | | .Where(q => q.WORK_ORDER == wo && q.NODE_ID == nodeID && q.ACT_ID == actID && q.WIP_ID == _lastWipID) |
| | | .ExecuteCommand(); |
| | | var InStoreLabel = CurPkg.IsFinished ? CurPkg.InStoreLabel?.ToJson() : ""; |
| | | db.Updateable<MES_WIP_ACT>() |
| | | .SetColumns(q => q.ACT_VALUE_1 == (CurPkg.IsFinished ? "Y" : "N")) |
| | | .SetColumns(q => q.ACT_VALUE_2 == CurPkg.ToJson()) |
| | | .SetColumns(q => q.ACT_VALUE_3 == InStoreLabel) |
| | | .SetColumns(q => q.ACT_VALUE_4 == "InStroe") |
| | | .Where(q => q.WORK_ORDER == wo && q.NODE_ID == nodeID && q.ACT_ID == CurPkg.InStoreActID && q.WIP_ID == _lastWipID) |
| | | .ExecuteCommand(); |
| | | //包装信息保存到工单条码明细表 |
| | | db.Updateable<BIZ_MES_WO_SN>() |
| | | .SetColumns(q => q.TRAY_SN == CurPkg.Item.Package.SN) |