| | |
| | | task.S_B_STATE = WCSTask.GetStateStr(task.N_B_STATE); |
| | | task.T_START_TIME = DateTime.Now; |
| | | db.Updateable(task).UpdateColumns(it => new { it.N_B_STATE, it.S_B_STATE, it.T_START_TIME }).ExecuteCommand(); |
| | | |
| | | var wmstask = db.Queryable<WMSTask>().Where(s => s.S_CODE == task.S_OP_CODE).First(); |
| | | wmstask.N_B_STATE = 2; |
| | | wmstask.S_B_STATE = WCSTask.GetStateStr(wmstask.N_B_STATE); |
| | | wmstask.T_START_TIME = DateTime.Now; |
| | | db.Updateable(wmstask).UpdateColumns(it => new { it.N_B_STATE, it.S_B_STATE, it.T_START_TIME }).ExecuteCommand(); |
| | | } |
| | | |
| | | } |
| | | } |
| | | internal static void End(WCSTask task) { |
| | | LogHelper.Info($"修改状态 "); |
| | | var db = new SqlHelper<WCSTask>().GetInstance(); |
| | | if (task != null) { |
| | | task.N_B_STATE = 3; |
| | | task.S_B_STATE = WCSTask.GetStateStr(task.N_B_STATE); |
| | | task.T_END_TIME = DateTime.Now; |
| | | db.Updateable(task).UpdateColumns(it => new { it.N_B_STATE, it.S_B_STATE, it.T_END_TIME }).ExecuteCommand(); |
| | | LogHelper.Info($"修改状态为3 "); |
| | | var wmstask = db.Queryable<WMSTask>().Where(s => s.S_CODE == task.S_OP_CODE).First(); |
| | | wmstask.N_B_STATE = 3; |
| | | wmstask.S_B_STATE = WCSTask.GetStateStr(wmstask.N_B_STATE); |
| | | wmstask.T_END_TIME = DateTime.Now; |
| | | db.Updateable(wmstask).UpdateColumns(it => new { it.N_B_STATE, it.S_B_STATE, it.T_END_TIME }).ExecuteCommand(); |
| | | } |
| | | } |
| | | internal static void Fail(WCSTask task) { |
| | |
| | | //判断有没有取货完成,没有就变成失败。有取货完成默认完成了(跟据项目而定,有些项目人工拉走了也没有放到终点)。 |
| | | task.N_B_STATE = 5; |
| | | task.S_B_STATE = WCSTask.GetStateStr(task.N_B_STATE); |
| | | db.Updateable(task).UpdateColumns(it => new { it.N_B_STATE, it.S_B_STATE }).ExecuteCommand(); |
| | | task.T_END_TIME = DateTime.Now; |
| | | db.Updateable(task).UpdateColumns(it => new { it.N_B_STATE, it.S_B_STATE, it.T_END_TIME }).ExecuteCommand(); |
| | | |
| | | |
| | | var wmstask = db.Queryable<WMSTask>().Where(s => s.S_CODE == task.S_OP_CODE).First(); |
| | | wmstask.N_B_STATE = 5; |
| | | wmstask.S_B_STATE = WCSTask.GetStateStr(wmstask.N_B_STATE); |
| | | wmstask.T_END_TIME = DateTime.Now; |
| | | db.Updateable(wmstask).UpdateColumns(it => new { it.N_B_STATE, it.S_B_STATE, it.T_END_TIME }).ExecuteCommand(); |
| | | } |
| | | } |
| | | internal static bool CreateTask(WCSTask TN_Task) { |