ApsPlateStandardRequireError Mapper调整

zhanghl

2025-05-13 6c20a020ce163c3255d1dd8900036c1b631f98f4

ApsPlateStandardRequireError Mapper调整

 aps-modules/aps-core/src/main/resources/mapper/core/ApsPlateStandardRequireErrorMapper.xml

@@ -4,7 +4,7 @@
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.aps.core.mapper.ApsPlateStandardRequireErrorMapper">
    
    <resultMap type="ApsPlateStandardRequireError" id="ApsPlateStandardRequireErrorResult">
    <resultMap type="com.aps.core.domain.ApsPlateStandardRequireError" id="ApsPlateStandardRequireErrorResult">
        <result property="id"    column="id"    />
        <result property="batchNumber"    column="batch_number"    />
        <result property="requireId"    column="require_id"    />
@@ -23,7 +23,7 @@
        select id, batch_number, require_id, doc_num, item_num, org_code, message, del_flag, create_by, create_time, update_by, update_time from aps_plate_standard_require_error
    </sql>

    <select id="selectApsPlateStandardRequireErrorList" parameterType="ApsPlateStandardRequireError" resultMap="ApsPlateStandardRequireErrorResult">
    <select id="selectApsPlateStandardRequireErrorList" parameterType="com.aps.core.domain.ApsPlateStandardRequireError" resultMap="ApsPlateStandardRequireErrorResult">
        <include refid="selectApsPlateStandardRequireErrorVo"/>
        <where>  
            <if test="batchNumber != null  and batchNumber != ''"> and batch_number = #{batchNumber}</if>
@@ -32,7 +32,9 @@
            <if test="itemNum != null  and itemNum != ''"> and item_num = #{itemNum}</if>
            <if test="orgCode != null  and orgCode != ''"> and org_code = #{orgCode}</if>
            <if test="message != null  and message != ''"> and message = #{message}</if>
            and del_flag = '0'
        </where>

    </select>
    
    <select id="selectApsPlateStandardRequireErrorById" parameterType="Long" resultMap="ApsPlateStandardRequireErrorResult">
@@ -40,7 +42,7 @@
        where id = #{id}
    </select>

    <insert id="insertApsPlateStandardRequireError" parameterType="ApsPlateStandardRequireError">
    <insert id="insertApsPlateStandardRequireError" parameterType="com.aps.core.domain.ApsPlateStandardRequireError">
        insert into aps_plate_standard_require_error
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">id,</if>
@@ -72,7 +74,7 @@
         </trim>
    </insert>

    <update id="updateApsPlateStandardRequireError" parameterType="ApsPlateStandardRequireError">
    <update id="updateApsPlateStandardRequireError" parameterType="com.aps.core.domain.ApsPlateStandardRequireError">
        update aps_plate_standard_require_error
        <trim prefix="SET" suffixOverrides=",">
            <if test="batchNumber != null">batch_number = #{batchNumber},</if>