ASPxCardView.GetTotalSummaryValue(ASPxCardViewSummaryItem) Method
Returns a summary value calculated against all cards.
Namespace: DevExpress.Web
Assembly:
DevExpress.Web.v20.2.dll
NuGet Package:
DevExpress.Web
Declaration
public object GetTotalSummaryValue(
ASPxCardViewSummaryItem item
)
Public Function GetTotalSummaryValue(
item As ASPxCardViewSummaryItem
) As Object
Parameters
Returns
Type |
Description |
Object |
An object which represents the summary value.
|
The ASPxCardView enables you to calculate summaries which are aggregate functions based on values of data source fields. The total summary calculates an aggregate function by all cards and displays the result in a footer. The total summary is represented by a ASPxSummaryItem object.
Example
View Example
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<dx:ASPxCardView ID="ASPxCardView1" runat="server" OnCustomSummaryCalculate="ASPxCardView1_CustomSummaryCalculate" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" KeyFieldName="ProductID">
<Settings ShowSummaryPanel="True" />
<TotalSummary>
<dx:ASPxCardViewSummaryItem SummaryType="Average" FieldName="UnitPrice" />
<dx:ASPxCardViewSummaryItem SummaryType="Average" FieldName="UnitsOnOrder" />
<dx:ASPxCardViewSummaryItem SummaryType="Custom" DisplayFormat="Average Sum ={0}" />
</TotalSummary>
<Columns>
<dx:CardViewTextColumn FieldName="ProductID" ReadOnly="True" Visible="False">
</dx:CardViewTextColumn>
<dx:CardViewTextColumn FieldName="ProductName" VisibleIndex="0">
</dx:CardViewTextColumn>
<dx:CardViewTextColumn FieldName="UnitPrice" VisibleIndex="1">
</dx:CardViewTextColumn>
<dx:CardViewTextColumn FieldName="UnitsInStock" VisibleIndex="2">
</dx:CardViewTextColumn>
<dx:CardViewTextColumn FieldName="UnitsOnOrder" VisibleIndex="3">
</dx:CardViewTextColumn>
<dx:CardViewTextColumn FieldName="ReorderLevel" VisibleIndex="4">
</dx:CardViewTextColumn>
<dx:CardViewCheckColumn FieldName="Discontinued" VisibleIndex="5">
</dx:CardViewCheckColumn>
</Columns>
</dx:ASPxCardView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\nwind.mdb;Persist Security Info=True" ProviderName="System.Data.OleDb" SelectCommand="SELECT [ProductID], [ProductName], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued] FROM [Products]"></asp:SqlDataSource>
</div>
</form>
</body>
</html>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using DevExpress.Web;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void ASPxCardView1_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e)
{
ASPxCardViewSummaryItem orderedUnits = (sender as ASPxCardView).TotalSummary["UnitsOnOrder"];
ASPxCardViewSummaryItem averagePrice = (sender as ASPxCardView).TotalSummary["UnitPrice"];
Int32 intOrderedUnits = Convert.ToInt32(((ASPxCardView)sender).GetTotalSummaryValue(orderedUnits));
Int32 intAveragePrice = Convert.ToInt32(((ASPxCardView)sender).GetTotalSummaryValue(averagePrice));
e.TotalValue = intOrderedUnits * intAveragePrice;
}
}
Imports System
Imports System.Collections.Generic
Imports System.Linq
Imports System.Web
Imports System.Web.UI
Imports System.Web.UI.WebControls
Imports DevExpress.Web
Partial Public Class _Default
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
End Sub
Protected Sub ASPxCardView1_CustomSummaryCalculate(ByVal sender As Object, ByVal e As DevExpress.Data.CustomSummaryEventArgs)
Dim orderedUnits As ASPxCardViewSummaryItem = (TryCast(sender, ASPxCardView)).TotalSummary("UnitsOnOrder")
Dim averagePrice As ASPxCardViewSummaryItem = (TryCast(sender, ASPxCardView)).TotalSummary("UnitPrice")
Dim intOrderedUnits As Int32 = Convert.ToInt32(DirectCast(sender, ASPxCardView).GetTotalSummaryValue(orderedUnits))
Dim intAveragePrice As Int32 = Convert.ToInt32(DirectCast(sender, ASPxCardView).GetTotalSummaryValue(averagePrice))
e.TotalValue = intOrderedUnits * intAveragePrice
End Sub
End Class
<%@ Page Language="vb" AutoEventWireup="true" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<dx:ASPxCardView ID="ASPxCardView1" runat="server" OnCustomSummaryCalculate="ASPxCardView1_CustomSummaryCalculate" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" KeyFieldName="ProductID">
<Settings ShowSummaryPanel="True" />
<TotalSummary>
<dx:ASPxCardViewSummaryItem SummaryType="Average" FieldName="UnitPrice" />
<dx:ASPxCardViewSummaryItem SummaryType="Average" FieldName="UnitsOnOrder" />
<dx:ASPxCardViewSummaryItem SummaryType="Custom" DisplayFormat="Average Sum ={0}" />
</TotalSummary>
<Columns>
<dx:CardViewTextColumn FieldName="ProductID" ReadOnly="True" Visible="False">
</dx:CardViewTextColumn>
<dx:CardViewTextColumn FieldName="ProductName" VisibleIndex="0">
</dx:CardViewTextColumn>
<dx:CardViewTextColumn FieldName="UnitPrice" VisibleIndex="1">
</dx:CardViewTextColumn>
<dx:CardViewTextColumn FieldName="UnitsInStock" VisibleIndex="2">
</dx:CardViewTextColumn>
<dx:CardViewTextColumn FieldName="UnitsOnOrder" VisibleIndex="3">
</dx:CardViewTextColumn>
<dx:CardViewTextColumn FieldName="ReorderLevel" VisibleIndex="4">
</dx:CardViewTextColumn>
<dx:CardViewCheckColumn FieldName="Discontinued" VisibleIndex="5">
</dx:CardViewCheckColumn>
</Columns>
</dx:ASPxCardView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\nwind.mdb;Persist Security Info=True" ProviderName="System.Data.OleDb" SelectCommand="SELECT [ProductID], [ProductName], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued] FROM [Products]"></asp:SqlDataSource>
</div>
</form>
</body>
</html>
See Also