湖北水库项目
parent: affff835 | patch | commit | ignore whitespace
guoshilong
2023-05-25 eb762c46aadf696495f1261361fb93bb088177eb 
sql添加水库查询条件
1 files modified
1 ■■■■■ changed files
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/reportFlood/mapper/ReportFloodRecordMapper.xml 1 ●●●●● patch | view | raw | blame | history 
 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/reportFlood/mapper/ReportFloodRecordMapper.xml


@@ -52,6 +52,7 @@


    <select id="getLatestRecord" resultType="cn.gistack.sm.reportFlood.entity.ReportFloodRecord">


        SELECT * FROM SM_REPORT_FLOOD_RECORD


        WHERE IS_DELETED = 0 AND IS_AUDIT = 20


        AND reservoir_id = #{reservoirId}


        ORDER BY UPDATE_TIME DESC LIMIT 1


    </select>


</mapper>