Exemplo n.º 1
0
		public void WriteOutNumberOfEntriesPerOrtsTeil(IXLWorksheet workSheet,
			ZustaendigAgOrtsTeilOrt ZustaendigAgOrtsTeilOrtInstance,
			StatistikRootClass.DistributionCountTyp DistTyp, int StartLine)
			{
			switch (DistTyp)
				{
					case StatistikRootClass.DistributionCountTyp.AllTogether:
						{
						foreach (AGCounter agCounter in ZustaendigAgOrtsTeilOrtInstance.Children)
							{
							workSheet.Cell($"B{StartLine}").Value = agCounter.ArbeitsGruppeDaten.NameId;
							IXLRange AGNameRange = workSheet.Range($"C{StartLine}:D{StartLine}").Merge();
							AGNameRange.Style.Alignment.WrapText = true;
							AGNameRange.Style.Alignment.SetVertical(XLAlignmentVerticalValues.Justify);
							AGNameRange.Value = agCounter.ArbeitsGruppeDaten.Beschreibung;
							StartLine++;
							StartLine++;
							foreach (OrtsTeilCounter ortsTeilCounter in agCounter.Children)
								{
								workSheet.Cell($"C{StartLine}").Value = ortsTeilCounter.OrtsTeilDaten.NameId;
								StartLine++;
								foreach (OrtsCounter ortsCounter in ortsTeilCounter.Children)
									{
									workSheet.Cell($"D{StartLine}").Value = ortsCounter.OrtDaten.Bezeichnung;
									workSheet.Cell($"E{StartLine}").SetDataType(XLCellValues.Number);
									workSheet.Cell($"F{StartLine}").SetDataType(XLCellValues.Number);
									workSheet.Cell($"E{StartLine}").Value = ortsCounter.Counter.NumberOfVorschlaege;
									workSheet.Cell($"F{StartLine}").Value = ortsCounter.Counter.NumberOfIdeen;
									StartLine++;
									}
								workSheet.Cell($"D{StartLine}").Style.Alignment.SetHorizontal(XLAlignmentHorizontalValues.Right);
								workSheet.Cell($"D{StartLine}").Value = ortsTeilCounter.OrtsTeilDaten.NameId + " Summen";
								workSheet.Cell($"E{StartLine}").SetDataType(XLCellValues.Number);
								workSheet.Cell($"F{StartLine}").SetDataType(XLCellValues.Number);
								workSheet.Cell($"E{StartLine}").Style.Fill.BackgroundColor = XLColor.LightGray;
								workSheet.Cell($"F{StartLine}").Style.Fill.BackgroundColor = XLColor.LightGray;
								workSheet.Cell($"E{StartLine}").Value = ortsTeilCounter.Counter.NumberOfVorschlaege;
								workSheet.Cell($"F{StartLine}").Value = ortsTeilCounter.Counter.NumberOfIdeen;
								StartLine++;
								StartLine++;
								}
							StartLine++;
							workSheet.Cell($"D{StartLine}").Style.Alignment.SetHorizontal(XLAlignmentHorizontalValues.Right);
							workSheet.Cell($"D{StartLine}").Value = agCounter.ArbeitsGruppeDaten.NameId + " Summen";
							workSheet.Cell($"E{StartLine}").SetDataType(XLCellValues.Number);
							workSheet.Cell($"F{StartLine}").SetDataType(XLCellValues.Number);
							workSheet.Cell($"E{StartLine}").Style.Fill.BackgroundColor = XLColor.LightGray;
							workSheet.Cell($"F{StartLine}").Style.Fill.BackgroundColor = XLColor.LightGray;
							workSheet.Cell($"E{StartLine}").Value = agCounter.Counter.NumberOfVorschlaege;
							workSheet.Cell($"F{StartLine}").Value = agCounter.Counter.NumberOfIdeen;
							StartLine++;
							StartLine++;
							}
						StartLine++;
						}
						break;
					case StatistikRootClass.DistributionCountTyp.PerAG:
						{
						StartLine++;
						foreach (AGCounter agCounter in ZustaendigAgOrtsTeilOrtInstance.Children)
							{
							workSheet.Cell($"B{StartLine}").Value = agCounter.ArbeitsGruppeDaten.NameId;
							IXLRange AGNameRange = workSheet.Range($"C{StartLine}:D{StartLine}").Merge();
							AGNameRange.Style.Alignment.WrapText = true;
							AGNameRange.Style.Alignment.SetVertical(XLAlignmentVerticalValues.Justify);
							AGNameRange.Value = agCounter.ArbeitsGruppeDaten.Beschreibung;
							workSheet.Cell($"E{StartLine}").SetDataType(XLCellValues.Number);
							workSheet.Cell($"F{StartLine}").SetDataType(XLCellValues.Number);
							workSheet.Cell($"E{StartLine}").Style.Fill.BackgroundColor = XLColor.LightGray;
							workSheet.Cell($"F{StartLine}").Style.Fill.BackgroundColor = XLColor.LightGray;
							workSheet.Cell($"E{StartLine}").Value = agCounter.Counter.NumberOfProjekte;
							workSheet.Cell($"F{StartLine}").Value = agCounter.Counter.NumberOfIdeen;
							StartLine++;
							StartLine++;
							}
						StartLine++;
						}
						break;
					case StatistikRootClass.DistributionCountTyp.PerOrtsTeil:
						{
						foreach (AGCounter agCounter in ZustaendigAgOrtsTeilOrtInstance.Children)
							{
							StartLine++;
							foreach (OrtsTeilCounter ortsTeilCounter in agCounter.Children)
								{
								workSheet.Cell($"C{StartLine}").Value = ortsTeilCounter.OrtsTeilDaten.NameId;
								workSheet.Cell($"E{StartLine}").SetDataType(XLCellValues.Number);
								workSheet.Cell($"F{StartLine}").SetDataType(XLCellValues.Number);
								workSheet.Cell($"E{StartLine}").Style.Fill.BackgroundColor = XLColor.LightGray;
								workSheet.Cell($"F{StartLine}").Style.Fill.BackgroundColor = XLColor.LightGray;
								workSheet.Cell($"E{StartLine}").Value = ortsTeilCounter.Counter.NumberOfProjekte;
								workSheet.Cell($"F{StartLine}").Value = ortsTeilCounter.Counter.NumberOfIdeen;
								StartLine++;
								StartLine++;
								}
							}
						StartLine++;
						}
						break;
				}
			}
