<select id="queryReconnoitreEventConfig" parameterType="reconnoitreEventConfig" resultType="reconnoitreEventConfig">
SELECT recon_event_id,recon_event_name,commun_file_type,(select item_name from tb_bmp_code_item where type_id=66 and item_code=commun_file_type) commun_file_type_name,reconnoitre_frequency,reconnoitre_point,reconnoitre_period,reconnoitre_limits,acquisition_rules,reconnoitre_way FROM tb_reconnoitre_event_config WHERE 1=1
<if test="reconEventName != null and reconEventName != ''">
and recon_event_name like concat('%',#{reconEventName},'%')
</if>
</select>
SELECT recon_event_id,recon_event_name,commun_file_type,(select item_name from tb_bmp_code_item where type_id=66 and item_code=commun_file_type) commun_file_type_name,reconnoitre_frequency,reconnoitre_point,reconnoitre_period,reconnoitre_limits,acquisition_rules,reconnoitre_way FROM tb_reconnoitre_event_config WHERE 1=1
<if test="reconEventName != null and reconEventName != ''">
and recon_event_name like concat('%',#{reconEventName},'%')
</if>
</select>