private void FillGrid()
{
try
{
if (m_sBuyerId == "")
{
grdDemand.DataSource = null; return;
}
DataTable dtBind = new DataTable();
dtBuyer = new DataTable();
DataTable dt = new DataTable();
DataSet ds = new DataSet();
ds = ProgBillBL.GetDemandAge(m_iFromDays, m_iToDays, m_iCCId);
dt = ds.Tables[0];
dtBuyer = ds.Tables[1];
dtBind = ds.Tables[2];
DataView dv = new DataView(dtBind);
dv.RowFilter = "LeadId In(" + m_sBuyerId.TrimEnd(',') + ")";
dtBind = dv.ToTable();
grdDemand.DataSource = null;
//grdDemand.DataSource = dtBind;
grdDemand.DataSource = dtBuyer;
grdViewDemand.PopulateColumns();
grdDemand.ForceInitialize();
grdViewDemand.Columns["PBillId"].Visible = false;
grdViewDemand.Columns["CostCentreId"].Visible = false;
grdViewDemand.Columns["FlatId"].Visible = false;
grdViewDemand.Columns["PaySchId"].Visible = false;
grdViewDemand.Columns["Count"].Visible = false;
grdViewDemand.Columns["LeadId"].Visible = false;
grdViewDemand.Columns["NoOfDays"].Visible = false;
grdViewDemand.Columns["SortOrder"].Visible = false;
grdViewDemand.Columns["BillNo"].Width = 50;
grdViewDemand.Columns["FlatNo"].Width = 50;
grdViewDemand.Columns["BuyerName"].Width = 100;
grdViewDemand.Columns["Description"].Width = 200;
//grdViewDemand.Columns["Count"].Width = 25;
grdViewDemand.Columns["Sel"].Width = 50;
grdViewDemand.Columns["FlatNo"].Caption = CommFun.m_sFuncName + " No";
grdViewDemand.Columns["NoOfDays"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
grdViewDemand.Columns["Sel"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
grdViewDemand.Columns["Sel"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
grdViewDemand.OptionsSelection.InvertSelection = true;
grdViewDemand.OptionsSelection.EnableAppearanceHideSelection = false;
grdViewDemand.Appearance.FocusedRow.BackColor = Color.Teal;
grdViewDemand.Appearance.FocusedRow.ForeColor = Color.White;
//grdViewDemand.BestFitColumns();
}
catch (Exception ex)
{
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
}
private string GetBuyer()
{
DataSet ds = new DataSet();
ds = ProgBillBL.GetDemandAge(m_iFromDays, m_iToDays, m_iCCId);
dtBuyer = ds.Tables[1];
m_sBuyerId = "";
if (dtBuyer.Rows.Count > 0)
{
for (int i = 0; i < dtBuyer.Rows.Count; i++)
{
m_sBuyerId = String.Format("{0}{1},", m_sBuyerId, dtBuyer.Rows[i]["LeadId"]);
}
}
return(m_sBuyerId);
}