private void Cek(string path)
{
string strSql = "SELECT * FROM [SLIP$]";
DataTable rs = new DataTable();
try
{
rs = Db.xls(strSql, path);
}
catch {}
if (Rpt.ValidateXls(rs, rule, gagal))
{
Save(path);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Session["belong"] = "0";
using (var db = new SiewebEntities())
{
var se = from it in db.teacher
where it.lang == 0
orderby it.updatetime descending
select it;
Rpt.DataSource = se.ToList();
Rpt.DataBind();
}
}
}
private void Header()
{
System.Text.StringBuilder x = new System.Text.StringBuilder();
Rpt.Judul(x, comp, judul);
DateTime Dari = Db.SingleTime("SELECT FilterDari FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'");
DateTime Sampai = Db.SingleTime("SELECT FilterSampai FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'");
Rpt.SubJudul(x
, "Tanggal PPJB : " + Cf.Day(Dari) + " s/d " + Cf.Day(Sampai)
);
Rpt.SubJudul(x
, "Project : " + Project
);
Rpt.HeaderReport(headReport, "", x);
}
private void SubTotal(string txt, decimal t1, decimal t2, decimal t3, decimal t4, decimal t5, decimal t6, decimal t7)
{
TableRow r = new TableRow();
TableCell c;
c = Rpt.Foot();
c.Text = txt;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
c = Rpt.Foot();
c.Text = Cf.Num(t1) + " UNIT";
c.HorizontalAlign = HorizontalAlign.Right;
r.Cells.Add(c);
c = Rpt.Foot();
c.Text = Cf.Num(t2);
c.HorizontalAlign = HorizontalAlign.Right;
r.Cells.Add(c);
c = Rpt.Foot();
c.Text = Cf.Num(t3);
c.HorizontalAlign = HorizontalAlign.Right;
r.Cells.Add(c);
c = Rpt.Foot();
c.Text = Cf.Num(t4);
c.HorizontalAlign = HorizontalAlign.Right;
r.Cells.Add(c);
c = Rpt.Foot();
c.Text = Cf.Num(t5);
c.HorizontalAlign = HorizontalAlign.Right;
r.Cells.Add(c);
c = Rpt.Foot();
c.Text = Cf.Num(t6);
c.HorizontalAlign = HorizontalAlign.Right;
r.Cells.Add(c);
c = Rpt.Foot();
c.Text = Cf.Num(t7);
c.HorizontalAlign = HorizontalAlign.Right;
r.Cells.Add(c);
rpt.Rows.Add(r);
}
private void Fill()
{
string strSql = "SELECT * FROM ISC064_MARKETINGJUAL..MS_FOLLOWUP ORDER BY NoFU";
DataTable rs = Db.Rs(strSql);
Rpt.NoData(rpt, rs, "Tidak ditemukan data follow up dengan keyword diatas.");
for (int i = 0; i < rs.Rows.Count; i++)
{
if (!Response.IsClientConnected)
{
break;
}
TableRow r = new TableRow();
TableCell c;
c = new TableCell();
c.Text = "<a href=\"javascript:call('" + rs.Rows[i]["NoKontrak"] + "','" + rs.Rows[i]["NoFU"] + "')\">"
+ rs.Rows[i]["NoKontrak"].ToString() + "." + rs.Rows[i]["NoFU"].ToString();
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = Cf.Day(rs.Rows[i]["TglFU"]);
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["NamaGrouping"].ToString();
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = Db.SingleString("SELECT Nama FROM ISC064_MARKETINGJUAL..MS_CUSTOMER WHERE NOCUSTOMER IN(SELECT NOCUSTOMER FROM ISC064_MARKETINGJUAL..MS_FOLLOWUP WHERE NOKONTRAK = '" + rs.Rows[i]["NoKontrak"].ToString() + "')");
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["Ket"].ToString();
c.Wrap = false;
r.Cells.Add(c);
Rpt.Border(r);
rpt.Rows.Add(r);
}
}
private void Header()
{
System.Text.StringBuilder x = new System.Text.StringBuilder();
Rpt.Judul(x, comp, judul);
if (statusA.Checked)
{
Rpt.SubJudul(x, "Status : " + statusA.Text);
}
else if (statusB.Checked)
{
Rpt.SubJudul(x, "Status : " + statusB.Text);
}
else
{
Rpt.SubJudul(x, "Status : " + statusS.Text);
}
string tgl = "";
if (tglkontrak.Checked)
{
tgl = tglkontrak.Text;
}
DateTime Dari = Convert.ToDateTime(dari.Text);
DateTime Sampai = Convert.ToDateTime(sampai.Text);
Rpt.SubJudul(x
, tgl + " : " + Cf.Day(dari.Text) + " s/d " + Cf.Day(sampai.Text)
);
Rpt.SubJudul(x
, "Jenis : " + Rpt.inSql(jenis).Replace("'", "")
);
Rpt.SubJudul(x
, "Lokasi : " + lokasi.SelectedItem.Text
);
Rpt.SubJudul(x
, "Sales : " + agent.SelectedItem.Text
);
Rpt.Header(rpt, x);
}
private void SubTotal(decimal GrandTotal)
{
TableRow r = new TableRow();
TableCell c;
c = Rpt.Foot();
c.Text = "Grand Total";
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
c = Rpt.Foot();
c.Text = Cf.Num(GrandTotal);
c.HorizontalAlign = HorizontalAlign.Right;
r.Cells.Add(c);
rpt.Rows.Add(r);
}
protected void SubTotal(decimal t)
{
TableRow r = new TableRow();
TableCell c;
c = Rpt.Foot();
c.Text = "<strong>TOTAL</strong>";
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
c = Rpt.Foot();
c.Text = "<strong>" + Cf.Num(t) + "</strong>";
c.HorizontalAlign = HorizontalAlign.Right;
r.Cells.Add(c);
rpt.Rows.Add(r);
}
private void Header()
{
System.Text.StringBuilder x = new System.Text.StringBuilder();
Rpt.Judul(x, comp, judul);
Rpt.SubJudul(x
, "Project : " + project.SelectedValue
);
Rpt.SubJudul(x
, "Perusahaan : " + pers.SelectedItem.Text
);
string legend = "Status: A = Aktif / B = Batal.";
Rpt.HeaderReport(headReport, legend, x);
}
protected void fillNext(byte Lvl)
{
TableRow r = new TableRow();
TableCell c;
c = new TableCell();
c.Text = " ";
r.Cells.Add(c);
c = new TableCell();
c.Text = "<a href='ApprovalDetailEdit.aspx?lvl=" + Lvl + "&tipe=" + TipeApproval + "&project=" + Project + "'><p style='font-size:14pt;font-weight:bold;'>Edit / Delete</p></a>";
r.Cells.Add(c);
Rpt.Border(r);
rpt.Rows.Add(r);
}
private void Header()
{
System.Text.StringBuilder x = new System.Text.StringBuilder();
Rpt.Judul(x, comp, judul);
if (statusA.Checked)
{
Rpt.SubJudul(x, "Status : " + statusA.Text);
}
else if (statusB.Checked)
{
Rpt.SubJudul(x, "Status : " + statusB.Text);
}
else
{
Rpt.SubJudul(x, "Status : " + statusS.Text);
}
string tgl = "";
if (tglkontrak.Checked)
{
tgl = tglkontrak.Text;
}
DateTime Dari = Convert.ToDateTime(dari.Text);
DateTime Sampai = Convert.ToDateTime(sampai.Text);
Rpt.SubJudul(x
, tgl + " : " + Cf.Day(dari.Text) + " s/d " + Cf.Day(sampai.Text)
);
Rpt.SubJudul(x
, "Project : " + project.SelectedValue
);
Rpt.SubJudul(x
, "Perusahaan : " + pers.SelectedItem.Text
);
//Rpt.Header(rpt, x);
string legend = "Status: A = Aktif / B = Batal.";
Rpt.HeaderReport(headReport, legend, x);
}
private void Header()
{
System.Text.StringBuilder x = new System.Text.StringBuilder();
Rpt.Judul(x, comp, judul);
if (StatusA != "")
{
Rpt.SubJudul(x, "Status : " + StatusA);
}
else if (StatusB != "")
{
Rpt.SubJudul(x, "Status : " + StatusB);
}
else if (StatusH != "")
{
Rpt.SubJudul(x, "Status : " + StatusH);
}
else
{
Rpt.SubJudul(x, "Status : " + StatusS);
}
Rpt.SubJudul(x
, "Tipe : " + Jenis
);
Rpt.SubJudul(x
, "Lokasi : " + Lokasi
);
Rpt.SubJudul(x
, "Project : " + Project
);
Rpt.SubJudul(x
, "Perusahaan : " + Perusahaan
);
string legend = "Status: A = Available / S = Sold / H = Hold."
+ "<br />"
+ "Luas dalam meter persegi.Harga price list adalah dalam rupiah.";
//Rpt.Header(rpt, x);
Rpt.HeaderReport(headReport, legend, x);
}
private void Header()
{
System.Text.StringBuilder x = new System.Text.StringBuilder();
Rpt.Judul(x, comp, judul);
if (StatusA != "")
{
Rpt.SubJudul(x, "Status : " + StatusA);
}
else if (StatusB != "")
{
Rpt.SubJudul(x, "Status : " + StatusB);
}
else
{
Rpt.SubJudul(x, "Status : " + StatusS);
}
DateTime Dari = Db.SingleTime("SELECT FilterDari FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'");
DateTime Sampai = Db.SingleTime("SELECT FilterSampai FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'");
Rpt.SubJudul(x
, "Tanggal Kontrak" + " : " + Cf.Day(Dari) + " s/d " + Cf.Day(Sampai)
);
Rpt.SubJudul(x
, "Jenis : " + Jenis//Rpt.inSql(jenis).Replace("'","")
);
Rpt.SubJudul(x
, "Lokasi : " + Lokasi
);
Rpt.SubJudul(x
, "Sales : " + Agent
);
//Rpt.Header(rpt, x);
string legend = "Status: A = Aktif / B = Batal.< br />"
+ "Luas dalam meter persegi.Gross adalah harga sebelum diskon.";
Rpt.HeaderReport(headReport, legend, x);
}
private void SetBarisPM(TextBox Kali, string Tipe, string Nama, TextBox nominal)
{
int count = Convert.ToInt32(Kali.Text);
int index = rpt.Rows.Count - 1;
for (int i = 0; i < count; i++)
{
if (!Response.IsClientConnected)
{
break;
}
TableRow r = new TableRow();
TableCell c;
index++;
c = new TableCell();
c.Text = index.ToString() + ".";
r.Cells.Add(c);
c = new TableCell();
c.Text = Tipe;
r.Cells.Add(c);
c = new TableCell();
int countkpr = Db.SingleInteger("select count(*) from REF_SKEMA_DETAIL where KPR = 1 AND Nomor = " + skema.SelectedValue);
if (countkpr != 0)
{
c.Text = Nama;
}
else
{
c.Text = Nama + " " + (i + 1);
}
r.Cells.Add(c);
c = new TableCell();
c.Text = Cf.Day(DateTime.Today);
r.Cells.Add(c);
Rpt.Border(r);
rpt.Rows.Add(r);
}
}
protected void SubTotal(decimal t1, decimal t2, decimal t3, decimal t4, decimal t5, decimal t6, decimal t7)
{
TableRow r = new TableRow();
TableCell c;
c = Rpt.Foot();
c.Text = "<strong>TOTAL</strong>";
c.ColumnSpan = 14;
r.Cells.Add(c);
c = Rpt.Foot();
c.Text = Cf.Num(t1);
c.HorizontalAlign = HorizontalAlign.Right;
r.Cells.Add(c);
c = Rpt.Foot();
c.Text = Cf.Num(t3);
c.HorizontalAlign = HorizontalAlign.Right;
r.Cells.Add(c);
c = Rpt.Foot();
c.Text = Cf.Num(t4);
c.HorizontalAlign = HorizontalAlign.Right;
r.Cells.Add(c);
c = Rpt.Foot();
c.Text = Cf.Num(t2);
c.HorizontalAlign = HorizontalAlign.Right;
r.Cells.Add(c);
c = Rpt.Foot();
c.Text = Cf.Num(Math.Round(t5));
c.HorizontalAlign = HorizontalAlign.Right;
r.Cells.Add(c);
c = Rpt.Foot();
c.Text = Cf.Num(Math.Round(t6));
c.HorizontalAlign = HorizontalAlign.Right;
r.Cells.Add(c);
rpt.Rows.Add(r);
}
private void Header()
{
System.Text.StringBuilder x = new System.Text.StringBuilder();
Rpt.Judul(x, comp, judul);
DateTime Dari = Convert.ToDateTime(dari.Text);
DateTime Sampai = Convert.ToDateTime(sampai.Text);
Rpt.SubJudul(x
, "Tanggal : " + Cf.Day(dari.Text) + " s/d " + Cf.Day(sampai.Text)
);
//Rpt.Header(rpt, x);
string legend = "";
Rpt.HeaderReport(headReport, legend, x);
}
protected void xls_Click(object sender, System.EventArgs e)
{
if (valid())
{
Report();
//rpt.Controls.Add(rptC);
rp.Controls.Add(headJudul);
rp.Controls.Add(lblA);
rp.Controls.Add(rptA);
rp.Controls.Add(lblB);
rp.Controls.Add(rptB);
rp.Controls.Add(lblC);
rp.Controls.Add(rpt);
rp.Controls.Add(lblD);
rp.Controls.Add(rptD);
Rpt.ToExcel(this, rp);
}
}
private void SubTotal(string txt, decimal t1)
{
TableRow r = new TableRow();
TableCell c;
c = Rpt.Foot();
c.Text = txt;
c.ColumnSpan = 12;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
//c = Rpt.Foot();
//c.Text = Cf.Num(t1);
//c.HorizontalAlign = HorizontalAlign.Right;
//r.Cells.Add(c);
rpt.Rows.Add(r);
}
private void DataBindToRepeater(int currentPage, List <Author> datascore)
{
PagedDataSource pds = new PagedDataSource();
pds.AllowPaging = true;
pds.PageSize = 5;
pds.DataSource = datascore;
lbTotal.Text = pds.PageCount.ToString();
pds.CurrentPageIndex = currentPage - 1;
Rpt.DataSource = pds;
Rpt.DataBind();
}
private void FillTable()
{
decimal t = 0;
DataTable rs = Db.Rs("SELECT * FROM MS_TUNGGAKAN_DETIL WHERE NoTunggakan = " + NoTunggakan);
for (int i = 0; i < rs.Rows.Count; i++)
{
if (!Response.IsClientConnected)
{
break;
}
TableRow r = new TableRow();
TableCell c;
c = new TableCell();
c.Text = Cf.Day(rs.Rows[i]["TglJT"]);
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["Telat"] + " Hari";
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["NamaTagihan"].ToString();
r.Cells.Add(c);
c = new TableCell();
c.Text = Cf.Num(rs.Rows[i]["Nilai"]);
c.HorizontalAlign = HorizontalAlign.Right;
r.Cells.Add(c);
t = t + (decimal)rs.Rows[i]["Nilai"];
Rpt.Border(r);
rpt.Rows.Add(r);
if (i == rs.Rows.Count - 1)
{
SubTotal(t);
}
}
}
protected void FillDetil()
{
DataTable rs2 = Db.Rs("SELECT * FROM MS_PELUNASAN_KPA WHERE NoRealKPA=" + nomor);
for (int i = 0; i < rs2.Rows.Count; i++)
{
TableCell c;
TableRow r = new TableRow();
DataTable tts = Db.Rs("SELECT * FROM " + Mi.DbPrefix + "FINANCEAR..MS_TTS WHERE NoTTS=" + rs2.Rows[i]["NoTTS"]);
c = new TableCell();
c.Text = tts.Rows[0]["NoTTS2"].ToString();
r.Cells.Add(c);
c = new TableCell();
c.Text = "<b>" + tts.Rows[0]["Status"].ToString() + "</b>";
if (tts.Rows[0]["Status"].ToString() == "VOID")
{
c.ForeColor = Color.Red;
}
r.Cells.Add(c);
c = new TableCell();
c.Text = rs2.Rows[i]["NoKontrak"].ToString();
r.Cells.Add(c);
c = new TableCell();
c.Text = tts.Rows[0]["Customer"].ToString();
r.Cells.Add(c);
c = new TableCell();
c.Text = tts.Rows[0]["Unit"].ToString();
r.Cells.Add(c);
c = new TableCell();
c.CssClass = "txt_num";
c.Text = Cf.Num(rs2.Rows[i]["NilaiPelunasan"]);
r.Cells.Add(c);
Rpt.Border(r);
rpt.Rows.Add(r);
}
}
protected void CarregaGrid()
{
try
{
AudienciaNegocios oNegocios = new AudienciaNegocios();
oList = oNegocios.Listar(new AudienciaModel());
if (oList.Count > 0)
{
Rpt.DataSource = oList;
Rpt.DataBind();
}
}
catch (Exception ex)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "EROOR", "$(document).MensagemModal(3,'Ocorreu um erro inesperado! Mensagem = " + new JavaScriptSerializer().Serialize(ex.Message.ToString()) + "');", true);
}
}
private void ListarAudiencia(int Id)
{
AudienciaModel oModel = new AudienciaModel();
List <AudienciaModel> oListModel = new List <AudienciaModel>();
AudienciaNegocios oNegocios = new AudienciaNegocios();
oModel.Id = Id;
oListModel = oNegocios.Listar(oModel);
if (oListModel.Count > 0)
{
Rpt.DataSource = oListModel;
Rpt.DataBind();
}
else
{
Rpt.DataSource = new List <AudienciaModel>();
Rpt.DataBind();
}
}
private void Fill()
{
string strSql = "SELECT *"
+ " FROM MS_KOMISIR"
+ " WHERE NoKomisiR + NoKomisiP + Ket "
+ " LIKE '%" + Cf.Str(keyword.Text) + "%'"
+ " AND Project IN (" + Act.ProjectListSql + ")"
+ " ORDER BY NoKomisiR";
DataTable rs = Db.Rs(strSql);
Rpt.NoData(rpt, rs, "Tidak ditemukan data realisasi komisi dengan keyword diatas.");
for (int i = 0; i < rs.Rows.Count; i++)
{
if (!Response.IsClientConnected)
{
break;
}
TableRow r = new TableRow();
TableCell c;
c = new TableCell();
c.Text = "<a href=\"javascript:call('" + rs.Rows[i]["NoKomisiR"] + "')\">"
+ rs.Rows[i]["NoKomisiR"].ToString() + "</a>";
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = Cf.Day(rs.Rows[i]["Tgl"]);
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["Ket"].ToString();
c.Wrap = false;
r.Cells.Add(c);
Rpt.Border(r);
rpt.Rows.Add(r);
}
}
private void Header()
{
System.Text.StringBuilder x = new System.Text.StringBuilder();
Rpt.Judul(x, comp, judul);
DateTime Dari = Convert.ToDateTime(dari.Text);
DateTime Sampai = Convert.ToDateTime(sampai.Text);
Rpt.SubJudul(x
, "Tanggal: " + Cf.Day(dari.Text) + " s/d " + Cf.Day(sampai.Text)
);
Rpt.SubJudul(x
, "Jenis PPN: DITANGGUNG " + JenisPPN.SelectedItem.Text
);
Rpt.Header(rpt, x);
}
private void SubTotal(decimal t1, decimal t2, decimal t3, decimal t4, decimal t5, decimal t6)
{
TableRow r = new TableRow();
TableCell c;
c = Rpt.Foot();
c.Text = "TOTAL";
c.HorizontalAlign = HorizontalAlign.Left;
c.VerticalAlign = VerticalAlign.Top;
r.Cells.Add(c);
c = Rpt.Foot();
c.Text = Cf.Num(t1);
c.HorizontalAlign = HorizontalAlign.Right;
r.Cells.Add(c);
c = Rpt.Foot();
c.Text = Cf.Num(t2);
c.HorizontalAlign = HorizontalAlign.Right;
r.Cells.Add(c);
c = Rpt.Foot();
c.Text = Cf.Num(t3);
c.HorizontalAlign = HorizontalAlign.Right;
r.Cells.Add(c);
c = Rpt.Foot();
c.Text = Cf.Num(t4);
c.HorizontalAlign = HorizontalAlign.Right;
r.Cells.Add(c);
c = Rpt.Foot();
c.Text = Cf.Num(t5);
c.HorizontalAlign = HorizontalAlign.Right;
r.Cells.Add(c);
c = Rpt.Foot();
c.Text = Cf.Num(t6);
c.HorizontalAlign = HorizontalAlign.Right;
r.Cells.Add(c);
rpt.Rows.Add(r);
}
private void Header()
{
System.Text.StringBuilder x = new System.Text.StringBuilder();
Rpt.Judul(x, comp, judul);
DateTime Dari = Convert.ToDateTime(dari.Text);
DateTime Sampai = Convert.ToDateTime(sampai.Text);
Rpt.SubJudul(x
, "Tanggal : " + Cf.Day(dari.Text) + " s/d " + Cf.Day(sampai.Text)
);
Rpt.SubJudul(x
, "Rekening Bank : " + ddlAcc.SelectedItem.Text
);
Rpt.Header(rpt, x);
}
private void Header()
{
System.Text.StringBuilder x = new System.Text.StringBuilder();
Rpt.Judul(x, comp, judul);
Rpt.SubJudul(x
, "Lokasi : " + lokasi.SelectedItem.Text
);
string tgl = "";
if (tbTarget.Checked)
{
tgl = tbTarget.Text;
}
if (tbTgl.Checked)
{
tgl = tbTgl.Text;
}
DateTime Dari = Convert.ToDateTime(dari.Text);
DateTime Sampai = Convert.ToDateTime(sampai.Text);
Rpt.SubJudul(x
, tgl + " : " + Cf.Day(dari.Text) + " s/d " + Cf.Day(sampai.Text)
);
Rpt.SubJudul(
x, "Status LPA : " + ddlStatus.SelectedItem.Text
);
Rpt.SubJudul(
x, "Project : " + project.SelectedValue
);
Rpt.SubJudul(
x, "Perusahaan : " + pers.SelectedItem.Text
);
//Rpt.Header(rpt, x);
Rpt.HeaderReport(headReport, "", x);
}
private void ListaPerfilAcesso(int IdFunc)
{
PerfilAcessoFuncionarioModel oModel = new PerfilAcessoFuncionarioModel();
List <PerfilAcessoFuncionarioModel> oListModel = new List <PerfilAcessoFuncionarioModel>();
PerfilAcessoFuncionarioNegocios oNegocios = new PerfilAcessoFuncionarioNegocios();
oModel.Codigo_Funcionario = IdFunc;
oListModel = oNegocios.Listar(oModel);
if (oListModel.Count > 0)
{
Rpt.DataSource = oListModel;
Rpt.DataBind();
}
else
{
Rpt.DataSource = new List <PerfilAcessoFuncionarioModel>();
Rpt.DataBind();
}
}
private void FillOld()
{
string strSql = "SELECT * FROM MS_TAGIHAN where NoKontrak = '" + NoKontrak + "'"
//+ " AND Nokontrak = '" + NoKontrak + "' AND Tipe <> 'ADM'"
+ " ORDER BY NoUrut";
DataTable rs = Db.Rs(strSql);
Rpt.NoData(rptTagihanNew, rs, "No Reservation.");
decimal TotalOld = 0;
for (int i = 0; i < rs.Rows.Count; i++)
{
TableRow r = new TableRow();
TableCell c;
c = new TableCell();
c.Text = rs.Rows[i]["NoUrut"].ToString();
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["Tipe"].ToString();
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["NamaTagihan"].ToString();
r.Cells.Add(c);
c = new TableCell();
c.Text = Cf.Day(Convert.ToDateTime(rs.Rows[i]["TglJT"]));
r.Cells.Add(c);
c = new TableCell();
c.Text = Cf.Num(Convert.ToDecimal(rs.Rows[i]["NilaiTagihan"]));
r.Cells.Add(c);
TotalOld += Convert.ToDecimal(rs.Rows[i]["NilaiTagihan"]);
Rpt.Border(r);
rptTagihanOld.Rows.Add(r);
}
grandTotalold.Text = Cf.Num(TotalOld);
}
