protected void FillTb()
{
string strSql = "SELECT "
+ " NamaTagihan"
+ ",TglJT"
+ ",NilaiTagihan"
+ ",NoUrut"
+ ",Tipe"
+ ",(NilaiTagihan - (SELECT ISNULL(SUM(NilaiPelunasan),0) FROM MS_PELUNASAN WHERE NoTagihan = MS_TAGIHAN.NoUrut AND NoKontrak = '" + nomor + "') ) AS SisaTagihan"
+ " FROM MS_TAGIHAN"
+ " WHERE NoKontrak = '" + nomor + "' and Tipe != 'ADM'"
+ " ORDER BY NoUrut";
DataTable rs = Db.Rs(strSql);
Rpt.NoData(rpt, rs, "Daftar tagihan untuk kontrak tersebut masih kosong.");
for (int i = 0; i < rs.Rows.Count; i++)
{
if (!Response.IsClientConnected)
{
break;
}
TableRow r = new TableRow();
TableCell c;
c = new TableCell();
c.Text = rs.Rows[i]["NoUrut"].ToString();
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["NamaTagihan"].ToString();
r.Cells.Add(c);
c = new TableCell();
c.Text = ":";
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
c = new TableCell();
c.Text = "Rp. ";
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
c = new TableCell();
c.Text = Cf.Num(rs.Rows[i]["NilaiTagihan"]);
c.HorizontalAlign = HorizontalAlign.Right;
r.Cells.Add(c);
c = new TableCell();
c.Text = " ";
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
c = new TableCell();
c.Text = Cf.DayIndoShort(rs.Rows[i]["TglJT"]);
r.Cells.Add(c);
c = new TableCell();
c.Text = " ";
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
Rpt.Border(r);
rpt.Rows.Add(r);
}
}
