<select id="selectInParamRecord" parameterType="map" resultType="com.thinkgem.jeesite.modules.ada.entity.ParamRecordDto">
SELECT
serial_num AS serialNum,
creat_time AS createDate
FROM
t_gl_adapter_param_input
WHERE
service_type = '${insertIn.serviceType}'
<if test="insertIn.createDate != null and insertIn.createDate != ''">
<![CDATA[ and DATE_FORMAT(creat_time, '%Y-%m-%d')>=DATE_FORMAT(#{insertIn.createDate}, '%Y-%m-%d') ]]>
</if>
</select>
