private void FrmAskForLeave_Load(object sender, EventArgs e) { tbNO.Text = ASK_For_Leave_Helper.getLastedNO(); this.dgv.DataSource = ASK_For_Leave_Helper.getAllVacationList(); DGVHelper.AutoSizeForDGV(dgv); dtStartPicker.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day); dtEndPicker.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day); timeStartPicker.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 8, 0, 0); timeEndPicker.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 17, 0, 0); }
/// <summary> /// 删除该假条 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void delByNOToolStripMenuItem_Click(object sender, EventArgs e) { DataGridViewRow dgvR = dgv.CurrentRow; if (dgvR == null) { return; } string NO = dgvR.Cells["单号"].Value.ToString(); ASK_For_Leave_Helper.delTheNO(NO); this.dgv.DataSource = ASK_For_Leave_Helper.getAllVacationList(); DGVHelper.AutoSizeForDGV(dgv); }
/* * private void timeStartPicker_ValueChanged(object sender, EventArgs e) * { * // _start_hour = timeStartPicker.Value.Hour; * //_start_minute = timeStartPicker.Value.Minute; * if (_start_hour < 8 ) * { * MessageBox.Show("起始时间点必须从8点开始:", "提示:", MessageBoxButtons.OK, MessageBoxIcon.Information); * //timeStartPicker.Value = new DateTime(_year, _month,_day, 8, 0, 0); * return; * } * //_start_second = timeStartPicker.Value.Second; * } * private void timeEndPicker_ValueChanged(object sender, EventArgs e) * { * //_end_hour = timeEndPicker.Value.Hour; * //_end_minute = timeEndPicker.Value.Minute; * if (_end_hour >=17 && _end_minute>0) { * MessageBox.Show("结束时间最晚为17:00","提示:",MessageBoxButtons.OK,MessageBoxIcon.Information); * //timeEndPicker.Value = new DateTime(_year, _month, _day, 17, 0,0); * return; * } * //_end_second = timeEndPicker.Value.Second; * } */ /// <summary> /// 删除该假条 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void delByNOToolStripMenuItem_Click(object sender, EventArgs e) { DataGridViewRow dgvR = dgv.CurrentRow; if (dgvR == null) { return; } //string NO = dgvR.Cells["单号"].Value.ToString(); string name = dgvR.Cells["姓名"].Value.ToString(); string year_month_day_str = dgvR.Cells["请假日期"].Value.ToString().Substring(0, 10); // ASK_For_Leave_Helper.delByNameAndMonth(name, year_month_day_str); this.dgv.DataSource = ASK_For_Leave_Helper.getAllVacationListByNameAndDate(cbName.Text.Trim()); DGVHelper.AutoSizeForDGV(dgv); }
/// <summary> /// 提交请假 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSubmit_Click(object sender, EventArgs e) { if (!checkName()) { return; } if (tbName.Text.Trim() == "") { return; } startDateTime = new DateTime(_start_year, _start_month, _start_day, _start_hour, _start_minute, _start_second); endDateTime = new DateTime(_end_year, _end_month, _end_day, _end_hour, _end_minute, _end_second); if (startDateTime >= endDateTime) { ShowResult.show(lblResult, "结束时间需比起始时间大!", false); timerClsResult.Enabled = true; return; } string startTime = startDateTime.ToString("yyyy-MM-dd HH:mm:ss"); string endTime = endDateTime.ToString("yyyy-MM-dd HH:mm:ss"); a_F_L_H = new ASK_For_Leave_Helper(tbName.Text.Trim(), startTime, endTime, tbNO.Text.Trim()); //先判断是否有日期范围的假条 if (a_F_L_H.ifExistsAtRange()) { ShowResult.show(lblResult, "已存在该日期范围的假条!", false); timerClsResult.Enabled = true; return; } if (a_F_L_H.ifExistsVacationAtRange()) { ShowResult.show(lblResult, "所设定的范围,涵盖公司休假日,请分段请假!", false); timerClsResult.Enabled = true; return; } a_F_L_H.save(); tbNO.Text = ASK_For_Leave_Helper.getLastedNO(); this.dgv.DataSource = ASK_For_Leave_Helper.getAllVacationList(); DGVHelper.AutoSizeForDGV(dgv); }
private void FrmAskForLeave_Load(object sender, EventArgs e) { this.cbName.SelectedIndexChanged -= new System.EventHandler(this.cbName_SelectedIndexChanged); //tbNO.Text = ASK_For_Leave_Helper.getLastedNO(); dtPicker.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day); //timeStartPicker.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day,8, 0, 0); //timeEndPicker.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 17, 0, 0); string sqlStr = string.Format(@"select distinct name,job_number from attendance_record_final where trunc(finger_print_date,'MM')>=trunc(add_months(sysdate,-3),'MM') ORDER BY NLSSORT(name,'NLS_SORT= SCHINESE_PINYIN_M') ASC"); DataTable dt = OracleDaoHelper.getDTBySql(sqlStr); this.cbName.DataSource = dt; cbName.DisplayMember = "name"; cbName.ValueMember = "job_number"; this.cbName.SelectedIndexChanged += new System.EventHandler(this.cbName_SelectedIndexChanged); cbName.SelectedIndex = -1; this.dgv.DataSource = ASK_For_Leave_Helper.getAllVacationListLastThreeMonths(); DGVHelper.AutoSizeForDGV(dgv); }
/// <summary> /// 提交请假 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSubmit_Click(object sender, EventArgs e) { if (!checkName()) { MessageBox.Show(cbName.Text.Trim() + ": 没有在近5个月以内的考勤系统人员名单中。请用备用方案请假!", "提示!", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (cbName.Text.Trim() == "") { return; } if (cbTimeSection.Text.Trim() == "") { return; } //startDateTime = new DateTime(_year, _month,_day,_start_hour,_start_minute,_start_second); //endDateTime = new DateTime(_year, _month, _day, _end_hour, _end_minute, _end_second); /*if (startDateTime >= endDateTime) { * ShowResult.show(lblResult, "结束时间需比起始时间大!", false); * timerClsResult.Enabled = true; * return; * } */ //string startTime = startDateTime.ToString("yyyy-MM-dd HH:mm:ss"); //string endTime = endDateTime.ToString("yyyy-MM-dd HH:mm:ss"); startTimeStr = string.Format(@"{0}-{1}-{2} {3}", dtPicker.Value.Year.ToString(), dtPicker.Value.Month.ToString(), dtPicker.Value.Day.ToString(), cbTimeSection.Text.ToString().Split('-')[0].Trim().ToString()); endTimeStr = string.Format(@"{0}-{1}-{2} {3}", dtPicker.Value.Year.ToString(), dtPicker.Value.Month.ToString(), dtPicker.Value.Day.ToString(), cbTimeSection.Text.ToString().Split('-')[1].Trim().ToString()); a_F_L_H = new ASK_For_Leave_Helper(cbName.Text.Trim(), startTimeStr, endTimeStr, ""); //先判断是否有日期范围的假条 if (a_F_L_H.ifExistsAtRange()) { ShowResult.show(lblResult, "已存在该日期范围的假条!", false); timerClsResult.Enabled = true; return; } //判断是否设定了加班日 if (!ifConfigRestDay(year_and_month_str)) { ShowResult.show(lblResult, "请先设定加班日!", false); timerClsResult.Enabled = true; return; } if (ifTheRestDay(year_and_month_day_str)) { ShowResult.show(lblResult, year_and_month_day_str + " :为休息日!", false); timerClsResult.Enabled = true; return; } //a_F_L_H.save(); //tbNO.Text = ASK_For_Leave_Helper.getLastedNO(); string sqlStr = string.Format(@"insert into Ask_For_Leave( job_number, name, leave_date, leave_start_time, leave_end_time ) values( '{0}', '{1}', to_date('{2}','yyyy-MM-dd'), to_date('{3}','yyyy-MM-dd HH24:MI'), to_date('{4}','yyyy-MM-dd HH24:MI') )", cbName.SelectedValue.ToString(), cbName.Text.Trim(), year_and_month_day_str, startTimeStr, endTimeStr );; OracleDaoHelper.executeSQL(sqlStr); this.dgv.DataSource = ASK_For_Leave_Helper.getAllVacationListByNameAndDate(cbName.Text.Trim()); DGVHelper.AutoSizeForDGV(dgv); cbTimeSection.SelectedIndex = -1; }