物料查询附件锁定信息

lxw

2022-09-14 391cfde7a1177d6508bea15a39733bd731e86774

物料查询附件锁定信息

 src/main/resources/mapper/MaterialMapper.xml

@@ -266,6 +266,8 @@
        <result property="dwgUrl" column="dwg_url"></result>
        <collection property="products" javaType="java.util.ArrayList" ofType="com.whyc.pojo.Product" column="{id=id}" select="selectInProduct">
        </collection>
        <collection property="attachLocks" javaType="java.util.ArrayList" ofType="com.whyc.pojo.AttachLock" column="{id=id}" select="selectInAttachLock">
        </collection>
    </resultMap>
    <select id="getMaterialById" resultMap="materialInfo">
        select * from db_doc.tb_material WHERE id = #{materialId} limit 1
@@ -275,4 +277,8 @@
        where tb_product.id=tb_product_bom.product_id
        and tb_product_bom.material_id=#{id}
    </select>
    <select id="selectInAttachLock"  resultType="attachLock">
        select DISTINCT tb_attach_lock.*  FROM db_doc.tb_attach_lock
        where tb_attach_lock.material_id=#{id}
    </select>
</mapper>