From a5ea6c16ddee126361a325ebd25d9136c0cc5b75 Mon Sep 17 00:00:00 2001 From: CZT <czt18638530771@163.com> Date: 星期四, 10 八月 2023 12:07:38 +0800 Subject: [PATCH] 优化3.5版本库存更新 --- src/main/java/com/fzzy/async/fzzy35/repository/Fzzy35Sync1208Rep.java | 9 +++++---- 1 files changed, 5 insertions(+), 4 deletions(-) diff --git a/src/main/java/com/fzzy/async/fzzy35/repository/Fzzy35Sync1208Rep.java b/src/main/java/com/fzzy/async/fzzy35/repository/Fzzy35Sync1208Rep.java index c2c390e..001532d 100644 --- a/src/main/java/com/fzzy/async/fzzy35/repository/Fzzy35Sync1208Rep.java +++ b/src/main/java/com/fzzy/async/fzzy35/repository/Fzzy35Sync1208Rep.java @@ -1,22 +1,23 @@ package com.fzzy.async.fzzy35.repository; -import com.fzzy.async.fzzy35.entity.Fz35Depot; +import com.fzzy.async.fzzy35.entity.Fz35DepotStore; 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; /** * 绮璐攢-绮搴撳瓨 */ -public interface Fzzy35Sync1208Rep extends JpaRepository<Fz35Depot, String> { +public interface Fzzy35Sync1208Rep extends JpaRepository<Fz35DepotStore, String> { /** * 鏍规嵁淇℃伅鑾峰彇浠撳簱淇℃伅 * * @return */ - @Query("from Fz35Depot where deptId=:deptId order by id ") - List<Fz35Depot> listDepot(@Param("deptId") String deptId); + @Query("from Fz35DepotStore where deptId=:deptId and createDate >=:start and createDate <:end order by createDate ") + List<Fz35DepotStore> listDepot(@Param("deptId") String deptId, @Param("start") Date start, @Param("end") Date end); } -- Gitblit v1.9.3