با سلام . تهیه گزارش زیر نزدیک به 19 ثانیه طول میکشد. علت در چیست؟
public IPdfReportData Create()
{
return new PdfReport().DocumentPreferences(doc =>
{
//DocumentMargins margin = new DocumentMargins()
//{
// Bottom = 5,
// Left = 5,
// Right = 5,
// Top = 5,
//};
//doc.DocumentMargins(margin);
//PrintingPreferences printPreference = new PrintingPreferences()
//{
// ShowPrintDialogAutomatically = true,
//};
//doc.PrintingPreferences(printPreference);
doc.RunDirection(PdfRunDirection.RightToLeft);
doc.Orientation(PageOrientation.Landscape);
doc.PageSize(PdfPageSize.A4);
doc.DocumentMetadata(new DocumentMetadata
{
Author = "ILIA",
Application = "PdfRpt",
Keywords = "IList Rpt.",
Subject = "ابلاغ استاد",
Title = "ابلاغ استاد"
});
})
.DefaultFonts(fonts =>
{
fonts.Size(8);
fonts.Path(Environment.GetEnvironmentVariable("SystemRoot") + "\\fonts\\BYekan.ttf",
Environment.GetEnvironmentVariable("SystemRoot") + "\\fonts\\tahoma.ttf");
})
.PagesFooter(footer =>
{
footer.DefaultFooter(DateTime.Now.ToString("MM/dd/yyyy"));
})
.PagesHeader(header =>
{
//header.PdfFont.Fonts.Add(new iTextSharp.text.Font("BYekan", 10f,0, new BaseColor(Color.Black)));
//header.PdfFont.Fonts.Add(new iTextSharp.text.Font("BYekan", 10f, new BaseColor(Color.Black)));
//CH_Rpt_TeacherEblagh ch = new CH_Rpt_TeacherEblagh(TermId.ToString(), "ساری", CenterId.ToString());
//header.CustomHeader(ch);
header.DefaultHeader(defaultHeader =>
{
defaultHeader.RunDirection(PdfRunDirection.RightToLeft);
//defaultHeader.ImagePath(AppPath.ApplicationPath + "\\Images\\01.png");
defaultHeader.Message("ابلاغ استاد");
});
})
.MainTableTemplate(template =>
{
template.BasicTemplate(BasicTemplate.SilverTemplate);
})
.MainTablePreferences(table =>
{
table.ColumnsWidthsType(TableColumnWidthType.Absolute);
table.NumberOfDataRowsPerPage(0);
})
.MainTableDataSource(dataSource =>
{
dataSource.StronglyTypedList<ProgramRowSemiInfo>(resultSource);
})
.MainTableSummarySettings(summarySettings =>
{
//summarySettings.OverallSummarySettings("Summary");
// summarySettings.PreviousPageSummarySettings("Previous Page Summary");
// summarySettings.PageSummarySettings("Page Summary");
})
.MainTableColumns(columns =>
{
columns.AddColumn(column =>
{
column.PropertyName("rowNo");
column.IsRowNumber(true);
column.CellsHorizontalAlignment(HorizontalAlignment.Center);
column.IsVisible(true);
column.Order(0);
column.Width(15);
column.HeaderCell("#", horizontalAlignment: HorizontalAlignment.Center);
});
columns.AddColumn(column =>
{
column.PropertyName<ProgramRowSemiInfo>(x => x.LessonId);
column.CellsHorizontalAlignment(HorizontalAlignment.Left);
column.IsVisible(true);
column.Order(1);
column.Width(35);
column.HeaderCell("کد درس", horizontalAlignment: HorizontalAlignment.Left);
});
columns.AddColumn(column =>
{
column.PropertyName<ProgramRowSemiInfo>(x => x.LessonName);
column.CellsHorizontalAlignment(HorizontalAlignment.Left);
column.IsVisible(true);
column.Order(2);
column.Width(80);
column.HeaderCell("عنوان درس", horizontalAlignment: HorizontalAlignment.Left);
});
columns.AddColumn(column =>
{
column.PropertyName<ProgramRowSemiInfo>(x => x.GroupNumber);
column.CellsHorizontalAlignment(HorizontalAlignment.Center);
column.IsVisible(true);
column.Order(2);
column.Width(20);
column.HeaderCell("گروه", horizontalAlignment: HorizontalAlignment.Center);
});
//columns.AddColumn(column =>
//{
// column.PropertyName<ProgramRowSemiInfo>(x => x.TrendName);
// column.CellsHorizontalAlignment(HorizontalAlignment.Left);
// column.IsVisible(true);
// column.Order(3);
// column.Width(100);
// column.HeaderCell("عنوان رشته", horizontalAlignment: HorizontalAlignment.Left);
//});
columns.AddColumn(column =>
{
column.PropertyName<ProgramRowSemiInfo>(x => x.TimeShort);
column.CellsHorizontalAlignment(HorizontalAlignment.Center);
column.IsVisible(true);
column.Order(3);
column.Width(30);
column.HeaderCell("ساعت", horizontalAlignment: HorizontalAlignment.Center);
});
columns.AddColumn(column =>
{
column.PropertyName<ProgramRowSemiInfo>(x => x.DaySemiTitle);
column.CellsHorizontalAlignment(HorizontalAlignment.Center);
column.IsVisible(true);
column.Order(3);
column.Width(15);
column.HeaderCell("روز", horizontalAlignment: HorizontalAlignment.Center);
});
columns.AddColumn(column =>
{
column.PropertyName<ProgramRowSemiInfo>(x => x.SessionCount);
column.CellsHorizontalAlignment(HorizontalAlignment.Left);
column.IsVisible(true);
column.Order(3);
column.Width(15);
column.HeaderCell("ت ج", horizontalAlignment: HorizontalAlignment.Left);
});
columns.AddColumn(column =>
{
column.PropertyName<ProgramRowSemiInfo>(x => x.SumOfTeachStringShort);
column.CellsHorizontalAlignment(HorizontalAlignment.Center);
column.IsVisible(true);
column.Order(3);
column.Width(25);
column.HeaderCell("جمع ساعت", horizontalAlignment: HorizontalAlignment.Center);
});
columns.AddColumn(column =>
{
column.PropertyName<ProgramRowSemiInfo>(x => x.PlaceShortName);
column.CellsHorizontalAlignment(HorizontalAlignment.Left);
column.IsVisible(true);
column.Order(3);
column.Width(42);
column.HeaderCell("ساختمان", horizontalAlignment: HorizontalAlignment.Left);
});
columns.AddColumn(column =>
{
column.PropertyName<ProgramRowSemiInfo>(x => x.ClassShortName);
column.CellsHorizontalAlignment(HorizontalAlignment.Left);
column.IsVisible(true);
column.Order(3);
column.Width(50);
column.HeaderCell("کلاس", horizontalAlignment: HorizontalAlignment.Left);
});
int maxSessionCount = resultSource.Max(p => p.SessionCount);
for (int i = 0; i < maxSessionCount; i++)
{
columns.AddColumn(column =>
{
column.PropertyName("S" + (i + 1));
column.CellsHorizontalAlignment(HorizontalAlignment.Left);
column.IsVisible(true);
column.Order(4);
column.Width(25);
column.HeaderCell("ج " + (i + 1), horizontalAlignment: HorizontalAlignment.Center);
//column.ColumnItemsTemplate(t => t.CustomTemplate(new SessionCustomCellTemplate()));
});
}
})
.MainTableEvents(events =>
{
events.DataSourceIsEmpty(message: "داده ای برای مشاهده وجود ندارد.");
})
.Export(export =>
{
//export.ToExcel();
//export.ToCsv();
//export.ToXml();
})
.Generate(data => data.AsPdfFile(string.Format("{0}\\{1}", ReportPathHelper.ReportsPath, ReportFileName)));
}
اینهم سرویسی که این گزارش را ایجاد میکند:
[ServiceContract(Namespace = "")]
[SilverlightFaultBehavior]
[AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)]
public class PdfReportService
{
[OperationContract]
public string CreateReport(int centerId, int termId, int teacherId)
{
Stopwatch sw = Stopwatch.StartNew();
var rpt = new Rpt_TeacherEblagh(centerId, termId, teacherId);
IPdfReportData rptData = rpt.Create();
sw.Stop();
long m = sw.ElapsedMilliseconds;
string result = rptData.FileName.Replace(HttpRuntime.AppDomainAppPath, string.Empty);
return result;
}
}
این هم خروجی گزارش که تنها یک صفحه دارد ولی باز حدود 20 ثانیه طول میکشد:
.png)
.png)
