//确定按钮点击事件
private void confirm_btn_Click(object sender, EventArgs e)
{
//设置备注的默认值并确保必填项不为空
if (remarks_txb.Text == "")
{
remarks_txb.Text = LoadForm.TextList[56];
}
if (name_txb.Text == "" || tel_txb.Text == "" || address_txb.Text == "")
{
MessageBox.Show(LoadForm.TextList[57]);
return;
}
//更新数据库suppier表
string sql = "update supplier set name = '" + name_txb.Text + "',tel = '" + tel_txb.Text + "',address = '" + address_txb.Text + "',remarks = '" + remarks_txb.Text + "' where id = '" + id + "'";
cmd = new MySqlCommand(sql, conn);
cmd.ExecuteScalar();
MessageBox.Show(LoadForm.TextList[80]);
//调用父窗口的查询方法，刷新供应商列表
sql = "select * from supplier ";
SupplierManage supplierManage = (SupplierManage)this.Owner;
supplierManage.supplier_list_ltv.Items.Clear();
supplierManage.SelectSupplier(sql);
supplierManage.Show();
this.Dispose();
}
//删除按钮点击事件
private void delete_btn_Click(object sender, EventArgs e)
{
//弹出确认删除对话框
MessageBoxButtons messbutton = MessageBoxButtons.OKCancel;
DialogResult dr = MessageBox.Show(LoadForm.TextList[81], LoadForm.TextList[63], messbutton);
if (dr == DialogResult.OK)
{
string sql = ("delete from supplier where id = '" + id + "'");
cmd = new MySqlCommand(sql, conn);
cmd.ExecuteScalar();
MessageBox.Show(LoadForm.TextList[82]);
//设置supplier表自增的主键id从0开始(实际值为当前最大值加1)
sql = ("alter table supplier auto_increment = 0");
cmd = new MySqlCommand(sql, conn);
cmd.ExecuteScalar();
//调用父窗口的查询方法，刷新供应商列表
sql = "select * from supplier ";
SupplierManage supplierManage = (SupplierManage)this.Owner;
supplierManage.supplier_list_ltv.Items.Clear();
supplierManage.SelectSupplier(sql);
supplierManage.Show();
this.Dispose();
}
}