From 9f6dacf7b39e5aeba37d8faf575c9e56d8cbe51a Mon Sep 17 00:00:00 2001 From: czt <czt18638530771@163.com> Date: 星期六, 11 十月 2025 13:35:42 +0800 Subject: [PATCH] 武汉黄陂军粮-质检报告共享接口同步及推送 --- src/main/java/com/fzzy/api/view/repository/Api1101Rep.java | 21 ++++++++++++++++----- 1 files changed, 16 insertions(+), 5 deletions(-) diff --git a/src/main/java/com/fzzy/api/view/repository/Api1101Rep.java b/src/main/java/com/fzzy/api/view/repository/Api1101Rep.java index 0a9d967..5034fe4 100644 --- a/src/main/java/com/fzzy/api/view/repository/Api1101Rep.java +++ b/src/main/java/com/fzzy/api/view/repository/Api1101Rep.java @@ -16,21 +16,21 @@ /** * 鏍规嵁琛ㄥ崟涓婚敭鏇存柊鎿嶄綔鏍囧織鐘舵�� * - * @param id 涓婚敭ID + * @param dwdm 涓婚敭ID * @param czbz 鎿嶄綔鏍囧織 * @return */ @Transactional @Modifying - @Query("update Api1101 set czbz=:czbz where dwdm=:id ") - int updateStatus(@Param("id") String id, @Param("czbz") String czbz); + @Query("update Api1101 set czbz =:czbz where dwdm =:dwdm ") + int updateStatus(@Param("dwdm") String dwdm, @Param("czbz") String czbz); /** * 鍗曚綅淇℃伅 * @param kqdm * @return */ - @Query("from Api1101 where kqdm=:kqdm ") + @Query("from Api1101 where kqdm =:kqdm ") List<Api1101> findPushData(@Param("kqdm") String kqdm); /** @@ -38,6 +38,17 @@ * @param kqdm * @return */ - @Query("from Api1101 where kqdm=:kqdm and zhgxsj >=:start and zhgxsj <:end order by zhgxsj ") + @Query("from Api1101 where kqdm =:kqdm and zhgxsj >=:start and zhgxsj <:end order by zhgxsj ") List<Api1101> getDataByTime(@Param("kqdm") String kqdm, @Param("start") Date start, @Param("end") Date end); + + /** + * 鍗曚綅淇℃伅 + * @param dwdm + * @return + */ + @Query("from Api1101 where dwdm =:dwdm ") + List<Api1101> findDataByDwdm(@Param("dwdm") String dwdm); + + @Query("from Api1101 where dwdm =:dwdm ") + Api1101 findData(@Param("dwdm") String dwdm); } -- Gitblit v1.9.3