| | |
|---|
| | | 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(); |
|---|
| | | |
|---|
| | | // 根据任务类型查询当前正在出片，进片的玻璃信息 |
|---|
