/// <summary> /// 수정하기 새로운 폼 띄우고 폼 닫히면 새로고침됨 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnUpdate_Click(object sender, EventArgs e) { SalaryVO sv = new SalaryVO() { No = dataGridView1.SelectedRows[0].Cells[0].Value.ToString(), Empno = dataGridView1.SelectedRows[0].Cells[1].Value.ToString(), Name = dataGridView1.SelectedRows[0].Cells[2].Value.ToString(), Salary = float.Parse(dataGridView1.SelectedRows[0].Cells[3].Value.ToString()), Tax = float.Parse(dataGridView1.SelectedRows[0].Cells[4].Value.ToString()), Bonus = float.Parse(dataGridView1.SelectedRows[0].Cells[5].Value.ToString()), TotalSalary = float.Parse(dataGridView1.SelectedRows[0].Cells[6].Value.ToString()), Payday = DateTime.Parse(dataGridView1.SelectedRows[0].Cells[7].Value.ToString()), }; Update_Salary us = new Update_Salary(); us.sv.No = sv.No; us.sv.Empno = sv.Empno; us.sv.Name = sv.Name; us.sv.Salary = sv.Salary; us.sv.Tax = sv.Tax; us.sv.Bonus = sv.Bonus; us.sv.TotalSalary = sv.TotalSalary; us.sv.Payday = sv.Payday; us.FormClosed += new FormClosedEventHandler(Salary_Load); us.Show(); }
public bool InsertSalary(SalaryVO s) { string sp = "proc_salary_insert";//저장프로시져 이름 SqlParameter[] sqlParameters = new SqlParameter[6]; sqlParameters[0] = new SqlParameter("Empno", s.Empno); sqlParameters[1] = new SqlParameter("Salary", s.Salary); sqlParameters[2] = new SqlParameter("Tax", s.Tax); sqlParameters[3] = new SqlParameter("Bonus", s.Bonus); sqlParameters[4] = new SqlParameter("TotalSalary", s.TotalSalary); sqlParameters[5] = new SqlParameter("Payday", s.Payday); bool result = false; if (new DBConnection().Insert(sp, sqlParameters)) { result = true; } return(result); }
/// <summary> /// 급여대장 추가 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnInsert_Click(object sender, EventArgs e) { var sv = new SalaryVO() { Empno = txtEmpno.Text, Salary = float.Parse(txtSalary.Text), Tax = float.Parse(txtTax.Text), Bonus = float.Parse(txtBonus.Text), TotalSalary = float.Parse(txtTotal.Text), Payday = DateTime.Parse(dtpDate.Text) }; if (sal.InsertSalary(sv)) { MessageBox.Show("입력 성공"); } else { MessageBox.Show("입력 실패"); } }
/// <summary> /// 수정하기 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnUpdate_Click(object sender, EventArgs e) { var lst = new SalaryVO() { No = txtNo.Text, Salary = float.Parse(txtSalary.Text), Tax = float.Parse(txtTax.Text), Bonus = float.Parse(txtBonus.Text), TotalSalary = float.Parse(txtTotal.Text), Payday = DateTime.Parse(dtpDate.Text) }; if (new SalaryDAO().UpdateSalary(lst)) { MessageBox.Show("수정 성공"); } else { MessageBox.Show("수정 실패"); } }
public bool UpdateSalary(SalaryVO s) { string sp = "proc_salary_update";//저장프로시져 이름 SqlParameter[] sqlParameters = new SqlParameter[6]; sqlParameters[0] = new SqlParameter("no", s.No); sqlParameters[1] = new SqlParameter("Salary", s.Salary); sqlParameters[2] = new SqlParameter("Tax", s.Tax); sqlParameters[3] = new SqlParameter("Bonus", s.Bonus); sqlParameters[4] = new SqlParameter("TotalSalary", s.TotalSalary); sqlParameters[5] = new SqlParameter("Payday", s.Payday); bool result = true; try { new DBConnection().Update(sp, sqlParameters); } catch (Exception) { result = false; } return(result); }
/// <summary> /// 수정할 데이터를 급여 메인 클래스에서 가져옴 /// </summary> /// <param name="vo"></param> public Update_Salary(SalaryVO vo) : this() { sv = vo; }