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];
}
}
