| | |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 起点出库锁(只能对无锁货位上锁) |
| | | /// </summary> |
| | | /// <param name="loc"></param> |
| | | /// <param name="lockSource"></param> |
| | | /// <returns></returns> |
| | | public static bool LockStartLoc(ref TN_Location loc, string lockSource = "") { |
| | | if (loc == null) { |
| | | LogHelper.Info($"起点出库锁:传入的货位参数为null"); |
| | | return false; |
| | | } |
| | | |
| | | if (loc.N_LOCK_STATE != 0 || loc.S_LOCK_STATE != "无") { |
| | | LogHelper.Info($"起点出库锁:货位当前已有锁({loc.N_LOCK_STATE},{loc.S_LOCK_STATE})"); |
| | | return false; |
| | | } |
| | | |
| | | if (loc != null && loc.N_LOCK_STATE == 0) { |
| | | loc.N_LOCK_STATE = 2; // 起点出库锁 |
| | | loc.S_LOCK_STATE = TN_Location.GetLockStateStr(2); // 起点出库锁 |
| | | loc.S_LOCK_OP = lockSource; |
| | | loc.T_MODIFY = System.DateTime.Now; |
| | | } |
| | | |
| | | return true; |
| | | } |
| | | |
| | | public static bool LockEndLoc(ref TN_Location loc, string lockSource = "") { |
| | | if (loc == null) { |
| | | LogHelper.Info($"终点入库锁:传入的货位参数为null"); |
| | | return false; |
| | | } |
| | | |
| | | if (loc.N_LOCK_STATE != 0 || loc.S_LOCK_STATE != "无") { |
| | | LogHelper.Info($"终点入库锁:货位当前已有锁({loc.N_LOCK_STATE},{loc.S_LOCK_STATE})"); |
| | | return false; |
| | | } |
| | | |
| | | if (loc != null && loc.N_LOCK_STATE == 0) { |
| | | loc.N_LOCK_STATE = 1; // 终点出库锁 |
| | | loc.S_LOCK_STATE = TN_Location.GetLockStateStr(1); // 终点出库锁 |
| | | loc.S_LOCK_OP = lockSource; |
| | | loc.T_MODIFY = System.DateTime.Now; |
| | | } |
| | | |
| | | return true; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 入库锁定终点,出库锁定起点 |
| | | /// </summary> |
| | | /// <remarks> |
| | | /// 创建任务锁定货位的时候,把锁的来源就是任务号也写上去(加锁的方法加个参数,可空的参数),解锁的时候把来源置空 |
| | | /// </remarks> |
| | | /// <param name="loc"></param> |
| | | /// <param name="lockState">1:入库锁、2:出库锁、3:其它锁</param> |
| | | /// <param name="lockSource">锁的来源=任务号</param> |
| | | /// <returns></returns> |
| | | private static bool LockLoc(string loc, int lockState, string lockSource = "") |
| | | { |
| | | var res = false; |
| | | var db = new SqlHelper<object>().GetInstance(); |
| | | var model = db.Queryable<TN_Location>().Where(a => a.S_CODE == loc).First(); |
| | | LogHelper.Info($"锁货位{loc},状态{lockState},信息" + JsonConvert.SerializeObject(model)); |
| | | if (model != null && model.N_LOCK_STATE == 0) |
| | | { |
| | | model.N_LOCK_STATE = lockState; |
| | | model.S_LOCK_STATE = TN_Location.GetLockStateStr(lockState); |
| | | model.S_LOCK_OP = lockSource; |
| | | model.T_MODIFY = System.DateTime.Now; |
| | | res = db.Updateable<TN_Location>(model).UpdateColumns(it => new { it.N_LOCK_STATE, it.S_LOCK_STATE, it.S_LOCK_OP, it.T_MODIFY }).ExecuteCommand() > 0; |
| | | } |
| | | LogHelper.Info($"锁货位{loc}返回{res}"); |
| | | |
| | | return res; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 取货完解锁起点,卸货完解锁终点,可检验锁的来源,也可以不校验 |
| | | /// </summary> |
| | | /// <param name="loc"></param> |