From b83df5a43c563bac919dee41d3a8b794f22f1030 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期五, 13 十二月 2024 19:20:45 +0800
Subject: [PATCH] zjh202412013
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjRulesMapper.java | 17 +++++++++++++----
1 files changed, 13 insertions(+), 4 deletions(-)
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjRulesMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjRulesMapper.java
index 86fa268..2a60f50 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjRulesMapper.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjRulesMapper.java
@@ -75,8 +75,17 @@
List<TjRules> getTjRulesListByTjNumAndProId(@Param("tjNum") String tjNum,@Param("proId") Long proId);
- @Select("SELECT a.advice_bt bt, a.advice_nr nr FROM tj_rules a JOIN tj_project b ON b.pro_id=a.pro_id\n" +
- "\n" +
- "WHERE b.lis_xmbm=#{proId} AND a.sign=#{ycbz}")
- List<Map<String,Object>> getyichangxiangmujianyiguize(@Param("proId") String proId,@Param("ycbz") String ycbz);
+// @Select("SELECT a.advice_bt bt, a.advice_nr nr FROM tj_rules a JOIN tj_project b ON b.pro_id=a.pro_id\n" +
+// " \n" +
+// " WHERE (b.lis_xmbm= #{xmbm} OR a.pro_id=#{proId}) AND a.sign= #{ycbz}")
+ List<Map<String,Object>> getyichangxiangmujianyiguize(Map<String, Object> map);
+
+
+ @Select("call tj_ycjgjy(\n" +
+ " #{xmbm,mode=IN,jdbcType=VARCHAR},\n" +
+ " #{proId,mode=IN,jdbcType=VARCHAR},\n" +
+ " #{ycbz,mode=IN,jdbcType=VARCHAR},\n" +
+ " #{tjnum,mode=IN,jdbcType=VARCHAR} )")
+ List<Map<String,Object>> getyichangxiangmujianyiguize1(@Param("xmbm") String xmbm,@Param("proId")String proId,
+ @Param("ycbz")String ycbz,@Param("tjnum")String tjnum);
}
--
Gitblit v1.8.0