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


@@ -850,7 +850,7 @@


                {


                    var locs = LocationHelper.GetList<Location>(x => x.S_AREA_CODE == item.S_AREA_CODE && x.N_ROW == item.N_ROW);


                    if (locs.Find(x => x.N_CURRENT_NUM > 0) == null)


                        LocationHelper.SetRowLock(item, 0);


                        WCSHelper.Do(db => db.Deleteable(item).ExecuteCommand());


                }


            }


            Rlock = Rlocks.FindAll(x => x.S_LOCK_STATE.Contains("入库锁"));


@@ -867,15 +867,15 @@


                    //            LocationHelper.SetRowLock(item, 0);


                    //}


                    //如果一排内无货。也无锁。  可能是物料的入库取消了。 取消当前排锁，防止后续不入这个物料了依然占着排。


                    if (locs.Find(x => x.N_CURRENT_NUM > 0) == null && locs.Find(x => x.S_LOCK_STATE != "无") == null) LocationHelper.SetRowLock(item, 0);


                    if (locs.Find(x => x.N_CURRENT_NUM > 0) == null && locs.Find(x => x.S_LOCK_STATE != "无") == null) WCSHelper.Do(db => db.Deleteable(item).ExecuteCommand());


                    else


                    {


                        var lastloC = locs.OrderByDescending(x => x.N_COL).FirstOrDefault();


                        if (lastloC.N_CURRENT_NUM == lastloC.N_CAPACITY) LocationHelper.SetRowLock(item, 0);


                        if (lastloC.N_CURRENT_NUM == lastloC.N_CAPACITY) WCSHelper.Do(db => db.Deleteable(item).ExecuteCommand());


                        else if (new List<string>() { "YWLAQWJ", "YWLBQWJ", "YWLCQSX", "YWLDQWJ" }.Contains(item.S_AREA_CODE)) WCSHelper.Do(db => db.Deleteable(item).ExecuteCommand());


                    }


                }


            }




        }




        /// <summary>


