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