| | |
|---|
| | | <select id="selectApsPlantList" parameterType="ApsPlant" resultMap="ApsPlantResult"> |
|---|
| | | <include refid="selectApsPlantVo"/> |
|---|
| | | <where> |
|---|
| | | <if test="plantName != null and plantName != ''"> and plant_name like concat('%', #{plantName}, '%')</if> |
|---|
| | | <if test="plantCode != null and plantCode != ''"> and plant_code like concat('%', #{plantCode}, '%')</if> |
|---|
| | | <if test="plantName != null and plantName != ''"> and plant_name like '%' || #{plantName} || '%'</if> |
|---|
| | | <if test="plantCode != null and plantCode != ''"> and plant_code like '%' || #{plantCode} || '%'</if> |
|---|
| | | <if test="status != null and status != ''"> and status = #{status}</if> |
|---|
| | | </where> |
|---|
| | | </select> |
|---|
