From 882f7ad646786ed96bb28533bcb5b4b496185eaf Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期三, 11 十二月 2024 11:59:06 +0800
Subject: [PATCH] zjh202412011
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjRulesMapper.java | 7 +++++++
1 files changed, 7 insertions(+), 0 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 b9ab218..86fa268 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
@@ -1,6 +1,7 @@
package com.ltkj.hosp.mapper;
import java.util.List;
+import java.util.Map;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ltkj.hosp.domain.TjRuleAdvice;
@@ -72,4 +73,10 @@
@Select("SELECT b.* FROM tj_order_detail_rules a LEFT JOIN tj_rules b ON a.Aid=b.Aid WHERE a.tj_number=#{tjNum} AND a.pro_id=#{proId}")
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);
}
--
Gitblit v1.8.0