| | |
|---|
| | | short SelectInTask(); |
|---|
| | | |
|---|
| | | // 手动完成任务 |
|---|
| | | @Update("update storage_task set task_state=1 where task_type=#{task_type} and task_state=0") |
|---|
| | | void UpdateTask(@Param("task_type") Integer task_type); |
|---|
| | | @Update("update storage_task set task_state=1 where task_type=#{task_type} and task_state=0 and glass_id=#{glassid}") |
|---|
| | | void UpdateTask(@Param("task_type") Integer task_type,String glassid); |
|---|
| | | |
|---|
| | | // 手动完成进片任务修改笼子数据 |
|---|
| | | @Update("update storage_cage set state=1 where glass_id=#{glassid} and state=2") |
|---|
| | |
|---|
| | | @Select("select ifnull(max(sequence),0)+1 from out_slice ") |
|---|
| | | Short SelectMaxSquence(); |
|---|
| | | //查询用户权限 |
|---|
| | | @Select("select rp.* from role_permission rp inner join role r on rp.role_id=r.id and r.name=#{token} and (permission_id=32 or permission_id=33 or permission_id=34 or permission_id=35)") |
|---|
| | | List<RolePermission> SelectPermissionByUserName(String token); |
|---|
| | | @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)") |
|---|
| | | List<RolePermission> SelectPermissionByUserName(String username); |
|---|
| | | //完成出片任务 |
|---|
| | | @Update("update out_slice set state=2 where id=#{id}") |
|---|
| | | void CompleteQueue(String id); |
|---|
