From e54ecd3c3cdf57c25d7dad004173ee46364fceec Mon Sep 17 00:00:00 2001
From: zjh <zjh@888>
Date: 星期四, 20 六月 2024 22:14:59 +0800
Subject: [PATCH] zjh 本地 2024/06/20 --2
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TbTransitionMapper.java | 3 +++
1 files changed, 3 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 b0933a7..708e8e2 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
@@ -72,6 +72,9 @@
@Delete("DELETE FROM tb_transition WHERE tj_num=#{tjNum}")
public boolean deletedTbTransitionByTjNum(String tjNum);
+ @Delete("DELETE FROM tb_transition WHERE isnull(tj_num) and cus_id=#{cdId} and parent_pro_id=#{proId}")
+ public boolean delTbBycusCardIdAndProId(@Param("cdId") String cdId,@Param("proId")String proId);
+
@Update("UPDATE tb_transition a SET "+
"a.tj_num=null" +
" WHERE a.tj_num=#{tjNum}")
--
Gitblit v1.8.0