private static void addColumn(MainTableColumnsBuilder columns, string propertyName, string caption, string headingCaption, bool mergeHeaderCell, int order, bool showTotal = true)
{
columns.AddColumn(column =>
{
column.PropertyName(propertyName);
column.CellsHorizontalAlignment(HorizontalAlignment.Center);
column.IsVisible(true);
column.Order(order);
column.HeaderCell(caption); //------- Main Header Row
column.AddHeadingCell(headingCaption, mergeHeaderCell: mergeHeaderCell); //------- Extra Header Row
if (showTotal)
{
column.AggregateFunction(aggregateFunction =>
{
aggregateFunction.NumericAggregateFunction(AggregateFunction.Sum);
aggregateFunction.DisplayFormatFormula(obj => obj == null || string.IsNullOrEmpty(obj.ToString())
? string.Empty : string.Format("{0:n0}", obj));
});
}
column.ColumnItemsTemplate(template =>
{
template.TextBlock();
template.DisplayFormatFormula(obj => obj == null || string.IsNullOrEmpty(obj.ToString())
? string.Empty : string.Format("{0:n0}", obj));
});
});
}
