整理订单查询工作明细时排除拣料入库

pang.jiabao

2025-03-27 4acea76809cad918ed742c77bd6e72652c32a2cd

整理订单查询工作明细时排除拣料入库

 src/main/resources/mapper/WrkDetlMapper.xml

@@ -82,9 +82,9 @@
    </update>

    <select id="selectAndLogByOrderNo" resultMap="BaseResultMap">
        select * from asr_wrk_detl where order_no = #{orderNo}
        select * from asr_wrk_detl where order_no = #{orderNo} and io_type != 53
        union
        select * from asr_wrk_detl_log where order_no = #{orderNo}
        select * from asr_wrk_detl_log where order_no = #{orderNo} and io_type != 53
    </select>

    <update id="updateInspect">