| | |
|---|
| | | short SelectInTask(); |
|---|
| | | |
|---|
| | | // 手动完成任务 |
|---|
| | | @Update("update storage_task set task_state=1 where task_type=#{task_type} and task_state=0 and glass_id=#{glassid}") |
|---|
| | | @Update("update storage_task set task_state=2 where task_type=#{task_type} and glass_id=#{glassid}") |
|---|
| | | void UpdateTask(@Param("task_type") Integer task_type,String glassid); |
|---|
| | | |
|---|
| | | // 手动完成进片任务修改笼子数据 |
|---|
| | |
|---|
| | | //根据玻璃id查询理片笼信息 |
|---|
| | | @Select("select * from storage_cage where glass_id=#{glassid}") |
|---|
| | | StorageCage SelectGlassInfo(String glassid); |
|---|
| | | |
|---|
| | | //根据玻璃id查询理片笼信息 |
|---|
| | | @Select("select * from storage_cage where glass_id=#{glassid}") |
|---|
| | | List<StorageCage> SelectStorageInfoByGlassId(String glassid); |
|---|
| | | |
|---|
| | | //查询玻璃信息 |
|---|
| | | // @Select("select * from glass where glassid=#{glassid}") |
|---|
| | |
|---|
| | | @Select("select ifnull(max(sequence),0)+1 from out_slice ") |
|---|
| | | Short SelectMaxSquence(); |
|---|
| | | //查询用户权限 |
|---|
| | | @Select("select rp.* from role_permission rp inner join user r on rp.role_id=r.role_id and r.username=#{username} and (permission_id=32 or permission_id=33 or permission_id=34 or permission_id=35 or permission_id=36 or permission_id=37 or permission_id=38)") |
|---|
| | | @Select("select rp.* from role_permission rp inner join user r on rp.role_id=r.role_id and r.username=#{username} and (permission_id=32 or permission_id=33 or permission_id=34 or permission_id=35 or permission_id=36 or permission_id=37 or permission_id=38 or permission_id=39)") |
|---|
| | | List<RolePermission> SelectPermissionByUserName(String username); |
|---|
| | | |
|---|
| | | //根据玻璃完成出片任务 |
|---|
| | |
|---|
| | | void UpdateOutSliceGlass(String glassid); |
|---|
| | | |
|---|
| | | //查询未完成的任务 |
|---|
| | | @Select("select * from storage_task where task_state=0 and task_type=#{task_type}") |
|---|
| | | @Select("select * from storage_task where task_state!=2 and task_type=#{task_type}") |
|---|
| | | List<StorageTask> SelectTaskByState(int task_type); |
|---|
| | | |
|---|
| | | //修改出片队列铝框状态 |
|---|
| | |
|---|
| | | @Select("select task_type from storage_task where glass_id=#{glassid} and task_state!=2") |
|---|
| | | Short SelectTaskByGlassId(String glassid); |
|---|
| | | |
|---|
| | | //修改格子宽度 |
|---|
| | | @Update("update storage_cage set width=width+#{width} where cage=#{cage} and cell=#{cell};") |
|---|
| | | void UpdataCageWidth(double width, int cage, int cell); |
|---|
| | | |
|---|
| | | } |
|---|
