| | |
| | | rows = "18,19"; |
| | | break; |
| | | } |
| | | LocMast loc = locMastService.selectOne(new EntityWrapper<LocMast>().eq("crn_no",crn.getId()) |
| | | LocMast loc = null; |
| | | List<LocMast> locs = locMastService.selectList(new EntityWrapper<LocMast>().eq("crn_no",crn.getId()) |
| | | .eq("loc_type1",shallowLoc.getLocType1()) |
| | | .eq("loc_sts","O") |
| | | .last(" and row1 in (" + rows + ") order by bay1,lev1")); |
| | | for (LocMast one : locs){ |
| | | if(Utils.getGroupRow(one.getLocNo()) != Utils.getGroupRow(shallowLoc.getLocNo()) |
| | | || Utils.getBay(one.getLocNo()) != Utils.getBay(shallowLoc.getLocNo()) |
| | | || Utils.getLev(one.getLocNo()) != Utils.getLev(shallowLoc.getLocNo())){ |
| | | loc = one; |
| | | break; |
| | | } |
| | | } |
| | | |
| | | if (null == loc) { |
| | | log.error("深库位出库 --- 浅库位阻塞异常! 待移转浅库位:" + shallowLoc.getLocNo()); |