110,535
社区成员
发帖
与我相关
我的任务
分享
private void txtName_TextChanged(object sender, EventArgs e)
{
DataTable dt = new DataTable();
string sql = "select * from CustInfo where 1=1 ";
if (!string.IsNullOrEmpty(txtName.Text.Trim()))
{
sql += "and CustName like '%" + txtName.Text.Trim() + "%' ";
}
dt = DBHelper.ExecuteDataTableSql(sql);
if (dt.Rows.Count > 0)
{
this.listBoxAuto.Visible = true;
this.listBoxAuto.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
if (!listBoxAuto.Items.Contains(dt.Rows[i]["CustName"].ToString()))
this.listBoxAuto.Items.Add(dt.Rows[i]["CustName"].ToString());
}
listBoxAuto.Height = listBoxAuto.ItemHeight * (listBoxAuto.Items.Count + 1);
}
}
private void txtName_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Down)
{
if (listBoxAuto.SelectedIndex != listBoxAuto.Items.Count - 1)
{
listBoxAuto.SelectedIndex += 1;
}
else
{
listBoxAuto.SelectedIndex = 0;
}
}
if (e.KeyCode == Keys.Up)
{
if (listBoxAuto.SelectedIndex != 0)
{
listBoxAuto.SelectedIndex -= 1;
}
else
{
listBoxAuto.SelectedIndex = listBoxAuto.Items.Count - 1;
}
}
if (listBoxAuto.SelectedIndex > -1)
{
if (e.KeyCode == Keys.Enter)
{
DateTime? custdate = null;
string status = "";
if (dateTimePickercustdate.Checked)
{
custdate = dateTimePickercustdate.Value.Date;
}
if (CBstatue.SelectedItem != null)
{
status = CBstatue.SelectedItem.ToString().Trim();
}
SearchData(txtName.Text = listBoxAuto.SelectedItem.ToString(), status.Trim(), custdate);
listBoxAuto.Visible = false;
txtName.Select(txtName.Text.Trim().Length, 0);
}
}
else if (e.KeyCode == Keys.Enter)
{
DateTime? custdate = null;
string status = "";
if (dateTimePickercustdate.Checked)
{
custdate = dateTimePickercustdate.Value.Date;
}
if (CBstatue.SelectedItem != null)
{
status = CBstatue.SelectedItem.ToString().Trim();
}
SearchData(txtName.Text, status.Trim(), custdate);
listBoxAuto.Visible = false;
txtName.Select(txtName.Text.Trim().Length, 0);
}
}
楼主可以参考下 我这个目前我能用 到那时可能不是那么好
恩 还有一些属性可能要楼主根据情况控制下