| | |
| | | package com.yssh.dao; |
| | | |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | import com.yssh.entity.*; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | | import com.yssh.entity.DistanceSuYuan; |
| | | import com.yssh.entity.SuYuan2d; |
| | | import com.yssh.entity.SuYuan3d; |
| | | import com.yssh.entity.SuYuanMonitorData; |
| | | import com.yssh.entity.Temporary; |
| | | |
| | | @Mapper |
| | | public interface SuYuanMapper extends BaseMapper{ |
| | | public interface SuYuanMapper extends BaseMapper { |
| | | Integer isTableExists(String tableName); |
| | | |
| | | int createTable(@Param("tableName") String tableName); |
| | | |
| | | |
| | | List<SuYuan2d> get2d(@Param("tableName") String tableName, @Param("ids") List<String> ids); |
| | | |
| | | |
| | | List<SuYuan3d> get3d(@Param("tableName") String tableName, @Param("ids") List<String> ids); |
| | | |
| | | List<DistanceSuYuan> getDistanceSuYuan(@Param("tableName") String tableName, @Param("ids") List<String> ids); |
| | |
| | | DistanceSuYuan getSuYuan500Max(@Param("tableName") String tableName, @Param("ids") List<String> ids); |
| | | |
| | | DistanceSuYuan getSuYuanById(@Param("tableName") String tableName, @Param("id") String id); |
| | | |
| | | |
| | | List<Temporary> getTemporary(@Param("tableName") String tableName, @Param("ids") List<String> ids); |
| | | |
| | | |
| | | int update(@Param("tableName") String tableName, @Param("id") String id, @Param("value") String value); |
| | | |
| | | List<SuYuan2d> getAlarmsAnalyse(@Param("tableName") String tableName, @Param("ids") List<String> ids); |
| | | |
| | | List<SuYuan2d> getWarningAnalyse(@Param("tableName") String tableName, @Param("ids") List<String> ids); |
| | | |
| | | |
| | | List<SuYuanMonitorData> getMonitorData(@Param("tableNames") List<String> tableNames, @Param("id") String id); |
| | | |
| | | List<SuYuanMonitorData> getNewMonitorData(String name, String start, String end); |
| | | |
| | | |
| | | //获取本月指定监测站点监测值对大的数据 |
| | | Map<String, Object> getMonthValueDataMax(@Param("tableNames") List<String> tableNames, @Param("id") String id); |
| | | |
| | | int updateVocsName(String table, String id, String vocsName); |
| | | |
| | | SuYuan700 selectSuYuan700ById(String id, String time); |
| | | } |