/// <summary>
/// 수정하기 누르면 새 폼 띄우고 닫을때 이벤트 삽입
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnUpdate_Click(object sender, EventArgs e)
{
AttendanceVO av = new AttendanceVO()
{
No = Int32.Parse(dataGridView1.SelectedRows[0].Cells[0].Value.ToString()),
Name = dataGridView1.SelectedRows[0].Cells[1].Value.ToString(),
Empno = dataGridView1.SelectedRows[0].Cells[2].Value.ToString(),
TimeIn = DateTime.Parse(dataGridView1.SelectedRows[0].Cells[3].Value.ToString()),
TimeOut = DateTime.Parse(dataGridView1.SelectedRows[0].Cells[4].Value.ToString()),
TotalTime = DateTime.Parse(dataGridView1.SelectedRows[0].Cells[5].Value.ToString()),
Date = DateTime.Parse(dataGridView1.SelectedRows[0].Cells[6].Value.ToString()),
TotalPay = float.Parse(dataGridView1.SelectedRows[0].Cells[7].Value.ToString()),
OverTime = DateTime.Parse(dataGridView1.SelectedRows[0].Cells[8].Value.ToString()),
Note = dataGridView1.SelectedRows[0].Cells[9].Value.ToString(),
};
Update_Attendance ua = new Update_Attendance();
ua.av.No = av.No;
ua.av.Name = av.Name;
ua.av.Empno = av.Empno;
ua.av.Date = av.Date;
ua.av.TotalPay = av.TotalPay;
ua.av.TimeIn = av.TimeIn;
ua.av.TimeOut = av.TimeOut;
ua.av.OverTime = av.OverTime;
ua.av.TotalTime = av.TotalTime;
ua.av.Note = av.Note;
ua.FormClosed += new FormClosedEventHandler(Attendance_Load);
ua.Show();
}
public bool UpdateAttendance(AttendanceVO ad)
{
string sp = "proc_attendance_update";//저장프로시져 이름
SqlParameter[] sqlParameters = new SqlParameter[8];
sqlParameters[0] = new SqlParameter("no", ad.No);
sqlParameters[1] = new SqlParameter("TimeIn", ad.TimeIn);
sqlParameters[2] = new SqlParameter("TimeOut", ad.TimeOut);
sqlParameters[3] = new SqlParameter("TotalTime", ad.TotalTime);
sqlParameters[4] = new SqlParameter("Date", ad.Date);
sqlParameters[5] = new SqlParameter("TotalPay", ad.TotalPay);
sqlParameters[6] = new SqlParameter("OverTime", ad.OverTime);
sqlParameters[7] = new SqlParameter("Note", ad.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 btnInsert_Click(object sender, EventArgs e)
{
//dtpTotaltime.Value = TimeSpan.FromHours.dtpTotaltime;
var at = new AttendanceVO()
{
Empno = txtEmpno.Text,
Date = DateTime.Parse(dtpDate.Text),
TotalPay = float.Parse(txtTotalpay.Text),
TimeIn = DateTime.Parse(dtpIn.Text),
TimeOut = DateTime.Parse(dtpOut.Text),
OverTime = DateTime.Parse(dtpOvertime.Text),
TotalTime = DateTime.Parse(dtpTotaltime.Text),
Note = txtNote.Text
};
if (atd.InsertAttendance(at))
{
MessageBox.Show("입력 성공");
}
else
{
MessageBox.Show("입력 실패");
}
}
public bool InsertAttendance(AttendanceVO ad)
{
string sp = "proc_attendance_insert";//저장프로시져 이름
SqlParameter[] sqlParameters = new SqlParameter[8];
sqlParameters[0] = new SqlParameter("empno", ad.Empno);
sqlParameters[1] = new SqlParameter("TimeIn", ad.TimeIn);
sqlParameters[2] = new SqlParameter("TimeOut", ad.TimeOut);
sqlParameters[3] = new SqlParameter("TotalTime", ad.TotalTime);
sqlParameters[4] = new SqlParameter("Date", ad.Date);
sqlParameters[5] = new SqlParameter("TotalPay", ad.TotalPay);
sqlParameters[6] = new SqlParameter("OverTime", ad.OverTime);
sqlParameters[7] = new SqlParameter("note", ad.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 btnInsert_Click(object sender, EventArgs e)
{
AttendanceVO vo = new AttendanceVO()
{
No = Int32.Parse(txtNo.Text),
Date = DateTime.Parse(dtpDate.Text),
TimeIn = DateTime.Parse(dtpIn.Text),
TimeOut = DateTime.Parse(dtpOut.Text),
OverTime = DateTime.Parse(dtpOvertime.Text),
TotalTime = DateTime.Parse(dtpTotaltime.Text),
TotalPay = float.Parse(txtTotalpay.Text),
Note = txtNote.Text
};
if (new AttendanceDAO().UpdateAttendance(vo))
{
MessageBox.Show("수정 성공");
}
else
{
MessageBox.Show("수정 실패");
}
}
/// <summary>
/// 수정할 데이터를 근태관리 클래스에서 가져옴
/// </summary>
/// <param name="vo"></param>
public Update_Attendance(AttendanceVO vo) : this()
{
av = vo;
}
