| | |
|---|
| | | int selectGlassState(int cage,int cell); |
|---|
| | | |
|---|
| | | //判断该调拨的笼子 |
|---|
| | | @Select("select glass_id,cage,cell,max(state)as shu,ROUND(id/2)as prcid,id from storage_cage where width>=#{width} and cage>#{cage1} and cage<#{cage2} GROUP BY cage,cell HAVING shu=0 order by abs(#{cage} - cage) limit 1;") |
|---|
| | | @Select("select glass_id,cage,cell,max(state)as shu,ROUND(id/2)as prcid,id from storage_cage where width>=#{width} and cage>#{cage1} and cage<#{cage2} GROUP BY cage,cell HAVING shu=0 order by abs(#{cage} - cage),cell desc limit 1;") |
|---|
| | | StorageCage selectGlassCage(int cage,double width,int cage1,int cage2); |
|---|
| | | |
|---|
| | | //删除笼子信息(出片) |
|---|
