| | |
|---|
| | | void insert(StorageTask storageTask); |
|---|
| | | |
|---|
| | | //出片任务查询 |
|---|
| | | @Select("select cage,cell,tier from storage_cage as a where a.order_id=#{orderId} and state=1 order by cage desc,tier desc,cell desc LIMIT 1") |
|---|
| | | @Select("select cage,cell,tier,glasswidth from storage_cage as a where a.order_id=#{orderId} and state=1 order by cage desc,tier desc,cell desc LIMIT 1") |
|---|
| | | StorageCage selectOut(String orderId); |
|---|
| | | //判断出片为1时，是否可直接出片 |
|---|
| | | @Select("select state from storage_cage where cage=#{cage} and cell=#{cell} and tier=2;") |
|---|
| | | int selectGlassState(int cage,int cell); |
|---|
| | | //判断 |
|---|
| | | @Select("select cage,cell,max(state)as shu from storage_cage where width>=#{width} and cage>#{cage1} and cage<#{cage2} GROUP BY cage,cell HAVING shu=0;") |
|---|
| | | int selectGlassCage(double width,int cage1,int cage2); |
|---|
| | | |
|---|
| | | //判断该调拨的笼子 |
|---|
| | | @Select("select cage,cell,max(state)as shu 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;") |
|---|
| | | StorageCage selectGlassCage(int cage,double width,int cage1,int cage2); |
|---|
| | | //修改笼子信息(进片) |
|---|
| | | // @Update("update storage_cage set state=1,width=width #{width},glass_id=#{glassid},order_id=#{orderid},glasswidth=#{glasswidth} where cage=#{cage} and cell=#{cell} and tier=#{tier}"); |
|---|
| | | |
|---|
| | | // @Insert("insert into user(name, date, address, user_no) values (#{name}, #{date}, #{address}, #{userNo})") |
|---|
| | | // void insert (Spian spian); |
|---|
| | | |
|---|
