private void gridView_GridMenuItemClick(object sender, DevExpress.XtraGrid.Views.Grid.GridMenuItemClickEventArgs e)
{
//汉化xtraGrid的统计菜单格式
if (e.MenuType != DevExpress.XtraGrid.Views.Grid.GridMenuType.Summary)
{
return;
}
String strFormat = e.SummaryFormat;
int equInx = strFormat.IndexOf("=");
if (equInx > 0)
{
strFormat = e.DXMenuItem.Caption + strFormat.Substring(equInx);
e.SummaryFormat = strFormat;
}
}
private void gridView1_GridMenuItemClick(object sender, DevExpress.XtraGrid.Views.Grid.GridMenuItemClickEventArgs e)
{
}
private void bandedGridView1_GridMenuItemClick(object sender, DevExpress.XtraGrid.Views.Grid.GridMenuItemClickEventArgs e)
{
if (e.SummaryItem == null)
{
return;
}
string _fname = e.SummaryItem.FieldName;
switch (e.SummaryType)
{
case DevExpress.Data.SummaryItemType.Count:
#region 处理求记录数
if (!this.CountSummaryValues.ContainsKey(_fname))
{
this.CountSummaryValues.Add(_fname, GetCountData(_fname));
}
if (this.CurrentValues.ContainsKey(_fname))
{
this.CurrentValues[_fname] = this.CountSummaryValues[_fname];
}
else
{
this.CurrentValues.Add(_fname, this.CountSummaryValues[_fname]);
}
e.SummaryItem.SummaryType = SummaryItemType.None;
e.SummaryItem.SummaryType = SummaryItemType.Custom;
e.SummaryItem.DisplayFormat = "记录数={0}";
e.Handled = true;
#endregion
break;
case DevExpress.Data.SummaryItemType.Sum:
#region 处理求总数
if (!this.SumSummaryValues.ContainsKey(_fname))
{
this.SumSummaryValues.Add(_fname, GetSumData(_fname));
}
if (this.CurrentValues.ContainsKey(_fname))
{
this.CurrentValues[_fname] = this.SumSummaryValues[_fname];
}
else
{
this.CurrentValues.Add(_fname, this.SumSummaryValues[_fname]);
}
e.SummaryItem.SummaryType = SummaryItemType.None;
e.SummaryItem.SummaryType = SummaryItemType.Custom;
e.SummaryItem.DisplayFormat = "总和={0}";
e.Handled = true;
#endregion
break;
case DevExpress.Data.SummaryItemType.Average:
#region 处理求平均数
if (!this.AvgSummaryValues.ContainsKey(_fname))
{
this.AvgSummaryValues.Add(_fname, GetAvgData(_fname));
}
if (this.CurrentValues.ContainsKey(_fname))
{
this.CurrentValues[_fname] = this.AvgSummaryValues[_fname];
}
else
{
this.CurrentValues.Add(_fname, this.AvgSummaryValues[_fname]);
}
e.SummaryItem.SummaryType = SummaryItemType.None;
e.SummaryItem.SummaryType = SummaryItemType.Custom;
e.SummaryItem.DisplayFormat = "平均数={0}";
e.Handled = true;
#endregion
break;
}
}
