mybatis SELECT FROM vmi_materialdocument where if test=material != null and material != AND Material = #material if wh

日期: 2027-10-28
标签: 社会

SELECT * FROM vmi_materialdocument

    <if test="material != null and material != ''">
        AND Material = #{material}
    </if>
    <if test="quantityInBaseUnit != null">
        AND (QuantityInBaseUnit - IFNULL(ArtificialConsume, 0) - IFNULL(AutomaticConsume, 0)) > 0
    </if>

ORDER BY PostingDate mybatis SELECT FROM vmi_materialdocument where if test=material != null and material != AND Material = #material if wh

mybatis SELECT FROM vmi_materialdocument where if test=material != null and material != AND Material = #material if wh

原文地址: https://www.cveoy.top/t/topic/iM1q 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录