湖北水库项目
parent: aea93f17 | patch | commit | show whitespace
xieb
2023-11-20 438e7530cf959f73e40e27386aeb9c7ae3dbbf57 
大坝安全监控预警列表
1 files modified
5 ■■■■■ changed files
skjcmanager/skjcmanager-service/skjcmanager-nky/src/main/java/cn/gistack/nky/mapper/AlarmGetMapper.xml 5 ●●●●● patch | view | raw | blame | history 
 skjcmanager/skjcmanager-service/skjcmanager-nky/src/main/java/cn/gistack/nky/mapper/AlarmGetMapper.xml


@@ -88,9 +88,12 @@


        <if test="vo.pointId != null and vo.pointId !='' ">


            AND NAG.POINT_id = #{vo.pointId}


        </if>


        <if test="vo.cdName != null and vo.cdName !=''">


        <if test="vo.cdName != null and vo.cdName !='' and vo.tpe != 3">


            AND acb."cd_nm" LIKE CONCAT('%',#{vo.cdName},'%')


        </if>


        <if test="vo.cdName != null and vo.cdName !='' and vo.tpe == 3">


            AND awcb."cd_nm" LIKE CONCAT('%',#{vo.cdName},'%')


        </if>


        AND NAG.dam_id =  #{vo.damId}


        ORDER BY NAG."TIME" DESC


        )temp