Exemplo n.º 2
0
		public List<string> ProjektCounterColumns(StatistikRootClass.DistributionCountTyp DistTyp)
			{
			switch (DistTyp)
				{
					case StatistikRootClass.DistributionCountTyp.AllTogether:
						return new List<string>
							{
							"AG",
							"OrtsTeil",
							"Ort",
							"Projekte",
							"Ideen"
							};
						break;
					case StatistikRootClass.DistributionCountTyp.PerAG:
						return new List<string>
							{
							"AG",
							"",
							"",
							"Projekt",
							"Ideen"
							};
						break;
					case StatistikRootClass.DistributionCountTyp.PerOrtsTeil:
						return new List<string>
							{
							"AG",
							"OrtsTeil",
							"",
							"Projekt",
							"Ideen"
							};
						break;
					default:
						return new List<string>
							{
							"AG",
							"OrtsTeil",
							"Ort",
							"Projekt",
							"Ideen"
							};
						break;
				}
			}
Exemplo n.º 3
0
		private int CreateXLSXHeadLines(IXLWorksheet workSheet, IXLCell StartTableCell,
			StatistikRootClass.StatistikDataSelectionTypes writeOutType)
			{
			workSheet.Column("A").Width = 2;
			int LineNumber = StartTableCell.WorksheetRow().RowNumber();
			int StartColumnIndex = StartTableCell.WorksheetColumn().ColumnNumber();

			//		FullTable.Theme = XLTableTheme.TableStyleLight20;
			CreateGroupHeader(workSheet, "AG's, OrtsTeile, Orte", LineNumber, StartColumnIndex, 6);

			workSheet.Column(StartColumnIndex).Width = 3;
			workSheet.Column(StartColumnIndex + 1).Width = 3;
			workSheet.Column(StartColumnIndex + 2).Width = 3;
			int OldStartColumnIndex = StartColumnIndex;
			foreach (string LevelText in StandardCounter.AllHeadLines["LevelHeadLines"])
				{
				if ((LevelText == "Gesamt")
					|| (LevelText == "AddProcesses")
					|| (LevelText == "Beschreibung")
					)
					continue;
				CreateVerticalNumberHeader(workSheet, LevelText, LineNumber + 1, StartColumnIndex++);
				}
			workSheet.Column(OldStartColumnIndex + 3).Width = 20;

			workSheet.Column(StartColumnIndex).Width = 1;
			workSheet.Cell(LineNumber, StartColumnIndex++).Style.Fill.SetBackgroundColor(XLColor.White);

			CreateGroupHeader(workSheet, "WMU Punkte", LineNumber, StartColumnIndex, 3);
//			StartColumnIndex = 8;
			foreach (string LevelText in StandardCounter.AllHeadLines["WMUHeadLines"])
				{
				CreateVerticalNumberHeader(workSheet,
					LevelText.Replace("W", "Weiblich").Replace("M", "Männlich").Replace("U", "Unbekannt"),
					LineNumber + 1, StartColumnIndex++);
				}


			workSheet.Column(StartColumnIndex).Width = 1;
			workSheet.Cell(LineNumber, StartColumnIndex++).Style.Fill.SetBackgroundColor(XLColor.White);
			CreateGroupHeader(workSheet, "Projekt Phasen", LineNumber, StartColumnIndex, 5);
			foreach (string LevelText in StandardCounter.AllHeadLines["ProjektPhasenHeadLines"])
				{
				CreateVerticalNumberHeader(workSheet, LevelText,
					LineNumber + 1, StartColumnIndex++);
				}
			//		StandardCounter.AllHeadLines
			IXLCell StartCell = workSheet.Cell(LineNumber, StartColumnIndex);
			int RunningColumn = StartCell.Address.ColumnNumber;
			int RunningRow = StartCell.Address.RowNumber;
			foreach (string writeOutSpecificHeadLine in StandardCounter.GetWriteOutSpecificHeadLines(writeOutType).Keys)
				{
				workSheet.Column(RunningColumn).Width = 1;
				workSheet.Cell(RunningRow, RunningColumn++).Style.Fill.SetBackgroundColor(XLColor.White);
				CreateGroupHeader(workSheet, writeOutSpecificHeadLine, LineNumber, RunningColumn,
					StandardCounter.GetWriteOutSpecificHeadLines(writeOutType)[writeOutSpecificHeadLine].Count);
				foreach (string ColumText in StandardCounter.GetWriteOutSpecificHeadLines(writeOutType)[writeOutSpecificHeadLine])
					{
					CreateVerticalNumberHeader(workSheet, ColumText, RunningRow + 1, RunningColumn++);
					}
				}
			return 0;
			}
