From 2fb7ee4542f57ebbd9fff56758f02ea3dc24b677 Mon Sep 17 00:00:00 2001
From: CZT <czt18638530771@163.com>
Date: 星期四, 18 一月 2024 13:28:25 +0800
Subject: [PATCH] 调整熏蒸备案

---
 src/main/java/com/fzzy/api/view/repository/Api1202Rep.java |    8 ++++++++
 1 files changed, 8 insertions(+), 0 deletions(-)

diff --git a/src/main/java/com/fzzy/api/view/repository/Api1202Rep.java b/src/main/java/com/fzzy/api/view/repository/Api1202Rep.java
index f64cdcc..d1c0de7 100644
--- a/src/main/java/com/fzzy/api/view/repository/Api1202Rep.java
+++ b/src/main/java/com/fzzy/api/view/repository/Api1202Rep.java
@@ -44,4 +44,12 @@
 
     @Query("from Api1202 where rkjsdh=:rkjsdh ")
     List<Api1202> getDataByRkjsdh(@Param("rkjsdh") String rkjsdh);
+
+    /**
+     * 鏍规嵁璐т綅浠g爜鍜屼笟鍔℃棩鏈燂紝鍊掑簭鏌ヨ
+     * @param hwdm
+     * @return
+     */
+    @Query("from Api1202 where hwdm=:hwdm and ywrq <=:keyTime order by ywrq desc")
+    List<Api1202> getDataByHwdmAndTime(@Param("hwdm") String hwdm, @Param("keyTime") Date keyTime);
 }

--
Gitblit v1.9.3