From 930d29f39d115fe76c305af4320c2acbcb30c445 Mon Sep 17 00:00:00 2001
From: czt <czt18638530771@163.com>
Date: 星期四, 12 六月 2025 10:37:37 +0800
Subject: [PATCH] 优化SQL
---
igds-core/src/main/java/com/ld/igds/view/service/HDepotStoreService.java | 22 ++++++++++++++++++++++
1 files changed, 22 insertions(+), 0 deletions(-)
diff --git a/igds-core/src/main/java/com/ld/igds/view/service/HDepotStoreService.java b/igds-core/src/main/java/com/ld/igds/view/service/HDepotStoreService.java
index bf55d3a..6df9589 100644
--- a/igds-core/src/main/java/com/ld/igds/view/service/HDepotStoreService.java
+++ b/igds-core/src/main/java/com/ld/igds/view/service/HDepotStoreService.java
@@ -11,6 +11,7 @@
import java.util.Date;
import java.util.HashMap;
+import java.util.List;
import java.util.Map;
@Component
@@ -93,4 +94,25 @@
}
return null;
}
+
+ public DepotStore getLastData(String depotId, Date time) {
+
+ StringBuilder hql = new StringBuilder();
+ hql.append(" from " + DepotStore.class.getName() + " where depotId = :depotId ");
+
+ Map<String, Object> args = new HashMap<>();
+ args.put("depotId", depotId);
+
+ if (null != time) {
+ hql.append(" and createDate <=:createDate");
+ args.put("createDate", time);
+ }
+ hql.append(" order by createDate desc");
+
+ List<DepotStore> list = this.query(hql.toString(), args);
+ if (null == list || list.isEmpty()) {
+ return null;
+ }
+ return list.get(0);
+ }
}
--
Gitblit v1.9.3