| | |
| | | //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 |
| | |
| | | { |
| | | 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; |
| | |
| | | Location StartBit = null; |
| | | List<LocCntrRel> _clrel = new List<LocCntrRel>(); |
| | | |
| | | foreach (var area in v.Concat(od.S_ROW.Split('$')).Distinct()) |
| | | foreach (var area in v) //.Concat(od.S_ROW.Split('$')).Distinct()) |
| | | { |
| | | var AreaRowlist = LocationHelper.GetAreaNormalLocList(area); |
| | | foreach (var item in AreaRowlist.GroupBy(x => x.N_ROW)) |
| | |
| | | } |
| | | else |
| | | { |
| | | Endbit = LocationHelper.GetAreaNormalLocList(PLC.areaPriy[0]).Find(x => x.N_CURRENT_NUM == 0); |
| | | Endbit = LocationHelper.GetAreaNormalLocList(PLC.areaPriy[0]).Find(x => x.S_LOCK_STATE == "无" && x.N_CURRENT_NUM == 0); |
| | | } |
| | | |
| | | if (StartBit != null && Endbit != null) |
| | |
| | | var 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(); |
| | | //给终点锁定住 |
| | |
| | | LogHelper.Info(Endbit.S_LOC_CODE + "LockLoc:锁结果" + res); |
| | | } |
| | | //排锁 |
| | | var row = db.Queryable<RowLock>().Where(x => x.S_AREA_CODE == r.S_AREA_CODE && r.N_ROW == x.N_ROW).First(); |
| | | if (row != null) |
| | | { |
| | | if (row.S_LOCK_SRC != r.S_LOCK_SRC) |
| | | { |
| | | db.Deleteable(row).ExecuteCommand(); |
| | | db.Insertable(r).ExecuteCommand(); |
| | | } |
| | | } |
| | | else db.Insertable(r).ExecuteCommand(); |
| | | //var row = db.Queryable<RowLock>().Where(x => x.S_AREA_CODE == r.S_AREA_CODE && r.N_ROW == x.N_ROW).First(); |
| | | //if (row != null) |
| | | //{ |
| | | // if (row.S_LOCK_SRC != r.S_LOCK_SRC) |
| | | // { |
| | | // db.Deleteable(row).ExecuteCommand(); |
| | | // db.Insertable(r).ExecuteCommand(); |
| | | // } |
| | | //} |
| | | //else db.Insertable(r).ExecuteCommand(); |
| | | od.TagOverTime = DateTime.Now; |
| | | db.Updateable(od).UpdateColumns(it => new { it.TagOverTime }).ExecuteCommand(); |
| | | break; |