From a6c2fcf68b27c50f2390e6b9d7e050cc3f76eceb Mon Sep 17 00:00:00 2001
From: zhaowenxuan <chacca165@163.com>
Date: 星期三, 26 二月 2025 15:07:23 +0800
Subject: [PATCH] 切库
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjRulesMapper.java | 27 +++++++++++++++++++++++++++
1 files changed, 27 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 b5d6a14..cff8f87 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,11 +1,13 @@
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;
import com.ltkj.hosp.domain.TjRules;
import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
/**
@@ -67,4 +69,29 @@
@Select("SELECT b.* FROM tj_project a INNER JOIN tj_rules b ON a.pro_id=b.pro_id WHERE a.deleted=0 AND a.pro_parent_id=#{proId}")
List<TjRules> getTjRulesListByProId(String proId);
+
+
+ @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= #{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}," +
+ " #{xmm,mode=IN,jdbcType=VARCHAR}," +
+ " #{jyjg,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,@Param("xmm") String xmm,@Param("jyjg") String jyjg);
+
+ @Select("call tj_ycjgjy_jc(\n" +
+ " #{jcjg,mode=IN,jdbcType=VARCHAR} )")
+ Map<String, Object> getyichangxiangmujianyiguizeJianCha(String jcjg);
}
--
Gitblit v1.8.0