1.员工列表修改及添加
点击修改员工，弹出修改页面，修改窗口与添加窗口时同一个窗口，需要区分是添加还是修改。
设置一个变量用于判断当前窗口的功能，flag=0，则是添加；flag>0则是修改，修改传进来的flag就是需要修改的员工编号。
先找到datagridview的显示选择整行的模型
private void AddStaffForm_Load(object sender, EventArgs e) { //加载的时候判断添加还是修改 if(flag == 0) { //添加功能 button1.Text = "添加"; //1.获取下拉列表 setComboBox(); } else { //修改功能 button1.Text = "修改"; //1.获取下拉列表 setComboBox(); //2.初始化窗体表数据 setStaffById(); } } /// <summary> /// 初始化修改窗口的员工信息 /// </summary> /// <exception cref="NotImplementedException"></exception> private void setStaffById() { MySqlConnection mySqlConnection = null; try { mySqlConnection = new MySqlConnection("server=127.0.0.1;port=3306;user=root;password=123456;database=course"); mySqlConnection.Open(); string sql = string.Format("select * from staffInfo where sId = {0}", flag); MySqlCommand mySqlCommand = new MySqlCommand(sql, mySqlConnection); MySqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader(); if (mySqlDataReader.Read()) { sCardText.Text = mySqlDataReader["sCard"].ToString(); sNameText.Text = mySqlDataReader["sName"].ToString(); if (mySqlDataReader["sSex"].ToString() == "男") { nanBtn.Checked = true; } else { nvBtn.Checked = true; } ageCombo.Text = mySqlDataReader["sAge"].ToString(); sAddressText.Text = mySqlDataReader["sAddress"].ToString(); deptCombo.SelectedIndex = Convert.ToInt32(mySqlDataReader["deptId"]); numericUpDown1.Value = Convert.ToDecimal(mySqlDataReader["sWages"]); } } catch (Exception e) { MessageBox.Show(e.Message); //throw; } finally { mySqlConnection.Close(); } } /// <summary> /// 获取下拉列表 /// </summary> private void setComboBox() { //年龄下拉框 for(int i = 1; i < 121; i++) { ageCombo.Items.Add(i); } ageCombo.SelectedItem = 18;//设置默认值 nanBtn.Checked = true;//默认性别男 MySqlConnection mySqlConnection = null; try { mySqlConnection = new MySqlConnection("server=127.0.0.1;port=3306;user=root;password=123456;database=course"); mySqlConnection.Open(); string sql = string.Format("select deptId,deptName from deptinfo"); MySqlDataAdapter msda = new MySqlDataAdapter(sql, mySqlConnection); DataSet ds = new DataSet(); //msda.Fill(ds); msda.Fill(ds, "depts"); //添加请选择 DataRow dr = ds.Tables["depts"].NewRow(); dr[0] = "0"; dr[1] = "请选择"; ds.Tables["depts"].Rows.InsertAt(dr, 0); //显示值 deptCombo.DisplayMember = "deptName"; //隐藏值 deptCombo.ValueMember = "deptId"; deptCombo.DataSource = ds.Tables["depts"]; } catch (Exception e) { MessageBox.Show(e.Message); //throw; } finally { mySqlConnection.Close(); } } private void button1_Click(object sender, EventArgs e) { //非空认证 if (CheckInput()) { //点击添加的时候，判断是添加还是修改员工 if (flag == 0) { //添加功能 insertStaff(); } else { //修改功能 updateStaff(); } } } /// <summary> /// 非空认证 /// </summary> private Boolean CheckInput() { if(sCardText.Text.Trim().Length == 0) { MessageBox.Show("员工工号不能为空"); sCardText.Focus(); return false; } if(sNameText.Text.Trim().Length == 0) { MessageBox.Show("员工姓名不能为空"); sNameText.Focus(); return false; } if(sAddressText.Text.Trim().Length == 0) { MessageBox.Show("员工地址不能为空"); sAddressText.Focus(); return false; } if(deptCombo.Text.Trim() == "请选择") { MessageBox.Show("请选择部门"); deptCombo.Focus(); return false; } //年龄和性别有默认值 return true; } /// <summary> /// 添加员工信息 /// </summary> private void insertStaff() { MySqlConnection mySqlConnection = null; try { mySqlConnection = new MySqlConnection("server=127.0.0.1;port=3306;user=root;password=123456;database=course"); mySqlConnection.Open(); string sql = string.Format("insert into staffInfo(`sCard`,`sName`,`sSex`,`sAge`,`sAddress`,`deptId`,`sWages`) values('{0}','{1}','{2}',{3},'{4}',{5},{6})" , sCardText.Text.Trim() , sNameText.Text.Trim() , nanBtn.Checked == true ? "男" : "女" , Convert.ToInt32(ageCombo.Text) , sAddressText.Text.Trim() , (int)deptCombo.SelectedValue//部门号是被隐藏了的 , numericUpDown1.Value ); MySqlCommand mySqlCommand = new MySqlCommand(sql, mySqlConnection); int result = mySqlCommand.ExecuteNonQuery(); if (result > 0) { MessageBox.Show("添加成功"); this.Close(); } else { MessageBox.Show("添加失败"); } } catch (Exception ex) { MessageBox.Show(ex.Message); //throw; } mySqlConnection.Close(); } /// <summary> /// 修改员工信息 /// </summary> private void updateStaff() { MySqlConnection mySqlConnection = null; try { mySqlConnection = new MySqlConnection("server=127.0.0.1;port=3306;user=root;password=123456;database=course"); mySqlConnection.Open(); string sql = string.Format("update staffInfo set sCard='{0}',sName='{1}',sSex='{2}',sAge={3},sAddress='{4}',deptId={5},sWages={6} where sId={7}" , sCardText.Text.Trim() , sNameText.Text.Trim() , nanBtn.Checked == true ? "男" : "女" , Convert.ToInt32(ageCombo.Text) , sAddressText.Text.Trim() , (int)deptCombo.SelectedValue//部门号是被隐藏了的 , numericUpDown1.Value , flag); MySqlCommand mySqlCommand = new MySqlCommand(sql, mySqlConnection); int result = mySqlCommand.ExecuteNonQuery(); if (result > 0) { MessageBox.Show("修改成功"); this.Close(); } else { MessageBox.Show("修改失败"); //this.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message); //throw; } mySqlConnection.Close(); }
2.修改完成后，关闭窗口，页面自动更新
3.删除员工操作
private void button3_Click(object sender, EventArgs e) { //删除操作 DialogResult dialogResult = MessageBox.Show("确定要删除吗【" + dataGridView1.CurrentRow.Cells[2].Value + "】吗？", "系统提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if(dialogResult == DialogResult.Yes) { MySqlConnection mySqlConnection = null; try { mySqlConnection = new MySqlConnection("server=127.0.0.1;port=3306;user=root;password=123456;database=course"); mySqlConnection.Open(); string sql = string.Format("delete from staffInfo where sId={0}" , Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value)); MySqlCommand mySqlCommand = new MySqlCommand(sql, mySqlConnection); int result = mySqlCommand.ExecuteNonQuery(); if (result > 0) { MessageBox.Show("删除成功"); setDataGridView();//刷新 } else { MessageBox.Show("删除失败"); } } catch (Exception ex) { MessageBox.Show(ex.Message); //throw; } finally { mySqlConnection.Clone(); } } }
4.