| | |
|---|
| | | //修改同笼子格子宽度 |
|---|
| | | @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); |
|---|
| | | //调拨更换笼子信息 |
|---|
| | | @Update("update storage_cage as a,(select*from storage_cage b where b.cage=#{cage} and b.cell=#{cell} and b.tier=2)as b set a.glass_id=b.glass_id,a.order_id=b.order_id,a.state=1 where a.id=#{id1}") |
|---|
| | | @Update("update storage_cage as a,(select*from storage_cage b where b.cage=#{cage} and b.cell=#{cell} and b.tier=2)as b set a.glass_id=b.glass_id,a.order_id=b.order_id,a.state=1,a.glasswidth=b.glasswidth where a.id=#{id1}") |
|---|
| | | void UpdateDBCage(int id1,int cage,int cell); |
|---|
| | | // @Insert("insert into user(name, date, address, user_no) values (#{name}, #{date}, #{address}, #{userNo})") |
|---|
| | | // void insert (Spian spian); |
|---|
| | |
|---|
| | | //根据笼子格子层数获取玻璃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(); |
|---|
| | | } |
|---|
| | | |
|---|
