From d00be6eb896fbbb283a8a3ec8eece3796ed1ed9a Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期四, 17 十月 2024 14:35:13 +0800
Subject: [PATCH] zjh20241017
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TbTransitionMapper.java | 9 +++++++++
1 files changed, 9 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 433f82b..0fda7b6 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
@@ -251,4 +251,13 @@
@Delete("DELETE FROM tb_transition WHERE jxbz=#{bldh}")
void deleteTjOrderDetailByjxbz(String bldh);
+
+ /**
+ * 鏍规嵁tjNum鍜宲arentProId鏌ヨ鎬讳环
+ * @param tjNum
+ * @param parentProId
+ * @return
+ */
+ @Select("SELECT SUM(now_price) FROM `tb_transition` WHERE `tj_num` = #{tjNum} AND `parent_pro_id` = #{parentProId}")
+ BigDecimal getLisPriceByTjNumAndParentProId(@Param("tjNum")String tjNum,@Param("parentProId")String parentProId);
}
--
Gitblit v1.8.0