| | |
|---|
| | | @Select("SELECT COUNT(*) FROM `storage_cage` where state=3;") |
|---|
| | | Integer Selectoutstate(); |
|---|
| | | //添加任务序列 |
|---|
| | | //获取进片队列id |
|---|
| | | @Insert("INSERT INTO `canadames`.`queue`(`glassid`, `type`, `state`,width) VALUES (#{glassid},#{type},0,#{width});") |
|---|
| | | void insertqueue(String glassid,int type,double width); |
|---|
| | | //获取任务序列 |
|---|
| | |
|---|
| | | //寻找可以多片出片的玻璃 |
|---|
| | | @Select("select cage,cell,ROUND(id/2)as prcId,width,count(glass_id)shu from storage_cage where order_id=#{orderid} and (cage!=#{cage} or cell!=#{cell}) GROUP BY cage,cell HAVING shu=1 ORDER BY cage desc,cell desc limit 1") |
|---|
| | | StorageCage SelectQueout(String orderid,int cage,int cell); |
|---|
| | | |
|---|
| | | //获取进片队列id |
|---|
| | | @Select("select glassid from queue where type=1 and state=0;") |
|---|
| | | @Select("select glassid from queue where type=1") |
|---|
| | | String Selectqueueid(); |
|---|
| | | //获取进片队列id |
|---|
| | | @Select("select state from queue where type=1") |
|---|
| | | String Selectqueuestate(); |
|---|
| | | } |
|---|
| | | |
|---|
