DevExpress lookupedit 如何实现多列筛选

Shaun_lee 2015-02-03 10:29:04

DevExpress lookupedit 目前只能够使用displaynumber进行筛选，哪位大神可以实现多列查询。谢谢了

...全文

1652 13 打赏收藏转发到动态举报

写回复

用AI写文章

13 条回复

切换为时间正序

请发表友善的回复…

发表回复

s666666__ 2018-12-13

打赏
举报

10楼的方法能现实[GridLookUpEdit]、但可惜[LookUpEdit]控件用不了

Aqiuuuuu 2017-09-06

打赏
举报

报错的话。很多都是引用问题

Aqiuuuuu 2017-09-06

打赏
举报

全部都可以复制。只要改改控件名。字段名和数据源就可以了。

Aqiuuuuu 2017-09-06

打赏
举报


        //GridLookUpEdit模糊查询
        private void FilterLookup(object sender, string[] arrFilterField)
        {
            //Text += " ! ";
            GridLookUpEdit edit = sender as GridLookUpEdit;
            GridView gridView = edit.Properties.View as GridView;
            FieldInfo fi = gridView.GetType().GetField("extraFilter", BindingFlags.NonPublic | BindingFlags.Instance);
            //Text = edit.AutoSearchText;
            CriteriaOperator[] arrCriteriaOperator = new CriteriaOperator[arrFilterField.Length];
            for (int i = 0; i < arrFilterField.Length; i++)
            {
                arrCriteriaOperator[i] = new BinaryOperator(arrFilterField[i],"%"+edit.AutoSearchText + "%", BinaryOperatorType.Like);
            }
            string filterCondition = new GroupOperator(GroupOperatorType.Or, arrCriteriaOperator).ToString();
            fi.SetValue(gridView, filterCondition);
            MethodInfo mi = gridView.GetType().GetMethod("ApplyColumnsFilterEx", BindingFlags.NonPublic | BindingFlags.Instance);
            mi.Invoke(gridView, null);
        }



//绑定事件
        void cmbZyzd_Properties_Popup(object sender, EventArgs e)
        {
            FilterLookup(sender, new string[] { "Name", "Code","Spell" });//中文，编码，拼音
        }
        void cmbZyzd_TextChanged(object sender, EventArgs e)
        {
            GridLookUpEdit edit = sender as GridLookUpEdit;
            edit.SelectionStart = edit.Text.Length;
        }
        void cmbZyzd_EditValueChanging(object sender, DevExpress.XtraEditors.Controls.ChangingEventArgs e)
        {
            this.BeginInvoke(new System.Windows.Forms.MethodInvoker(delegate
            {
                FilterLookup(sender, new string[] { "Name", "Code", "Spell" });
            }));
        }




        //加载主要诊断
        void LoadZyzd()
        {

            DataTable dt = new CDM_HB_ICD10BLL().GetZYZDData();//数据源
            this.cmbZyzd.Properties.Popup -= new EventHandler(cmbZyzd_Properties_Popup);
            this.cmbZyzd.EditValueChanging -= new DevExpress.XtraEditors.Controls.ChangingEventHandler(cmbZyzd_EditValueChanging);
            this.cmbZyzd.TextChanged -= new EventHandler(cmbZyzd_TextChanged);
            this.cmbZyzd.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup;
            this.cmbZyzd.Properties.AllowNullInput = DevExpress.Utils.DefaultBoolean.True;
            this.cmbZyzd.Properties.AutoComplete = false;
            this.cmbZyzd.Properties.ImmediatePopup = true;
            this.cmbZyzd.Properties.PopupFilterMode = DevExpress.XtraEditors.PopupFilterMode.Contains;
            this.cmbZyzd.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;
            this.cmbZyzd.Properties.DataSource =dt;
            this.cmbZyzd.Properties.ValueMember = "Code";
            this.cmbZyzd.Properties.DisplayMember = "Name";
            this.cmbZyzd.Properties.Popup += new EventHandler(cmbZyzd_Properties_Popup);
            this.cmbZyzd.EditValueChanging += new DevExpress.XtraEditors.Controls.ChangingEventHandler(cmbZyzd_EditValueChanging);
            this.cmbZyzd.TextChanged += new EventHandler(cmbZyzd_TextChanged);

        }

可以去慢慢参悟，不懂的可以问我