From 92be463c5a038062c42d758a6e18be62955007a7 Mon Sep 17 00:00:00 2001 From: CZT <czt18638530771@163.com> Date: 星期四, 02 十一月 2023 20:35:17 +0800 Subject: [PATCH] 优化上海接口-调整视频信息等 --- src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1108Rep.java | 5 +++-- 1 files changed, 3 insertions(+), 2 deletions(-) diff --git a/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1108Rep.java b/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1108Rep.java index 0bff8b7..d48f734 100644 --- a/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1108Rep.java +++ b/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1108Rep.java @@ -5,6 +5,7 @@ import org.springframework.data.jpa.repository.Query; import org.springframework.data.repository.query.Param; +import java.util.Date; import java.util.List; /** @@ -14,6 +15,6 @@ */ public interface Fzzy40Sync1108Rep extends JpaRepository<Fz40Drug, String> { - @Query("from Fz40Drug where deptId=:deptId order by id") - List<Fz40Drug> listDrug(@Param("deptId") String deptId); + @Query("from Fz40Drug where deptId=:deptId and updateTime >=:start and updateTime <:end order by updateTime ") + List<Fz40Drug> listDrug(@Param("deptId") String deptId, @Param("start") Date start, @Param("end") Date end); } -- Gitblit v1.9.3