Merge remote-tracking branch 'origin/tzskwcs_3' into tzskwcs_3
| | |
| | | |
| | | //获取提升机命令 |
| | | NyLiftCommand liftCommand = NyLiftUtils.getLiftCommand(liftProtocol.getLiftNo().intValue(), NyLiftTaskModelType.MOVE_TRAY.id, startSta, targetSta, wrkMast.getWrkNo()); |
| | | if (wrkMast.getIoType() == 53) { |
| | | if (wrkMast.getIoType() == 53 || wrkMast.getIoType() == 57) { |
| | | //拣料再回库,重新分配设备工作号 |
| | | Random random = new Random(); |
| | | int deviceWrk = Math.abs((liftCommand.getTaskNo().intValue() + random.nextInt(9999)));//获取设备工作号 |
| | |
| | | continue; |
| | | } |
| | | |
| | | if (shuttleProtocol.getSuspendState() == 1) { |
| | | //小车处于管制中 |
| | | continue; |
| | | } |
| | | |
| | | int currentLev = shuttleProtocol.getPoint().getZ();//小车当前层高 |
| | | String currentLocNo = shuttleProtocol.getCurrentLocNo();//小车当前库位号 |
| | | |
| | |
| | | from dbo.asr_wrk_mast |
| | | where 1=1 |
| | | and wrk_sts = 4 |
| | | and io_type in (1,10,53) |
| | | and io_type in (1,10,53,57) |
| | | order by io_pri desc,wrk_sts desc |
| | | </select> |
| | | |
| | |
| | | <select id="selectBy2125" resultMap="BaseResultMap"> |
| | | select * from dbo.asr_wrk_mast |
| | | where wrk_sts in (21,25) |
| | | and io_type in (101,103,110) |
| | | and io_type in (101,103,107,110) |
| | | order by io_pri desc,wrk_sts desc |
| | | </select> |
| | | |
| | |
| | | |
| | | <select id="selectPickStepByBarcode" resultMap="BaseResultMap"> |
| | | select top 1 * from asr_wrk_mast |
| | | where io_type in (53,103) |
| | | where io_type in (53,103,107) |
| | | and wrk_sts in (2,3,34,29) |
| | | and barcode = #{barcode} |
| | | order by io_pri desc,wrk_sts desc |