| | |
| | | select h.id,m.* from tb_product_bom h,tb_material m where h.material_id = m.id; |
| | | </select> |
| | | <insert id="insertBomSelectBomH"> |
| | | insert into tb_product_bom(product_id,material_id,sub_version,quantity) |
| | | select product_id,material_id,#{subVersionMax},quantity from tb_product_bom_history where tb_product_bom_history.product_id=#{id} |
| | | insert into tb_product_bom(product_id,material_id,sub_version,quantity,category,producer,producer_specification,material,thickness,surface_detail,notes) |
| | | select product_id,material_id,#{subVersionMax},quantity,category,producer,producer_specification,material,thickness,surface_detail,notes from tb_product_bom_history where tb_product_bom_history.product_id=#{id} |
| | | </insert> |
| | | </mapper> |