Exemplo n.º 4
0
		public int WriteOutNumberOfEntriesPerOrtsTeil(IXLWorksheet workSheet,
			StatistikRootClass.DistributionCountTyp DistTyp)
			{
			IXLRange headerRng = workSheet.Range("B2:F2").Merge();
			headerRng.Style
				.Font.SetBold()
				.Fill.SetBackgroundColor(XLColor.AliceBlue)
				.Alignment.SetHorizontal(XLAlignmentHorizontalValues.Center)
				.Alignment.WrapText = true;
			headerRng.Value = "Vorschläge / Ideen Anzahlen " + DistTyp.GetDescription();

			switch (DistTyp)
				{
					case StatistikRootClass.DistributionCountTyp.AllTogether:
						{
						workSheet.Column("A").Width = 2;
						workSheet.Column("G").Width = 2;
						IXLRange CounterHeaderRange = workSheet.Range("E4:F4").Merge().SetDataType(XLCellValues.Text);
						CounterHeaderRange.Value = "Anzahlen";
						CounterHeaderRange.Style
							.Font.SetBold()
							.Alignment.SetHorizontal(XLAlignmentHorizontalValues.Center)
							.Alignment.WrapText = true;

						int ColumnNumber = 0;
						foreach (string Col in ProjektCounterColumns(DistTyp))
							workSheet.Cell($"{ColumnNameTable[ColumnNumber++ + 1]}5").Value = Col;

						workSheet.Column("D").Width = 40;
						return 7;
						}
						break;
					case StatistikRootClass.DistributionCountTyp.PerAG:
						{
						workSheet.Column("A").Width = 2;
						workSheet.Column("G").Width = 2;
						IXLRange CounterHeaderRange = workSheet.Range("E4:F4").Merge().SetDataType(XLCellValues.Text);
						CounterHeaderRange.Value = "Anzahlen";
						CounterHeaderRange.Style
							.Font.SetBold()
							.Alignment.SetHorizontal(XLAlignmentHorizontalValues.Center)
							.Alignment.WrapText = true;

						int ColumnNumber = 0;
						foreach (string Col in ProjektCounterColumns(DistTyp))
							workSheet.Cell($"{ColumnNameTable[ColumnNumber++ + 1]}5").Value = Col;

						workSheet.Column("D").Width = 40;
						return 7;
						}
						break;
					case StatistikRootClass.DistributionCountTyp.PerOrtsTeil:
						{
						workSheet.Column("A").Width = 2;
						workSheet.Column("G").Width = 2;
						IXLRange CounterHeaderRange = workSheet.Range("E4:F4").Merge().SetDataType(XLCellValues.Text);
						CounterHeaderRange.Value = "Anzahlen";
						CounterHeaderRange.Style
							.Font.SetBold()
							.Alignment.SetHorizontal(XLAlignmentHorizontalValues.Center)
							.Alignment.WrapText = true;

						int ColumnNumber = 0;
						foreach (string Col in ProjektCounterColumns(DistTyp))
							workSheet.Cell($"{ColumnNameTable[ColumnNumber++ + 1]}5").Value = Col;

						workSheet.Column("D").Width = 40;
						return 7;
						}
						break;
					default:
						return 7;
				}
			}
