From d866e43afbe901bfc640776e02f767b9045acbc2 Mon Sep 17 00:00:00 2001
From: 赵文轩 <1652863494@qq.com>
Date: 星期三, 12 六月 2024 09:04:56 +0800
Subject: [PATCH] Merge branch 'master' of http://101.42.27.146:5001/r/ltkj_peis

---
 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjAskMedicalHistoryMapper.java |   28 ++++++++++++++++++++++++++++
 1 files changed, 28 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..159ec6b 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
@@ -3,10 +3,14 @@
 import java.util.List;
 
 import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.ltkj.hosp.domain.DictZhengzhuang;
 import com.ltkj.hosp.domain.TjAskMedicalHistory;
 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.Select;
+import org.apache.ibatis.annotations.Update;
 
 /**
  * 闂瘖Mapper鎺ュ彛
@@ -88,4 +92,28 @@
          * @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);
+
+
+
+    @Select("SELECT * FROM dict_zhengzhuang")
+    List<DictZhengzhuang> getZhengZhuang();
+
+
+
+//    @Select("SELECT * FROM tj_ask_medical_history a WHERE a.deleted=0 AND a.tj_num=#{tjNum}")
+    TjAskMedicalHistory selectTjAskMedicalHistoryByTjNum(String tjNum);
+
 }

--
Gitblit v1.8.0