本文整理汇总了C#中ASPxGridView.GroupBy方法的典型用法代码示例。如果您正苦于以下问题:C# ASPxGridView.GroupBy方法的具体用法?C# ASPxGridView.GroupBy怎么用?C# ASPxGridView.GroupBy使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类ASPxGridView
的用法示例。
在下文中一共展示了ASPxGridView.GroupBy方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: CreateGridViewRetale
//.........这里部分代码省略.........
}
}
}
else
{
List<ASPxSummaryItem> groupitem = new List<ASPxSummaryItem>();
List<ASPxSummaryItem> footeritem = new List<ASPxSummaryItem>();
GridViewColumn[] colarray = new GridViewColumn[sourceField.Rows.Count];
string objectnamefk = string.Empty;
for (int i = 0; i < sourceField.Rows.Count; i++)
{
//SiAuto.Main.LogString("cot" + i.ToString(), sourceField.Rows[i]["fieldname"].ToString());
string fieldtext = sourceField.Rows[i]["fieldtext"].ToString();
string fieldname = isStored ? sourceField.Rows[i]["fieldname"].ToString() : sourceField.Rows[i]["fieldname"].ToString().ToLower();
string tablename = sourceField.Rows[i]["tablename"].ToString().ToLower();
string alias = sourceField.Rows[i]["alias"].ToString().ToLower();
int width = sourceField.Rows[i]["width"].ToString() == string.Empty ? 0 : int.Parse(sourceField.Rows[i]["width"].ToString());
string format = sourceField.Rows[i]["format"].ToString();
string tempeditor = sourceField.Rows[i]["tempeditor"].ToString();
string datasource = sourceField.Rows[i]["datasource"].ToString();
int isGroup = sourceField.Rows[i]["isGroup"].ToString() == string.Empty ? 0 : int.Parse(sourceField.Rows[i]["isGroup"].ToString());
string SummaryCalculator = sourceField.Rows[i]["SummaryCalculator"].ToString();
bool ishidden = false;
bool.TryParse(sourceField.Rows[i]["ishidden"].ToString(), out ishidden);
bool ishyperlinkrelate = sourceField.Rows[i]["ishyperlinkrelate"].ToString() == "True" ? true : false;
switch (sourceField.Rows[i]["tempcolumn"].ToString().ToLower())
{
case "textcolumn":
{
if (objectnamefk == string.Empty)
objectnamefk = ObjectUtils.getObjectNameFromModuleId(modulerelateid);
GridViewDataTextColumn dc = BuildTextColumn(fieldtext, fieldname, alias, width, format, tempeditor, modulerelateid,
tablename, datasource, ishyperlinkrelate, keyFieldName, objectnamefk);
gridViewName.Columns.Add(dc);
colarray[i] = dc;
break;
}
case "checkcolumn":
{
GridViewDataCheckColumn dc = BuildCheckColumn(fieldtext, fieldname, alias, width);
gridViewName.Columns.Add(dc);
colarray[i] = dc;
break;
}
case "datecolumn":
{
GridViewDataDateColumn dc = BuildDateColumn(fieldtext, fieldname, alias, width, format);
gridViewName.Columns.Add(dc);
colarray[i] = dc;
break;
}
case "progressbarcolumn":
{
GridViewDataProgressBarColumn dc = BuildProgressBarColumn(fieldtext, fieldname, alias, width);
gridViewName.Columns.Add(dc);
colarray[i] = dc;
break;
}
}
gridViewName.Columns[fieldname].Visible = !ishidden;
List<ASPxSummaryItem> sitem = SummaryCalculatorOnGview(fieldname, fieldtext, SummaryCalculator, gridViewName);
if (sitem != null)
{
groupitem.Add(sitem[0]);
footeritem.Add(sitem[1]);
}
}
List<List<ASPxSummaryItem>> summarylist = new List<List<ASPxSummaryItem>>();
summarylist.Add(groupitem);
summarylist.Add(footeritem);
mypage.Session["colcollect_gridrlMain" + modulerelateid] = colarray;
mypage.Session["colcollect_gridMain_summary" + modulerelateid] = summarylist;
}
DataRow[] dataRows = sourceField.Select("isGroup>0", "isGroup ASC");
if (dataRows.Length > 0)
{
gridViewName.Settings.ShowFooter = true;
for (int i = 0; i < dataRows.Length; i++)
{
string fieldname = dataRows[i]["fieldname"].ToString();
gridViewName.GroupBy(gridViewName.Columns[fieldname]);
((GridViewDataTextColumn)gridViewName.Columns[fieldname]).GroupIndex = i;
gridViewName.GroupSummary.Add(DevExpress.Data.SummaryItemType.Count, fieldname).DisplayFormat = "Tổng:{0}";
}
}
SiAuto.Main.LogColored(System.Drawing.Color.Chocolate, keyFieldName);
}
catch (Exception ex)
{
SiAuto.Main.LogColored(System.Drawing.Color.Red, ex.ToString());
}
}
示例2: CreateGridViewDynamic
//.........这里部分代码省略.........
string fieldname = isStored ? sourceField.Rows[i]["fieldname"].ToString() : sourceField.Rows[i]["fieldname"].ToString().ToLower();
string tablename = sourceField.Rows[i]["tablename"].ToString().ToLower();
string alias = sourceField.Rows[i]["alias"].ToString().ToLower();
int width = sourceField.Rows[i]["width"].ToString() == string.Empty ? 0 : int.Parse(sourceField.Rows[i]["width"].ToString());
string format = sourceField.Rows[i]["format"].ToString();
string tempeditor = sourceField.Rows[i]["tempeditor"].ToString();
string datasource = sourceField.Rows[i]["datasource"].ToString();
int isGroup = sourceField.Rows[i]["isGroup"].ToString() == string.Empty ? -1 : int.Parse(sourceField.Rows[i]["isGroup"].ToString());
string SummaryCalculator = sourceField.Rows[i]["SummaryCalculator"].ToString();
bool ishidden = false;
bool.TryParse(sourceField.Rows[i]["ishidden"].ToString(), out ishidden);
switch (sourceField.Rows[i]["tempcolumn"].ToString().ToLower())
{
case "bandcolumn":
{
GridViewBandColumn band = new GridViewBandColumn(fieldtext);
gridViewName.Columns.Add(band);
colarray[i] = band;
break;
}
case "textcolumn":
{
if (objectnamemain == string.Empty)
objectnamemain = ObjectUtils.getObjectNameFromModuleId(moduleid);
GridViewDataTextColumn dc = BuildTextColumn(fieldtext, fieldname, alias, width, format, tempeditor, moduleid, tablename, datasource, false, keyFieldName, objectnamemain);
if (i < 2 && Utils.isMobileBrowser())
dc.FixedStyle = GridViewColumnFixedStyle.Left;
gridViewName.Columns.Add(dc);
colarray[i] = dc;
break;
}
case "checkcolumn":
{
GridViewDataCheckColumn dc = BuildCheckColumn(fieldtext, fieldname, alias, width);
if (i < 2 && Utils.isMobileBrowser())
dc.FixedStyle = GridViewColumnFixedStyle.Left;
gridViewName.Columns.Add(dc);
colarray[i] = dc;
break;
}
case "datecolumn":
{
GridViewDataDateColumn dc = BuildDateColumn(fieldtext, fieldname, alias, width, format);
if (i < 2 && Utils.isMobileBrowser())
dc.FixedStyle = GridViewColumnFixedStyle.Left;
gridViewName.Columns.Add(dc);
colarray[i] = dc;
break;
}
case "progressbarcolumn":
{
GridViewDataProgressBarColumn dc = BuildProgressBarColumn(fieldtext, fieldname, alias, width);
if (i < 2 && Utils.isMobileBrowser())
dc.FixedStyle = GridViewColumnFixedStyle.Left;
gridViewName.Columns.Add(dc);
colarray[i] = dc;
break;
}
}
gridViewName.Columns[fieldname].Visible = !ishidden;
List<ASPxSummaryItem> sitem = SummaryCalculatorOnGview(fieldname, fieldtext, SummaryCalculator, gridViewName);
if (sitem != null)
{
groupitem.Add(sitem[0]);
footeritem.Add(sitem[1]);
}
}
List<List<ASPxSummaryItem>> summarylist = new List<List<ASPxSummaryItem>>();
summarylist.Add(groupitem);
summarylist.Add(footeritem);
mypage.Session["colcollect_gridMain" + moduleid] = colarray;
mypage.Session["colcollect_gridMain_summary" + moduleid] = summarylist;
}
DataRow[] dataRows = sourceField.Select("ISNULL(isGroup,-1)>=0", "isGroup ASC");
SiAuto.Main.LogDataTable("danh sach field chuan bi group filter ISNULL(isGroup,-1)>=0 isGroup ASC", sourceField);
if (dataRows.Length > 0)
{
gridViewName.Settings.ShowGroupPanel = true;
gridViewName.Settings.ShowFooter = true;
for (int i = 0; i < dataRows.Length; i++)
{
string fieldname = isStored ? dataRows[i]["fieldname"].ToString() : dataRows[i]["fieldname"].ToString().ToLower();
SiAuto.Main.LogColored(Color.Orange, fieldname);
gridViewName.GroupBy(gridViewName.Columns[fieldname], i);
//((GridViewDataTextColumn)gridViewName.Columns[fieldname]).GroupIndex = i;
//gridViewName.GroupSummary.Add(DevExpress.Data.SummaryItemType.Count, fieldname).DisplayFormat = "Tổng:{0}";
}
}
SiAuto.Main.LogColored(System.Drawing.Color.Chocolate, keyFieldName);
}
catch (Exception ex)
{
SiAuto.Main.LogColored(System.Drawing.Color.Red, ex.ToString());
}
}