产品设定可行性

lxw

2022-09-09 34958c066bf073d52b71dbbd77d911f265c8f046

产品设定可行性

 src/main/java/com/whyc/mapper/ProductBomMapper.java

@@ -29,5 +29,5 @@


    //6.在productBom中插入pHsitoryBom查询出的数据
    int insertBomSelectBomH(Integer id);
    int insertBomSelectBomH(Integer id,Integer subVersionMax);
}

 src/main/java/com/whyc/service/ProductHistoryService.java

@@ -116,7 +116,7 @@
                    // 5.在product中插入设定可用的pHistory
                    productMapper.insertPselectPH(pHistory.getId());
                    //6.在productBom中插入pHsitoryBom查询出的数据
                    productBomMapper.insertBomSelectBomH(pHistory.getId());
                    productBomMapper.insertBomSelectBomH(pHistory.getId(),pHistory.getSubVersionMax());
                }
            }
        }else{

 src/main/resources/mapper/ProductBomMapper.xml

@@ -202,7 +202,7 @@
        and p.parent_code = #{parentCode} and p.custom_code = #{customCode}
    </select>
    <insert id="insertBomSelectBomH">
        insert into db_doc.tb_product_bom(product_id,material_id,sub_s_version,sub_e_version,quantity)
        select product_id,material_id,sub_s_version,sub_e_version from db_doc.tb_product_bom_history where tb_product_bom_history.product_id=#{id}
        insert into db_doc.tb_product_bom(product_id,material_id,sub_version,quantity)
        select product_id,material_id,#{subVersionMax},quantity from db_doc.tb_product_bom_history where tb_product_bom_history.product_id=#{id}
    </insert>
</mapper>