private static SummaryFunc ConvertToSummaryFunc(DevExpress.Data.SummaryItemType t)
{
SummaryFunc s = SummaryFunc.Sum;
switch (t)
{
case DevExpress.Data.SummaryItemType.Average:
s = SummaryFunc.Avg;
break;
case DevExpress.Data.SummaryItemType.Count:
s = SummaryFunc.Count;
break;
case DevExpress.Data.SummaryItemType.Max:
s = SummaryFunc.Max;
break;
case DevExpress.Data.SummaryItemType.Min:
s = SummaryFunc.Min;
break;
case DevExpress.Data.SummaryItemType.Sum:
s = SummaryFunc.Sum;
break;
}
return(s);
}
//根据统计汇总的类型获取对应的中文描述。
private string getSummmaryDisplayCaption(DevExpress.Data.SummaryItemType type) {
switch (type) {
case DevExpress.Data.SummaryItemType.Sum:
return "总计";
case DevExpress.Data.SummaryItemType.Count:
return "总数";
case DevExpress.Data.SummaryItemType.Max:
return "最大";
case DevExpress.Data.SummaryItemType.Min:
return "最小";
case DevExpress.Data.SummaryItemType.Average:
return "平均";
default:
return "小计";
}
}
static public void gridviewViewSummaryAdd(DevExpress.XtraGrid.Views.Grid.GridView _view, String _fild_name, DevExpress.Data.SummaryItemType _summary_item_type, String _display_format)
{
if (null != _view)
{
DevExpress.XtraGrid.Columns.GridColumn des_column = _view.Columns[_fild_name];
if (null != des_column)
{
des_column.Summary.Add(_summary_item_type, _fild_name, _display_format);
}
}
}
static public void gridviewGroupSummaryAdd(DevExpress.XtraGrid.Views.Grid.GridView _view, String _fild_name, DevExpress.Data.SummaryItemType _summary_item_type, String _display_format)
{
if (null != _view)
{
DevExpress.XtraGrid.Columns.GridColumn des_column = _view.Columns[_fild_name];
if (null != des_column)
{
DevExpress.XtraGrid.GridGroupSummaryItem item = new DevExpress.XtraGrid.GridGroupSummaryItem();
if (null != item)
{
item.FieldName = _fild_name;
item.SummaryType = _summary_item_type;
if (null != _display_format && 0 < _display_format.Length)
{
item.DisplayFormat = _display_format;
}
item.ShowInGroupColumnFooter = des_column;
_view.GroupSummary.Add(item);
}
}
}
}
/// <summary>
/// Tinh tong gia tri trong nhieu cot
/// </summary>
/// <param name="grid"></param>
/// <param name="fieldName"></param>
/// <param name="displayFormat"></param>
/// <param name="summaryType"></param>
public static void SummaryField(GridView grid, string[] fieldNames, string displayFormat, DevExpress.Data.SummaryItemType summaryType)
{
grid.OptionsView.ShowFooter = true;
for (int i = 0; i < fieldNames.Length; i++)
{
grid.Columns[fieldNames[i]].SummaryItem.FieldName = fieldNames[i];
grid.Columns[fieldNames[i]].SummaryItem.DisplayFormat = displayFormat;
grid.Columns[fieldNames[i]].SummaryItem.SummaryType = summaryType;
}
}
/// <summary>
/// Tinh tong gia tri trong cot
/// </summary>
/// <param name="grid"></param>
/// <param name="fieldName"></param>
/// <param name="displayFormat"></param>
/// <param name="summaryType"></param>
public static void SummaryField(GridView grid, string fieldName, string displayFormat, DevExpress.Data.SummaryItemType summaryType)
{
grid.OptionsView.ShowFooter = true;
grid.Columns[fieldName].SummaryItem.FieldName = fieldName;
grid.Columns[fieldName].SummaryItem.DisplayFormat = displayFormat;
grid.Columns[fieldName].SummaryItem.SummaryType = summaryType;
}
