public string GenerateReportPdf(Guid rptId, Guid companyId)
{
var currentRptInfo = rptInformationService.GetCurrentRptInformation(rptId);
var filePath = Path.Combine(Report.AutoGenerate.Service.AppSettings.GetValue("xlsSaveDirectory"), currentRptInfo.RptPath);
if (!System.IO.File.Exists(filePath))
{
throw new NullReferenceException("The report file does not exist");
}
var startTime = GetStartTime((RptTypeEnum)currentRptInfo.RptType);
IWorkbook workbook = GetExportWorkBook(filePath, (int)currentRptInfo.RptType, "2", startTime, startTime, false, companyId);
if (workbook == null)
{
throw new NullReferenceException("the workbook is null");
}
ReplaceSensitiveDataToEmpty(workbook);
MemoryStream mStream = new MemoryStream();
workbook.Write(mStream);
mStream.Flush();
workbook.Close();
mStream.Close();
return(CommHelper.ConvertXlsToPdf(mStream, companyId.ToString(), currentRptInfo.Name));
}