From ba9562289ab7e67c9eeca4d518ddbb3e68ed5dc2 Mon Sep 17 00:00:00 2001
From: YYC <1833023622@qq.com>
Date: 星期一, 28 八月 2023 18:56:32 +0800
Subject: [PATCH] 上海新增页面--检斤单,倒仓倒入

---
 src/main/java/com/fzzy/api/view/repository/ApiInfoDataRep.java |   17 +++++++++++++++++
 1 files changed, 17 insertions(+), 0 deletions(-)

diff --git a/src/main/java/com/fzzy/api/view/repository/ApiInfoDataRep.java b/src/main/java/com/fzzy/api/view/repository/ApiInfoDataRep.java
index fce7ebf..8b18944 100644
--- a/src/main/java/com/fzzy/api/view/repository/ApiInfoDataRep.java
+++ b/src/main/java/com/fzzy/api/view/repository/ApiInfoDataRep.java
@@ -3,8 +3,11 @@
 import com.fzzy.api.entity.ApiInfoData;
 import org.springframework.data.jpa.repository.JpaRepository;
 import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
+import org.springframework.data.jpa.repository.Modifying;
 import org.springframework.data.jpa.repository.Query;
 import org.springframework.data.repository.query.Param;
+import org.springframework.transaction.annotation.Transactional;
+
 import java.util.List;
 
 public interface ApiInfoDataRep extends JpaRepository<ApiInfoData, String>, JpaSpecificationExecutor<ApiInfoData> {
@@ -12,6 +15,7 @@
 
     /**
      * 鏍规嵁鏁版嵁鍐呭ID鏌ヨ鏁版嵁
+     *
      * @param dataId
      * @return
      */
@@ -20,10 +24,23 @@
 
     /**
      * 鏍规嵁鎺ュ彛缂栫爜鏌ヨ鏁版嵁
+     *
      * @param inteId
      * @return
      */
     @Query("from ApiInfoData where inteId=:inteId ")
     List<ApiInfoData> getDataByInteId(@Param("inteId") String inteId);
 
+    /**
+     * 鏍规嵁琛ㄥ崟涓婚敭鏇存柊鎿嶄綔鏍囧織鐘舵��
+     *
+     * @param id   涓婚敭ID
+     * @param czbz 鎿嶄綔鏍囧織
+     * @return
+     */
+    @Transactional
+    @Modifying
+    @Query(value = "update ApiInfoData set czbz=:czbz ,data=:data where id=:id ")
+    int updateStatus(@Param("id") String id, @Param("data") String data, @Param("czbz") String czbz);
+
 }
\ No newline at end of file

--
Gitblit v1.9.3