| | |
|---|
| | | 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查询笼内玻璃信息 |
|---|
| | |
|---|
| | | @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); |
|---|
| | | |
|---|
| | | |
|---|
| | | } |
|---|
