• WinForms界面开发技巧放送——如何将Pivot Grid用作主筛选器项


    下载DevExpress v20.2完整版

    DevExpress技术交流群2:775869749      欢迎一起进群讨论

    DevExpress WinForms能完美构建流畅、美观且易于使用的应用程序,无论是Office风格的界面,还是分析处理大批量的业务数据,它都能轻松胜任!

    先决条件
    • 平台:Business Intelligence
    • 产品:WinForms Dashboard

    本文演示如何使用Pivot dashboard项目像单选主过滤器项目一样运行,此方法使用以下功能:按仪表板参数进行过滤、对基础控件的访问,条件格式设置以及用于访问基础数据的API方法。

    1. 在要用于过滤的Pivot item中创建一组与尺寸对应的仪表盘参数,本文使用四个参数:ProductParam、CategoryParam、CountryParam和CityParam,它们对应于按Periods Pivot item的Product Amount行和列部分中使用的Product、Category、Country和City。

    2. 处理DashboardDesigner.DashboardItemClick 事件,来从clicked元素获取尺寸的值,并将其传递给仪表盘参数。

    C#

    void OnDashboardItemClick(object sender, DashboardItemMouseActionEventArgs e) {
    if(e.DashboardItemName == "pivotDashboardItem1" && !skipFiltering) {
    dashboardDesigner1.BeginUpdateParameters();
    //clear all parameters
    ClearPivotFilter();
    //set selected columns and rows to parameters
    SetParameterValue(e.GetAxisPoint("Column"));
    SetParameterValue(e.GetAxisPoint("Row"));
    dashboardDesigner1.EndUpdateParameters();
    }
    }

    skipFiltering变量指示是否按下Expand / Collapse 按钮,在这种情况下,该变量用于跳过设置过滤器。

    3. 上面的代码段未设置或清除单击元素无法访问的尺寸值,您需要设置仅与所选相交点对应的参数值,并在设置新的值之前清除仪表盘参数中的先前值。

    创建以下用于清除参数值的方法:

    C#

    void ClearPivotFilter() {
    PivotDashboardItem pivotItem = dashboardDesigner1.Dashboard.Items["pivotDashboardItem1"] as PivotDashboardItem;
    ClearParameters(pivotItem.Columns);
    ClearParameters(pivotItem.Rows);
    }
    
    void ClearParameters(DimensionCollection dimensions) {
    foreach(var dimension in dimensions)
    dashboardDesigner1.Parameters[GetParameterDataMember(dimension.DataMember)].SelectedValue = null;
    }

    4. 当最终用户单击行或列中的 Expand / Collapse按钮时,Dashboard Designer将引发DashboardDesigner.DashboardItemClick事件,处理DashboardDesigner.DashboardItemControlCreated事件来在这种情况下跳过设置过滤器。

    C#

    bool skipFiltering = false;
    private void dashboardDesigner1_DashboardItemControlCreated(object sender, DevExpress.DashboardWin.DashboardItemControlEventArgs e) {
    if(e.DashboardItemName == "pivotDashboardItem1") {
    e.PivotGridControl.MouseDown += PivotGridControl_MouseDown;
    }
    }
    
    private void PivotGridControl_MouseDown(object sender, MouseEventArgs e) {
    PivotGridControl pivot = sender as PivotGridControl;
    PivotGridHitInfo hi = pivot.CalcHitInfo(e.Location);
    skipFiltering = (hi.ValueInfo != null && hi.ValueInfo.ValueHitTest == PivotGridValueHitTest.ExpandButton);
    }

    5. 要通过与Pivot Item相关的仪表盘参数筛选其仪表盘项时,请向这些项添加所有必须的尺寸。如果不想向最终用户显示尺寸,请将尺寸放置到"Hidden Dimensions" 部分。

    然后将以下过滤器表达式添加到仪表盘项目:

    Code

    ([Dimension1] = ?Dimension1Param Or ?Dimension1Param Is Null) And
    ([Dimension2] = ?Dimension2Param Or ?Dimension2Param Is Null) And
    ...
    ([DimensionN] = ?DimensionNParam Or ?DimensionNParam Is Null)

    本示例使用以下表达式:

    Code

    ([Product] = ?ProductParam Or ?ProductParam Is Null)
    And ([Category] = ?CategoryParam Or ?CategoryParam Is Null)
    And ([Country] = ?CountryParam Or ?CountryParam Is Null)
    And ([City] = ?CityParam Or ?CityParam Is Null)

    上面的步骤足以实现最少的过滤功能,进一步的步骤将改善UI操作。

    1. Optional. To 突出显示在Pivot Grid中选择的单元格,请使用以下表达式添加格式规则:

    (?CityParam Is Not Null Or ?CountryParam Is Not Null Or ?ProductParam Is Not Null Or ?CategoryParam Is Not Null) And ([Product] = ?ProductParam Or ?ProductParam Is Null) And ([Category] = ?CategoryParam Or ?CategoryParam Is Null) And ([Country] = ?CountryParam Or ?CountryParam Is Null) And ([City] = ?CityParam Or ?CityParam Is Null)

    2. Optional. 处理DashboardDesigner.CustomizeDashboardItemCaption事件,将Clear Master Filter按钮添加到该项目的标题:

    C#

    void OnCustomizeDashboardItemCaption(object sender, CustomizeDashboardItemCaptionEventArgs e) {
    if(e.DashboardItemName == "pivotDashboardItem1") {
    DashboardToolbarItem showDataItem = new DashboardToolbarItem("Clear Master Filter",
    new Action((args) => {
    dashboardDesigner1.BeginUpdateParameters();
    ClearPivotFilter();
    dashboardDesigner1.EndUpdateParameters();
    }));
    showDataItem.Enabled = IsAnyFilterSet();
    showDataItem.SvgImage = svgImageCollection1[0];
    e.Items.Insert(0, showDataItem);
    }
    }

    上DevExpress中文网,获取第一手最新产品资讯!

  • 相关阅读:
    59. Spiral Matrix II
    58. Length of Last Word
    57. Insert Interval
    56. Merge Intervals
    55. Jump Game
    54. Spiral Matrix
    53. Maximum Subarray
    52. N-Queens II
    51. N-Queens
    java封装学习
  • 原文地址:https://www.cnblogs.com/AABBbaby/p/13952455.html
Copyright © 2020-2023  润新知