From e9191e6d4485d94c75f76762b4926439503c20c6 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期四, 14 九月 2023 14:29:10 +0800
Subject: [PATCH] zjh 2023/09/14---1

---
 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjAskMedicalHistoryMapper.java |   15 +++++++++++++++
 1 files changed, 15 insertions(+), 0 deletions(-)

diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjAskMedicalHistoryMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjAskMedicalHistoryMapper.java
index 1d068eb..5da7e32 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjAskMedicalHistoryMapper.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjAskMedicalHistoryMapper.java
@@ -7,6 +7,8 @@
 import com.ltkj.hosp.domain.TjAskHistorys;
 import com.ltkj.hosp.domain.TjCatering;
 import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Update;
 
 /**
  * 闂瘖Mapper鎺ュ彛
@@ -88,4 +90,17 @@
          * @return 缁撴灉
          */
         public int deleteTjAskHistorysByAskId(Long askId);
+
+    @Update("UPDATE tj_ask_medical_history a SET \n" +
+            "\n" +
+            "a.tj_num=#{tjNum},\n" +
+            "a.update_time=SYSDATE(),\n" +
+            "a.update_by=#{userName},\n" +
+            "a.update_id=#{userId}\n" +
+
+            "WHERE" +
+
+            " a.cus_id=#{cusId} \n" +
+            "AND ISNULL(a.tj_num)")
+    boolean updateTjAskMedicalHistoryByCusId(@Param("tjNum") String tjNum,@Param("userName") String userName,@Param("userId") String userId,@Param("cusId") String cusId);
 }

--
Gitblit v1.8.0