public static PivotGridSettings CreatePivotGridSettings() { PivotGridSettings settings = new PivotGridSettings(); CustomizePivotGridSettings(settings); return(settings); }
public static ActionResult GetExportActionResult(PivotGridExportDemoOptions options, object data) { if (exportTypes == null) { exportTypes = CreateExportTypes(); } PivotGridExportFormats format = options.ExportType; PivotGridSettings settings = GetPivotGridExportSettings(options.WYSIWYG); switch (format) { case PivotGridExportFormats.Excel: return(exportTypes[format].ExcelMethod(settings, data, new XlsxExportOptionsEx() { ExportType = ExportType.WYSIWYG })); case PivotGridExportFormats.ExcelDataAware: XlsxExportOptionsEx exportOptions = new XlsxExportOptionsEx() { ExportType = ExportType.DataAware }; exportOptions.AllowFixedColumnHeaderPanel = exportOptions.AllowFixedColumns = options.DataAware.AllowFixedColumnAndRowArea ? DefaultBoolean.True : DefaultBoolean.False; exportOptions.AllowGrouping = options.DataAware.AllowGrouping ? DefaultBoolean.True : DefaultBoolean.False; exportOptions.RawDataMode = options.DataAware.ExportRawData; exportOptions.TextExportMode = options.DataAware.ExportDisplayText ? TextExportMode.Text : TextExportMode.Value; return(exportTypes[format].ExcelMethod(DataAwarePivotGridSettings, data, exportOptions)); default: return(exportTypes[format].Method(settings, data)); } }
public static void HandleAfterPerformCallback(PivotGridSettings settings, string fieldID, int itemIndex) { settings.AfterPerformCallback = (s, e) => { MVCxPivotGrid pivot = (MVCxPivotGrid)s; MVCxPivotGridField clickedField = (MVCxPivotGridField)pivot.Fields[fieldID]; object filterValue = pivot.GetFieldValueByIndex(clickedField, itemIndex); clickedField.FilterValues.ValuesIncluded = new Object[] { filterValue }; }; }
static PivotGridSettings CreatePivotGridSettingsBase() { PivotGridSettings settings = new PivotGridSettings(); settings.Name = "pivotGrid"; settings.CallbackRouteValues = new { Controller = "Export", Action = "ExportPartial" }; settings.Width = Unit.Percentage(100); settings.OptionsView.HorizontalScrollBarMode = ScrollBarMode.Auto; return(settings); }
public static void PassAllowedFieldsToClientSide(PivotGridSettings settings) { StringBuilder stb = new StringBuilder(); foreach (MVCxPivotGridField field in settings.Fields.OfType <MVCxPivotGridField>().Where(f => f.Area == PivotArea.DataArea)) { stb.Append(field.ID); stb.Append("|"); } settings.CustomJsProperties = (s, e) => { e.Properties.Add("cpAllowedFields", stb.ToString()); }; }
public static PivotGridSettings GetPivotGridExportSettings(PivotGridExportDemoOptions options) { PivotGridSettings exportSettings = ExportPivotGridSettings; exportSettings.SettingsExport.OptionsPrint.PrintHeadersOnEveryPage = options.PrintHeadersOnEveryPage; exportSettings.SettingsExport.OptionsPrint.PrintFilterHeaders = ConvertToDefaultBoolean(options.PrintFilterHeaders); exportSettings.SettingsExport.OptionsPrint.PrintColumnHeaders = ConvertToDefaultBoolean(options.PrintColumnHeaders); exportSettings.SettingsExport.OptionsPrint.PrintRowHeaders = ConvertToDefaultBoolean(options.PrintRowHeaders); exportSettings.SettingsExport.OptionsPrint.PrintDataHeaders = ConvertToDefaultBoolean(options.PrintDataHeaders); return(exportSettings); }
public static PivotGridSettings CreateGeneralSettings() { var settings = new PivotGridSettings(); settings.Name = "PivotGrid"; settings.OptionsView.ShowHorizontalScrollBar = true; settings.Width = new System.Web.UI.WebControls.Unit(90, System.Web.UI.WebControls.UnitType.Percentage); settings.Fields.Add("Country", PivotArea.ColumnArea); settings.Fields.Add("City", PivotArea.FilterArea); settings.Fields.Add("ExtendedPrice", PivotArea.DataArea); settings.Fields.Add("Freight", PivotArea.FilterArea); settings.Fields.Add("Quantity", PivotArea.FilterArea); settings.Fields.Add(field => { field.Area = PivotArea.RowArea; field.FieldName = "OrderDate"; field.GroupInterval = PivotGroupInterval.DateYear; field.UnboundFieldName = "DateYear"; field.Caption = "Year"; }); settings.Fields.Add(field => { field.Area = PivotArea.RowArea; field.FieldName = "OrderDate"; field.GroupInterval = PivotGroupInterval.DateQuarter; field.UnboundFieldName = "DateQuarter"; field.Caption = "Quarter"; }); settings.Fields.Add(field => { field.Area = PivotArea.RowArea; field.FieldName = "OrderDate"; field.GroupInterval = PivotGroupInterval.DateMonth; field.UnboundFieldName = "DateMonth"; field.Caption = "Month"; field.UseNativeFormat = DefaultBoolean.False; }); // Saves layout after change settings.GridLayout = (sender, e) => { MVCxPivotGrid PivotGrid = sender as MVCxPivotGrid; Session["Layout"] = PivotGrid.SaveLayoutToString(PivotGridWebOptionsLayout.DefaultLayout); }; // Loads layout after change settings.PreRender = (sender, e) => { MVCxPivotGrid PivotGrid = sender as MVCxPivotGrid; string layout = Session["Layout"] as string; if (!string.IsNullOrEmpty(layout)) { PivotGrid.LoadLayoutFromString(layout, DevExpress.Web.ASPxPivotGrid.PivotGridWebOptionsLayout.DefaultLayout); } }; return(settings); }
static PivotGridSettings CreateDrillDownPivotGridSettings() { PivotGridSettings settings = CreatePivotGridSettings("DrillDownPivotGridPartial"); settings.Styles.CellStyle.Cursor = "pointer"; settings.OptionsView.ShowFilterHeaders = false; settings.ClientSideEvents.CellClick = "OnPivotGridCellClick"; settings.Fields["Year"].UnboundFieldName = "Year"; settings.Fields["Product"].Area = PivotArea.RowArea; return(settings); }
public static void CustomizeContextMenu(PivotGridSettings settings) { settings.PopupMenuCreated = (s, e) => { if (e.MenuType == DevExpress.Web.ASPxPivotGrid.PivotGridPopupMenuType.FieldValueMenu) { MenuItem item = e.Menu.Items.Add("Filter By This Value", "Filter"); item.BeginGroup = true; e.Menu.ClientSideEvents.PopUp = "function ASPxClientMenuItemEventHandler(s, e) { MenuItemPopUpHandle(s, e); }"; e.Menu.ClientSideEvents.CloseUp = "function ASPxClientMenuItemEventHandler(s, e) { MenuItemCloseUpHandle(s, e); }"; } }; }
private static PivotGridSettings CreatePivotGridSettings() { PivotGridSettings settings = new PivotGridSettings(); settings.Name = "pivotGrid"; settings.CallbackRouteValues = new { Controller = "Home", Action = "PivotGridPartial" }; settings.OptionsView.ShowHorizontalScrollBar = true; settings.Width = new System.Web.UI.WebControls.Unit(90, System.Web.UI.WebControls.UnitType.Percentage); settings.Fields.Add("[Measures].[Sales Amount]", PivotArea.DataArea); settings.Fields.Add("[Product].[Product Categories].[Category]", PivotArea.RowArea); settings.Fields.Add("[Date].[Calendar Year].[Calendar Year]", PivotArea.ColumnArea); return(settings); }
public static PivotGridSettings PivotChartIntegrationSettings(PivotGridChartIntegrationDemoOptions options) { if (pivotChartIntegrationSettings == null) { pivotChartIntegrationSettings = CreatePivotChartIntegrationSettings(); } if (options != null) { pivotChartIntegrationSettings.OptionsChartDataSource.ProvideColumnGrandTotals = options.ShowColumnGrandTotals; pivotChartIntegrationSettings.OptionsChartDataSource.ProvideRowGrandTotals = options.ShowRowGrandTotals; pivotChartIntegrationSettings.OptionsChartDataSource.ProvideDataByColumns = options.GenerateSeriesFromColumns; } return(pivotChartIntegrationSettings); }
static PivotGridSettings CreatePivotChartIntegrationSettings() { PivotGridSettings pivotGridSettings = new PivotGridSettings(); pivotGridSettings.Name = "pivotGrid"; pivotGridSettings.CallbackRouteValues = new { Controller = "PivotGrid", Action = "ChartsIntegrationPivotPartial" }; pivotGridSettings.OptionsChartDataSource.DataProvideMode = PivotChartDataProvideMode.UseCustomSettings; pivotGridSettings.OptionsView.ShowFilterHeaders = false; pivotGridSettings.OptionsView.ShowHorizontalScrollBar = true; pivotGridSettings.Width = Unit.Percentage(100); pivotGridSettings.Fields.Add(field => { field.FieldName = "Extended_Price"; field.Caption = "Extended Price"; field.Area = PivotArea.DataArea; field.AreaIndex = 0; }); pivotGridSettings.Fields.Add(field => { field.FieldName = "CategoryName"; field.Caption = "Category Name"; field.Area = PivotArea.RowArea; field.AreaIndex = 0; }); pivotGridSettings.Fields.Add(field => { field.FieldName = "OrderDate"; field.Caption = "Order Month"; field.Area = PivotArea.ColumnArea; field.AreaIndex = 0; field.UnboundFieldName = "fieldOrderDate"; field.GroupInterval = PivotGroupInterval.DateMonth; }); pivotGridSettings.PreRender = (sender, e) => { int selectNumber = 4; var field = ((MVCxPivotGrid)sender).Fields["Category Name"]; object[] values = field.GetUniqueValues(); List <object> includedValues = new List <object>(values.Length / selectNumber); for (int i = 0; i < values.Length; i++) { if (i % selectNumber == 0) { includedValues.Add(values[i]); } } field.FilterValues.ValuesIncluded = includedValues.ToArray(); }; pivotGridSettings.ClientSideEvents.BeginCallback = "OnBeforePivotGridCallback"; pivotGridSettings.ClientSideEvents.EndCallback = "UpdateChart"; return(pivotGridSettings); }
static PivotGridSettings CreatePivotGridSettings(string actionName) { PivotGridSettings settings = new PivotGridSettings(); settings.Name = "pivotGrid"; settings.CallbackRouteValues = new { Controller = "PivotGrid", Action = actionName }; settings.Width = Unit.Percentage(100); settings.OptionsView.ShowHorizontalScrollBar = true; settings.Fields.Add(field => { field.Area = PivotArea.FilterArea; field.AreaIndex = 0; field.Caption = "Product"; field.FieldName = "ProductName"; }); settings.Fields.Add(field => { field.Area = PivotArea.RowArea; field.AreaIndex = 0; field.Caption = "Customer"; field.FieldName = "CompanyName"; }); settings.Fields.Add(field => { field.Area = PivotArea.ColumnArea; field.AreaIndex = 0; field.Caption = "Year"; field.FieldName = "OrderDate"; field.GroupInterval = PivotGroupInterval.DateYear; }); settings.Fields.Add(field => { field.Area = PivotArea.DataArea; field.AreaIndex = 0; field.Caption = "Product Amount"; field.FieldName = "ProductAmount"; field.CellFormat.FormatString = "c"; field.CellFormat.FormatType = FormatType.Custom; }); settings.Fields.Add(field => { field.Area = PivotArea.FilterArea; field.AreaIndex = 1; field.Caption = "Quarter"; field.FieldName = "OrderDate"; field.GroupInterval = PivotGroupInterval.DateQuarter; }); return(settings); }
private static PivotGridSettings CreatePivotGridSettings() { PivotGridSettings settings = new PivotGridSettings(); settings.Name = "pivotGrid"; settings.CallbackRouteValues = new { Controller = "Home", Action = "PivotGridPartial" }; settings.OptionsView.HorizontalScrollBarMode = DevExpress.Web.ScrollBarMode.Auto; settings.OptionsData.AutoExpandGroups = DevExpress.Utils.DefaultBoolean.False; settings.Width = new System.Web.UI.WebControls.Unit(100, System.Web.UI.WebControls.UnitType.Percentage); settings.Fields.Add("Country", PivotArea.ColumnArea); settings.Fields.Add("City", PivotArea.ColumnArea); settings.Fields.Add(field => { field.Area = PivotArea.DataArea; field.FieldName = "ExtendedPrice"; }); settings.Fields.Add("ProductName", PivotArea.RowArea); return(settings); }
static PivotGridSettings CreatePivotGridSettings() { PivotGridSettings settings = CreatePivotGridSettingsBase(); settings.Fields.Add(field => { field.Area = PivotArea.FilterArea; field.AreaIndex = 0; field.Caption = "Product"; field.FieldName = "ProductName"; }); settings.Fields.Add(field => { field.Area = PivotArea.RowArea; field.AreaIndex = 0; field.Caption = "Customer"; field.FieldName = "CompanyName"; }); settings.Fields.Add(field => { field.Area = PivotArea.ColumnArea; field.AreaIndex = 0; field.Caption = "Year"; field.FieldName = "OrderDate"; field.GroupInterval = PivotGroupInterval.DateYear; }); settings.Fields.Add(field => { field.Area = PivotArea.DataArea; field.AreaIndex = 0; field.Caption = "Product Amount"; field.FieldName = "ProductAmount"; field.CellFormat.FormatString = "c"; field.CellFormat.FormatType = FormatType.Custom; }); settings.Fields.Add(field => { field.Area = PivotArea.FilterArea; field.AreaIndex = 1; field.Caption = "Quarter"; field.FieldName = "OrderDate"; field.GroupInterval = PivotGroupInterval.DateQuarter; }); return(settings); }
private PivotGridSettings GetPivotGridSettings() { var settings = new PivotGridSettings(); settings.Name = "PivotGrid"; settings.CallbackRouteValues = new { Controller = "Home", Action = "PivotGridPartial" }; settings.CustomActionRouteValues = new { Controller = "Home", Action = "PivotGridCustomPartial" }; settings.Fields.Add(field => { field.ID = "fieldCountry"; field.Area = PivotArea.RowArea; field.FieldName = "Country"; field.Caption = "Country"; }); settings.Fields.Add(field => { field.ID = "fieldOrderDate"; field.Area = PivotArea.ColumnArea; field.FieldName = "OrderDate"; field.Caption = "OrderDate"; field.GroupInterval = PivotGroupInterval.DateYear; }); settings.Fields.Add(field => { field.ID = "fieldProductName"; field.Area = PivotArea.FilterArea; field.FieldName = "ProductName"; field.Caption = "ProductName"; }); settings.Fields.Add(field => { field.ID = "fieldExtendedPrice"; field.Area = PivotArea.DataArea; field.FieldName = "ExtendedPrice"; field.Caption = "ExtendedPrice"; }); settings.PreRender = settings.GridLayout = (s, e) => { var pivot = (MVCxPivotGrid)s; Session["pivotFilterValues"] = pivot.Fields.OfType <PivotGridField>().Where(f => f.Visible && f.Area != PivotArea.DataArea).ToDictionary(f => f.ID, f => CustomFilterItem.GetItems(f)); }; return(settings); }
public static void CustomizePivotGridSettings(PivotGridSettings settings) { settings.Name = "PivotGrid"; settings.CallbackRouteValues = new { Controller = "Home", Action = "PivotGridPartial" }; settings.OptionsChartDataSource.ProvideDataByColumns = false; settings.ClientSideEvents.EndCallback = "PivotEndCallback"; settings.BeforeGetCallbackResult = (sender, e) => { MVCxPivotGrid pivot = (MVCxPivotGrid)sender; pivot.JSProperties["cpLayoutUpdated"] = false; }; settings.GridLayout = (sender, e) => { MVCxPivotGrid pivot = (MVCxPivotGrid)sender; pivot.JSProperties["cpLayoutUpdated"] = true; }; settings.Fields.Add(field => { field.ID = "fieldDate"; field.Area = PivotArea.ColumnArea; field.FieldName = "Date"; field.GroupInterval = PivotGroupInterval.Date; field.Caption = "Date"; }); settings.Fields.Add(field => { field.ID = "fieldName"; field.Area = PivotArea.RowArea; field.FieldName = "Name"; field.Caption = "Name"; }); settings.Fields.Add(field => { field.ID = "fieldValue"; field.Area = PivotArea.DataArea; field.FieldName = "Value"; field.Caption = "Value"; }); }
public static PivotGridSettings CreatePivotGridSettings() { PivotGridSettings settings = new PivotGridSettings(); settings.Name = "PivotGrid1"; settings.CallbackRouteValues = new { Controller = "Home", Action = "PivotGrid1Partial" }; settings.Fields.Add(field => { field.Area = PivotArea.RowArea; field.FieldName = "SupplierID"; field.Caption = "SupplierID"; }); settings.Fields.Add(field => { field.Area = PivotArea.ColumnArea; field.FieldName = "CategoryID"; field.Caption = "CategoryID"; }); settings.Fields.Add(field => { field.Area = PivotArea.DataArea; field.FieldName = "UnitsInStock"; field.Caption = "UnitsInStock"; }); return(settings); }
public static PivotGridSettings CreatePivotGridSettingsM() { PivotGridSettings settings = new PivotGridSettings(); settings.Name = "BaoCaoTheoThang_" + DateTime.Now.ToString("dd-MM-yyyy HH:mm:ss"); settings.CallbackRouteValues = new { Controller = "StockMovementSummary", Action = "_PivotPartialViewM", FromMonth = _FromMonth, FromYearMonth = _FromYearMonth, ToMonth = _ToMonth, ToYearMonth = _ToYearMonth, WarehouseId = _WarehouseId }; settings.Width = System.Web.UI.WebControls.Unit.Percentage(100); settings.Theme = "Metropolis"; settings.OptionsView.ShowHorizontalScrollBar = true; settings.OptionsView.ShowColumnGrandTotals = false; settings.OptionsView.ShowRowTotals = false; settings.OptionsView.ShowRowGrandTotals = false; // dòng tổng cuối settings.OptionsPager.RowsPerPage = PageSize; // Xác định các field //Fillter settings.Fields.Add(filed => { filed.Area = DevExpress.XtraPivotGrid.PivotArea.FilterArea; filed.AreaIndex = 0; filed.FieldName = "ShortName"; filed.Caption = "Cửa hàng"; // Tên hiển thị fillter }); settings.Fields.Add(filed => { filed.Area = DevExpress.XtraPivotGrid.PivotArea.FilterArea; filed.AreaIndex = 1; filed.FieldName = "WarehouseName"; filed.Caption = "Kho"; }); settings.Fields.Add(filed => { filed.Area = DevExpress.XtraPivotGrid.PivotArea.FilterArea; filed.AreaIndex = 2; filed.FieldName = "CategoryName"; filed.Caption = "Loại sản phẩm"; }); //Giá trị vùng dữ liệu settings.Fields.Add(filed => { filed.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; filed.AreaIndex = 0; filed.FieldName = "BeginInventoryQty"; filed.Caption = "Tồn đầu"; filed.CellFormat.FormatType = FormatType.Numeric; filed.CellFormat.FormatString = "{0:n0}"; }); settings.Fields.Add(filed => { filed.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; filed.AreaIndex = 1; filed.FieldName = "ImportQty"; filed.Caption = "Nhập"; filed.CellFormat.FormatType = FormatType.Numeric; filed.CellFormat.FormatString = "{0:n0}"; }); settings.Fields.Add(filed => { filed.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; filed.AreaIndex = 2; filed.FieldName = "ExportQty"; filed.Caption = "Xuất"; filed.CellFormat.FormatType = FormatType.Numeric; filed.CellFormat.FormatString = "{0:n0}"; }); settings.Fields.Add(filed => { filed.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; filed.AreaIndex = 3; filed.FieldName = "EndInventoryQty"; filed.Caption = "Tồn cuối"; filed.CellFormat.FormatType = FormatType.Numeric; filed.CellFormat.FormatString = "{0:n0}"; }); // Dòng dữ liệu settings.Fields.Add(filed => { filed.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; filed.AreaIndex = 0; filed.FieldName = "ProductName"; filed.Caption = "Sản phẩm"; }); //cột dữ liệu settings.Fields.Add(filed => { filed.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; filed.FieldName = "CreatedDateString"; filed.AreaIndex = 0; filed.Caption = "Tháng"; }); settings.PreRender = (sender, e) => { MVCxPivotGrid PivotGrid = sender as MVCxPivotGrid; if (System.Web.HttpContext.Current.Session["LayoutM"] != null) { PivotGrid.LoadLayoutFromString((string)System.Web.HttpContext.Current.Session["LayoutM"], PivotGridWebOptionsLayout.DefaultLayout); } PivotGrid.CollapseAll(); }; settings.GridLayout = (sender, e) => { MVCxPivotGrid PivotGrid = sender as MVCxPivotGrid; System.Web.HttpContext.Current.Session["LayoutM"] = PivotGrid.SaveLayoutToString(PivotGridWebOptionsLayout.DefaultLayout); }; return(settings); }
public static PivotGridSettings ModelPivotSettings() { PivotGridSettings pivotGridSettings = new PivotGridSettings(); pivotGridSettings.Name = "pivotGrid"; pivotGridSettings.CallbackRouteValues = new { Area = "NKD", Controller = "User", Action = "ModelPivotPartial" }; pivotGridSettings.OptionsChartDataSource.DataProvideMode = DevExpress.XtraPivotGrid.PivotChartDataProvideMode.UseCustomSettings; pivotGridSettings.OptionsChartDataSource.ProvideDataByColumns = true; pivotGridSettings.OptionsView.ShowFilterHeaders = false; pivotGridSettings.OptionsView.ShowHorizontalScrollBar = true; pivotGridSettings.OptionsView.ShowHorizontalScrollBar = true; pivotGridSettings.Width = System.Web.UI.WebControls.Unit.Percentage(100); pivotGridSettings.CustomizationFieldsLeft = 600; pivotGridSettings.CustomizationFieldsTop = 400; pivotGridSettings.OLAPDataProvider = DevExpress.XtraPivotGrid.OLAPDataProvider.Adomd; pivotGridSettings.OptionsCustomization.CustomizationFormStyle = DevExpress.XtraPivotGrid.Customization.CustomizationFormStyle.Excel2007; pivotGridSettings.CustomCallback = (sender, e) => { //DevExpress.Web.ASPxPivotGrid.PivotGridField field = ((MVCxPivotGrid)sender).Fields["[Product].[Product Categories].[Product]"]; //if (field != null) // ((MVCxPivotGrid)sender).Fields.Remove(field); }; pivotGridSettings.PreRender = (sender, e) => { MVCxPivotGrid pivot = ((MVCxPivotGrid)sender); pivot.RetrieveFields(DevExpress.XtraPivotGrid.PivotArea.FilterArea, false); //pivot.BeginUpdate(); //pivot.Fields["[Product].[Product Categories].[Category]"].Area = PivotArea.RowArea; //pivot.Fields["[Product].[Product Categories].[Category]"].Visible = true; //pivot.Fields["[Date].[Calendar].[Calendar Year]"].Area = PivotArea.ColumnArea; //pivot.Fields["[Date].[Calendar].[Calendar Year]"].Visible = true; //pivot.Fields["[Date].[Calendar].[Calendar Year]"].ExpandedInFieldsGroup = false; //pivot.Fields["[Measures].[Sales Amount]"].Visible = true; //pivot.EndUpdate(); }; //pivotGridSettings.Fields.Add(field => { // field.FieldName = "Extended_Price"; // field.Caption = "Extended Price"; // field.Area = PivotArea.DataArea; // field.AreaIndex = 0; //}); //pivotGridSettings.Fields.Add(field => { // field.FieldName = "CategoryName"; // field.Caption = "Category Name"; // field.Area = PivotArea.RowArea; // field.AreaIndex = 0; //}); //pivotGridSettings.Fields.Add(field => { // field.FieldName = "OrderDate"; // field.Caption = "Order Month"; // field.Area = PivotArea.ColumnArea; // field.AreaIndex = 0; // field.UnboundFieldName = "fieldOrderDate"; // field.GroupInterval = PivotGroupInterval.DateMonth; //}); //pivotGridSettings.PreRender = (sender, e) => { // int selectNumber = 4; // var field = ((MVCxPivotGrid)sender).Fields["Category Name"]; // object[] values = field.GetUniqueValues(); // List<object> includedValues = new List<object>(values.Length / selectNumber); // for (int i = 0; i < values.Length; i++) { // if (i % selectNumber == 0) // includedValues.Add(values[i]); // } // field.FilterValues.ValuesIncluded = includedValues.ToArray(); //}; pivotGridSettings.ClientSideEvents.BeginCallback = "OnBeforePivotGridCallback"; pivotGridSettings.ClientSideEvents.EndCallback = "UpdateChart"; return(pivotGridSettings); }
public BusinessIntelligenceModel() { PivotGridExportOptions = new PivotGridExportOptionsModel(); PivotGridSettings = new PivotGridSettings(); }
public static PivotGridSettings ModelPivotSettings() { PivotGridSettings pivotGridSettings = new PivotGridSettings(); pivotGridSettings.Name = "pivotGrid"; pivotGridSettings.CallbackRouteValues = new { Area = "XODB", Controller = "User", Action = "ModelPivotPartial" }; pivotGridSettings.OptionsChartDataSource.DataProvideMode = DevExpress.XtraPivotGrid.PivotChartDataProvideMode.UseCustomSettings; pivotGridSettings.OptionsChartDataSource.ProvideDataByColumns = true; pivotGridSettings.OptionsView.ShowFilterHeaders = false; pivotGridSettings.OptionsView.ShowHorizontalScrollBar = true; pivotGridSettings.OptionsView.ShowHorizontalScrollBar = true; pivotGridSettings.Width = System.Web.UI.WebControls.Unit.Percentage(100); pivotGridSettings.CustomizationFieldsLeft = 600; pivotGridSettings.CustomizationFieldsTop = 400; pivotGridSettings.OLAPDataProvider = DevExpress.XtraPivotGrid.OLAPDataProvider.Adomd; pivotGridSettings.OptionsCustomization.CustomizationFormStyle = DevExpress.XtraPivotGrid.Customization.CustomizationFormStyle.Excel2007; pivotGridSettings.CustomCallback = (sender, e) => { //DevExpress.Web.ASPxPivotGrid.PivotGridField field = ((MVCxPivotGrid)sender).Fields["[Product].[Product Categories].[Product]"]; //if (field != null) // ((MVCxPivotGrid)sender).Fields.Remove(field); }; pivotGridSettings.PreRender = (sender, e) => { MVCxPivotGrid pivot = ((MVCxPivotGrid)sender); pivot.RetrieveFields( DevExpress.XtraPivotGrid.PivotArea.FilterArea, false); //pivot.BeginUpdate(); //pivot.Fields["[Product].[Product Categories].[Category]"].Area = PivotArea.RowArea; //pivot.Fields["[Product].[Product Categories].[Category]"].Visible = true; //pivot.Fields["[Date].[Calendar].[Calendar Year]"].Area = PivotArea.ColumnArea; //pivot.Fields["[Date].[Calendar].[Calendar Year]"].Visible = true; //pivot.Fields["[Date].[Calendar].[Calendar Year]"].ExpandedInFieldsGroup = false; //pivot.Fields["[Measures].[Sales Amount]"].Visible = true; //pivot.EndUpdate(); }; //pivotGridSettings.Fields.Add(field => { // field.FieldName = "Extended_Price"; // field.Caption = "Extended Price"; // field.Area = PivotArea.DataArea; // field.AreaIndex = 0; //}); //pivotGridSettings.Fields.Add(field => { // field.FieldName = "CategoryName"; // field.Caption = "Category Name"; // field.Area = PivotArea.RowArea; // field.AreaIndex = 0; //}); //pivotGridSettings.Fields.Add(field => { // field.FieldName = "OrderDate"; // field.Caption = "Order Month"; // field.Area = PivotArea.ColumnArea; // field.AreaIndex = 0; // field.UnboundFieldName = "fieldOrderDate"; // field.GroupInterval = PivotGroupInterval.DateMonth; //}); //pivotGridSettings.PreRender = (sender, e) => { // int selectNumber = 4; // var field = ((MVCxPivotGrid)sender).Fields["Category Name"]; // object[] values = field.GetUniqueValues(); // List<object> includedValues = new List<object>(values.Length / selectNumber); // for (int i = 0; i < values.Length; i++) { // if (i % selectNumber == 0) // includedValues.Add(values[i]); // } // field.FilterValues.ValuesIncluded = includedValues.ToArray(); //}; pivotGridSettings.ClientSideEvents.BeginCallback = "OnBeforePivotGridCallback"; pivotGridSettings.ClientSideEvents.EndCallback = "UpdateChart"; return pivotGridSettings; }
static PivotGridSettings GetPivotGridSettings() { PivotGridSettings settings = new PivotGridSettings(); settings.Name = "pivotGrid"; settings.CallbackRouteValues = new { Controller = "Home", Action = "PivotGridPartial" }; settings.OptionsView.HorizontalScrollBarMode = DevExpress.Web.ScrollBarMode.Auto; settings.OptionsChartDataSource.ProvideDataByColumns = false; settings.Width = new System.Web.UI.WebControls.Unit(90, System.Web.UI.WebControls.UnitType.Percentage); settings.Groups.Add("Order Date"); settings.Fields.Add("Country", PivotArea.FilterArea); settings.Fields.Add("City", PivotArea.FilterArea); settings.Fields.Add(field => { field.Area = PivotArea.ColumnArea; field.FieldName = "OrderDate"; field.GroupInterval = PivotGroupInterval.DateYear; field.Caption = "Year"; field.GroupIndex = 0; }); settings.Fields.Add(field => { field.Area = PivotArea.ColumnArea; field.FieldName = "OrderDate"; field.GroupInterval = PivotGroupInterval.DateMonth; field.Caption = "Month"; field.GroupIndex = 0; field.InnerGroupIndex = 1; }); settings.Fields.Add(field => { field.Area = PivotArea.DataArea; field.FieldName = "Quantity"; field.Visible = false; }); settings.Fields.Add(field => { field.Area = PivotArea.DataArea; field.FieldName = "UnitPrice"; field.Visible = false; }); settings.Fields.Add(field => { field.Area = PivotArea.DataArea; field.FieldName = "Amount"; field.UnboundType = DevExpress.Data.UnboundColumnType.Decimal; field.UnboundExpression = "[UnitPrice]*[Quantity]"; field.Visible = true; }); settings.Fields.Add("ProductName", PivotArea.RowArea); settings.PreRender = (sender, e) => { ((MVCxPivotGrid)sender).CollapseAll(); var field = ((MVCxPivotGrid)sender).Fields["ProductName"]; object[] values = field.GetUniqueValues(); field.FilterValues.ValuesIncluded = values.Where(name => name.ToString().StartsWith("N")).ToArray(); }; settings.ClientSideEvents.BeginCallback = "OnBeforePivotGridCallback"; settings.ClientSideEvents.EndCallback = "UpdateChart"; return(settings); }
private static PivotGridSettings CreatePivotGridSettings() { PivotGridSettings settings = new PivotGridSettings { Name = "pivotGrid", CallbackRouteValues = new { Controller = "Report", Action = "PivotGridPartial" }, Width = new System.Web.UI.WebControls.Unit(99, System.Web.UI.WebControls.UnitType.Percentage) }; settings.Fields.Add(field => { field.Area = PivotArea.RowArea; field.FieldName = "ItemType"; field.Caption = IWSLocalResource.ItemType; field.AreaIndex = 1; }); settings.Fields.Add(field => { field.Area = PivotArea.RowArea; field.FieldName = "Owner"; field.Caption = IWSLocalResource.Owner; field.AreaIndex = 0; }); settings.Fields.Add(field => { field.Area = PivotArea.ColumnArea; field.FieldName = "TransDate"; field.Caption = IWSLocalResource.Year; field.GroupInterval = PivotGroupInterval.DateYear; field.AreaIndex = 0; }); settings.Fields.Add(field => { field.Area = PivotArea.FilterArea; field.FieldName = "TransDate"; field.Caption = IWSLocalResource.Quarter; field.GroupInterval = PivotGroupInterval.DateQuarter; field.AreaIndex = 1; }); settings.Fields.Add(field => { field.Area = PivotArea.RowArea; field.FieldName = "AccountName"; field.Caption = IWSLocalResource.account; field.AreaIndex = 2; }); settings.Fields.Add(field => { field.Area = PivotArea.DataArea; field.FieldName = "Amount"; field.Caption = IWSLocalResource.amount; field.AreaIndex = 0; }); settings.Fields.Add(field => { field.Area = PivotArea.FilterArea; field.FieldName = "Currency"; field.Caption = IWSLocalResource.Currency; field.AreaIndex = 0; }); settings.Fields.Add(field => { field.Area = PivotArea.FilterArea; field.FieldName = "Side"; field.Caption = IWSLocalResource.side; field.AreaIndex = 1; }); return(settings); }
static PivotGridSettings CreatePivotGridSettings() { PivotGridSettings settings = new PivotGridSettings(); settings.Name = "PivotGrid"; settings.CallbackRouteValues = new { Controller = "Cubo", Action = "PivotGridPartial" }; //settings.CustomActionRouteValues = new { Controller = "Home", Action = "PivotGridCustomCallback" }; settings.Width = System.Web.UI.WebControls.Unit.Percentage(100); settings.OptionsChartDataSource.ProvideDataByColumns = false; settings.CustomizationFieldsLeft = 600; settings.CustomizationFieldsTop = 400; settings.OptionsView.HorizontalScrollBarMode = ScrollBarMode.Auto; settings.OptionsView.VerticalScrollingMode = PivotScrollingMode.Virtual; settings.OptionsView.HorizontalScrollingMode = PivotScrollingMode.Virtual; settings.OptionsView.VerticalScrollBarMode = ScrollBarMode.Auto; settings.OptionsPager.RowsPerPage = 25; settings.OptionsPager.ColumnsPerPage = 15; settings.OptionsPager.Visible = false; settings.OptionsFilter.NativeCheckBoxes = false; settings.OptionsView.ShowColumnGrandTotals = true; settings.Fields.Add(field => { field.Area = PivotArea.FilterArea; field.AreaIndex = 0; field.Caption = "Cliente"; field.FieldName = "[Clientes].[Cliente].[Cliente]"; field.SortMode = PivotSortMode.None; }); settings.Fields.Add(field => { field.Area = PivotArea.FilterArea; field.AreaIndex = 1; field.Caption = "Provincia"; field.FieldName = "[Provincia].[Provincia].[Provincia]"; field.SortMode = PivotSortMode.None; }); settings.Fields.Add(field => { field.Area = PivotArea.FilterArea; field.AreaIndex = 2; field.Caption = "Producto"; field.FieldName = "[Producto].[Producto].[Producto]"; field.SortMode = PivotSortMode.None; }); settings.Fields.Add(field => { field.Area = PivotArea.FilterArea; field.AreaIndex = 3; field.Caption = "Unid Fact"; field.FieldName = "[Unidad de Facturacion].[Unid Fac].[Unid Fac]"; field.SortMode = PivotSortMode.None; }); settings.Fields.Add(field => { field.Area = PivotArea.FilterArea; field.AreaIndex = 4; field.Caption = "Categoría"; field.FieldName = "[Categorías de Cliente].[Categoría].[Categoría]"; field.SortMode = PivotSortMode.None; }); settings.Fields.Add(field => { field.Area = PivotArea.FilterArea; field.AreaIndex = 5; field.Caption = "Pais"; field.FieldName = "[País].[Pais].[Pais]"; field.SortMode = PivotSortMode.None; }); settings.Fields.Add(field => { field.Area = PivotArea.FilterArea; field.AreaIndex = 6; field.Caption = "Proceso"; field.FieldName = "[Proceso].[Proceso].[Proceso]"; field.SortMode = PivotSortMode.None; }); settings.Fields.Add(field => { field.Area = PivotArea.FilterArea; field.AreaIndex = 7; field.Caption = "Rubro"; field.FieldName = "[Rubro].[Rubro].[Rubro]"; field.SortMode = PivotSortMode.None; }); settings.Fields.Add(field => { field.Area = PivotArea.ColumnArea; field.AreaIndex = 0; field.Caption = "Unidad de Produccion"; field.FieldName = "[Unidad de Produccion].[Unid Prod].[Unid Prod]"; field.SortMode = PivotSortMode.None; }); settings.Fields.Add(field => { field.Area = PivotArea.RowArea; field.AreaIndex = 0; field.Caption = "Año"; field.FieldName = "[Fecha].[Jerarquía].[Año]"; field.SortMode = PivotSortMode.None; }); settings.Fields.Add(field => { field.Area = PivotArea.RowArea; field.AreaIndex = 1; field.Caption = "Mes"; field.FieldName = "[Fecha].[Jerarquía].[Mes]"; field.SortMode = PivotSortMode.None; }); settings.Fields.Add(field => { field.Area = PivotArea.RowArea; field.AreaIndex = 2; field.Caption = "Dia"; field.FieldName = "[Fecha].[Jerarquía].[Dia]"; field.SortMode = PivotSortMode.None; }); settings.Fields.Add(field => { field.Area = PivotArea.DataArea; field.AreaIndex = 0; field.Caption = "Importe"; field.FieldName = "[Measures].[Importe Tot Pesos]"; field.CellFormat.FormatString = "$#.##"; field.CellFormat.FormatType = FormatType.Custom; }); settings.Fields.Add(field => { field.Area = PivotArea.DataArea; field.AreaIndex = 1; field.Caption = "Precio Unit"; field.FieldName = "[Measures].[Precio Unit Pesos]"; field.CellFormat.FormatString = "${0:f2}"; field.CellFormat.FormatType = FormatType.Custom; field.Visible = false; }); settings.Fields.Add(field => { field.Area = PivotArea.DataArea; field.AreaIndex = 2; field.Caption = "Vol Equivalente"; field.FieldName = "[Measures].[Vol Equivalente]"; field.CellFormat.FormatString = "{0:f2}"; field.CellFormat.FormatType = FormatType.Custom; field.Visible = false; }); settings.Fields.Add(field => { field.Area = PivotArea.DataArea; field.AreaIndex = 3; field.Caption = "Unid Fisicas"; field.FieldName = "[Measures].[Unidades Fisicas]"; field.CellFormat.FormatString = "{0:f2}"; field.CellFormat.FormatType = FormatType.Custom; field.Visible = false; }); settings.Fields.Add(field => { field.Area = PivotArea.DataArea; field.AreaIndex = 4; field.Caption = "Precio Unit Promedio"; field.FieldName = "[Measures].[Precio Unitario Promedio]"; field.CellFormat.FormatString = "{0:f2}"; field.CellFormat.FormatType = FormatType.Custom; field.Visible = false; }); //settings.Name = "pivotGrid"; //settings.CallbackRouteValues = new { Controller = "Home", Action = "PivotGridPartial" }; //settings.CustomActionRouteValues = new { Controller = "Home", Action = "PivotGridCustomCallback" }; //settings.OptionsView.HorizontalScrollBarMode = DevExpress.Web.ScrollBarMode.Auto; //settings.OptionsChartDataSource.ProvideDataByColumns = false; //settings.Width = new System.Web.UI.WebControls.Unit(90, System.Web.UI.WebControls.UnitType.Percentage); //settings.ClientSideEvents.BeginCallback = "OnBeforePivotGridCallback"; //settings.ClientSideEvents.EndCallback = "UpdateChart"; //settings.Groups.Add("Order Date"); //settings.Fields.Add("Country", PivotArea.FilterArea); //settings.Fields.Add("City", PivotArea.FilterArea); //settings.Fields.Add(field => //{ // field.Area = PivotArea.ColumnArea; // field.FieldName = "OrderDate"; // field.GroupInterval = PivotGroupInterval.DateYear; // field.Caption = "Year"; // field.GroupIndex = 0; //}); //settings.Fields.Add(field => //{ // field.Area = PivotArea.ColumnArea; // field.FieldName = "OrderDate"; // field.GroupInterval = PivotGroupInterval.DateMonth; // field.Caption = "Month"; // field.GroupIndex = 0; // field.InnerGroupIndex = 1; //}); //settings.Fields.Add(field => //{ // field.Area = PivotArea.DataArea; // field.FieldName = "Quantity"; // field.Visible = false; //}); //settings.Fields.Add(field => //{ // field.Area = PivotArea.DataArea; // field.FieldName = "UnitPrice"; // field.Visible = false; //}); //settings.Fields.Add(field => //{ // field.Area = PivotArea.DataArea; // field.FieldName = "Amount"; // field.UnboundType = DevExpress.Data.UnboundColumnType.Decimal; // field.UnboundExpression = "[UnitPrice]*[Quantity]"; // field.Visible = true; //}); //settings.Fields.Add("ProductName", PivotArea.RowArea); //settings.PreRender = (sender, e) => //{ // ((MVCxPivotGrid)sender).CollapseAll(); // var field = ((MVCxPivotGrid)sender).Fields["ProductName"]; // object[] values = field.GetUniqueValues(); // field.FilterValues.ValuesIncluded = values.Where(name => name.ToString().StartsWith("N")).ToArray(); //}; //settings.CustomFieldValueCells = () settings.ClientSideEvents.EndCallback = "UpdateChart"; return(settings); }
static PivotGridSettings CreateCompactLayoutPivotGridSettings() { PivotGridSettings settings = new PivotGridSettings(); settings.Name = "pivotGrid"; settings.CallbackRouteValues = new { Controller = "PivotGrid", Action = "CompactLayoutPartial" }; settings.OptionsPager.NumericButtonCount = 7; settings.OptionsPager.RowsPerPage = 15; settings.OptionsView.ShowHorizontalScrollBar = true; settings.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Tree; settings.OptionsView.ShowTotalsForSingleValues = true; settings.OptionsView.ShowColumnHeaders = false; settings.OptionsView.ShowDataHeaders = false; settings.OptionsView.ShowFilterHeaders = false; settings.OptionsView.ShowRowHeaders = false; settings.Width = Unit.Pixel(400); settings.PivotCustomizationExtensionSettings.Name = "pivotCustomization"; settings.PivotCustomizationExtensionSettings.AllowedLayouts = CustomizationFormAllowedLayouts.BottomPanelOnly1by4 | CustomizationFormAllowedLayouts.BottomPanelOnly2by2 | CustomizationFormAllowedLayouts.StackedDefault | CustomizationFormAllowedLayouts.StackedSideBySide; settings.PivotCustomizationExtensionSettings.Layout = CustomizationFormLayout.BottomPanelOnly2by2; settings.PivotCustomizationExtensionSettings.AllowSort = true; settings.PivotCustomizationExtensionSettings.AllowFilter = true; settings.PivotCustomizationExtensionSettings.Height = Unit.Pixel(480); settings.PivotCustomizationExtensionSettings.Width = Unit.Pixel(400); settings.Fields.Add(field => { field.FieldName = "Country"; field.Area = PivotArea.RowArea; field.AreaIndex = 0; }); settings.Fields.Add(field => { field.Caption = "Category Name"; field.FieldName = "CategoryName"; field.Area = PivotArea.RowArea; field.AreaIndex = 1; }); settings.Fields.Add(field => { field.Caption = "Product Name"; field.FieldName = "ProductName"; field.Area = PivotArea.RowArea; field.AreaIndex = 2; }); settings.Fields.Add(field => { field.Caption = "Customer"; field.FieldName = "Sales_Person"; field.Area = PivotArea.RowArea; field.AreaIndex = 3; }); settings.Fields.Add(field => { field.Caption = "Order Year"; field.FieldName = "OrderDate"; field.Area = PivotArea.RowArea; field.AreaIndex = 4; field.GroupInterval = PivotGroupInterval.DateYear; }); settings.Fields.Add(field => { field.Caption = "Order Quarter"; field.FieldName = "OrderDate"; field.Area = PivotArea.RowArea; field.AreaIndex = 5; field.GroupInterval = PivotGroupInterval.DateQuarter; field.ValueFormat.FormatString = "Qtr {0}"; field.ValueFormat.FormatType = FormatType.Numeric; }); settings.Fields.Add("Quantity", PivotArea.DataArea); settings.Fields.Add("UnitPrice", PivotArea.FilterArea); settings.PreRender = (sender, e) => { MVCxPivotGrid pivotGrid = (MVCxPivotGrid)sender; pivotGrid.CollapseAll(); pivotGrid.ExpandValue(false, new object[] { "UK" }); pivotGrid.ExpandValue(false, new object[] { "UK", "Condiments" }); pivotGrid.ExpandValue(false, new object[] { "UK", "Condiments", "Chef Anton's Cajun Seasoning" }); pivotGrid.ExpandValue(false, new object[] { "UK", "Condiments", "Chef Anton's Cajun Seasoning", "Robert King" }); pivotGrid.ExpandValue(false, new object[] { "UK", "Condiments", "Chef Anton's Cajun Seasoning", "Robert King", 1996 }); pivotGrid.ExpandValue(false, new object[] { "UK", "Condiments", "Chef Anton's Cajun Seasoning", "Robert King", 1997 }); pivotGrid.ExpandValue(false, new object[] { "UK", "Condiments", "Genen Shouyu" }); pivotGrid.ExpandValue(false, new object[] { "UK", "Condiments", "Genen Shouyu", "Michael Suyama" }); }; return(settings); }
public PivotGridSettings CreateSetting( string statid, int id) { var settings = new PivotGridSettings{ Name = "pivotGrid",CallbackRouteValues = new { Controller = "Reports", Action = "GetPivotLogsByCategory", categoryid = id,statcategoryid = statid }, Width = Unit.Percentage(99) }; settings.OptionsView.ShowHorizontalScrollBar = true; settings.OptionsView.HideAllTotals(); settings.OptionsPager.Position = PagerPosition.Bottom; settings.OptionsView.ShowFilterHeaders = false; // settings.OptionsPager.RowsPerPage = 15; // settings.OptionsView.ShowRowHeaders = true; settings.Fields.Add(field => { field.Area = PivotArea.RowArea; field.AreaIndex = 0; field.FieldName = "CategoryName"; field.Caption = "类别"; field.ValueStyle.VerticalAlign = VerticalAlign.Middle; }); settings.Fields.Add(field => { field.Area = PivotArea.RowArea; field.AreaIndex = 1; field.FieldName = "ItemNo"; field.Caption = "序号"; // field.UnboundType = UnboundColumnType.Integer; }); settings.Fields.Add(field => { field.Area = PivotArea.RowArea; field.AreaIndex = 2; field.FieldName = "ErpCode"; field.Caption = "Erp编码"; }); settings.Fields.Add(field => { field.Area = PivotArea.RowArea; field.AreaIndex = 3; field.FieldName = "Name"; field.Caption = "项目名称"; }); if (statid.StartsWith("2")) { settings.Fields.Add(field => { field.Area = PivotArea.RowArea; field.AreaIndex = 4; field.FieldName = "PlanYear"; field.Caption = "实施年度"; }); settings.Fields.Add(field => { field.Area = PivotArea.RowArea; field.AreaIndex = 5; field.FieldName = "Xjsgs"; field.Caption = "项建书估算(万元)"; }); settings.Fields.Add(field => { field.Area = PivotArea.RowArea; field.AreaIndex = 6; field.FieldName = "Kygs"; field.Caption = "可研估算(万元)"; }); } settings.Fields.Add(field => { field.Area = PivotArea.ColumnArea; field.AreaIndex = 0; field.FieldName = "StageName"; field.Caption = "阶段"; }); if (id != 0) { settings.Fields.Add(field => { field.Area = PivotArea.ColumnArea; field.AreaIndex = 1; field.FieldName = "NodeName"; field.Caption = "管控节点"; }); } settings.Fields.Add(field => { field.Area = PivotArea.DataArea; field.AreaIndex = 0; field.FieldName = "PlanStartDate"; field.SummaryType = PivotSummaryType.Min; field.Caption = "计划开始"; field.CellFormat.FormatType = FormatType.Custom; field.CellFormat.FormatString = ("yyyy.MM.dd"); field.ExportBestFit = true; }); settings.Fields.Add(field => { field.Area = PivotArea.DataArea; field.AreaIndex = 1; field.FieldName = "PlanEndDate"; field.SummaryType = PivotSummaryType.Max; field.Caption = "计划完成"; field.CellFormat.FormatType = FormatType.Custom; field.CellFormat.FormatString = ("yyyy.MM.dd"); field.ExportBestFit = true; }); settings.Fields.Add(field => { field.Area = PivotArea.DataArea; field.AreaIndex = 2; field.FieldName = "DateBeginOn"; field.SummaryType = PivotSummaryType.Min; field.Caption = "实际开始"; field.CellFormat.FormatType = FormatType.Custom; field.CellFormat.FormatString = ("yyyy.MM.dd"); field.EmptyCellText = "----------"; field.ExportBestFit = true; }); settings.Fields.Add(field => { field.Area = PivotArea.DataArea; field.AreaIndex = 3; field.FieldName = "DateEndOn"; field.SummaryType = PivotSummaryType.Max; field.Caption = "实际完成"; field.CellFormat.FormatType = FormatType.Custom; field.CellFormat.FormatString = ("yyyy.MM.dd"); field.EmptyCellText = "----------"; field.ExportBestFit = true; }); // settings.OptionsView.ShowColumnHeaders = false; // Event: Custom DisplayText settings.FieldValueDisplayText = (sender, e) => { if (e.Value == null) return; if (e.IsColumn) { if (e.Field.ID == "fieldStageName") e.DisplayText = e.Value.ToString().Substring(1); if (e.Field.ID == "fieldNodeName" && e.Value.ToString().Substring(1, 1) == ".") e.DisplayText = e.Value.ToString().Substring(3); } }; settings.SettingsExport.OptionsPrint.PrintColumnHeaders = DefaultBoolean.False; settings.SettingsExport.OptionsPrint.PrintDataHeaders = DefaultBoolean.False; settings.SettingsExport.OptionsPrint.PrintRowHeaders = DefaultBoolean.True; settings.SettingsExport.OptionsPrint.PrintHeadersOnEveryPage = true; return settings; }
static PivotGridSettings GetSettings() { PivotGridSettings settings = new PivotGridSettings(); settings.Name = "PivotGrid"; settings.CallbackRouteValues = new { Controller = "Report", Action = "_PivotAccountsGridPartial" }; settings.OptionsView.HorizontalScrollBarMode = DevExpress.Web.ScrollBarMode.Visible; settings.Width = new System.Web.UI.WebControls.Unit(90, System.Web.UI.WebControls.UnitType.Percentage); settings.SettingsExport.OptionsPrint.PrintColumnAreaOnEveryPage = true; settings.SettingsExport.OptionsPrint.PrintRowAreaOnEveryPage = true; settings.SettingsExport.OptionsPrint.PageSettings.Landscape = true; settings.SettingsExport.CustomExportCell = (sender, e) => { // Determine whether the cell is Grand Total. if ((e.ColumnField == null) || (e.RowField == null)) { // Specify the text to display in a cell. ((DevExpress.XtraPrinting.TextBrick)e.Brick).Text = string.Format( "=> {0}", ((DevExpress.XtraPrinting.TextBrick)e.Brick).Text); // Specify the colors used to paint the cell. e.Appearance.BackColor = Color.Gray; e.Appearance.ForeColor = Color.Orange; return; } MVCxPivotGrid pivot = ((MVCxPivotGridExporter)sender).PivotGrid as MVCxPivotGrid; int lastRowFieldIndex = pivot.Fields.GetVisibleFieldCount(PivotArea.RowArea) - 1; int lastColumnFieldIndex = pivot.Fields.GetVisibleFieldCount(PivotArea.ColumnArea) - 1; // Determine whether the cell is an ordinary cell. if (e.RowField.AreaIndex == lastRowFieldIndex && e.ColumnField.AreaIndex == lastColumnFieldIndex) { e.Appearance.ForeColor = Color.Gray; } // The cell is a Total cell. else { e.Appearance.BackColor = Color.DarkOliveGreen; e.Appearance.ForeColor = Color.White; } }; settings.SettingsExport.CustomExportFieldValue = (sender, e) => { if (e.Field != null) { if (e.Field.FieldName == "ProductName") { e.Brick.Url = String.Format("https://www.google.com/search?q={0}", e.Text); ((DevExpress.XtraPrinting.TextBrick)e.Brick).Target = "_blank"; } if (e.Field.FieldName == "Country" && e.Text == "USA") { DevExpress.XtraPrinting.ImageBrick imBrick = new DevExpress.XtraPrinting.ImageBrick(); imBrick.Image = Image.FromFile(HttpContext.Current.Server.MapPath("~/Content/us.png")); imBrick.SizeMode = DevExpress.XtraPrinting.ImageSizeMode.AutoSize; e.Brick = imBrick; } } }; settings.Fields.Add(field => { field.Area = PivotArea.RowArea; field.FieldName = "CategoryName"; field.Caption = "Category"; field.AreaIndex = 0; }); settings.Fields.Add(field => { field.Area = PivotArea.ColumnArea; field.FieldName = "Country"; field.Caption = "Country"; field.AreaIndex = 0; }); settings.Fields.Add(field => { field.Area = PivotArea.DataArea; field.FieldName = "Extended Price"; field.Caption = "Extended_Price"; field.AreaIndex = 0; }); settings.Fields.Add(field => { field.Area = PivotArea.RowArea; field.FieldName = "ProductName"; field.Caption = "Product Name"; field.AreaIndex = 1; }); settings.Fields.Add(field => { field.Area = PivotArea.ColumnArea; field.FieldName = "Sales Person"; field.Caption = "Sales Person"; field.AreaIndex = 1; }); return(settings); }
public PivotGridSettings CreatePivotGridSettings() { PivotGridSettings settings = new PivotGridSettings(); settings.Name = "journalPivotGrid"; settings.CallbackRouteValues = new { Controller = "Information", Action = "MarksPagePartial" }; //settings.CustomActionRouteValues = new { Controller = "Journal", Action = "CustomActionSampleReportsPartial" }; settings.Width = Unit.Percentage(100); settings.OptionsView.ShowHorizontalScrollBar = true; settings.CustomGroupInterval += OnCustomGroupInterval; settings.CustomUnboundFieldData += OnCustomUnboundFieldData; settings.CustomCellValue += OnCustomCellValue; settings.ClientSideEvents.BeginCallback = "OnJournalGridBeginCallback"; settings.Styles.CellStyle.Cursor = "pointer"; settings.OptionsPager.RowsPerPage = 50; settings.Fields.Add(field => { field.Area = PivotArea.RowArea; field.AreaIndex = 0; field.UnboundExpression = "Concat([Pupil.UserDetails.LastName], ' ', [Pupil.UserDetails.FirstName], ' ', [Pupil.UserDetails.PatronymicName])"; field.UnboundType = UnboundColumnType.String; field.Caption = "Имя ученика"; }); settings.Fields.Add(field => { field.Area = PivotArea.RowArea; field.AreaIndex = 1; field.FieldName = "ConcreteLesson.JournalLesson.SubjectID"; field.Caption = "Предмет"; }); settings.Fields.Add(field => { field.Area = PivotArea.ColumnArea; field.AreaIndex = 0; field.FieldName = "ConcreteLesson.Date"; field.Caption = "Четверть"; field.GroupInterval = PivotGroupInterval.Custom; field.SummaryType = PivotSummaryType.Average; field.GrandTotalText = "Среднее"; }); settings.Fields.Add(field => { field.Area = PivotArea.ColumnArea; field.AreaIndex = 1; field.FieldName = "ConcreteLesson.Date"; field.Caption = "Месяц"; field.GroupInterval = PivotGroupInterval.DateMonth; field.TotalsVisibility = PivotTotalsVisibility.None; }); settings.Fields.Add(field => { field.Area = PivotArea.ColumnArea; field.AreaIndex = 2; field.FieldName = "ConcreteLesson.Date"; field.Caption = "Дата"; field.GroupInterval = PivotGroupInterval.Date; field.ValueFormat.FormatType = FormatType.DateTime; field.ValueFormat.FormatString = "dd"; }); settings.Fields.Add(field => { field.Visible = true; field.Area = PivotArea.DataArea; field.AreaIndex = 0; field.Caption = "Оценка"; field.UnboundType = UnboundColumnType.Object; field.EmptyCellText = string.Empty; field.EmptyValueText = string.Empty; field.FieldName = "Mark1"; field.SummaryType = PivotSummaryType.Average; //field.UnboundExpression //field.UnboundType = UnboundColumnType.String; field.CellFormat.FormatString = "{0:0.##}"; field.CellFormat.FormatType = FormatType.Numeric; }); //settings.PreRender = (sender, e) => { // UpdatePivotGridLayout((MVCxPivotGrid)sender); //}; //settings.BeforeGetCallbackResult = (sender, e) => { // if (ViewBag.IsReloadLayout != null && ViewBag.IsReloadLayout) // UpdatePivotGridLayout((MVCxPivotGrid)sender); //}; return settings; }
private static PivotGridSettings CreateLayoutPivotGridSettings(AvrPivotGridModel model) { var settings = new PivotGridSettings(); bool readOnly = model.PivotSettings.IsPublished | !AvrPermissions.UpdatePermission; settings.Name = "pivotGrid"; settings.CallbackRouteValues = new { Controller = "Layout", Action = "PivotGridPartial", //queryId = model.PivotSettings.QueryId, layoutId = model.PivotSettings.LayoutId }; settings.CustomActionRouteValues = new { Controller = "Layout", Action = "PivotGridPartial", //queryId = model.PivotSettings.QueryId, layoutId = model.PivotSettings.LayoutId }; settings.OptionsView.HorizontalScrollBarMode = model.PivotSettings.FreezeRowHeaders ? ScrollBarMode.Auto : ScrollBarMode.Hidden; if (model.PivotSettings.FreezeRowHeaders) { settings.Width = Unit.Percentage(99); } settings.OptionsView.ShowFilterHeaders = false; settings.OptionsView.ShowColumnHeaders = true; settings.OptionsView.ShowRowHeaders = true; settings.OptionsView.DataHeadersDisplayMode = PivotDataHeadersDisplayMode.Popup; settings.OptionsView.DataHeadersPopupMaxColumnCount = 3; //settings.OptionsDataField.RowHeaderWidth = 100; settings.OptionsPager.Position = PagerPosition.Bottom; settings.OptionsPager.RowsPerPage = BaseSettings.AvrRowsPerPage; // note: this option disables paging. commented by Ivan because of out of memory // settings.OptionsPager.Visible = false; settings.OptionsBehavior.BestFitMode = PivotGridBestFitMode.FieldValue; // PivotGridBestFitMode.Cell; settings.CustomLoadCallbackState = CustomLoadCallbackState; settings.OptionsCustomization.AllowDrag = !readOnly; settings.OptionsCustomization.AllowExpand = !readOnly; settings.OptionsCustomization.AllowDragInCustomizationForm = true; settings.OptionsCustomization.AllowHideFields = AllowHideFieldsType.Always; settings.OptionsCustomization.CustomizationFormStyle = CustomizationFormStyle.Simple; settings.OptionsCustomization.AllowCustomizationForm = !readOnly; SetTotalSettings(settings.OptionsView, model.PivotSettings); if (!readOnly) { settings.PivotCustomizationExtensionSettings.Name = "pivotCustomization"; settings.PivotCustomizationExtensionSettings.Enabled = true; settings.PivotCustomizationExtensionSettings.Visible = true; settings.PivotCustomizationExtensionSettings.AllowedLayouts = CustomizationFormAllowedLayouts.TopPanelOnly; settings.PivotCustomizationExtensionSettings.Layout = CustomizationFormLayout.TopPanelOnly; settings.PivotCustomizationExtensionSettings.AllowSort = true; settings.PivotCustomizationExtensionSettings.AllowFilter = false; settings.PivotCustomizationExtensionSettings.Height = Unit.Percentage(100); settings.PivotCustomizationExtensionSettings.Width = Unit.Percentage(100); } settings.OptionsCustomization.AllowPrefilter = false; settings.Prefilter.Enabled = false; settings.OptionsView.EnableFilterControlPopupMenuScrolling = true; settings.Prefilter.Criteria = CriteriaOperator.TryParse(model.PivotSettings.FilterCriteriaString); settings.Styles.PrefilterBuilderCloseButtonStyle.CssClass = "invisible"; settings.Styles.PrefilterBuilderHeaderStyle.CssClass = "roundbox"; settings.PopupMenuCreated += PopupMenuCreated; settings.Styles.PrefilterBuilderMainAreaStyle.CssClass = "filterwindow"; settings.FilterControlOperationVisibility = (sender, args) => { WebPivotGridField webField = GetWebPivotGridFieldByName(model.PivotSettings.Fields, args.PropertyInfo.PropertyName); if (webField == null) { args.Visible = false; return; } switch (webField.SearchFieldType) { case SearchFieldType.ID: //lookup args.Visible = IsValidLookupClause(args.Operation); break; case SearchFieldType.String: args.Visible = IsValidStringClause(args.Operation); break; case SearchFieldType.Date: args.Visible = IsValidDateClause(args.Operation); break; default: args.Visible = IsValidDefaultClause(args.Operation); break; } }; settings.FilterControlCustomValueDisplayText = (sender, args) => { if (args.Value == null) { args.DisplayText = Translator.GetMessageString("FilterConrol_EmptyEnter"); } else if (args.PropertyInfo.PropertyType == typeof(DateTime)) { args.DisplayText = string.Format("{0:d}", args.Value); } }; settings.OptionsCustomization.AllowFilterInCustomizationForm = true; settings.Theme = GeneralSettings.Theme; settings.Fields.Clear(); foreach (WebPivotGridField webField in model.PivotSettings.Fields.Where(f => f.Visible && f.Area != PivotArea.FilterArea).OrderBy(f => (long)f.Area * 100000 + f.AreaIndex)) { settings.Fields.Add(webField); } foreach (WebPivotGridField webField in model.PivotSettings.Fields.Where(f => !f.Visible || f.Area == PivotArea.FilterArea).OrderBy(f => f.Caption)) { settings.Fields.Add(webField); } settings.Init = (sender, args) => { var pivotGrid = (MVCxPivotGrid)sender; if (model.ShowingPrefilter) { pivotGrid.PrefilterCriteriaChanged += PrefilterCriteriaChanged; } pivotGrid.FieldAreaChanged += PivotGridOnFieldAreaChanged; pivotGrid.HeaderTemplate = new HeaderTemplate(model); }; settings.PreRender = (sender, e) => { var pivotGrid = (MVCxPivotGrid)sender; pivotGrid.BeginUpdate(); pivotGrid.HeaderTemplate = new HeaderTemplate(model); pivotGrid.EndUpdate(); }; settings.BeforeGetCallbackResult = (sender, e) => { var pivotGrid = (MVCxPivotGrid)sender; if (model.ShowPrefilter) { pivotGrid.IsPrefilterPopupVisible = true; CriteriaOperator criteria = CriteriaOperator.TryParse(model.PivotSettings.FilterCriteriaString); criteria = ValidatePrefilterCriteria(criteria); pivotGrid.Prefilter.Criteria = criteria; model.ShowPrefilter = false; model.ShowingPrefilter = true; return; } model.ShowingPrefilter = false; pivotGrid.BeginUpdate(); try { pivotGrid.Prefilter.Enabled = false; UpdatePivotGridField(pivotGrid, model); model.PivotSettings.UpdatedField = null; if (model.PivotSettings.UpdateGroupInterval) { PivotGroupInterval interval = GroupIntervalHelper.GetGroupInterval(model.PivotSettings.DefaultGroupInterval); SetInterval(pivotGrid, interval); model.PivotSettings.UpdateGroupInterval = false; } SetTotalSettings(pivotGrid.OptionsView, model.PivotSettings); pivotGrid.OptionsView.HorizontalScrollBarMode = model.PivotSettings.FreezeRowHeaders ? ScrollBarMode.Auto : ScrollBarMode.Hidden; if (model.PivotSettings.FreezeRowHeaders) { pivotGrid.Width = Unit.Percentage(99); } else { pivotGrid.Width = Unit.Empty; } pivotGrid.ReloadData(); } finally { pivotGrid.EndUpdate(); } }; //settings.ClientSideEvents.EndCallback = "layoutPivotGrid.resizePivotGridEvent"; settings.AfterPerformCallback = (sender, e) => { var pivotGrid = (MVCxPivotGrid)sender; if (pivotGrid.HeaderTemplate == null) { pivotGrid.HeaderTemplate = new HeaderTemplate(model); } //pivotGrid.BeginUpdate(); //pivotGrid.ReloadData(); //pivotGrid.EndUpdate(); }; settings.ClientSideEvents.CallbackError = "layoutPivotGrid.onCallbackError"; settings.ClientSideEvents.EndCallback = "layoutPivotGrid.onEndCallback"; settings.CustomCellDisplayText = (sender, e) => { InitDisplayTexthandler(); m_DisplayTextHandler.DisplayAsterisk(new WebPivotCellDisplayTextEventArgs(e)); if (e.DataField == null) { return; } if (model.PivotSettings.FieldsDictionary.ContainsKey(e.DataField.FieldName)) { WebPivotGridField field = model.PivotSettings.FieldsDictionary[e.DataField.FieldName]; m_DisplayTextHandler.DisplayCellText(new WebPivotCellDisplayTextEventArgs(e), field.CustomSummaryType, field.Precision); } }; settings.FieldValueDisplayText = (sender, e) => { InitDisplayTexthandler(); var eventArgs = new WebPivotFieldDisplayTextEventArgs(e); m_DisplayTextHandler.DisplayAsterisk(eventArgs); m_DisplayTextHandler.DisplayBool(eventArgs); if (m_CustomSummaryHandler == null) { var helper = new AvrPivotGridHelperWeb((ASPxPivotGrid)sender) { SingleSearchObject = model.PivotSettings.IsSingleSearchObject }; m_CustomSummaryHandler = new CustomSummaryHandler(helper); } var summaryTypes = new List <CustomSummaryType>(); List <IAvrPivotGridField> dataFields = AvrPivotGridHelper.GetFieldCollectionFromArea(model.PivotSettings.Fields, PivotArea.DataArea); foreach (IAvrPivotGridField field in dataFields) { summaryTypes.Add(field.CustomSummaryType); m_DisplayTextHandler.DisplayStatisticsTotalCaption(eventArgs, summaryTypes); } }; settings.CustomSummary = (sender, e) => { if (m_CustomSummaryHandler == null) { var helper = new AvrPivotGridHelperWeb((ASPxPivotGrid)sender); m_CustomSummaryHandler = new CustomSummaryHandler(helper); } WebPivotGridField settingsField = model.PivotSettings.Fields.Find(f => f.FieldName == e.DataField.FieldName); var field = e.DataField as IAvrPivotGridField; if (settingsField != null && field != null && ((int)field.CustomSummaryType <= 0)) { field.CustomSummaryType = settingsField.CustomSummaryType; field.BasicCountFunctionId = settingsField.BasicCountFunctionId; field.AggregateFunctionId = settingsField.AggregateFunctionId; field.UnitLayoutSearchFieldId = settingsField.UnitLayoutSearchFieldId; field.UnitSearchFieldAlias = settingsField.UnitSearchFieldAlias; field.SearchFieldDataType = settingsField.SearchFieldDataType; field.DefaultGroupInterval = settingsField.DefaultGroupInterval; field.Ordinal = settingsField.Ordinal; field.AddMissedValues = settingsField.AddMissedValues; field.DiapasonStartDate = settingsField.DiapasonStartDate; field.DiapasonEndDate = settingsField.DiapasonEndDate; field.Precision = settingsField.Precision; field.AggregateFunctionId = settingsField.AggregateFunctionId; field.BasicCountFunctionId = settingsField.BasicCountFunctionId; field.UnitLayoutSearchFieldId = settingsField.UnitLayoutSearchFieldId; field.UnitSearchFieldAlias = settingsField.UnitSearchFieldAlias; field.DateLayoutSearchFieldId = settingsField.DateLayoutSearchFieldId; field.DateSearchFieldAlias = settingsField.DateSearchFieldAlias; if (settingsField.IsDateTimeField) { field.GroupInterval = settingsField.DefaultGroupInterval; } field.AllowMissedReferenceValues = settingsField.AllowMissedReferenceValues; field.LookupTableName = settingsField.LookupTableName; field.GisReferenceTypeId = settingsField.GisReferenceTypeId; field.ReferenceTypeId = settingsField.ReferenceTypeId; field.LookupAttributeName = settingsField.LookupAttributeName; field.HaCode = settingsField.HaCode; field.AllPivotFields = settingsField.AllPivotFields; field.FieldNamesDictionary = settingsField.FieldNamesDictionary; } m_CustomSummaryHandler.OnCustomSummary(sender, new WebPivotGridCustomSummaryEventArgs(e)); }; settings.CustomCellStyle = (sender, args) => { var pivotGrid = (MVCxPivotGrid)sender; }; settings.HtmlCellPrepared = (sender, args) => { var pivotGrid = (MVCxPivotGrid)sender; }; settings.HtmlFieldValuePrepared = (sender, args) => { var pivotGrid = (MVCxPivotGrid)sender; }; settings.GridLayout = (sender, args) => { var pivotGrid = (MVCxPivotGrid)sender; model.PivotSettings.HasChanges = true; var fieldsToDelete = new List <PivotGridFieldBase>(); foreach (PivotGridField field in pivotGrid.Fields) { WebPivotGridField webField = GetWebPivotGridFieldByFieldName(model.PivotSettings.Fields, field.FieldName); if (webField != null) { PivotFieldItemBase visualField = pivotGrid.Fields.Data.VisualItems.Data.FieldItems.SingleOrDefault( s => s.FieldName == field.FieldName); Dbg.Assert(visualField != null, "field {0} is not found in pivot fields list", field.FieldName); if (!visualField.Visible && visualField.Area != PivotArea.FilterArea) { webField.Area = PivotArea.FilterArea; webField.AreaIndex = -1; webField.FilterValues.Clear(); webField.SortOrder = field.SortOrder; webField.Width = field.Width; ClearMissedValues(webField); } else { webField.Area = field.Area; webField.AreaIndex = field.AreaIndex; webField.Visible = field.Visible; webField.SortOrder = field.SortOrder; webField.Width = field.Width; webField.FilterValues.Assign(field.FilterValues); //if (webField.IsDateTimeField && webField.GroupInterval == PivotGroupInterval.Default) //{ // webField.DefaultGroupInterval = GroupIntervalHelper.GetGroupInterval(model.PivotSettings.DefaultGroupInterval); // field.GroupInterval = webField.GroupInterval; //} } } else { fieldsToDelete.Add(field); } } foreach (PivotGridFieldBase field in fieldsToDelete) { field.Visible = false; field.Area = PivotArea.FilterArea; field.AreaIndex = -1; pivotGrid.Fields.Remove(field); } //if (model.PivotSettings.ShowMissedValues) //{ // List<IAvrPivotGridField> fields = model.PivotSettings.Fields.Cast<IAvrPivotGridField>().ToList(); // AvrPivotGridHelper.AddMissedValuesInRowColumnArea(model, fields); //} if (fieldsToDelete.Count > 0) { pivotGrid.ReloadData(); } }; return(settings); }
public static PivotGridSettings CreatePivotGridSettings() { PivotGridSettings settings = new PivotGridSettings(); settings.Name = "BaoCao_" + DateTime.Now.ToString("dd-MM-yyyy HH:mm:ss"); settings.CallbackRouteValues = new { Controller = "Pivot", Action = "_PivotPartialView" }; settings.OptionsView.ShowHorizontalScrollBar = true; settings.Width = System.Web.UI.WebControls.Unit.Percentage(100); #region // Xác định các field //Fillter settings.Fields.Add(filed => { filed.Area = DevExpress.XtraPivotGrid.PivotArea.FilterArea; filed.FieldName = "UnitName"; filed.Caption = "Tên khách hàng"; // Tên hiển thị fillter }); //Giá trị vùng dữ liệu settings.Fields.Add(filed => { filed.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; filed.FieldName = "COGS"; filed.Caption = "Giá bán"; //filed.ValueFormat.FormatType = FormatType.Custom; //filed.ValueFormat.FormatString = "c"; filed.CellFormat.FormatType = FormatType.Numeric; filed.CellFormat.FormatString = "{0:n0} VNĐ"; }); // Dòng dữ liệu settings.Fields.Add(filed => { filed.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; filed.AreaIndex = 0; filed.FieldName = "CategoryName"; filed.Caption = "Loại sản phẩm"; }); settings.Fields.Add(filed => { filed.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; filed.AreaIndex = 1; filed.FieldName = "ProductName"; filed.Caption = "Tên sản phẩm"; }); //cột dữ liệu settings.Fields.Add(filed => { filed.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; filed.FieldName = "CreatedDate"; filed.Caption = "Năm"; filed.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateYear; }); settings.Fields.Add(filed => { filed.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; filed.FieldName = "CreatedDate"; filed.Caption = "Quý"; filed.GroupInterval = DevExpress.XtraPivotGrid.PivotGroupInterval.DateQuarter; filed.ValueFormat.FormatType = FormatType.Numeric; filed.ValueFormat.FormatString = "Quý {0}"; }); #endregion settings.PreRender = (sender, e) => { MVCxPivotGrid PivotGrid = sender as MVCxPivotGrid; if (System.Web.HttpContext.Current.Session["Layout"] != null) { PivotGrid.LoadLayoutFromString((string)System.Web.HttpContext.Current.Session["Layout"], PivotGridWebOptionsLayout.DefaultLayout); } PivotGrid.CollapseAll(); }; settings.GridLayout = (sender, e) => { MVCxPivotGrid PivotGrid = sender as MVCxPivotGrid; System.Web.HttpContext.Current.Session["Layout"] = PivotGrid.SaveLayoutToString(PivotGridWebOptionsLayout.DefaultLayout); }; return(settings); }