DevExpress GridControl 部分用法

昵称10504424 2013-04-16

展开全文

GridControl赋值：this.GridControl1.DataSouce=dt;

2、GridContro总合计及分组合计：

常规总合计直接RunDesigner-Group Summary Items

DisplayFormat 设置显示格式如：{0:P}表示显示为百分号模式。如数据源中为0.5。表示出来为50%

FieldName 设置显示的对应列

ShowInGroupColumnFooter 在那一列下面显示

SummaryType 合计方式。选择Custom表示自定义。CustomSummaryCalculate事件可处理

View Code

  //Footer行自定义列合计
  1   GridView view = sender as GridView;
  2   if (e.Item == view.Columns["RateZk"].SummaryItem)
  3   {
  4     decimal x = Convert.ToDecimal(view.Columns["RetailFAmount"].SummaryItem.SummaryValue);
  5     decimal y = Convert.ToDecimal(view.Columns["RetailAmount"].SummaryItem.SummaryValue);
  6     view.Columns["RateZk"].SummaryItem.DisplayFormat = "{0:P}";
  7     if (y != 0)
  8     e.TotalValue = x / y;
  9     else
 10     e.TotalValue = 0;
 11   }

View Code

 //分组行自定义合计列
 1   if (e.IsGroupSummary)
 2  {
 3     Hashtable ht = view.GetGroupSummaryValues(e.GroupRowHandle);
 4 
 5     foreach (DictionaryEntry entry in ht)
 6     {
 7       GridGroupSummaryItem sumItem = entry.Key as GridGroupSummaryItem;
 8       if (sumItem.FieldName.Equals("RetailFAmount"))
 9          retailFAmount = Convert.ToDecimal(entry.Value);
10     }           
11     if (e.Item.ToString().Contains(view.Columns["RateZk"].SummaryItem.FieldName))  
12          e.TotalValue = retailFAmount

3、GridContro导出Excel操作：

View Code

 1    SaveFileDialog saveFileDialog = new SaveFileDialog();
 2    saveFileDialog.Title = "导出Excel";
 3    saveFileDialog.Filter = "Excel文件(*.xls)|*.xls";
 4    DialogResult dialogResult = saveFileDialog.ShowDialog(this);
 5    if (dialogResult == DialogResult.OK)
 6    {
 7      this.gvbrowse.OptionsPrint.AutoWidth = false; //设置导出的Excel自动调整列宽，列宽和控件的列宽一致
 8      this.gcbrowse.ExportToXls(saveFileDialog.FileName);
 9      //this.gcbrowse.ExportToXlsOld(saveFileDialog.FileName);//这个方法默认会自动调整列宽，但是office10以上版本有的会报错
10      DevExpress.XtraEditors.XtraMessageBox.Show("保存成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
11      this.gvbrowse.OptionsPrint.AutoWidth = true; 
12    }