@@ -1009,16 +1009,17 @@


        static bool InworkLock = false;


        /// <summary>


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


        /// 2025.4.8


        /// 1.清溪原材料测试与成品拆分


        /// 2.进出口单据与CS异常处理


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


        /// </summary>


        internal static void BottTask()


        {


            //InworkLock = false;


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


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


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


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


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


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




            foreach (var area in usingSpace)


            {


                try


@@ -1120,7 +1121,7 @@


                                            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 && x.S_LOCK_STATE == "入库锁").FirstOrDefault();


                                                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();


                                                if (inlock != null)


                                                {


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


@@ -1146,7 +1147,7 @@


                                                    if (s_clrel0 != null && string.IsNullOrEmpty(s_clrel0.S_TYPE))


                                                    {


                                                        var cntrrel = ContainerHelper.GetCntrItemRel(rr_clrel.FirstOrDefault()?.S_CNTR_CODE).FirstOrDefault();


                                                        if (cntrrel.S_ITEM_CODE == cir1.S_ITEM_CODE && cntrrel.S_ITEM_NAME == cir1.S_ITEM_NAME)


                                                        if (cntrrel.S_ITEM_CODE == cir1.S_ITEM_CODE && cntrrel.S_ITEM_NAME == cir1.S_ITEM_NAME && cntrrel.S_CJ_NAME == cir1.S_CJ_NAME)


                                                        {


                                                            if (_cl2.N_CURRENT_NUM < _cl2.N_CAPACITY)


                                                                endbit = _cl2;


@@ -1166,7 +1167,7 @@


                                                    var cntrrel = ContainerHelper.GetCntrItemRel(rel.FirstOrDefault()?.S_CNTR_CODE).FirstOrDefault();


                                                    if (cntrrel == null)


                                                        continue;


                                                    if (cntrrel.S_ITEM_CODE == cir1.S_ITEM_CODE && cntrrel.S_ITEM_NAME == cir1.S_ITEM_NAME)


                                                    if (cntrrel.S_ITEM_CODE == cir1.S_ITEM_CODE && cntrrel.S_ITEM_NAME == cir1.S_ITEM_NAME && cntrrel.S_CJ_NAME == cir1.S_CJ_NAME)


                                                    {


                                                        LogHelper.Info($"入库库》使用{endbit.S_LOC_CODE}");


                                                    }


@@ -1191,7 +1192,7 @@


                                                LogHelper.Info($"{r.Key}原物料搬运 {sign} 任务 ，创建{res} ");


                                                if (res && inlock == null && isCd)


                                                {


                                                    var rrrr = new RowLock { S_LOCK_SRC = cir1.S_ITEM_CODE + cir1.S_ITEM_NAME, T_LOCK_TIME = DateTime.Now, S_LOCK_STATE = "入库锁", S_AREA_CODE = endbit.S_AREA_CODE, N_ROW = endbit.N_ROW };


                                                    var rrrr = new RowLock { S_LOCK_SRC = cir1.S_ITEM_CODE + cir1.S_ITEM_NAME + cir1.S_CJ_NAME, T_LOCK_TIME = DateTime.Now, S_LOCK_STATE = "入库锁", S_AREA_CODE = endbit.S_AREA_CODE, N_ROW = endbit.N_ROW };


                                                    WCSHelper.Do(db => db.Insertable(rrrr).ExecuteCommand());


                                                }


                                                if (EdnRarea == "YWLWJJB") InworkLock = false;


@@ -1259,6 +1260,9 @@


            public static string RK_BQCDQ = "SXBQDDKQ";




        }


        /// <summary>


        ///  提扣 。


        /// </summary>


        internal static void YwlTKPEBQ_Auto()


        {


            LogHelper.CoCo(DateTime.Now + "标签-提扣-PE膜->>>>>>>>>>>> ", ConsoleColor.Cyan);


@@ -1281,6 +1285,7 @@


                                           S_NOTE = cir.S_ITEM_CODE.Trim() + "&" + cir.S_ITEM_NAME.Trim(),


                                           S_ITEM_CODE = cir.S_ITEM_CODE,


                                           S_ITEM_NAME = cir.S_ITEM_NAME,


                                           S_CJ_NAME = cir.S_CJ_NAME,


                                           S_CNTR_CODE = cir.S_CNTR_CODE


                                       })


                                       .ToList();


@@ -1301,11 +1306,16 @@


            {


                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 => DateTime.Now.Subtract(x.SQL_Modify_TIme ?? DateTime.Now).TotalSeconds > 10).OrderBy(x => !string.IsNullOrEmpty(x.TagOver) ? 1 : 2).ThenBy(x => x.TagOverTime).ToList();


                    if (!yuworders.Any())


                    {


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


                    }


                    else


                    {


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


                        YwlBQ_CreWJOutOrder();


                    }


                    YwlBQ_CreWJTK();


                }


                catch (Exception ex)


@@ -1320,7 +1330,7 @@


                try


                {


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


                    var Syuworders = LocationHelper.GetList<YWLWorkOrder>(x => x.SQL_PLineNo == pline && 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 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();


                    //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 == "执行中");


@@ -1331,12 +1341,7 @@


                    if (tklist.Count() > 0)


                    {


                        var tk = tklist.FirstOrDefault();


                        var Cjsj = LocationHelper.GetList<CjTimeOrder>(x => tklist.Select(c => c.S_CJ_NAME).ToList().Contains(x.S_CJ_NAME) && tklist.Select(c => c.SQL_ItemCode).ToList().Contains(x.S_ITEM_CODE));


                        if (Cjsj.Count() > 0)


                        {


                            var Cj = Cjsj.OrderBy(e => e.T_CJ_TIME).ToList().FirstOrDefault();


                            tk = tklist.Find(e => e.S_CJ_NAME == Cj.S_CJ_NAME && e.SQL_ItemCode == Cj.S_ITEM_CODE);


                        }




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


                        if (loc.N_CURRENT_NUM > 0 && loc.S_LOCK_STATE == "无")


                        {


@@ -1361,7 +1366,7 @@


                    }


                    else if (Syuworders.Any())


                    {


                        YwlBQ_CreSXOutOrder(plc, Syuworders);


                        YwlBQ_CreSXOutOrder(plc, Syuworders.FindAll(x => x.OutNum > 0));


                    }


                }


                catch (Exception ex)


@@ -1387,23 +1392,17 @@


                try


                {


                    //return;






                    ///起点数据。  终点库区 堆叠层数。


                    YwlPETK_CreInwork(PElocsFirst, "YWLTKMKQ", "提扣叉运", 1);//提扣入库


                    YwlPETK_CreInwork(TKlocsFirst, "YWLTKMKQ", "收缩膜叉运"); // PE入库


                    YwlPETK_CreInwork(PElocsFirst, "YWLTKMKQ", "提扣叉运", 3);//提扣入库--PE膜


                    YwlPETK_CreInwork(TKlocsFirst, "YWLTKMKQ", "收缩膜叉运", 1); // PE入库 --提扣


                    //YwlPETKtkOrder("YWLZSXBKQ", "YWLTKMKQ", "收缩膜叉运");


                    //YwlPETKOutOrder("YWLTKMKQ", "YWLZSXBKQ", "收缩膜叉运");// PE中出库




                    var tklist = LocationHelper.GetList<YWLWorkOrder>(x => x.SQL_PLineNo == "T2提升机-收缩膜" && x.WorkType == 1 && x.SQL_State == "执行中");


                    if (tklist.Count() > 0)


                    {


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


                        var tk = tklist.FirstOrDefault();


                        var Cjsj = LocationHelper.GetList<CjTimeOrder>(x => tklist.Select(c => c.S_CJ_NAME).ToList().Contains(x.S_CJ_NAME) && tklist.Select(c => c.SQL_ItemCode).ToList().Contains(x.S_ITEM_CODE));


                        if (Cjsj.Count() > 0)


                        {


                            var Cj = Cjsj.OrderBy(e => e.T_CJ_TIME).ToList().FirstOrDefault();


                            tk = tklist.Find(e => e.S_CJ_NAME == Cj.S_CJ_NAME && e.SQL_ItemCode == Cj.S_ITEM_CODE);


                        }




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


                        if (loc.N_CURRENT_NUM > 0 && loc.S_LOCK_STATE == "无")


@@ -1440,6 +1439,15 @@


                                    {


                                        var srloclist = rs.OrderBy(x => x.N_COL).ToList();


                                        var lastfull = srloclist.FindAll(x => x.N_CURRENT_NUM > 0).LastOrDefault();


                                        if (lastfull != null)


                                        {


                                            var c = LocationHelper.GetList<LocCntrRel>(x => x.S_LOC_CODE == lastfull.S_LOC_CODE);


                                            var xcirs = ContainerHelper.GetCntrItemRel(c.FirstOrDefault().S_CNTR_CODE);


                                            if (!xcirs.Any()) continue;


                                            var xcir = xcirs.OrderByDescending(x => x.T_CREATE).FirstOrDefault();


                                            if (cir.S_ITEM_CODE != xcir.S_ITEM_CODE || cir.S_ITEM_NAME != xcir.S_ITEM_NAME || xcir.S_CJ_NAME != cir.S_CJ_NAME)


                                                continue;


                                        }


                                        EndBit = srloclist.Find(x => x.S_LOCK_STATE == "无" && x.N_CURRENT_NUM < Math.Min(x.N_CAPACITY, 3) && x.S_LOCK_STATE != "报废" && x.N_COL >= (lastfull?.N_COL ?? 0));


                                        if (EndBit != null)


                                            break;


@@ -1482,19 +1490,24 @@


                    else


                    //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();


                        if (!yuworders.Any()) return;


                        if (!yuworders.Any())


                        {


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


                            return;


                        }


                        var ploc = plc.location[0];


                    retuse:


                        var order = yuworders.FirstOrDefault();


                        if (yuworders.Count() > 0)


                        {


                            var Cjsj = LocationHelper.GetList<CjTimeOrder>(x => yuworders.Select(c => c.S_CJ_NAME).ToList().Contains(x.S_CJ_NAME) && yuworders.Select(c => c.SQL_ItemCode).ToList().Contains(x.S_ITEM_CODE));


                            if (Cjsj.Count() > 0)


                            {


                                var Cj = Cjsj.OrderBy(e => e.T_CJ_TIME).ToList().FirstOrDefault();


                                order = yuworders.Find(e => e.S_CJ_NAME == Cj.S_CJ_NAME && e.SQL_ItemCode == Cj.S_ITEM_CODE);


                            }


                            //var Cjsj = LocationHelper.GetList<CjTimeOrder>(x => yuworders.Select(c => c.S_CJ_NAME).ToList().Contains(x.S_CJ_NAME) && yuworders.Select(c => c.SQL_ItemCode).ToList().Contains(x.S_ITEM_CODE));


                            //if (Cjsj.Count() > 0)


                            //{


                            //    var Cj = Cjsj.OrderBy(e => e.T_CJ_TIME).ToList().FirstOrDefault();


                            //    order = yuworders.Find(e => e.S_CJ_NAME == Cj.S_CJ_NAME && e.SQL_ItemCode == Cj.S_ITEM_CODE);


                            //}


                        }


                        if (order != null)


                        {


@@ -1515,6 +1528,7 @@


                                LogHelper.CErrorLog("小水出库：" + (order.SQL_WorkNo) + "没有【指定物料；");


                                goto retuse;


                            }


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




                            string v = "YWLTKMKQ";


                            int ord = -1;


@@ -1541,15 +1555,18 @@


                                    var cirs = ContainerHelper.GetCntrItemRel(CNTR.FirstOrDefault().S_CNTR_CODE);


                                    if (!cirs.Any()) continue;


                                    cir = cirs.OrderByDescending(x => x.T_CREATE).FirstOrDefault();


                                    if (cir.S_ITEM_CODE == order.SQL_ItemCode && cir.S_ITEM_NAME == order.SQL_ItemName)


                                    LogHelper.Info($"收缩膜 出库！{item.Key}排 [{cir.S_ITEM_CODE}-{order.SQL_ItemCode}]   [{cir.S_ITEM_NAME}-{order.SQL_ItemName}]  [{cir.S_CJ_NAME}-{order.S_CJ_NAME}]  {(cir.S_ITEM_CODE == order.SQL_ItemCode && cir.S_ITEM_NAME == order.SQL_ItemName && cir.S_CJ_NAME == order.S_CJ_NAME)}");


                                    if (cir.S_ITEM_CODE == order.SQL_ItemCode && cir.S_ITEM_NAME == order.SQL_ItemName && cir.S_CJ_NAME == order.S_CJ_NAME)


                                    {


                                        //plg 2025年6月13日 09:08:10 


                                        Temp = new locCntItem


                                        {


                                            N_CURRENT_NUM = lastfull.N_CURRENT_NUM,


                                            S_CNTR_CODE = cir.S_CNTR_CODE,


                                            S_LOC_CODE = lastfull.S_LOC_CODE,


                                            HalfOrFull = (cir.N_BQ_TRAY_TYPE == .5 ? 1 : (cir.N_BQ_TRAY_TYPE == .75 ? 2 : 3)),


                                            S_NOTE = cir.S_ITEM_CODE.Trim() + "&" + cir.S_ITEM_NAME.Trim()


                                            S_NOTE = cir.S_ITEM_CODE.Trim() + "&" + cir.S_ITEM_NAME.Trim(),


                                            S_CJ_NAME = cir.S_CJ_NAME


                                        };


                                        if (outlock != null)


                                        {


@@ -1572,30 +1589,32 @@


                            if (StartBit != null)


                            {


                                var tagLoc = StartBit;


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


                                {


                                    // 直接出提升机位


                                    //var pc = Settings.GetDeviceInfoList().Where(a => a.deviceName == "水线标签提升机").FirstOrDefault();


                                // 直接出提升机位




                                    if (!string.IsNullOrEmpty(ploc) && plc != null && DeviceProcess.doorStatus[ploc]?.info == "1")


                                LogHelper.Info(order.SQL_PLineNo + $"-收缩膜出库！终点{ploc}-{DeviceProcess.doorStatus[ploc]?.info}");


                                if (!string.IsNullOrEmpty(ploc) && plc != null && DeviceProcess.doorStatus[ploc]?.info == "1")


                                {


                                    var loc = LocationHelper.GetLoc(ploc);


                                    LogHelper.Info(order.SQL_PLineNo + $"-收缩膜出库！终点{loc.N_CURRENT_NUM}-{loc.S_LOCK_STATE}");


                                    if (loc.N_CURRENT_NUM == 0 && loc.S_LOCK_STATE == "无")


                                    {


                                        var loc = LocationHelper.GetLoc(ploc);


                                        if (loc.N_CURRENT_NUM == 0 && loc.S_LOCK_STATE == "无")


                                        var re = TaskProcess.CreateTransport("", tagLoc.S_LOC_CODE.Trim(), loc.S_LOC_CODE, "收缩膜叉运-货架出提升机", new List<string> { tagLoc.S_CNTR_CODE }, StartBit.N_CURRENT_NUM, 1, 1, 62);


                                        LogHelper.CSucessLog($"from {tagLoc.S_LOC_CODE} to {loc.S_LOC_CODE} 收缩膜叉运-货架出提升机 ，创建{re} ");


                                        if (re)


                                        {


                                            var re = TaskProcess.CreateTransport("", tagLoc.S_LOC_CODE.Trim(), loc.S_LOC_CODE, "收缩膜叉运-货架出提升机", new List<string> { tagLoc.S_CNTR_CODE }, StartBit.N_CURRENT_NUM, 1, 1, 62);


                                            LogHelper.CSucessLog($"from {tagLoc.S_LOC_CODE} to {loc.S_LOC_CODE} 收缩膜叉运-货架出提升机 ，创建{re} ");


                                            if (re)


                                            oto.Add(oic);


                                            if (outlock == null)


                                            {


                                                oto.Add(oic);


                                                if (outlock == null)


                                                {


                                                    var r = new RowLock { S_LOCK_SRC = (StartBit.S_NOTE /*+ StartBit.HalfOrFull*/), T_LOCK_TIME = DateTime.Now, S_LOCK_STATE = "出库锁", S_AREA_CODE = StartBit.S_AREA_CODE, N_ROW = StartBit.N_ROW };


                                                    db.Insertable(r).ExecuteCommand();


                                                }


                                                var r = new RowLock { S_LOCK_SRC = (StartBit.S_NOTE /*+ StartBit.HalfOrFull*/), T_LOCK_TIME = DateTime.Now, S_LOCK_STATE = "出库锁", S_AREA_CODE = StartBit.S_AREA_CODE, N_ROW = StartBit.N_ROW };


                                                db.Insertable(r).ExecuteCommand();


                                            }


                                        }


                                    }


                                }


                            }


                            else


                            {


                                LogHelper.Info(order.SQL_PLineNo + "-收缩膜  出库！ 没有可用物料");


                            }




                            var set1 = new HashSet<string>(oto);


@@ -1721,7 +1740,7 @@


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


            var v = db.Queryable<Location>().


                LeftJoin<LocCntrRel>((l, c) => l.S_LOC_CODE == c.S_LOC_CODE)


                .Where((l, c) => (l.S_AREA_CODE == WJ_BQ.RK_XBKQ || l.S_AREA_CODE == WJ_BQ.RK_BQJBQ) && c.S_TYPE == BQ_PRA.B)


                .Where((l, c) => (l.S_AREA_CODE == WJ_BQ.RK_XBKQ /*|| l.S_AREA_CODE == WJ_BQ.RK_BQJBQ*/) && c.S_TYPE == BQ_PRA.B)


                .ToList();


            if (v.Any())


            {


@@ -1744,45 +1763,46 @@


                            {


                                var s_type = ContainerHelper.GetCntrItemRel(CNTR.FirstOrDefault().S_CNTR_CODE).FirstOrDefault()?.N_BQ_TRAY_TYPE ?? 0;


                                Location Endbit = null;


                                if (area == WJ_BQ.RK_BQJBQ)


                                if (area == area/* WJ_BQ.RK_BQJBQ*/)


                                {


                                    var hjs = LocationHelper.GetAreaNormalLocList(WJ_BQ.RK_BBHJQ, true, false);


                                    Endbit = hjs.FindAll(x => x.N_CURRENT_NUM == 0 && x.N_LAYER == (s_type == .5 ? 1 : (s_type == .75 ? 2 : 3))).OrderBy(x => x.N_ROW).ThenBy(x => x.N_COL).FirstOrDefault();


                                    if (Endbit != null)


                                    {


                                        var re = TaskProcess.CreateTransport("", lastfull.S_LOC_CODE.Trim(), Endbit.S_LOC_CODE, "标签叉运-接驳标签退库", CNTR.Select(x => x.S_CNTR_CODE).ToList(), 1, 1, 1, 62);


                                        var re = TaskProcess.CreateTransport("", lastfull.S_LOC_CODE.Trim(), Endbit.S_LOC_CODE, "标签叉运-线边标签退库", CNTR.Select(x => x.S_CNTR_CODE).ToList(), 1, 1, 1, 62);


                                        LogHelper.CSucessLog($"from {lastfull.S_LOC_CODE} to {Endbit.S_LOC_CODE} 标签叉运-接驳标签退库 ，创建{re}");


                                    }


                                }


                                else


                                {


                                    var jbqs = LocationHelper.GetAreaNormalLocList(WJ_BQ.RK_BQJBQ);


                                    foreach (var rowloc in jbqs.GroupBy(x => x.N_ROW))


                                    {


                                        var y2 = rowloc.OrderBy(x => x.N_COL).ToList();


                                        var l2 = y2.FindAll(x => x.N_CURRENT_NUM > 0).LastOrDefault();


                                        if (l2 != null && l2.N_CURRENT_NUM > 0)


                                        {


                                            var c = LocationHelper.GetList<LocCntrRel>(x => x.S_LOC_CODE == l2.S_LOC_CODE);


                                            if (c.FirstOrDefault()?.S_TYPE != BQ_PRA.B)


                                            {


                                                continue;


                                            }


                                            var xcirs = ContainerHelper.GetCntrItemRel(c.FirstOrDefault().S_CNTR_CODE);


                                            if (!xcirs.Any()) continue;


                                            var xcir = xcirs.OrderByDescending(x => x.T_CREATE).FirstOrDefault();


                                            if (cir.S_ITEM_CODE != xcir.S_ITEM_CODE || cir.S_ITEM_NAME != xcir.S_ITEM_NAME)


                                                continue;


                                        }


                                        var e = y2.Find(x => x.N_COL > (l2?.N_COL ?? 0) && x.N_CURRENT_NUM == 0);


                                        if (e != null)


                                        {


                                            var re = TaskProcess.CreateTransport("", lastfull.S_LOC_CODE.Trim(), e.S_LOC_CODE, "标签叉运-线边标签退库", new List<string> { CNTR.FirstOrDefault().S_CNTR_CODE }, 1, 1, 1, 62, BQ_PRA.B);


                                            LogHelper.Info($"from {lastfull.S_LOC_CODE} to {e.S_LOC_CODE} 标签叉运-线边标签退库 ，创建{re} ");


                                            break;


                                        }


                                    }


                                }




                                //else


                                //{


                                //    var jbqs = LocationHelper.GetAreaNormalLocList(WJ_BQ.RK_BQJBQ);


                                //    foreach (var rowloc in jbqs.GroupBy(x => x.N_ROW))


                                //    {


                                //        var y2 = rowloc.OrderBy(x => x.N_COL).ToList();


                                //        var l2 = y2.FindAll(x => x.N_CURRENT_NUM > 0).LastOrDefault();


                                //        if (l2 != null && l2.N_CURRENT_NUM > 0)


                                //        {


                                //            var c = LocationHelper.GetList<LocCntrRel>(x => x.S_LOC_CODE == l2.S_LOC_CODE);


                                //            if (c.FirstOrDefault()?.S_TYPE != BQ_PRA.B)


                                //            {


                                //                continue;


                                //            }


                                //            var xcirs = ContainerHelper.GetCntrItemRel(c.FirstOrDefault().S_CNTR_CODE);


                                //            if (!xcirs.Any()) continue;


                                //            var xcir = xcirs.OrderByDescending(x => x.T_CREATE).FirstOrDefault();


                                //            if (cir.S_ITEM_CODE != xcir.S_ITEM_CODE || cir.S_ITEM_NAME != xcir.S_ITEM_NAME)


                                //                continue;


                                //        }


                                //        var e = y2.Find(x => x.N_COL > (l2?.N_COL ?? 0) && x.N_CURRENT_NUM == 0);


                                //        if (e != null)


                                //        {


                                //            var re = TaskProcess.CreateTransport("", lastfull.S_LOC_CODE.Trim(), e.S_LOC_CODE, "标签叉运-线边标签退库", new List<string> { CNTR.FirstOrDefault().S_CNTR_CODE }, 1, 1, 1, 62, BQ_PRA.B);


                                //            LogHelper.Info($"from {lastfull.S_LOC_CODE} to {e.S_LOC_CODE} 标签叉运-线边标签退库 ，创建{re} ");


                                //            break;


                                //        }


                                //    }


                                //}


                            }


                        }


                    }


@@ -1833,15 +1853,17 @@


                            var cirs = ContainerHelper.GetCntrItemRel(CNTR.FirstOrDefault().S_CNTR_CODE);


                            if (!cirs.Any()) continue;


                            cir = cirs.OrderByDescending(x => x.T_CREATE).FirstOrDefault();


                            if (cir.S_ITEM_CODE == od.SQL_ItemCode && cir.S_ITEM_NAME == od.SQL_ItemName)


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


                            {


                                //plg 2025年6月13日 09:09:25  


                                Temp = new locCntItem


                                {


                                    N_CURRENT_NUM = lastfull.N_CURRENT_NUM,


                                    S_CNTR_CODE = cir.S_CNTR_CODE,


                                    S_LOC_CODE = lastfull.S_LOC_CODE,


                                    HalfOrFull = (cir.N_BQ_TRAY_TYPE == .5 ? 1 : (cir.N_BQ_TRAY_TYPE == .75 ? 2 : 3)),


                                    S_NOTE = cir.S_ITEM_CODE.Trim() + "&" + cir.S_ITEM_NAME.Trim()


                                    S_NOTE = cir.S_ITEM_CODE.Trim() + "&" + cir.S_ITEM_NAME.Trim(),


                                    S_CJ_NAME = cir.S_CJ_NAME


                                };


                                if (outlock != null)


                                {


@@ -2280,11 +2302,11 @@


            return;


            //1 半托直接上货架一层。


            lgrx = locsFirst.GroupBy(X => X.N_ROW).Select(x =>


           {


               var y11 = x.OrderBy(y => y.N_COL).ToList();


               var y1 = y11.FindAll(z => z.N_CURRENT_NUM > 0).LastOrDefault();


               return y1;


           }).ToList();


            {


                var y11 = x.OrderBy(y => y.N_COL).ToList();


                var y1 = y11.FindAll(z => z.N_CURRENT_NUM > 0).LastOrDefault();


                return y1;


            }).ToList();


            foreach (var lastfull in lgrx.FindAll(x => x.HalfOrFull == 2).OrderBy(x => x.HalfOrFull).ThenBy(x => x.N_ROW))


            {


                //var y = item.OrderBy(x => x.N_COL).ToList();


@@ -2456,59 +2478,77 @@




        internal static void YwlBQ_CreWJOutOrder()


        {




            LogHelper.Info($" 无菌出库  开始");


            //1.检查是否有退库


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


            ///第三段：接驳区 转 线边


            var JQBS = LocationHelper.GetAreaNormalLocList(WJ_BQ.RK_BQJBQ);


            foreach (var jbr in JQBS.GroupBy(x => x.N_ROW))


            {


                var y2 = jbr.OrderBy(x => x.N_COL).ToList();


                var l2 = y2.FindAll(x => x.N_CURRENT_NUM > 0).LastOrDefault();


                if (l2 != null)


                {


                    var c = LocationHelper.GetList<LocCntrRel>(x => x.S_LOC_CODE == l2.S_LOC_CODE);


                    if (!c.Any() || c.FirstOrDefault()?.S_TYPE == BQ_PRA.B)


                    {


                        //回库。


                        continue;


                    }


                    var cirs = ContainerHelper.GetCntrItemRel(c.FirstOrDefault().S_CNTR_CODE);


                    if (!cirs.Any()) continue;


                    var cir = cirs.OrderByDescending(x => x.T_CREATE).FirstOrDefault();




                    var xbqs = LocationHelper.GetAreaNormalLocList(WJ_BQ.RK_XBKQ);


                    foreach (var x1 in xbqs.GroupBy(x => x.N_ROW))


            if (false)


            {


                ///第三段：接驳区 转 线边


                var JQBS = LocationHelper.GetAreaNormalLocList(WJ_BQ.RK_BQJBQ);


                foreach (var jbr in JQBS.GroupBy(x => x.N_ROW))


                {


                    LogHelper.Info($" 无菌出库 接驳有数据");


                    var y2 = jbr.OrderBy(x => x.N_COL).ToList();


                    var l2 = y2.FindAll(x => x.N_CURRENT_NUM > 0).LastOrDefault();


                    if (l2 != null)


                    {


                        var x2 = x1.OrderBy(x => x.N_COL).ToList();


                        var l3 = x2.FindAll(x => x.N_CURRENT_NUM > 0).LastOrDefault();


                        if (l3 != null)


                        var c = LocationHelper.GetList<LocCntrRel>(x => x.S_LOC_CODE == l2.S_LOC_CODE);


                        if (!c.Any() || c.FirstOrDefault()?.S_TYPE == BQ_PRA.B)


                        {


                            var xc = LocationHelper.GetList<LocCntrRel>(x => x.S_LOC_CODE == l3.S_LOC_CODE);


                            if (!xc.Any() || xc.FirstOrDefault()?.S_TYPE == BQ_PRA.B)


                            {


                                continue;


                            }


                            var xcirs = ContainerHelper.GetCntrItemRel(xc.FirstOrDefault().S_CNTR_CODE);


                            if (!xcirs.Any()) continue;


                            var xcir = xcirs.OrderByDescending(x => x.T_CREATE).FirstOrDefault();


                            if (xcir.S_ITEM_CODE != cir.S_ITEM_CODE || xcir.S_ITEM_NAME != cir.S_ITEM_CODE)


                                continue;


                            //回库。


                            LogHelper.Info($"循环有无退库==> 有 退库" + l2.S_LOC_CODE);


                            continue;


                        }


                        var e = x2.FindAll(x => x.N_COL > (l3?.N_COL ?? 0) && x.N_CURRENT_NUM == 0).FirstOrDefault();


                        if (e != null)


                        var cirs = ContainerHelper.GetCntrItemRel(c.FirstOrDefault().S_CNTR_CODE);


                        if (!cirs.Any())


                        {


                            var re = TaskProcess.CreateTransport("", l2.S_LOC_CODE.Trim(), e.S_LOC_CODE, "标签叉运-接驳转线边", new List<string> { c.FirstOrDefault().S_CNTR_CODE }, 1, 1, 1, 62, BQ_PRA.Out);


                            LogHelper.Info($"from {l2.S_LOC_CODE} to {e.S_LOC_CODE} 标签叉运-接驳转线边 ，创建{re} ");


                            break;


                            LogHelper.Info($"循环有无退库==> 没有物料信息 托盘:" + c.FirstOrDefault().S_CNTR_CODE);


                            continue;


                        }


                        var cir = cirs.OrderByDescending(x => x.T_CREATE).FirstOrDefault();




                        var xbqs = LocationHelper.GetAreaNormalLocList(WJ_BQ.RK_XBKQ);


                        foreach (var x1 in xbqs.GroupBy(x => x.N_ROW))


                        {


                            LogHelper.Info($" 无菌出库 线边有数据");


                            var x2 = x1.OrderBy(x => x.N_COL).ToList();


                            var l3 = x2.FindAll(x => x.N_CURRENT_NUM > 0).LastOrDefault();


                            if (l3 != null)


                            {


                                var xc = LocationHelper.GetList<LocCntrRel>(x => x.S_LOC_CODE == l3.S_LOC_CODE);


                                if (!xc.Any() || xc.FirstOrDefault()?.S_TYPE == BQ_PRA.B)


                                {


                                    LogHelper.Info($"循环线边==> 有 退库" + xc.FirstOrDefault()?.S_TYPE);


                                    continue;


                                }


                                var xcirs = ContainerHelper.GetCntrItemRel(xc.FirstOrDefault().S_CNTR_CODE);


                                if (!xcirs.Any())


                                {


                                    LogHelper.Info($"循环线边==>  没有物料信息 托盘:" + xc.FirstOrDefault().S_CNTR_CODE);


                                    continue;


                                }




                                var xcir = xcirs.OrderByDescending(x => x.T_CREATE).FirstOrDefault();


                                if (xcir.S_ITEM_CODE != cir.S_ITEM_CODE || xcir.S_ITEM_NAME != cir.S_ITEM_CODE)


                                {


                                    LogHelper.Info($"循环线边==>  物料不匹配 托盘:" + xc.FirstOrDefault().S_CNTR_CODE);


                                    continue;


                                }


                            }


                            var e = x2.FindAll(x => x.N_COL > (l3?.N_COL ?? 0) && x.N_CURRENT_NUM == 0).FirstOrDefault();


                            LogHelper.Info($"无菌 生成任务==> 是否有合适的货位信息" + e?.S_LOC_CODE);


                            if (e != null)


                            {


                                var re = TaskProcess.CreateTransport("", l2.S_LOC_CODE.Trim(), e.S_LOC_CODE, "标签叉运-接驳转线边", new List<string> { c.FirstOrDefault().S_CNTR_CODE }, 1, 1, 1, 62, BQ_PRA.Out);


                                LogHelper.Info($"from {l2.S_LOC_CODE} to {e.S_LOC_CODE} 标签叉运-接驳转线边 ，创建{re} ");


                                break;


                            }


                        }


                    }


                }


            }




            ///拆垛区取消。


            if (false)


            {


                LogHelper.Info($" 无菌出库 到线边 结束");


                ///拆垛区取消。


                ///第二段：拆垛区。拆去接驳。 或者回库。


                var v = LocationHelper.GetAreaNormalLocList(WJ_BQ.RK_BQCDQ);


                ///拆垛的出库。 单层的回库  单层不入拆垛区


@@ -2563,8 +2603,9 @@


                    }


                }


            }




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


            var yuworders = LocationHelper.GetList<YWLWorkOrder>(x => x.SQL_PLineNo == "无菌标签出库" && 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 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();




        //foreach (var order in yuworders)


        retuse:


@@ -2626,7 +2667,7 @@


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


                        {


                            // 直接出接驳位


                            var jbqs = LocationHelper.GetAreaNormalLocList(WJ_BQ.RK_BQJBQ);


                            var jbqs = LocationHelper.GetAreaNormalLocList(WJ_BQ.RK_XBKQ);


                            foreach (var rowloc in jbqs.GroupBy(x => x.N_ROW))


                            {


                                var y2 = rowloc.OrderBy(x => x.N_COL).ToList();


@@ -2638,16 +2679,16 @@


                                    {


                                        continue;


                                    }


                                    var cirs = ContainerHelper.GetCntrItemRel(c.FirstOrDefault().S_CNTR_CODE);


                                    if (!cirs.Any()) continue;


                                    var cir = cirs.OrderByDescending(x => x.T_CREATE).FirstOrDefault();


                                    if (cir.S_ITEM_CODE != tagLoc.S_ITEM_CODE || cir.S_ITEM_NAME != tagLoc.S_ITEM_NAME)


                                        continue;


                                    //var cirs = ContainerHelper.GetCntrItemRel(c.FirstOrDefault().S_CNTR_CODE);


                                    //if (!cirs.Any()) continue;


                                    //var cir = cirs.OrderByDescending(x => x.T_CREATE).FirstOrDefault();


                                    //if (cir.S_ITEM_CODE != tagLoc.S_ITEM_CODE || cir.S_ITEM_NAME != tagLoc.S_ITEM_NAME)


                                    //    continue;


                                }


                                var e = y2.FindAll(x => x.N_COL > (l2?.N_COL ?? 0) && x.N_CURRENT_NUM == 0).FirstOrDefault();


                                if (e != null)


                                {


                                    var re = TaskProcess.CreateTransport("", tagLoc.S_LOC_CODE.Trim(), e.S_LOC_CODE, "标签叉运-货架出接驳", new List<string> { tagLoc.S_CNTR_CODE }, 1, 1, 1, 62);


                                    var re = TaskProcess.CreateTransport("", tagLoc.S_LOC_CODE.Trim(), e.S_LOC_CODE, "标签叉运-货架出线边", new List<string> { tagLoc.S_CNTR_CODE }, 1, 1, 1, 62);


                                    LogHelper.Info($"from {tagLoc.S_LOC_CODE} to {e.S_LOC_CODE} 标签叉运-货架出接驳 ，创建{re} ");


                                    if (re)


                                        oto.Add(item);


@@ -2980,7 +3021,7 @@


                                if (endBit != null)


                                {


                                    LogHelper.Info($"{spn} - 去中转区，找到位置{endBit.S_LOC_CODE}");


                                    bool bb = TaskProcess.CreateTransport(order.SQL_WorkNo, strBit.S_LOC_CODE, endBit.S_LOC_CODE, spn + "中转去", new List<string> { crl.S_CNTR_CODE }, strBit.N_CURRENT_NUM, endBit.N_CURRENT_NUM++, 1, 50, crl.S_TYPE);


                                    bool bb = TaskProcess.CreateTransport(order.SQL_WorkNo, strBit.S_LOC_CODE, endBit.S_LOC_CODE, spn + "中转去", new List<string> { crl.S_CNTR_CODE }, strBit.N_CURRENT_NUM, endBit.N_CURRENT_NUM + 1, 1, 50, crl.S_TYPE);


                                    LogHelper.Info($"{spn}未开，翻斗机开。线程，创建去{areaList}中转区的任务{(bb ? "成功" : "失败")}");


                                    if (bb && needBread)


                                    {


@@ -3121,22 +3162,22 @@


                        }


                        else


                            WCSHelper.Do(db =>


                        {


                            //var LCRLIST = db.Queryable<LocCntrRel>().Includes(x => x.CntrItemRel).Where(x => x.S_LOC_CODE.StartsWith("QX-") && (x.CntrItemRel.S_ITEM_CODE == outOer.S_ITEM_CODE || x.CntrItemRel.S_ITEM_CODE == outOer.S_ITEM_NAME)).ToList();


                            List = db.Queryable<LocCntrRel>()


                            .LeftJoin<CntrItemRel>((lcr, cir) => lcr.S_CNTR_CODE == cir.S_CNTR_CODE)


                            .LeftJoin<Location>((lcr, cir, lo) => lcr.S_LOC_CODE == lo.S_LOC_CODE)


                            .Where((lcr, cir) => lcr.S_LOC_CODE.StartsWith("QX-") && (cir.S_ITEM_CODE == outOer.S_ITEM_CODE || cir.S_ITEM_CODE == outOer.S_ITEM_NAME))


                            .Select((lcr, cir, lo) => new Location


                            {


                                S_AREA_CODE = lo.S_AREA_CODE,


                                S_WH_CODE = lcr.S_TYPE,


                                T_CREATE = lcr.T_CREATE,


                                N_ROW = lo.N_ROW,


                                N_COL = lcr.S_CNTR_CODE.StartsWith("TP") ? 0 : 1


                            }).ToList();


                                //var LCRLIST = db.Queryable<LocCntrRel>().Includes(x => x.CntrItemRel).Where(x => x.S_LOC_CODE.StartsWith("QX-") && (x.CntrItemRel.S_ITEM_CODE == outOer.S_ITEM_CODE || x.CntrItemRel.S_ITEM_CODE == outOer.S_ITEM_NAME)).ToList();


                                List = db.Queryable<LocCntrRel>()


                                .LeftJoin<CntrItemRel>((lcr, cir) => lcr.S_CNTR_CODE == cir.S_CNTR_CODE)


                                .LeftJoin<Location>((lcr, cir, lo) => lcr.S_LOC_CODE == lo.S_LOC_CODE)


                                .Where((lcr, cir) => lcr.S_LOC_CODE.StartsWith("QX-") && (cir.S_ITEM_CODE == outOer.S_ITEM_CODE || cir.S_ITEM_CODE == outOer.S_ITEM_NAME))


                                .Select((lcr, cir, lo) => new Location


                                {


                                    S_AREA_CODE = lo.S_AREA_CODE,


                                    S_WH_CODE = lcr.S_TYPE,


                                    T_CREATE = lcr.T_CREATE,


                                    N_ROW = lo.N_ROW,


                                    N_COL = lcr.S_CNTR_CODE.StartsWith("TP") ? 0 : 1


                                }).ToList();




                        });


                            });


                        if (!List.Any())


                        {


                            LogHelper.Info($"备货单：{outOer.S_Work_NO} 库区中没有找到可用物料。");


@@ -3275,6 +3316,7 @@


                                LogHelper.Info($"备货单：{outOer.S_Work_NO} 最后移库库区{ea} - 排{er} 怎么他妈是空的！！！诡了个异的");


                            }


                        }




                    eaaa:


                        if (string.IsNullOrEmpty(end_area))


                        {


@@ -3355,7 +3397,6 @@


                                //}


                            }


                        }






                        if (string.IsNullOrEmpty(start_area)


                            || string.IsNullOrEmpty(start_row)


@@ -3501,6 +3542,8 @@


        {


            public string ItemCode { get; set; }


            public string ItemName { get; set; }




            public string S_CJ_NAME { get; set; }


            /// <summary>


            /// 最高层


            /// </summary>


@@ -3511,8 +3554,13 @@


            public string Row { get; set; }




        }


        /// <summary>


        /// 原物料纸箱出库


        /// </summary>


        public static void AutoRun13TSJ()


        {


            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))


            {


                string pline = PLC.deviceName;


@@ -3520,7 +3568,6 @@


                    pline = "T2提升机-纸箱";




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


                orkOrd = orkOrd.FindAll(x => DateTime.Now.Subtract(x.SQL_Modify_TIme ?? DateTime.Now).TotalSeconds > 10);


                bool can = false;


                if (orkOrd.Any())


                {


@@ -3531,18 +3578,52 @@


                    if (locs.Find(x => x.N_CURRENT_NUM > 0) != null) //拆垛有货 不判断


                        continue;


                    can = true;




                    //var source1 = orkOrd.FirstOrDefault();


                    //foreach (var item in list)


                    //{


                    //    YWLWorkOrder source = new YWLWorkOrder();


                    //    source.SQL_PLineNo = source1.SQL_PLineNo;


                    //    source.FuLe_PLine_No = source1.FuLe_PLine_No;


                    //    source.SQL_LinkLineNO = source1.SQL_LinkLineNO;


                    //    source.SQL_Area = item;


                    //    source.SQL_UsingNow = source1.SQL_UsingNow;


                    //    source.SQL_State = source1.SQL_State;


                    //    source.SQL_WorkNo = source1.SQL_WorkNo;


                    //    source.SQL_ItemCode = source1.SQL_ItemCode;


                    //    source.SQL_ItemName = source1.SQL_ItemName;


                    //    source.SQL_charge = source1.SQL_charge;


                    //    source.SQL_Total = source1.SQL_Total;


                    //    source.SQL_PLAN_END = source1.SQL_PLAN_END;


                    //    source.SQL_Modify_TIme = source1.SQL_Modify_TIme;


                    //    source.OutNum = source1.OutNum;


                    //    source.WorkType = source1.WorkType;


                    //    source.MidArea = source1.MidArea;


                    //    source.TagOver = source1.TagOver;


                    //    source.TagOverTime = source1.TagOverTime;


                    //    source.S_BQ_TRAY_TYPE = source1.S_BQ_TRAY_TYPE;


                    //    source.S_CJ_NAME = source1.S_CJ_NAME;


                    //    source.S_ROW = item;


                    //    WorkOrder.Add(source);


                    //}


                }




                orkOrd = orkOrd.FindAll(x => x.OutNum > 0 && DateTime.Now.Subtract(x.SQL_Modify_TIme ?? DateTime.Now).TotalSeconds > 10);


                ReadCCK = can;


                if (orkOrd.Any())


                    foreach (var od in orkOrd.OrderByDescending(x => x.OutNum))


                    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" };


                        l2.Remove(od.S_ROW);


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


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


                        Dictitems Lart = null;


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


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


                        {


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


                            {


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


                                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 (Lart == null)


                                        Lart = d;


@@ -3552,99 +3633,127 @@


                                            Lart = d;


                                    }


                                }




                            }


                        }




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


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


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


                        {


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


                            Location StartBit = null;


                            List<LocCntrRel> _clrel = new List<LocCntrRel>();




                            foreach (var area in v.Concat(od.S_ROW.Split('$')).Distinct())


                        if (Lart != null)


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


                            {


                                var AreaRowlist = LocationHelper.GetAreaNormalLocList(area);


                                foreach (var item in AreaRowlist.GroupBy(x => x.N_ROW))


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


                                Location StartBit = null;


                                List<LocCntrRel> _clrel = new List<LocCntrRel>();




                                foreach (var area in v) //.Concat(od.S_ROW.Split('$')).Distinct())


                                {


                                    var rl = item.ToList().FindAll(x => x.N_CURRENT_NUM > 0).OrderBy(x => x.N_COL).LastOrDefault();


                                    if (rl == null) continue;


                                    _clrel = LocationHelper.GetLocCntrRel(rl.S_LOC_CODE);


                                    //板型相同


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


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


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


                                    if (_clcntitem != null)


                                    var AreaRowlist = LocationHelper.GetAreaNormalLocList(area);


                                    foreach (var item in AreaRowlist.GroupBy(x => x.N_ROW))


                                    {


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


                                        var rl = item.ToList().FindAll(x => x.N_CURRENT_NUM > 0).OrderBy(x => x.N_COL).LastOrDefault();


                                        if (rl == null) continue;


                                        _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));


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


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


                                        if (_clcntitem != null)


                                        {


                                            StartBit = rl;


                                            break;


                                            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);


                                            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;


                                            }


                                        }


                                    }


                                    if (StartBit != null)


                                        break;


                                }


                                if (StartBit != null)


                                    break;


                            }


                            if (StartBit == null)


                                continue;


                            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 (DeviceProcess.doorStatus[PLC.location[0]].info == "1")


                                if (StartBit == null)


                                {


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


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


                                    continue;


                                }


                            }


                            else


                            {


                                Endbit = LocationHelper.GetAreaNormalLocList(PLC.areaPriy[0]).Find(x => x.N_CURRENT_NUM == 0);


                            }


                                Location Endbit = null;




                            if (StartBit != null && Endbit != null)


                            {


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


                                var EndBit = Endbit.S_LOC_CODE;


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


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


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


                                {


                                    EndBit = "YWLWJJB";


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


                                    {


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


                                    }


                                }


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


                                if (b)


                                else


                                {


                                    Endbit = LocationHelper.GetAreaNormalLocList(PLC.areaPriy[0]).Find(x => x.S_LOCK_STATE == "无" && x.N_CURRENT_NUM == 0);


                                }




                                    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 };


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


                                    //给终点锁定住


                                if (StartBit != null && Endbit != null)


                                {


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


                                    var jbbit = "";


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


                                    {


                                        var model = db.Queryable<Location>().Where(a => a.S_LOC_CODE == Endbit.S_LOC_CODE).First();




                                        model.S_LOCK_STATE = "入库锁";


                                        var res = db.Updateable(model).UpdateColumns(it => new { it.S_LOCK_STATE }).ExecuteCommand() > 0;


                                        LogHelper.Info(Endbit.S_LOC_CODE + "LockLoc:锁结果" + res);


                                    }


                                    //排锁


                                    var row = db.Queryable<RowLock>().Where(x => x.S_AREA_CODE == r.S_AREA_CODE && r.N_ROW == x.N_ROW).First();


                                    if (row != null)


                                    {


                                        if (row.S_LOCK_SRC != r.S_LOCK_SRC)


                                        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)


                                        {


                                            db.Deleteable(row).ExecuteCommand();


                                            db.Insertable(r).ExecuteCommand();


                                            jbbit = locs1.FirstOrDefault().S_LOC_CODE;


                                        }


                                        else


                                        {


                                            continue;


                                        }


                                    }


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


                                    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);


                                    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 };


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


                                        //给终点锁定住


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


                                        {


                                            var model = db.Queryable<Location>().Where(a => a.S_LOC_CODE == Endbit.S_LOC_CODE).First();




                                            model.S_LOCK_STATE = "入库锁";


                                            var res = db.Updateable(model).UpdateColumns(it => new { it.S_LOCK_STATE }).ExecuteCommand() > 0;


                                            LogHelper.Info(Endbit.S_LOC_CODE + "LockLoc:锁结果" + res);


                                        }


                                        //排锁


                                        //var row = db.Queryable<RowLock>().Where(x => x.S_AREA_CODE == r.S_AREA_CODE && r.N_ROW == x.N_ROW).First();


                                        //if (row != null)


                                        //{


                                        //    if (row.S_LOCK_SRC != r.S_LOCK_SRC)


                                        //    {


                                        //        db.Deleteable(row).ExecuteCommand();


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


                                        //    }


                                        //}


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


                                        od.TagOverTime = DateTime.Now;


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


                                        //break;


                                    }


                                }


                                break;


                                else


                                {


                                    LogHelper.Info($"{od.SQL_PLineNo} 出库起点{StartBit.S_LOC_CODE}-{StartBit.N_CURRENT_NUM},没有可用终点");


                                    continue;


                                }


                            }


                        }


                    }


            }


        }


        public static void AutoRunABD()


        {


            LogHelper.Info($"AutoRunABD abcd物料汇总  >>{ReadCCK}|| {dsi.Count}");


            if (!ReadCCK)


            {


                Thread.Sleep(3000);


@@ -3658,10 +3767,14 @@


                    pline = "T2提升机-纸箱";


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


                if (orkOrd.Any())


                    foreach (var ork in orkOrd)


                    {


                        list = list.Concat(ork.S_ROW.Split('$')).ToList();


                    }


                {


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


                    //foreach (var ork in orkOrd)


                    //{


                    //    list = list.Concat(ork.S_ROW.Split('$')).ToList();


                    //}


                }




            }


            foreach (var area in list.Distinct())


            {


@@ -3671,8 +3784,13 @@


                    var rl = item.ToList().FindAll(x => x.N_CURRENT_NUM > 0).OrderBy(x => x.N_COL).LastOrDefault();




                    var _clrel = LocationHelper.GetLocCntrRel(rl.S_LOC_CODE);


                    if (!_clrel.Any())


                    {


                        LogHelper.Info($"{area}>> {rl.S_LOC_CODE}有数量， 没托盘");


                        continue;


                    }


                    //板型相同


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


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


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




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


@@ -3681,7 +3799,7 @@


                    {


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


                        {


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


                            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);


                            if (ill != null)


                            {


                                if (rl.N_CURRENT_NUM > ill.ItemLayer)


@@ -3697,6 +3815,7 @@


                                ItemName = _clcntitem.S_ITEM_NAME,


                                ItemCode = _clcntitem.S_ITEM_CODE,


                                ItemLayer = rl.N_CURRENT_NUM,


                                S_CJ_NAME = _clcntitem.S_CJ_NAME,


                                area = area,


                                Row = $"{rl.S_LOC_CODE}"


                            });


@@ -3710,6 +3829,7 @@


                                ItemName = _clcntitem.S_ITEM_NAME,


                                ItemCode = _clcntitem.S_ITEM_CODE,


                                ItemLayer = rl.N_CURRENT_NUM,


                                S_CJ_NAME = _clcntitem.S_CJ_NAME,


                                area = area,


                                Row = $"{rl.S_LOC_CODE}"


                            });


