| | |
| | | List<StorageCage> selectAll(); |
| | | |
| | | // 查询1-5笼内层格子状态 |
| | | @Select("SELECT cage,state from storage_cage where cage<=5 and tier=1") |
| | | @Select("SELECT cage,state from storage_cage where cage<=5 and tier=2") |
| | | List<StorageCage> selectRack1(); |
| | | |
| | | // 查询6-10笼内层格子状态 |
| | | @Select("SELECT cage,state from storage_cage where cage>5 and tier=1") |
| | | @Select("SELECT cage,state from storage_cage where cage>5 and tier=2") |
| | | List<StorageCage> selectRack2(); |
| | | |
| | | // 查询1-5笼外层格子状态 |
| | | @Select("SELECT cage,state from storage_cage where cage<=5 and tier=2") |
| | | @Select("SELECT cage,state from storage_cage where cage<=5 and tier=1") |
| | | List<StorageCage> selectRack3(); |
| | | |
| | | // 查询6-10笼外层格子状态 |
| | | @Select("SELECT cage,state from storage_cage where cage>5 and tier=2") |
| | | @Select("SELECT cage,state from storage_cage where cage>5 and tier=1") |
| | | List<StorageCage> selectRack4(); |
| | | |
| | | // 根据任务类型查询当前正在出片,进片的玻璃信息 |