zjh20241205-3

zjh

2024-12-06 c42f62b32bac302a7ac9fcde7489f7c5fc6e11aa

 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjCustomerBlackMapper.java

@@ -3,7 +3,11 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ltkj.hosp.domain.TjCustomerBlack;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface TjCustomerBlackMapper extends BaseMapper<TjCustomerBlack> {

    @Select("SELECT * FROM tj_customer_black a WHERE a.cus_id=#{cusId} AND a.is_expiration='N'")
    TjCustomerBlack isTjCustomerBlack(String cusId);
}