package com.ltkj.hosp.mapper;/*
 * @Authot:zjh
 * @Date:  2024-07-10   15:45
 * */

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ltkj.hosp.domain.TjCf;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import javax.annotation.Resource;
import java.util.List;

@Mapper
public interface TjCfMapper extends BaseMapper<TjCf> {

    @Delete("DELETE FROM tj_cf WHERE cfh=#{cfh}")
    void  delCfByCardId(String cfh);

    @Select("SELECT a.cfh FROM tj_cf a WHERE a.card_id=#{cardId}")
    List<String> getCfhs(String cardId);

    @Select("SELECT a.cfh FROM tj_cf a WHERE a.card_id=#{cardId} and a.jxbz=#{bldh}")
    List<String> getCfBlhs(@Param("cardId") String cardId,@Param("bldh") String bldh);
}