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


@@ -872,10 +872,10 @@


                    {


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


                        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


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


            public static string RK_BQCDQ = "SXBQDDKQ";




        }


        /// <summary>


        ///  提扣 。


        /// </summary>


        internal static void YwlTKPEBQ_Auto()


        {


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


@@ -1435,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;


@@ -1727,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())


            {


@@ -1750,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;


                                //        }


                                //    }


                                //}


                            }


                        }


                    }


@@ -2467,73 +2481,74 @@


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




            if (false)


            {


                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 JQBS = LocationHelper.GetAreaNormalLocList(WJ_BQ.RK_BQJBQ);


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


                {


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


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


                    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)


                    {


                        //回库。


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


                        continue;


                    }


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


                    if (!cirs.Any())


                    {


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


                            {


                                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;


                            }


                            //回库。


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


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


                        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;


                            }


                        }


                    }


                }


            }


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


            ///拆垛区取消。


            if (false)


            {


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


                ///拆垛区取消。


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


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


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


@@ -2588,6 +2603,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();




@@ -2651,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();


@@ -2663,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);


@@ -3005,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)


                                    {


@@ -3300,6 +3316,7 @@


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


                            }


                        }




                    eaaa:


                        if (string.IsNullOrEmpty(end_area))


                        {


@@ -3380,7 +3397,6 @@


                                //}


                            }


                        }






                        if (string.IsNullOrEmpty(start_area)


                            || string.IsNullOrEmpty(start_row)


@@ -3598,8 +3614,9 @@


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


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


                    {


                        list.Remove(od.S_ROW);


                        var odsr = new List<string> { od.S_ROW }.Concat(list).Distinct().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 odsr)//od.S_ROW.Split('$'))


@@ -3616,6 +3633,7 @@


                                            Lart = d;


                                    }


                                }




                            }


                        }




@@ -3628,7 +3646,7 @@


                                Location StartBit = null;


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




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


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


                                {


                                    var AreaRowlist = LocationHelper.GetAreaNormalLocList(area);


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


@@ -3656,7 +3674,10 @@


                                        break;


                                }


                                if (StartBit == null)


                                {


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


                                    continue;


                                }


                                Location Endbit = null;




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


@@ -3669,29 +3690,31 @@


                                }


                                else


                                {


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


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


                                }




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


                                {


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


                                    var EndBit = Endbit.S_LOC_CODE;


                                    var jbbit = "";


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


                                    {


                                        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)


                                        {


                                            EndBit = locs1.FirstOrDefault().S_LOC_CODE;


                                            jbbit = locs1.FirstOrDefault().S_LOC_CODE;


                                        }


                                        else


                                        {


                                            continue;


                                        }


                                    }


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


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


                                        //给终点锁定住


@@ -3704,20 +3727,25 @@


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


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


                                }


                            }


                    }


@@ -3828,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 == "无");


@@ -3883,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} 数据缺失。无法完成移库。");


@@ -3902,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")


                                {


@@ -3914,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))


                                {


@@ -3926,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));


                                        }


@@ -3939,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;


                                }