GridLookUpEdit模糊查询所有列

//先绑定数据源
  sql = "select distinct replace(Code,' ','')  招聘来源代码, replace(Name,' ','') 招聘来源名称,replace( Remark,' ','')  备注 from sys_tx_zply a left join sys_tx_kqSystem b on a.kqSystem = b.kqSystem where b.company_FK = '" + ddlRzgs.SelectedValue.ToString().Trim() + "'";
            if (!DB.AF.execSql(sql, sqlconn, out dtzply))
            {
                return;
            }
            ddlzply.Properties.ValueMember = "招聘来源代码";
            ddlzply.Properties.DisplayMember = "招聘来源名称";
            ddlzply.Properties.DataSource = dtzply;
            ddlzply.Properties.AllowNullInput = DevExpress.Utils.DefaultBoolean.True;
            ddlzply.Properties.View.BestFitColumns();
            ddlzply.Properties.ShowFooter = false;
            ddlzply.Properties.View.OptionsView.ShowAutoFilterRow = false; //显示不显示grid上第一个空行,也是用于检索的应用
            ddlzply.Properties.AutoComplete = false;
            ddlzply.Properties.ImmediatePopup = true;
            ddlzply.Properties.PopupFilterMode = DevExpress.XtraEditors.PopupFilterMode.Contains;
            ddlzply.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;
            SetGridLookUpEditMoreColumnFilter(ddlzply.Properties);

gridlookupedit默认可以模糊查询DisplayMember的值，想要模糊查询所有列需要加一个方法，就是SetGridLookupEditMoreColumnFilter，上面有调用。

private void SetGridLookUpEditMoreColumnFilter(DevExpress.XtraEditors.Repository.RepositoryItemGridLookUpEdit repGLUEdit)
        {
            repGLUEdit.EditValueChanging += (sender, e) =>
            {
                this.BeginInvoke(new System.Windows.Forms.MethodInvoker(() =>
                {
                    GridLookUpEdit edit = sender as GridLookUpEdit;
                    DevExpress.XtraGrid.Views.Grid.GridView view = edit.Properties.View as DevExpress.XtraGrid.Views.Grid.GridView;
                    //获取GriView私有变量
                    System.Reflection.FieldInfo extraFilter = view.GetType().GetField("extraFilter", System.Reflection.BindingFlags.NonPublic | System.Reflection.BindingFlags.Instance);
                    List<DevExpress.Data.Filtering.CriteriaOperator> columnsOperators = new List<DevExpress.Data.Filtering.CriteriaOperator>();
                    foreach (GridColumn col in view.VisibleColumns)
                    {
                        if (col.Visible && col.ColumnType == typeof(string))
                            columnsOperators.Add(new DevExpress.Data.Filtering.FunctionOperator(DevExpress.Data.Filtering.FunctionOperatorType.Contains,
                                new DevExpress.Data.Filtering.OperandProperty(col.FieldName),
                                new DevExpress.Data.Filtering.OperandValue(edit.Text)));
                    }
                    string filterCondition = new DevExpress.Data.Filtering.GroupOperator(DevExpress.Data.Filtering.GroupOperatorType.Or, columnsOperators).ToString();
                    extraFilter.SetValue(view, filterCondition);
                    //获取GriView中处理列过滤的私有方法
                    System.Reflection.MethodInfo ApplyColumnsFilterEx = view.GetType().GetMethod("ApplyColumnsFilterEx", System.Reflection.BindingFlags.NonPublic | System.Reflection.BindingFlags.Instance);
                    ApplyColumnsFilterEx.Invoke(view, null);
                }));
            };
        }
    

实现效果：

但是只有DisplayMember搜索的时候有底色：