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;
|
|
/**
|
* 规则+病种Mapper接口
|
*
|
* @author ltkj_赵佳豪&李格
|
* @date 2023-08-30
|
*/
|
@Mapper
|
public interface TjRulesMapper extends BaseMapper<TjRules> {
|
/**
|
* 查询规则+病种
|
*
|
* @param aid 规则+病种主键
|
* @return 规则+病种
|
*/
|
public TjRules selectTjRulesByAid(String aid);
|
|
/**
|
* 查询规则+病种列表
|
*
|
* @param tjRules 规则+病种
|
* @return 规则+病种集合
|
*/
|
public List<TjRules> selectTjRulesList(TjRules tjRules);
|
|
/**
|
* 新增规则+病种
|
*
|
* @param tjRules 规则+病种
|
* @return 结果
|
*/
|
public int insertTjRules(TjRules tjRules);
|
|
/**
|
* 修改规则+病种
|
*
|
* @param tjRules 规则+病种
|
* @return 结果
|
*/
|
public int updateTjRules(TjRules tjRules);
|
|
/**
|
* 删除规则+病种
|
*
|
* @param aid 规则+病种主键
|
* @return 结果
|
*/
|
public int deleteTjRulesByAid(String aid);
|
|
/**
|
* 批量删除规则+病种
|
*
|
* @param aids 需要删除的数据主键集合
|
* @return 结果
|
*/
|
public int deleteTjRulesByAids(String[] aids);
|
|
|
@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);
|
}
|
