| | |
|---|
| | | <include refid="selectApsBomHeaderVo"/> |
|---|
| | | <where> |
|---|
| | | <if test="bomHeaderId != null and bomHeaderId != ''"> and bom_header_id = #{bomHeaderId}</if> |
|---|
| | | <if test="itemCode != null and itemCode != ''"> and item_code = #{itemCode}</if> |
|---|
| | | <if test="itemCode != null and itemCode != ''"> and item_code like '%' || #{itemCode} || '%'</if> |
|---|
| | | <if test="itemName != null and itemName != ''"> and item_name = #{itemName}</if> |
|---|
| | | <if test="startDate != null "> and start_date = #{startDate}</if> |
|---|
| | | <if test="endDate != null "> and end_date = #{endDate}</if> |
|---|
