根据产品id查询被锁定的物料dwg和产品丝印

lxw

2022-09-16 38fc24a1af1ba66de013966066796c46db3824f7

根据产品id查询被锁定的物料dwg和产品丝印

 src/main/resources/mapper/ProductMapper.xml

@@ -40,10 +40,12 @@
          and tb_product_bom.material_id=tb_material.id
          and tb_material.id=tb_attach_lock.material_id
          and tb_product.id=#{productId} and  locate(".dwg",tb_attach_lock.attach_name)>0
          and tb_attach_lock.lock_flag=1 
    </select>
    <select id="selectListProduct" resultType="com.whyc.pojo.AttachLock">
        select tb_attach_lock.*,tb_product.parent_name from tb_product,tb_attach_lock
        where tb_product.id=tb_attach_lock.product_id
          and tb_product.id=#{productId}
        and tb_product.id=#{productId}
        and tb_attach_lock.lock_flag=1
    </select>
</mapper>