public bool Update(EmpVO emp)
{
string sp = "proc_emp_update";
SqlParameter[] sqlParameters = new SqlParameter[12];
sqlParameters[0] = new SqlParameter("empno", emp.Empno);
sqlParameters[1] = new SqlParameter("job", emp.Job);
sqlParameters[2] = new SqlParameter("Pay", emp.Pay);
sqlParameters[3] = new SqlParameter("name", emp.Name);
sqlParameters[4] = new SqlParameter("Department", emp.Department);
sqlParameters[5] = new SqlParameter("Mobile", emp.Mobile);
sqlParameters[6] = new SqlParameter("JoinDate", emp.JoinDate);
sqlParameters[7] = new SqlParameter("LeaveDate", emp.LeaveDate);
sqlParameters[8] = new SqlParameter("BankAccountNo", emp.BankAccountNo);
sqlParameters[9] = new SqlParameter("Bank", emp.Bank);
sqlParameters[10] = new SqlParameter("Email", emp.Email);
sqlParameters[11] = new SqlParameter("Note", emp.Note);
bool result = true;
try
{
new DBConnection().Update(sp, sqlParameters);
}
catch (Exception)
{
result = false;
}
return(result);
}
/// <summary>
/// 수정하기
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
if (!(dtpLeave.Text == "1900-01-01") && dtpLeave.Value < dtpJoin.Value) // 퇴사일이 입사일보다 빠르면 서로 교체
{
DateTime temp = dtpLeave.Value;
dtpLeave.Value = dtpJoin.Value;
dtpJoin.Value = temp;
MessageBox.Show("퇴사일이 입사일보다 빨라 치환되었습니다.");
}
EmpVO vo = new EmpVO()
{
Empno = txtNum.Text,
Job = cbJob.Text,
Pay = float.Parse(txtSalary.Text),
Name = txtName.Text,
Department = txtDepartment.Text,
Mobile = txtPhone.Text,
JoinDate = DateTime.Parse(dtpJoin.Text),
LeaveDate = DateTime.Parse(dtpLeave.Text),
BankAccountNo = txtBankAccountNo.Text,
Bank = cbBank.Text,
Email = txtEmail.Text,
Note = txtNote.Text
};
if (new EmpDAO().Update(vo))
{
MessageBox.Show("수정 성공");
}
else
{
MessageBox.Show("수정 실패");
}
}
/// <summary>
/// 사원 추가
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e) // insert
{
if (check())
{
var emp = new EmpVO()
{
Name = txtName.Text,
Job = cbJob.Text,
Pay = float.Parse(txtSalary.Text),
Department = txtDepartment.Text,
Mobile = txtPhone.Text,
JoinDate = DateTime.Parse(dtpJoin.Text),
BankAccountNo = txtBankAccountNo.Text,
Bank = cbBank.Text,
Email = txtEmail.Text,
Note = txtNote.Text
};
if (ed.InsertBoard(emp))
{
MessageBox.Show("저장 성공");
}
else
{
MessageBox.Show("저장 실패");
}
}
btnClear_Click(null, null);
}
public bool InsertBoard(EmpVO emp)
{
string sp = "proc_emp_insert";
SqlParameter[] sqlParameters = new SqlParameter[10];
sqlParameters[0] = new SqlParameter("job", emp.Job);
sqlParameters[1] = new SqlParameter("Pay", emp.Pay);
sqlParameters[2] = new SqlParameter("name", emp.Name);
sqlParameters[3] = new SqlParameter("Department", emp.Department);
sqlParameters[4] = new SqlParameter("Mobile", emp.Mobile);
sqlParameters[5] = new SqlParameter("JoinDate", emp.JoinDate);
sqlParameters[6] = new SqlParameter("BankAccountNo", emp.BankAccountNo);
sqlParameters[7] = new SqlParameter("Bank", emp.Bank);
sqlParameters[8] = new SqlParameter("Email", emp.Email);
sqlParameters[9] = new SqlParameter("Note", emp.Note);
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 btnUpdate_Click(object sender, EventArgs e) // 수정버튼
{
EmpVO tempVO = new EmpVO()
{
Empno = dataGridView1.SelectedRows[0].Cells[0].Value.ToString(),
Name = dataGridView1.SelectedRows[0].Cells[1].Value.ToString(),
Job = dataGridView1.SelectedRows[0].Cells[2].Value.ToString(),
Pay = float.Parse(dataGridView1.SelectedRows[0].Cells[3].Value.ToString()),
Department = dataGridView1.SelectedRows[0].Cells[4].Value.ToString(),
Mobile = dataGridView1.SelectedRows[0].Cells[5].Value.ToString(),
JoinDate = DateTime.Parse(dataGridView1.SelectedRows[0].Cells[6].Value.ToString()),
LeaveDate = DateTime.Parse(dataGridView1.SelectedRows[0].Cells[7].Value.ToString()),
BankAccountNo = dataGridView1.SelectedRows[0].Cells[8].Value.ToString(),
Bank = dataGridView1.SelectedRows[0].Cells[9].Value.ToString(),
Email = dataGridView1.SelectedRows[0].Cells[10].Value.ToString(),
Note = dataGridView1.SelectedRows[0].Cells[11].Value.ToString(),
};
Update_Emp ue = new Update_Emp();
ue.bo.Empno = tempVO.Empno;
ue.bo.Name = tempVO.Name;
ue.bo.Job = tempVO.Job;
ue.bo.Pay = tempVO.Pay;
ue.bo.Department = tempVO.Department;
ue.bo.Mobile = tempVO.Mobile;
ue.bo.JoinDate = tempVO.JoinDate;
ue.bo.LeaveDate = tempVO.LeaveDate;
ue.bo.BankAccountNo = tempVO.BankAccountNo;
ue.bo.Bank = tempVO.Bank;
ue.bo.Email = tempVO.Email;
ue.bo.Note = tempVO.Note;
ue.FormClosed += new FormClosedEventHandler(Employee_Load);
ue.Show();
}
/// <summary>
/// 수정할 데이터를 인사관리 클래스에서 가져옴
/// </summary>
/// <param name="vo"></param>
public Update_Emp(EmpVO vo) : this()
{
bo = vo;
}
