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