'lxw'

he wei

2022-09-07 c91a3aabe6fbe8dfbbdaf7bb6fdee031e2cbfb40

'lxw'

 src/main/resources/mapper/ProductBomHistoryMapper.xml

@@ -86,8 +86,13 @@
        where apply_material_code=#{subCode}
    </select>
    <select id="selectMaterial"  resultType="com.whyc.pojo.Material">
        select DISTINCT tb_software.*  FROM db_doc.tb_software
        where apply_material_code=#{parentCode}
        select DISTINCT tb_Material.*  FROM db_doc.tb_Material,db_doc.tb_material_product_history
        where tb_Material.id=tb_material_product_history.material_id
        and tb_material_product_history.parent_code=#{parentCode}
        and tb_material_product_history.custom_code=#{customCode}
        and tb_material_product_history.sub_material_id=#{materialId}
        and tb_material_product_history.s_version&lt;=#{version}
        and tb_material_product_history.e_version>=#{version}
    </select>