private void btnSearch_Click(object sender, EventArgs e) //查询按钮事件 { if (txtSearch.Text == "") { MessageBox.Show("请输入产品类别编号后再查询!", "提示"); return; } try { categoryIDSearch = txtSearch.Text.Trim(); cate = categoryBll.FindByID(categoryIDSearch); list.Add(cate); //将查询到的结果填充 dgCategroy.DataSource = list; //找到查询的项的索引值(获取索引值) for (int i = 0; i < list.Count; i++) { if (list[i].CategoryID == cate.CategoryID) { //查找到的行反蓝色显示 dgCategroy.Rows[i].Selected = true; currentRowsIndex = i; //自动跳转到查找到的行 dgCategroy.FirstDisplayedScrollingRowIndex = currentRowsIndex; break; } } //当更新按钮 或者 删除按钮被单击时 执行赋值语句 if (op == Operation.UPDATE || op == Operation.DELETE) { //给控件赋值 txtCategoryID.Text = cate.CategoryID; txtCategoryName.Text = cate.CategoryName; } } catch (Exception) { MessageBox.Show("没有该记录!", "提示"); } }
private void btnSelect_Click(object sender, EventArgs e) { string seach = ""; //存储查询条件 try { if (cbQuery.SelectedIndex == 0) { BindDate(); return; } else if (cbQuery.SelectedIndex == 1) { seach = txtQueryValue.Text.Trim(); //从文本框取出查询值 if (seach == "") //判断是否为空 { MessageBox.Show("请输入查询值!"); txtQueryValue.Focus(); return; } c = cBLL.FindByID(seach); if (c != null) { list = new List <Category>(); list.Add(c); dgCategoryInfo.DataSource = null; dgCategoryInfo.DataSource = list; if (list.Count > 0) { dgCategoryInfo.CurrentCell.Selected = false; //取消反蓝 } return; } else { MessageBox.Show("没有查询到记录!"); txtQueryValue.Text = ""; txtQueryValue.Focus(); return; } } else if (cbQuery.SelectedIndex == 2) { seach = txtQueryValue.Text.Trim(); //从文本框取出查询值 if (seach == "") //判断是否为空 { MessageBox.Show("请输入查询值!"); txtQueryValue.Focus(); return; } list = cBLL.FindByName(txtQueryValue.Text.Trim()); if (list == null) { MessageBox.Show("没有查询到记录!"); txtQueryValue.Text = ""; txtQueryValue.Focus(); return; } if (list.Count > 0) { dgCategoryInfo.DataSource = null; dgCategoryInfo.DataSource = list; dgCategoryInfo.CurrentCell.Selected = false; //取消反蓝 return; } else { MessageBox.Show("没有查询到记录!"); txtQueryValue.Text = ""; txtQueryValue.Focus(); return; } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }