| | |
|---|
| | | @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 or permission_id=39)") |
|---|
| | | @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 or permission_id=50)") |
|---|
| | | List<RolePermission> SelectPermissionByUserName(String username); |
|---|
| | | |
|---|
| | | // //根据玻璃完成出片任务 |
|---|
| | |
|---|
| | | @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); |
|---|
| | | |
|---|
| | | |
|---|
| | | } |
|---|
