存储库如何通过值成员进行搜索？

Question

如何通过搜索值成员将文本设置为repositoryLookupedit？我想要的是在grade列中，当我键入值成员时，它会显示显示成员。E.g当我键入1时，它会将grade列设置为D

​

​

这是我的代码

   private void Form1_Load(object sender, EventArgs e)
    {
        DataTable dt = new DataTable();
        dt.Columns.Add("Grade", typeof(string));
        dt.Columns.Add("Value", typeof(int));
        dt.Rows.Add("A", 4);
        dt.Rows.Add("B", 3);
        dt.Rows.Add("C", 2);
        dt.Rows.Add("D", 1);
        repositoryItemLookUpEdit1.DataSource = dt;
        repositoryItemLookUpEdit1.DisplayMember = dt.Columns["Grade"].ToString();
        repositoryItemLookUpEdit1.ValueMember = dt.Columns["Value"].ToString();
        repositoryItemLookUpEdit1.NullText = "";
        repositoryItemLookUpEdit1.PopupFormMinSize = new Size(100, 50);

        DataTable dt2 = new DataTable();
        dt2.Columns.Add("colA", typeof(String));
        dt2.Columns.Add("colB", typeof(String));
        dt2.Columns.Add("colC", typeof(String));
        for(int i =0; i < 15; i++)
        {
            dt2.Rows.Add(i.ToString() + "a", i.ToString() + "b", i.ToString()+"c");
        }
        gridControl1.DataSource = dt2;
        gridView1.BeginUpdate();
        DataColumn col2 = dt2.Columns.Add("Grade", typeof(int));
        GridColumn column2 = gridView1.Columns.AddVisible(col2.ColumnName);
        column2.Caption = col2.Caption;
        column2.Name = col2.ColumnName;
        gridView1.EndUpdate();
        gridView1.Columns["Grade"].ColumnEdit = repositoryItemLookUpEdit1;
    }

我所尝试的是在gridview事件中添加一个代码。但它不会起作用

 private void gridView1_KeyDown(object sender, KeyEventArgs e)
    {            
        if(e.KeyValue == 49)
        {
            gridView1.SetFocusedRowCellValue("Grade", 1);
        }
    }

Answer 1

首先，将仓库的搜索模式设置为弹出窗口

repositoryItemLookUpEdit1.SearchMode = DevExpress.XtraEditors.Controls.SearchMode.OnlyInPopup;

然后将代码添加到gridview和repositoryitemlookupedit keydown事件

  private void gridView1_KeyDown(object sender, KeyEventArgs e)
    {
        if (e.KeyCode == Keys.NumPad1 || e.KeyCode == Keys.D || e.KeyValue == 49)
        {
            gridView1.SetFocusedRowCellValue("Grade", 1);
        }
        if (e.KeyCode == Keys.NumPad2 || e.KeyCode == Keys.C || e.KeyValue == 50)
        {
            gridView1.SetFocusedRowCellValue("Grade", 2);
        }
        if (e.KeyCode == Keys.NumPad3 || e.KeyCode == Keys.B || e.KeyValue == 51)
        {
            gridView1.SetFocusedRowCellValue("Grade", 3);
        }
        if (e.KeyCode == Keys.NumPad4 || e.KeyCode == Keys.A || e.KeyValue == 52)
        {
            gridView1.SetFocusedRowCellValue("Grade", 4);
        }
    }
    private void repositoryItemLookUpEdit1_KeyDown(object sender, KeyEventArgs e)
    {
        if (e.KeyCode == Keys.NumPad1 || e.KeyCode == Keys.D || e.KeyValue == 49)
        {
            gridView1.SetFocusedRowCellValue("Grade", 1);
        }
        if (e.KeyCode == Keys.NumPad2 || e.KeyCode == Keys.C || e.KeyValue == 50)
        {
            gridView1.SetFocusedRowCellValue("Grade", 2);
        }
        if (e.KeyCode == Keys.NumPad3 || e.KeyCode == Keys.B || e.KeyValue == 51)
        {
            gridView1.SetFocusedRowCellValue("Grade", 3);
        }
        if (e.KeyCode == Keys.NumPad4 || e.KeyCode == Keys.A || e.KeyValue == 52)
        {
            gridView1.SetFocusedRowCellValue("Grade", 4);
        }
    }

Answer 2

您可以尝试使用SearchLookUpEdit而不是简单的LookUpEdit。SearchLookUpEdit提供了多种搜索选项。