From 30d46d06fb4153e48df281d3008ed90935b3c06d Mon Sep 17 00:00:00 2001 From: riku <risaku@163.com> Date: 星期二, 19 七月 2022 16:45:08 +0800 Subject: [PATCH] 1. 新增扬尘监测数据超标情况表 --- src/main/kotlin/cn/flightfeather/supervision/domain/ds1/mapper/MonitorobjectversionMapper.kt | 5 +++++ 1 files changed, 5 insertions(+), 0 deletions(-) diff --git a/src/main/kotlin/cn/flightfeather/supervision/domain/ds1/mapper/MonitorobjectversionMapper.kt b/src/main/kotlin/cn/flightfeather/supervision/domain/ds1/mapper/MonitorobjectversionMapper.kt index bf051e9..0cbce76 100644 --- a/src/main/kotlin/cn/flightfeather/supervision/domain/ds1/mapper/MonitorobjectversionMapper.kt +++ b/src/main/kotlin/cn/flightfeather/supervision/domain/ds1/mapper/MonitorobjectversionMapper.kt @@ -3,7 +3,12 @@ import cn.flightfeather.supervision.domain.ds1.entity.Monitorobjectversion import cn.flightfeather.supervision.domain.util.MyMapper import org.apache.ibatis.annotations.Mapper +import org.apache.ibatis.annotations.Select @Mapper interface MonitorobjectversionMapper:MyMapper<Monitorobjectversion> { + + @Select("select b.S_GUID from sm_t_monitorobjectversion as a left join sm_t_scense as b on a.S_GUID = b.S_GUID" + + " where a.T_ID = #{param1} and b.S_TypeID = #{param2}") + fun getSceneByType(topTaskId: String, sceneTypeId: Int): List<String> } \ No newline at end of file -- Gitblit v1.9.3