| | |
|---|
| | | @Select("SELECT case when tier=1 then cage else 0 end as cage,case when tier=1 then state else 0 end as state,sum(case when tier=1 then glasswidth/2750*2 else 0 end) as glasswidth,sum(case when tier=2 then glasswidth/2750*2 else 0 end) as width from storage_cage where cage<=5 group by cage,cell order by cage desc,cell desc") |
|---|
| | | List<StorageCage> selectRack4(); |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | // 根据任务类型查询当前正在出片，进片的玻璃信息 |
|---|
| | | @Select("select * from storage_cage where state=#{task_type}") |
|---|
| | | List<StorageCage> selectinout(@Param("task_type") Integer task_type); |
|---|
