| | |
|---|
| | | var orders = WCSHelper.GetWorkOrder2(); |
|---|
| | | var thisOrder = orders.Find(x => x.SQL_WorkNo == WorkNo); |
|---|
| | | LogHelper.Info("移库解锁 --当前工单 sid:" + thisOrder?.S_ID); |
|---|
| | | if (thisOrder != null) |
|---|
| | | { |
|---|
| | | var other = orders.Find(x => x.SQL_WorkNo != WorkNo && x.start_area == thisOrder.start_area && x.start_row == thisOrder.start_row); |
|---|
| | | LogHelper.Info($"移库解锁 --其他工单 x.start_area == {thisOrder.start_area} start_row == {thisOrder.start_row} SID:" + other?.S_ID); |
|---|
| | | if (other != null) |
|---|
| | | j解锁起点库区排 = false; |
|---|
| | | } |
|---|
| | | var allarea_rows = orders.FindAll(x => x.S_ID != thisOrder.S_ID && x.start_area == thisOrder.start_area && x.start_row == thisOrder.start_row); |
|---|
| | | LogHelper.Info("移库解锁 --当前工单 的同库区排 其他工单:" + JsonConvert.SerializeObject(allarea_rows)); |
|---|
| | | if (allarea_rows.Any()) |
|---|
| | | j解锁起点库区排 = false; |
|---|
| | | //if (thisOrder != null) |
|---|
| | | //{ |
|---|
| | | // var other = orders.Find(x => x.SQL_WorkNo != WorkNo && x.start_area == thisOrder.start_area && x.start_row == thisOrder.start_row); |
|---|
| | | // LogHelper.Info($"移库解锁 --其他工单 x.start_area == {thisOrder.start_area} start_row == {thisOrder.start_row} SID:" + other?.S_ID); |
|---|
| | | // if (other != null) |
|---|
| | | // j解锁起点库区排 = false; |
|---|
| | | //} |
|---|
| | | } |
|---|
| | | //if (sign == 1) |
|---|
| | | //{ |
|---|
| | |
|---|
| | | ca.And((o, p, t) => o.N_CURRENT_NUM > 0 && o.S_LOCK_STATE == "无" && t.S_ITEM_CODE == cir1.S_ITEM_CODE && t.S_ITEM_NAME == cir1.S_ITEM_NAME && t.S_CJ_NAME == cir1.S_CJ_NAME && o.S_AREA_CODE == EdnRarea); |
|---|
| | | var lstCanOutL = dbll.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(); |
|---|
| | | LogHelper.Info($"终点有相同的物料的货位有{lstCanOutL.Count()}"); |
|---|
| | | |
|---|
| | | var ca1 = Expressionable.Create<Location, LocCntrRel, CntrItemRel>(); |
|---|
| | | ca1.And((o, p, t) => o.N_CURRENT_NUM > 0 && o.S_LOCK_STATE == "无" && t.S_ITEM_CODE == cir1.S_ITEM_CODE && t.S_ITEM_NAME == cir1.S_ITEM_NAME && t.S_CJ_NAME == cir1.S_CJ_NAME && o.S_AREA_CODE == "YWLRGDD" && p.S_TYPE == EdnRarea); |
|---|
| | | var lstCanOutLSta = dbll.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(ca1.ToExpression()).ToList(); |
|---|
| | | if (lstCanOutL.Count() > 0) |
|---|
| | | { |
|---|
| | | var EndMum = dbll.Queryable<Location>().Where(l => l.S_AREA_CODE == EdnRarea && l.N_CURRENT_NUM == 0 && l.S_LOCK_STATE == "无" && lstCanOutL.Select(e => e.N_ROW).ToList().Contains(l.N_ROW)).ToList(); |
|---|
| | | if (EndMum.Count() > 0) |
|---|
| | | { |
|---|
| | | arloclist = arloclist.FindAll(x => lstCanOutL.Select(e => e.N_ROW).ToList().Contains(x.N_ROW)).ToList(); |
|---|
| | | if (lstCanOutL.Count() <= EndMum.Count()) |
|---|
| | | { |
|---|
| | | arloclist = arloclist.FindAll(x => lstCanOutL.Select(e => e.N_ROW).ToList().Contains(x.N_ROW)).ToList(); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | } |
|---|
| | | } |
|---|
