| | |
|---|
| | | @Select("select id from storage_cage where glasstype=#{glasstype} and width>=#{width}+#{widths} and disabled=0 order by id limit 1") |
|---|
| | | StorageCage SelectCage(int glasstype,Double width,int widths); |
|---|
| | | //判断笼内没有玻璃的空格 |
|---|
| | | @Select("select id from storage_cage where number=0 and cage>#{cage} and cage<#{cage2} and disabled=0 order by id limit 1") |
|---|
| | | @Select("select id from storage_cage where (number is null or number=0) and cage>#{cage} and cage<#{cage2} and disabled=0 order by id limit 1") |
|---|
| | | StorageCage SelectNewCell(int cage,int cage2); |
|---|
| | | //增加玻璃数 |
|---|
| | | @Update("update storage_cage set number=number+1,width=width-glasswidth where id=#{id}") |
|---|
