public AutoCheck_Handle(CheckingPerson person, int hour, int min) { CheckingPerson = person; UpdateHour = hour; UpdateMin = min; UpdateDone = false; updateIndex = 0; CheckAreas = Data_Services.Get_ECheckAreas(); shufArr = CheckAreas.Select(i => i.AreaCode).ToArray(); shufArr = shufArr.OrderBy(n => Guid.NewGuid()).ToArray(); }
public string ExportToExcel(DateTime Date) { string ExportLog = string.Empty; try { var areas = Data_Services.Get_ECheckAreas(); if (areas == null) { return(null); } string FilePath = Create_ExcelFile(Date); FileInfo CurrentExcel = new FileInfo(FilePath); using (ExcelPackage excelPackage = new ExcelPackage(CurrentExcel)) { foreach (var area in areas) { string excp = ExportToExcel(excelPackage, Date, (ECheckAreaDef)area.id); if (excp != null) { ExportLog += excp; } } excelPackage.Save(); } return(ExportLog); } catch (Exception ex) { return(null); } }