| | |
|---|
| | | @Select("select cage,cell,tier,id,ROUND(id/2)as prcId,width from storage_cage where cage=#{cage1} and cell=#{cell} and state=0 and disabled=0 and width>=#{width} ORDER BY cell asc,tier asc LIMIT 1") |
|---|
| | | StorageCage selectCage1(int cage1,int cell,double width); |
|---|
| | | //判断笼子内玻璃数 |
|---|
| | | @Select("select COUNT(tier)as tier from storage_cage where cage=#{cage} and cell=#{cell} and state=1;") |
|---|
| | | @Select("select COUNT(tier)as tier from storage_cage where cage=#{cage} and cell=#{cell} and state!=0;") |
|---|
| | | int selectsum(int cage,int cell); |
|---|
| | | //完成进片中的玻璃状态 |
|---|
| | | @Update("update storage_cage set state=#{state} where glass_id=#{glassid};") |
|---|
| | |
|---|
| | | StorageCage selectGlassCage(int cage,double width,int cage1,int cage2); |
|---|
| | | |
|---|
| | | //删除笼子信息(出片) |
|---|
| | | @Update("update storage_cage as a set state=#{state},glass_id=null,order_id=null,glasswidth=0,a.glassheight=null,a.glasswidthmm=null,a.glassheightmm=null,a.listid=null,a.boxid=null where glassid=#{glassid};") |
|---|
| | | @Update("update storage_cage as a set state=#{state},glass_id=null,order_id=null,glasswidth=0,a.glassheight=null,a.glasswidthmm=null,a.glassheightmm=null,a.listid=null,a.boxid=null where glass_id=#{glassid} and state=3;") |
|---|
| | | void UpdataGlassCage(String glassid,int state); |
|---|
| | | //改变玻璃状态为出片中 |
|---|
| | | @Update("update storage_cage as a set state=#{state} where glass_id=#{glassid};") |
|---|