@@ -3718,6 +3838,7 @@


                    }


                }


            }


            LogHelper.Info($"AutoRunABD abcd物料汇总完成  >>{ReadCCK}|| {dsi.Count}");


        }




        public static void chargeCCD()


@@ -3735,6 +3856,7 @@


                    list.AddRange(item.MidArea.Split('$'));


                }


            }




            foreach (var item in list.Distinct())


            {


                var locs = LocationHelper.GetList<Location>(x => x.S_AREA_CODE == item && x.N_CURRENT_NUM > 0 && x.S_LOCK_STATE == "无");


@@ -3790,6 +3912,7 @@


                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.CError($"from{od.S_START_AREA} mid:{od.S_ZZ_AREA} to{od.S_END_AREA} 数据缺失。无法完成移库。");


@@ -3809,10 +3932,12 @@


                            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}。");


                                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}");


                                var cir1 = cntritems.First();


                                if (od.S_ZZ_AREA == "YWLWJJB")


                                {


@@ -3821,7 +3946,8 @@


                                    else InworkLock = true;


                                }


                                else InworkLock = false;


                                var zzlocs = LocationHelper.GetAreaNormalLocList(od.S_ZZ_AREA);


                                string nextarea = !string.IsNullOrEmpty(od.S_ZZ_AREA) ? od.S_ZZ_AREA : od.S_END_AREA;


                                var zzlocs = LocationHelper.GetAreaNormalLocList(nextarea);


                                Location Endbit = null;


                                foreach (var zzrs in zzlocs.GroupBy(x => x.N_ROW).OrderBy(x => x.Key))


                                {


@@ -3833,7 +3959,7 @@


                                        var cntrrel = ContainerHelper.GetCntrItemRel(rel.FirstOrDefault()?.S_CNTR_CODE).FirstOrDefault();


                                        if (cntrrel == null)


                                            continue;


                                        if (cntrrel.S_ITEM_CODE == cir1.S_ITEM_CODE && cntrrel.S_ITEM_NAME == cir1.S_ITEM_NAME)


                                        if (cntrrel.S_ITEM_CODE == cir1.S_ITEM_CODE && cntrrel.S_ITEM_NAME == cir1.S_ITEM_NAME && cntrrel.S_CJ_NAME == cir1.S_CJ_NAME)


                                        {


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


                                        }


@@ -3846,10 +3972,11 @@


                                        break;


                                    }


                                }


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


                                if (Endbit != null)


                                {


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


                                    var b = TaskProcess.CreateTransport(od.S_ID, lastful.S_LOC_CODE, Endbit.S_LOC_CODE, "原物料搬运-纸箱", crs.Select(x => x.S_CNTR_CODE).ToList(), 1, 1, crs.Count, 50, od.S_END_AREA);


                                    var b = TaskProcess.CreateTransport(od.S_ID, lastful.S_LOC_CODE, Endbit.S_LOC_CODE, "原物料搬运-纸箱", crs.Select(x => x.S_CNTR_CODE).ToList(), 1, 1, crs.Count, 50, nextarea == od.S_END_AREA ? "" : od.S_END_AREA);


                                    if (od.S_ZZ_AREA == "YWLWJJB") InworkLock = false;


                                    break;


                                }