private string GetBillId()
{
m_sBillId = "";
DataTable dtSel = new DataTable();
dtSel = grdDemand.DataSource as DataTable;
DataView dview = new DataView(dtSel)
{
RowFilter = "Sel=" + true + ""
};
DataTable dt = new DataTable();
dt = dview.ToTable();
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
int iLeadId = Convert.ToInt32(CommFun.IsNullCheck(dt.Rows[i]["LeadId"], CommFun.datatypes.vartypenumeric));
int iFlatId = Convert.ToInt32(CommFun.IsNullCheck(dt.Rows[i]["FlatId"], CommFun.datatypes.vartypenumeric));
int iSortOrder = Convert.ToInt32(CommFun.IsNullCheck(dt.Rows[i]["SortOrder"], CommFun.datatypes.vartypenumeric));
DataView dv = new DataView(dtSel)
{
RowFilter = "LeadId=" + iLeadId + " AND FlatId=" + iFlatId + " AND SortOrder<=" + iSortOrder + ""
};
DataTable dtFilter = new DataTable();
dtFilter = dv.ToTable();
if (dtFilter != null)
{
for (int k = 0; k < dtFilter.Rows.Count; k++)
{
if (m_sBillId == "")
{
m_sBillId = String.Format("{0}", dtFilter.Rows[k]["PBillId"]);
}
else
{
m_sBillId = String.Format("{0},{1}", m_sBillId, dtFilter.Rows[k]["PBillId"]);
}
}
m_sBillId = m_sBillId.TrimEnd(',');
if (m_sBillId == "")
{
m_sBillId = "0";
}
//Insert into Temp Table
ProgBillBL.InsertDLDate(m_sLeadId, m_sBillId, dtFilter);
}
}
}
return(m_sBillId);
}
