From ac9b4c99b2534e31a8ce9948b376feb514c2ec20 Mon Sep 17 00:00:00 2001
From: CZT <czt18638530771@163.com>
Date: 星期五, 01 三月 2024 11:31:52 +0800
Subject: [PATCH] 优化损益数据同步

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

diff --git a/src/main/java/com/fzzy/api/view/repository/Api1205Rep.java b/src/main/java/com/fzzy/api/view/repository/Api1205Rep.java
index 0de6e06..0809515 100644
--- a/src/main/java/com/fzzy/api/view/repository/Api1205Rep.java
+++ b/src/main/java/com/fzzy/api/view/repository/Api1205Rep.java
@@ -34,4 +34,20 @@
      */
     @Query("from Api1205 where bizId =:bizId")
     List<Api1205> getDataByBizId(@Param("bizId") String bizId);
+
+    /**
+     * 鏍规嵁鍑哄簱缁撶畻鍗曞彿鏌ヨ鏁版嵁
+     * @param ckjsdh
+     * @return
+     */
+    @Query("from Api1205 where ckjsdh =:ckjsdh")
+    List<Api1205> getDataByCkjsdh(@Param("ckjsdh") String ckjsdh);
+
+    /**
+     * 鏍规嵁璐т綅浠g爜鍜屼笟鍔℃棩鏈燂紝姝e簭鏌ヨ
+     * @param hwdm
+     * @return
+     */
+    @Query("from Api1205 where hwdm=:hwdm and ywrq >=:keyTime order by ywrq asc ")
+    List<Api1205> getDataByHwdmAndTime(@Param("hwdm") String hwdm, @Param("keyTime") Date keyTime);
 }

--
Gitblit v1.9.3