//delete
private void button4_Click(object sender, EventArgs e)
{
try
{
string id = textBox2.Text.ToString();
SupplierHelp.DeleteSupplier(id);
MessageBox.Show("删除成功");
Init_gridview();
ClearTextBox();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
//add
private void button2_Click(object sender, EventArgs e)
{
try
{
string name = textBox3.Text.ToString();
string addr = textBox4.Text.ToString();
SupplierHelp.AddSupplier(name, addr);
MessageBox.Show("增加成功");
Init_gridview();
ClearTextBox();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
//query
private void button1_Click(object sender, EventArgs e)
{
string id = "";
string name = "";
string addr = "";
try
{
switch (comboBox1.SelectedItem.ToString())
{
case "供应商名称":
name = textBox1.Text.ToString();
break;
case "供应商ID":
id = textBox1.Text.ToString();
break;
case "供应商所在地":
addr = textBox1.Text.ToString();
break;
default:
MessageBox.Show("请勿修改选项");
break;
}
}catch (Exception ex)
{
MessageBox.Show("请勿修改选项");
}
DataTable data = SupplierHelp.QuerySupplier(id, name, addr);
if (data.Rows.Count > 0)
{
dataGridView1.DataSource = data;
}
else
{
MessageBox.Show("不存在该供应商");
}
}
private void Init_gridview()
{
dataGridView1.DataSource = SupplierHelp.GetOrder();
}
