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