//<summary> //设置GridLookUpEdit多列过滤 //</summary> //<param name="repGLUEdit">GridLookUpEdit的知识库,eg:gridlookUpEdit.Properties</param> public 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); })); }; }
private void FilterLookupGridLookUpEdit() { DevExpress.XtraGrid.Views.Grid.GridView gridView = Properties.View as DevExpress.XtraGrid.Views.Grid.GridView; System.Reflection.FieldInfo fi = gridView.GetType().GetField("extraFilter", System.Reflection.BindingFlags.NonPublic | System.Reflection.BindingFlags.Instance); List <CriteriaOperator> _ListCriteriaOperator = new List <CriteriaOperator>(); if (string.IsNullOrEmpty(Properties.FilterColumn)) { foreach (DevExpress.XtraGrid.Columns.GridColumn column in Properties.View.Columns) { _ListCriteriaOperator.Add(GetOperator(column.FieldName)); } } else { var _Filters = Properties.FilterColumn.Split('|'); foreach (var filter in _Filters) { foreach (DevExpress.XtraGrid.Columns.GridColumn column in Properties.View.Columns) { if (column.FieldName == filter) { _ListCriteriaOperator.Add(GetOperator(filter)); } } } } string filterCondition = new GroupOperator(GroupOperatorType.Or, _ListCriteriaOperator).ToString(); fi.SetValue(gridView, filterCondition); MethodInfo mi = gridView.GetType().GetMethod("ApplyColumnsFilterEx", BindingFlags.NonPublic | BindingFlags.Instance); mi.Invoke(gridView, null); }
private void FilterLookupStaff(object sender) { DevExpress.XtraEditors.GridLookUpEdit edit = sender as DevExpress.XtraEditors.GridLookUpEdit; DevExpress.XtraGrid.Views.Grid.GridView gridView = edit.Properties.View as DevExpress.XtraGrid.Views.Grid.GridView; System.Reflection.FieldInfo fi = gridView.GetType().GetField("extraFilter", System.Reflection.BindingFlags.NonPublic | System.Reflection.BindingFlags.Instance); //Text = edit.AutoSearchText; DevExpress.Data.Filtering.BinaryOperator op1 = new DevExpress.Data.Filtering.BinaryOperator("StaffID", "%" + edit.AutoSearchText + "%", DevExpress.Data.Filtering.BinaryOperatorType.Like); DevExpress.Data.Filtering.BinaryOperator op2 = new DevExpress.Data.Filtering.BinaryOperator("FullName", "%" + edit.AutoSearchText + "%", DevExpress.Data.Filtering.BinaryOperatorType.Like); string filterCondition = new DevExpress.Data.Filtering.GroupOperator(DevExpress.Data.Filtering.GroupOperatorType.Or, new DevExpress.Data.Filtering.CriteriaOperator[] { op1, op2 }).ToString(); fi.SetValue(gridView, filterCondition); System.Reflection.MethodInfo mi = gridView.GetType().GetMethod("ApplyColumnsFilterEx", System.Reflection.BindingFlags.NonPublic | System.Reflection.BindingFlags.Instance); mi.Invoke(gridView, null); }