Exemplo n.º 5
0
		private IXLCell CreateXLSXContentLines(ZustaendigAgOrtsTeilOrt ZustaendigAgOrtsTeilOrtInstance,
			IXLWorksheet workSheet, IXLCell StartCell,
			StatistikRootClass.StatistikDataSelectionTypes writeOutType,
			bool StandardContent = true, bool ProcessOrte = true)
			{
			int ActuallRow = StartCell.WorksheetRow().RowNumber() + 1;
			int FirstCellNumber = StartCell.WorksheetColumn().ColumnNumber();
			IXLCell LastCell = null;
			foreach (AGCounter agCounter in ZustaendigAgOrtsTeilOrtInstance.Children)
				{
				if (StandardContent)
					{
					workSheet.Cell(ActuallRow, FirstCellNumber).Value = agCounter.ArbeitsGruppeDaten.NameId;
					workSheet.Cell(ActuallRow, FirstCellNumber + 1).Value
						= agCounter.ArbeitsGruppeDaten.Beschreibung;
					}
				ActuallRow++;
				foreach (OrtsTeilCounter ortsTeilCounter in agCounter.Children)
					{
					if (StandardContent)
						{
						workSheet.Cell(ActuallRow, FirstCellNumber + 1).Value
							= ortsTeilCounter.OrtsTeilDaten.NameId;
						}
					if (ProcessOrte)
						{
						ActuallRow++;
						if (StandardContent)
							{
							foreach (OrtsCounter ortsCounter in ortsTeilCounter.Children)
								{
								workSheet.Cell(ActuallRow, FirstCellNumber + 2).Value
									= ortsCounter.OrtDaten.Bezeichnung;
								LastCell = ShowStandardDataPerEntry(workSheet, ortsCounter.Counter,
									ActuallRow, 6);
								ActuallRow = LastCell.Address.RowNumber + 1;
								}
							if (ProcessOrte)
								{
								IXLRange OrtsTeilLine = workSheet.Range(ActuallRow, FirstCellNumber + 2, ActuallRow, FirstCellNumber + 3).Merge();
								OrtsTeilLine.Style.Font.SetBold();
								OrtsTeilLine.Style.Alignment.SetHorizontal(XLAlignmentHorizontalValues.Right);
								OrtsTeilLine.Value = ortsTeilCounter.OrtsTeilDaten.NameId + " - Summe";
								LastCell = ShowStandardDataPerEntry(workSheet, ortsTeilCounter.Counter,
									ActuallRow, 6);
								ActuallRow = LastCell.Address.RowNumber;
								}
							}
						else
							{
							foreach (OrtsCounter ortsCounter in ortsTeilCounter.Children)
								{
								LastCell = ShowDataPerEntry(workSheet, writeOutType, ortsCounter.Counter,
									ActuallRow, StartCell.Address.ColumnNumber);
								ActuallRow = LastCell.Address.RowNumber + 1;
								}
							if (ProcessOrte)
								{
								LastCell = ShowDataPerEntry(workSheet, writeOutType, ortsTeilCounter.Counter,
									ActuallRow, StartCell.Address.ColumnNumber);
								ActuallRow = LastCell.Address.RowNumber;
								}
							}
						ActuallRow++;
						}
					else
						{
						if (StandardContent)
							{
							LastCell = ShowStandardDataPerEntry(workSheet, ortsTeilCounter.Counter,
								ActuallRow, 6);
							}
						else
							{
							LastCell = ShowDataPerEntry(workSheet, writeOutType, ortsTeilCounter.Counter,
								ActuallRow, StartCell.Address.ColumnNumber);
							}
						ActuallRow = LastCell.Address.RowNumber + 1;
						}
					}
				}
			return LastCell;
			}
