From 4c6b38c84b14e90bd0844046645c61796746696c Mon Sep 17 00:00:00 2001 From: CZT <czt18638530771@163.com> Date: 星期六, 09 三月 2024 14:18:03 +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