From f9501db5a27184c54ec25832f4dffc356e961bfe Mon Sep 17 00:00:00 2001
From: lige <bestlige@outlook.com>
Date: 星期二, 21 五月 2024 16:56:37 +0800
Subject: [PATCH] exe文件上传

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

diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TbTransitionMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TbTransitionMapper.java
index d525862..2a78241 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TbTransitionMapper.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TbTransitionMapper.java
@@ -69,6 +69,14 @@
     public boolean deletedTbTransitionByCusId(String cusId);
 
 
+    @Delete("DELETE  FROM tb_transition WHERE tj_num=#{tjNum}")
+    public boolean deletedTbTransitionByTjNum(String tjNum);
+
+    @Update("UPDATE tb_transition a SET "+
+            "a.tj_num=null" +
+            " WHERE a.tj_num=#{tjNum}")
+    boolean updateTbTransitionByTjNum(String tjNum);
+
     @Select("SELECT * FROM tb_transition WHERE cus_id=#{cusId} AND pac_id=#{pacId}")
     public List<TbTransition> getTbTransitionListByCusIdAndPac(@Param("cusId") String cusId,@Param("pacId") String pacId);
 

--
Gitblit v1.8.0