//<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);
}
