private void btnDelete_Click(object sender, EventArgs e)
{
DialogResult dr = MessageBox.Show("该操作将删除该业务员全部数据", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.Yes)
{
if (tbNo.Text != "")
{
dbOperator db = new dbOperator();
if (db.dbNonQuery("delete from worker where 编号='" + tbNo.Text + "'") > 0)
{
MessageBox.Show("删除成功");
tbNo.Enabled = true;
clearInput();
db.loadListview("select 编号,姓名,类型,查询密码 from worker", lvWorker);
}
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (tbNo.Text == "" || tbName.Text == "" || tbPwd.Text == "" || cbType.Text == "")
{
MessageBox.Show("输入的信息不完整，请重新输入");
return;
}
String sql;
if (tbNo.Enabled)
{
sql = "insert into worker(编号,姓名,类型,查询密码) values('" + tbNo.Text + "','" + tbName.Text + "','" + cbType.Text + "','" + tbPwd.Text + "')";
}
else
{
sql = "update worker set 姓名='" + tbName.Text + "',类型='" + cbType.Text + "',查询密码='" + tbPwd.Text + "' where 编号='" + tbNo.Text + "'";
}
dbOperator db = new dbOperator();
if (db.dbNonQuery(sql)>0)
{
MessageBox.Show("保存成功");
}
db.loadListview("select 编号,姓名,类型,查询密码 from worker",lvWorker);
}
private void frmWorker_Load(object sender, EventArgs e)
{
dbOperator db = new dbOperator();
db.loadListview("select 编号,姓名,类型,查询密码 from worker", lvWorker);
}
