WMSPrjInstance/HH-0014_NongFu_QingXi.git

			@@ -8,6 +8,7 @@
			using System.Linq;
			using System.Threading;
			using System.Threading.Tasks;
			using System.Web.UI.WebControls.WebParts;

			namespace HH.WCS.QingXigongchang.core
			{
			@@ -95,7 +96,7 @@
			{
			if (item.SQL_State != "完成")
			{
			ROW_LOCK(LocationHelper.GetLocList(x => x.S_AREA_CODE == item.start_area && x.N_ROW == srow).FirstOrDefault(), LocationHelper.GetLocList(x => x.S_AREA_CODE == item.end_area && x.N_ROW == erow).FirstOrDefault(), "", 0, string.IsNullOrEmpty(item.FROM_NO));
			ROW_LOCK(LocationHelper.GetLocList(x => x.S_AREA_CODE == item.start_area && x.N_ROW == srow).FirstOrDefault(), LocationHelper.GetLocList(x => x.S_AREA_CODE == item.end_area && x.N_ROW == erow).FirstOrDefault(), "", 0, string.IsNullOrEmpty(item.FROM_NO),item.SQL_WorkNo);
			WCSHelper.Do(db =>
			{
			LogHelper.Info("移库工单数量完成" + item.SQL_WorkNo);
			@@ -118,7 +119,7 @@
			{
			LogHelper.Info($"{item.Turn_Type}工单{item.SQL_WorkNo} 手动完成，处理解锁,");

			ROW_LOCK(LocationHelper.GetLocList(x => x.S_AREA_CODE == item.start_area && x.N_ROW == srow).FirstOrDefault(), LocationHelper.GetLocList(x => x.S_AREA_CODE == item.end_area && x.N_ROW == erow).FirstOrDefault(), "", 0, string.IsNullOrEmpty(item.FROM_NO));
			ROW_LOCK(LocationHelper.GetLocList(x => x.S_AREA_CODE == item.start_area && x.N_ROW == srow).FirstOrDefault(), LocationHelper.GetLocList(x => x.S_AREA_CODE == item.end_area && x.N_ROW == erow).FirstOrDefault(), "", 0, string.IsNullOrEmpty(item.FROM_NO), item.SQL_WorkNo);
			WCSHelper.Do(db =>
			{
			if (item.Turn_Type == "自动移库")
			@@ -178,7 +179,7 @@
			{
			//LocationHelper.SetRowLock(new RowLock { S_AREA_CODE = item.start_row, N_ROW = srow }, 0);
			//LocationHelper.SetRowLock(new RowLock { S_AREA_CODE = item.end_row, N_ROW = erow }, 0);
			ROW_LOCK(LocationHelper.GetLocList(x => x.S_AREA_CODE == item.start_area && x.N_ROW == srow).FirstOrDefault(), LocationHelper.GetLocList(x => x.S_AREA_CODE == item.end_area && x.N_ROW == erow).FirstOrDefault(), "", 0, string.IsNullOrEmpty(item.FROM_NO));
			ROW_LOCK(LocationHelper.GetLocList(x => x.S_AREA_CODE == item.start_area && x.N_ROW == srow).FirstOrDefault(), LocationHelper.GetLocList(x => x.S_AREA_CODE == item.end_area && x.N_ROW == erow).FirstOrDefault(), "", 0, string.IsNullOrEmpty(item.FROM_NO), item.SQL_WorkNo);

			LogHelper.Info($"{item.Turn_Type}工单,完成" + item.SQL_WorkNo + "起排无货或终排已满无法移库");
			item.SQL_State = "完成";
			@@ -302,7 +303,7 @@
			{
			//LocationHelper.SetRowLock(new RowLock { S_AREA_CODE = item.start_row, N_ROW = srow }, 0);
			//LocationHelper.SetRowLock(new RowLock { S_AREA_CODE = item.end_row, N_ROW = erow }, 0);
			ROW_LOCK(LocationHelper.GetLocList(x => x.S_AREA_CODE == item.start_area && x.N_ROW == srow).FirstOrDefault(), LocationHelper.GetLocList(x => x.S_AREA_CODE == item.end_area && x.N_ROW == erow).FirstOrDefault(), "", 0, string.IsNullOrEmpty(item.FROM_NO));
			ROW_LOCK(LocationHelper.GetLocList(x => x.S_AREA_CODE == item.start_area && x.N_ROW == srow).FirstOrDefault(), LocationHelper.GetLocList(x => x.S_AREA_CODE == item.end_area && x.N_ROW == erow).FirstOrDefault(), "", 0, string.IsNullOrEmpty(item.FROM_NO), item.SQL_WorkNo);
			LogHelper.Info($"{item.Turn_Type}工单,完成" + item.SQL_WorkNo + "起点已经没有货了，移库完成");
			item.SQL_State = "完成";
			item.Note = "起点已经没有货了，移库完成";
			@@ -321,7 +322,7 @@
			{
			//LocationHelper.SetRowLock(new RowLock { S_AREA_CODE = item.start_row, N_ROW = srow }, 0);
			//LocationHelper.SetRowLock(new RowLock { S_AREA_CODE = item.end_row, N_ROW = erow }, 0);
			ROW_LOCK(LocationHelper.GetLocList(x => x.S_AREA_CODE == item.start_area && x.N_ROW == srow).FirstOrDefault(), LocationHelper.GetLocList(x => x.S_AREA_CODE == item.end_area && x.N_ROW == erow).FirstOrDefault(), "", 0, string.IsNullOrEmpty(item.FROM_NO));
			ROW_LOCK(LocationHelper.GetLocList(x => x.S_AREA_CODE == item.start_area && x.N_ROW == srow).FirstOrDefault(), LocationHelper.GetLocList(x => x.S_AREA_CODE == item.end_area && x.N_ROW == erow).FirstOrDefault(), "", 0, string.IsNullOrEmpty(item.FROM_NO), item.SQL_WorkNo);
			LogHelper.Info($"{item.Turn_Type}工单,完成" + item.SQL_WorkNo + "终点满了，移库完成");
			item.SQL_State = "完成";
			item.Note = "终点满了，移库完成";
			@@ -418,11 +419,24 @@
			}
			}

			static void ROW_LOCK(Location startBit, Location EndBit, string msg, int sign, bool up = true)
			static void ROW_LOCK(Location startBit, Location EndBit, string msg, int sign, bool up = true, string WorkNo = "")
			{
			LogHelper.Info("dooooooooooooooooooooooooooooooooooooooooooooo" + msg + "---" + sign);
			LogHelper.Info(JsonConvert.SerializeObject(startBit));
			LogHelper.Info(JsonConvert.SerializeObject(EndBit));
			bool j解锁起点库区排 = true;
			if (!string.IsNullOrEmpty(WorkNo) && sign == 0)
			{
			//解锁时，有工单号。查查除了这个工单号以外的其他指定出库排执行
			var orders = WCSHelper.GetWorkOrder2();
			var thisOrder = orders.Find(x => x.SQL_WorkNo == WorkNo);
			if (thisOrder != null)
			{
			var other = orders.Find(x => x.SQL_WorkNo != WorkNo && x.start_area == thisOrder.start_area && x.start_row == thisOrder.start_row);
			if (other != null)
			j解锁起点库区排 = false;
			}
			}
			//if (sign == 1)
			//{
			// if (LocationHelper.GetRowLock(x => x.S_AREA_CODE == startBit.S_AREA_CODE && x.N_ROW == startBit.N_ROW).Count > 0)
			@@ -430,7 +444,8 @@
			// return;
			// }
			//}
			LocationHelper.SetRowLock(new RowLock { S_AREA_CODE = startBit.S_AREA_CODE, N_ROW = startBit.N_ROW, S_LOCK_STATE = msg }, sign);
			if (j解锁起点库区排)
			LocationHelper.SetRowLock(new RowLock { S_AREA_CODE = startBit.S_AREA_CODE, N_ROW = startBit.N_ROW, S_LOCK_STATE = msg }, sign);
			LocationHelper.SetRowLock(new RowLock { S_AREA_CODE = EndBit.S_AREA_CODE, N_ROW = EndBit.N_ROW, S_LOCK_STATE = msg }, sign);
			//if (EndBit == null \|\| EndBit.S_AREA_CODE.StartsWith("BHQ-"))
			// return;
			@@ -439,9 +454,12 @@
			{
			case 0:
			{
			var lst = new List<string> { startBit.S_Fule_LOC, EndBit.S_Fule_LOC };
			if (!j解锁起点库区排)
			lst = new List<string> { EndBit.S_Fule_LOC };
			var req = JsonConvert.SerializeObject(new
			{
			areaNum = new List<string> { startBit.S_Fule_LOC, EndBit.S_Fule_LOC },
			areaNum = lst,
			repoNo = Settings.repoNo,
			areaLock = "2"
			});
			@@ -850,7 +868,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 +885,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 +1027,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
			@@ -1043,6 +1062,7 @@
			if (!cntritems.Any())
			continue;
			var cir1 = cntritems.First();
			//只筛选纸箱物料的库区数据。
			if (!string.IsNullOrEmpty(cir1.S_ITEM_NAME) && cir1.S_ITEM_NAME.Contains("纸箱-"))
			if (dsll.TryGetValue(cir1.S_ITEM_CODE, out List<Location> ll))
			{
			@@ -1120,7 +1140,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 +1166,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 +1186,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 +1211,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 +1279,9 @@
			public static string RK_BQCDQ = "SXBQDDKQ";

			}
			/// <summary>
			/// 提扣。标签。PE膜出库
			/// </summary>
			internal static void YwlTKPEBQ_Auto()
			{
			LogHelper.CoCo(DateTime.Now + "标签-提扣-PE膜->>>>>>>>>>>> ", ConsoleColor.Cyan);
			@@ -1281,10 +1304,12 @@
			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();

			/// 人工堆叠区纸箱和标签是按标识+物料筛选进行入库转运。
			/// 物料名称包含对应种类进行入库。
			var locsFirst = locsFirstA.FindAll(x => x.S_NOTE.Contains("标签-") && x.S_TYPE == WJ_BQ.RK_BBHJQ);
			var SlocsFirst = locsFirstA.FindAll(x => x.S_NOTE.Contains("标签-") && x.S_TYPE == SX_BQ.RK_BBHJQ);
			var TKlocsFirst = locsFirstA.FindAll(x => x.S_NOTE.Contains("提扣-"));
			@@ -1301,11 +1326,19 @@
			{
			try
			{
			var yuworders = LocationHelper.GetList<YWLWorkOrder>(x => x.SQL_PLineNo == "无菌标签出库" && x.WorkType == 6 && x.SQL_State == "执行中").FindAll(x => x.OutNum > 0 && DateTime.Now.Subtract(x.SQL_Modify_TIme ?? DateTime.Now).TotalSeconds > 10).OrderBy(x => !string.IsNullOrEmpty(x.TagOver) ? 1 : 2).ThenBy(x => x.TagOverTime).ToList();
			var yuworders = LocationHelper.GetList<YWLWorkOrder>(x => x.SQL_PLineNo == "无菌标签出库" && x.WorkType == 6 && x.SQL_State == "执行中").FindAll(x => x.OutNum > 0 && DateTime.Now.Subtract(x.SQL_Modify_TIme ?? DateTime.Now).TotalSeconds > 10).OrderBy(x => x.TagOverTime).ToList();
			if (!yuworders.Any())
			{
			YwlBQ_CreInwork(locsFirst, WJ_BQ.RK_BQDDQ, WJ_BQ.RK_BBHJQ);
			}
			else
			{
			LogHelper.Info($" 无菌出库工单开启中 ");
			// 标签出库。货架直接出到线边
			YwlBQ_CreWJOutOrder();
			}

			// 标签无菌退库。
			YwlBQ_CreWJTK();
			}
			catch (Exception ex)
			@@ -1320,7 +1353,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 => 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 +1364,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 +1389,7 @@
			}
			else if (Syuworders.Any())
			{
			YwlBQ_CreSXOutOrder(plc, Syuworders);
			YwlBQ_CreSXOutOrder(plc, Syuworders.FindAll(x => x.OutNum > 0));
			}
			}
			catch (Exception ex)
			@@ -1387,23 +1415,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 +1462,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 +1513,24 @@
			else
			//YwlPETKOutOrder("YWLTKMKQ", "", "PE叉运");// PE小出库
			{
			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;
			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 => x.TagOverTime).ToList();
			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 +1551,7 @@
			LogHelper.CErrorLog("小水出库：" + (order.SQL_WorkNo) + "没有【指定物料；");
			goto retuse;
			}
			LogHelper.Info("-收缩膜出库！" + oic + oin);

			string v = "YWLTKMKQ";
			int ord = -1;
			@@ -1541,15 +1578,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 +1612,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);
			@@ -1715,13 +1757,13 @@
			Console.WriteLine($"{v.FirstOrDefault()?.S_LOC_CODE} 需要退库-- 自动退库-未实现");
			}
			}

			//标签退库。线边转到货架。
			private static void YwlBQ_CreWJTK()
			{
			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 +1786,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 +1876,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)
			{
			@@ -2152,6 +2197,7 @@
			//LogHelper.Info($"{plc.deviceName}-标签{tagLoc.S_LOC_CODE}//{DeviceProcess.doorStatus[ploc]?.info}-----{(!string.IsNullOrEmpty(ploc) && plc != null && DeviceProcess.doorStatus[ploc]?.info == "1")}");
			if (tagLoc != null)
			{
			// 这里都是1层的，所以必走 current_num =1
			if (tagLoc.N_LAYER == 1 \|\| tagLoc.N_CURRENT_NUM == 1)
			{
			// 直接出提升机位
			@@ -2245,7 +2291,7 @@
			}

			/// <summary>
			///
			/// 标签入库。从人工绑定区到货架区。
			/// </summary>
			/// <param name="locsFirst"></param>
			internal static void YwlBQ_CreInwork(List<locCntItem> locsFirst, string RK_BQDDQ, string RK_BBHJQ)
			@@ -2280,11 +2326,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 +2502,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 +2627,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 => x.TagOverTime).ToList();

			//foreach (var order in yuworders)
			retuse:
			@@ -2578,6 +2643,7 @@
			yuworders.Remove(order);
			goto retuse;
			}

			var oto = new List<string>();
			//if (!string.IsNullOrEmpty(order.TagOver))
			// oto = order.TagOver.Split(',').ToList();
			@@ -2626,7 +2692,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 +2704,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 +3046,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 +3187,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 +3341,7 @@
			LogHelper.Info($"备货单：{outOer.S_Work_NO} 最后移库库区{ea} - 排{er} 怎么他妈是空的！！！诡了个异的");
			}
			}

			eaaa:
			if (string.IsNullOrEmpty(end_area))
			{
			@@ -3355,7 +3422,6 @@
			//}
			}
			}


			if (string.IsNullOrEmpty(start_area)
			\|\| string.IsNullOrEmpty(start_row)
			@@ -3501,6 +3567,8 @@
			{
			public string ItemCode { get; set; }
			public string ItemName { get; set; }

			public string S_CJ_NAME { get; set; }
			/// <summary>
			/// 最高层
			/// </summary>
			@@ -3508,11 +3576,72 @@

			public string area { get; set; }

			public string Row { get; set; }
			/// <summary>
			/// 排
			/// </summary>
			public int Row { get; set; }

			}
			/// <summary>
			/// 原物料纸箱出库
			/// </summary>
			public static void AutoRun13TSJ()
			{

			Action<YWLWorkOrder> _sAB没物料或者余量不足开始触发跟根据自动转运_名字越长越好 = (od) =>
			{
			LogHelper.Info($"AutoRun13TSJ{od.SQL_WorkNo}对应工单的{od.S_ROW} 物料数量不足。触发转运。");
			// 先看是否有到该库区的转运任务。
			var zxs = LocationHelper.GetList<YWLZXtake>(X => X.S_ZX_STATE == "执行" && X.S_END_AREA == od.S_ROW);
			//1.查看物料是否匹配。
			var itemTRUN = zxs.Any(x => x.S_ITEM_CODE == od.SQL_ItemCode && x.S_ITEM_NAME == od.SQL_ItemName && x.S_CJ_NAME == od.S_CJ_NAME);
			if (itemTRUN)
			{ //有到该库区的物料转运任务了。不需要继续了。

			LogHelper.Info($"AutoRun13TSJ{od.SQL_WorkNo}已经存在转运了无需触发转运。");
			return;
			}
			//人工转运没指定物料，我会自动写回转运单物料数据。

			//找CD 区哪里有这个物料。
			Dictitems TrunStart = null;
			foreach (var area in CDlist)
			{
			if (dsi.TryGetValue(area, out var dictitems1))
			{
			var arearowsloc = LocationHelper.GetAreaNormalLocList(area);
			foreach (var d in dictitems1.FindAll(x => x.ItemCode == od.SQL_ItemCode && x.ItemName == od.SQL_ItemName && x.S_CJ_NAME == od.S_CJ_NAME))
			{
			if (arearowsloc.Exists(x => x.N_ROW == d.Row))
			{
			TrunStart = d;
			break;
			}
			}
			}
			}

			LogHelper.Info($"AutoRun13TSJ{od.SQL_WorkNo}触发转运。转运来源是{JsonConvert.SerializeObject(TrunStart)}");
			if (TrunStart != null)
			WCSHelper.Do(db =>
			{
			db.Insertable(new YWLZXtake
			{
			S_START_AREA = TrunStart.area,
			N_START_ROW = TrunStart.Row,
			S_END_AREA = od.S_ROW,
			S_ZX_STATE = "执行",
			S_ITEM_CODE = od.SQL_ItemCode,
			S_ITEM_NAME = od.SQL_ItemName,
			S_CJ_NAME = od.S_CJ_NAME,
			S_ZZ_AREA = (od.S_ROW == "YWLAQWJ" ? "YWLWJJB" : od.S_ROW)
			}).ExecuteCommand();
			});
			};

			//var TaskSiggg = Settings.GetTimeStamp();
			//var list = new List<string>() { "YWLAQWJ", "YWLBQWJ", "YWLCQSX", "YWLDQWJ" };
			//var WorkOrder = new List<YWLWorkOrder>();
			foreach (var PLC in Settings.GetDeviceInfoList().FindAll(X => X.deviceType == 13 && X.enable == 1))
			{
			string pline = PLC.deviceName;
			@@ -3520,7 +3649,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 +3659,56 @@
			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);
			l2.Remove(od.TagOver);
			var odsr = new List<string> { od.TagOver, od.S_ROW }.Concat(l2).Distinct().ToList();

			///汇总仓库里最大层是几层。
			Dictitems Lart = null;
			foreach (var area in od.S_ROW.Split('$'))
			foreach (var area in odsr)//od.S_ROW.Split('$'))
			{
			if (string.IsNullOrEmpty(area)) continue;

			if (dsi.TryGetValue(area, out var dictitems1))
			{
			foreach (var d in dictitems1.FindAll(x => x.ItemCode == od.SQL_ItemCode && x.ItemName == od.SQL_ItemName))
			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;
			@@ -3554,97 +3720,154 @@
			}
			}
			}

			//等下要检测，如果没有可用排，或者AB库区内物料数<5 就要从CD 开始转运。
			var autoTurn = false;
			LogHelper.Info($"AutoRun13TSJ 筛选物料库区排数据. {od.SQL_PLineNo} >>{od.OutNum}> {JsonConvert.SerializeObject(Lart)}");
			// 需要数量 >= 仓库最大数量。就开始出库。
			if (od.OutNum >= Lart?.ItemLayer)
			if (Lart != null)
			{
			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 (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("AutoRun13TSJ" + rl.S_LOC_CODE + "识别托盘类型。" + JsonConvert.SerializeObject(_clrel0));
			var _clcntitem = ContainerHelper.GetCntrItemRel(_clrel0.S_CNTR_CODE.Trim()).FirstOrDefault();
			LogHelper.Info("AutoRun13TSJ" + rl.S_LOC_CODE + "识别托盘上的物料信息。" + JsonConvert.SerializeObject(_clcntitem));
			if (_clcntitem != null)
			{
			StartBit = rl;
			break;
			LogHelper.Info("AutoRun13TSJ" + "相互是否匹配 _clcntitem S_ITEM_CODE:" + _clcntitem.S_ITEM_CODE + " od" + od.SQL_ItemCode + " _clcntitem S_ITEM_NAME:" + _clcntitem.S_ITEM_NAME + "od: " + od.SQL_ItemName + " od.S_CJ_NAME:" + od.S_CJ_NAME + "结果:" + (_clcntitem.S_ITEM_CODE == od.SQL_ItemCode && _clcntitem.S_ITEM_NAME == od.SQL_ItemName && _clcntitem.S_CJ_NAME == od.S_CJ_NAME));
			if (_clcntitem.S_ITEM_CODE == od.SQL_ItemCode && _clcntitem.S_ITEM_NAME == od.SQL_ItemName && _clcntitem.S_CJ_NAME == od.S_CJ_NAME)
			{
			StartBit = rl;
			break;
			}
			}
			}
			if (StartBit != null)
			break;
			}
			if (StartBit == null)
			{
			autoTurn = true;
			LogHelper.Info("AutoRun13TSJ" + $"{od.SQL_PLineNo} 出库 {Lart.area}区域没有物料可用起点");
			continue;
			}
			else
			{
			//检测指定库区的物料排总数量
			if (dsi.TryGetValue(od.S_ROW, out var dictitems1))
			{
			var rows = dictitems1.Select(x => x.Row).Distinct();
			var loclist = LocationHelper.GetLocList(x => x.S_AREA_CODE == od.S_ROW && rows.Contains(x.N_ROW));
			var count = loclist.FindAll(x => x.N_CURRENT_NUM > 0 && x.S_LOCK_STATE == "无").Sum(x => x.N_CURRENT_NUM);
			LogHelper.Info("AutoRun13TSJ" + $"od.S_ROW 出库余量判断是否需要转运。-{count}< 5");
			if (count < 5)
			{
			autoTurn = true;
			_sAB没物料或者余量不足开始触发跟根据自动转运_名字越长越好(od);
			}
			}
			}
			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")
			{
			Endbit = LocationHelper.GetLoc(PLC.location[0]);
			}
			}
			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 (StartBit.N_CURRENT_NUM == 1)
			{
			EndBit = "YWLWJJB";
			}
			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)
			{

			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")
			if (loc?.N_CURRENT_NUM == 0 && DeviceProcess.doorStatus.ContainsKey(PLC.location[0]))
			{
			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)
			if (DeviceProcess.doorStatus[PLC.location[0]].info == "1")
			{
			db.Deleteable(row).ExecuteCommand();
			db.Insertable(r).ExecuteCommand();
			Endbit = LocationHelper.GetLoc(PLC.location[0]);
			}
			}
			else db.Insertable(r).ExecuteCommand();
			if (Endbit == null)
			break;
			}
			break;
			else
			{
			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 jbbit = "";
			if (od.S_ROW == "YWLCQSX" \|\| od.S_ROW == "YWLDQWJ" \|\| Endbit.S_AREA_CODE == "YWLDQWJ" \|\| Endbit.S_AREA_CODE == "YWLCQSX")
			{
			var locs1 = LocationHelper.GetList<Location>(x => x.S_AREA_CODE == "YWLWJJB" && x.S_LOCK_STATE != "报废" && x.S_LOCK_STATE == "无" && x.N_CURRENT_NUM == 0).ToList();
			if (locs1.Count() > 0)
			{
			jbbit = locs1.FirstOrDefault().S_LOC_CODE;
			}
			else
			{
			continue;
			}
			}
			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;
			od.TagOver = StartBit.S_AREA_CODE;
			db.Updateable(od).UpdateColumns(it => new { it.TagOverTime, it.TagOver }).ExecuteCommand();
			//break;
			}
			}
			else
			{
			LogHelper.Info($"{od.SQL_PLineNo} 出库起点{StartBit.S_LOC_CODE}-{StartBit.N_CURRENT_NUM},没有可用终点");
			continue;
			}
			}
			}
			else
			{
			_sAB没物料或者余量不足开始触发跟根据自动转运_名字越长越好(od);
			}
			}
			}
			}
			public static void AutoRunABD()
			{
			LogHelper.Info($"AutoRunABD abcd物料汇总 >>{ReadCCK}\|\| {dsi.Count}");
			if (!ReadCCK)
			{
			Thread.Sleep(3000);
			@@ -3658,10 +3881,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 +3898,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,14 +3913,14 @@
			{
			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.Row == rl.N_ROW && x.ItemCode == _clcntitem.S_ITEM_CODE && x.ItemName == _clcntitem.S_ITEM_NAME && _clcntitem.S_CJ_NAME == x.S_CJ_NAME);
			if (ill != null)
			{
			if (rl.N_CURRENT_NUM > ill.ItemLayer)
			{
			ill.ItemLayer = rl.N_CURRENT_NUM;
			ill.area = area;
			ill.Row = $"{rl.S_LOC_CODE}";
			ill.Row = rl.N_ROW;
			}
			else continue;
			}
			@@ -3697,8 +3929,9 @@
			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}"
			Row = rl.N_ROW
			});
			dsi[area] = dictitems;
			}
			@@ -3710,14 +3943,16 @@
			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}"
			Row = rl.N_ROW
			});
			dsi.Add(area, dictitems);
			}
			}
			}
			}
			LogHelper.Info($"AutoRunABD abcd物料汇总完成 >>{ReadCCK}\|\| {dsi.Count}");
			}

			public static void chargeCCD()
			@@ -3735,6 +3970,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,9 +4026,10 @@
			var locS = LocationHelper.GetAreaNormalLocList(ODs.Key);
			foreach (var od in ODs)
			{
			LogHelper.Info($"YWL_ZX_Turn from{od.S_START_AREA} mid:{od.S_ZZ_AREA} to{od.S_END_AREA} 开始》》》");
			if (string.IsNullOrEmpty(od.S_ZZ_AREA) \|\| string.IsNullOrEmpty(od.S_END_AREA))
			{
			LogHelper.CError($"from{od.S_START_AREA} mid:{od.S_ZZ_AREA} to{od.S_END_AREA} 数据缺失。无法完成移库。");
			LogHelper.CError($"YWL_ZX_Turn from{od.S_START_AREA} mid:{od.S_ZZ_AREA} to{od.S_END_AREA} 数据缺失。无法完成移库。");
			continue;
			}
			var rows = locS.FindAll(x => x.N_ROW == od.N_START_ROW);
			@@ -3809,11 +4046,23 @@
			var lastful = rows.FindAll(x => x.N_CURRENT_NUM > 0).OrderBy(x => x.N_COL).LastOrDefault();
			if (lastful != null)
			{
			LogHelper.Info($"YWL_ZX_Turn 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($"YWL_ZX_Turn 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 (!string.IsNullOrEmpty(od.S_ITEM_CODE))
			{
			///给移库单写上转运的物料数据。
			od.S_ITEM_CODE = cir1.S_ITEM_CODE;
			od.S_ITEM_NAME = cir1.S_ITEM_NAME;
			od.S_CJ_NAME = cir1.S_CJ_NAME;
			WCSHelper.Do(db => db.Updateable(od).UpdateColumns(it => new { it.S_ITEM_NAME, it.S_ITEM_CODE, it.S_CJ_NAME }).ExecuteCommand());
			}

			if (od.S_ZZ_AREA == "YWLWJJB")
			{
			if (InworkLock)
			@@ -3821,7 +4070,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 +4083,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 +4096,11 @@
			break;
			}
			}
			LogHelper.Info($"YWL_ZX_Turn from{od.S_START_AREA} mid:{od.S_ZZ_AREA} to{od.S_END_AREA} 找到移库终点》{Endbit?.S_LOC_CODE}");
			if (Endbit != null)
			{
			//生成接驳区任务，标记为终点库区。
			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;
			}