WMSPrjInstance/HH-0014_NongFu_QingXi.git

			@@ -1413,403 +1413,462 @@

			public static string RK_BQCDQ = "SXBQDDKQ";

			/// <summary>
			/// 中水线边
			/// </summary>
			public static string YWLZSXBKQ = "YWLZSXBKQ";


			}

			public static bool LocLock(string AreaCode)
			{
			try
			{
			var db = new SqlHelper<object>().GetInstance();
			var TaskListNum = db.Queryable<Location>().Where(l => l.S_AREA_CODE == AreaCode && (l.S_LOCK_STATE == "出库锁" \|\| l.S_LOCK_STATE == "入库锁")).ToList();
			if (TaskListNum.Any())
			{
			return false;
			}
			else
			{
			return true;
			}
			}
			catch (Exception ex)
			{

			return false;
			}
			}
			public static object NewLock = new object();
			/// <summary>
			/// 提扣。标签。PE膜出库
			/// </summary>
			internal static void YwlTKPEBQ_Auto()
			{
			LogHelper.CoCo(DateTime.Now + "标签-提扣-PE膜->>>>>>>>>>>> ", ConsoleColor.Cyan);
			var locsFirst1 = LocationHelper.GetAreaNormalLocList(BQ_PRA.YWLRGDD);
			var db = new SqlHelper<object>().GetInstance();
			var locsFirstA = db.Queryable<LocCntrRel>()//标签绑定必须都是单层。 - 涉及堆叠与货架1层问题。
			.InnerJoin<CntrItemRel>((lcr, cir) => lcr.S_CNTR_CODE == cir.S_CNTR_CODE)
			//.LeftJoin<ItemInfo>((lcr, cir, item) => cir.S_ITEM_CODE == item.S_ITEM_CODE && cir.S_ITEM_NAME == item.S_ITEM_NAME)
			.InnerJoin<Location>((lcr, cir, lo) => lcr.S_LOC_CODE == lo.S_LOC_CODE)
			.Where((lcr, cir, lo) =>/* cir.S_ITEM_NAME.Contains("标签")&& */ locsFirst1.Select(x => x.S_LOC_CODE).Contains(lo.S_LOC_CODE) && lo.S_AREA_CODE == BQ_PRA.YWLRGDD)
			.Select((lcr, cir, lo) => new locCntItem
			{
			N_CURRENT_NUM = lo.N_CURRENT_NUM,
			S_TYPE = lcr.S_TYPE,
			S_LOC_CODE = lo.S_LOC_CODE,
			S_AREA_CODE = lo.S_AREA_CODE,
			N_ROW = lo.N_ROW,
			N_COL = lo.N_COL,
			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_ITEM_CODE = cir.S_ITEM_CODE,
			S_ITEM_NAME = cir.S_ITEM_NAME,
			S_BATCH_NO = cir.S_BATCH_NO,
			S_CJ_NAME = cir.S_CJ_NAME,
			S_CNTR_CODE = cir.S_CNTR_CODE
			})
			.ToList();
			/// 人工堆叠区纸箱和标签是按标识+物料筛选进行入库转运。
			/// 物料名称包含对应种类进行入库。
			foreach (var item in locsFirstA)
			lock (NewLock)
			{
			if (!string.IsNullOrEmpty(item.S_BATCH_NO))
			LogHelper.CoCo(DateTime.Now + "标签-提扣-PE膜->>>>>>>>>>>> ", ConsoleColor.Cyan);
			var locsFirst1 = LocationHelper.GetAreaNormalLocList(BQ_PRA.YWLRGDD);
			var db = new SqlHelper<object>().GetInstance();
			var locsFirstA = db.Queryable<LocCntrRel>()//标签绑定必须都是单层。 - 涉及堆叠与货架1层问题。
			.InnerJoin<CntrItemRel>((lcr, cir) => lcr.S_CNTR_CODE == cir.S_CNTR_CODE)
			//.LeftJoin<ItemInfo>((lcr, cir, item) => cir.S_ITEM_CODE == item.S_ITEM_CODE && cir.S_ITEM_NAME == item.S_ITEM_NAME)
			.InnerJoin<Location>((lcr, cir, lo) => lcr.S_LOC_CODE == lo.S_LOC_CODE)
			.Where((lcr, cir, lo) =>/* cir.S_ITEM_NAME.Contains("标签")&& */ locsFirst1.Select(x => x.S_LOC_CODE).Contains(lo.S_LOC_CODE) && lo.S_AREA_CODE == BQ_PRA.YWLRGDD)
			.Select((lcr, cir, lo) => new locCntItem
			{
			N_CURRENT_NUM = lo.N_CURRENT_NUM,
			S_TYPE = lcr.S_TYPE,
			S_LOC_CODE = lo.S_LOC_CODE,
			S_AREA_CODE = lo.S_AREA_CODE,
			N_ROW = lo.N_ROW,
			N_COL = lo.N_COL,
			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_ITEM_CODE = cir.S_ITEM_CODE,
			S_ITEM_NAME = cir.S_ITEM_NAME,
			S_BATCH_NO = cir.S_BATCH_NO,
			S_CJ_NAME = cir.S_CJ_NAME,
			S_CNTR_CODE = cir.S_CNTR_CODE
			})
			.ToList();
			/// 人工堆叠区纸箱和标签是按标识+物料筛选进行入库转运。
			/// 物料名称包含对应种类进行入库。
			foreach (var item in locsFirstA)
			{
			item.S_NOTE = item.S_NOTE + "&" + item.S_BATCH_NO;
			}
			}
			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("提扣-"));
			var PElocsFirst = locsFirstA.FindAll(x => x.S_NOTE.Contains("收缩膜-"));

			//if (mun % 20 == 0)
			//{
			// Console.WriteLine("标签叉运人工绑定区-无菌：" + JsonConvert.SerializeObject(locsFirst));
			// Console.WriteLine("标签叉运人工绑定区-水线：" + JsonConvert.SerializeObject(SlocsFirst));
			//}

			var TASKs = new List<Task>();
			var task1 = Task.Run(() =>
			{
			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 => x.TagOverTime).ToList();
			var yuworders = LocationHelper.GetList<YWLWorkOrder>(x => x.SQL_PLineNo == "无菌标签出库" && x.WorkType == 6 && x.SQL_State == "执行中").FindAll(x => x.OutNum > 0).OrderBy(x => x.TagOverTime).ToList();
			if (!yuworders.Any())
			if (!string.IsNullOrEmpty(item.S_BATCH_NO))
			{
			YwlBQ_CreInwork(locsFirst, WJ_BQ.RK_BQDDQ, WJ_BQ.RK_BBHJQ);
			item.S_NOTE = item.S_NOTE + "&" + item.S_BATCH_NO;
			}
			else
			{
			LogHelper.Info($" 无菌出库工单开启中 ");
			// 标签出库。货架直接出到线边
			YwlBQ_CreWJOutOrder();
			}

			// 标签无菌退库。
			YwlBQ_CreWJTK();
			}
			catch (Exception ex)
			{
			LogHelper.Error(ex.Message, ex);
			}
			});
			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("提扣-"));
			var PElocsFirst = locsFirstA.FindAll(x => x.S_NOTE.Contains("收缩膜-"));

			var plc = Settings.GetDeviceInfoList().Where(a => a.deviceName == "T2提升机").FirstOrDefault();
			var task2 = Task.Run(() =>
			{
			try
			{
			string pline = "T2提升机-标签";
			var Syuworders = LocationHelper.GetList<YWLWorkOrder>(x => x.SQL_PLineNo == pline && x.WorkType == 6 && x.SQL_State == "执行中").FindAll(x => DateTime.Now.Subtract(x.SQL_Modify_TIme ?? DateTime.Now).TotalSeconds > 10).OrderBy(x => 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();
			//if (mun % 20 == 0)
			//{
			// Console.WriteLine("标签叉运人工绑定区-无菌：" + JsonConvert.SerializeObject(locsFirst));
			// Console.WriteLine("标签叉运人工绑定区-水线：" + JsonConvert.SerializeObject(SlocsFirst));
			//}

			var tklist = LocationHelper.GetList<YWLWorkOrder>(x => x.SQL_PLineNo == pline && x.WorkType == 1 && x.SQL_State == "执行中");
			if (!Syuworders.Any())
			var TASKs = new List<Task>();
			var task1 = Task.Run(() =>
			{
			try
			{
			//水线标签入库
			YwlBQ_CreInwork(SlocsFirst, SX_BQ.RK_BQDDQ, SX_BQ.RK_BBHJQ);
			}
			if (tklist.Count() > 0)
			{
			var tk = tklist.FirstOrDefault();
			var loc = LocationHelper.GetLoc(plc.location[0]);
			if (loc.N_CURRENT_NUM > 0 && loc.S_LOCK_STATE == "无")
			// 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();
			var yuworders = LocationHelper.GetList<YWLWorkOrder>(x => x.SQL_PLineNo == "无菌标签出库" && x.WorkType == 6 && x.SQL_State == "执行中").FindAll(x => x.OutNum > 0).OrderBy(x => x.TagOverTime).ToList();
			if (LocLock(WJ_BQ.RK_BBHJQ))
			{
			var rr_clrel = LocationHelper.GetLocCntrRel(loc.S_LOC_CODE);
			if (rr_clrel.FirstOrDefault()?.S_TYPE == BQ_PRA.B && DateTime.Now.Subtract(rr_clrel.FirstOrDefault()?.T_CREATE ?? DateTime.Now).TotalSeconds > 10)
			//标签入库
			YwlBQ_CreInwork(locsFirst, WJ_BQ.RK_BQDDQ, WJ_BQ.RK_BBHJQ);
			}
			if (yuworders.Any())
			{
			LogHelper.Info($" 无菌出库工单开启中 ");
			// 标签出库。货架直接出到线边
			YwlBQ_CreWJOutOrder();
			}

			// 标签无菌退库。
			YwlBQ_CreWJTK();
			}
			catch (Exception ex)
			{
			LogHelper.Error(ex.Message, ex);
			}
			});

			var task11 = Task.Run(() =>
			{
			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 => x.TagOverTime).ToList();
			var yuworders = LocationHelper.GetList<YWLWorkOrder>(x => x.SQL_PLineNo == "中水标签出库" && x.WorkType == 6 && x.SQL_State == "执行中").FindAll(x => x.OutNum > 0).OrderBy(x => x.TagOverTime).ToList();
			if (LocLock(SX_BQ.RK_BBHJQ))
			{
			YwlBQ_CreInwork(locsFirst, SX_BQ.RK_BQDDQ, SX_BQ.RK_BBHJQ);
			}
			if (yuworders.Any())
			{
			LogHelper.Info($" 无菌出库工单开启中 ");
			// 中水标签退库。货架直接出到线边
			ZsBQ_CreWJOutOrder();
			}
			// 中水标签退库。
			ZsBQ_CreWJTK();
			}
			catch (Exception ex)
			{
			LogHelper.Error(ex.Message, ex);
			}
			});

			var plc = Settings.GetDeviceInfoList().Where(a => a.deviceName == "T2提升机").FirstOrDefault();
			var task2 = Task.Run(() =>
			{
			try
			{
			string pline = "T2提升机-小水标签";
			var Syuworders = LocationHelper.GetList<YWLWorkOrder>(x => x.SQL_PLineNo == pline && x.WorkType == 6 && x.SQL_State == "执行中").FindAll(x => DateTime.Now.Subtract(x.SQL_Modify_TIme ?? DateTime.Now).TotalSeconds > 10).OrderBy(x => 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 == "执行中");

			if (LocLock(SX_BQ.RK_BBHJQ))
			{
			//水线标签入库
			YwlBQ_CreInwork(SlocsFirst, SX_BQ.RK_BQDDQ, SX_BQ.RK_BBHJQ);
			}
			if (tklist.Count() > 0)
			{
			var tk = tklist.FirstOrDefault();
			var loc = LocationHelper.GetLoc(plc.location[0]);
			if (loc.N_CURRENT_NUM > 0 && loc.S_LOCK_STATE == "无")
			{
			var s_type = ContainerHelper.GetCntrItemRel(rr_clrel.FirstOrDefault().S_CNTR_CODE).FirstOrDefault()?.N_BQ_TRAY_TYPE ?? 0;
			if (s_type == 0)
			var rr_clrel = LocationHelper.GetLocCntrRel(loc.S_LOC_CODE);
			if (rr_clrel.FirstOrDefault()?.S_TYPE == BQ_PRA.B && DateTime.Now.Subtract(rr_clrel.FirstOrDefault()?.T_CREATE ?? DateTime.Now).TotalSeconds > 10)
			{
			LogHelper.CErrorLog($"{tk.SQL_WorkNo}-{tk.SQL_PLineNo} 退库工单开启，绑定的零整标记");
			}
			Location Endbit = null;
			// var hjs = LocationHelper.GetList<Location>(x => x.S_AREA_CODE == SX_BQ.RK_BBHJQ).FindAll(x => x.S_LOCK_STATE == "无" && x.N_CURRENT_NUM == 0);
			// var hjs = db.Queryable<Location>().Where(l => l.S_AREA_CODE == SX_BQ.RK_BBHJQ && l.S_LOCK_STATE.Trim() == "无").ToList();
			var hjs = LocationHelper.GetAreaNormalLocList(SX_BQ.RK_BBHJQ, true, false);
			Endbit = hjs.FindAll(x => 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("", loc.S_LOC_CODE.Trim(), Endbit.S_LOC_CODE, "标签叉运-SX标签退库", rr_clrel.Select(x => x.S_CNTR_CODE).ToList(), 1, 1, 1, 62);
			LogHelper.CSucessLog($"from {loc.S_LOC_CODE} to {Endbit.S_LOC_CODE} 标签叉运-SX标签退库，创建{re}");
			var s_type = ContainerHelper.GetCntrItemRel(rr_clrel.FirstOrDefault().S_CNTR_CODE).FirstOrDefault()?.N_BQ_TRAY_TYPE ?? 0;
			if (s_type == 0)
			{
			LogHelper.CErrorLog($"{tk.SQL_WorkNo}-{tk.SQL_PLineNo} 退库工单开启，绑定的零整标记");
			}
			Location Endbit = null;
			// var hjs = LocationHelper.GetList<Location>(x => x.S_AREA_CODE == SX_BQ.RK_BBHJQ).FindAll(x => x.S_LOCK_STATE == "无" && x.N_CURRENT_NUM == 0);
			// var hjs = db.Queryable<Location>().Where(l => l.S_AREA_CODE == SX_BQ.RK_BBHJQ && l.S_LOCK_STATE.Trim() == "无").ToList();
			var hjs = LocationHelper.GetAreaNormalLocList(SX_BQ.RK_BBHJQ, true, false);
			Endbit = hjs.FindAll(x => 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("", loc.S_LOC_CODE.Trim(), Endbit.S_LOC_CODE, "标签叉运-SX标签退库", rr_clrel.Select(x => x.S_CNTR_CODE).ToList(), 1, 1, 1, 62);
			LogHelper.CSucessLog($"from {loc.S_LOC_CODE} to {Endbit.S_LOC_CODE} 标签叉运-SX标签退库，创建{re}");
			}
			}
			}
			}
			}
			else if (Syuworders.Any())
			{
			YwlBQ_CreSXOutOrder(plc, Syuworders.FindAll(x => x.OutNum > 0));
			}
			}
			catch (Exception ex)
			{
			LogHelper.Error(ex.Message, ex);
			}
			});
			var task3 = Task.Run(() =>
			{
			try
			{
			//return;
			YwlPETKtkOrder("YWLZSXBKQ", "YWLTKMKQ", "提扣叉运");//提扣中水退库。
			YwlPETKOutOrder("YWLTKMKQ", "YWLZSXBKQ", "提扣叉运", 1);//提扣中水出库
			}
			catch (Exception ex)
			{
			LogHelper.Error(ex.Message, ex);
			}
			});
			var task4 = Task.Run(() =>
			{
			try
			{
			//return;
			///起点数据。终点库区堆叠层数。
			YwlPETK_CreInwork(PElocsFirst, "YWLTKMKQ", "收缩膜叉运", 2);//PE膜
			YwlPETK_CreInwork(TKlocsFirst, "YWLTKMKQ", "提扣叉运", 1); //提扣
			//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 loc = LocationHelper.GetLoc(plc.location[0]);
			if (loc.N_CURRENT_NUM > 0 && loc.S_LOCK_STATE == "无")
			else if (Syuworders.Any())
			{
			var rr_clrel = LocationHelper.GetLocCntrRel(loc.S_LOC_CODE);
			if (rr_clrel.FirstOrDefault()?.S_TYPE == BQ_PRA.B && DateTime.Now.Subtract(rr_clrel.FirstOrDefault()?.T_CREATE ?? DateTime.Now).TotalSeconds > 10)
			{
			var cir = ContainerHelper.GetCntrItemRel(rr_clrel.FirstOrDefault().S_CNTR_CODE).FirstOrDefault();
			if (cir == null)
			{ LogHelper.CErrorLog($"{loc.S_LOC_CODE} 没有托盘物料数据！！"); return; }
			var s_type = cir?.N_BQ_TRAY_TYPE ?? 0;
			if (s_type == 0)
			{
			LogHelper.CErrorLog($"{tk.SQL_WorkNo}-{tk.SQL_PLineNo} 退库工单开启，绑定的零整标记");
			}
			Location Endbit = null;
			//Endbit = hjs.FindAll(x => 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("", loc.S_LOC_CODE.Trim(), Endbit.S_LOC_CODE, "收缩膜叉运-T2退库", rr_clrel.Select(x => x.S_CNTR_CODE).ToList(), 1, 1, 1, 62);
			// LogHelper.CSucessLog($"from {loc.S_LOC_CODE} to {Endbit.S_LOC_CODE} 标签叉运-T2退库，创建{re}");
			//}
			string v = "YWLTKMKQ";
			var rklist = LocationHelper.GetRowLock(v);
			int hof = (s_type == .5 ? 1 : (s_type == .75 ? 2 : 3));
			YwlBQ_CreSXOutOrder(plc, Syuworders.FindAll(x => x.OutNum > 0));
			}
			}
			catch (Exception ex)
			{
			LogHelper.Error(ex.Message, ex);
			}
			});
			var task3 = Task.Run(() =>
			{
			try
			{
			//return;
			YwlPETKtkOrder("YWLZSXBKQ", "YWLTKMKQ", "提扣叉运");//提扣中水退库。
			YwlPETKOutOrder("YWLTKMKQ", "YWLZSXBKQ", "提扣叉运", 1);//提扣中水出库
			YwlPEZsOutOrder("YWLTKMKQ", "YWLZSXBKQ", "中水膜叉运", 1);//中水出库
			}
			catch (Exception ex)
			{
			LogHelper.Error(ex.Message, ex);
			}
			});
			var task4 = Task.Run(() =>
			{
			try
			{
			//return;
			///起点数据。终点库区堆叠层数。
			YwlPETK_CreInwork(PElocsFirst, "YWLTKMKQ", "收缩膜叉运", 2);//PE膜
			YwlPETK_CreInwork(TKlocsFirst, "YWLTKMKQ", "提扣叉运", 1); //提扣
			//YwlPETKtkOrder("YWLZSXBKQ", "YWLTKMKQ", "收缩膜叉运");
			//YwlPETKOutOrder("YWLTKMKQ", "YWLZSXBKQ", "收缩膜叉运");// PE中出库

			var inlock = rklist.Find(x => x.S_LOCK_SRC == (cir.S_ITEM_CODE.Trim() + "&" + cir.S_ITEM_NAME.Trim() + hof) && x.S_LOCK_STATE.Contains("入库锁"));
			Location EndBit = null;
			var NormalList = LocationHelper.GetAreaNormalLocList(v);
			//有入库锁排。能入就入。不能就等。
			if (inlock != null)
			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 loc = LocationHelper.GetLoc(plc.location[0]);
			if (loc.N_CURRENT_NUM > 0 && loc.S_LOCK_STATE == "无")
			{
			var rr_clrel = LocationHelper.GetLocCntrRel(loc.S_LOC_CODE);
			if (rr_clrel.FirstOrDefault()?.S_TYPE == BQ_PRA.B && DateTime.Now.Subtract(rr_clrel.FirstOrDefault()?.T_CREATE ?? DateTime.Now).TotalSeconds > 10)
			{
			var loclist1 = NormalList.FindAll(x => inlock.N_ROW == (x.N_ROW));
			foreach (var rs in loclist1.GroupBy(x => x.N_ROW).OrderBy(x => x.Key * -1))
			var cir = ContainerHelper.GetCntrItemRel(rr_clrel.FirstOrDefault().S_CNTR_CODE).FirstOrDefault();
			if (cir == null)
			{ LogHelper.CErrorLog($"{loc.S_LOC_CODE} 没有托盘物料数据！！"); return; }
			var s_type = cir?.N_BQ_TRAY_TYPE ?? 0;
			if (s_type == 0)
			{
			var srloclist = rs.OrderBy(x => x.N_COL).ToList();
			var lastfull = srloclist.FindAll(x => x.N_CURRENT_NUM > 0).LastOrDefault();
			if (lastfull != null)
			LogHelper.CErrorLog($"{tk.SQL_WorkNo}-{tk.SQL_PLineNo} 退库工单开启，绑定的零整标记");
			}
			Location Endbit = null;
			//Endbit = hjs.FindAll(x => 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("", loc.S_LOC_CODE.Trim(), Endbit.S_LOC_CODE, "收缩膜叉运-T2退库", rr_clrel.Select(x => x.S_CNTR_CODE).ToList(), 1, 1, 1, 62);
			// LogHelper.CSucessLog($"from {loc.S_LOC_CODE} to {Endbit.S_LOC_CODE} 标签叉运-T2退库，创建{re}");
			//}
			string v = "YWLTKMKQ";
			var rklist = LocationHelper.GetRowLock(v);
			int hof = (s_type == .5 ? 1 : (s_type == .75 ? 2 : 3));

			var inlock = rklist.Find(x => x.S_LOCK_SRC == (cir.S_ITEM_CODE.Trim() + "&" + cir.S_ITEM_NAME.Trim() + hof) && x.S_LOCK_STATE.Contains("入库锁"));
			Location EndBit = null;
			var NormalList = LocationHelper.GetAreaNormalLocList(v);
			//有入库锁排。能入就入。不能就等。
			if (inlock != null)
			{
			var loclist1 = NormalList.FindAll(x => inlock.N_ROW == (x.N_ROW));
			foreach (var rs in loclist1.GroupBy(x => x.N_ROW).OrderBy(x => x.Key * -1))
			{
			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;
			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;
			}
			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;
			}
			else
			{
			var hasNum = NormalList.FindAll(x => x.N_CURRENT_NUM > 0).Select(x => x.N_ROW).Distinct();
			var EptRowlist = NormalList.FindAll(x => !hasNum.Contains(x.N_ROW));
			if (EptRowlist.Any())
			{
			EndBit = EptRowlist.GroupBy(x => x.N_ROW).OrderBy(x => x.Key * (-1)).FirstOrDefault().ToList().OrderBy(x => x.N_COL).FirstOrDefault();
			}
			}
			if (EndBit != null)
			{
			var res = TaskProcess.CreateTransport("", loc.S_LOC_CODE.Trim(), EndBit.S_LOC_CODE, "收缩膜叉运-入库", new List<string> { cir.S_CNTR_CODE }, 1, EndBit.N_CURRENT_NUM + 1, 1, 62);
			LogHelper.CSucessLog($"from {loc.S_LOC_CODE} to {EndBit.S_LOC_CODE} {("收缩膜叉运-入库")} ，创建{res} ");

			if (res && inlock == null)
			{
			var r = new RowLock { S_LOCK_SRC = (cir.S_ITEM_CODE.Trim() + "&" + cir.S_ITEM_NAME.Trim() + hof), T_LOCK_TIME = DateTime.Now, S_LOCK_STATE = "入库锁", S_AREA_CODE = EndBit.S_AREA_CODE, N_ROW = EndBit.N_ROW };
			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();
			}
			}
			Thread.Sleep(1000);

			}
			}
			}
			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 => 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);
			//}
			}
			if (order != null)
			{
			var Porder = WCSHelper.GetWorkOrder(order.SQL_LinkLineNO);
			if (Porder == null)
			{
			LogHelper.CErrorLog("小水出库：" + (order.SQL_LinkLineNO) + "没有【执行中】的工单");
			yuworders.Remove(order);
			goto retuse;
			}
			var oto = new List<string>();
			//if (!string.IsNullOrEmpty(order.TagOver))
			// oto = order.TagOver.Split(',').ToList();
			var oic = order.SQL_ItemCode?.Trim();
			var oin = order.SQL_ItemName?.Trim();
			if (string.IsNullOrEmpty(oic) \|\| string.IsNullOrEmpty(oin))
			{
			LogHelper.CErrorLog("小水出库：" + (order.SQL_WorkNo) + "没有【指定物料；");
			goto retuse;
			}
			LogHelper.Info("-收缩膜出库！" + oic + oin);

			string v = "YWLTKMKQ";
			int ord = -1;
			locCntItem StartBit = null;
			Location EndBit = null;
			CntrItemRel cir = null;
			var rklist = LocationHelper.GetRowLock(v);
			var outlock = rklist.Find(x => x.S_AREA_CODE == v && x.S_LOCK_SRC == (oic + "&" + oin) && x.S_LOCK_STATE.Contains("出库锁"));
			var NormalList = LocationHelper.GetAreaNormalLocList(v);
			if (outlock != null)
			{
			NormalList = NormalList.FindAll(x => outlock.N_ROW == (x.N_ROW));
			}
			var taglist = new List<string>() { oic };
			foreach (var item in NormalList.GroupBy(X => X.N_ROW).OrderBy(x => x.Key * ord))
			{
			locCntItem Temp = null;
			var y = item.OrderBy(x => x.N_COL).ToList();
			var lastfull = y.FindAll(x => x.N_CURRENT_NUM > 0).LastOrDefault();
			if (lastfull != null)
			{
			var CNTR = LocationHelper.GetList<LocCntrRel>(x => x.S_LOC_CODE == lastfull.S_LOC_CODE);
			if (!CNTR.Any()) continue;
			var cirs = ContainerHelper.GetCntrItemRel(CNTR.FirstOrDefault().S_CNTR_CODE);
			if (!cirs.Any()) continue;
			cir = cirs.OrderByDescending(x => x.T_CREATE).FirstOrDefault();
			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_CJ_NAME = cir.S_CJ_NAME
			};
			if (outlock != null)
			{
			StartBit = Temp;
			break;
			}
			}
			if (Temp != null)
			{
			if (StartBit == null)
			StartBit = Temp;
			else if (StartBit.HalfOrFull > Temp.HalfOrFull)
			{
			StartBit = Temp;
			}
			if (StartBit.HalfOrFull == 1) break;
			}
			}
			}
			if (StartBit != null)
			{
			var tagLoc = StartBit;
			// 直接出提升机位

			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 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)
			{
			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
			{
			var hasNum = NormalList.FindAll(x => x.N_CURRENT_NUM > 0).Select(x => x.N_ROW).Distinct();
			var EptRowlist = NormalList.FindAll(x => !hasNum.Contains(x.N_ROW));
			if (EptRowlist.Any())
			{
			EndBit = EptRowlist.GroupBy(x => x.N_ROW).OrderBy(x => x.Key * (-1)).FirstOrDefault().ToList().OrderBy(x => x.N_COL).FirstOrDefault();
			}
			LogHelper.Info(order.SQL_PLineNo + "-收缩膜出库！没有可用物料");
			}
			if (EndBit != null)
			var set1 = new HashSet<string>(oto);
			var set2 = new HashSet<string>(taglist);

			if (set1.SetEquals(set2))
			{
			var res = TaskProcess.CreateTransport("", loc.S_LOC_CODE.Trim(), EndBit.S_LOC_CODE, "收缩膜叉运-入库", new List<string> { cir.S_CNTR_CODE }, 1, EndBit.N_CURRENT_NUM + 1, 1, 62);
			LogHelper.CSucessLog($"from {loc.S_LOC_CODE} to {EndBit.S_LOC_CODE} {("收缩膜叉运-入库")} ，创建{res} ");
			//order.OutNum++;

			if (res && inlock == null)
			{
			var r = new RowLock { S_LOCK_SRC = (cir.S_ITEM_CODE.Trim() + "&" + cir.S_ITEM_NAME.Trim() + hof), T_LOCK_TIME = DateTime.Now, S_LOCK_STATE = "入库锁", S_AREA_CODE = EndBit.S_AREA_CODE, N_ROW = EndBit.N_ROW };
			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();
			}
			order.OutNum--;
			order.TagOverTime = DateTime.Now;
			//order.TagOver = string.Empty;
			db.Updateable(order).UpdateColumns(it => new { /it.TagOver,/it.OutNum, it.TagOverTime }).ExecuteCommand();
			LogHelper.CSucessLog($"{order.SQL_PLineNo}-{order.SQL_LinkLineNO} 标签完成。重置数据");
			}
			Thread.Sleep(1000);

			}
			}
			}
			else
			//YwlPETKOutOrder("YWLTKMKQ", "", "PE叉运");// PE小出库
			catch (Exception ex)
			{
			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);
			//}
			}
			if (order != null)
			{
			var Porder = WCSHelper.GetWorkOrder(order.SQL_LinkLineNO);
			if (Porder == null)
			{
			LogHelper.CErrorLog("小水出库：" + (order.SQL_LinkLineNO) + "没有【执行中】的工单");
			yuworders.Remove(order);
			goto retuse;
			}
			var oto = new List<string>();
			//if (!string.IsNullOrEmpty(order.TagOver))
			// oto = order.TagOver.Split(',').ToList();
			var oic = order.SQL_ItemCode?.Trim();
			var oin = order.SQL_ItemName?.Trim();
			if (string.IsNullOrEmpty(oic) \|\| string.IsNullOrEmpty(oin))
			{
			LogHelper.CErrorLog("小水出库：" + (order.SQL_WorkNo) + "没有【指定物料；");
			goto retuse;
			}
			LogHelper.Info("-收缩膜出库！" + oic + oin);

			string v = "YWLTKMKQ";
			int ord = -1;
			locCntItem StartBit = null;
			Location EndBit = null;
			CntrItemRel cir = null;
			var rklist = LocationHelper.GetRowLock(v);
			var outlock = rklist.Find(x => x.S_AREA_CODE == v && x.S_LOCK_SRC == (oic + "&" + oin) && x.S_LOCK_STATE.Contains("出库锁"));
			var NormalList = LocationHelper.GetAreaNormalLocList(v);
			if (outlock != null)
			{
			NormalList = NormalList.FindAll(x => outlock.N_ROW == (x.N_ROW));
			}
			var taglist = new List<string>() { oic };
			foreach (var item in NormalList.GroupBy(X => X.N_ROW).OrderBy(x => x.Key * ord))
			{
			locCntItem Temp = null;
			var y = item.OrderBy(x => x.N_COL).ToList();
			var lastfull = y.FindAll(x => x.N_CURRENT_NUM > 0).LastOrDefault();
			if (lastfull != null)
			{
			var CNTR = LocationHelper.GetList<LocCntrRel>(x => x.S_LOC_CODE == lastfull.S_LOC_CODE);
			if (!CNTR.Any()) continue;
			var cirs = ContainerHelper.GetCntrItemRel(CNTR.FirstOrDefault().S_CNTR_CODE);
			if (!cirs.Any()) continue;
			cir = cirs.OrderByDescending(x => x.T_CREATE).FirstOrDefault();
			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_CJ_NAME = cir.S_CJ_NAME
			};
			if (outlock != null)
			{
			StartBit = Temp;
			break;
			}
			}
			if (Temp != null)
			{
			if (StartBit == null)
			StartBit = Temp;
			else if (StartBit.HalfOrFull > Temp.HalfOrFull)
			{
			StartBit = Temp;
			}
			if (StartBit.HalfOrFull == 1) break;
			}
			}
			}
			if (StartBit != null)
			{
			var tagLoc = StartBit;
			// 直接出提升机位

			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 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)
			{
			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);
			var set2 = new HashSet<string>(taglist);

			if (set1.SetEquals(set2))
			{
			//order.OutNum++;

			order.OutNum--;
			order.TagOverTime = DateTime.Now;
			//order.TagOver = string.Empty;
			db.Updateable(order).UpdateColumns(it => new { /it.TagOver,/it.OutNum, it.TagOverTime }).ExecuteCommand();
			LogHelper.CSucessLog($"{order.SQL_PLineNo}-{order.SQL_LinkLineNO} 标签完成。重置数据");
			}
			}
			LogHelper.Error(ex.Message, ex);
			}
			}
			catch (Exception ex)
			{
			LogHelper.Error(ex.Message, ex);
			}
			});
			Task.WaitAll(task1, task2, task3, task4);
			LogHelper.CoCo(DateTime.Now + "标签-提扣-PE膜- Over=============== ", ConsoleColor.Cyan);
			});
			// Task.WaitAll(task1, task2, task3, task4);
			LogHelper.CoCo(DateTime.Now + "标签-提扣-PE膜- Over=============== ", ConsoleColor.Cyan);
			}
			}
			/// <summary>
			/// 提扣，中水退库
			@@ -1826,6 +1885,7 @@
			LeftJoin<LocCntrRel>((l, c) => l.S_LOC_CODE == c.S_LOC_CODE)
			.Where((l, c) => (l.S_AREA_CODE == v1) && c.S_TYPE == BQ_PRA.B)
			.ToList();

			if (v.Any())
			{
			foreach (var area in v.Select(x => x.S_AREA_CODE).Distinct())
			@@ -1843,59 +1903,47 @@
			var cirs = ContainerHelper.GetCntrItemRel(CNTR.FirstOrDefault().S_CNTR_CODE);
			if (!cirs.Any()) continue;
			var cir = cirs.OrderByDescending(x => x.T_CREATE).FirstOrDefault();
			if (CNTR.FirstOrDefault().S_TYPE == BQ_PRA.B)
			if (cirs.FirstOrDefault().S_ITEM_NAME.Contains("标签-"))
			{
			var s_type = ContainerHelper.GetCntrItemRel(CNTR.FirstOrDefault().S_CNTR_CODE).FirstOrDefault()?.N_BQ_TRAY_TYPE ?? 0;
			continue;
			}

			var rklist = LocationHelper.GetRowLock(v2);
			int hof = (s_type == .5 ? 1 : (s_type == .75 ? 2 : 3));
			var inlock = rklist.Find(x => x.S_AREA_CODE == v2 && x.S_LOCK_SRC == (cir.S_ITEM_CODE.Trim() + "&" + cir.S_ITEM_NAME.Trim() + hof) && x.S_LOCK_STATE.Contains("入库锁"));
			Location EndBit = null;
			var NormalList = LocationHelper.GetAreaNormalLocList(v2);
			//有入库锁排。能入就入。不能就等。
			if (inlock != null)
			{
			var loclist1 = NormalList.FindAll(x => inlock.N_ROW == (x.N_ROW));
			foreach (var rs in loclist1.GroupBy(x => x.N_ROW).OrderBy(x => x.Key * -1))
			{
			var srloclist = rs.OrderBy(x => x.N_COL).ToList();
			var lastfull = srloclist.FindAll(x => x.N_CURRENT_NUM > 0).LastOrDefault();
			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;
			}
			}
			else
			{
			var hasNum = NormalList.FindAll(x => x.N_CURRENT_NUM > 0).Select(x => x.N_ROW).Distinct();
			var EptRowlist = NormalList.FindAll(x => !hasNum.Contains(x.N_ROW));
			if (EptRowlist.Any())
			{
			EndBit = EptRowlist.GroupBy(x => x.N_ROW).OrderBy(x => x.Key * (-1)).FirstOrDefault().ToList().OrderBy(x => x.N_COL).FirstOrDefault();
			}
			}
			if (EndBit != null)
			{
			var res = TaskProcess.CreateTransport("", lastfull1.S_LOC_CODE.Trim(), EndBit.S_LOC_CODE, v3 + "-退库", new List<string> { cir.S_CNTR_CODE }, lastfull1.N_CURRENT_NUM, EndBit.N_CURRENT_NUM + 1, 1, 62);
			LogHelper.CSucessLog($"from {lastfull1.S_LOC_CODE} to {EndBit.S_LOC_CODE} {v3}-退库，创建{res} ");
			var ca = Expressionable.Create<Location, LocCntrRel, CntrItemRel>();
			ca.And((o, p, t) => o.N_CURRENT_NUM > 0 && o.S_LOCK_STATE == "无" && t.S_ITEM_CODE == cir.S_ITEM_CODE && t.S_ITEM_NAME == cir.S_ITEM_NAME && t.S_CJ_NAME == cir.S_CJ_NAME && o.S_AREA_CODE == v2);
			var lstCanOutL = db.Queryable<Location>().InnerJoin<LocCntrRel>((o, p) => o.S_LOC_CODE == p.S_LOC_CODE).InnerJoin<CntrItemRel>((o, p, t) => p.S_CNTR_CODE == t.S_CNTR_CODE).Where(ca.ToExpression()).ToList();

			if (res && inlock == null)
			{
			var r = new RowLock { S_LOCK_SRC = (cir.S_ITEM_CODE.Trim() + "&" + cir.S_ITEM_NAME.Trim() + hof), T_LOCK_TIME = DateTime.Now, S_LOCK_STATE = "入库锁", S_AREA_CODE = EndBit.S_AREA_CODE, N_ROW = EndBit.N_ROW };
			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();
			}
			Location EndBit = null;
			var NormalList = LocationHelper.GetAreaNormalLocList(v2);
			NormalList = NormalList.FindAll(e => lstCanOutL.Select(c => c.N_ROW).ToList().Contains(e.N_ROW));
			//有入库锁排。能入就入。不能就等。
			if (NormalList.Count() > 0)
			{
			var loclist1 = NormalList.ToList();
			foreach (var rs in loclist1.GroupBy(x => x.N_ROW).OrderBy(x => x.Key * -1))
			{
			var srloclist = rs.OrderBy(x => x.N_COL).ToList();
			var lastfull = srloclist.FindAll(x => x.N_CURRENT_NUM > 0).LastOrDefault();
			EndBit = srloclist.Find(x => x.S_LOCK_STATE == "无" && x.N_CURRENT_NUM < Math.Min(x.N_CAPACITY, 1) && x.S_LOCK_STATE != "报废" && x.N_COL >= (lastfull?.N_COL ?? 0));
			if (EndBit != null)
			break;
			}
			}
			else
			{
			var hasNum = NormalList.FindAll(x => x.N_CURRENT_NUM > 0).Select(x => x.N_ROW).Distinct();
			var EptRowlist = NormalList.FindAll(x => !hasNum.Contains(x.N_ROW));
			if (EptRowlist.Any())
			{
			EndBit = EptRowlist.GroupBy(x => x.N_ROW).OrderBy(x => x.Key * (-1)).FirstOrDefault().ToList().OrderBy(x => x.N_COL).FirstOrDefault();
			}
			}
			if (EndBit != null)
			{
			var res = TaskProcess.CreateTransport("", lastfull1.S_LOC_CODE.Trim(), EndBit.S_LOC_CODE, v3 + "-退库", new List<string> { cir.S_CNTR_CODE }, lastfull1.N_CURRENT_NUM, EndBit.N_CURRENT_NUM + 1, 1, 62);
			LogHelper.CSucessLog($"from {lastfull1.S_LOC_CODE} to {EndBit.S_LOC_CODE} {v3}-退库，创建{res} ");

			}

			}
			}
			}
			@@ -1905,6 +1953,49 @@
			}
			}
			//标签退库。线边转到货架。
			private static void ZsBQ_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 == SX_BQ.YWLZSXBKQ /\|\| l.S_AREA_CODE == WJ_BQ.RK_BQJBQ/) && c.S_TYPE == BQ_PRA.B)
			.ToList();
			if (v.Any())
			{
			foreach (var area in v.Select(x => x.S_AREA_CODE).Distinct())
			{
			var rowsss = v.FindAll(x => x.S_AREA_CODE == area).Select(x => x.N_ROW).Distinct();
			var locs = LocationHelper.GetAreaNormalLocList(area).FindAll(x => rowsss.Contains(x.N_ROW));
			foreach (var item in locs.GroupBy(x => x.N_ROW))
			{
			var y = item.OrderBy(x => x.N_COL).ToList();
			var lastfull = y.FindAll(x => x.N_CURRENT_NUM > 0).LastOrDefault();
			if (lastfull != null)
			{
			var CNTR = LocationHelper.GetList<LocCntrRel>(x => x.S_LOC_CODE == lastfull.S_LOC_CODE);
			if (!CNTR.Any()) continue;
			var cirs = ContainerHelper.GetCntrItemRel(CNTR.FirstOrDefault().S_CNTR_CODE);
			if (!cirs.Any()) continue;
			var cir = cirs.OrderByDescending(x => x.T_CREATE).FirstOrDefault();
			if (CNTR.FirstOrDefault().S_TYPE == BQ_PRA.B)
			{
			var s_type = ContainerHelper.GetCntrItemRel(CNTR.FirstOrDefault().S_CNTR_CODE).FirstOrDefault()?.N_BQ_TRAY_TYPE ?? 0;
			Location Endbit = null;
			var hjs = LocationHelper.GetAreaNormalLocListAll(SX_BQ.RK_BBHJQ);
			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);
			LogHelper.CSucessLog($"from {lastfull.S_LOC_CODE} to {Endbit.S_LOC_CODE} 标签叉运-接驳标签退库，创建{re}");
			}

			}
			}
			}
			}
			}

			}
			private static void YwlBQ_CreWJTK()
			{
			var db = new SqlHelper<object>().GetInstance();
			@@ -2023,7 +2114,7 @@
			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 && cir.S_CJ_NAME == od.S_CJ_NAME)
			if (cir.S_ITEM_CODE == od.SQL_ItemCode && cir.S_ITEM_NAME == od.SQL_ItemName)
			{
			//plg 2025年6月13日 09:09:25
			Temp = new locCntItem
			@@ -2059,6 +2150,10 @@
			//var rklist = LocationHelper.GetRowLock(v);
			//var inlock = rklist.Find(x => x.S_LOCK_SRC == (cir.S_ITEM_CODE.Trim() + "&" + cir.S_ITEM_NAME.Trim() + (cir.N_BQ_TRAY_TYPE == .5 ? 1 : (cir.N_BQ_TRAY_TYPE == .75 ? 2 : 3))) && x.S_LOCK_STATE.Contains("出库锁"));
			var NormalList2 = LocationHelper.GetAreaNormalLocList(v1);
			if (NormalList2.Any())
			{
			NormalList2 = NormalList2.FindAll(e => e.N_ROW == 2).ToList();
			}
			//if (inlock != null)
			//{
			// var loclist1 = NormalList.FindAll(x => inlock.N_ROW == (x.N_ROW));
			@@ -2081,6 +2176,172 @@
			if (EndBit != null)
			break;
			}
			//}
			//else
			if (EndBit == null)
			{
			var hasNum = NormalList2.FindAll(x => x.N_CURRENT_NUM > 0).Select(x => x.N_ROW).Distinct();
			var EptRowlist = NormalList2.FindAll(x => !hasNum.Contains(x.N_ROW));
			if (EptRowlist.Any())
			{
			EndBit = EptRowlist.GroupBy(x => x.N_ROW).OrderBy(x => x.Key).FirstOrDefault().ToList().OrderBy(x => x.N_COL).FirstOrDefault();
			}
			}

			//foreach (var item in sLocs.GroupBy(X => X.N_ROW).OrderBy(x => x.Key * ord))
			//{
			// var y = item.OrderBy(x => x.N_COL).ToList();
			// var lastfull = y.FindAll(x => x.N_CURRENT_NUM > 0).LastOrDefault();
			// EndBit = y.Find(x => x.N_COL >= (lastfull?.N_COL ?? 0) && x.N_CURRENT_NUM == 0);
			// if (lastfull != null)
			// {
			// var CNTR = LocationHelper.GetList<LocCntrRel>(x => x.S_LOC_CODE == lastfull.S_LOC_CODE);
			// if (!CNTR.Any()) continue;
			// if (CNTR.Find(x => x.S_TYPE == BQ_PRA.B) != null) continue;
			// var cirs = ContainerHelper.GetCntrItemRel(CNTR.FirstOrDefault().S_CNTR_CODE);
			// if (!cirs.Any()) continue;
			// var cir2 = cirs.OrderByDescending(x => x.T_CREATE).FirstOrDefault();
			// if (cir2.S_ITEM_CODE != od.SQL_ItemCode \|\| cir2.S_ITEM_NAME != od.SQL_ItemName)
			// continue;
			// }
			// if (EndBit != null)
			// break;
			//}
			if (EndBit != null)
			{
			var re = TaskProcess.CreateTransport("", StartBit.S_LOC_CODE.Trim(), EndBit.S_LOC_CODE, (oin.Contains("提扣") ? "提扣" : "收缩膜") + "叉运-出库线边", new List<string> { StartBit.S_CNTR_CODE }, StartBit.N_CURRENT_NUM, 1, 1, 62);
			LogHelper.Info($"from {StartBit.S_LOC_CODE} to {EndBit.S_LOC_CODE} {pline}-出库线边，创建{re} ");
			if (re)
			{
			od.TagOverTime = DateTime.Now;
			od.OutNum--;
			WCSHelper.Do(db =>
			{
			db.Updateable(od).UpdateColumns(it => new { it.TagOverTime, it.OutNum }).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 };
			//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
			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();
			}
			});
			}
			break;
			}
			}
			}
			}
			}
			private static void YwlPEZsOutOrder(string v, string v1, string v2, int v3 = 3)
			{
			List<YWLWorkOrder> Orders = new List<YWLWorkOrder>();

			foreach (var pline in new[] { "中水PE膜出库" })
			{
			Orders = 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 => x.TagOverTime).ToList();
			foreach (var od in Orders)
			{
			var oic = od.SQL_ItemCode?.Trim();
			var oin = od.SQL_ItemName?.Trim();
			if (string.IsNullOrEmpty(oic) \|\| string.IsNullOrEmpty(oin))
			{
			LogHelper.CErrorLog("中水PE膜：" + (od.SQL_WorkNo) + "没有【指定物料；");
			continue;
			}
			int ord = oin.Contains("中水") ? 1 : -1;
			locCntItem StartBit = null;
			Location EndBit = null;
			CntrItemRel cir = null;
			var rklist = LocationHelper.GetRowLock(v);
			var outlock = rklist.Find(x => x.S_AREA_CODE == v && x.S_LOCK_SRC == (oic + "&" + oin) && x.S_LOCK_STATE.Contains("出库锁"));
			var NormalList = LocationHelper.GetAreaNormalLocList(v);
			if (outlock != null)
			{
			NormalList = NormalList.FindAll(x => outlock.N_ROW == (x.N_ROW));
			}
			foreach (var item in NormalList.GroupBy(X => X.N_ROW).OrderBy(x => x.Key * ord))
			{
			locCntItem Temp = null;
			var y = item.OrderBy(x => x.N_COL).ToList();
			var lastfull = y.FindAll(x => x.N_CURRENT_NUM > 0).LastOrDefault();
			if (lastfull != null)
			{
			var CNTR = LocationHelper.GetList<LocCntrRel>(x => x.S_LOC_CODE == lastfull.S_LOC_CODE);
			if (!CNTR.Any()) continue;
			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)
			{
			//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,
			S_NOTE = cir.S_ITEM_CODE.Trim() + "&" + cir.S_ITEM_NAME.Trim(),
			S_CJ_NAME = cir.S_CJ_NAME
			};
			if (outlock != null)
			{
			StartBit = Temp;
			break;
			}
			}
			if (Temp != null)
			{
			if (StartBit == null)
			StartBit = Temp;
			else if (StartBit.HalfOrFull > Temp.HalfOrFull)
			{
			StartBit = Temp;
			}
			if (StartBit.HalfOrFull == 1) break;
			}
			}
			}
			//}
			if (StartBit != null)
			{
			//var rklist = LocationHelper.GetRowLock(v);
			//var inlock = rklist.Find(x => x.S_LOCK_SRC == (cir.S_ITEM_CODE.Trim() + "&" + cir.S_ITEM_NAME.Trim() + (cir.N_BQ_TRAY_TYPE == .5 ? 1 : (cir.N_BQ_TRAY_TYPE == .75 ? 2 : 3))) && x.S_LOCK_STATE.Contains("出库锁"));
			var NormalList2 = LocationHelper.GetAreaNormalLocList(v1);
			if (NormalList2.Any())
			{
			NormalList2 = NormalList2.FindAll(e => e.N_ROW == 1).ToList();
			}
			//if (inlock != null)
			//{
			// var loclist1 = NormalList.FindAll(x => inlock.N_ROW == (x.N_ROW));

			var srloclist = NormalList2.OrderBy(x => x.N_COL).ToList();
			var lastfull = srloclist.FindAll(x => x.N_CURRENT_NUM > 0).LastOrDefault();
			if (lastfull != null)
			{
			var CNTR = LocationHelper.GetList<LocCntrRel>(x => x.S_LOC_CODE == lastfull.S_LOC_CODE);
			if (!CNTR.Any()) continue;
			if (CNTR.Find(x => x.S_TYPE == BQ_PRA.B) != null) continue;
			var cirs = ContainerHelper.GetCntrItemRel(CNTR.FirstOrDefault().S_CNTR_CODE);
			if (!cirs.Any()) continue;
			var cir2 = cirs.OrderByDescending(x => x.T_CREATE).FirstOrDefault();
			if (cir2.S_ITEM_CODE != od.SQL_ItemCode \|\| cir2.S_ITEM_NAME != od.SQL_ItemName)
			continue;
			EndBit = srloclist.Find(x => x.S_LOCK_STATE == "无" && x.N_CURRENT_NUM < Math.Min(x.N_CAPACITY, v3) && x.S_LOCK_STATE != "报废" && x.N_COL >= (lastfull?.N_COL ?? 0));
			}
			if (EndBit != null)
			break;

			//}
			//else
			if (EndBit == null)
			@@ -2920,6 +3181,290 @@
			}

			}



			internal static void ZsBQ_CreWJOutOrder()
			{
			LogHelper.Info($" 无菌出库开始");
			//1.检查是否有退库
			var db = new SqlHelper<object>().GetInstance();

			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 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($"循环有无退库==> 有退库" + 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 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($" 无菌出库到线边结束");
			///拆垛区取消。
			///第二段：拆垛区。拆去接驳。或者回库。
			var v = LocationHelper.GetAreaNormalLocList(WJ_BQ.RK_BQCDQ);
			///拆垛的出库。单层的回库单层不入拆垛区
			foreach (var item in v.GroupBy(x => x.N_ROW))
			{
			var y = item.OrderBy(x => x.N_COL).ToList();
			var lastfull = y.FindAll(x => x.N_CURRENT_NUM > 0).LastOrDefault();
			if (lastfull != null)
			{
			var CNTR = LocationHelper.GetList<LocCntrRel>(x => x.S_LOC_CODE == lastfull.S_LOC_CODE);
			if (lastfull.N_CURRENT_NUM == 2)
			{
			if (CNTR.Find(x => x.S_TYPE == BQ_PRA.Out) == null)
			{
			LogHelper.CError($" 开启出库流程。堆叠区是入库堆叠托盘，终止出库。这里可以执行入库。");
			return;
			}
			//拆一个到接驳 - 接驳位排，如果是退库的，就换一排。
			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 == 1)
			{
			var c = LocationHelper.GetList<LocCntrRel>(x => x.S_LOC_CODE == l2.S_LOC_CODE);
			if (c.FirstOrDefault()?.S_TYPE == BQ_PRA.B)
			{
			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("", lastfull.S_LOC_CODE.Trim(), e.S_LOC_CODE, "标签叉运-拆垛接驳", new List<string> { CNTR.FirstOrDefault().S_CNTR_CODE }, 2, 1, 1, 62);
			LogHelper.Info($"from {lastfull.S_LOC_CODE} to {e.S_LOC_CODE} 标签叉运-拆垛接驳，创建{re} ");
			break;
			}
			}
			}
			else
			{
			//回货架
			var hjs = LocationHelper.GetList<Location>(x => x.S_AREA_CODE == WJ_BQ.RK_BBHJQ).FindAll(x => x.S_LOCK_STATE == "无" && x.N_CURRENT_NUM == 0).OrderBy(x => x.N_LAYER).ThenBy(x => x.N_ROW).ThenBy(x => x.N_COL).FirstOrDefault();
			if (hjs != null)
			{
			var re = TaskProcess.CreateTransport("", lastfull.S_LOC_CODE.Trim(), hjs.S_LOC_CODE, "标签叉运-拆垛回", new List<string> { CNTR.FirstOrDefault().S_CNTR_CODE }, 1, 1, 1, 62);
			LogHelper.Info($"from {lastfull.S_LOC_CODE} to {hjs.S_LOC_CODE} 标签叉运-拆垛回，创建{re} ");
			break;
			}
			}
			}
			}
			}

			///第一段：出库 -到拆垛或者接驳。
			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:
			var order = yuworders.FirstOrDefault();
			if (order != null)
			{
			var Porder = WCSHelper.GetWorkOrder(order.SQL_LinkLineNO);
			//if (Porder == null)
			//{
			// LogHelper.CErrorLog("无菌标签出库：" + (order.SQL_LinkLineNO) + "没有【执行中】的工单");
			// yuworders.Remove(order);
			// goto retuse;
			//}

			var oto = new List<string>();
			//if (!string.IsNullOrEmpty(order.TagOver))
			// oto = order.TagOver.Split(',').ToList();
			var oic = order.SQL_ItemCode;
			var oin = order.SQL_ItemName;
			if (string.IsNullOrEmpty(oic) \|\| string.IsNullOrEmpty(oin))
			{
			LogHelper.CErrorLog("中水标签出库：" + (order.SQL_WorkNo) + "没有【指定物料；");
			goto retuse;
			}
			//var item_ = ContainerHelper.GetItem(x => x.S_ITEM_CODE == oic && x.S_ITEM_NAME == oin);

			//按顺序匹配标签，直到完成所有标签。后清空标签，并重置标签完成时间= 当前时间。
			var hjs = db.Queryable<Location>()
			.LeftJoin<LocCntrRel>((l, lc) => l.S_LOC_CODE == lc.S_LOC_CODE)
			.LeftJoin<CntrItemRel>((l, lc, ci) => lc.S_CNTR_CODE == ci.S_CNTR_CODE)
			.Where((l, lc, ci) => l.S_AREA_CODE == SX_BQ.RK_BBHJQ && l.S_LOCK_STATE == "无").Select((l, lc, ci) => new locCntItem
			{
			N_CURRENT_NUM = l.N_CURRENT_NUM,
			S_TYPE = lc.S_TYPE,
			S_LOC_CODE = l.S_LOC_CODE,
			S_AREA_CODE = l.S_AREA_CODE,
			HalfOrFull = (ci.N_BQ_TRAY_TYPE == .5 ? 1 : (ci.N_BQ_TRAY_TYPE == .75 ? 2 : 3)), // 半托为0.5 整托为1 。转换为整数( *2 )。半托为>1，整托>2
			N_LAYER = l.N_LAYER,
			S_NOTE = ci.S_ITEM_CODE.Trim() + "&" + ci.S_ITEM_NAME.Trim(),
			S_ITEM_CODE = ci.S_ITEM_CODE,
			S_ITEM_NAME = ci.S_ITEM_NAME,
			S_CNTR_CODE = ci.S_CNTR_CODE
			}).ToList();
			var taglist = new List<string>() { oic };
			//if (!string.IsNullOrEmpty(item_.S_BQ_NAME))
			// taglist = item_.S_BQ_NAME.Split(',').ToList();
			foreach (var item in taglist)
			{
			//if (oto.Contains(item))
			// continue;
			//var Ii = ContainerHelper.GetItem(x => x.S_ITEM_CODE == item);
			//if (Ii == null)
			//{
			// LogHelper.CError($"{order.SQL_WorkNo} - {order.SQL_PLineNo} - {item} 物料顺序不存在。");
			// return;
			//}
			var tagLoc = hjs.FindAll(x => x.S_ITEM_CODE == oic/* Ii.S_ITEM_CODE/ && x.S_ITEM_NAME == oin /Ii.S_ITEM_NAME x.S_NOTE == (Ii.S_ITEM_CODE + "&" + Ii.S_ITEM_NAME)*/).OrderBy(x => x.HalfOrFull).FirstOrDefault();
			if (tagLoc != null)
			{
			if (tagLoc.N_LAYER == 1 \|\| tagLoc.N_CURRENT_NUM == 1)
			{
			// 直接出接驳位
			var jbqs = LocationHelper.GetAreaNormalLocList(SX_BQ.YWLZSXBKQ);
			if (jbqs.Any())
			{
			jbqs = jbqs.FindAll(e => e.N_ROW == 3).ToList();
			}
			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 == 1)
			{
			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();
			//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);
			LogHelper.Info($"from {tagLoc.S_LOC_CODE} to {e.S_LOC_CODE} 标签叉运-货架出接驳，创建{re} ");
			if (re)
			oto.Add(item);
			break;
			}
			}
			}
			else
			{
			var taglocs = hjs.FindAll(x => x.S_LOC_CODE == tagLoc.S_LOC_CODE);
			var v = LocationHelper.GetAreaNormalLocList(SX_BQ.YWLZSXBKQ);
			if (v.Any())
			{
			v = v.FindAll(e => e.N_ROW == 3).ToList();
			}
			foreach (var cdr in v.GroupBy(x => x.N_ROW))
			{
			var y2 = cdr.OrderBy(x => x.N_COL).ToList();
			var l2 = y2.FindAll(x => x.N_CURRENT_NUM > 0).LastOrDefault();
			var e = y2.FindAll(x => x.N_COL > (l2?.N_COL ?? 0) && x.N_CURRENT_NUM == 0).FirstOrDefault();
			if (e != null)
			{
			var tgs = taglocs.Select(x => x.S_CNTR_CODE).ToList();
			var re = TaskProcess.CreateTransport("", tagLoc.S_LOC_CODE.Trim(), e.S_LOC_CODE, "标签叉运-货架出拆垛", tgs, 1, 1, tgs.Count, 62, BQ_PRA.Out);
			LogHelper.Info($"from {tagLoc.S_LOC_CODE} to {e.S_LOC_CODE} 标签叉运-货架出拆垛，创建{re} ");
			if (re)
			oto.Add(item);
			break;
			}
			}
			}
			}
			else
			{
			LogHelper.CErrorLog("中水标签出库：" + (order.SQL_LinkLineNO) + $" 货架上没有这个[{item}]标签物料。");
			}
			}

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

			if (set1.SetEquals(set2))
			{
			order.OutNum--;
			order.TagOverTime = DateTime.Now;
			//order.TagOver = string.Empty;
			db.Updateable(order).UpdateColumns(it => new {/* it.TagOver,*/it.OutNum, it.TagOverTime }).ExecuteCommand();
			LogHelper.CSucess($"{order.SQL_PLineNo}-{order.SQL_LinkLineNO} 标签完成。重置数据");
			}
			else
			{
			//string otgo = string.Join(",", oto);
			//if (order.TagOver != otgo)
			//{
			// order.TagOver = otgo;
			// db.Updateable(order).UpdateColumns(it => new { it.TagOver }).ExecuteCommand();
			//}
			}
			}

			}



			//入库-堆叠-货架
			static bool from_mid_to(locCntItem startLoc, string MidArea, List<Location> locHJs)
			@@ -4462,6 +5007,10 @@
			{
			if (zzlocs.Any() && od.N_END_ROW > 0)//用于库内比如A库某排移到A库的另一排
			{
			if (ABlist.Contains(od.S_END_AREA))
			{
			continue;
			}
			zzlocs = zzlocs.FindAll(e => e.N_ROW == od.N_END_ROW);
			//
			var EndMt = dbcd.Queryable<Location>().Where(l => l.S_AREA_CODE == od.S_END_AREA && l.N_ROW == od.N_END_ROW && l.N_CURRENT_NUM > 0).ToList();
			@@ -4474,7 +5023,6 @@
			{
			Endbit = zzlocs.OrderBy(e => e.N_COL).FirstOrDefault();
			}

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

	HH.WCS.QingXiNongfu/core/Monitor.cs	1364 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	HH.WCS.QingXiNongfu/core/TaskCore.cs	2 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	HH.WCS.QingXiNongfu/wms/LocationHelper.cs	7 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史

			@@ -98,7 +98,7 @@
			TaskHelper.BeEnd(wmsTask);
			break;
			case 9://强制取消 //起点解绑锁释放终点锁释放

			var R = NDCHelper.CancelS(model.No);
			r = TaskProcess.OperateStatus(wmsTask, 9);
			if (r.ResultCode != -1)
			{

			@@ -177,6 +177,13 @@
			}
			return locs;
			}

			public static List<Location> GetAreaNormalLocListAll(string areeacode)
			{
			var locs = LocationHelper.GetLocList(x => x.S_AREA_CODE == areeacode && x.S_LOCK_STATE.Trim() == "无" && x.N_CURRENT_NUM == 0);

			return locs;
			}
			internal static List<Location> GetAllLocListByAreaCode(string _areacode, int minRow, int maxRow)
			{
			var db = new SqlHelper<object>().GetInstance();