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();
}
public OperationReportsVm(AccessType access)
{
CenterPoint = 0;
StartingPoint = 0;
Access = access;
_history = new Stack<OperatorBarInfo>();
DataService = new OperatorReportDataService();
CurrentInterval = DateTimeIntervals.Monthly;
Scales = new ObservableCollection<int>();
ScaleLines = new ObservableCollection<int>();
InitializeProviders(null);
CenterDateChanged += OperationReportsVmCenterDateChanged;
NavigateInsideCommand = new Command(NavigateInside, CanNavigateInside);
NavigateBackCommand = new Command(NavigateBack,CanNavigateBack);
InitializeProviderCommand = new Command(InitializeProviders);
RefreshCommand = new Command(Refresh,CanRefresh);
}