| | |
| | | { |
| | | var locs = LocationHelper.GetList<Location>(x => x.S_AREA_CODE == item.S_AREA_CODE && x.N_ROW == item.N_ROW); |
| | | if (locs.Find(x => x.N_CURRENT_NUM > 0) == null) |
| | | LocationHelper.SetRowLock(item, 0); |
| | | WCSHelper.Do(db => db.Deleteable(item).ExecuteCommand()); |
| | | } |
| | | } |
| | | Rlock = Rlocks.FindAll(x => x.S_LOCK_STATE.Contains("入库锁")); |
| | |
| | | // LocationHelper.SetRowLock(item, 0); |
| | | //} |
| | | //如果一排内无货。也无锁。 可能是物料的入库取消了。 取消当前排锁,防止后续不入这个物料了依然占着排。 |
| | | if (locs.Find(x => x.N_CURRENT_NUM > 0) == null && locs.Find(x => x.S_LOCK_STATE != "无") == null) LocationHelper.SetRowLock(item, 0); |
| | | if (locs.Find(x => x.N_CURRENT_NUM > 0) == null && locs.Find(x => x.S_LOCK_STATE != "无") == null) WCSHelper.Do(db => db.Deleteable(item).ExecuteCommand()); |
| | | else |
| | | { |
| | | var lastloC = locs.OrderByDescending(x => x.N_COL).FirstOrDefault(); |
| | | if (lastloC.N_CURRENT_NUM == lastloC.N_CAPACITY) LocationHelper.SetRowLock(item, 0); |
| | | if (lastloC.N_CURRENT_NUM == lastloC.N_CAPACITY) WCSHelper.Do(db => db.Deleteable(item).ExecuteCommand()); |
| | | } |
| | | } |
| | | } |
| | |
| | | //InworkLock = false; |
| | | var usingSpace = new List<string> { "入库接驳区", "库内接驳区", "出库接驳区", "提升机退料口" }; |
| | | //usingSpace = new List<string> { "YWLRGDD", "YWLWJJB", "YWLYLTKQ", "YWLTKKTQ", "YWLKTDDQ", "YWLT1TSJ", "YWLT1TSJCD", "YWLT2TSJ", "YWLT2TSJCD" }; |
| | | usingSpace = new List<string> { "YWLRGDD", "YWLWJJB", "YWLYLTKQ", "YWLTKKTQ", "YWLT1TSJ", "YWLT2TSJ" }; |
| | | usingSpace = new List<string> { "YWLWJJB", "YWLYLTKQ", "YWLTKKTQ", "YWLRGDD", "YWLT1TSJ", "YWLT2TSJ" }; |
| | | foreach (var area in usingSpace) |
| | | { |
| | | try |
| | |
| | | { |
| | | try |
| | | { |
| | | LogHelper.Info($" 无菌出库 查工单"); |
| | | var yuworders = LocationHelper.GetList<YWLWorkOrder>(x => x.SQL_PLineNo == "无菌标签出库" && x.WorkType == 6 && x.SQL_State == "执行中").FindAll(x => x.OutNum > 0 && DateTime.Now.Subtract(x.SQL_Modify_TIme ?? DateTime.Now).TotalSeconds > 10).OrderBy(x => !string.IsNullOrEmpty(x.TagOver) ? 1 : 2).ThenBy(x => x.TagOverTime).ToList(); |
| | | var yuworders = LocationHelper.GetList<YWLWorkOrder>(x => x.SQL_PLineNo == "无菌标签出库" && x.WorkType == 6 && x.SQL_State == "执行中").FindAll(x => DateTime.Now.Subtract(x.SQL_Modify_TIme ?? DateTime.Now).TotalSeconds > 10).OrderBy(x => !string.IsNullOrEmpty(x.TagOver) ? 1 : 2).ThenBy(x => x.TagOverTime).ToList(); |
| | | if (!yuworders.Any()) |
| | | { |
| | | YwlBQ_CreInwork(locsFirst, WJ_BQ.RK_BQDDQ, WJ_BQ.RK_BBHJQ); |
| | |
| | | try |
| | | { |
| | | string pline = "T2提升机-标签"; |
| | | var Syuworders = LocationHelper.GetList<YWLWorkOrder>(x => x.SQL_PLineNo == pline && x.WorkType == 6 && x.SQL_State == "执行中").FindAll(x => x.OutNum > 0 && DateTime.Now.Subtract(x.SQL_Modify_TIme ?? DateTime.Now).TotalSeconds > 10).OrderBy(x => !string.IsNullOrEmpty(x.TagOver) ? 1 : 2).ThenBy(x => x.TagOverTime).ToList(); |
| | | var Syuworders = LocationHelper.GetList<YWLWorkOrder>(x => x.SQL_PLineNo == pline && x.WorkType == 6 && x.SQL_State == "执行中").FindAll(x => DateTime.Now.Subtract(x.SQL_Modify_TIme ?? DateTime.Now).TotalSeconds > 10).OrderBy(x => !string.IsNullOrEmpty(x.TagOver) ? 1 : 2).ThenBy(x => x.TagOverTime).ToList(); |
| | | //yuworders = LocationHelper.GetList<YWLWorkOrder>(x => x.SQL_PLineNo == plc.deviceName && x.WorkType == 6 && x.SQL_State == "执行中").FindAll(x => DateTime.Now.Subtract(x.SQL_Modify_TIme ?? DateTime.Now).TotalSeconds > 10).OrderBy(x => !string.IsNullOrEmpty(x.TagOver) ? 1 : 2).ThenBy(x => x.TagOverTime).ToList(); |
| | | |
| | | var tklist = LocationHelper.GetList<YWLWorkOrder>(x => x.SQL_PLineNo == pline && x.WorkType == 1 && x.SQL_State == "执行中"); |
| | |
| | | } |
| | | else if (Syuworders.Any()) |
| | | { |
| | | YwlBQ_CreSXOutOrder(plc, Syuworders); |
| | | YwlBQ_CreSXOutOrder(plc, Syuworders.FindAll(x => x.OutNum > 0)); |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | |
| | | { |
| | | 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; |
| | |
| | | } |
| | | } |
| | | ///第一段:出库 -到拆垛或者 接驳。 |
| | | var yuworders = LocationHelper.GetList<YWLWorkOrder>(x => x.SQL_PLineNo == "无菌标签出库" && x.WorkType == 6 && x.SQL_State == "执行中").FindAll(x => DateTime.Now.Subtract(x.SQL_Modify_TIme ?? DateTime.Now).TotalSeconds > 10).OrderBy(x => !string.IsNullOrEmpty(x.TagOver) ? 1 : 2).ThenBy(x => x.TagOverTime).ToList(); |
| | | var yuworders = LocationHelper.GetList<YWLWorkOrder>(x => x.SQL_PLineNo == "无菌标签出库" && x.WorkType == 6 && x.SQL_State == "执行中").FindAll(x => x.OutNum > 0 && DateTime.Now.Subtract(x.SQL_Modify_TIme ?? DateTime.Now).TotalSeconds > 10).OrderBy(x => !string.IsNullOrEmpty(x.TagOver) ? 1 : 2).ThenBy(x => x.TagOverTime).ToList(); |
| | | |
| | | //foreach (var order in yuworders) |
| | | retuse: |
| | |
| | | public static void AutoRun13TSJ() |
| | | { |
| | | var list = new List<string>() { "YWLAQWJ", "YWLBQWJ", "YWLCQSX", "YWLDQWJ" }; |
| | | var WorkOrder = new List<YWLWorkOrder>(); |
| | | //var WorkOrder = new List<YWLWorkOrder>(); |
| | | foreach (var PLC in Settings.GetDeviceInfoList().FindAll(X => X.deviceType == 13 && X.enable == 1)) |
| | | { |
| | | string pline = PLC.deviceName; |
| | |
| | | pline = "T2提升机-纸箱"; |
| | | |
| | | var orkOrd = LocationHelper.GetList<YWLWorkOrder>(x => x.SQL_PLineNo == pline && x.WorkType == 6 && x.SQL_State == "执行中"); |
| | | orkOrd = orkOrd.FindAll(x => DateTime.Now.Subtract(x.SQL_Modify_TIme ?? DateTime.Now).TotalSeconds > 10); |
| | | bool can = false; |
| | | if (orkOrd.Any()) |
| | | { |
| | |
| | | continue; |
| | | can = true; |
| | | |
| | | foreach (var item in list) |
| | | { |
| | | YWLWorkOrder source = new YWLWorkOrder(); |
| | | var source1 = orkOrd.FirstOrDefault(); |
| | | source.SQL_PLineNo = source1.SQL_PLineNo; |
| | | source.FuLe_PLine_No = source1.FuLe_PLine_No; |
| | | source.SQL_LinkLineNO = source1.SQL_LinkLineNO; |
| | | source.SQL_Area = item; |
| | | source.SQL_UsingNow = source1.SQL_UsingNow; |
| | | source.SQL_State = source1.SQL_State; |
| | | source.SQL_WorkNo = source1.SQL_WorkNo; |
| | | source.SQL_ItemCode = source1.SQL_ItemCode; |
| | | source.SQL_ItemName = source1.SQL_ItemName; |
| | | source.SQL_charge = source1.SQL_charge; |
| | | source.SQL_Total = source1.SQL_Total; |
| | | source.SQL_PLAN_END = source1.SQL_PLAN_END; |
| | | source.SQL_Modify_TIme = source1.SQL_Modify_TIme; |
| | | source.OutNum = source1.OutNum; |
| | | source.WorkType = source1.WorkType; |
| | | source.MidArea = source1.MidArea; |
| | | source.TagOver = source1.TagOver; |
| | | source.TagOverTime = source1.TagOverTime; |
| | | source.S_BQ_TRAY_TYPE = source1.S_BQ_TRAY_TYPE; |
| | | source.S_CJ_NAME = source1.S_CJ_NAME; |
| | | source.S_ROW = item; |
| | | WorkOrder.Add(source); |
| | | } |
| | | //var source1 = orkOrd.FirstOrDefault(); |
| | | //foreach (var item in list) |
| | | //{ |
| | | // YWLWorkOrder source = new YWLWorkOrder(); |
| | | // source.SQL_PLineNo = source1.SQL_PLineNo; |
| | | // source.FuLe_PLine_No = source1.FuLe_PLine_No; |
| | | // source.SQL_LinkLineNO = source1.SQL_LinkLineNO; |
| | | // source.SQL_Area = item; |
| | | // source.SQL_UsingNow = source1.SQL_UsingNow; |
| | | // source.SQL_State = source1.SQL_State; |
| | | // source.SQL_WorkNo = source1.SQL_WorkNo; |
| | | // source.SQL_ItemCode = source1.SQL_ItemCode; |
| | | // source.SQL_ItemName = source1.SQL_ItemName; |
| | | // source.SQL_charge = source1.SQL_charge; |
| | | // source.SQL_Total = source1.SQL_Total; |
| | | // source.SQL_PLAN_END = source1.SQL_PLAN_END; |
| | | // source.SQL_Modify_TIme = source1.SQL_Modify_TIme; |
| | | // source.OutNum = source1.OutNum; |
| | | // source.WorkType = source1.WorkType; |
| | | // source.MidArea = source1.MidArea; |
| | | // source.TagOver = source1.TagOver; |
| | | // source.TagOverTime = source1.TagOverTime; |
| | | // source.S_BQ_TRAY_TYPE = source1.S_BQ_TRAY_TYPE; |
| | | // source.S_CJ_NAME = source1.S_CJ_NAME; |
| | | // source.S_ROW = item; |
| | | // WorkOrder.Add(source); |
| | | //} |
| | | } |
| | | |
| | | orkOrd = orkOrd.FindAll(x => x.OutNum > 0 && DateTime.Now.Subtract(x.SQL_Modify_TIme ?? DateTime.Now).TotalSeconds > 10); |
| | | ReadCCK = can; |
| | | if (orkOrd.Any()) |
| | | // foreach (var od in orkOrd.OrderByDescending(x => x.OutNum)) |
| | | foreach (var od in WorkOrder) |
| | | foreach (var od in orkOrd.OrderBy(x => x.TagOverTime).ThenBy(x => x.OutNum)) |
| | | //foreach (var od in od2.ToList()) |
| | | { |
| | | list.Remove(od.S_ROW); |
| | | var odsr = new List<string> { od.S_ROW }.Concat(list).Distinct().ToList(); |
| | | ///汇总仓库里最大层是几层。 |
| | | Dictitems Lart = null; |
| | | foreach (var area in od.S_ROW.Split('$')) |
| | | foreach (var area in odsr)//od.S_ROW.Split('$')) |
| | | { |
| | | if (dsi.TryGetValue(area, out var dictitems1)) |
| | | { |
| | |
| | | } |
| | | } |
| | | |
| | | LogHelper.Info($"AutoRun13TSJ 筛选物料 库区排数据. {od.SQL_PLineNo} >>{od.OutNum}> {JsonConvert.SerializeObject(Lart)}"); |
| | | // 需要数量 >= 仓库最大数量。 就开始出库。 |
| | | if (od.OutNum >= Lart?.ItemLayer) |
| | | { |
| | | var v = new List<string>() { Lart.area }; |
| | | Location StartBit = null; |
| | | List<LocCntrRel> _clrel = new List<LocCntrRel>(); |
| | | |
| | | foreach (var area in v.Concat(od.S_ROW.Split('$')).Distinct()) |
| | | if (Lart != null) |
| | | if (od.OutNum >= Lart?.ItemLayer) |
| | | { |
| | | var AreaRowlist = LocationHelper.GetAreaNormalLocList(area); |
| | | foreach (var item in AreaRowlist.GroupBy(x => x.N_ROW)) |
| | | { |
| | | var rl = item.ToList().FindAll(x => x.N_CURRENT_NUM > 0).OrderBy(x => x.N_COL).LastOrDefault(); |
| | | if (rl == null) continue; |
| | | _clrel = LocationHelper.GetLocCntrRel(rl.S_LOC_CODE); |
| | | //板型相同 |
| | | var _clrel0 = _clrel.OrderByDescending(xx => xx.T_CREATE).First(); |
| | | LogHelper.Info(rl.S_LOC_CODE + "识别托盘类型。" + JsonConvert.SerializeObject(_clrel0)); |
| | | var _clcntitem = ContainerHelper.GetCntrItemRel(_clrel0.S_CNTR_CODE.Trim()).FirstOrDefault(); |
| | | LogHelper.Info(rl.S_LOC_CODE + "识别托盘上的物料信息。" + JsonConvert.SerializeObject(_clcntitem)); |
| | | if (_clcntitem != null) |
| | | { |
| | | LogHelper.Info("相互是否匹配 _clcntitem S_ITEM_CODE:" + _clcntitem.S_ITEM_CODE + " od" + od.SQL_ItemCode + " _clcntitem S_ITEM_NAME:" + _clcntitem.S_ITEM_NAME + "od: " + od.SQL_ItemName + " od.S_CJ_NAME:" + od.S_CJ_NAME); |
| | | if (_clcntitem.S_ITEM_CODE == od.SQL_ItemCode && _clcntitem.S_ITEM_NAME == od.SQL_ItemName && _clcntitem.S_CJ_NAME == od.S_CJ_NAME) |
| | | { |
| | | var v = new List<string>() { Lart.area }; |
| | | Location StartBit = null; |
| | | List<LocCntrRel> _clrel = new List<LocCntrRel>(); |
| | | |
| | | StartBit = rl; |
| | | break; |
| | | foreach (var area in v) //.Concat(od.S_ROW.Split('$')).Distinct()) |
| | | { |
| | | var AreaRowlist = LocationHelper.GetAreaNormalLocList(area); |
| | | foreach (var item in AreaRowlist.GroupBy(x => x.N_ROW)) |
| | | { |
| | | var rl = item.ToList().FindAll(x => x.N_CURRENT_NUM > 0).OrderBy(x => x.N_COL).LastOrDefault(); |
| | | if (rl == null) continue; |
| | | _clrel = LocationHelper.GetLocCntrRel(rl.S_LOC_CODE); |
| | | //板型相同 |
| | | var _clrel0 = _clrel.OrderByDescending(xx => xx.T_CREATE).First(); |
| | | LogHelper.Info(rl.S_LOC_CODE + "识别托盘类型。" + JsonConvert.SerializeObject(_clrel0)); |
| | | var _clcntitem = ContainerHelper.GetCntrItemRel(_clrel0.S_CNTR_CODE.Trim()).FirstOrDefault(); |
| | | LogHelper.Info(rl.S_LOC_CODE + "识别托盘上的物料信息。" + JsonConvert.SerializeObject(_clcntitem)); |
| | | if (_clcntitem != null) |
| | | { |
| | | LogHelper.Info("相互是否匹配 _clcntitem S_ITEM_CODE:" + _clcntitem.S_ITEM_CODE + " od" + od.SQL_ItemCode + " _clcntitem S_ITEM_NAME:" + _clcntitem.S_ITEM_NAME + "od: " + od.SQL_ItemName + " od.S_CJ_NAME:" + od.S_CJ_NAME); |
| | | if (_clcntitem.S_ITEM_CODE == od.SQL_ItemCode && _clcntitem.S_ITEM_NAME == od.SQL_ItemName && _clcntitem.S_CJ_NAME == od.S_CJ_NAME) |
| | | { |
| | | |
| | | StartBit = rl; |
| | | break; |
| | | } |
| | | } |
| | | } |
| | | if (StartBit != null) |
| | | break; |
| | | } |
| | | if (StartBit != null) |
| | | break; |
| | | } |
| | | if (StartBit == null) |
| | | continue; |
| | | Location Endbit = null; |
| | | var loc = LocationHelper.GetLoc(PLC.location[0]); |
| | | if (loc?.N_CURRENT_NUM == 0 && StartBit.N_CURRENT_NUM == 1 && DeviceProcess.doorStatus.ContainsKey(PLC.location[0])) |
| | | { |
| | | if (DeviceProcess.doorStatus[PLC.location[0]].info == "1") |
| | | { |
| | | Endbit = LocationHelper.GetLoc(PLC.location[0]); |
| | | } |
| | | } |
| | | else |
| | | { |
| | | Endbit = LocationHelper.GetAreaNormalLocList(PLC.areaPriy[0]).Find(x => x.N_CURRENT_NUM == 0); |
| | | } |
| | | if (StartBit == null) |
| | | continue; |
| | | Location Endbit = null; |
| | | |
| | | if (StartBit != null && Endbit != null) |
| | | { |
| | | var crs = _clrel.Select(x => x.S_CNTR_CODE).ToList(); |
| | | var EndBit = Endbit.S_LOC_CODE; |
| | | if (od.S_ROW == "YWLCQSX" || od.S_ROW == "YWLDQWJ") |
| | | var loc = LocationHelper.GetLoc(PLC.location[0]); |
| | | if (loc?.N_CURRENT_NUM == 0 && StartBit.N_CURRENT_NUM == 1 && DeviceProcess.doorStatus.ContainsKey(PLC.location[0])) |
| | | { |
| | | var locs1 = LocationHelper.GetList<Location>(x => x.S_AREA_CODE == "YWLWJJB" && x.S_LOCK_STATE != "报废" && x.S_LOCK_STATE == "无" && x.N_CURRENT_NUM == 0).ToList(); |
| | | if (locs1.Count() > 0) |
| | | if (DeviceProcess.doorStatus[PLC.location[0]].info == "1") |
| | | { |
| | | EndBit = locs1.FirstOrDefault().S_LOC_CODE; |
| | | } |
| | | else |
| | | { |
| | | continue; |
| | | Endbit = LocationHelper.GetLoc(PLC.location[0]); |
| | | } |
| | | } |
| | | var b = TaskProcess.CreateTransport(od.SQL_WorkNo, StartBit.S_LOC_CODE, EndBit, "原物料搬运-纸箱", crs, StartBit.N_CURRENT_NUM - crs.Count + 1, 1, crs.Count, PLC.taskPri, "", Endbit.S_LOC_CODE); |
| | | if (b) |
| | | else |
| | | { |
| | | Endbit = LocationHelper.GetAreaNormalLocList(PLC.areaPriy[0]).Find(x => x.S_LOCK_STATE == "无" && x.N_CURRENT_NUM == 0); |
| | | } |
| | | |
| | | var r = new RowLock { S_LOCK_SRC = od.SQL_ItemCode, T_LOCK_TIME = DateTime.Now, S_LOCK_STATE = "出库锁", S_AREA_CODE = StartBit.S_AREA_CODE, N_ROW = StartBit.N_ROW }; |
| | | var db = new SqlHelper<object>().GetInstance(); |
| | | //给终点锁定住 |
| | | if (StartBit != null && Endbit != null) |
| | | { |
| | | var crs = _clrel.Select(x => x.S_CNTR_CODE).ToList(); |
| | | var EndBit = Endbit.S_LOC_CODE; |
| | | if (od.S_ROW == "YWLCQSX" || od.S_ROW == "YWLDQWJ") |
| | | { |
| | | var model = db.Queryable<Location>().Where(a => a.S_LOC_CODE == Endbit.S_LOC_CODE).First(); |
| | | |
| | | model.S_LOCK_STATE = "入库锁"; |
| | | var res = db.Updateable(model).UpdateColumns(it => new { it.S_LOCK_STATE }).ExecuteCommand() > 0; |
| | | LogHelper.Info(Endbit.S_LOC_CODE + "LockLoc:锁结果" + res); |
| | | } |
| | | //排锁 |
| | | var row = db.Queryable<RowLock>().Where(x => x.S_AREA_CODE == r.S_AREA_CODE && r.N_ROW == x.N_ROW).First(); |
| | | if (row != null) |
| | | { |
| | | if (row.S_LOCK_SRC != r.S_LOCK_SRC) |
| | | var locs1 = LocationHelper.GetList<Location>(x => x.S_AREA_CODE == "YWLWJJB" && x.S_LOCK_STATE != "报废" && x.S_LOCK_STATE == "无" && x.N_CURRENT_NUM == 0).ToList(); |
| | | if (locs1.Count() > 0) |
| | | { |
| | | db.Deleteable(row).ExecuteCommand(); |
| | | db.Insertable(r).ExecuteCommand(); |
| | | EndBit = locs1.FirstOrDefault().S_LOC_CODE; |
| | | } |
| | | else |
| | | { |
| | | continue; |
| | | } |
| | | } |
| | | else db.Insertable(r).ExecuteCommand(); |
| | | var b = TaskProcess.CreateTransport(od.SQL_WorkNo, StartBit.S_LOC_CODE, EndBit, "原物料搬运-纸箱", crs, StartBit.N_CURRENT_NUM - crs.Count + 1, 1, crs.Count, PLC.taskPri, "", Endbit.S_LOC_CODE); |
| | | if (b) |
| | | { |
| | | var r = new RowLock { S_LOCK_SRC = od.SQL_ItemCode, T_LOCK_TIME = DateTime.Now, S_LOCK_STATE = "出库锁", S_AREA_CODE = StartBit.S_AREA_CODE, N_ROW = StartBit.N_ROW }; |
| | | var db = new SqlHelper<object>().GetInstance(); |
| | | //给终点锁定住 |
| | | if (od.S_ROW == "YWLCQSX" || od.S_ROW == "YWLDQWJ") |
| | | { |
| | | var model = db.Queryable<Location>().Where(a => a.S_LOC_CODE == Endbit.S_LOC_CODE).First(); |
| | | |
| | | model.S_LOCK_STATE = "入库锁"; |
| | | var res = db.Updateable(model).UpdateColumns(it => new { it.S_LOCK_STATE }).ExecuteCommand() > 0; |
| | | LogHelper.Info(Endbit.S_LOC_CODE + "LockLoc:锁结果" + res); |
| | | } |
| | | //排锁 |
| | | //var row = db.Queryable<RowLock>().Where(x => x.S_AREA_CODE == r.S_AREA_CODE && r.N_ROW == x.N_ROW).First(); |
| | | //if (row != null) |
| | | //{ |
| | | // if (row.S_LOCK_SRC != r.S_LOCK_SRC) |
| | | // { |
| | | // db.Deleteable(row).ExecuteCommand(); |
| | | // db.Insertable(r).ExecuteCommand(); |
| | | // } |
| | | //} |
| | | //else db.Insertable(r).ExecuteCommand(); |
| | | od.TagOverTime = DateTime.Now; |
| | | db.Updateable(od).UpdateColumns(it => new { it.TagOverTime }).ExecuteCommand(); |
| | | break; |
| | | } |
| | | } |
| | | break; |
| | | } |
| | | } |
| | | } |
| | | } |
| | | } |
| | | public static void AutoRunABD() |
| | | { |
| | | LogHelper.Info($"AutoRunABD abcd物料汇总 >>{ReadCCK}|| {dsi.Count}"); |
| | | if (!ReadCCK) |
| | | { |
| | | Thread.Sleep(3000); |
| | |
| | | var rl = item.ToList().FindAll(x => x.N_CURRENT_NUM > 0).OrderBy(x => x.N_COL).LastOrDefault(); |
| | | |
| | | var _clrel = LocationHelper.GetLocCntrRel(rl.S_LOC_CODE); |
| | | if (!_clrel.Any()) |
| | | { |
| | | LogHelper.Info($"{area}>> {rl.S_LOC_CODE}有数量, 没托盘"); |
| | | continue; |
| | | } |
| | | //板型相同 |
| | | var _clrel0 = _clrel.OrderByDescending(xx => xx.T_CREATE).First(); |
| | | var _clrel0 = _clrel.OrderByDescending(xx => xx.T_CREATE).FirstOrDefault(); |
| | | LogHelper.Info(rl.S_LOC_CODE + "识别托盘类型。"); |
| | | |
| | | var _clcntitem = ContainerHelper.GetCntrItemRel(_clrel0.S_CNTR_CODE.Trim()).FirstOrDefault(); |
| | |
| | | } |
| | | } |
| | | } |
| | | LogHelper.Info($"AutoRunABD abcd物料汇总完成 >>{ReadCCK}|| {dsi.Count}"); |
| | | } |
| | | |
| | | public static void chargeCCD() |