From 7a9fd36cadbd5f0d8737955f0edd79e38ef19eaf Mon Sep 17 00:00:00 2001
From: 郑永安 <zyazyz250@sina.com>
Date: 星期二, 20 六月 2023 14:48:59 +0800
Subject: [PATCH] SQL异常修复
---
src/main/java/com/nanometer/smartlab/service/SysContainerSensorsService.java | 9 +++++++++
1 files changed, 9 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/nanometer/smartlab/service/SysContainerSensorsService.java b/src/main/java/com/nanometer/smartlab/service/SysContainerSensorsService.java
index 2ed59fd..ca1b5ad 100644
--- a/src/main/java/com/nanometer/smartlab/service/SysContainerSensorsService.java
+++ b/src/main/java/com/nanometer/smartlab/service/SysContainerSensorsService.java
@@ -5,6 +5,7 @@
import com.nanometer.smartlab.entity.dto.ContainerStatusMngDto;
import org.springframework.transaction.annotation.Transactional;
+import java.math.BigDecimal;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.LinkedHashMap;
@@ -28,5 +29,13 @@
int countAll(Map<String, Object> params) throws RuntimeException;
+ ContainerStatusMngDto getRowData(String rowKey);
+
+ Map<String,BigDecimal> selectMaxTemperature(String selectedContainerId, String beginDate, String endDate);
+
+ Map selectMaxHumidity(String selectedContainerId, String beginDate, String endDate);
+
+ Map selectMaxVoc(String selectedContainerId, String beginDate, String endDate);
+
//获得
}
--
Gitblit v1.9.2