public override bool LoadTableData (TableDescription TableDataContent)
{
TableDataContent.NameID = "Personen " + NameID;
TableDataContent.HeadLine = String.Format ("Wahlberechtigte mit den Familiennamen von {0} ", NameID);
int RunningRowIndex = 0;
TableDataContent.ColumnHeader.AddCell(new TableCell() { Text = "Block" });
TableDataContent.ColumnHeader.AddCell(new TableCell() { Text = "Stiege" });
TableDataContent.ColumnHeader.AddCell(new TableCell() { Text = "Stock/Türe" });
TableDataContent.ColumnHeader.AddCell(new TableCell() { Text = "Name" });
TableDataContent.ColumnHeader.AddCell(new TableCell() { Text = "Vorname" });
TableDataContent.ColumnHeader.AddCell(new TableCell() { Text = "Anz.Chips" });
foreach (WahlberechtigtInStiege RowEntry in ItemsSource)
{
TableRow NewRow = new TableRow();
NewRow.FirstCellIsRowHeader = true;
NewRow.AddCell(new TableCell() { Text = RowEntry.Block });
NewRow.AddCell(new TableCell() { Text = RowEntry.Stiege });
NewRow.AddCell(new TableCell() { Text = RowEntry.StockTuere });
NewRow.AddCell(new TableCell() { Text = RowEntry.Name });
NewRow.AddCell(new TableCell() { Text = RowEntry.Vorname });
NewRow.AddCell(new TableCell() { Text = Convert.ToString(RowEntry.NumberOfFamilyMember) });
TableDataContent.Rows.AddRow (NewRow);
}
return true;
}
public void AddTableBinding(string schema, string catalog, string logicalName, string physicalName, Table denormalizedSuperTable)
{
string key = BuildTableNameKey(schema, catalog, physicalName);
TableDescription tableDescription = new TableDescription(logicalName, denormalizedSuperTable);
TableDescription oldDescriptor;
tableNameBinding.TryGetValue(key, out oldDescriptor);
tableNameBinding[key] = tableDescription;
if (oldDescriptor != null && !oldDescriptor.logicalName.Equals(logicalName))
{
//TODO possibly relax that
throw new MappingException("Same physical table name reference several logical table names: " + physicalName
+ " => " + "'" + oldDescriptor.logicalName + "' and '" + logicalName + "'");
}
}
/// <summary>
/// Creates a <see cref="EmptyTableDataLoader" /> instance.
/// </summary>
/// <param name="table">
/// The metadata of the table.
/// </param>
/// <returns>
/// The <see cref="EmptyTableDataLoader" /> instance for the table.
/// </returns>
public ITableDataLoader CreateTableDataLoader(TableDescription table)
{
return new EmptyTableDataLoader();
}
public override bool LoadTableData(TableDescription TableDataContent)
{
TableDataContent.NameID = "Wahlberechtigte " + NameID;
TableDataContent.HeadLine = String.Format("Wahlberechtigte {0} ", NameID);
TableDataContent.ColumnHeader.AddCell(new TableCell() { Text = String.Empty });
foreach (String KurzWahlBezeichnung in Years)
{
TableDataContent.ColumnHeader.AddCell(new TableCell() { Text = KurzWahlBezeichnung });
}
foreach (WahlberechtigtSummen RowEntry in ItemsSource)
{
TableRow NewRow = new TableRow();
NewRow.FirstCellIsRowHeader = true;
NewRow.AddCell(new TableCell() { Text = Convert.ToString (RowEntry.Block) });
foreach (WahlberechtigtSummen WahlEntry in RowEntry.WahlberechtigtJeVergleichsWahl)
{
NewRow.AddCell(new TableCell() { Text = Convert.ToString(WahlEntry.NumberOfChips) });
}
TableDataContent.Rows.AddRow(NewRow);
}
return true;
}
public override bool LoadTableData(TableDescription TableDataContent)
{
TableDataContent.NameID = "Abgegeben je Stiege" + NameID;
TableDataContent.HeadLine = String.Format("Abgegebene Stimmen aus der Stiege {0} ", NameID);
TableDataContent.ColumnHeader.AddCell(new TableCell() { Text = "Block" });
foreach (String WahlKurzName in Years)
{
TableDataContent.ColumnHeader.AddCell(new TableCell() { Text = WahlKurzName });
}
foreach (AbgegebenStiegenSummen RowEntry in ItemsSource)
{
TableRow NewRow = new TableRow();
NewRow.FirstCellIsRowHeader = true;
NewRow.AddCell(new TableCell() { Text = RowEntry.Block + " " + RowEntry.StiegenNummer});
foreach (AbgegebenStiegenSummen SummenPerWahl in RowEntry.AbgegebenJeVergleichsWahl)
{
NewRow.AddCell(new TableCell() { Text = Convert.ToString (SummenPerWahl.Abgegeben)});
}
TableDataContent.Rows.AddRow(NewRow);
}
return true;
}
public override bool LoadTableData(TableDescription TableDataContent)
{
TableDataContent.NameID = "Wahlergebnis " + NameID;
TableDataContent.HeadLine = String.Format("Stimmen pro Kandidat und Kommission {0} ", NameID);
TableDataContent.ColumnHeader.AddCell(new TableCell() { Text = "Kommission" });
foreach (String CounterParts in CounterPartsHeader)
{
TableDataContent.ColumnHeader.AddCell(new TableCell() { Text = CounterParts, Rotate = true });
}
foreach (String WahlKurzName in Years)
{
TableDataContent.ColumnHeader.AddCell(new TableCell() { Text = WahlKurzName });
}
foreach (String KandidatenName in KandidatenNamensListe)
{
TableDataContent.ColumnHeader.AddCell(new TableCell() { Text = KandidatenName,Rotate=true });
}
foreach (ErgebnisSummen RowEntry in ItemsSource)
{
MBRWahl.TableRow NewKommissionsRow = new MBRWahl.TableRow();
NewKommissionsRow.AddCell(new TableCell() { Text = Convert.ToString(RowEntry.ErgebnissName) });
NewKommissionsRow.AddCell(new TableCell() { Text = Convert.ToString(RowEntry.Abgegeben) });
NewKommissionsRow.AddCell(new TableCell() { Text = Convert.ToString(RowEntry.Gueltig) });
NewKommissionsRow.AddCell(new TableCell() { Text = Convert.ToString(RowEntry.Ungueltig) });
foreach (ErgebnisSummen AbgegebenPerWahl in RowEntry.AbgegebenJeVergleichsWahl)
{
TableDescription JeStiegeTableData = null;
if (AbgegebenPerWahl.AbgegebenJeStiege.Count > 0)
{
JeStiegeTableData = new TableDescription()
{
NameID = "AbgJeStg",
HeadLine = "Stimmen je Stiege"
};
JeStiegeTableData.ColumnHeader.AddCell(new TableCell() { Text = "Anzahl" });
JeStiegeTableData.ColumnHeader.AddCell(new TableCell() { Text = "Von" });
foreach (AbgegebenStiegenSummen StgSum in AbgegebenPerWahl.AbgegebenJeStiege)
{
MBRWahl.TableRow NewPopupRow = new MBRWahl.TableRow();
NewPopupRow.AddCell(new TableCell() { Text = Convert.ToString(StgSum.Abgegeben) });
NewPopupRow.AddCell(new TableCell() { Text = Convert.ToString(StgSum.Block) });
NewPopupRow.AddCell(new TableCell() { Text = Convert.ToString(StgSum.StiegenNummer) });
JeStiegeTableData.Rows.AddRow(NewPopupRow);
}
}
NewKommissionsRow.AddCell(new TableCell()
{
Text = Convert.ToString(AbgegebenPerWahl.Abgegeben),
ThirdLevelAdditionalInfos = JeStiegeTableData
});
}
foreach (KandidatenErgebnissSummen KandErg in RowEntry.ErgebnissJeKandidat)
{
NewKommissionsRow.AddCell(new TableCell() { Text = Convert.ToString(KandErg.Stimmen) });
}
TableDataContent.Rows.AddRow(NewKommissionsRow);
}
return true;
}
public void WriteBookWithoutAttributesToCells()
{
WorkBook wb = WorkBook.CreateNew();
WorkSheet sheet = wb.Sheets["sheet1"];
sheet.Name = "FirstSheet";
IEnumerable<BookWithoutAttributes> books = FillBookWithoutAttributesData(10240);
TableDescription tableDesp = new TableDescription("Books");
tableDesp.AllColumns.Add(new TableColumnDescription(new DataColumn("书名", typeof(string))) { PropertyName = "Name" });
tableDesp.AllColumns.Add(new TableColumnDescription(new DataColumn("价格", typeof(double))) { PropertyName = "Price" });
tableDesp.AllColumns.Add(new TableColumnDescription(new DataColumn("发行日期", typeof(DateTime))) { PropertyName = "IssueDate" });
sheet.LoadFromCollection(books, tableDesp, (cell, dcp) =>
{
cell.Value = dcp.PropertyValue;
if (dcp.ColumnName == "发行日期")
cell.Value = string.Format("{0:yyyy-MM-dd HH:mm}", dcp.PropertyValue);
});
wb.Save("WriteBookWithoutAttributesToCells.xlsx");
}
public virtual bool LoadTableData (TableDescription TableData)
{
return false;
}
public override bool LoadTableData(TableDescription TableDataContent)
{
TableDataContent.NameID = "Abgegeben je Kommission" + NameID;
TableDataContent.HeadLine = String.Format("Abgegebene Stimmen bei der Kommission {0} ", NameID);
TableDataContent.ColumnHeader.AddCell(new TableCell() { Text = "Komm." });
foreach (String WahlKurzName in Years)
{
TableDataContent.ColumnHeader.AddCell(new TableCell() { Text = WahlKurzName });
}
foreach (AbgegebenKommissionsSummen RowEntry in ItemsSource)
{
MBRWahl.TableRow NewRow = new TableRow();
NewRow.FirstCellIsRowHeader = true;
NewRow.AddCell (new TableCell (){Text = RowEntry.AktuelleKommissionsID});
foreach (AbgegebenKommissionsSummen SummenPerWahl in RowEntry.AbgegebenJeVergleichsWahl)
{
MBRWahl.TableDescription PopupTable = null;
if (SummenPerWahl.AbgegebenJeStiege.Count > 0) // Add third dimension popup informations
{
PopupTable = new TableDescription ();
PopupTable.HeadLine = "Woher stammen die Stimmen";
PopupTable.NameID = "VotesComeFrom";
foreach (AbgegebenKommissionsSummen ComesFrom in SummenPerWahl.AbgegebenJeStiege)
{
MBRWahl.TableRow NewPopupRow = new TableRow ();
NewPopupRow.AddCell (new TableCell () {Text = Convert.ToString (ComesFrom.Abgegeben)});
NewPopupRow.AddCell(new TableCell() { Text = ComesFrom.BlockName + " " + ComesFrom.StiegenNummer });
PopupTable.Rows.AddRow(NewPopupRow);
}
}
NewRow.AddCell(new TableCell() { Text = Convert.ToString(SummenPerWahl.Abgegeben),
ThirdLevelAdditionalInfos = PopupTable});
}
TableDataContent.Rows.AddRow(NewRow);
}
return true;
}
