| | |
|---|
| | | int selectGlassState(int cage,int cell); |
|---|
| | | |
|---|
| | | //判断该调拨的笼子 |
|---|
| | | @Select("select cage,cell,max(state)as shu,ROUND(id/2)as prcid,id 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;") |
|---|
| | | @Select("select glass_id,cage,cell,max(state)as shu,ROUND(id/2)as prcid,id 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=#{state},glass_id=#{glassid},order_id=#{orderid},glasswidth=0 where cage=#{cage} and cell=#{cell} and tier=#{tier};") |
|---|
| | | @Update("update storage_cage as a set state=#{state},glass_id=#{glassid},order_id=#{orderid},glasswidth=0 where cage=#{cage} and cell=#{cell} and tier=#{tier};") |
|---|
| | | void UpdataGlassCage(String orderid,String glassid,double width,int cage,int cell,int tier,int state); |
|---|
| | | |
|---|
| | | //修改笼子信息(进片) |
|---|
| | |
|---|
| | | // @Insert("insert into user(name, date, address, user_no) values (#{name}, #{date}, #{address}, #{userNo})") |
|---|
| | | // void insert (Spian spian); |
|---|
| | | //新增任务表 |
|---|
| | | @Insert("INSERT INTO `canadames`.`storage_task`(`task_type`, `task_state`, `shelf_rack`, `load_rack`,start_time) VALUES (#{tasktype},#{taskstate},#{shelfrack},#{loadrack},now());") |
|---|
| | | void Inserttask(int tasktype,int taskstate,int shelfrack,int loadrack); |
|---|
| | | @Insert("INSERT INTO `canadames`.`storage_task`(`task_type`, `task_state`, `shelf_rack`, `load_rack`,start_time,glass_id) VALUES (#{tasktype},#{taskstate},#{shelfrack},#{loadrack},now(),#{glassid});") |
|---|
| | | void Inserttask(int tasktype,int taskstate,int shelfrack,int loadrack,String glassid); |
|---|
| | | //修改任务表 |
|---|
| | | @Update("update storage_task set task_state=#{state} where task_type=#{type} and task_state=0;") |
|---|
| | | void Updatetask(int state,int type); |
|---|
| | |
|---|
| | | //查询按订单出片 |
|---|
| | | @Select("select order_id state from order_out where state=0") |
|---|
| | | String SelectOrderout(); |
|---|
| | | //内外片调换 |
|---|
| | | @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.cage=#{cage} and a.cell=#{cell} and a.tier=1") |
|---|
| | | void UpdateDBCage1(int cage,int cell); |
|---|
| | | //清除内片数据 |
|---|
| | | @Update("update storage_cage set glass_id='',order_id='',state=0,glasswidth=0 where a.cage=#{cage} and a.cell=#{cell} and a.tier=1;") |
|---|
| | | void UpdateDBCage2(int cage,int cell); |
|---|
| | | //判断是否有调拨完后出片的任务 |
|---|
| | | @Select("select COUNT(*)as id,glass_id from storage_task where (task_type=1 or task_type=2) and task_state=0;") |
|---|
| | | Glass SelectDBOut(); |
|---|
| | | } |
|---|
