| | |
| | | using HH.WCS.QingXigongchang.process; |
| | | using HH.WCS.QingXigongchang.dispatch; |
| | | using HH.WCS.QingXigongchang.util; |
| | | using Newtonsoft.Json; |
| | | using SqlSugar; |
| | |
| | | } |
| | | internal static void End(WMSTask task) |
| | | { |
| | | var db = new SqlHelper<WMSTask>().GetInstance(); |
| | | var db = new SqlHelper<object>().GetInstance(); |
| | | |
| | | |
| | | //plg 2025年6月13日 10:42:24 |
| | | if (task.S_END_LAREA == "YWLWJJB" && task.S_START_LAREA != "YWLRGDD" && !string.IsNullOrEmpty(task.S_TWO_END_LOC)) |
| | | if (task.S_END_LAREA == "YWLYLTKQ" || task.S_END_LAREA == "YWLTKKTQ") |
| | | { |
| | | var model = db.Queryable<Location>().Where(a => a.S_LOC_CODE == task.S_TWO_END_LOC).First(); |
| | | if (model != null) |
| | | //查询出库锁YWLWJJB |
| | | var ls = LocationHelper.GetList<Location>(x => x.S_AREA_CODE == "YWLWJJB" && x.S_LOCK_STATE == "出库锁"); |
| | | if (ls.Any()) |
| | | { |
| | | //先解锁终点 在锁定 |
| | | db.Ado.BeginTran(); |
| | | try |
| | | var tas = db.Queryable<WMSTask>().Where(a => a.S_START_LOC == ls.First().S_LOC_CODE).ToList().FirstOrDefault(); |
| | | if (tas.S_B_STATE == "已推送") |
| | | { |
| | | model.S_LOCK_STATE = "无"; |
| | | var res = db.Updateable(model).UpdateColumns(it => new { it.S_LOCK_STATE }).ExecuteCommand() > 0; |
| | | LogHelper.Info(task.S_TWO_END_LOC + "LockLoc:锁结果" + res); |
| | | db.Ado.CommitTran(); |
| | | NDC.ChangeParamPri(tas.S_TASK_NO, 70); |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | db.Ado.RollbackTran(); |
| | | LogHelper.Info("CreateTask 失败 " + ex.Message); |
| | | } |
| | | |
| | | LogHelper.Info(task.S_TWO_END_LOC + "二段任务 开始。 "); |
| | | var b = TaskProcess.CreateTransport(task.S_SRC_NO, task.S_END_LOC, task.S_TWO_END_LOC, "原物料搬运-纸箱", task.S_CNTRS.Split(',').ToList(), task.N_START_LAYER, 1, task.N_CNTR_COUNT, task.N_PRIORITY); |
| | | //if (b) |
| | | //{ |
| | | // if (task != null) |
| | | // { |
| | | // task.S_B_STATE = "完成"; |
| | | // task.T_END_TIME = DateTime.Now; |
| | | // db.Updateable(task).UpdateColumns(it => new { it.S_B_STATE, it.T_END_TIME }).ExecuteCommand(); |
| | | // } |
| | | //} |
| | | } |
| | | } |
| | | ////plg 2025年6月13日 10:42:24 |
| | | //if (task.S_END_LAREA == "YWLWJJB" && task.S_START_LAREA != "YWLRGDD" && !string.IsNullOrEmpty(task.S_TWO_END_LOC)) |
| | | //{ |
| | | // var model = db.Queryable<Location>().Where(a => a.S_LOC_CODE == task.S_TWO_END_LOC).First(); |
| | | // if (model != null) |
| | | // { |
| | | // //先解锁终点 在锁定 |
| | | // db.Ado.BeginTran(); |
| | | // try |
| | | // { |
| | | // model.S_LOCK_STATE = "无"; |
| | | // var res = db.Updateable(model).UpdateColumns(it => new { it.S_LOCK_STATE }).ExecuteCommand() > 0; |
| | | // LogHelper.Info(task.S_TWO_END_LOC + "LockLoc:锁结果" + res); |
| | | // db.Ado.CommitTran(); |
| | | // } |
| | | // catch (Exception ex) |
| | | // { |
| | | // db.Ado.RollbackTran(); |
| | | // LogHelper.Info("CreateTask 失败 " + ex.Message); |
| | | // } |
| | | |
| | | // LogHelper.Info(task.S_TWO_END_LOC + "二段任务 开始。 "); |
| | | // var b = TaskProcess.CreateTransport(task.S_SRC_NO, task.S_END_LOC, task.S_TWO_END_LOC, "原物料搬运-纸箱", task.S_CNTRS.Split(',').ToList(), task.N_START_LAYER, 1, task.N_CNTR_COUNT, task.N_PRIORITY); |
| | | // //if (b) |
| | | // //{ |
| | | // // if (task != null) |
| | | // // { |
| | | // // task.S_B_STATE = "完成"; |
| | | // // task.T_END_TIME = DateTime.Now; |
| | | // // db.Updateable(task).UpdateColumns(it => new { it.S_B_STATE, it.T_END_TIME }).ExecuteCommand(); |
| | | // // } |
| | | // //} |
| | | // } |
| | | //} |
| | | if (task != null) |
| | | { |
| | | task.S_B_STATE = "完成"; |