| | |
|---|
| | | <select id="selectArdAlarmpointsWellList" parameterType="ArdAlarmpointsWell" resultMap="ArdAlarmpointsWellResult"> |
|---|
| | | <include refid="selectArdAlarmpointsWellVo"/> |
|---|
| | | <where> |
|---|
| | | <if test="wellId != null and wellId != ''">and c.well_id = #{wellId}</if> |
|---|
| | | <if test="wellId != null and wellId != ''">and c.well_id like ('%${wellId}%')</if> |
|---|
| | | <if test="wellNumber != null and wellNumber != ''">and c.well_number = #{wellNumber}</if> |
|---|
| | | <if test="userId != null and userId != ''">and c.user_id = #{userId}</if> |
|---|
| | | <if test="deptId != null ">and (c.dept_id = #{deptId} OR c.dept_id IN ( SELECT t.dept_id FROM sys_dept t |
|---|
