1.盘点出库状态工作任务不进行删除
2.托盘码为空不允许进行盘点出库
| | |
| | | if (null != one) locDetlDtos.add(new LocDetlDto(one, one.getAnfme())); |
| | | } |
| | | } |
| | | for (LocDetlDto e: locDetlDtos) { |
| | | if (Cools.isEmpty(e.getLocDetl().getZpallet())) { |
| | | throw new CoolException("托盘码为空不允许盘点,库位号" + e.getLocDetl().getLocNo()); |
| | | } |
| | | } |
| | | if (!locDetlDtos.isEmpty()) { |
| | | // 启动出库开始 107.盘点出库 |
| | | stockOut(staNo, locDetlDtos, 107, userId); |
| | |
| | | |
| | | <select id="selectToBeHistoryData" resultMap="BaseResultMap"> |
| | | select * from asr_wrk_mast |
| | | where wrk_sts=5 |
| | | where wrk_sts=5 and io_type != 107 |
| | | or (wrk_sts=15 and ove_mk='Y' and wrk_no not in (select wrk_no from asr_bas_devp)) |
| | | or (wrk_sts=15 and dateadd(mi,15,crn_end_time) <= getdate() and wrk_no not in (select wrk_no from asr_bas_devp)) |
| | | or (wrk_sts=15 and crn_end_time is null and wrk_no not in (select wrk_no from asr_bas_devp)) |