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);
|
}
|
