From 979f95e192e306bf8ae6552415d20c57015baab4 Mon Sep 17 00:00:00 2001
From: 严智鑫 <test>
Date: 星期三, 22 十月 2025 13:59:05 +0800
Subject: [PATCH] 优化：短连接+抛异常 防止异常导致端口占用 无法连接设备
---
JiuMuMesParent/moduleService/DeviceInteractionModule/src/main/java/com/mes/utilization/controller/UtilizationController.java | 10 +++++++++-
1 files changed, 9 insertions(+), 1 deletions(-)
diff --git a/JiuMuMesParent/moduleService/DeviceInteractionModule/src/main/java/com/mes/utilization/controller/UtilizationController.java b/JiuMuMesParent/moduleService/DeviceInteractionModule/src/main/java/com/mes/utilization/controller/UtilizationController.java
index 0ccf8e6..aa5aa13 100644
--- a/JiuMuMesParent/moduleService/DeviceInteractionModule/src/main/java/com/mes/utilization/controller/UtilizationController.java
+++ b/JiuMuMesParent/moduleService/DeviceInteractionModule/src/main/java/com/mes/utilization/controller/UtilizationController.java
@@ -11,6 +11,7 @@
import org.springframework.util.StringUtils;
import org.springframework.web.bind.annotation.*;
+import java.util.Calendar;
import java.util.Date;
import java.util.List;
import java.util.Map;
@@ -82,12 +83,19 @@
@ResponseBody
public Result getChartData(@RequestBody(required = false) Map<String, Object> params) {
String lineNo = params != null ? (String) params.get("lineNo") : null;
+ Integer dayCount = params != null && params.get("dayCount") != null ? (Integer) params.get("dayCount") : null;
QueryWrapper<Utilization> queryWrapper = new QueryWrapper<Utilization>().orderByAsc("record_time");
if (StringUtils.hasText(lineNo)) {
queryWrapper.eq("line_no", lineNo);
}
- queryWrapper.last("limit 30");
+
+ if (dayCount != null && dayCount > 0) {
+ Calendar calendar = Calendar.getInstance();
+ calendar.add(Calendar.DAY_OF_MONTH, -dayCount);
+ Date startDate = calendar.getTime();
+ queryWrapper.ge("record_time", startDate);
+ }
List<Utilization> data = utilizationService.list(queryWrapper);
--
Gitblit v1.8.0