| | |
|---|
| | | <result property="createDate" column="create_date"></result> |
|---|
| | | <result property="version" column="version"></result> |
|---|
| | | <result property="dwgUrl" column="dwg_url"></result> |
|---|
| | | <result property="replaceStatus" column="replaceStatus"></result> |
|---|
| | | <collection property="materials" javaType="java.util.ArrayList" ofType="com.whyc.pojo.Material" column="{productId=product_id,subCode=sub_code,version=version}" select="selectMaterial"> |
|---|
| | | </collection> |
|---|
| | | </resultMap> |
|---|
| | | <select id="getBomAndMaterial" resultMap="MaterialList" parameterType="java.lang.Integer"> |
|---|
| | | select distinct *,0 as replaceStatus from db_doc.tb_product_bom |
|---|
| | | select distinct * from db_doc.tb_product_bom |
|---|
| | | <where> |
|---|
| | | product_id = #{productId} |
|---|
| | | and |
|---|
