| | |
|---|
| | | |
|---|
| | | 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 && DateTime.Now.Subtract(x.SQL_Modify_TIme ?? DateTime.Now).TotalSeconds > 10).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> |
|---|
| | | /// 提扣，中水 退库 |
|---|
| | |
|---|
| | | 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()) |
|---|
| | |
|---|
| | | 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} "); |
|---|
| | | |
|---|
| | | } |
|---|
| | | |
|---|
| | | } |
|---|
| | | } |
|---|
| | | } |
|---|
| | |
|---|
| | | } |
|---|
| | | } |
|---|
| | | //标签退库。 线边转到 货架。 |
|---|
| | | 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(); |
|---|
| | |
|---|
| | | 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 |
|---|
| | |
|---|
| | | //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)); |
|---|
| | |
|---|
| | | 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) |
|---|
| | |
|---|
| | | if (order != null) |
|---|
| | | { |
|---|
| | | var Porder = WCSHelper.GetWorkOrder(order.SQL_LinkLineNO); |
|---|
| | | if (Porder == null) |
|---|
| | | { |
|---|
| | | LogHelper.CErrorLog("SX标签出库：" + (order.SQL_LinkLineNO) + "没有【执行中】的工单"); |
|---|
| | | yuworders.Remove(order); |
|---|
| | | goto retuse; |
|---|
| | | } |
|---|
| | | //if (Porder == null) |
|---|
| | | //{ |
|---|
| | | // LogHelper.CErrorLog("SX标签出库：" + (order.SQL_LinkLineNO) + "没有【执行中】的工单"); |
|---|
| | | // yuworders.Remove(order); |
|---|
| | | // goto retuse; |
|---|
| | | //} |
|---|
| | | var oto = new List<string>(); |
|---|
| | | //if (!string.IsNullOrEmpty(order.TagOver)) |
|---|
| | | // oto = order.TagOver.Split(',').ToList(); |
|---|
| | |
|---|
| | | if (order != null) |
|---|
| | | { |
|---|
| | | var Porder = WCSHelper.GetWorkOrder(order.SQL_LinkLineNO); |
|---|
| | | if (Porder == null) |
|---|
| | | { |
|---|
| | | LogHelper.CErrorLog("无菌标签出库：" + (order.SQL_LinkLineNO) + "没有【执行中】的工单"); |
|---|
| | | yuworders.Remove(order); |
|---|
| | | goto retuse; |
|---|
| | | } |
|---|
| | | //if (Porder == null) |
|---|
| | | //{ |
|---|
| | | // LogHelper.CErrorLog("无菌标签出库：" + (order.SQL_LinkLineNO) + "没有【执行中】的工单"); |
|---|
| | | // yuworders.Remove(order); |
|---|
| | | // goto retuse; |
|---|
| | | //} |
|---|
| | | |
|---|
| | | var oto = new List<string>(); |
|---|
| | | //if (!string.IsNullOrEmpty(order.TagOver)) |
|---|
| | |
|---|
| | | } |
|---|
| | | |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | 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) |
|---|
| | |
|---|
| | | /// </summary> |
|---|
| | | internal static void YWL_ZX_Turn() |
|---|
| | | { |
|---|
| | | var dbcd = new SqlHelper<object>().GetInstance(); |
|---|
| | | |
|---|
| | | foreach (var ODs in LocationHelper.GetList<YWLZXtake>(X => X.S_ZX_STATE == "执行").GroupBy(x => x.S_START_AREA)) |
|---|
| | | { |
|---|
| | | var locS = LocationHelper.GetAreaNormalLocList(ODs.Key); |
|---|
| | |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | if (od.N_END_ROW > 0) |
|---|
| | | { |
|---|
| | | var EndRow = 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(); |
|---|
| | | if (EndRow.Count() == 0) |
|---|
| | | { |
|---|
| | | //置为完成。 |
|---|
| | | od.S_ZX_STATE = "完成"; |
|---|
| | | WCSHelper.Do(db => db.Updateable(od).UpdateColumns(x => new { x.S_ZX_STATE }).ExecuteCommand()); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | var EndRow = dbcd.Queryable<Location>().Where(l => l.S_AREA_CODE == od.S_END_AREA && l.N_CURRENT_NUM == 0).ToList(); |
|---|
| | | if (EndRow.Count() == 0) |
|---|
| | | { |
|---|
| | | //置为完成。 |
|---|
| | | od.S_ZX_STATE = "完成"; |
|---|
| | | WCSHelper.Do(db => db.Updateable(od).UpdateColumns(x => new { x.S_ZX_STATE }).ExecuteCommand()); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | var lastful = rows.FindAll(x => x.N_CURRENT_NUM > 0).OrderBy(x => x.N_COL).LastOrDefault(); |
|---|
| | | if (lastful != null) |
|---|
| | | { |
|---|
| | |
|---|
| | | 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)) |
|---|
| | | if (od.N_END_ROW == 0 && zzlocs.Any()) |
|---|
| | | { |
|---|
| | | var zzrloclist = zzrs.ToList(); |
|---|
| | | var _cl2 = zzrloclist.FindAll(x => x.N_CURRENT_NUM > 0).OrderBy(x => x.N_COL).LastOrDefault(); |
|---|
| | | if (_cl2 != null) |
|---|
| | | foreach (var zzrs in zzlocs.GroupBy(x => x.N_ROW).OrderBy(x => x.Key)) |
|---|
| | | { |
|---|
| | | var rel = LocationHelper.GetLocCntrRel(_cl2.S_LOC_CODE); |
|---|
| | | 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 && cntrrel.S_CJ_NAME == cir1.S_CJ_NAME) |
|---|
| | | var zzrloclist = zzrs.ToList(); |
|---|
| | | var _cl2 = zzrloclist.FindAll(x => x.N_CURRENT_NUM > 0).OrderBy(x => x.N_COL).LastOrDefault(); |
|---|
| | | if (_cl2 != null) |
|---|
| | | { |
|---|
| | | var rel = LocationHelper.GetLocCntrRel(_cl2.S_LOC_CODE); |
|---|
| | | 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 && cntrrel.S_CJ_NAME == cir1.S_CJ_NAME) |
|---|
| | | { |
|---|
| | | Endbit = zzrloclist.Find(x => x.N_COL > (_cl2?.N_COL ?? 0)); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | else |
|---|
| | | Endbit = zzrloclist.Find(x => x.N_COL > (_cl2?.N_COL ?? 0)); |
|---|
| | | if (Endbit != null) |
|---|
| | | { |
|---|
| | | LogHelper.Info($"入中转区{nextarea}使用{Endbit.S_LOC_CODE}"); |
|---|
| | | break; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | else |
|---|
| | | Endbit = zzrloclist.Find(x => x.N_COL > (_cl2?.N_COL ?? 0)); |
|---|
| | | if (Endbit != null) |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | if (zzlocs.Any() && od.N_END_ROW > 0)//用于库内 比如A库某排移到A库的另一排 |
|---|
| | | { |
|---|
| | | LogHelper.Info($"入中转区{nextarea}使用{Endbit.S_LOC_CODE}"); |
|---|
| | | break; |
|---|
| | | 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(); |
|---|
| | | if (EndMt.Any()) |
|---|
| | | { |
|---|
| | | var ggh = EndMt.OrderByDescending(e => e.N_COL).FirstOrDefault(); |
|---|
| | | zzlocs = zzlocs.FindAll(e => e.N_COL > ggh.N_COL).ToList(); |
|---|
| | | } |
|---|
| | | if (zzlocs.Any()) |
|---|
| | | { |
|---|
| | | 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}"); |
|---|
| | |
|---|
| | | } |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | } |
|---|
| | | } |
|---|
| | | } |
|---|