Exemplo n.º 6
0
		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);
			}
Exemplo n.º 7
0
		private void WriteOutZustaendigAGOrtsTeilOrt(ZustaendigAgOrtsTeilOrt ZustaendigAgOrtsTeilOrtInstance,
			StatistikRootClass.StatistikDataSelectionTypes writeOutType, IXLWorksheet workSheet, bool ProcessOrte)
			{
			IXLCell StartCell = workSheet.Cell(5, 2);
			IXLCell StartTableCell = workSheet.Cell(4, 2);
			IXLCell EndCell = CreateXLSXContentLines(ZustaendigAgOrtsTeilOrtInstance,
				workSheet, StartCell, writeOutType, true, ProcessOrte);
			CreateXLSXHeadLines(workSheet, StartTableCell, writeOutType);
			IXLCell StartXLSXContent = workSheet.Cell(4, EndCell.Address.ColumnNumber);
			StartCell = workSheet.Cell(5, EndCell.Address.ColumnNumber);
			EndCell = CreateXLSXContentLines(ZustaendigAgOrtsTeilOrtInstance,
				workSheet, StartCell, writeOutType, false, ProcessOrte);
			}
Exemplo n.º 8
0
		private void WriteOutZustaendigAGOrtsTeilOrt(ZustaendigAgOrtsTeilOrt ZustaendigAgOrtsTeilOrtInstance,
			StatistikRootClass.StatistikDataSelectionTypes writeOutType, string OutputFileName)
			{
			XLWorkbook workBook = new XLWorkbook();

			IXLWorksheet workSheetOhneOrte = workBook.Worksheets.Add(writeOutType.ToString());
			WriteOutZustaendigAGOrtsTeilOrt(ZustaendigAgOrtsTeilOrtInstance,
				writeOutType, workSheetOhneOrte, false);
			IXLWorksheet workSheetMitOrte = workBook.Worksheets.Add(writeOutType + "_inclOrte");
			WriteOutZustaendigAGOrtsTeilOrt(ZustaendigAgOrtsTeilOrtInstance,
				writeOutType, workSheetMitOrte, true);

			workBook.SaveAs(new FileStream(OutputFileName, FileMode.Create,
				FileAccess.Write, FileShare.ReadWrite));
			workBook.Dispose();
			}
Exemplo n.º 9
0
		public static Dictionary<String, List<String>> GetWriteOutSpecificHeadLines
			(StatistikRootClass.StatistikDataSelectionTypes writeOutType)
			{
			Dictionary<String, List<String>> Result
				= new Dictionary<string, List<String>>();
			switch (writeOutType)
				{
				case StatistikRootClass.StatistikDataSelectionTypes.All:
					Result[StatistikRootClass.StatistikDataSelectionTypes.OnlySchools.ToString()]
						= GetSchulenCodeNames();
					Result[StatistikRootClass.StatistikDataSelectionTypes.OnlyResponsibilities.ToString()]
						= GetResposibilityNames();
					Result[StatistikRootClass.StatistikDataSelectionTypes.OnlyTypes.ToString()]
						= GetProjektTypeNames();
					break;
				case StatistikRootClass.StatistikDataSelectionTypes.OnlySchools:
					Result[StatistikRootClass.StatistikDataSelectionTypes.OnlySchools.ToString()]
						= GetSchulenCodeNames();
					break;
				case StatistikRootClass.StatistikDataSelectionTypes.OnlyResponsibilities:
					Result[StatistikRootClass.StatistikDataSelectionTypes.OnlyResponsibilities.ToString()]
						= GetResposibilityNames();
					break;
				case StatistikRootClass.StatistikDataSelectionTypes.OnlyTypes:
					Result[StatistikRootClass.StatistikDataSelectionTypes.OnlyTypes.ToString()]
						= GetProjektTypeNames();
					break;
				}
			return Result;

			}
