private void button1_Click(object sender, EventArgs e) { string EmployeeId = textBox1.Text; string EmployeeName = textBox2.Text; string EmployeeSex = textBox3.Text; string EmployeeWorkType = textBox4.Text; string EmployeeAge = textBox5.Text; string sqlStr = "INSERT INTO member " + "VALUES(" + EmployeeId + ", '" + EmployeeWorkType + "', " + EmployeeAge + ", '" + EmployeeSex + "', '" + EmployeeName + "')"; DatabaseControl databaseControl = new DatabaseControl(); int d2 = databaseControl.ExecuteUpdate(sqlStr);//执行后会有返回值,是int类型,如果执行失败会返回0; if (d2 != 0) { MessageBox.Show("添加成功!", "添加结果", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("添加失败!此工号已存在!", "添加结果", MessageBoxButtons.OK, MessageBoxIcon.Information); } this.Close(); }
private void Delete_Employee_Click(object sender, EventArgs e) { int a = dataGridView1.CurrentRow.Index; string strID = dataGridView1.Rows[a].Cells[0].Value.ToString(); string AlertMessage = "确定要删除id为" + strID + "的员工吗?"; if (MessageBox.Show(AlertMessage, "警告", MessageBoxButtons.YesNoCancel) == DialogResult.Yes) { //确定删除 string sqlStr = "DELETE FROM member where id =" + strID; DatabaseControl databaseControl = new DatabaseControl(); int d2 = databaseControl.ExecuteUpdate(sqlStr);//执行后会有返回值,是int类型,如果执行失败会返回0; if (d2 != 0) { MessageBox.Show("删除成功!", "添加结果", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("删除失败!此工号不存在!", "添加结果", MessageBoxButtons.OK, MessageBoxIcon.Information); } } }
private void button1_Click(object sender, EventArgs e) { string WorkTypeName = textBox1.Text; string WorkTypeBase = textBox2.Text; string WorkTypeGrade = textBox3.Text; string WorkTypeDept = textBox4.Text; string WorkTypePenalty = textBox5.Text; string sqlStr = "INSERT INTO work_type " + "VALUES('" + WorkTypeName + "', " + WorkTypeBase + ", " + WorkTypeGrade + ", '" + WorkTypeDept + "', " + WorkTypePenalty + ")"; DatabaseControl databaseControl = new DatabaseControl(); int d2 = databaseControl.ExecuteUpdate(sqlStr);//执行后会有返回值,是int类型,如果执行失败会返回0; if (d2 != 0) { MessageBox.Show("添加成功!", "添加结果", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("添加失败!此工种已存在!", "添加结果", MessageBoxButtons.OK, MessageBoxIcon.Information); } this.Close(); }