<select id="getGyggZdByCondition" resultMap="BaseResultMap" parameterType="com.gisquest.zrzy.tdsc.domain.gsgg.GyggZd">
select
<include refid="Base_Column_List" />
from td_gygg_zd
where
1 = 1
<if test="zdBh != null and zdBh != ''" >
and ZD_BH like CONCAT('%',#{zdBh,jdbcType=VARCHAR}, '%')
</if>
<if test="gyggZdGuid != null and gyggZdGuid != ''" >
and GYGG_ZD_GUID = #{gyggZdGuid,jdbcType=VARCHAR}
</if>
</select>