private void createAvailabilityReport()
{
try
{
AvailabilityReport report = new AvailabilityReport();
report.Postfix = "сформирован вручную";
report.H1 = report.ReportName;
if (report.Save())
{
MessageBox.Show("Отчет сохранен!");
}
else
{
MessageBox.Show("При формировании отчета произошли ошибки!\nПодробности см. в логе ошибок.");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnGenerate_Click(object sender, RoutedEventArgs e)
{
ReportTable = null;
avReport = null;
dgReportGrid.DataContext = null;
dgReportGrid.Visibility = Visibility.Visible;
if (cmbReportSelector.SelectedIndex == 0)
{
ReportTable = dataAccess.GetReportData(dpFrom.SelectedDate.Value, dpTo.SelectedDate.Value);
dgReportGrid.DataContext = ReportTable;
}
else if (cmbReportSelector.SelectedIndex == 1)
{
avReport = new AvailabilityReport();
int[] lineids = { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 };
foreach (Shift s in shifts)
{
if (s.Name != "GEN_SHIFT")
{
String date = String.Empty;
foreach (Session se in s.Sessions)
{
DateTime f = new DateTime(dpFrom.SelectedDate.Value.Year,
dpFrom.SelectedDate.Value.Month,
dpFrom.SelectedDate.Value.Day,
TimeSpan.Parse(se.StartTime).Hours,
TimeSpan.Parse(se.StartTime).Minutes,
TimeSpan.Parse(se.StartTime).Seconds
);
DateTime t = new DateTime(dpTo.SelectedDate.Value.Year,
dpTo.SelectedDate.Value.Month,
dpTo.SelectedDate.Value.Day,
TimeSpan.Parse(se.EndTime).Hours,
TimeSpan.Parse(se.EndTime).Minutes,
TimeSpan.Parse(se.EndTime).Seconds
);
if (s.Name == "THIRD SHIFT" && se.Name != "FIRST HOUR")
{
f = f.AddDays(1);
t = t.AddDays(1);
date = t.ToShortDateString();
}
else
{
date = f.ToShortDateString();
}
foreach (int n in lineids)
{
DataTable dt = dataAccess.GetHourlyReportData(n, f, t);
if (dt.Rows.Count == 0)
{
continue;
}
Availability av = new Availability();
for (int j = 0; j < dt.Rows.Count; j++)
{
IssueDetails issueDetail = new IssueDetails();
issueDetail.Line = (int)dt.Rows[j]["LINE"];
issueDetail.Station = (int)dt.Rows[j]["STATION"];
issueDetail.Tolerance = (int)dt.Rows[j]["Tolerance"];
issueDetail.Raised = (TimeSpan)dt.Rows[j]["Raised"];
if (dt.Rows[j]["Resolved"] == DBNull.Value)
{
issueDetail.Resolved = TimeSpan.Parse(se.EndTime);
}
else
{
issueDetail.Resolved = (TimeSpan)dt.Rows[j]["Resolved"];
if (issueDetail.Resolved > TimeSpan.Parse(se.EndTime))
{
issueDetail.Resolved = TimeSpan.Parse(se.EndTime);
}
}
TimeSpan ToleranceLimit = new TimeSpan(0, issueDetail.Tolerance, 0);
if (issueDetail.Resolved - issueDetail.Raised > ToleranceLimit)
{
av.Add(issueDetail);
}
}
avReport.Add(new AvailabilityRecord((string)dt.Rows[0]["LINENAME"],
date, f.ToShortTimeString() + "-" + t.ToShortTimeString(),
av.getAvailability(f.TimeOfDay, t.TimeOfDay).ToString(), av.EffectiveDowntime.ToString()));
}
}
}
}
dgReportGrid.AutoGenerateColumns = true;
dgReportGrid.DataContext = avReport;
}
}
private void btnGenerate_Click(object sender, RoutedEventArgs e)
{
ReportTable = null;
avReport = null;
dgReportGrid.DataContext = null;
dgReportGrid.Visibility = Visibility.Visible;
if (cmbReportSelector.SelectedIndex == 0)
{
ReportTable = dataAccess.GetReportData(dpFrom.SelectedDate.Value, dpTo.SelectedDate.Value);
dgReportGrid.DataContext = ReportTable;
}
else if (cmbReportSelector.SelectedIndex == 1)
{
avReport = new AvailabilityReport();
int[] lineids = {1,2,3,4,5,6,7,8,9,10};
foreach (Shift s in shifts)
{
if (s.Name != "GEN_SHIFT")
{
String date = String.Empty;
foreach (Session se in s.Sessions)
{
DateTime f = new DateTime(dpFrom.SelectedDate.Value.Year,
dpFrom.SelectedDate.Value.Month,
dpFrom.SelectedDate.Value.Day,
TimeSpan.Parse(se.StartTime).Hours,
TimeSpan.Parse(se.StartTime).Minutes,
TimeSpan.Parse(se.StartTime).Seconds
);
DateTime t = new DateTime(dpTo.SelectedDate.Value.Year,
dpTo.SelectedDate.Value.Month,
dpTo.SelectedDate.Value.Day,
TimeSpan.Parse(se.EndTime).Hours,
TimeSpan.Parse(se.EndTime).Minutes,
TimeSpan.Parse(se.EndTime).Seconds
);
if (s.Name == "THIRD SHIFT" && se.Name != "FIRST HOUR")
{
t = t.AddDays(1);
date = t.ToShortDateString();
}
else
date = f.ToShortDateString();
foreach(int n in lineids)
{
DataTable dt = dataAccess.GetHourlyReportData(n, f, t);
if (dt.Rows.Count == 0) continue;
Availability av = new Availability();
for (int j = 0; j < dt.Rows.Count; j++)
{
IssueDetails issueDetail = new IssueDetails();
issueDetail.Line = (int)dt.Rows[j]["LINE"];
issueDetail.Station = (int)dt.Rows[j]["STATION"];
issueDetail.Tolerance = (int)dt.Rows[j]["Tolerance"];
issueDetail.Raised = (TimeSpan)dt.Rows[j]["Raised"];
if (dt.Rows[j]["Resolved"] == DBNull.Value)
issueDetail.Resolved = TimeSpan.Parse(se.EndTime);
else
{
issueDetail.Resolved = (TimeSpan)dt.Rows[j]["Resolved"];
if (issueDetail.Resolved > TimeSpan.Parse(se.EndTime))
{
issueDetail.Resolved = TimeSpan.Parse(se.EndTime);
}
}
TimeSpan ToleranceLimit = new TimeSpan(0, issueDetail.Tolerance, 0);
if (issueDetail.Resolved - issueDetail.Raised > ToleranceLimit)
{
av.Add(issueDetail);
}
}
avReport.Add(new AvailabilityRecord((string)dt.Rows[0]["LINENAME"],
date, f.ToShortTimeString() + "-" + t.ToShortTimeString(),
av.getAvailability( f.TimeOfDay, t.TimeOfDay).ToString()));
}
}
}
}
dgReportGrid.AutoGenerateColumns = true;
dgReportGrid.DataContext = avReport;
}
}
