From bfa4c9b7258cc25ed9d6e5511fede769b4ef5ea9 Mon Sep 17 00:00:00 2001 From: YYC <1833023622@qq.com> Date: 星期一, 28 十月 2024 23:38:34 +0800 Subject: [PATCH] 提交代码 --- src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1212Rep.java | 15 +++++++++------ 1 files changed, 9 insertions(+), 6 deletions(-) diff --git a/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1212Rep.java b/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1212Rep.java index 9fab138..0f56465 100644 --- a/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1212Rep.java +++ b/src/main/java/com/fzzy/async/fzzy40/repository/Fzzy40Sync1212Rep.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; @@ -13,14 +14,16 @@ public interface Fzzy40Sync1212Rep extends JpaRepository<Fz40InoutCustomer, String> { /** - * 鏍规嵁淇℃伅鑾峰彇瀹㈡埛淇℃伅 + * 鏍规嵁淇℃伅鑾峰彇瀹㈡埛鍗曚綅淇℃伅 * - * @param start - * @param end * @return */ -// @Query("from Fz40InoutCustomer where deptId=:deptId and updateTime >=:start and updateTime <:end order by updateTime ") -// List<Fz40InoutCustomer> listInoutCustomer(@Param("deptId") String deptId, @Param("start") Date start, @Param("end") Date end); - @Query("from Fz40InoutCustomer where deptId=:deptId order by updateTime ") + @Query("from Fz40InoutCustomer where deptId=:deptId order by id ") List<Fz40InoutCustomer> listInoutCustomer(@Param("deptId") String deptId); + + @Query("from Fz40InoutCustomer where deptId=:deptId and updateTime >=:start and updateTime <=:end order by id ") + List<Fz40InoutCustomer> listInoutCustomer(@Param("deptId") String deptId, @Param("start") Date start, @Param("end") Date end); + + @Query("from Fz40InoutCustomer where id=:id order by id ") + List<Fz40InoutCustomer> getDataById(@Param("id") String id); } -- Gitblit v1.9.3