| | |
|---|
| | | .eq("station_code", stationCode) |
|---|
| | | .like("dev_no", "0" + i + "@"); |
|---|
| | | |
|---|
| | | if("CS-305".equals(stationCode) || "CS-306".equals(stationCode) || "CS-307".equals(stationCode)){ |
|---|
| | | List<String> list = this.selectCacheShelvesStationCodeByFloor(3); |
|---|
| | | if(list.contains(stationCode)){ |
|---|
| | | wrapper.orderBy("dev_no",false); |
|---|
| | | } |
|---|
| | | |
|---|
| | |
|---|
| | | .eq("loc_sts", "O")); |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public List<AgvBasDevp> getBasDevpByNoCacheShelves() { |
|---|
| | | return this.selectList(new EntityWrapper<AgvBasDevp>().eq("cache_shelves","N")); |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public List<String> selectCacheShelvesStationCodeByFloor(int floor) { |
|---|
| | | //Object o = this.selectList(new EntityWrapper<AgvBasDevp>().setSqlSelect("station_code").eq("floor",floor).eq("cache_shelves","Y").groupBy("station_code")); |
|---|
| | | return this.baseMapper.selectCacheShelvesStationCodeByFloor(floor); |
|---|
| | | } |
|---|
| | | |
|---|
| | | } |
|---|
