| | |
|---|
| | | north_glass_buffer1 SelectBoxNo(String glassid); |
|---|
| | | |
|---|
| | | //查询出片队列信息 |
|---|
| | | @Select("select * from out_slice order by sequence") |
|---|
| | | @Select("select a.*,b.cell from out_slice a left join storage_cage b on a.glassId=b.glass_id order by sequence") |
|---|
| | | List<Out_slice> SelectProductionqueue(); |
|---|
| | | |
|---|
| | | //根据玻璃id查询笼内玻璃信息 |
|---|
| | |
|---|
| | | Out_slice SelectCurrentFrame(); |
|---|
| | | |
|---|
| | | //根据玻璃id查询任务信息 |
|---|
| | | @Select("select task_type from storage_task where glass_id=#{glassid} and task_state!=2") |
|---|
| | | @Select("select task_type from storage_task where glass_id=#{glassid} and task_state!=1") |
|---|
| | | Short SelectTaskByGlassId(String glassid); |
|---|
| | | |
|---|
| | | //修改格子宽度 |
|---|
| | |
|---|
| | | //获取铝框有没有正在出片的玻璃 |
|---|
| | | @Select("select count(*) from out_slice where barcode=#{frameNo} and state=1") |
|---|
| | | Short SelectOutingQueueCount(String frameNo); |
|---|
| | | |
|---|
| | | //获取铝框是否存在玻璃对了 |
|---|
| | | @Select("select count(*) from out_slice where barcode=#{frameNo}") |
|---|
| | | int SelectCountFrame(String getbarcode); |
|---|
| | | |
|---|
| | | |
|---|
| | | } |
|---|
