<!-- 雨情数据查询-->
<select id="queryRain" parameterType="java.util.HashMap" resultType="java.util.HashMap">
select * from (select row_number() over (order by a.id desc) rn, a.*,b.stnm
from
dt_rain a inner join tb_station b on a.stcd=b.stcd
<where>
<if test="null != stcd and stcd != ''">
and a.stcd=#{stcd}
</if>
<if test="null != tmbegin and tmbegin != ''">
and
tm>=#{tmbegin}
</if>
<if test="null != tmend and tmend != ''">
and
tm<=#{tmend}
</if>
<select id="queryRain" parameterType="java.util.HashMap" resultType="java.util.HashMap">
select * from (select row_number() over (order by a.id desc) rn, a.*,b.stnm
from
dt_rain a inner join tb_station b on a.stcd=b.stcd
<where>
<if test="null != stcd and stcd != ''">
and a.stcd=#{stcd}
</if>
<if test="null != tmbegin and tmbegin != ''">
and
tm>=#{tmbegin}
</if>
<if test="null != tmend and tmend != ''">
and
tm<=#{tmend}
</if>