From 254da24705ba4daa8bf289a2c10b912fb8c53ad2 Mon Sep 17 00:00:00 2001
From: CZT <czt18638530771@163.com>
Date: 星期二, 18 七月 2023 21:18:37 +0800
Subject: [PATCH] 增加V40接口-粮情、出入库

---
 src/main/java/com/fzzy/api/view/repository/Api1203Rep.java |    8 ++++++--
 1 files changed, 6 insertions(+), 2 deletions(-)

diff --git a/src/main/java/com/fzzy/api/view/repository/Api1203Rep.java b/src/main/java/com/fzzy/api/view/repository/Api1203Rep.java
index c07c48c..2813adc 100644
--- a/src/main/java/com/fzzy/api/view/repository/Api1203Rep.java
+++ b/src/main/java/com/fzzy/api/view/repository/Api1203Rep.java
@@ -1,5 +1,6 @@
 package com.fzzy.api.view.repository;
 
+import com.fzzy.api.entity.Api1202;
 import com.fzzy.api.entity.Api1203;
 
 import org.springframework.data.jpa.repository.JpaRepository;
@@ -19,6 +20,9 @@
 
     @Transactional
     @Modifying
-    @Query("update Api1203 set czbz =:czbz where id=:id")
-    void updateStatus(@Param("id") String id, @Param("czbz") String czbz);
+    @Query("update Api1203 set czbz =:czbz where rkjydh=:rkjydh")
+    void updateStatus(@Param("rkjydh") String rkjydh, @Param("czbz") String czbz);
+
+    @Query("from Api1203 where rkjydh=:rkjydh ")
+    List<Api1203> getDataById(@Param("rkjydh") String rkjydh);
 }

--
Gitblit v1.9.3