private void PopulateFormat1Grid()
{
gridControl1.DataSource = null;
if (rg1.SelectedIndex == -1)
{
return;
}
if (rg1.SelectedIndex == 3)
{
if (dt1.EditValue == null)
{
return;
}
if (dt2.EditValue == null)
{
return;
}
}
DataTable dt = new DataTable();
dt = ReceiptDetailBL.PopulateF1CollectionReport(rg1.SelectedIndex, Convert.ToDateTime(dt1.EditValue), Convert.ToDateTime(dt2.EditValue));
if (dt == null || dt.Columns.Count == 0)
{
return;
}
gridControl1.DataSource = dt;
gridControl1.ForceInitialize();
gridView1.PopulateColumns();
gridView1.Columns["ProjectName"].Group();
gridView1.Columns["FlatNo"].Group();
gridView1.ExpandAllGroups();
gridView1.Columns["Gross"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
gridView1.Columns["ServiceTax"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
gridView1.Columns["NetAmount"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
gridView1.Columns["Gross"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
gridView1.Columns["Gross"].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat;
gridView1.Columns["ServiceTax"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
gridView1.Columns["ServiceTax"].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat;
gridView1.Columns["NetAmount"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
gridView1.Columns["NetAmount"].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat;
gridView1.Columns["Gross"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
gridView1.Columns["Gross"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
gridView1.Columns["ServiceTax"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
gridView1.Columns["ServiceTax"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
gridView1.Columns["NetAmount"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
gridView1.Columns["NetAmount"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
gridView1.OptionsView.ShowFooter = true;
gridView1.FocusedRowHandle = 0;
gridView1.Focus();
dt.Dispose();
}
