| | |
|---|
| | | List<StorageCage> selectAll(); |
|---|
| | | |
|---|
| | | // 查询1-5笼内层格子状态 |
|---|
| | | @Select("SELECT cage,state,glasswidth/2750*2 as glasswidth from storage_cage where cage>5 and tier=2 order by cage desc,cell desc") |
|---|
| | | @Select("SELECT cage,state,ifnull(glasswidth/2750*2,0) as glasswidth from storage_cage where cage>5 and tier=2 order by cage desc,cell desc") |
|---|
| | | List<StorageCage> selectRack1(); |
|---|
| | | |
|---|
| | | // 查询6-10笼内层格子状态 |
|---|
| | | @Select("SELECT cage,state,glasswidth/2750*2 as glasswidth from storage_cage where cage<=5 and tier=2 order by cage desc,cell desc") |
|---|
| | | @Select("SELECT cage,state,ifnull(glasswidth/2750*2,0) as glasswidth from storage_cage where cage<=5 and tier=2 order by cage desc,cell desc") |
|---|
| | | List<StorageCage> selectRack2(); |
|---|
| | | |
|---|
| | | // 查询1-5笼外层格子状态 |
|---|
| | |
|---|
| | | List<alarmmg> SelectAlarmmgInfo(); |
|---|
| | | |
|---|
| | | //获取理片笼内玻璃信息 |
|---|
| | | @Select("select *,concat(glasswidth,' x ',glassheight) as lengthwidth from storage_cage where cage=#{cage} and state!=0 ") |
|---|
| | | @Select("select *,concat(glasswidth,' x ',glassheight) as lengthwidth from storage_cage ") |
|---|
| | | List<StorageCage> SelectCageInfo(short cage); |
|---|
| | | |
|---|
| | | @Update("update storage_cage set state=0,glass_id=null,order_id=null,glasswidth=null,glassheight=null,coating=null where glass_id=#{glassid}") |
|---|
