From dba54bf8c8f9299d61c05bf3a941708ea399c998 Mon Sep 17 00:00:00 2001 From: ZhuDongming <773644075@qq.com> Date: Sun, 26 Apr 2020 15:20:22 +0800 Subject: [PATCH] update excel多个工作表导出 --- src/main/java/com/moral/mapper/SensorMapper.java | 27 +++++++++++++++------------ 1 files changed, 15 insertions(+), 12 deletions(-) diff --git a/src/main/java/com/moral/mapper/SensorMapper.java b/src/main/java/com/moral/mapper/SensorMapper.java index 0a63b1e..6c8e581 100644 --- a/src/main/java/com/moral/mapper/SensorMapper.java +++ b/src/main/java/com/moral/mapper/SensorMapper.java @@ -1,11 +1,12 @@ package com.moral.mapper; -import com.moral.common.mapper.BaseMapper; -import com.moral.entity.Sensor; -import org.apache.ibatis.annotations.Param; - import java.util.List; import java.util.Map; + +import org.apache.ibatis.annotations.Param; + +import com.moral.common.mapper.BaseMapper; +import com.moral.entity.Sensor; public interface SensorMapper extends BaseMapper<Sensor> { List<Sensor> selectByVersionId(Integer deviceVersionId); @@ -16,17 +17,19 @@ List<Sensor> selectByOrgId(Integer organizationId); - List<Map<String, Object>> getSensorsByDeviceVersionId(Map<String, Object> parameters); - - List<Sensor> getSensorsByCriteria(Map<String, Object> parameters); - - Map<String,Object> getSensorBySensorKey(@Param("sensor_key")String sensor_key); - - List<Map<String,Object>> getSensorByDeviceId(@Param("id")String id); + List<Map<String, Object>> getSensorsByDeviceVersionId(Map<String, Object> parameters); - List<Map<String,Object>> getSensorByMonitorPointId(@Param("monitor_point_id")String monitor_point_id); + List<Sensor> getSensorsByCriteria(Map<String, Object> parameters); + + Map<String, Object> getSensorBySensorKey(@Param("sensor_key") String sensor_key); + + List<Map<String, Object>> getSensorByDeviceId(@Param("id") String id); + + List<Map<String, Object>> getSensorByMonitorPointId(@Param("monitor_point_id") String monitor_point_id); List<Sensor> getSensorsByMac(Map<String, Object> parameters); List<Sensor> getSensorsInfoByMac(@Param("mac") String mac); + + List<Sensor> selectSenosrsByOrgId(Map<String, Object> parameters); } \ No newline at end of file -- Gitblit v1.8.0