/// <summary> /// Grid Element Exporting /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void radGridSnapshot_ElementExporting(object sender, GridViewElementExportingEventArgs e) { RadGridView_ElementExport.ElementExporting(e, isGroupFootersVisible: false, cellValueConverter: () => { object result = e.Value; if (e.Value == null && e.Element == ExportElement.Cell) { GridViewDataColumn column = (e.Context as GridViewDataColumn); if (column != null) { if (column.DisplayIndex == 0) { MarketSnapshotPerformanceData data = column.DataControl.Items[++itemIndex] as MarketSnapshotPerformanceData; if (data != null) { result = string.Format("{0}{1}{2}", data.MarketSnapshotPreferenceInfo.EntityNodeValueName , String.IsNullOrEmpty(data.MarketSnapshotPreferenceInfo.EntityNodeValueName) ? "" : " " , data.MarketSnapshotPreferenceInfo.EntityName); } } } } return(result); }); }
private void ElementExporting(object sender, GridViewElementExportingEventArgs e) { var visParameters = e.VisualParameters as GridViewExcelMLVisualExportParameters; if (e.Element == ExportElement.Row) { if (!firstRow.HasValue) { firstRow = true; } else if (firstRow.Value) { firstRow = false; } firstCell = true; } else if (e.Element == ExportElement.Cell) { if ((firstRow.HasValue && firstRow.Value) || (firstCell)) { visParameters.StyleId = "Header"; firstCell = false; } else { visParameters.StyleId = "Cell"; } } }
/// <summary> /// handles element exporting for grid /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgRelativePerformance_ElementExporting(object sender, GridViewElementExportingEventArgs e) { RadGridView_ElementExport.ElementExporting(e, () => { if (e.Value is RelativePerformanceData) { RelativePerformanceData value = e.Value as RelativePerformanceData; if (value != null) { decimal totalValue = value.AggregateCountryAlpha.HasValue? value.AggregateCountryAlpha.Value:0; countryTotal = GetValueInBasisPoints(totalValue.ToString()); } return(value); } if (e.Value is RelativePerformanceCountrySpecificData) { RelativePerformanceCountrySpecificData value = e.Value as RelativePerformanceCountrySpecificData; string result = String.Empty; if (value.Alpha != null) { decimal totalValue = 0M; result = Decimal.TryParse(value.Alpha.ToString(), out totalValue) ? GetValueInBasisPoints(totalValue.ToString()) : String.Empty; } return(result); } if (e.Value == null) { GridViewDataColumn column = (e.Context as GridViewDataColumn); if (column != null) { if ((!String.IsNullOrEmpty(column.Header.ToString()) && String.Equals(column.Header.ToString(), "Total", StringComparison.CurrentCultureIgnoreCase))) { return(countryTotal); } } } if (e.Element == ExportElement.FooterCell) { decimal totalValue = 0M; string value = Decimal.TryParse(e.Value.ToString(), out totalValue) ? GetValueInBasisPoints(totalValue.ToString()) : "Total"; return(value); } return(e.Value); }); }
private void ElementExporting(object sender, GridViewElementExportingEventArgs e) { if (e.Element == ExportElement.HeaderRow) { var htmlVisualExportParameters = e.VisualParameters as GridViewHtmlVisualExportParameters; if (htmlVisualExportParameters != null) { htmlVisualExportParameters.FontWeight = FontWeights.Bold; } } }
static void gvwToExport_ElementExporting(object sender, GridViewElementExportingEventArgs e) { if (e.Value != null && e.Value.GetType() == typeof(string)) { e.Value = (e.Value as string) .Replace("&", "&") .Replace("<", "<") .Replace(">", ">") .Replace("\"", """) .Replace("\'", "'"); } }
/// <summary> /// dgFinancialReportExt ElementExporting EventHandler /// </summary> /// <param name="sender"></param> /// <param name="e">GridViewElementExportingEventArgs</param> private void dgFinancialReportExt_ElementExporting(object sender, GridViewElementExportingEventArgs e) { RadGridView_ElementExport.ElementExporting(e, hideColumnIndex: new List <int> { 1, 14 }, headerCellValueConverter: () => { if (e.Value == null) { return(null); } return(e.Value.ToString().Replace("A", "E")); }); }
private void GridViewReport_ElementExporting(object sender, GridViewElementExportingEventArgs e) { if (e.Element == ExportElement.Cell) { if (e.Value is HudPlayerType hudPlayerType) { e.Value = hudPlayerType.Name; } else if (e.Value is EnumMRatio mRatio) { var converter = new MRatioToTextConverter(); e.Value = converter.Convert(e.Value, typeof(string), null, null); } } }
private void ElementExporting(object sender, GridViewElementExportingEventArgs e) { var visParameters = e.VisualParameters as GridViewExcelMLVisualExportParameters; if (e.Element == ExportElement.Row) { visParameters.RowHeight = this.RowHeight; } if (e.Element == ExportElement.Cell && (e.Context as GridViewBoundColumnBase).UniqueName == "Name") { visParameters.StyleId = "Name"; } if (e.Element == ExportElement.Cell && (e.Context as GridViewBoundColumnBase).UniqueName == "UnitPrice") { visParameters.StyleId = "UnitPrice"; } }
private void ElementExporting(object sender, GridViewElementExportingEventArgs e) { e.Width *= 1.4; if (e.Element == ExportElement.HeaderRow || e.Element == ExportElement.FooterRow || e.Element == ExportElement.GroupFooterRow) { e.Background = HeaderBackground; e.Foreground = HeaderForeground; e.FontSize = 16; e.FontWeight = FontWeights.Bold; } else if (e.Element == ExportElement.Row) { e.Background = RowBackground; e.Foreground = RowForeground; } else if (e.Element == ExportElement.Cell && e.Value != null && e.Value.Equals("Chocolade")) { e.FontFamily = new FontFamily("Verdana"); e.Background = Colors.LightGray; e.Foreground = Colors.Blue; } else if (e.Element == ExportElement.GroupHeaderRow) { e.FontFamily = new FontFamily("Verdana"); e.Background = Colors.LightGray; e.Height = 24; } else if (e.Element == ExportElement.GroupHeaderCell && e.Value != null && e.Value.Equals("Chocolade")) { e.Value = "MyNewValue"; } else if (e.Element == ExportElement.GroupFooterCell) { GridViewDataColumn column = e.Context as GridViewDataColumn; QueryableCollectionViewGroup qcvGroup = e.Value as QueryableCollectionViewGroup; if (column != null && qcvGroup != null && column.AggregateFunctions.Count > 0) { e.Value = GetAggregates(qcvGroup, column); } } }
/// <summary> /// Element Exporting Event /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgPortfolioDetails_ElementExporting(object sender, GridViewElementExportingEventArgs e) { if (e.Element == ExportElement.Row) { var value = e.Value as PortfolioDetailsData; if (value.Children != null) { foreach (var child in value.Children) { e.Value = child; RadGridView_ElementExport.ElementExporting(e, isGroupFootersVisible: false); } } else { RadGridView_ElementExport.ElementExporting(e, isGroupFootersVisible: false); } } else { RadGridView_ElementExport.ElementExporting(e, isGroupFootersVisible: false); //The following section is used for reformatting in exported file RadGridView_ElementExport.ElementExporting(e, isGroupFootersVisible: false, cellValueConverter: () => { object result = e.Value; if (e.Value != null && e.Element == ExportElement.Cell && e.Value.ToString() != "") { GridViewDataColumn column = (e.Context as GridViewDataColumn); if (column != null && (column.Header.ToString() == "Target %" || column.Header.ToString() == "Portfolio %" || column.Header.ToString() == "Benchmark %" || column.Header.ToString() == "Active Position %" || column.Header.ToString() == "Upside %")) { decimal?resultInt = 0; resultInt = Convert.ToDecimal(result); //resultInt = ? 0 : Convert.ToDecimal(result); resultInt = resultInt / 100; result = resultInt.ToString(); } } return(result); }); } }
void ElementExporting(object sender, GridViewElementExportingEventArgs e) { var htmlVisualExportParameters = e.VisualParameters as GridViewHtmlVisualExportParameters; if (htmlVisualExportParameters != null) { if (e.Element == ExportElement.HeaderRow || e.Element == ExportElement.FooterRow || e.Element == ExportElement.GroupFooterRow) { htmlVisualExportParameters.Background = HeaderBackground; htmlVisualExportParameters.Foreground = HeaderForeground; htmlVisualExportParameters.FontSize = 20; htmlVisualExportParameters.FontWeight = FontWeights.Bold; } else if (e.Element == ExportElement.Row) { htmlVisualExportParameters.Background = RowBackground; htmlVisualExportParameters.Foreground = RowForeground; } else if (e.Element == ExportElement.Cell && e.Value != null && e.Value.Equals("Chocolade")) { htmlVisualExportParameters.FontFamily = new FontFamily("Verdana"); htmlVisualExportParameters.Background = Colors.LightGray; htmlVisualExportParameters.Foreground = Colors.Blue; } else if (e.Element == ExportElement.GroupHeaderRow) { htmlVisualExportParameters.FontFamily = new FontFamily("Verdana"); htmlVisualExportParameters.Background = Colors.LightGray; htmlVisualExportParameters.Height = 30; } else if (e.Element == ExportElement.GroupHeaderCell && e.Value != null && e.Value.Equals("Chocolade")) { e.Value = "MyNewValue"; } } }
/// <summary> /// Event for Grid Export /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ElementExportingEvent(object sender, GridViewElementExportingEventArgs e) { RadGridView_ElementExport.ElementExporting(e); }
/// <summary> /// dgICPSummaryReport ElementExporting EventHandler /// </summary> /// <param name="sender"></param> /// <param name="e">GridViewElementExportingEventArgs</param> private void dgICPSummaryReport_ElementExporting(object sender, GridViewElementExportingEventArgs e) { RadGridView_ElementExport.ElementExporting(e); }
/// <summary> /// 设置导出样式 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ElementExporting(object sender, GridViewElementExportingEventArgs e) { // ReSharper disable once CSharpWarnings::CS0618 e.Width = 120; if (e.Element == ExportElement.Cell && e.Value != null) { var temp = (sender as RadGridView); if (temp != null) { if (_i%3 == 0 && _i >= 6 && temp.Name.Equals("FleetTrendAll", StringComparison.OrdinalIgnoreCase)) { e.Value = DateTime.Parse(e.Value.ToString()).AddMonths(1).AddDays(-1).ToString("yyyy/M/d"); } else if (_i%4 == 3 && _i >= 7 && temp.Name.Equals("SubFleetTrendAll", StringComparison.OrdinalIgnoreCase)) { e.Value = DateTime.Parse(e.Value.ToString()).AddMonths(1).AddDays(-1).ToString("yyyy/M/d"); } } } _i++; }
/// <summary> /// 设置导出样式 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void ElementExporting(object sender, GridViewElementExportingEventArgs e) { e.Width = 120; if (e.Element == ExportElement.Cell && e.Value != null) { if (i % 5 == 3 && i >= 8 && (sender as RadGridView).Name == "AircraftTrent") { e.Value = DateTime.Parse(e.Value.ToString()).AddMonths(1).AddDays(-1).ToString("yyyy/M/d"); } } i++; }
/// <summary> ///Adding styles to export /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgTopTenBenchmarkSecurities_ElementExporting(object sender, GridViewElementExportingEventArgs e) { RadGridView_ElementExport.ElementExporting(e, isGroupFootersVisible: false); }
private void ElementExporting(object sender, GridViewElementExportingEventArgs e) { var htmlVisualExportParameters = e.VisualParameters as GridViewHtmlVisualExportParameters; if (htmlVisualExportParameters != null) { if (e.Element == ExportElement.HeaderRow || e.Element == ExportElement.FooterRow || e.Element == ExportElement.GroupFooterRow) { htmlVisualExportParameters.Background = HeaderBackground; htmlVisualExportParameters.Foreground = HeaderForeground; htmlVisualExportParameters.FontSize = 20; htmlVisualExportParameters.FontWeight = FontWeights.Bold; } else if (e.Element == ExportElement.Row) { htmlVisualExportParameters.Background = RowBackground; htmlVisualExportParameters.Foreground = RowForeground; } else if (e.Element == ExportElement.Cell && e.Value != null && e.Value.Equals("Chocolade")) { htmlVisualExportParameters.FontFamily = new FontFamily("Verdana"); htmlVisualExportParameters.Background = Colors.LightGray; htmlVisualExportParameters.Foreground = Colors.Blue; } else if (e.Element == ExportElement.GroupHeaderRow) { htmlVisualExportParameters.FontFamily = new FontFamily("Verdana"); htmlVisualExportParameters.Background = Colors.LightGray; htmlVisualExportParameters.Height = 30; } else if (e.Element == ExportElement.GroupHeaderCell && e.Value != null && e.Value.Equals("Chocolade")) { e.Value = "MyNewValue"; } } }
private void ElementExporting(object sender, GridViewElementExportingEventArgs e) { var visParameters = e.VisualParameters as GridViewExcelMLVisualExportParameters; if (e.Element == ExportElement.Row) { visParameters.RowHeight = this.RowHeight; } if (e.Element == ExportElement.Cell && (e.Context as GridViewBoundColumnBase).UniqueName == "Name") { visParameters.StyleId = "Name"; } if (e.Element == ExportElement.Cell && (e.Context as GridViewBoundColumnBase).UniqueName == "UnitPrice") { visParameters.StyleId = "UnitPrice"; } }
private void ElementExporting(object sender, GridViewElementExportingEventArgs e) { var bHtml = (TheExportOptionsViewModel.Value.ExportFileType != ExportFileType.ExcelML && TheExportOptionsViewModel.Value.ExportFileType != ExportFileType.Csv); if (!bHtml) return; switch (e.Element) { case ExportElement.HeaderRow: if (TheExportOptionsViewModel.Value.ExportFileType == ExportFileType.Pdf) { if (TheExportOptionsViewModel.Value.HeaderBackground.HasValue) ((GridViewHtmlVisualExportParameters)e.VisualParameters).Styles.Add("background-color", TheExportOptionsViewModel.Value.HeaderBackground.Value.ToString().Remove(1, 2)); } else { ((GridViewHtmlVisualExportParameters)e.VisualParameters).Background = TheExportOptionsViewModel.Value.HeaderBackground; } ((GridViewHtmlVisualExportParameters)e.VisualParameters).FontSize = 20; ((GridViewHtmlVisualExportParameters)e.VisualParameters).FontWeight = FontWeights.Bold; break; case ExportElement.HeaderCell: ((GridViewHtmlVisualExportParameters)e.VisualParameters).Foreground = TheExportOptionsViewModel.Value.HeaderForeground; ((GridViewHtmlVisualExportParameters)e.VisualParameters).Height = 20; break; case ExportElement.Row: _row = (IInfoClass)e.Value; if (TheExportOptionsViewModel.Value.ExportFileType == ExportFileType.Pdf) { if (TheExportOptionsViewModel.Value.RowBackground.HasValue) ((GridViewHtmlVisualExportParameters)e.VisualParameters).Styles.Add("background-color", TheExportOptionsViewModel.Value.RowBackground.Value.ToString().Remove(1, 2)); } else { ((GridViewHtmlVisualExportParameters)e.VisualParameters).Background = TheExportOptionsViewModel.Value.RowBackground; } break; case ExportElement.GroupHeaderRow: ((GridViewHtmlVisualExportParameters)e.VisualParameters).FontFamily = new FontFamily("Arial Unicode MS"); ((GridViewHtmlVisualExportParameters)e.VisualParameters).Background = Colors.LightGray; ((GridViewHtmlVisualExportParameters)e.VisualParameters).Height = 30; var qcvGroup = e.Value as QueryableCollectionViewGroup; if (qcvGroup != null) e.Value = string.Format(CultureInfo.InvariantCulture, "{0} Items", qcvGroup.Items.Count); break; case ExportElement.GroupFooterRow: case ExportElement.FooterRow: if (TheExportOptionsViewModel.Value.ExportFileType == ExportFileType.Pdf) ((GridViewHtmlVisualExportParameters)e.VisualParameters).Styles.Add("background-color", Colors.LightGray.ToString().Remove(1, 2)); else ((GridViewHtmlVisualExportParameters)e.VisualParameters).Background = Colors.LightGray; break; case ExportElement.Cell: if (_accessDeniedProperties.Any(x => x == ((GridViewColumn)e.Context).UniqueName)) { e.Value = "<Blocked>"; ((GridViewHtmlVisualExportParameters)e.VisualParameters).Foreground = Colors.Red; break; } if (e.Value is string && (string)e.Value == "<Rich Text>") { ((GridViewHtmlVisualExportParameters)e.VisualParameters).Foreground = Colors.Blue; break; } if (e.Value is byte[]) { e.Value = "binary data"; } var propertyName = ((GridViewDataColumn)e.Context).UniqueName + Constants.FieldBackColorPostfix; var value = _row.GetValueByPropertyName(propertyName); if (value is long) { var color = ((long)value); if (color != 0) { ((GridViewHtmlVisualExportParameters)e.VisualParameters).Background = ((long)value).ToColor(); } } ((GridViewHtmlVisualExportParameters)e.VisualParameters).Foreground = TheExportOptionsViewModel.Value.RowForeground; break; case ExportElement.GroupFooterCell: if (e.Value == null) return; var qcvg = e.Value as QueryableCollectionViewGroup; if (qcvg != null) { var resultList = new List<string>(); foreach (var aggr in qcvg.AggregateResults) { if (aggr.FunctionName.StartsWith(((GridViewColumn)e.Context).UniqueName, StringComparison.Ordinal)) { resultList.Add(string.Format(CultureInfo.InvariantCulture, "{0} {1}", aggr.Caption, aggr.Value)); } } e.Value = string.Join(", ", resultList); } break; case ExportElement.FooterCell: if (e.Value == null) return; var result = new List<string>(); var array = ((string)e.Value).Split(','); for (byte i = 0; i < ((GridViewColumn)e.Context).AggregateFunctions.Count; i++) result.Add(string.Format(CultureInfo.InvariantCulture, "{0} {1}", ((GridViewColumn)e.Context).AggregateFunctions[i].Caption, array[i])); e.Value = string.Join(", ", result); break; } }
/// <summary> /// handles element exporting /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgIndexConstituents_ElementExporting(object sender, GridViewElementExportingEventArgs e) { RadGridView_ElementExport.ElementExporting(e, isGroupFootersVisible: false); }
private void dgQuarterlyResults_ElementExporting(object sender, GridViewElementExportingEventArgs e) { RadGridView_ElementExport.ElementExporting(e, isGroupFootersVisible: false); }
/// <summary> /// 设置导出样式 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void ElementExporting(object sender, GridViewElementExportingEventArgs e) { e.Width = 120; if (e.Element == ExportElement.Cell && e.Value != null) { if (i % 4 == 3 && i >= 7 && (sender as RadGridView).Name == "FleetTrendCargo") { e.Value = DateTime.Parse(e.Value.ToString()).AddMonths(1).AddDays(-1).ToString("yyyy/M/d"); } else if (i % 6 == 3 && i >= 9 && (sender as RadGridView).Name == "SubFleetTrendCargo") { e.Value = DateTime.Parse(e.Value.ToString()).AddMonths(1).AddDays(-1).ToString("yyyy/M/d"); } } i++; }
/// <summary> /// Element Exporting Event /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ExcelElementExporting(object sender, GridViewElementExportingEventArgs e) { RadGridView_ElementExport.ElementExporting(e, isGroupFootersVisible: false); }
/// <summary> /// dgFinancialReport ElementExporting EventHandler /// </summary> /// <param name="sender"></param> /// <param name="e">GridViewElementExportingEventArgs</param> private void dgFinancialReport_ElementExporting(object sender, GridViewElementExportingEventArgs e) { RadGridView_ElementExport.ElementExporting(e, hideColumnIndex: new List <int> { 1, 14 }); }
/// <summary> /// 设置导出样式 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void ElementExporting(object sender, GridViewElementExportingEventArgs e) { e.Width = 120; if (e.Element == ExportElement.Cell && e.Value != null) { if (i % 4 == 3 && i >= 7) { RadGridView a = sender as RadGridView; if (a.Name == "FleetTrendPnrMonth") { e.Value = DateTime.Parse(e.Value.ToString()).AddMonths(1).AddDays(-1).ToString("yyyy/M/d"); } } } i++; }
/// <summary> /// Syles added to Export to Excel /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgCOASpecific_ElementExporting(object sender, GridViewElementExportingEventArgs e) { RadGridView_ElementExport.ElementExporting(e, hideColumnIndex: new List <int> { 1, 8 }); }
/// <summary> /// Application des couleurs sur les éléments du tableau /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private static void elementExporting(object sender, GridViewElementExportingEventArgs e) { e.FontFamily = new FontFamily("Verdana"); e.FontSize = 9; e.VerticalAlignment = VerticalAlignment.Center; if (e.Element == ExportElement.Table) { e.Attributes["border"] = "0"; } else if (e.Element == ExportElement.HeaderRow) { rowCount = 0; e.Styles.Add("background-color", ExportAndPrintHelper.HeaderBackground.ToString().Remove(1, 2)); e.Background = ExportAndPrintHelper.HeaderBackground; e.Foreground = ExportAndPrintHelper.HeaderForeground; e.FontWeight = FontWeights.Bold; e.FontSize = 10; } else if (e.Element == ExportElement.GroupHeaderRow) { rowCount = 0; e.Styles.Add("background-color", ExportAndPrintHelper.GroupHeaderBackground.ToString().Remove(1, 2)); e.Background = ExportAndPrintHelper.GroupHeaderBackground; e.Foreground = ExportAndPrintHelper.HeaderForeground; e.FontWeight = FontWeights.Bold; } else if (e.Element == ExportElement.HeaderCell) { e.Styles.Add("white-space", "nowrap"); if (e.Value is Image && (e.Context as GridViewDataColumn) != null) { e.Value = (e.Context as GridViewDataColumn).DataMemberBinding.Path.Path; } } else if (e.Element == ExportElement.GroupHeaderCell && String.IsNullOrEmpty(e.Value.ToString()) && e.Context is QueryableCollectionViewGroup) { e.Value = (e.Context as QueryableCollectionViewGroup).Key; } else if (e.Element == ExportElement.Row) { rowCount++; if (rowCount % 2 == 0) { e.Background = ExportAndPrintHelper.RowBackgroundAlternate; e.Foreground = ExportAndPrintHelper.RowForegroundAlternate; } else { e.Background = ExportAndPrintHelper.RowBackground; e.Foreground = ExportAndPrintHelper.RowForeground; } e.Styles.Add("background-color", e.Background.ToString().Remove(1, 2)); } else if (e.Element == ExportElement.Cell && (e.Context as GridViewDataColumn) != null) { if ((e.Context as GridViewDataColumn).DataType == typeof(DateTime) || (e.Context as GridViewDataColumn).DataType == typeof(Decimal) || (e.Context as GridViewDataColumn).DataType == typeof(Double) || (e.Context as GridViewDataColumn).DataType == typeof(int) ) { (e.Context as GridViewDataColumn).TextWrapping = TextWrapping.NoWrap; e.Styles.Add("white-space", "nowrap"); } if (e.Value is bool) { e.Value = ((bool)e.Value) ? "oui" : "non"; } if ((e.Context as GridViewDataColumn).DataType == typeof(DateTime)) { e.Width = 80; } } }
/// <summary> /// Helper method Export /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgRelativePerformanceUI_ElementExporting(object sender, GridViewElementExportingEventArgs e) { RadGridView_ElementExport.ElementExporting(e); }
/// <summary> /// 设置导出样式 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void ElementExporting(object sender, GridViewElementExportingEventArgs e) { e.Width = 120; if (e.Element == ExportElement.Row) { i = 1; } else if (e.Element == ExportElement.Cell && e.Value != null) { var gridViewColumn = e.Context as GridViewColumn; if (gridViewColumn != null && gridViewColumn.UniqueName == "performTime") { if (!string.IsNullOrEmpty(e.Value.ToString())) e.Value = DateTime.Parse(e.Value.ToString()).ToString("yyyy年M月"); } i++; } }
/// <summary> /// handles element exporting for export to excel /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgRegionBreakdown_ElementExporting(object sender, GridViewElementExportingEventArgs e) { RadGridView_ElementExport.ElementExporting(e, isGroupFootersVisible: true, aggregatedColumnIndex: new List <int> { 1, 2, 3 }); }
/// <summary> /// 设置导出样式 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ElementExporting(object sender, GridViewElementExportingEventArgs e) { // ReSharper disable once CSharpWarnings::CS0618 e.Width = 120; if (e.Element == ExportElement.Cell && e.Value != null) { var radGridView = sender as RadGridView; if (radGridView != null && (_i%5 == 3 && _i >= 8 && radGridView.Name.Equals("FleetTrendPnr", StringComparison.OrdinalIgnoreCase))) { e.Value = DateTime.Parse(e.Value.ToString()).AddMonths(1).AddDays(-1).ToString("yyyy/M/d"); } else if (radGridView != null && _i%8 == 3 && _i >= 11 && radGridView.Name.Equals("SubFleetTrendPnr", StringComparison.OrdinalIgnoreCase)) { e.Value = DateTime.Parse(e.Value.ToString()).AddMonths(1).AddDays(-1).ToString("yyyy/M/d"); } } _i++; }
/// <summary> /// 设置导出样式 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ElementExporting(object sender, GridViewElementExportingEventArgs e) { // ReSharper disable once CSharpWarnings::CS0618 e.Width = 120; if (e.Element == ExportElement.Cell && e.Value != null) { if (_i%5 == 3 && _i >= 8 && ((RadGridView) sender).Name.Equals("FleetStructure", StringComparison.OrdinalIgnoreCase)) { e.Value = DateTime.Parse(e.Value.ToString()).AddMonths(1).AddDays(-1).ToString("yyyy/M/d"); } } _i++; }
private void ElementExporting(object sender, GridViewElementExportingEventArgs e) { if (e.Element == ExportElement.HeaderRow) { var htmlVisualExportParameters = e.VisualParameters as GridViewHtmlVisualExportParameters; if (htmlVisualExportParameters != null) { htmlVisualExportParameters.FontWeight = FontWeights.Bold; } } }
/// <summary> /// 设置导出样式 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void ElementExporting(object sender, GridViewElementExportingEventArgs e) { e.Width = 120; }
/// <summary> /// Handles RadGridView Element Export in predefined prameterized details /// </summary> /// <param name="exportElement">GridViewElementExportingEventArgs - custom argument received in RadGridView Element_Exporting event</param> /// <param name="cellValueConverter">Function to convert cell values to customed values</param> /// <param name="headerCellValueConverter">Function to convert header cell values to customed values</param> /// <param name="isGroupFootersVisible">True to display group footers in export</param> /// <param name="hideColumnIndex">List of column indexes to be hide in export</param> /// <param name="aggregatedColumnIndex">aggregated column indexes</param> public static void ElementExporting(GridViewElementExportingEventArgs exportElement, Func <object> cellValueConverter = null, Func <object> headerCellValueConverter = null, bool isGroupFootersVisible = true , List <int> hideColumnIndex = null, List <int> aggregatedColumnIndex = null) { ExportElementOptions element = ExportElementOptions.Where(t => t.ExportElementType == exportElement.Element).FirstOrDefault(); if (element != null) { exportElement.Background = element.ExportElementBackground; exportElement.Foreground = element.ExportElementForeground; exportElement.FontFamily = element.ExportElementFontFamily; exportElement.FontSize = element.ExportElementFontSize; exportElement.Height = element.ExportElementFontSize + 5; exportElement.Width = 100; exportElement.VerticalAlignment = VerticalAlignment.Center; exportElement.FontWeight = element.ExportElementFontWeight; exportElement.TextAlignment = element.ExportElementTextAlignment; } if (hideColumnIndex != null) { GridViewDataColumn column = exportElement.Context as GridViewDataColumn; if (column != null) { if (exportElement.Element == ExportElement.Cell || exportElement.Element == ExportElement.FooterCell || exportElement.Element == ExportElement.GroupFooterCell || exportElement.Element == ExportElement.GroupHeaderCell || exportElement.Element == ExportElement.GroupIndentCell || exportElement.Element == ExportElement.HeaderCell) { if (hideColumnIndex.Contains(column.DisplayIndex)) { exportElement.Cancel = true; } } } } if (exportElement.Element == ExportElement.HeaderCell) { if (headerCellValueConverter != null) { exportElement.Value = headerCellValueConverter(); } } if (exportElement.Element == ExportElement.GroupFooterRow || exportElement.Element == ExportElement.GroupFooterCell) { if (isGroupFootersVisible == false) { exportElement.Cancel = true; return; } } if (exportElement.Element == ExportElement.Cell) { if (cellValueConverter != null) { exportElement.Value = cellValueConverter(); } } if (exportElement.Element == ExportElement.Row) { if (cellValueConverter != null) { exportElement.Value = cellValueConverter(); } } if (exportElement.Element == ExportElement.FooterCell) { if (cellValueConverter != null) { exportElement.Value = cellValueConverter(); } } else if (exportElement.Element == ExportElement.GroupFooterCell) { GridViewDataColumn column = exportElement.Context as GridViewDataColumn; QueryableCollectionViewGroup qcvGroup = exportElement.Value as QueryableCollectionViewGroup; if (column != null && qcvGroup != null && column.AggregateFunctions.Count > 0) { exportElement.Value = GetAggregates(qcvGroup, column); } else { exportElement.Value = ""; } } }