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