private IXLCell ShowStandardDataPerEntry(IXLWorksheet workSheet, StandardCounter Counter, int StartRowIndex, int StartColumnIndex, bool showZeros = true) { int ActuallRow = StartRowIndex; int ColumnIndex = StartColumnIndex; ColumnIndex = SetOneValue(workSheet, ActuallRow, ColumnIndex, Counter.GetHeadLineValues()["Klassen"], showZeros); ColumnIndex = SetOneValue(workSheet, ActuallRow, ColumnIndex, Counter.GetHeadLineValues()["Kind-Elemente"], showZeros); ColumnIndex++; ColumnIndex = SetOneValue(workSheet, ActuallRow, ColumnIndex, Counter.GetWMUHeadLineValues()["W"], showZeros); ColumnIndex = SetOneValue(workSheet, ActuallRow, ColumnIndex, Counter.GetWMUHeadLineValues()["M"], showZeros); ColumnIndex = SetOneValue(workSheet, ActuallRow, ColumnIndex, Counter.GetWMUHeadLineValues()["U"], showZeros); ColumnIndex++; ColumnIndex = SetOneValue(workSheet, ActuallRow, ColumnIndex, Counter.GetProjektPhasenHeadLineValues()["Ideen"], showZeros); ColumnIndex = SetOneValue(workSheet, ActuallRow, ColumnIndex, Counter.GetProjektPhasenHeadLineValues()["Vorschläge"], showZeros); ColumnIndex = SetOneValue(workSheet, ActuallRow, ColumnIndex, Counter.GetProjektPhasenHeadLineValues()["Planungen"], showZeros); ColumnIndex = SetOneValue(workSheet, ActuallRow, ColumnIndex, Counter.GetProjektPhasenHeadLineValues()["Projekte"], showZeros); ColumnIndex = SetOneValue(workSheet, ActuallRow, ColumnIndex, Counter.GetProjektPhasenHeadLineValues()["Realisierungen"], showZeros); return workSheet.Cell(ActuallRow, ColumnIndex); }
private IXLCell ShowDataPerEntry(IXLWorksheet workSheet, StatistikRootClass.StatistikDataSelectionTypes writeOutType, StandardCounter Counter, int StartRowIndex, int StartColumnIndex, bool showZeros = true) { int ActuallRow = StartRowIndex; int ColumnIndex = StartColumnIndex; foreach (string writeOutSpecificHeadLine in StandardCounter.GetWriteOutSpecificHeadLines(writeOutType).Keys) { workSheet.Column(ColumnIndex).Width = 1; workSheet.Cell(ActuallRow, ColumnIndex++).Style.Fill.SetBackgroundColor(XLColor.White); foreach (string columnText in StandardCounter.GetWriteOutSpecificHeadLines(writeOutType)[writeOutSpecificHeadLine]) { ColumnIndex = SetOneValue(workSheet, ActuallRow, ColumnIndex, Counter.GetWriteOutSpecificValues (writeOutType)[writeOutSpecificHeadLine][columnText], showZeros); } } return workSheet.Cell(ActuallRow, ColumnIndex); }
public void AddStandardCounterToMe(StandardCounter ChildCounter) { NumberOfKlassen += ChildCounter.NumberOfKlassen; NumberOfRealisierungen += ChildCounter.NumberOfRealisierungen; NumberOfProjekte += ChildCounter.NumberOfProjekte; NumberOfPlanungen += ChildCounter.NumberOfPlanungen; NumberOfVorschlaege += ChildCounter.NumberOfVorschlaege; NumberOfIdeen += ChildCounter.NumberOfIdeen; NumberOfAddProcesses++; SummeW += ChildCounter.SummeW; SummeM += ChildCounter.SummeM; SummeU += ChildCounter.SummeU; foreach (Zustaendigkeit zustaendigkeit in ChildCounter.Zustaendigkeiten.Keys) { if (!Zustaendigkeiten.ContainsKey(zustaendigkeit)) Zustaendigkeiten[zustaendigkeit] = 0; Zustaendigkeiten[zustaendigkeit] += ChildCounter.Zustaendigkeiten[zustaendigkeit]; } foreach (Organisation organisation in ChildCounter.InvolvedSchulen.Keys) { if (!InvolvedSchulen.ContainsKey(organisation)) InvolvedSchulen[organisation] = 0; InvolvedSchulen[organisation] += ChildCounter.InvolvedSchulen[organisation]; } foreach (Typ projektType in ChildCounter.ProjektTypen.Keys) { if (!ProjektTypen.ContainsKey(projektType)) ProjektTypen[projektType] = 0; ProjektTypen[projektType] += ChildCounter.ProjektTypen[projektType]; } }