private void c1Combo1_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
DataTable dt_mate = new DataTable();
dt_mate = db.QueryDataTable("select fNumber,fName,mateCateId,mateCateName from materiel where (fNumber like '%" + c1Combo1.Text.Trim() + "%') OR (fName like '%" + c1Combo1.Text.Trim() + "%') order by fName");
c1Combo1.ClearItems();
c1Combo1.AddItemTitles("代码;名称;属性代码;属性名称");
if (dt_mate.Rows.Count > 0)
{
for (int r = 0; r < dt_mate.Rows.Count; r++)
{
c1Combo1.AddItem(dt_mate.Rows[r]["fNumber"].ToString() + "; " + dt_mate.Rows[r]["fName"].ToString() + "; " + dt_mate.Rows[r]["mateCateId"].ToString() + "; " + dt_mate.Rows[r]["mateCateName"].ToString());
}
c1Combo1.DisplayMember = "fName";
c1Combo1.ValueMember = "fNumber";
c1Combo1.RowDivider.Style = C1.Win.C1List.LineStyleEnum.None; //去除列表横线
c1Combo1.Columns[0].Caption = "代码";
c1Combo1.Columns[1].Caption = "名称";
c1Combo1.Columns[2].Caption = "属性代码";
c1Combo1.Columns[2].Caption = "属性名称";
c1Combo1.Splits[0].DisplayColumns[0].Width = 80;
c1Combo1.Splits[0].DisplayColumns[1].Width = 400;
c1Combo1.Splits[0].DisplayColumns[2].Width = 40;
c1Combo1.Splits[0].DisplayColumns[3].Width = 80;
}
c1Combo1.OpenCombo();
}
} |