| | |
| | | } |
| | | } |
| | | // 修改源库位状态 |
| | | if (shallowLoc.getLocSts().equals("D") || shallowLoc.getLocSts().equals("M") || shallowLoc.getLocSts().equals("Z")) { |
| | | if (shallowLoc.getLocSts().equals("F") || shallowLoc.getLocSts().equals("M") || shallowLoc.getLocSts().equals("Z")) { |
| | | shallowLoc.setLocSts("R"); // R.出库预约 |
| | | shallowLoc.setModiTime(new Date()); |
| | | if (!locMastService.updateById(shallowLoc)) { |
| | |
| | | select top 1 * from asr_loc_mast where crn_no = #{crnNo} and loc_sts = 'O' |
| | | ORDER BY NEWID() |
| | | </select> |
| | | <select id="queryFreeLocMastNew" resultType="com.zy.entity.LocMast"> |
| | | <select id="queryFreeLocMastNew" resultMap="BaseResultMap"> |
| | | select top 1 * |
| | | from asr_loc_mast |
| | | where row1=#{row} |