From b83df5a43c563bac919dee41d3a8b794f22f1030 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期五, 13 十二月 2024 19:20:45 +0800
Subject: [PATCH] zjh202412013
---
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