| | |
| | | <where> |
| | | <if test="bomLineId != null and bomLineId != ''"> and bom_line_id = #{bomLineId}</if> |
| | | <if test="bomHeaderId != null and bomHeaderId != ''"> and bom_header_id = #{bomHeaderId}</if> |
| | | <if test="itemCode != null and itemCode != ''"> and item_code like '%'||#{itemCode}||'%'</if> |
| | | <if test="itemName != null and itemName != ''"> and item_name like '%'|| #{itemName}||'%'</if> |
| | | <if test="itemCode != null and itemCode != ''"> and item_code like '%' || #{itemCode} || '%'</if> |
| | | <if test="itemName != null and itemName != ''"> and item_name like '%' || #{itemName} || '%'</if> |
| | | <if test="params.beginStartDate != null and params.beginStartDate != '' and params.endStartDate != null and params.endStartDate != ''"> and start_date between #{params.beginStartDate} and #{params.endStartDate}</if> |
| | | <if test="params.beginEndDate != null and params.beginEndDate != '' and params.endEndDate != null and params.endEndDate != ''"> and end_date between #{params.beginEndDate} and #{params.endEndDate}</if> |
| | | <if test="orgCode != null and orgCode != ''"> and org_code = #{orgCode}</if> |