public void FillGrid()
{
try
{
iProgRegId = Convert.ToInt32(grdPBRegView.GetFocusedRowCellValue("ProgRegId"));
if (Convert.ToInt32(cboProj.EditValue) > 0)
{
dtBind = new DataTable();
dtBind = ProgBillBL.GetPBRegister(Convert.ToInt32(cboProj.EditValue.ToString()), iProgRegId, m_sBussinessType);
grdPBTrans.DataSource = null;
grdPBTrans.DataSource = dtBind;
grdPBTransView.PopulateColumns();
grdPBTransView.Columns["ProgRegId"].Visible = false;
grdPBTransView.Columns["PBillId"].Visible = false;
grdPBTransView.Columns["CostCentreId"].Visible = false;
grdPBTransView.Columns["LeadId"].Visible = false;
grdPBTransView.Columns["Amount"].Visible = false;
if (m_sBussinessType == "B")
{
grdPBTransView.Columns["FlatId"].Visible = false;
}
else
{
grdPBTransView.Columns["PlotDetailsId"].Visible = false;
}
if (m_sBussinessType == "B")
{
grdPBTransView.Columns["FlatNo"].Width = 100;
grdPBTransView.Columns["FlatNo"].Caption = CommFun.m_sFuncName + " No";
}
else
{
grdPBTransView.Columns["PlotNo"].Width = 100;
}
grdPBTransView.Columns["AsOnDate"].Width = 100;
grdPBTransView.Columns["PBDate"].Width = 100;
grdPBTransView.Columns["PBNo"].Width = 100;
grdPBTransView.Columns["CostCentreName"].Width = 200;
grdPBTransView.Columns["Description"].Width = 150;
grdPBTransView.Columns["BuyerName"].Width = 150;
grdPBTransView.Columns["NetAmount"].Width = 100;
grdPBTransView.Columns["Approve"].Width = 50;
grdPBTransView.Columns["Approve"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
grdPBTransView.Columns["Approve"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
grdPBTransView.Columns["NetAmount"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
grdPBTransView.Columns["NetAmount"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
grdPBTransView.Appearance.HeaderPanel.Font = new Font(grdPBTransView.Appearance.HeaderPanel.Font, FontStyle.Bold);
grdPBTransView.Appearance.FocusedCell.BackColor = Color.Teal;
grdPBTransView.Appearance.FocusedCell.ForeColor = Color.White;
grdPBTransView.Appearance.FocusedRow.ForeColor = Color.Black;
grdPBTransView.Appearance.FocusedRow.BackColor = Color.White;
grdPBTransView.OptionsSelection.EnableAppearanceHideSelection = false;
}
}
catch (Exception ex)
{
throw ex;
}
}
