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