赵文轩
2024-11-01 14f9208da19b7030a1c65a40897f9f4146a74d44
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);
}