From 069c3ea2792899256f46c44ff2bd497d91f91a4d Mon Sep 17 00:00:00 2001 From: CZT <czt18638530771@163.com> Date: 星期五, 08 三月 2024 16:03:30 +0800 Subject: [PATCH] 优化出入库数据同步的必填项 --- src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1111Rep.java | 7 +++---- 1 files changed, 3 insertions(+), 4 deletions(-) diff --git a/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1111Rep.java b/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1111Rep.java index 2f2903c..630a595 100644 --- a/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1111Rep.java +++ b/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1111Rep.java @@ -4,6 +4,7 @@ import org.springframework.data.jpa.repository.JpaRepository; import org.springframework.data.jpa.repository.Query; import org.springframework.data.repository.query.Param; +import java.util.Date; import java.util.List; /** @@ -16,9 +17,7 @@ * * @return */ -// @Query("from Fz40SecCamera where deptId=:deptId and updateTime >=:start and updateTime <:end order by updateTime ") -// List<Fz40SecCamera> listCamera(@Param("deptId") String deptId, @Param("start") Date start, @Param("end") Date end); - @Query("from Fz40SecCamera where deptId=:deptId order by ipIn") - List<Fz40SecCamera> listCamera(@Param("deptId") String deptId); + @Query("from Fz40SecCamera where deptId=:deptId and updateTime >=:start and updateTime <:end order by ipIn ") + List<Fz40SecCamera> listCamera(@Param("deptId") String deptId, @Param("start") Date start, @Param("end") Date end); } -- Gitblit v1.9.3