| | |
| | | itemCode = it.S_ITEM_CODE, |
| | | factoryCode = string.IsNullOrEmpty(it.S_OWNER) ? "" : it.S_OWNER, |
| | | stockCode = string.IsNullOrEmpty(it.S_ERP_WH_CODE) ? "" : it.S_ERP_WH_CODE, |
| | | qty = Convert.ToInt32(it.F_QTY), |
| | | qty = it.F_QTY, |
| | | vendorCode = string.IsNullOrEmpty(it.S_SUPPLIER_NO) ? "" : it.S_SUPPLIER_NO, |
| | | batchNo = string.IsNullOrEmpty(it.S_BATCH_NO) ? "" : it.S_BATCH_NO, |
| | | serialNo = string.IsNullOrEmpty(it.S_SERIAL_NO) ? "" : it.S_SERIAL_NO |
| | |
| | | var db = new SqlHelper<object>().GetInstance(); |
| | | task.T_MODIFY = DateTime.Now; |
| | | task.S_B_STATE = WMSTask.GetStateStr(task.N_B_STATE); |
| | | db.Updateable<WMSTask>(task).UpdateColumns(a => new { a.N_B_STATE, a.S_B_STATE, a.T_MODIFY }).ExecuteCommand(); |
| | | var res=db.Updateable<WMSTask>(task).UpdateColumns(a => new { a.N_B_STATE, a.S_B_STATE, a.T_MODIFY }).ExecuteCommand()>0; |
| | | LogHelper.Info($"修改作业状态 作业号{task.S_CODE} 作业状态{task.N_B_STATE} 修改结果{res}"); |
| | | } |
| | | |
| | | internal static bool UpdateTaskEnd(WMSTask a) |