| | |
| | | //BIZ_MES_WO_SN |
| | | db.Updateable<BIZ_MES_WO_SN>(user) |
| | | .SetColumns(q => q.STATUS == BIZ_MES_WO_SN.STATUSs.Offline.GetValue()) |
| | | .SetColumns(q => q.TRAY_SN == null).SetColumns(q => q.OUTER_SN == null) |
| | | .Where(q => q.WORK_ORDER == wo.ORDER_NO && wipIDs.Contains(q.WIP_ID)) |
| | | .ExecuteCommand(); |
| | | //MES_WIP_DATA & MES_WIP_HIS |
| | |
| | | foreach (var wipSN in wipList.Where(q => q.STATUS != MES_WIP_DATA.STATUSs.Offline.GetValue())) |
| | | { |
| | | wipSN.STATUS = MES_WIP_DATA.STATUSs.Offline.GetValue(); |
| | | wipSN.TRAY_SN = wipSN.INNER_SN = wipSN.CARTON_SN = wipSN.PALLET_SN = wipSN.SHIPPING_ORDER = null; |
| | | wipSN.FINISHED_FLAG = wipSN.HOLD_FLAG = "N"; |
| | | wipSN.UNBIND_FLAG = "Y"; |
| | | wipSN.NODE_ID = ""; |
| | | wipSN.NODE_NAME = "下线退库"; |