Friday 15 May 2015

c# - How to display sum of Grouped Items -



c# - How to display sum of Grouped Items -

i have datagrid displays scan count, logical reads etc.i have figured out how calculate sum single column 'scan count' using converters , display. how same remaining columns ? sum dispalyed in header of expander, can aligned @ bottom of respective columns ?

totalsumconverter.cs

public class totalsumconverter : ivalueconverter { public object convert(object value, type targettype, object parameter, system.globalization.cultureinfo culture) { //first method var users = value ienumerable<object>; if (users == null) homecoming ""; double sum = 0; foreach (var u in users) { sum += ((aggregationtable)u).scancount; } homecoming sum.tostring(); } public object convertback(object value, type targettype, object parameter, system.globalization.cultureinfo culture) { throw new system.notimplementedexception(); }

mainwindow.xaml

<window.resources> <local:totalsumconverter x:key="sumconverter" /> <style x:key="groupheaderstyle" targettype="{x:type groupitem}"> <setter property="template"> <setter.value> <controltemplate targettype="{x:type groupitem}"> <expander x:name="exp" isexpanded="true" background="white" foreground="black"> <expander.header> <stackpanel orientation="horizontal"> <textblock grid.column="1" text="{binding path=name}" margin="3.5,0" /> <textblock grid.column="2" text="total:" /> <textblock grid.column="3" text="{binding path=items, converter={staticresource sumconverter}}" textalignment="right" /> </stackpanel> </expander.header> <itemspresenter /> </expander> </controltemplate> </setter.value> </setter> </style>

aggregationtable.cs

class aggregationtable { string _table; double _scancount; double _logicalreads; string _physicalreads; string _readaheadreads; string _loblogicalreads; string _lobphysicalreads; string _lobreadaheadreads; public string table { { homecoming _table; } set { _table = value; } } public double scancount { { homecoming _scancount; } set { _scancount = value; } } public double logicalreads { { homecoming _logicalreads; } set { _logicalreads = value; } }

c# wpf styles converter grouping

No comments:

Post a Comment