| | |
|---|
| | | //修改同笼子格子宽度 |
|---|
| | | @Update("update storage_cage set width=width-#{width} where cage=#{cage} and cell=#{cell};") |
|---|
| | | void UpdataAddCage1(double width,int cage,int cell); |
|---|
| | | //修改同笼子格子宽度 |
|---|
| | | @Update("update storage_cage set state=#{state} where state=#{oldstate};") |
|---|
| | | void UpdataAddCageState(int state,int oldstate); |
|---|
| | | //修改同笼子格子宽度(出片) |
|---|
| | | @Update("update storage_cage set width=width+#{width} where cage=#{cage} and cell=#{cell};") |
|---|
| | | void UpdataOutCage1(double width,int cage,int cell); |
|---|
| | |
|---|
| | | //根据笼子格子层数获取玻璃id |
|---|
| | | @Select("select glass_id from storage_cage where cage=#{cage} and cell=#{cell} and tier=2;") |
|---|
| | | String SelectGlassid(int cage,int cell); |
|---|
| | | //根据笼子格子层数获取玻璃id |
|---|
| | | @Select("SELECT COUNT(*) FROM `storage_cage` where state=3;") |
|---|
| | | Integer Selectoutstate(); |
|---|
| | | } |
|---|
| | | |
|---|
