C# 模糊搜索

    private void txt_Select_SelectionChanged(object sender, RoutedEventArgs e)
    {
        try
        {
            //初始化变量（接收条件）
            string strSelect = "";
            string strContent = txt_Select.Text.Trim();
            if (strContent != "")
            {
                //拼接模糊搜索条件（员工编号\姓名\职务\联系电话\工作状态\员工类型\性别\身份证号\年龄\联系地址\电子邮件\）
                strSelect += "staff_number like '%'+'" + strContent + "'+'%'"
                     + "or staff_name like '%'+'" + strContent + "'+'%'"
                     + "or branch like '%'+'" + strContent + "'+'%'"
                     + "or phone_number like '%'+'" + strContent + "'+'%'"
                     + "or work_status like '%'+'" + strContent + "'+'%'"
                     + "or employee_type like '%'+'" + strContent + "'+'%'"
                     + "or gender like '%'+'" + strContent + "'+'%'";
            }
            //获取全部数据
            DataTable dtSelect = myClient.UserControl_Loaded_SelectStaff().Tables[0];
            //把表格转化为数据视图
            DataView dv = new DataView(dtSelect);
            //接收最终页面显示的数据
            DataTable dt = new DataTable();
            if (dtSelect.Rows.Count > 0 && strSelect != "")
            {
                //筛选数据
                dv.RowFilter = strSelect;
                dt = dv.ToTable();
            }
            if (strSelect == "")
            {
                //查询全部数据
                dt = dv.ToTable();
            }
            //绑定表格数据
            dgStaff.ItemsSource = dt.DefaultView;
        }
        catch (Exception)
        {

            throw;
        }
    }