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