产品中心绑定ecr变更的时候,只需要物料编码确定唯一性就可以了

whycxzp

2023-06-02 4ee1f60c0c5cc02ac09986efc3f03e9751560722

产品中心绑定ecr变更的时候,只需要物料编码确定唯一性就可以了

 src/main/resources/mapper/ProductMapper.xml

@@ -18,7 +18,7 @@
        <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 property="ecrList" javaType="java.util.ArrayList" ofType="com.whyc.pojo.ECR" column="{subCode=parent_code}" select="selectEcrProduct">
        </collection>
    </resultMap>
    <select id="getAllProduct" resultMap="ProductErcList">
@@ -65,7 +65,7 @@
    </resultMap>
    <select id="selectEcrProduct" resultMap="ECRWebSockt">
        select tb_ecr.* from tb_ecr
        where sub_code=#{subCode} and sub_model=#{subModel}
        where sub_code=#{subCode}
        order by create_time desc
    </select>
    <select id="selectListMaterial" resultType="attachLock">