From 07ace5ef7c3ddf0deb66249aae6468e96b4ae646 Mon Sep 17 00:00:00 2001
From: zhaowenxuan <chacca165@163.com>
Date: 星期一, 10 二月 2025 09:25:42 +0800
Subject: [PATCH] 20250210
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TbTransitionMapper.java | 9 ++++++++-
1 files changed, 8 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 ddb735e..6078b93 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
@@ -76,7 +76,8 @@
public boolean delTbBycusCardIdAndProId(@Param("cdId") String cdId,@Param("proId")String proId);
@Update("UPDATE tb_transition a SET "+
- "a.tj_num=null" +
+ "a.tj_num=null," +
+ "a.card_id=0" +
" WHERE a.tj_num=#{tjNum}")
boolean updateTbTransitionByTjNum(String tjNum);
@@ -376,4 +377,10 @@
@Select("SELECT SUM(a.ord_price) FROM tb_transition a WHERE a.tj_num=#{tjNum} AND a.parent_pro_id=#{proId}")
BigDecimal getTbTransitionOrdPriceByTjNumAndParentId(@Param("tjNum")String tjNum,@Param("proId")String proId);
+
+ @Select("SELECT SUM(a.ord_price) FROM tb_transition a WHERE a.tj_num=#{tjNum}")
+ BigDecimal sumTbTransitionOrdPriceByTjNum(@Param("tjNum")String tjNum);
+
+ @Select("SELECT SUM(a.now_price) FROM tb_transition a WHERE a.tj_num=#{tjNum}")
+ BigDecimal sumTbTransitionNowPriceByTjNum(@Param("tjNum")String tjNum);
}
--
Gitblit v1.8.0