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);
}
}
