'宣言 Public Class SummaryValue Inherits Infragistics.Shared.SubObjectBase
public class SummaryValue : Infragistics.Shared.SubObjectBase
SummaryValue インスタンスには、集計の計算結果が含まれます。このオブジェクトは、各集計計算で表示される集計値 UI 要素に関連付けられます。行コレクションの集計値にアクセスするには、RowsCollection の RowsCollection.SummaryValues プロパティを使用します。
SummarySettings インスタンスは、それに関連付けられる複数の SummaryValue インスタンスを持つことができます。SummarySettings には、計算で使用するための式の情報が含まれます。コードで集計を追加するには、Band の UltraGridBand.Summaries プロパティを使用します。
Imports Infragistics.Shared Imports Infragistics.Win Imports Infragistics.Win.UltraWinGrid Private Sub UltraGrid1_SummaryValueChanged(ByVal sender As Object, ByVal e As Infragistics.Win.UltraWinGrid.SummaryValueChangedEventArgs) Handles ultraGrid1.SummaryValueChanged ' Use the key to identify what summary the SummaryValue object is associated with ' and set appearance properties accordingly. If e.SummaryValue.Key = "Max" Then If CType(e.SummaryValue.Value, Decimal) < 20 Then ' If the max is less than han 40, then highlight the summary with red color ' by setting the back color to red e.SummaryValue.Appearance.BackColor = Color.LightYellow Else e.SummaryValue.Appearance.BackColor = Color.SkyBlue End If End If If e.SummaryValue.Key = "Avg" Then If CType(e.SummaryValue.Value, Decimal) > 20 Then ' If the sum is greater than 20, then highlight the summary with red color ' by setting the back color to red e.SummaryValue.Appearance.BackColor = Color.LightSkyBlue Else e.SummaryValue.Appearance.BackColor = Color.LightYellow End If End If End Sub
using Infragistics.Shared; using Infragistics.Win; using Infragistics.Win.UltraWinGrid; using System.Diagnostics; private void ultraGrid1_SummaryValueChanged(object sender, Infragistics.Win.UltraWinGrid.SummaryValueChangedEventArgs e) { // Use the key to identify what summary the SummaryValue object is associated with // and set appearance properties accordingly. if ( e.SummaryValue.Key == "Max" ) { if ( (decimal)e.SummaryValue.Value < 20 ) { // If the max is less than han 40, then highlight the summary with red color // by setting the back color to red e.SummaryValue.Appearance.BackColor = Color.LightYellow; } else { e.SummaryValue.Appearance.BackColor = Color.SkyBlue; } } if ( e.SummaryValue.Key == "Avg" ) { if ( (decimal)e.SummaryValue.Value > 20 ) { // If the sum is greater than 20, then highlight the summary with red color // by setting the back color to red e.SummaryValue.Appearance.BackColor = Color.LightSkyBlue; } else { e.SummaryValue.Appearance.BackColor = Color.LightYellow; } } }