去线边的，取消任务收到4后直接删除物料容器

杨张扬

4 天以前 7b3b60e8e01a1cf2fb97af695639b18210a160c0

 wms/WCSHelper.cs

@@ -187,15 +187,11 @@
            var db = new SqlHelper<TN_Task>().GetInstance();
            if (task != null)
            {
                if (task.N_B_STATE == 1)
                {
                    task.N_B_STATE = 2;
                    task.S_B_STATE = TN_Task.GetStateStr(task.N_B_STATE);
                    task.T_START_TIME = System.DateTime.Now;
                    task.S_EQ_NO = forklift_no;
                    db.Updateable(task).UpdateColumns(it => new { it.N_B_STATE, it.S_B_STATE, it.T_START_TIME, it.S_EQ_NO }).ExecuteCommand();
                }

                task.N_B_STATE = 2;
                task.S_B_STATE = TN_Task.GetStateStr(task.N_B_STATE);
                task.T_START_TIME = System.DateTime.Now;
                task.S_EQ_NO = forklift_no;
                db.Updateable(task).UpdateColumns(it => new { it.N_B_STATE, it.S_B_STATE, it.T_START_TIME, it.S_EQ_NO }).ExecuteCommand();
            }
        }
        internal static void End(TN_Task task) {
@@ -240,11 +236,12 @@
        public static void CancleTaskInfo(TN_Task tN_Task)
        {
            var HJ = Settings.Areas[1];
            var db = new SqlHelper<object>().GetInstance();
            if (tN_Task.S_END_AREA == HJ || tN_Task.S_TYPE.Contains("满托下线入库"))//终点是满托缓存库区
            {
                LogHelper.Info($"取消任务: {tN_Task.S_CODE} 终点是满托缓存库区: {tN_Task.S_END_AREA}");

                TaskProcess.OperateStatus(tN_Task, 7);//异常处理
                TaskProcess.CacheBitCancelUpdate(tN_Task);//异常处理
            }
            else if (tN_Task.S_START_AREA == HJ || tN_Task.S_TYPE.Contains("满托出库上线"))//起点是满托缓存库区
            {
@@ -259,12 +256,27 @@
                else
                {
                    WCSHelper.End(tN_Task);//任务状态改成结束
                    LocationHelper.BindingLoc(tN_Task.S_END_LOC, tN_Task.S_CNTR_CODE.Split(',').ToList());// 绑定终点容器货位

                    if (tN_Task.S_END_AREA != Settings.Areas[2])//不去线边的绑定终点
                    {
                        LocationHelper.BindingLoc(tN_Task.S_END_LOC, tN_Task.S_CNTR_CODE.Split(',').ToList());// 绑定终点容器货位
                    }
                    else//去线边的全部删除
                    {
                        db.Deleteable<TN_CG_Detail>().Where(it => it.S_CNTR_CODE == tN_Task.S_CNTR_CODE).ExecuteCommand();
                        db.Deleteable<TN_InventoryM>().Where(it => it.RFID == tN_Task.S_CNTR_CODE).ExecuteCommand();
                        db.Deleteable<TN_Loc_Container>().Where(it => it.S_CNTR_CODE == tN_Task.S_CNTR_CODE).ExecuteCommand();
                        db.Deleteable<TN_Container>().Where(it => it.S_CODE == tN_Task.S_CNTR_CODE).ExecuteCommand();
                    }

                    LogHelper.Info($"取消任务: {tN_Task.S_CODE} 取货完成，任务状态改成结束，绑定终点容器货位");
                }
                LocationHelper.UnLockLoc(tN_Task.S_END_LOC);
                LocationHelper.UnLockLoc(tN_Task.S_START_LOC);//解锁起点终点
                if (!WCSHelper.CheckActionRecordExist(tN_Task.S_CODE, 4))
                {
                    LocationHelper.UnLockLoc(tN_Task.S_START_LOC);//解锁起点终点
                }
               
            }
            else
            {
@@ -274,7 +286,7 @@
                {
                    WCSHelper.Fail(tN_Task);//任务状态改成错误

                    var db = new SqlHelper<object>().GetInstance();

                    var cginfo = db.Queryable<TN_CG_Detail>().First(a => a.S_CNTR_CODE == tN_Task.S_CNTR_CODE);
                    if (cginfo != null)
                    {
@@ -294,7 +306,10 @@
                    LogHelper.Info($"取消任务: {tN_Task.S_CODE} 未取货完成，任务状态改成结束，绑定终点容器货位");
                }
                LocationHelper.UnLockLoc(tN_Task.S_END_LOC);
                LocationHelper.UnLockLoc(tN_Task.S_START_LOC);//解锁起点终点
                if (!WCSHelper.CheckActionRecordExist(tN_Task.S_CODE, 4))
                {
                    LocationHelper.UnLockLoc(tN_Task.S_START_LOC);//解锁起点终点
                }
            }
        }
    }