捡料出库bug

ZY

2024-08-23 3a6385e0d275b21f6e70c3588937c5e0972ca029

捡料出库bug

 src/main/resources/mapper/WrkDetlMapper.xml

@@ -97,9 +97,24 @@
    </update>

    <select id="selectAndLogByOrderNo" resultMap="BaseResultMap">
        select * from asr_wrk_detl where order_no = #{orderNo}
        union
        select * from asr_wrk_detl_log where order_no = #{orderNo}
--         select * from asr_wrk_detl where order_no = #{orderNo}
--         union
--         select * from asr_wrk_detl_log where order_no = #{orderNo}
        SELECT
            d.*
        FROM
            asr_wrk_detl d
        WHERE
            order_no = #{orderNo} UNION
        SELECT
            d.*
        FROM
            asr_wrk_detl_log d
                JOIN asr_wrk_mast_log m ON d.wrk_no= m.wrk_no
        WHERE
            d.order_no = #{orderNo}
          AND m.io_time= d.io_time
          AND m.io_type!= 53
    </select>

    <update id="updateInspect">