产品详情软件是不被锁定的getBomHistoryAndMaterial

lxw

2022-11-03 24e9638301e78a67dba0681ac26839924c2f81cf

产品详情软件是不被锁定的getBomHistoryAndMaterial

 src/main/resources/mapper/ProductBomHistoryMapper.xml

@@ -95,7 +95,7 @@
    </select>
    <select id="selectSoftWares"  resultType="com.whyc.pojo.Software">
        select DISTINCT tb_software.*  FROM tb_software
        where apply_material_code=#{subCode}
        where apply_material_code=#{subCode}  and  lock_flag=0
    </select>
    <select id="selectMaterial"  resultType="com.whyc.pojo.Material">
        select DISTINCT tb_Material.*  FROM tb_Material,tb_material_product_history
@@ -113,7 +113,7 @@

    <select id="selectSoftware"  resultType="com.whyc.pojo.Software">
        select DISTINCT tb_software.*  FROM tb_software
        where apply_material_code=#{parentCode}
        where apply_material_code=#{parentCode} and  lock_flag=0
    </select>
    <select id="getBomListByProductIdAndSubVersion" resultMap="Map_ProductBomHistory">
        <!--SELECT h.product_id,h.material_id,h.quantity,m.*-->