| | |
|---|
| | | </select> |
|---|
| | | <select id="selectMaterialProductHistory" resultType="com.whyc.pojo.MaterialProductHistory"> |
|---|
| | | select DISTINCT tb_Material_product_history.* FROM db_doc.tb_material_product_history,db_doc.tb_product |
|---|
| | | where tb_product.version=tb_Material_product_history.version |
|---|
| | | and tb_product.id=tb_Material_product_history.product_id |
|---|
| | | where tb_product.version>=tb_Material_product_history.s_version and tb_product.version<=tb_Material_product_history.e_version |
|---|
| | | and tb_product.parent_code=tb_Material_product_history.parent_code |
|---|
| | | and tb_product.custom_code=tb_Material_product_history.custom_code |
|---|
| | | and tb_Material_product_history.material_id=#{id} |
|---|
| | | </select> |
|---|
| | | <select id="selectMaterialInProduct" resultType="com.whyc.pojo.Product"> |
|---|
