From 82da75d12863f4e351425d088b1338e74b8e0662 Mon Sep 17 00:00:00 2001
From: 赵文轩 <1652863494@qq.com>
Date: 星期二, 29 十月 2024 11:44:28 +0800
Subject: [PATCH] 增加IN查询
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TbTransitionMapper.java | 18 ++++++++++++++++++
1 files changed, 18 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 cc25ed3..c404c7b 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
@@ -263,4 +263,22 @@
*/
@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);
+
+ /**
+ * 鏍规嵁tjNum鍜宲arentProId鏌ヨ鎬讳环
+ * @param tjNum
+ * @param parentProId
+ * @return
+ */
+ @Select({
+ "<script>",
+ "SELECT SUM(now_price) FROM `tb_transition`",
+ "WHERE `tj_num` = #{tjNum}",
+ "AND `parent_pro_id` IN",
+ "<foreach item='item' index='index' collection='parentProId' open='(' separator=',' close=')'>",
+ "#{item}",
+ "</foreach>",
+ "</script>"
+ })
+ BigDecimal getLisPriceByTjNumAndInParentProId(@Param("tjNum") String tjNum, @Param("parentProId") List<String> parentProId);
}
--
Gitblit v1.8.0