private void FrmMainOfAttendanceRecord_FormClosed(object sender, FormClosedEventArgs e) { FrmAnalyzeAR.killHwndOfXls(); V_Work_Schedule.killHwndOfXls(); AppManagement.closeAllExcel(); }
/// <summary> /// 获取考勤记录。 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnGetARResult_Click(object sender, EventArgs e) { V_Work_Schedule v_W_S = new V_Work_Schedule(); v_W_S.WORK_AND_REST_DATE = YearAndMonthStr; /* * if (!v_W_S.ifExistsWS()) { * return; * } */ ARResult aRResult = new ARResult(YearAndMonthStr); string randomStr = RandomStr.GetRandomString(40, true, true, true, false, ""); if (aRResult.updateARResult(randomStr) == 0) { this.dgv.DataSource = MESSAGES.getMSG(randomStr); DGVHelper.AutoSizeForDGV(dgv); ShowResult.show(lblResult, "异常!", false); timerRestoreTheLblResult.Enabled = true; return; } ShowResult.show(lblResult, "完成!", true); //显示结果 AttendanceR aR = new AttendanceR(); this.dgv.DataSource = aR.getARByYearAndMonth(aRResult.Year_And_Month_str); DGVHelper.AutoSizeForDGV(dgv); }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnGenerateWorkSchedule_Click(object sender, EventArgs e) { //获取MonthCalendar的值 //依据Work Summary 生成一张工作安排表 V_Work_Schedule v_W_S = new V_Work_Schedule(); V_Work_Schedule._YearAndMonthStr = this.YearAndMonthStr; if (!WorkSummary.ifExistsWorkSummary(this.YearAndMonthStr)) { ShowResult.show(lblResult, "请先导入5月份考勤记录!", false); timerRestoreTheLblResult.Enabled = true; return; } //生成工作表。 v_W_S.GenWorkSchedule(); MSG msg = v_W_S.genExcel(out xlsFilePath); ShowResult.show(lblResult, msg.Msg, msg.Flag); this.timerRestoreTheLblResult.Enabled = true; }