Exemplo n.º 10
0
		public String WriteCSVData(StatistikRootClass.StatistikDataSelectionTypes writeOutType,
			String Level0, String Level1 = "", String Level2 = "",
			String Level3 = "", String Level4 = "", String Level5 = "", String Level6 = "")
			{
			StatistikDataSelection = writeOutType;
			List<String> ColumnContentElements = new List<string>();
			ColumnContentElements.Add("\"" + Level0 + "\"");
			ColumnContentElements.Add("\"" + Level1 + "\"");
			ColumnContentElements.Add("\"" + Level2 + "\"");
			ColumnContentElements.Add("\"" + Level3 + "\"");
			ColumnContentElements.Add("\"" + Level4 + "\"");
			ColumnContentElements.Add("\"" + Level5 + "\"");
			ColumnContentElements.Add("\"" + Level6 + "\"");
			ColumnContentElements.Add(NumberOfChildren.ToString());
			ColumnContentElements.Add(NumberOfAddProcesses.ToString());
			ColumnContentElements.Add(NumberOfKlassen.ToString());
			ColumnContentElements.Add(SummeW.ToString());
			ColumnContentElements.Add(SummeM.ToString());
			ColumnContentElements.Add(SummeU.ToString());
			ColumnContentElements.Add(NumberOfIdeen.ToString());
			ColumnContentElements.Add(NumberOfVorschlaege.ToString());
			ColumnContentElements.Add(NumberOfPlanungen.ToString());
			ColumnContentElements.Add(NumberOfProjekte.ToString());
			ColumnContentElements.Add(NumberOfRealisierungen.ToString());

			if ((writeOutType == StatistikRootClass.StatistikDataSelectionTypes.All)
				|| (writeOutType == StatistikRootClass.StatistikDataSelectionTypes.OnlyResponsibilities))
				foreach (Zustaendigkeit Responsibility in Data.DbServer3.WordUp.Zustaendigkeiten.OrderBy(ord => ord.NameId))
					{
					if (!Zustaendigkeiten.ContainsKey(Responsibility))
						Zustaendigkeiten[Responsibility] = 0;
					ColumnContentElements.Add(Zustaendigkeiten[Responsibility].ToString());
					}

			if ((writeOutType == StatistikRootClass.StatistikDataSelectionTypes.All)
				|| (writeOutType == StatistikRootClass.StatistikDataSelectionTypes.OnlySchools))
				foreach (Organisation Schule in Data.DbServer3.WordUp.Organisationen.AktuelleSchulen)
					{
					if (!InvolvedSchulen.ContainsKey(Schule))
						InvolvedSchulen[Schule] = 0;
					ColumnContentElements.Add(InvolvedSchulen[Schule].ToString());
					}

			if ((writeOutType == StatistikRootClass.StatistikDataSelectionTypes.All)
				|| (writeOutType == StatistikRootClass.StatistikDataSelectionTypes.OnlyTypes))
				foreach (Typ ProjektType in Data.DbServer3.WordUp.Typen.AllTypForProjekte.OrderBy(ord => ord.TypNameId))
					{
					if (!ProjektTypen.ContainsKey(ProjektType))
						ProjektTypen[ProjektType] = 0;
					ColumnContentElements.Add(ProjektTypen[ProjektType].ToString());
					}

			return String.Join(";", ColumnContentElements);
			}
Exemplo n.º 11
0
		public String WriteCSVData(StatistikRootClass.StatistikDataSelectionTypes writeOutType)
			{
			StatistikDataSelection = writeOutType;
			List<String> standards = new List<string>();
			standards.AddRange(GetLevelHeadLineStrings());
			standards.AddRange(GetWMUHeadLineStrings());
			standards.AddRange(GetProjektPhasenHeadLineStrings());
			switch (StatistikDataSelection)
				{
				case StatistikRootClass.StatistikDataSelectionTypes.All:
					standards.AddRange(GetResposibilityNames());
					standards.AddRange(GetSchulenCodeNames());
					standards.AddRange(GetProjektTypeNames());
					break;
				case StatistikRootClass.StatistikDataSelectionTypes.OnlySchools:
					standards.AddRange(GetSchulenCodeNames());
					break;
				case StatistikRootClass.StatistikDataSelectionTypes.OnlyResponsibilities:
					standards.AddRange(GetResposibilityNames());
					break;
				case StatistikRootClass.StatistikDataSelectionTypes.OnlyTypes:
					standards.AddRange(GetProjektTypeNames());
					break;
				}
			return String.Join(";", standards);
			}