From f2f83ca83f31f9a9cd0e78d394000c08f5434cdd Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期五, 19 七月 2024 13:35:31 +0800
Subject: [PATCH] zjh 2024/07/19-1
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TbTransitionMapper.java | 5 ++++-
1 files changed, 4 insertions(+), 1 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 82043c6..f62685c 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
@@ -113,7 +113,7 @@
"a.ord_price=a.now_price,\n" +
"a.now_price=a.ord_price*(#{discount}/10)," +
"a.tj_num=#{tjNum}"+
- " WHERE a.cus_id=#{cusId} ")
+ " WHERE a.cus_id=#{cusId} AND ISNULL(a.tj_num) ")
boolean updateTbTransitionPriceByCusId(@Param("cusId")String cusId,@Param("discount")BigDecimal discount,@Param("tjNum")String tjNum);
@@ -239,4 +239,7 @@
"\tAND a.tj_num = #{tjNumber}")
boolean updateCardIdByTjNumAndIdCard(@Param("idCard")String idCard,@Param("cardId")String cardId,@Param("tjNumber") String tjNumber);
+
+ @Delete("DELETE FROM tb_transition WHERE jxbz=#{bldh}")
+ void deleteTjOrderDetailByjxbz(String bldh);
}
--
Gitblit v1.8.0