package com.flow.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.flow.pojo.TbFuwuqi;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface TbFuwuqiMapper extends BaseMapper<TbFuwuqi> {

    @Select({"select * from tb_fuwuqi where none = 0"})
    List<TbFuwuqi> findAllUsers();

    @Select({"select * from tb_fuwuqi where none = 0 and company = #{Zong}"})
    List<TbFuwuqi> findTbFuwuqiZi(String var1);

    @Select({"SELECT * FROM tb_fuwuqi WHERE none = 0  and company LIKE CONCAT('%', #{company}, '%') or servername LIKE CONCAT('%', #{servername}, '%')"})
    List<TbFuwuqi> FindSearch(@Param("company") String var2,@Param("servername") String var3);
}