ECR

lxw

2023-02-23 d0e4a1a2192982a93d51a0372191ae14455341ba

ECR

 src/main/java/com/whyc/pojo/Product.java

@@ -59,4 +59,7 @@
    @TableField(exist = false)
    private String fileUrl;

    @TableField(exist = false)
    private List<ECR> ecrList;

}

 src/main/resources/mapper/ProductMapper.xml

@@ -7,7 +7,21 @@
        insert into tb_product(id,parent_code,parent_name,parent_model,notes,custom_code,create_time,version_time,version)
        select id,parent_code,parent_name,parent_model,notes,custom_code,create_time,version_time,version from tb_product_history where tb_product_history.id=#{id}
    </insert>
    <select id="getAllProduct" resultType="Product">

    <resultMap id="ProductErcList" type="Product">
        <id property="id" column="id"></id>
        <result property="parentCode" column="parent_code"></result>
        <result property="parentName" column="parent_name"></result>
        <result property="parentModel" column="parent_model"></result>
        <result property="customCode" column="custom_code"></result>
        <result property="createTime" column="create_time"></result>
        <result property="versionTime" column="version_time"></result>
        <result property="version" column="version"></result>
        <result property="notes" column="notes"></result>
        <collection property="ecrList" javaType="java.util.ArrayList" ofType="com.whyc.pojo.ECR" column="{subCode=parent_code,subModel=parent_model}" select="selectEcrProduct">
        </collection>
    </resultMap>
    <select id="getAllProduct" resultMap="ProductErcList">
        select distinct tb_product.* from tb_product,tb_product_bom,tb_material
        <where>
            tb_product.id=tb_product_bom.product_id
@@ -35,6 +49,10 @@
        </where>
        order by tb_product.version_time desc
    </select>
    <select id="selectEcrProduct" resultType="ECR">
        select ecr.*from tb_ecr
        where sub_code=#{subCode} and sub_model=#{subModel}
    </select>
    <select id="selectListMaterial" resultType="attachLock">
        select tb_attach_lock.*,tb_material.sub_name from tb_product,tb_material,tb_product_bom,tb_attach_lock
        where tb_product.id=tb_product_bom.product_id