private void BindData()
{
pob = rt.palm_opd_pathlogy_billms.Single(palm_opd_pathlogy_billm => palm_opd_pathlogy_billm.memo == Session["memo"].ToString());
DataSet ds = new DataSet();
DataSet ds1 = new DataSet();
StringBuilder htmlTable = new StringBuilder();
ds = objb.getpathology_billby_pateint_code(Session["memo"].ToString());
ds1 = objb.getpathology_totalbillby_pateint_code(Session["memo"].ToString());
htmlTable.Append("<table style='width:100%' border=2px>");
htmlTable.Append("<tr ><th>Sr.No.</th><th>Investigation</th><th>Amount</th></tr>");
if (!object.Equals(ds.Tables[0], null))
{
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
htmlTable.Append("<tr>");
htmlTable.Append("<td align='center'>" + Convert.ToInt32(i + 1) + "</td>");
htmlTable.Append("<td align='center'>" + ds.Tables[0].Rows[i]["test_name"] + "</td>");
htmlTable.Append("<td align='center'>" + ds.Tables[0].Rows[i]["charge"] + "</td>");
htmlTable.Append("</tr>");
}
htmlTable.Append("</table>");
htmlTable.Append("</br>");
htmlTable.Append("<table>");
htmlTable.Append("<tr>");
htmlTable.Append("<td align='center' colspan='4'> <table width=100% >");
htmlTable.Append("<tr><td> </td><td> </td>");
htmlTable.Append("<td>Total</td><td>" + ds1.Tables[0].Rows[0]["total"] + "</td></tr>");
htmlTable.Append("<tr><td> </td><td></td>");
htmlTable.Append("<td>Advance</td><td>" + pob.advanced + "</td></tr>");
htmlTable.Append("<tr><td> Thank You ! </td><td></td>");
htmlTable.Append("<td>Balence Total</td><td>" + pob.balence + "</td></tr>");
htmlTable.Append("<tr><td><B>Emergency : +91-22-27668119<br/>Email:[email protected]</B><br/>Economic-class Professional Treatment With Care</td><td width='200px'></td><td colspan='2' style='vertical-align:bottom; '>Received Signature</td></tr>");
htmlTable.Append("</table></td>");
/* htmlTable.Append("<td align='center'> Total</td>");
* htmlTable.Append("<td align='center'><asp:Label ID=''label1 runat='server'>"+ds1.Tables[0].Rows[0]["total"]+"</asp:Label></td>");*/
htmlTable.Append("</tr>");
htmlTable.Append("</table>");
PlaceHolder2.Controls.Add(new Literal {
Text = htmlTable.ToString()
});
}
else
{
htmlTable.Append("<tr>");
htmlTable.Append("<td align='center' colspan='4'>There is no Record.</td>");
htmlTable.Append("</tr>");
}
}
}
