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