使用dev的GridLookUpEdit来实现下拉筛选完成功能.
数据源绑定和常用设置:
private void CtlPatientSelectedNew_Load(object sender, EventArgs e)
{
if (this.DesignMode) return;
RI_Wards.Properties.DataSource = CommonVar.g_Wards;//数据源绑定;列为:DeptCode,DeptName,pyCode,wbCode..其他
RI_Wards.Properties.DisplayMember = "DeptName";
RI_Wards.Properties.ValueMember = "DeptCode";
RI_Wards.Properties.AutoComplete = false;//文本框自动补全
RI_Wards.Properties.ImmediatePopup = true;//在输入框按任一可见字符键时立即弹出下拉窗体
RI_Wards.Properties.PopupFilterMode = DevExpress.XtraEditors.PopupFilterMode.Contains;//弹框筛选模式:
RI_Wards.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;//控件类型:如只能下拉,可以筛选下拉
RI_Wards.Properties.ShowFooter = false;
RI_Wards.EditValue = "-1";//默认值为null
RI_Wards.Properties.Tag = "|PyCode|WbCode|DeptName|";//个人用Tag存放多列筛选字段
SetGridLookUpEditMoreColumnFilter(RI_Wards.Properties);//设置多列筛选
}
一般情况下,它会默认实现根据DisplayMember进行筛选,然而大多数情况下,我们需要根据其他列筛选,甚至多列筛选,如,我们想按照拼音码,五笔码,和部门名称 怎么处理呢
下面方法可直接使用
///根据多列筛选
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 gridView.VisibleColumns)
//{
//if (col.Visible && col.ColumnType == typeof(string))
foreach (GridColumn col in view.Columns)//个人修改为通过上面Tag配置检索
{
//这里判断哪一种条件的列头是否可以进行搜索,你也可以自己修改自己需要的情况!
if ( col.ColumnType == typeof(string)&& repGLUEdit.Tag.ToString().Contains(string.Format("|{0}|",col.FieldName)))
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();
//或者在这里明确写死指定列
//BinaryOperator op1 = new BinaryOperator("Id", "%" + edit.AutoSearchText + "%", BinaryOperatorType.Like);
//BinaryOperator op2 = new BinaryOperator("Model", "%" + edit.AutoSearchText + "%", BinaryOperatorType.Like);
//string filterCondition = new GroupOperator(GroupOperatorType.Or, new CriteriaOperator[] { op1, op2, op3 }).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);
}));
};
}
基本上面两端代码,可以实现需求.
对于更详细的细节可参见别人的文章https://www.cnblogs.com/springsnow/p/10191663.html