/// <summary>
/// Constructor
/// </summary>
/// <param name="report">report document</param>
/// <param name="data">report data</param>
/// <exception cref="ArgumentException">Flow document must have a specified page height</exception>
/// <exception cref="ArgumentException">Flow document must have a specified page width</exception>
/// <exception cref="ArgumentException">Flow document can have only one report header section</exception>
/// <exception cref="ArgumentException">Flow document can have only one report footer section</exception>
public ReportPaginator(ReportDocument report, ReportData data)
{
_report = report;
_data = data;
_flowDocument = report.CreateFlowDocument();
_pageSize = new Size(_flowDocument.PageWidth, _flowDocument.PageHeight);
if (_flowDocument.PageHeight == double.NaN) throw new ArgumentException("Flow document must have a specified page height");
if (_flowDocument.PageWidth == double.NaN) throw new ArgumentException("Flow document must have a specified page width");
_dynamicCache = new ReportPaginatorDynamicCache(_flowDocument);
ArrayList listPageHeaders = _dynamicCache.GetFlowDocumentVisualListByType(typeof(SectionReportHeader));
if (listPageHeaders.Count > 1) throw new ArgumentException("Flow document can have only one report header section");
if (listPageHeaders.Count == 1) _blockPageHeader = (SectionReportHeader)listPageHeaders[0];
ArrayList listPageFooters = _dynamicCache.GetFlowDocumentVisualListByType(typeof(SectionReportFooter));
if (listPageFooters.Count > 1) throw new ArgumentException("Flow document can have only one report footer section");
if (listPageFooters.Count == 1) _blockPageFooter = (SectionReportFooter)listPageFooters[0];
_paginator = ((IDocumentPaginatorSource)_flowDocument).DocumentPaginator;
// remove header and footer in our working copy
Block block = _flowDocument.Blocks.FirstBlock;
while (block != null)
{
Block thisBlock = block;
block = block.NextBlock;
if ((thisBlock == _blockPageHeader) || (thisBlock == _blockPageFooter)) _flowDocument.Blocks.Remove(thisBlock);
}
// get report context values
_reportContextValues = _dynamicCache.GetFlowDocumentVisualListByInterface(typeof(IInlineContextValue));
FillData();
}
/// <summary>
/// Helper method to create page header or footer from flow document template
/// </summary>
/// <param name="data">report data</param>
/// <param name="fileName">file to save XPS to</param>
/// <returns></returns>
public XpsDocument CreateXpsDocument(ReportData data, string fileName)
{
Package pkg = Package.Open(fileName, FileMode.Create, FileAccess.ReadWrite);
string pack = "pack://report.xps";
PackageStore.RemovePackage(new Uri(pack));
PackageStore.AddPackage(new Uri(pack), pkg);
XpsDocument doc = new XpsDocument(pkg, _xpsCompressionOption, pack);
XpsSerializationManager rsm = new XpsSerializationManager(new XpsPackagingPolicy(doc), false);
DocumentPaginator paginator = ((IDocumentPaginatorSource)CreateFlowDocument()).DocumentPaginator;
ReportPaginator rp = new ReportPaginator(this, data);
rsm.SaveAsXaml(rp);
rsm.Commit();
pkg.Close();
return new XpsDocument(fileName, FileAccess.Read);
}
/// <summary>
/// Helper method to create page header or footer from flow document template
/// </summary>
/// <param name="data">report data</param>
/// <returns></returns>
public XpsDocument CreateXpsDocument(ReportData data)
{
MemoryStream ms = new MemoryStream();
Package pkg = Package.Open(ms, FileMode.Create, FileAccess.ReadWrite);
string pack = "pack://report.xps";
PackageStore.RemovePackage(new Uri(pack));
PackageStore.AddPackage(new Uri(pack), pkg);
XpsDocument doc = new XpsDocument(pkg, CompressionOption.NotCompressed, pack);
XpsSerializationManager rsm = new XpsSerializationManager(new XpsPackagingPolicy(doc), false);
DocumentPaginator paginator = ((IDocumentPaginatorSource)CreateFlowDocument()).DocumentPaginator;
ReportPaginator rp = new ReportPaginator(this, data);
rsm.SaveAsXaml(rp);
return doc;
}
public void LoadOperatorProcessReport(int operatorId)
{
var dataService = new OperatorReportDataService();
Report = dataService.GetOperatorProcessReport(operatorId, StartDate, EndDate);
var reportDocument = new ReportDocument();
var reader =
new StreamReader(new FileStream(@"Views\Reporting\OperatorProcessReport.xaml", FileMode.Open, FileAccess.Read));
reportDocument.XamlData = reader.ReadToEnd();
reportDocument.XamlImagePath = Path.Combine(Environment.CurrentDirectory, @"Views\Reporting\");
reader.Close();
var data = new ReportData();
// set constant document values
data.ReportDocumentValues.Add("PrintDate", DateTime.Now);
var titleTabel = new DataTable("TitleTable");
titleTabel.Columns.Add("ReportTitle", typeof(string));
var name = Common.Properties.Resources.ResourceManager.GetString("txtName") + Report.Title;
var code = Common.Properties.Resources.ResourceManager.GetString("txtCode") + Report.Code;
var date = DateTime.Now.ToPersianCompactDateTimeString();
titleTabel.Rows.Add(new object[] { name });
titleTabel.Rows.Add(new object[] { code });
titleTabel.Rows.Add(new object[] { date });
data.DataTables.Add(titleTabel);
var totalTabel = new DataTable("TotalTable");
totalTabel.Columns.Add("TimeTotal", typeof(string));
totalTabel.Columns.Add("CountTotal", typeof(string));
totalTabel.Rows.Add(new object[] { Common.Properties.Resources.ResourceManager.GetString("txtTotalTargetTime") + Format.ConvertToHMS((int) Report.TotalTargetTime), Common.Properties.Resources.ResourceManager.GetString("txtTotalTargetCount") + Report.TotalTargetCount });
totalTabel.Rows.Add(new object[] { Common.Properties.Resources.ResourceManager.GetString("txtTotalProductionTime") + Format.ConvertToHMS((int)Report.TotalProductionTime), Common.Properties.Resources.ResourceManager.GetString("txTotalProductionCount") + Report.TotalProductionCount });
totalTabel.Rows.Add(new object[] { Common.Properties.Resources.ResourceManager.GetString("txtTotalExtraTime") + Format.ConvertToHMS((int)Report.TotalExtraTime), Common.Properties.Resources.ResourceManager.GetString("txtTotalExtraCount") + Report.TotalExtraCount });
totalTabel.Rows.Add(new object[] { Common.Properties.Resources.ResourceManager.GetString("txtTotalShortageTime") + Format.ConvertToHMS((int)Report.TotalShortageTime), Common.Properties.Resources.ResourceManager.GetString("txtTotalShortageCount") + Report.TotalShortageCount });
totalTabel.Rows.Add(new object[] { Common.Properties.Resources.ResourceManager.GetString("txtTotalDefectionTime") + Format.ConvertToHMS((int)Report.TotalDefectionTime), Common.Properties.Resources.ResourceManager.GetString("txtTotalDefectionCount") + Report.TotalDefectionCount });
totalTabel.Rows.Add(new object[] { Common.Properties.Resources.ResourceManager.GetString("txtTotalWaste") + Report.TotalWaste, Common.Properties.Resources.ResourceManager.GetString("txtTotalSecondGrade") + Report.TotalSecondGrade });
data.DataTables.Add(totalTabel);
var activitiesTable = new DataTable("ActivitiesReport");
activitiesTable.Columns.Add("Date", typeof(string));
activitiesTable.Columns.Add("Product", typeof (string));
activitiesTable.Columns.Add("Station", typeof (string));
activitiesTable.Columns.Add("Activity", typeof (string));
activitiesTable.Columns.Add("TargetValue", typeof (string));
activitiesTable.Columns.Add("ProductionValue", typeof (string));
activitiesTable.Columns.Add("DefectionValue", typeof (string));
activitiesTable.Columns.Add("StoppageValue", typeof (string));
activitiesTable.Columns.Add("IsRework", typeof (string));
foreach (var item in Report.ActivityItems)
{
activitiesTable.Rows.Add(CurrentType == OEType.CountBased
? new object[]
{
item.Date.ToShortDateString(), item.Product, item.Station, item.Activity, item.TargetCount, item.ProductionCount,
item.DefectionCount, item.StoppageCount, item.IsRework
}
: new object[]
{
item.Date.ToShortDateString(), item.Product, item.Station, item.Activity, item.TargetTime, item.ProductionTime,
item.DefectionTime, item.StoppageTime, item.IsRework
});
}
data.DataTables.Add(activitiesTable);
var qualitiveTable = new DataTable("QualitiveReport");
qualitiveTable.Columns.Add("Date", typeof(string));
qualitiveTable.Columns.Add("Product", typeof(string));
qualitiveTable.Columns.Add("Station", typeof(string));
qualitiveTable.Columns.Add("Activity", typeof(string));
qualitiveTable.Columns.Add("DefectionValue", typeof(string));
qualitiveTable.Columns.Add("SecondGrade", typeof(string));
qualitiveTable.Columns.Add("Waste", typeof(string));
foreach (var item in Report.QualitiveItems)
{
var waste = item.Status == QualitiveStatus.Waste ? "*" : string.Empty;
var secondGrade = item.Status == QualitiveStatus.SecondGrade ? "*" : string.Empty;
var defection = CurrentType == OEType.CountBased ? item.DefectionCount : item.DefectionTime;
qualitiveTable.Rows.Add(new object[]
{
item.Date.ToShortDateString(), item.Product, item.Station, item.Activity, defection, secondGrade, waste
});
}
data.DataTables.Add(qualitiveTable);
var technicalTable = new DataTable("TechnicalReport");
technicalTable.Columns.Add("Date", typeof(string));
technicalTable.Columns.Add("Product", typeof(string));
technicalTable.Columns.Add("Station", typeof(string));
technicalTable.Columns.Add("Activity", typeof(string));
technicalTable.Columns.Add("StoppageValue", typeof(string));
foreach (var item in Report.TechnicalItems)
{
var stoppage = CurrentType == OEType.CountBased ? item.StoppageCount : item.StoppageTime;
technicalTable.Rows.Add(new object[]
{
item.Date.ToShortDateString(), item.Product, item.Station, item.Activity, stoppage
});
}
data.DataTables.Add(technicalTable);
XpsDocument xps = reportDocument.CreateXpsDocument(data);
Document = xps.GetFixedDocumentSequence();
}
