public void InitSummary()
{
GroupChooseNeedSummary = new DevExpress.XtraGrid.GridGroupSummaryItem(DevExpress.Data.SummaryItemType.Custom, ChooseColumnName, null, "Count:{0}")
{
Tag = "GroupChooseNeedSummary"
};
ChooseNeedSummary = new DevExpress.XtraGrid.GridColumnSummaryItem(DevExpress.Data.SummaryItemType.Custom, "", "{0}");
}
//join service and rate
private void SearchData(string CountryKey, string Phrase)
{
List <ReadyExcursion> readyExcursion = new List <ReadyExcursion>();
foreach (var item in services.Where(x => x.CountryKey == CountryKey && x.Name.ToLower().Contains(Phrase.ToLower())))
{
var query = rateGroup.Where(x => x.ServiceKey == item.Key);
List <Rate> r = new List <Rate>();
foreach (var item2 in query)
{
foreach (var item3 in item2.Rates)
{
r.Add(new Rate {
Per = item3.Per, Fill = item3.Fill, Group = item3.Group, Value = item3.Value
});
}
}
readyExcursion.Add(new ReadyExcursion {
ServiceName = item.Name, Rates = r
});
}
gridControl1.BeginUpdate();
gridControl1.DataSource = null;
gridView1.Columns.Clear();
gridControl1.DataSource = readyExcursion.OrderBy(x => x.ServiceName);
for (int i = 0; i < gridView1.Columns.Count(); i++)
{
gridView1.Columns[i].OptionsFilter.FilterPopupMode = DevExpress.XtraGrid.Columns.FilterPopupMode.CheckedList;
}
if (gridView1.Columns["ServiceName"].Summary.ActiveCount == 0)
{
DevExpress.XtraGrid.GridColumnSummaryItem itemStatus = new DevExpress.XtraGrid.GridColumnSummaryItem(DevExpress.Data.SummaryItemType.Count, "ProductName", "Count: {0}");
gridView1.Columns["ServiceName"].Summary.Add(itemStatus);
}
gridView1.ClearSelection();
gridControl1.EndUpdate();
}
