| | |
| | | } |
| | | } |
| | | if (command.getTaskNo2() > 0){ |
| | | List<WrkMastSta> wrkMastSta1 = wrkMastStaService.selectBywrkNoHistoricalTasks2(command.getRgvNo(),command.getTaskNo2()); |
| | | List<WrkMastSta> wrkMastSta1 = wrkMastStaService.selectBywrkNoHistoricalTasks(command.getRgvNo(),command.getTaskNo2()); |
| | | if (!Cools.isEmpty(wrkMastSta1)){ |
| | | for (WrkMastSta wrkMastSta :wrkMastSta1){ |
| | | wrkMastStaService.deleteById(wrkMastSta); |
| | |
| | | </select> |
| | | <select id="selectBywrkNoHistoricalTasks" resultMap="BaseResultMap"> |
| | | select * from asr_wrk_mast_sta |
| | | where wrk_crn = #{rgvNo} and wrk_no = #{taskNo1} |
| | | where wrk_crn = #{rgvNo} and (wrk_no = #{taskNo1} or wrk_no2 = #{taskNo1}) |
| | | </select> |
| | | <select id="selectBywrkNoHistoricalTasks2" resultMap="BaseResultMap"> |
| | | select * from asr_wrk_mast_sta |