blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
czw
2025-06-23 e552f3366723d8a2392ca59e95e5d9589ad7a858 
 HH.WCS.QingXiNongfu/core/Monitor.cs


@@ -95,7 +95,7 @@


                        {


                            if (item.SQL_State != "完成")


                            {


                                ROW_LOCK(LocationHelper.GetLocList(x => x.S_AREA_CODE == item.start_area && x.N_ROW == srow).FirstOrDefault(), LocationHelper.GetLocList(x => x.S_AREA_CODE == item.end_area && x.N_ROW == erow).FirstOrDefault(), "", 0, string.IsNullOrEmpty(item.FROM_NO));


                                ROW_LOCK(LocationHelper.GetLocList(x => x.S_AREA_CODE == item.start_area && x.N_ROW == srow).FirstOrDefault(), LocationHelper.GetLocList(x => x.S_AREA_CODE == item.end_area && x.N_ROW == erow).FirstOrDefault(), "", 0, string.IsNullOrEmpty(item.FROM_NO), item.SQL_WorkNo);


                                WCSHelper.Do(db =>


                                {


                                    LogHelper.Info("移库工单数量完成" + item.SQL_WorkNo);


@@ -118,7 +118,7 @@


                        {


                            LogHelper.Info($"{item.Turn_Type}工单{item.SQL_WorkNo} 手动完成，处理解锁,");




                            ROW_LOCK(LocationHelper.GetLocList(x => x.S_AREA_CODE == item.start_area && x.N_ROW == srow).FirstOrDefault(), LocationHelper.GetLocList(x => x.S_AREA_CODE == item.end_area && x.N_ROW == erow).FirstOrDefault(), "", 0, string.IsNullOrEmpty(item.FROM_NO));


                            ROW_LOCK(LocationHelper.GetLocList(x => x.S_AREA_CODE == item.start_area && x.N_ROW == srow).FirstOrDefault(), LocationHelper.GetLocList(x => x.S_AREA_CODE == item.end_area && x.N_ROW == erow).FirstOrDefault(), "", 0, string.IsNullOrEmpty(item.FROM_NO), item.SQL_WorkNo);


                            WCSHelper.Do(db =>


                            {


                                if (item.Turn_Type == "自动移库")


@@ -178,7 +178,7 @@


                            {


                                //LocationHelper.SetRowLock(new RowLock { S_AREA_CODE = item.start_row, N_ROW = srow }, 0);


                                //LocationHelper.SetRowLock(new RowLock { S_AREA_CODE = item.end_row, N_ROW = erow }, 0);


                                ROW_LOCK(LocationHelper.GetLocList(x => x.S_AREA_CODE == item.start_area && x.N_ROW == srow).FirstOrDefault(), LocationHelper.GetLocList(x => x.S_AREA_CODE == item.end_area && x.N_ROW == erow).FirstOrDefault(), "", 0, string.IsNullOrEmpty(item.FROM_NO));


                                ROW_LOCK(LocationHelper.GetLocList(x => x.S_AREA_CODE == item.start_area && x.N_ROW == srow).FirstOrDefault(), LocationHelper.GetLocList(x => x.S_AREA_CODE == item.end_area && x.N_ROW == erow).FirstOrDefault(), "", 0, string.IsNullOrEmpty(item.FROM_NO), item.SQL_WorkNo);




                                LogHelper.Info($"{item.Turn_Type}工单,完成" + item.SQL_WorkNo + "起排无货 或 终排已满 无法移库");


                                item.SQL_State = "完成";


@@ -302,7 +302,7 @@


                        {


                            //LocationHelper.SetRowLock(new RowLock { S_AREA_CODE = item.start_row, N_ROW = srow }, 0);


                            //LocationHelper.SetRowLock(new RowLock { S_AREA_CODE = item.end_row, N_ROW = erow }, 0);


                            ROW_LOCK(LocationHelper.GetLocList(x => x.S_AREA_CODE == item.start_area && x.N_ROW == srow).FirstOrDefault(), LocationHelper.GetLocList(x => x.S_AREA_CODE == item.end_area && x.N_ROW == erow).FirstOrDefault(), "", 0, string.IsNullOrEmpty(item.FROM_NO));


                            ROW_LOCK(LocationHelper.GetLocList(x => x.S_AREA_CODE == item.start_area && x.N_ROW == srow).FirstOrDefault(), LocationHelper.GetLocList(x => x.S_AREA_CODE == item.end_area && x.N_ROW == erow).FirstOrDefault(), "", 0, string.IsNullOrEmpty(item.FROM_NO), item.SQL_WorkNo);


                            LogHelper.Info($"{item.Turn_Type}工单,完成" + item.SQL_WorkNo + "起点已经没有货了，移库完成");


                            item.SQL_State = "完成";


                            item.Note = "起点已经没有货了，移库完成";


@@ -321,7 +321,7 @@


                        {


                            //LocationHelper.SetRowLock(new RowLock { S_AREA_CODE = item.start_row, N_ROW = srow }, 0);


                            //LocationHelper.SetRowLock(new RowLock { S_AREA_CODE = item.end_row, N_ROW = erow }, 0);


                            ROW_LOCK(LocationHelper.GetLocList(x => x.S_AREA_CODE == item.start_area && x.N_ROW == srow).FirstOrDefault(), LocationHelper.GetLocList(x => x.S_AREA_CODE == item.end_area && x.N_ROW == erow).FirstOrDefault(), "", 0, string.IsNullOrEmpty(item.FROM_NO));


                            ROW_LOCK(LocationHelper.GetLocList(x => x.S_AREA_CODE == item.start_area && x.N_ROW == srow).FirstOrDefault(), LocationHelper.GetLocList(x => x.S_AREA_CODE == item.end_area && x.N_ROW == erow).FirstOrDefault(), "", 0, string.IsNullOrEmpty(item.FROM_NO), item.SQL_WorkNo);


                            LogHelper.Info($"{item.Turn_Type}工单,完成" + item.SQL_WorkNo + "终点满了，移库完成");


                            item.SQL_State = "完成";


                            item.Note = "终点满了，移库完成";


@@ -418,11 +418,26 @@


            }


        }




        static void ROW_LOCK(Location startBit, Location EndBit, string msg, int sign, bool up = true)


        static void ROW_LOCK(Location startBit, Location EndBit, string msg, int sign, bool up = true, string WorkNo = "")


        {


            LogHelper.Info("dooooooooooooooooooooooooooooooooooooooooooooo" + msg + "---" + sign);


            LogHelper.Info("移库解锁 doo" + msg + "---" + sign + "--" + WorkNo);


            LogHelper.Info(JsonConvert.SerializeObject(startBit));


            LogHelper.Info(JsonConvert.SerializeObject(EndBit));


            bool j解锁起点库区排 = true;


            if (!string.IsNullOrEmpty(WorkNo) && sign == 0)


            {


                //解锁时，有工单号。  查查除了这个工单号以外的其他 指定出库排执行


                var orders = WCSHelper.GetWorkOrder2();


                var thisOrder = orders.Find(x => x.SQL_WorkNo == WorkNo);


                LogHelper.Info("移库解锁 --当前工单 sid:" + thisOrder?.S_ID);


                if (thisOrder != null)


                {


                    var other = orders.Find(x => x.SQL_WorkNo != WorkNo && x.start_area == thisOrder.start_area && x.start_row == thisOrder.start_row);


                    LogHelper.Info($"移库解锁 --其他工单 x.start_area == {thisOrder.start_area} start_row == {thisOrder.start_row} SID:" + other?.S_ID);


                    if (other != null)


                        j解锁起点库区排 = false;


                }


            }


            //if (sign == 1)


            //{


            //    if (LocationHelper.GetRowLock(x => x.S_AREA_CODE == startBit.S_AREA_CODE && x.N_ROW == startBit.N_ROW).Count > 0)


@@ -430,7 +445,8 @@


            //        return;


            //    }


            //}


            LocationHelper.SetRowLock(new RowLock { S_AREA_CODE = startBit.S_AREA_CODE, N_ROW = startBit.N_ROW, S_LOCK_STATE = msg }, sign);


            if (j解锁起点库区排)


                LocationHelper.SetRowLock(new RowLock { S_AREA_CODE = startBit.S_AREA_CODE, N_ROW = startBit.N_ROW, S_LOCK_STATE = msg }, sign);


            LocationHelper.SetRowLock(new RowLock { S_AREA_CODE = EndBit.S_AREA_CODE, N_ROW = EndBit.N_ROW, S_LOCK_STATE = msg }, sign);


            //if (EndBit == null || EndBit.S_AREA_CODE.StartsWith("BHQ-"))


            //    return;


@@ -439,9 +455,12 @@


                {


                    case 0:


                        {


                            var lst = new List<string> { startBit.S_Fule_LOC, EndBit.S_Fule_LOC };


                            if (!j解锁起点库区排)


                                lst = new List<string> { EndBit.S_Fule_LOC };


                            var req = JsonConvert.SerializeObject(new


                            {


                                areaNum = new List<string> { startBit.S_Fule_LOC, EndBit.S_Fule_LOC },


                                areaNum = lst,


                                repoNo = Settings.repoNo,


                                areaLock = "2"


                            });


@@ -1009,7 +1028,7 @@


        static bool InworkLock = false;


        /// <summary>


        /// 原材料 检测各流转位置。  写入托盘货位s_type 中 下一个目的地。就开始中转。


        /// 原物料纸箱，入库堆叠区转运


        /// 原物料纸箱，入库堆叠区转运 YWLRGDD--人工堆叠区


        /// </summary>


        internal static void BottTask()


        {


@@ -1017,9 +1036,9 @@


            var usingSpace = new List<string> { "入库接驳区", "库内接驳区", "出库接驳区", "提升机退料口" };


            //usingSpace = new List<string> { "YWLRGDD", "YWLWJJB", "YWLYLTKQ", "YWLTKKTQ", "YWLKTDDQ", "YWLT1TSJ", "YWLT1TSJCD", "YWLT2TSJ", "YWLT2TSJCD" };


            usingSpace = new List<string> { "YWLYLTKQ", "YWLTKKTQ", "YWLWJJB", "YWLRGDD", "YWLT1TSJ", "YWLT2TSJ" };


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


            ///----------------------------退余料中间库区，退空中间库区，


            ///   /*托盘货位表的 S_TYPE。  库区1,库区,*/




            foreach (var area in usingSpace)


            {


                try


@@ -1104,7 +1123,7 @@


                                        var arloclist = LocationHelper.GetAreaNormalLocList(EdnRarea);// LocationHelper.GetList<Location>(x => x.S_AREA_CODE == _clrel0.S_TYPE && x.S_LOCK_STATE != "报废");


                                        if (arloclist.Any())


                                        {


                                            if (EdnRarea == "YWLWJJB")


                                            if (EdnRarea == "YWLWJJB")//纸箱无菌接驳区


                                            //    InworkLock = true;


                                            //else InworkLock = false;


                                            //if (od.S_ZZ_AREA == "YWLWJJB")


@@ -1118,14 +1137,43 @@


                                            Location endbit = null;


                                            //foreach (var rss in arloclist.GroupBy(x => x.N_ROW).OrderByDescending(x => x.Count(y => y.N_CURRENT_NUM > 0)).ThenBy(xx => xx.Key))


                                            RowLock inlock = null;


                                            List<RowLock> inlockLis = new List<RowLock>();


                                            bool isCd = false;


                                            if (CDlist.Contains(EdnRarea))


                                            {


                                                isCd = true;


                                                inlock = LocationHelper.GetList<RowLock>(x => x.S_AREA_CODE == EdnRarea && x.S_LOCK_SRC == cir1.S_ITEM_CODE + cir1.S_ITEM_NAME + cir1.S_CJ_NAME && x.S_LOCK_STATE == "入库锁").FirstOrDefault();


                                                inlockLis = LocationHelper.GetList<RowLock>(x => x.S_AREA_CODE == EdnRarea && x.S_LOCK_SRC == cir1.S_ITEM_CODE + cir1.S_ITEM_NAME + cir1.S_CJ_NAME && x.S_LOCK_STATE == "入库锁").ToList();


                                                inlock = inlockLis.FirstOrDefault();


                                                if (inlock != null)


                                                {


                                                    arloclist = arloclist.FindAll(x => x.N_ROW == inlock.N_ROW).ToList();


                                                    //当入库的任务能放满一排并且还有余的时候 开第二排


                                                    //先判断起点有多少相同的 能入的物料


                                                    if (_cl.S_AREA_CODE == "YWLRGDD")//判断起点是否是人工堆叠区


                                                    {


                                                        //然后判断人工堆叠区需要入库多少托同品种物料 startMum


                                                        //货位 托盘 物料表联查


                                                        LogHelper.Info($"查起点有多少同品种的物料 开始");


                                                        var ca = Expressionable.Create<Location, LocCntrRel, CntrItemRel>();


                                                        ca.And((o, p, t) => o.N_CURRENT_NUM > 0 && o.S_LOCK_STATE == "无" && t.S_ITEM_CODE == cir1.S_ITEM_CODE && t.S_ITEM_NAME == cir1.S_ITEM_NAME && t.S_CJ_NAME == cir1.S_CJ_NAME && o.S_AREA_CODE == "YWLRGDD" && p.S_TYPE == _clrel0.S_TYPE);


                                                        var lstCanOutL = dbll.Queryable<Location>().InnerJoin<LocCntrRel>((o, p) => o.S_LOC_CODE == p.S_LOC_CODE).InnerJoin<CntrItemRel>((o, p, t) => p.S_CNTR_CODE == t.S_CNTR_CODE).Where(ca.ToExpression()).Includes(e => e.LocCntrRel, p => p.CntrItemRel).ToList();


                                                        LogHelper.Info($"起点要入CD的有多少托盘数量为{lstCanOutL.Count()}");


                                                        //判断终点排能入多少  少于入库托盘数则多开一排 EndMum 


                                                        var EndMum = dbll.Queryable<Location>().Where(l => l.S_AREA_CODE == EdnRarea && l.N_CURRENT_NUM == 0 && l.S_LOCK_STATE == "无" && inlockLis.Select(e => e.N_ROW).ToList().Contains(l.N_ROW)).ToList();


                                                        if (lstCanOutL.Count <= EndMum.Count())


                                                        {


                                                            arloclist = arloclist.FindAll(x => inlockLis.Select(e => e.N_ROW).ToList().Contains(x.N_ROW)).ToList();


                                                        }


                                                        else


                                                        {


                                                            arloclist = arloclist.FindAll(x => !inlockLis.Select(e => e.N_ROW).ToList().Contains(x.N_ROW)).ToList();


                                                            inlock = null;


                                                        }


                                                        LogHelper.Info($"查起点有多少同品种的物料 结束");


                                                    }


                                                    else


                                                    {


                                                        arloclist = arloclist.FindAll(x => x.N_ROW == inlock.N_ROW).ToList();


                                                    }


                                                }


                                            }


                                            foreach (var rss in arloclist.GroupBy(x => x.N_ROW).OrderByDescending(x => x.Count(y => y.N_CURRENT_NUM > 0)).ThenBy(x => x.Key))


@@ -1308,7 +1356,7 @@


            {


                try


                {


                    var yuworders = LocationHelper.GetList<YWLWorkOrder>(x => x.SQL_PLineNo == "无菌标签出库" && x.WorkType == 6 && x.SQL_State == "执行中").FindAll(x => x.OutNum > 0 && DateTime.Now.Subtract(x.SQL_Modify_TIme ?? DateTime.Now).TotalSeconds > 10).OrderBy(x => !string.IsNullOrEmpty(x.TagOver) ? 1 : 2).ThenBy(x => x.TagOverTime).ToList();


                    var yuworders = LocationHelper.GetList<YWLWorkOrder>(x => x.SQL_PLineNo == "无菌标签出库" && x.WorkType == 6 && x.SQL_State == "执行中").FindAll(x => x.OutNum > 0 && DateTime.Now.Subtract(x.SQL_Modify_TIme ?? DateTime.Now).TotalSeconds > 10).OrderBy(x => x.TagOverTime).ToList();


                    if (!yuworders.Any())


                    {


                        YwlBQ_CreInwork(locsFirst, WJ_BQ.RK_BQDDQ, WJ_BQ.RK_BBHJQ);


@@ -1316,7 +1364,7 @@


                    else


                    {


                        LogHelper.Info($" 无菌出库  工单开启中 ");


                       // 标签出库。货架直接出到线边


                        // 标签出库。货架直接出到线边


                        YwlBQ_CreWJOutOrder();


                    }




@@ -1335,7 +1383,7 @@


                try


                {


                    string pline = "T2提升机-标签";


                    var Syuworders = LocationHelper.GetList<YWLWorkOrder>(x => x.SQL_PLineNo == pline && x.WorkType == 6 && x.SQL_State == "执行中").FindAll(x => DateTime.Now.Subtract(x.SQL_Modify_TIme ?? DateTime.Now).TotalSeconds > 10).OrderBy(x => !string.IsNullOrEmpty(x.TagOver) ? 1 : 2).ThenBy(x => x.TagOverTime).ToList();


                    var Syuworders = LocationHelper.GetList<YWLWorkOrder>(x => x.SQL_PLineNo == pline && x.WorkType == 6 && x.SQL_State == "执行中").FindAll(x => DateTime.Now.Subtract(x.SQL_Modify_TIme ?? DateTime.Now).TotalSeconds > 10).OrderBy(x => x.TagOverTime).ToList();


                    //yuworders = LocationHelper.GetList<YWLWorkOrder>(x => x.SQL_PLineNo == plc.deviceName && x.WorkType == 6 && x.SQL_State == "执行中").FindAll(x => DateTime.Now.Subtract(x.SQL_Modify_TIme ?? DateTime.Now).TotalSeconds > 10).OrderBy(x => !string.IsNullOrEmpty(x.TagOver) ? 1 : 2).ThenBy(x => x.TagOverTime).ToList();




                    var tklist = LocationHelper.GetList<YWLWorkOrder>(x => x.SQL_PLineNo == pline && x.WorkType == 1 && x.SQL_State == "执行中");


@@ -1496,7 +1544,7 @@


                    //YwlPETKOutOrder("YWLTKMKQ", "", "PE叉运");// PE小出库


                    {


                        LogHelper.Info("-收缩膜  出库！");


                        var yuworders = LocationHelper.GetList<YWLWorkOrder>(x => x.SQL_PLineNo == "T2提升机-收缩膜" && x.WorkType == 6 && x.SQL_State == "执行中").FindAll(x => x.OutNum > 0 && DateTime.Now.Subtract(x.SQL_Modify_TIme ?? DateTime.Now).TotalSeconds > 10).OrderBy(x => !string.IsNullOrEmpty(x.TagOver) ? 1 : 2).ThenBy(x => x.TagOverTime).ToList();


                        var yuworders = LocationHelper.GetList<YWLWorkOrder>(x => x.SQL_PLineNo == "T2提升机-收缩膜" && x.WorkType == 6 && x.SQL_State == "执行中").FindAll(x => x.OutNum > 0 && DateTime.Now.Subtract(x.SQL_Modify_TIme ?? DateTime.Now).TotalSeconds > 10).OrderBy(x => x.TagOverTime).ToList();


                        if (!yuworders.Any())


                        {


                            LogHelper.Info("-收缩膜  出库！没有出库单。");


@@ -2179,6 +2227,7 @@


                    //LogHelper.Info($"{plc.deviceName}-标签{tagLoc.S_LOC_CODE}//{DeviceProcess.doorStatus[ploc]?.info}-----{(!string.IsNullOrEmpty(ploc) && plc != null && DeviceProcess.doorStatus[ploc]?.info == "1")}");


                    if (tagLoc != null)


                    {


                        // 这里都是1层的，所以必走  current_num =1


                        if (tagLoc.N_LAYER == 1 || tagLoc.N_CURRENT_NUM == 1)


                        {


                            // 直接出提升机位


@@ -2610,7 +2659,7 @@


            }




            ///第一段：出库 -到拆垛或者 接驳。


            var yuworders = LocationHelper.GetList<YWLWorkOrder>(x => x.SQL_PLineNo == "无菌标签出库" && x.WorkType == 6 && x.SQL_State == "执行中").FindAll(x => x.OutNum > 0 && DateTime.Now.Subtract(x.SQL_Modify_TIme ?? DateTime.Now).TotalSeconds > 10).OrderBy(x => !string.IsNullOrEmpty(x.TagOver) ? 1 : 2).ThenBy(x => x.TagOverTime).ToList();


            var yuworders = LocationHelper.GetList<YWLWorkOrder>(x => x.SQL_PLineNo == "无菌标签出库" && x.WorkType == 6 && x.SQL_State == "执行中").FindAll(x => x.OutNum > 0 && DateTime.Now.Subtract(x.SQL_Modify_TIme ?? DateTime.Now).TotalSeconds > 10).OrderBy(x => x.TagOverTime).ToList();




        //foreach (var order in yuworders)


        retuse:


@@ -2624,6 +2673,7 @@


                    yuworders.Remove(order);


                    goto retuse;


                }




                var oto = new List<string>();


                //if (!string.IsNullOrEmpty(order.TagOver))


                //    oto = order.TagOver.Split(',').ToList();


@@ -3556,7 +3606,10 @@




            public string area { get; set; }




            public string Row { get; set; }


            /// <summary>


            /// 排


            /// </summary>


            public int Row { get; set; }




        }


        /// <summary>


@@ -3564,7 +3617,59 @@


        /// </summary>


        public static void AutoRun13TSJ()


        {


            var list = new List<string>() { "YWLAQWJ", "YWLBQWJ", "YWLCQSX", "YWLDQWJ" };


            Action<YWLWorkOrder> _sAB没物料或者余量不足开始触发跟根据自动转运_名字越长越好 = (od) =>


            {


                LogHelper.Info($"AutoRun13TSJ{od.SQL_WorkNo}对应工单的{od.S_ROW} 物料数量不足。触发转运。");


                // 先看是否有到该库区的转运任务。 


                var zxs = LocationHelper.GetList<YWLZXtake>(X => X.S_ZX_STATE == "执行" && X.S_END_AREA == od.S_ROW);


                //1.查看物料是否匹配。


                var itemTRUN = zxs.Any(x => x.S_ITEM_CODE == od.SQL_ItemCode && x.S_ITEM_NAME == od.SQL_ItemName && x.S_CJ_NAME == od.S_CJ_NAME);


                if (itemTRUN)


                {  //有到该库区的 物料转运任务了。 不需要继续了 。




                    LogHelper.Info($"AutoRun13TSJ{od.SQL_WorkNo}已经存在转运了无需触发转运。");


                    return;


                }


                //人工转运没指定物料，我会自动写回转运单 物料数据。




                //找CD 区 哪里有这个物料。 


                Dictitems TrunStart = null;


                foreach (var area in CDlist)


                {


                    if (dsi.TryGetValue(area, out var dictitems1))


                    {


                        var arearowsloc = LocationHelper.GetAreaNormalLocList(area);


                        foreach (var d in dictitems1.FindAll(x => x.ItemCode == od.SQL_ItemCode && x.ItemName == od.SQL_ItemName && x.S_CJ_NAME == od.S_CJ_NAME))


                        {


                            if (arearowsloc.Exists(x => x.N_ROW == d.Row))


                            {


                                TrunStart = d;


                                break;


                            }


                        }


                    }


                }




                LogHelper.Info($"AutoRun13TSJ{od.SQL_WorkNo}触发转运。转运来源是{JsonConvert.SerializeObject(TrunStart)}");


                if (TrunStart != null)


                    WCSHelper.Do(db =>


                    {


                        db.Insertable(new YWLZXtake


                        {


                            S_START_AREA = TrunStart.area,


                            N_START_ROW = TrunStart.Row,


                            S_END_AREA = od.S_ROW,


                            S_ZX_STATE = "执行",


                            S_ITEM_CODE = od.SQL_ItemCode,


                            S_ITEM_NAME = od.SQL_ItemName,


                            S_CJ_NAME = od.S_CJ_NAME,


                            S_ZZ_AREA = (od.S_ROW == "YWLAQWJ" ? "YWLWJJB" : od.S_ROW)


                        }).ExecuteCommand();


                    });


            };




            //var TaskSiggg = Settings.GetTimeStamp();


            //var list = new List<string>() { "YWLAQWJ", "YWLBQWJ", "YWLCQSX", "YWLDQWJ" };


            //var WorkOrder = new List<YWLWorkOrder>();


            foreach (var PLC in Settings.GetDeviceInfoList().FindAll(X => X.deviceType == 13 && X.enable == 1))


            {


@@ -3619,13 +3724,17 @@


                    foreach (var od in orkOrd.OrderBy(x => x.TagOverTime).ThenBy(x => x.OutNum))


                    //foreach (var od in od2.ToList())


                    {


                        var l2 = new List<string>() { "YWLAQWJ", "YWLBQWJ", "YWLCQSX", "YWLDQWJ" };


                        var l2 = new List<string>() { "YWLAQWJ", "YWLBQWJ" };//, "YWLCQSX", "YWLDQWJ" };


                        l2.Remove(od.S_ROW);


                        var odsr = new List<string> { od.S_ROW }.Concat(l2).Distinct().ToList();


                        l2.Remove(od.TagOver);


                        var odsr = new List<string> { od.TagOver, od.S_ROW }.Concat(l2).Distinct().ToList();




                        ///汇总仓库里最大层是几层。


                        Dictitems Lart = null;


                        foreach (var area in odsr)//od.S_ROW.Split('$'))


                        {


                            if (string.IsNullOrEmpty(area)) continue;




                            if (dsi.TryGetValue(area, out var dictitems1))


                            {


                                foreach (var d in dictitems1.FindAll(x => x.ItemCode == od.SQL_ItemCode && x.ItemName == od.SQL_ItemName && x.S_CJ_NAME == od.S_CJ_NAME))


@@ -3638,13 +3747,14 @@


                                            Lart = d;


                                    }


                                }




                            }


                        }




                        //等下要检测，如果没有可用排，或者AB库区内物料数<5 就要从CD 开始转运。


                        var autoTurn = false;


                        LogHelper.Info($"AutoRun13TSJ 筛选物料 库区排数据.  {od.SQL_PLineNo} >>{od.OutNum}> {JsonConvert.SerializeObject(Lart)}");


                        // 需要数量 >= 仓库最大数量。 就开始出库。


                        if (Lart != null)


                        {


                            if (od.OutNum >= Lart?.ItemLayer)


                            {


                                var v = new List<string>() { Lart.area };


@@ -3661,15 +3771,14 @@


                                        _clrel = LocationHelper.GetLocCntrRel(rl.S_LOC_CODE);


                                        //板型相同


                                        var _clrel0 = _clrel.OrderByDescending(xx => xx.T_CREATE).First();


                                        LogHelper.Info(rl.S_LOC_CODE + "识别托盘类型。" + JsonConvert.SerializeObject(_clrel0));


                                        LogHelper.Info("AutoRun13TSJ" + rl.S_LOC_CODE + "识别托盘类型。" + JsonConvert.SerializeObject(_clrel0));


                                        var _clcntitem = ContainerHelper.GetCntrItemRel(_clrel0.S_CNTR_CODE.Trim()).FirstOrDefault();


                                        LogHelper.Info(rl.S_LOC_CODE + "识别托盘上的物料信息。" + JsonConvert.SerializeObject(_clcntitem));


                                        LogHelper.Info("AutoRun13TSJ" + rl.S_LOC_CODE + "识别托盘上的物料信息。" + JsonConvert.SerializeObject(_clcntitem));


                                        if (_clcntitem != null)


                                        {


                                            LogHelper.Info("相互是否匹配 _clcntitem S_ITEM_CODE:" + _clcntitem.S_ITEM_CODE + " od" + od.SQL_ItemCode + " _clcntitem S_ITEM_NAME:" + _clcntitem.S_ITEM_NAME + "od: " + od.SQL_ItemName + " od.S_CJ_NAME:" + od.S_CJ_NAME);


                                            LogHelper.Info("AutoRun13TSJ" + "相互是否匹配 _clcntitem S_ITEM_CODE:" + _clcntitem.S_ITEM_CODE + " od" + od.SQL_ItemCode + " _clcntitem S_ITEM_NAME:" + _clcntitem.S_ITEM_NAME + "od: " + od.SQL_ItemName + " od.S_CJ_NAME:" + od.S_CJ_NAME + "结果:" + (_clcntitem.S_ITEM_CODE == od.SQL_ItemCode && _clcntitem.S_ITEM_NAME == od.SQL_ItemName && _clcntitem.S_CJ_NAME == od.S_CJ_NAME));


                                            if (_clcntitem.S_ITEM_CODE == od.SQL_ItemCode && _clcntitem.S_ITEM_NAME == od.SQL_ItemName && _clcntitem.S_CJ_NAME == od.S_CJ_NAME)


                                            {




                                                StartBit = rl;


                                                break;


                                            }


@@ -3680,18 +3789,40 @@


                                }


                                if (StartBit == null)


                                {


                                    LogHelper.Info($"{od.SQL_PLineNo} 出库 {Lart.area}区域没有物料可用起点");


                                    autoTurn = true;


                                    LogHelper.Info("AutoRun13TSJ" + $"{od.SQL_PLineNo} 出库 {Lart.area}区域没有物料可用起点");


                                    continue;


                                }


                                else


                                {


                                    //检测指定库区的物料排总数量


                                    if (dsi.TryGetValue(od.S_ROW, out var dictitems1))


                                    {


                                        var rows = dictitems1.Select(x => x.Row).Distinct();


                                        var loclist = LocationHelper.GetLocList(x => x.S_AREA_CODE == od.S_ROW && rows.Contains(x.N_ROW));


                                        var count = loclist.FindAll(x => x.N_CURRENT_NUM > 0 && x.S_LOCK_STATE == "无").Sum(x => x.N_CURRENT_NUM);


                                        LogHelper.Info("AutoRun13TSJ" + $"od.S_ROW 出库余量判断是否需要转运。-{count}< 5");


                                        if (count < 5)


                                        {


                                            autoTurn = true;


                                            _sAB没物料或者余量不足开始触发跟根据自动转运_名字越长越好(od);


                                        }


                                    }


                                }


                                Location Endbit = null;




                                var loc = LocationHelper.GetLoc(PLC.location[0]);


                                if (loc?.N_CURRENT_NUM == 0 && StartBit.N_CURRENT_NUM == 1 && DeviceProcess.doorStatus.ContainsKey(PLC.location[0]))


                                if (StartBit.N_CURRENT_NUM == 1)


                                {


                                    if (DeviceProcess.doorStatus[PLC.location[0]].info == "1")


                                    if (loc?.N_CURRENT_NUM == 0 && DeviceProcess.doorStatus.ContainsKey(PLC.location[0]))


                                    {


                                        Endbit = LocationHelper.GetLoc(PLC.location[0]);


                                        if (DeviceProcess.doorStatus[PLC.location[0]].info == "1")


                                        {


                                            Endbit = LocationHelper.GetLoc(PLC.location[0]);


                                        }


                                    }


                                    if (Endbit == null)


                                        break;


                                }


                                else


                                {


@@ -3702,7 +3833,7 @@


                                {


                                    var crs = _clrel.Select(x => x.S_CNTR_CODE).ToList();


                                    var jbbit = "";


                                    if (od.S_ROW == "YWLCQSX" || od.S_ROW == "YWLDQWJ")


                                    if (od.S_ROW == "YWLCQSX" || od.S_ROW == "YWLDQWJ" || Endbit.S_AREA_CODE == "YWLDQWJ" || Endbit.S_AREA_CODE == "YWLCQSX")


                                    {


                                        var locs1 = LocationHelper.GetList<Location>(x => x.S_AREA_CODE == "YWLWJJB" && x.S_LOCK_STATE != "报废" && x.S_LOCK_STATE == "无" && x.N_CURRENT_NUM == 0).ToList();


                                        if (locs1.Count() > 0)


@@ -3717,7 +3848,8 @@


                                    var b = false;


                                    if (!string.IsNullOrEmpty(jbbit))


                                        b = TaskProcess.CreateTransport(od.SQL_WorkNo, StartBit.S_LOC_CODE, jbbit, "原物料搬运-纸箱", crs, StartBit.N_CURRENT_NUM - crs.Count + 1, 1, crs.Count, PLC.taskPri, "", Endbit.S_LOC_CODE);


                                    else b = TaskProcess.CreateTransport(od.SQL_WorkNo, StartBit.S_LOC_CODE, Endbit.S_LOC_CODE, "原物料搬运-纸箱", crs, StartBit.N_CURRENT_NUM - crs.Count + 1, 1, crs.Count, PLC.taskPri);


                                    else


                                        b = TaskProcess.CreateTransport(od.SQL_WorkNo, StartBit.S_LOC_CODE, Endbit.S_LOC_CODE, "原物料搬运-纸箱", crs, StartBit.N_CURRENT_NUM - crs.Count + 1, 1, crs.Count, PLC.taskPri);


                                    if (b)


                                    {


                                        var r = new RowLock { S_LOCK_SRC = od.SQL_ItemCode, T_LOCK_TIME = DateTime.Now, S_LOCK_STATE = "出库锁", S_AREA_CODE = StartBit.S_AREA_CODE, N_ROW = StartBit.N_ROW };


@@ -3743,7 +3875,8 @@


                                        //}


                                        //else db.Insertable(r).ExecuteCommand();


                                        od.TagOverTime = DateTime.Now;


                                        db.Updateable(od).UpdateColumns(it => new { it.TagOverTime }).ExecuteCommand();


                                        od.TagOver = StartBit.S_AREA_CODE;


                                        db.Updateable(od).UpdateColumns(it => new { it.TagOverTime, it.TagOver }).ExecuteCommand();


                                        //break;


                                    }


                                }


@@ -3753,6 +3886,11 @@


                                    continue;


                                }


                            }


                        }


                        else


                        {


                            _sAB没物料或者余量不足开始触发跟根据自动转运_名字越长越好(od);


                        }


                    }


            }


        }


@@ -3804,14 +3942,14 @@


                    {


                        if (dsi.TryGetValue(area, out dictitems))


                        {


                            var ill = dictitems.Find(x => x.ItemCode == _clcntitem.S_ITEM_CODE && x.ItemName == _clcntitem.S_ITEM_NAME && _clcntitem.S_CJ_NAME == x.S_CJ_NAME);


                            var ill = dictitems.Find(x => x.Row == rl.N_ROW && x.ItemCode == _clcntitem.S_ITEM_CODE && x.ItemName == _clcntitem.S_ITEM_NAME && _clcntitem.S_CJ_NAME == x.S_CJ_NAME);


                            if (ill != null)


                            {


                                if (rl.N_CURRENT_NUM > ill.ItemLayer)


                                {


                                    ill.ItemLayer = rl.N_CURRENT_NUM;


                                    ill.area = area;


                                    ill.Row = $"{rl.S_LOC_CODE}";


                                    ill.Row = rl.N_ROW;


                                }


                                else continue;


                            }


@@ -3822,7 +3960,7 @@


                                ItemLayer = rl.N_CURRENT_NUM,


                                S_CJ_NAME = _clcntitem.S_CJ_NAME,


                                area = area,


                                Row = $"{rl.S_LOC_CODE}"


                                Row = rl.N_ROW


                            });


                            dsi[area] = dictitems;


                        }


@@ -3836,7 +3974,7 @@


                                ItemLayer = rl.N_CURRENT_NUM,


                                S_CJ_NAME = _clcntitem.S_CJ_NAME,


                                area = area,


                                Row = $"{rl.S_LOC_CODE}"


                                Row = rl.N_ROW


                            });


                            dsi.Add(area, dictitems);


                        }


@@ -3917,10 +4055,10 @@


                var locS = LocationHelper.GetAreaNormalLocList(ODs.Key);


                foreach (var od in ODs)


                {


                    LogHelper.Info($"from{od.S_START_AREA} mid:{od.S_ZZ_AREA} to{od.S_END_AREA} 开始 》》》");


                    if (string.IsNullOrEmpty(od.S_ZZ_AREA) || string.IsNullOrEmpty(od.S_END_AREA))


                    LogHelper.Info($"YWL_ZX_Turn from{od.S_START_AREA} mid:{od.S_ZZ_AREA} to{od.S_END_AREA} 开始 》》》");


                    if (string.IsNullOrEmpty(od.S_ZZ_AREA) && string.IsNullOrEmpty(od.S_END_AREA))


                    {


                        LogHelper.CError($"from{od.S_START_AREA} mid:{od.S_ZZ_AREA} to{od.S_END_AREA} 数据缺失。无法完成移库。");


                        LogHelper.CError($"YWL_ZX_Turn from{od.S_START_AREA} to{od.S_END_AREA} 数据缺失。无法完成移库。");


                        continue;


                    }


                    var rows = locS.FindAll(x => x.N_ROW == od.N_START_ROW);


@@ -3937,13 +4075,23 @@


                            var lastful = rows.FindAll(x => x.N_CURRENT_NUM > 0).OrderBy(x => x.N_COL).LastOrDefault();


                            if (lastful != null)


                            {


                                LogHelper.Info($"from{od.S_START_AREA} mid:{od.S_ZZ_AREA} to{od.S_END_AREA} 找到移库起点》{lastful.S_LOC_CODE}。");


                                LogHelper.Info($"YWL_ZX_Turn from{od.S_START_AREA}to{od.S_END_AREA} 找到移库起点》{lastful.S_LOC_CODE}。");


                                var crs = LocationHelper.GetLocCntrRel(lastful.S_LOC_CODE);


                                var cntritems = ContainerHelper.GetCntrItemRel(crs.FirstOrDefault()?.S_CNTR_CODE);


                                if (!cntritems.Any())


                                    continue;


                                LogHelper.Info($"from{od.S_START_AREA} mid:{od.S_ZZ_AREA} to{od.S_END_AREA} 找到移库起点》{lastful.S_LOC_CODE}。接驳是否被锁？：{InworkLock}");


                                LogHelper.Info($"YWL_ZX_Turn from{od.S_START_AREA}to{od.S_END_AREA} 找到移库起点》{lastful.S_LOC_CODE}。接驳是否被锁？：{InworkLock}");


                                var cir1 = cntritems.First();




                                if (!string.IsNullOrEmpty(od.S_ITEM_CODE))


                                {


                                    ///给移库单 写上转运的物料数据。


                                    od.S_ITEM_CODE = cir1.S_ITEM_CODE;


                                    od.S_ITEM_NAME = cir1.S_ITEM_NAME;


                                    od.S_CJ_NAME = cir1.S_CJ_NAME;


                                    WCSHelper.Do(db => db.Updateable(od).UpdateColumns(it => new { it.S_ITEM_NAME, it.S_ITEM_CODE, it.S_CJ_NAME }).ExecuteCommand());


                                }




                                if (od.S_ZZ_AREA == "YWLWJJB")


                                {


                                    if (InworkLock)


@@ -3973,11 +4121,11 @@


                                        Endbit = zzrloclist.Find(x => x.N_COL > (_cl2?.N_COL ?? 0));


                                    if (Endbit != null)


                                    {


                                        LogHelper.Info($"入中转区{od.S_ZZ_AREA}使用{Endbit.S_LOC_CODE}");


                                        LogHelper.Info($"入中转区{nextarea}使用{Endbit.S_LOC_CODE}");


                                        break;


                                    }


                                }


                                LogHelper.Info($"from{od.S_START_AREA} mid:{od.S_ZZ_AREA} to{od.S_END_AREA} 找到移库终点》{Endbit?.S_LOC_CODE}");


                                LogHelper.Info($"YWL_ZX_Turn from{od.S_START_AREA} mid:{od.S_ZZ_AREA} to{od.S_END_AREA} 找到移库终点》{Endbit?.S_LOC_CODE}");


                                if (Endbit != null)


                                {


                                    //生成接驳区任务，标记为终点库区。