质量不合格筛选修改

zss

6 小时以前 10af82e4a5571713c8821ddd319523b89beadd0e

质量不合格筛选修改

 src/main/resources/mapper/quality/QualityUnqualifiedMapper.xml

@@ -7,13 +7,13 @@
        FROM quality_unqualified
        where
        1=1
        <if test="qualityUnqualified.inspectType != null and qualityTestStandard.inspectType != '' ">
        <if test="qualityUnqualified.inspectType != null and qualityUnqualified.inspectType != '' ">
            AND inspect_type = #{qualityUnqualified.inspectType}
        </if>
        <if test="qualityUnqualified.inspectState != null and qualityTestStandard.inspectState != '' ">
        <if test="qualityUnqualified.inspectState != null and qualityUnqualified.inspectState != '' ">
            AND inspect_state = #{qualityUnqualified.inspectState}
        </if>
        <if test="qualityUnqualified.productName != null and qualityTestStandard.productName != '' ">
        <if test="qualityUnqualified.productName != null and qualityUnqualified.productName != '' ">
            AND product_name = #{qualityUnqualified.productName}
        </if>
    </select>
@@ -23,13 +23,13 @@
        FROM quality_unqualified
        where
        1=1
        <if test="qualityUnqualified.inspectType != null and qualityTestStandard.inspectType != '' ">
        <if test="qualityUnqualified.inspectType != null and qualityUnqualified.inspectType != '' ">
            AND inspect_type = #{qualityUnqualified.inspectType}
        </if>
        <if test="qualityUnqualified.inspectState != null and qualityTestStandard.inspectState != '' ">
        <if test="qualityUnqualified.inspectState != null and qualityUnqualified.inspectState != '' ">
            AND inspect_state = #{qualityUnqualified.inspectState}
        </if>
        <if test="qualityUnqualified.productName != null and qualityTestStandard.productName != '' ">
        <if test="qualityUnqualified.productName != null and qualityUnqualified.productName != '' ">
            AND product_name = #{qualityUnqualified.productName}
        </if>
    </select>