//设置汇总显示的信息
public void SetGroupSummary(DevExpress.XtraGrid.Views.Grid.GridView gridView, Dictionary<string, MB.WinBase.Common.ColumnPropertyInfo> colPropertys) {
ArrayList list = new ArrayList();
foreach (DevExpress.XtraGrid.Columns.GridColumn dc in gridView.Columns) {
int num;
string name = string.Empty;
if (!string.IsNullOrEmpty(colPropertys.Keys.FirstOrDefault(o => string.Compare(o, dc.FieldName, true) == 0))) {
name = dc.FieldName;
}
else {
name = interceptRightNumber(dc.FieldName, out num);
}
MB.WinBase.Common.ColumnPropertyInfo info = null;
if (colPropertys.ContainsKey(name))
info = colPropertys[name];
if (info != null && info.SummaryItem) {
//设置Total 汇总的信息
dc.SummaryItem.SummaryType = (DevExpress.Data.SummaryItemType)Enum.Parse(typeof(DevExpress.Data.SummaryItemType), info.SummaryItemType.ToString());
dc.SummaryItem.DisplayFormat = getSummmaryDisplayCaption(dc.SummaryItem.SummaryType) + "={0}";
//为了设置小计的显示而存储
list.Add(dc);
}
// 处理动态创建的列.
if (info == null && dc.Tag != null) {
switch (dc.Tag.ToString()) {
case "System.Int32":
case "System.Decimal":
dc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
dc.SummaryItem.DisplayFormat = getSummmaryDisplayCaption(dc.SummaryItem.SummaryType) + "={0}";
list.Add(dc);
break;
default:
break;
}
}
}
if (list.Count > 0) {
List<DevExpress.XtraGrid.GridSummaryItem> summaryItems = new List<GridSummaryItem>();
for (int i = 0; i < list.Count; i++) {
DevExpress.XtraGrid.Columns.GridColumn dc = list[i] as DevExpress.XtraGrid.Columns.GridColumn;
if (dc != null) {
var sumItem = new DevExpress.XtraGrid.GridGroupSummaryItem(dc.SummaryItem.SummaryType, dc.FieldName, dc, getSummmaryDisplayCaption(dc.SummaryItem.SummaryType) + "={0}");
var gsumItem = new DevExpress.XtraGrid.GridGroupSummaryItem(dc.SummaryItem.SummaryType, dc.FieldName, null, getSummmaryDisplayCaption(dc.SummaryItem.SummaryType) + "={0}");
summaryItems.Add(sumItem);
summaryItems.Add(gsumItem);
}
}
gridView.GroupSummary.AddRange(summaryItems.ToArray());
}
}
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);
}
}
}
}
void ucContractList_EventDataChanged()
{
//a.ContractNo, a.ContractType, ct.name as ContractTypeName, a.CustNo, c.FirstName, c.LastName,
//c.CorporateName, a.ValidStartDate, a.ValidStartTime, a.ValidEndDate, a.ValidEndTime,
//a.Amount, a.Balance, a.CurCode, a.PersonCount, a.DepFreq,
//a.DepAmount, a.Status, decode(a.Status, 0, 'Идэвхгүй', 1, 'Идэвхтэй') as StatusName
ucContractList.FieldLinkSetColumnCaption(0, "Гэрээний ID");
ucContractList.FieldLinkSetColumnCaption(1, "Гэрээний төрөл");
ucContractList.FieldLinkSetColumnCaption(2, "Гэрээний төрлийн нэр");
ucContractList.FieldLinkSetColumnCaption(3, "Харилцагчийн дугаар");
ucContractList.FieldLinkSetColumnCaption(4, "Харилцагчийн эцэг эхийн нэр");
ucContractList.FieldLinkSetColumnCaption(5, "Харилцагчийн нэр");
ucContractList.FieldLinkSetColumnCaption(6, "Компаний нэр");
ucContractList.FieldLinkSetColumnCaption(7, "Эхлэх огноо");
ucContractList.FieldLinkSetColumnCaption(8, "Эхлэх цаг");
ucContractList.FieldLinkSetColumnCaption(9, "Дуусах огноо");
ucContractList.FieldLinkSetColumnCaption(10, "Дуусах цаг");
ucContractList.FieldLinkSetColumnCaption(11, "Гэрээний үнийн дүн");
ucContractList.gridView1.Columns[11].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
ucContractList.gridView1.Columns[11].DisplayFormat.FormatString = "{0:n2}";
ucContractList.FieldLinkSetColumnCaption(12, "Гэрээний үлдэгдэл үнэ");
ucContractList.gridView1.Columns[12].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
ucContractList.gridView1.Columns[12].DisplayFormat.FormatString = "{0:n2}";
ucContractList.FieldLinkSetColumnCaption(13, "Валют");
ucContractList.FieldLinkSetColumnCaption(14, "Гэрээнд хамрагдах үйчлүүлэгчийн тоо");
ucContractList.FieldLinkSetColumnCaption(15, "Гэрээний дүнг элэгдүүлэх давтамж");
ucContractList.FieldLinkSetColumnCaption(16, "Гэрээний дүнг элэгдүүлэх дүн");
ucContractList.gridView1.Columns[16].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
ucContractList.gridView1.Columns[16].DisplayFormat.FormatString = "{0:n2}";
ucContractList.FieldLinkSetColumnCaption(17, "Гэрээний төлөв");
ucContractList.FieldLinkSetColumnCaption(18, "Гэрээний төлөв");
ucContractList.FieldLinkSetColumnCaption(19, "Үүсэгсэн огноо");
ucContractList.FieldLinkSetColumnCaption(20, "Үүсэгсэн огноо цаг");
ucContractList.FieldLinkSetColumnCaption(21, "Үүсэгсэн хэрэглэгч");
ucContractList.FieldLinkSetColumnCaption(22, "Хариуцсан хэрэглэгч");
ucContractList.gridView1.GroupFooterShowMode = GroupFooterShowMode.VisibleAlways;
// Customize the total summary.
ucContractList.gridView1.Columns[0].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Count;
ucContractList.gridView1.Columns[0].SummaryItem.DisplayFormat = "Нийт гэрээний тоо :{0:C2}";
ucContractList.gridView1.Columns[0].SummaryItem.Tag = 1;
(ucContractList.gridView1.Columns[0].View as GridView).OptionsView.ShowFooter = true;
ucContractList.gridView1.OptionsView.ShowGroupPanel = false;
ucContractList.gridView1.ExpandAllGroups();
ucContractList.gridView1.Columns[11].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
ucContractList.gridView1.Columns[11].SummaryItem.DisplayFormat = "Нийт:{0:C2}";
ucContractList.gridView1.Columns[11].SummaryItem.Tag = 1;
(ucContractList.gridView1.Columns[11].View as GridView).OptionsView.ShowFooter = true;
ucContractList.gridView1.OptionsView.ShowGroupPanel = true;
ucContractList.gridView1.ExpandAllGroups();
ucContractList.gridView1.Columns[12].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
ucContractList.gridView1.Columns[12].SummaryItem.DisplayFormat = "Нийт:{0:C2}";
ucContractList.gridView1.Columns[12].SummaryItem.Tag = 1;
(ucContractList.gridView1.Columns[12].View as GridView).OptionsView.ShowFooter = true;
// Create and setup the first summary item.
GridGroupSummaryItem item = new GridGroupSummaryItem();
item.FieldName = "ContractNo";
item.SummaryType = DevExpress.Data.SummaryItemType.Count;
ucContractList.gridView1.GroupSummary.Add(item);
DevExpress.XtraGrid.GridGroupSummaryItem item1 = new DevExpress.XtraGrid.GridGroupSummaryItem();
item1.FieldName = "Amount";
item1.SummaryType = DevExpress.Data.SummaryItemType.Sum;
item1.DisplayFormat = "Нийт б/хураамж {0:c2}";
item1.Tag = 1;
item1.ShowInGroupColumnFooter = ucContractList.gridView1.Columns["Amount"];
ucContractList.gridView1.GroupSummary.Add(item1);
DevExpress.XtraGrid.GridGroupSummaryItem item2 = new DevExpress.XtraGrid.GridGroupSummaryItem();
item2.FieldName = "Balance";
item2.SummaryType = DevExpress.Data.SummaryItemType.Sum;
item2.DisplayFormat = "Нийт б/үнэлгээ {0:c2}";
item2.Tag = 1;
item2.ShowInGroupColumnFooter = ucContractList.gridView1.Columns["Balance"];
ucContractList.gridView1.GroupSummary.Add(item2);
FormUtility.RestoreStateGrid(appname, formname, ref ucContractList.gridView1);
FormUtility.RestoreStateVGrid(appname, formname, ref ucContractList.ucParameterPanel1.vGridControl1, ref ucContractList.groupControl1);
}