| public void ConfigureExport() |
| { |
| rdgSelektionResult.ExportSettings.ExportOnlyData = true; |
| rdgSelektionResult.ExportSettings.IgnorePaging = true; |
| rdgSelektionResult.ExportSettings.OpenInNewWindow = true; |
| rdgSelektionResult.ExportSettings.FileName = "Selektion_" + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second + "_" + base.Page.User.Identity.Name; |
| } |
| |
| void HeaderControl_OnExportClick() |
| { |
| if (!string.IsNullOrEmpty(base.Request_CurrentRowKey)) |
| { |
| |
| rdgSelektionResult.ExportSettings.Excel.Format = Telerik.Web.UI.GridExcelExportFormat.Html; |
| ConfigureExport(); |
| |
| base.Page.ApplyView(rdgSelektionResult, base.Page.CurrentListe.DefaultView, false, false, false,true); |
| rdgSelektionResult.MasterTableView.ExportToExcel(); |
| |
| } |
| } |
| |
| protected void rdgSelektionResult_ColumnCreated(object sender, GridColumnCreatedEventArgs e) |
| { |
| if (e.Column is GridBoundColumn) |
| { |
| GridBoundColumn column = (GridBoundColumn)e.Column; |
| |
| if (column != null) |
| { |
| if (column.DataType == typeof(Guid)) |
| column.Display = false; |
| |
| |
| if (column.UniqueName == "Land" || column.UniqueName == "ColumnLand") |
| { |
| column.HeaderText = Properties.Resources.Alle_Land; |
| } |
| else if (column.UniqueName == "Sender" || column.UniqueName == "ColumnSender") |
| { |
| column.HeaderText = Properties.Resources.Alle_Sender; |
| } |
| else if (column.UniqueName == "Sendung" || column.UniqueName == "ColumnSendung") |
| { |
| column.HeaderText = Properties.Resources.Alle_Sendung; |
| } |
| else if (column.UniqueName == "Datum" || column.UniqueName == "ColumnDatum") |
| { |
| column.HeaderText = Properties.Resources.Alle_Datum; |
| column.DataFormatString = "{0:dd.MM.yy}"; |
| } |
| else if (column.UniqueName == "dtmStart" || column.UniqueName == "ColumndtmStart") |
| { |
| column.HeaderText = "Zeit"; |
| column.DataFormatString = "{0:HH:mm}"; |
| } |
| else if (column.UniqueName == "SendungsArt" || column.UniqueName == "ColumnSendungsart") |
| { |
| column.HeaderText = Properties.Resources.Alle_Sendungsart; |
| } |
| //else if (column.UniqueName == "RW Sendung (Zielgruppe Standard)") |
| //{ |
| // column.HeaderText = ""; |
| // column.DataFormatString = ""; |
| //} |
| //else if (column.UniqueName == "MA Sendung (Zielgruppe: Standard)") |
| //{ |
| // column.HeaderText = ""; |
| // column.DataFormatString = ""; |
| //} |
| //else if (column.UniqueName == "RW (Beitrag) (Zielgruppe Standard)") |
| //{ |
| // column.HeaderText = ""; |
| // column.DataFormatString = ""; |
| //} |
| //else if (column.UniqueName == "MA Beitrag (Zielgruppe: Standard)") |
| //{ |
| // column.HeaderText = ""; |
| // column.DataFormatString = ""; |
| //} |
| //else if (column.UniqueName == "Bemerkung") |
| //{ |
| // column.HeaderText = ""; |
| // column.DataFormatString = ""; |
| //} |
| //else if (column.UniqueName == "Wettbewerb") |
| //{ |
| // column.HeaderText = ""; |
| // column.DataFormatString = ""; |
| //} |
| //else if (column.UniqueName == "WettbewerbOffizname") |
| //{ |
| // column.HeaderText = ""; |
| // column.DataFormatString = ""; |
| //} |
| //else if (column.UniqueName == "WettbewerbOrt") |
| //{ |
| // column.HeaderText = ""; |
| // column.DataFormatString = ""; |
| //} |
| else if (column.UniqueName == "Wettbewerbsbeginn" || column.UniqueName == "ColumnWettbewerbsbeginn") |
| { |
| column.DataFormatString = "{0:dd.MM.yy}"; |
| } |
| else if (column.UniqueName == "Wettbewerbsende" || column.UniqueName == "ColumnWettbewerbsende") |
| { |
| column.DataFormatString = "{0:dd.MM.yy}"; |
| } |
| //else if (column.UniqueName == "Anlass") |
| //{ |
| // column.HeaderText = ""; |
| // column.DataFormatString = ""; |
| //} |
| //else if (column.UniqueName == "Ereignis") |
| //{ |
| // column.HeaderText = ""; |
| // column.DataFormatString = ""; |
| //} |
| //else if (column.UniqueName == "Sportart") |
| //{ |
| // column.HeaderText = ""; |
| // column.DataFormatString = ""; |
| //} |
| //else if (column.UniqueName == "SportartAnhang") |
| //{ |
| // column.HeaderText = ""; |
| // column.DataFormatString = ""; |
| //} |
| //else if (column.UniqueName == "Disziplin") |
| //{ |
| // column.HeaderText = ""; |
| // column.DataFormatString = ""; |
| //} |
| else if (column.UniqueName == "Ereignisbeginn" || column.UniqueName == "ColumnEreignisbeginn") |
| { |
| //column.HeaderText = ""; |
| column.DataFormatString = "{0:dd.MM.yy}"; |
| } |
| else if (column.UniqueName == "Ereignisende" || column.UniqueName == "ColumnEreignisende") |
| { |
| //column.HeaderText = ""; |
| column.DataFormatString = "{0:dd.MM.yy}"; |
| } |
| //else if (column.UniqueName == "EreignisGeschlecht") |
| //{ |
| // column.HeaderText = ""; |
| // column.DataFormatString = ""; |
| //} |
| //else if (column.UniqueName == "EreignisOrt") |
| //{ |
| // column.HeaderText = ""; |
| // column.DataFormatString = ""; |
| //} |
| //else if (column.UniqueName == "Paarung") |
| //{ |
| // column.HeaderText = ""; |
| // column.DataFormatString = ""; |
| //} |
| //else if (column.UniqueName == "Team 1") |
| //{ |
| // column.HeaderText = ""; |
| // column.DataFormatString = ""; |
| //} |
| //else if (column.UniqueName == "Team 2") |
| //{ |
| // column.HeaderText = ""; |
| // column.DataFormatString = ""; |
| //} |
| else if (column.UniqueName == "S-Dauer" || column.UniqueName == "ColumnS-Dauer") |
| { |
| //column.HeaderText = ""; |
| column.DataFormatString = "{0:HH:mm:ss}"; |
| } |
| else if (column.UniqueName == "W-Dauer" || column.UniqueName == "ColumnW-Dauer") |
| { |
| //column.HeaderText = ""; |
| column.DataFormatString = "{0:HH:mm:ss}"; |
| } |
| //else if (column.UniqueName == "Beitragsart") |
| //{ |
| // column.HeaderText = ""; |
| // column.DataFormatString = ""; |
| //} |
| else if (column.UniqueName == "Beitragsbeginn" || column.UniqueName == "ColumnBeitragsbeginn") |
| { |
| // column.HeaderText = ""; |
| column.DataFormatString = "{0:HH:mm}"; |
| } |
| else if (column.UniqueName == "BeitragsEnde" || column.UniqueName == "ColumnBeitragsEnde") |
| { |
| //column.HeaderText = ""; |
| column.DataFormatString = "{0:HH:mm}"; |
| } |
| //else if (column.UniqueName == "Beitragart") |
| //{ |
| // column.HeaderText = ""; |
| // column.DataFormatString = ""; |
| //} |
| //else if (column.UniqueName == "Beitrag.Bemerkung") |
| //{ |
| // column.HeaderText = ""; |
| // column.DataFormatString = ""; |
| //} |
| //else if (column.UniqueName == "Live") |
| //{ |
| // column.HeaderText = ""; |
| // column.DataFormatString = ""; |
| //} |
| //else if (column.UniqueName == "E-Index (SD)") |
| //{ |
| // column.HeaderText = ""; |
| // column.DataFormatString = ""; |
| //} |
| //else if (column.UniqueName == "Sponsor") |
| //{ |
| // column.HeaderText = ""; |
| // column.DataFormatString = ""; |
| //} |
| //else if (column.UniqueName == "Werbebotschaft") |
| //{ |
| // column.HeaderText = ""; |
| // column.DataFormatString = ""; |
| //} |
| //else if (column.UniqueName == "Werbemittel") |
| //{ |
| // column.HeaderText = ""; |
| // column.DataFormatString = ""; |
| //} |
| //else if (column.UniqueName == "UnterWerbemittel") |
| //{ |
| // column.HeaderText = ""; |
| // column.DataFormatString = ""; |
| //} |
| else if (column.UniqueName == "Klar" || column.UniqueName == "ColumnKlar") |
| { |
| //column.HeaderText = ""; |
| column.DataFormatString = "{0:HH:mm:ss}"; |
| } |
| //else if (column.UniqueName == "seq_klar") |
| //{ |
| // column.HeaderText = ""; |
| // column.DataFormatString = ""; |
| //} |
| else if (column.UniqueName == "Assoz" || column.UniqueName == "ColumnAssoz") |
| { |
| //column.HeaderText = ""; |
| column.DataFormatString = "{0:HH:mm:ss}"; |
| } |
| else if (column.UniqueName == "Werbedauer" || column.UniqueName == "ColumnWerbedauer") |
| { |
| //column.HeaderText = ""; |
| column.DataFormatString = "{0:HH:mm:ss}"; |
| } |
| //else if (column.UniqueName == "seq_assoz") |
| //{ |
| // column.HeaderText = ""; |
| // column.DataFormatString = ""; |
| //} |
| //else if (column.UniqueName == "seq") |
| //{ |
| // column.HeaderText = ""; |
| // column.DataFormatString = ""; |
| //} |
| //else if (column.UniqueName == "Werbewert") |
| //{ |
| // column.HeaderText = ""; |
| // column.DataFormatString = ""; |
| //} |
| //else if (column.UniqueName == "Werbepreis") |
| //{ |
| // column.HeaderText = ""; |
| // column.DataFormatString = ""; |
| //} |
| //else if (column.UniqueName == "S-Index (SD)") |
| //{ |
| // column.HeaderText = ""; |
| // column.DataFormatString = ""; |
| //} |
| //else if (column.UniqueName == "TKP") |
| //{ |
| // column.HeaderText = ""; |
| // column.DataFormatString = ""; |
| //} |
| |
| |
| } |
| |
| |
| } |
| } |
| |
| |
| |