private void newHeader() { string header = "<h2>" + Mi.Pt + "</h2>"; header += "<h1 class='title'>LAPORAN MASTER STOCK PER LANTAI</h1>"; header += "<h4>Lokasi : " + lokasi.SelectedItem.Text; header += "<br>Project : " + project.SelectedItem.Text + "</h4>"; header += "Laporan dihasilkan pada hari " + Cf.IndoWeek(DateTime.Today); header += ", " + Cf.Date(DateTime.Now) + " dari workstation " + Act.IP + " oleh user " + Act.UserID + "<br /><br />"; headJudul.Text = header; }
private void newHeader() { string header = "<p>" + Mi.Pt + "</p>"; header += "<h1 class='title'>LAPORAN PAJAK</h1>"; header += "Periode : " + Cf.Day(dari.Text) + " s/d " + Cf.Day(sampai.Text) + "<br>"; header += "Project : " + project.SelectedValue + "<br>"; header += "Perusahaan : " + pers.SelectedItem.Text + "<br>"; header += "<br/> Laporan dihasilkan pada hari " + Cf.IndoWeek(DateTime.Today); header += ", " + Cf.Date(DateTime.Now) + " dari workstation " + Act.IP + " oleh user " + Act.UserID + "<br />"; headJudul.Text = header; //Response.Write(header); }
private void newHeader() { DateTime Dari = Db.SingleTime("SELECT FilterDari FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'"); DateTime Sampai = Db.SingleTime("SELECT FilterSampai FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'"); string header = "<p>" + Mi.Pt + "</p>"; header += "<h1 class='title'>LAPORAN PROYEKSI PENERIMAAN</h1>"; header += "Periode : " + Cf.Day(Dari) + " s/d " + Cf.Day(Sampai); header += "<br/> Laporan dihasilkan pada hari " + Cf.IndoWeek(DateTime.Today); header += ", " + Cf.Date(DateTime.Now) + " dari workstation " + Act.IP + " oleh user " + Act.UserID + "<br /><br />"; headJudul.Text = header; }
private void newHeader() { string header = "<h2>" + Mi.Pt + "</h2>"; header += "<h1 class='title'>LAPORAN PENJUALAN TAHUNAN</h1>"; header += "Periode : " + thn1.SelectedValue + " s/d " + thn2.SelectedValue; header += "<br/>Jenis : " + Rpt.inSql(jenis).Replace("'", ""); header += "<br/>Lokasi : " + lokasi.SelectedItem.Text; header += "<br/>Principal : " + agent.SelectedItem.Text; header += "<br/>Perusahaan : " + pers.SelectedValue; header += "<br/>Project : " + project.SelectedValue; header += "<br/> Laporan dihasilkan pada hari " + Cf.IndoWeek(DateTime.Today); header += ", " + Cf.Date(DateTime.Now) + " dari workstation " + Act.IP + " oleh user " + Act.UserID + "<br /><br />"; headJudul.Text = header; }
private void newHeader() { DateTime Dari = Db.SingleTime("SELECT FilterDari FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'"); DateTime Sampai = Db.SingleTime("SELECT FilterSampai FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'"); string header = "<p>" + Mi.Pt + "</p>"; header += "<h1 class='title'>LAPORAN PAJAK</h1>"; header += "Periode : " + Cf.Day(Dari) + " s/d " + Cf.Day(Sampai) + "<br>"; header += "Project : " + Project + "<br>"; string pers = (Perusahaan == "SEMUA") ? "SEMUA" : Db.SingleString("SELECT Nama FROM " + Mi.DbPrefix + "SECURITY..REF_PERS WHERE Pers = '" + Perusahaan + "'"); header += "Perusahaan : " + pers + "<br>"; header += "<br/> Laporan dihasilkan pada hari " + Cf.IndoWeek(DateTime.Today); header += ", " + Cf.Date(DateTime.Now) + " dari workstation " + Act.IP + " oleh user " + Act.UserID + "<br />"; headJudul.Text = header; //Response.Write(header); }
private void Fill() { string strSql = "SELECT * FROM MS_BAST A INNER JOIN MS_KONTRAK B ON A.NoKontrak = B.NoKontrak " + "INNER JOIN MS_CUSTOMER C ON B.NoCustomer = C.NoCustomer" + " WHERE A.NoKontrak = '" + nomor + "'"; DataTable rs = Db.Rs(strSql); if (rs.Rows.Count != 0) { string[] SplitDate = Cf.DaySlash1(rs.Rows[0]["TglST"]).ToString().Split('/'); string Thns = SplitDate[2]; string Blns = SplitDate[1]; nomorl.Text = "BAST-" + Thns + Blns + rs.Rows[0]["NoST"].ToString(); //tgl.Text = Cf.Day(rs.Rows[0]["TglST"]); harist.Text = Cf.IndoWeek(Convert.ToDateTime(rs.Rows[0]["TglST"])); tglst.Text = Cf.Day(rs.Rows[0]["TglST"]); string[] Times = Cf.Time(rs.Rows[0]["TglST"]).ToString().Split(':'); string Jam = Times[0]; string Menit = Times[1]; jamst.Text = Jam + ":" + Menit; Namacs.Text = rs.Rows[0]["Nama"].ToString(); Alamatcs.Text = rs.Rows[0]["KTP1"].ToString(); ktpcs.Text = rs.Rows[0]["NoKTP"].ToString(); DataTable r = Db.Rs("SELECT * FROM MS_UNIT WHERE NoUnit = '" + rs.Rows[0]["NoUnit"].ToString() + "'"); if (r.Rows.Count != 0) { nounit1.Text = r.Rows[0]["NoUnit"].ToString(); lantai1.Text = r.Rows[0]["Lantai"].ToString(); nounit1.Text = r.Rows[0]["Nomor"].ToString(); tipe1.Text = r.Rows[0]["Jenis"].ToString(); luas1.Text = Cf.Num(r.Rows[0]["LuasSG"]).ToString(); semigross1.Text = Cf.Num(r.Rows[0]["LuasNett"]).ToString(); } } }
private void Header() { System.Text.StringBuilder x = new System.Text.StringBuilder(); x.Append("<br>Laporan dihasilkan pada hari : " + Cf.IndoWeek(DateTime.Today) + ", " + Cf.Date(DateTime.Now) + " dari workstation : " + Act.IP + " dan username : "******"<h3>" + Mi.Pt + "</h3>" + "<h1 class='title'>LAPORAN REALISASI SALES & CASH IN</h1>" + "Periode " + Cf.Monthname(Convert.ToInt32(bulandari.SelectedValue)) + " " + Convert.ToInt32(tahundari.SelectedValue) + " s/d " + Cf.Monthname(Convert.ToInt32(bulansampai.SelectedValue)) + " " + Convert.ToInt32(tahunsampai.SelectedValue) + "<br />" + "Project : " + project.SelectedValue + "<br>Perusahaan : " + pers.SelectedItem.Text + "<br>Lokasi : " + tower.SelectedItem.Text + "<br>Lantai : " + lt.SelectedItem.Text + x + "<br />" + "<br />" ; }
private void Report2() { param.Visible = false; rpt.Visible = true; string tgl = ""; if (tglinput.Checked) { tgl = tglinput.Text; } DateTime Dari = Convert.ToDateTime(dari.Text); DateTime Sampai = Convert.ToDateTime(sampai.Text); lblHeader.Text = Mi.Pt + "<br />" + "Laporan Kasir NUP" + "<br />" + tgl + " : " + Cf.Day(dari.Text) + " s/d " + Cf.Day(sampai.Text) ; System.Text.StringBuilder x = new System.Text.StringBuilder(); x.Append("<br /><span style='font-weight: normal;'>Laporan dihasilkan pada hari : " + Cf.IndoWeek(DateTime.Today) + ", " + Cf.Date(DateTime.Now) + " dari workstation : " + Act.IP + " dan username : "******"</span>" ); lblSubHeader.Text = x.ToString(); Fill(); }
protected void Report() { lblHeader.Text = Mi.Pt + "<br />" + "Laporan Revisi NUP" ; System.Text.StringBuilder x = new System.Text.StringBuilder(); x.Append("<br />Untuk Project : " + Cf.Str(Project)); x.Append("<br /><span style='font-weight: normal;'>Laporan dihasilkan pada hari : " + Cf.IndoWeek(DateTime.Today) + ", " + Cf.Date(DateTime.Now) + " dari workstation : " + Act.IP + " dan username : "******"</span>" ); lblSubHeader.Text = x.ToString(); Fill(); }
protected void Report() { lblHeader.Text = Mi.Pt + "<br />" + "Laporan Kasir NUP" ; System.Text.StringBuilder x = new System.Text.StringBuilder(); DateTime Tanggal1 = Db.SingleTime("SELECT FilterDari FROM " + Mi.DbPrefix + "MARKETINGJUAL..LapPDF WHERE AttachmentID = '" + AttachmentID + "'"); DateTime Tanggal2 = Db.SingleTime("SELECT FilterSampai FROM " + Mi.DbPrefix + "MARKETINGJUAL..LapPDF WHERE AttachmentID = '" + AttachmentID + "'"); x.Append("<br />Untuk tanggal : " + Cf.Day(Tanggal1) + " s/d " + Cf.Day(Tanggal2)); x.Append("<br />Untuk Project : " + Cf.Str(Project)); x.Append("<br />Untuk Kasir : " + Cf.Str(Kasir)); x.Append("<br /><span style='font-weight: normal;'>Laporan dihasilkan pada hari : " + Cf.IndoWeek(DateTime.Today) + ", " + Cf.Date(DateTime.Now) + " dari workstation : " + Act.IP + " dan username : "******"</span>" ); lblSubHeader.Text = x.ToString(); Fill(); }
private void Report() { DateTime Dari = Db.SingleTime("SELECT FilterDari FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'"); DateTime Sampai = Db.SingleTime("SELECT FilterSampai FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'"); param.Visible = false; rpt.Visible = true; lblHeader.Text = "<p>" + Mi.Pt + "</p>" + "<h1 class='title'>Laporan Sales Performance</h1>" ; System.Text.StringBuilder x = new System.Text.StringBuilder(); x.Append("Sales : " + nAgent); string nstatussales = String.Empty; if (StatusSales == "I") { nstatussales = "Inaktif"; } else if (StatusSales == "A") { nstatussales = "Aktif"; } else { nstatussales = "Semua"; } x.Append("<br />Status Agent : " + nstatussales); if (FilterTgl == "0") { x.Append("<br />Tgl Kontrak : " + Cf.Day(Dari) + " s/d " + Cf.Day(Sampai)); } else { x.Append("<br />Tgl Kontrak : As Of : " + Cf.Day(TglAsOf)); } x.Append("<br />Project : " + Project); x.Append("<br /><br /><span style='font-weight: normal;'>Laporan dihasilkan pada hari : " + Cf.IndoWeek(DateTime.Today) + ", " + Cf.Date(DateTime.Now) + " dari workstation : " + Act.IP + " dan username : "******"</span>" ); lblSubHeader.Text = x.ToString(); Fill(); }
private void Report() { param.Visible = false; rpt.Visible = true; lblHeader.Text = Mi.Pt + "<br />" + "LAPORAN AGING PIUTANG" + "<br />" + "PER " + Cf.Day(tgl.Text) ; System.Text.StringBuilder x = new System.Text.StringBuilder(); if (lokasi.SelectedIndex > 0) { x.Append("Lokasi: " + lokasi.SelectedItem.Text + "<br />"); } if (ddlAgent.SelectedIndex != 0) { x.Append("Sales: " + ddlAgent.SelectedValue); } else { x.Append("Sales: SEMUA"); } string strPrincipal = "SEMUA"; System.Text.StringBuilder z = new System.Text.StringBuilder(); bool isFirst = true; for (int i = 0; i < cblPrincipal.Items.Count; i++) { if (cblPrincipal.Items[i].Selected) { if (isFirst) { z.Append(cblPrincipal.Items[i].Text); isFirst = false; } else { z.Append("," + cblPrincipal.Items[i].Text); } } } if (z.ToString() != "") { strPrincipal = z.ToString(); } x.Append("<br />Principal: " + strPrincipal); x.Append("<br /><span style='font-weight: normal;'>Laporan dihasilkan pada hari : " + Cf.IndoWeek(DateTime.Today) + ", " + Cf.Date(DateTime.Now) + " dari workstation : " + Act.IP + " dan username : "******"</span>" ); lblSubHeader.Text = x.ToString(); Fill(); }
protected void Report() { lblHeader.Text = Mi.Pt + "<br />" + "Laporan NUP" ; System.Text.StringBuilder x = new System.Text.StringBuilder(); DateTime Tanggal1 = Db.SingleTime("SELECT FilterDari FROM " + Mi.DbPrefix + "MARKETINGJUAL..LapPDF WHERE AttachmentID = '" + AttachmentID + "'"); DateTime Tanggal2 = Db.SingleTime("SELECT FilterSampai FROM " + Mi.DbPrefix + "MARKETINGJUAL..LapPDF WHERE AttachmentID = '" + AttachmentID + "'"); string addStr = "Semua Admin"; if (Admin != "SEMUA") { addStr = Db.SingleString("SELECT Nama FROM ISC064_SECURITY..USERNAME WHERE UserID='" + Admin + "'"); } x.Append("<br />Untuk tanggal : " + Cf.Day(Tanggal1) + " s/d " + Cf.Day(Tanggal2)); x.Append("<br />Untuk Project : " + Cf.Str(Project)); x.Append("<br />Untuk Admin : " + Cf.Str(addStr)); x.Append("<br />Untuk Tipe : " + Tipe); x.Append("<br /><span style='font-weight: normal;'>Laporan dihasilkan pada hari : " + Cf.IndoWeek(DateTime.Today) + ", " + Cf.Date(DateTime.Now) + " dari workstation : " + Act.IP + " dan username : "******"</span>" ); lblSubHeader.Text = x.ToString(); Fill(); }
protected void Report() { param.Visible = false; rpt.Visible = true; header.Text = Mi.Pt + "<br />" + "LAPORAN DATA CUSTOMER SIAP PPJB" ; System.Text.StringBuilder x = new System.Text.StringBuilder(); x.Append("Urut Customer: " + urut.SelectedItem.Text + "<br />"); x.Append("Skema Bayar: " + Rpt.inSql(skemalist).Replace("'", "")); x.Append("<br /><span style='font-weight: normal;'>Laporan dihasilkan pada hari : " + Cf.IndoWeek(DateTime.Today) + ", " + Cf.Date(DateTime.Now) + " dari workstation : " + Act.IP + " dan username : "******"</span>" ); subheader.Text = x.ToString(); Fill(); }
private void Report() { param.Visible = false; rpt.Visible = true; lblPT.Text = Mi.Pt; lblHeader.Text = "Laporan Ganti Nama NUP"; System.Text.StringBuilder x = new System.Text.StringBuilder(); x.Append("<br /><span style='font-weight: normal;'>Laporan dihasilkan pada hari : " + Cf.IndoWeek(DateTime.Today) + ", " + Cf.Date(DateTime.Now) + " dari workstation : " + Act.IP + " dan username : "******"</span>" ); lblSubHeader.Text = x.ToString(); Fill(); }
private void Fill() { string Status = ""; if (statusA.Checked) { Status = " AND a.Status = 'A'"; } if (statusB.Checked) { Status = " AND a.Status = 'B'"; } string tgl = ""; if (tglkontrak.Checked) { tgl = "TglKontrak"; } else if (tglinput.Checked) { tgl = "a.TglInput"; } DateTime Dari = Convert.ToDateTime(dari.Text); DateTime Sampai = Convert.ToDateTime(sampai.Text); if (Dari > Sampai) { DateTime x = Sampai; Sampai = Dari; Dari = x; } string Lokasi = ""; if (lokasi.SelectedIndex != 0) { Lokasi = " AND Lokasi = '" + Cf.Str(lokasi.SelectedValue) + "'"; } string Agent = ""; if (agent.SelectedIndex != 0) { Agent = " AND Principal = '" + Cf.Str(agent.SelectedValue) + "'"; } string Sort = ""; if (sort.SelectedValue == "TglInput") { Sort = "a.TglInput"; } else { Sort = sort.SelectedValue; } string strSql = "SELECT a.*" + ", b.Nama AS Cs" + ", b.NoKTP" + ", b.NoTelp" + ", b.NoHP" + ", c.Nama AS Ag" + ", c.Principal" + " FROM MS_KONTRAK a" + " INNER JOIN MS_CUSTOMER b ON a.NoCustomer = b.NoCustomer" + " INNER JOIN MS_AGENT c ON a.NoAgent = c.NoAgent" + " WHERE 1 = 1" + " AND CONVERT(varchar, " + tgl + " ,112) >= '" + Cf.Tgl112(Dari) + "'" + " AND CONVERT(varchar, " + tgl + ", 112) <= '" + Cf.Tgl112(Sampai) + "'" + " AND Jenis IN (" + Rpt.inSql(jenis) + ")" + Lokasi + Status + Agent + " ORDER BY " + Sort ; DataTable rs = Db.Rs(strSql); decimal t1 = 0, t2 = 0, t3 = 0, t4 = 0; decimal[] TotalBF = new decimal[rs.Rows.Count]; decimal[] TotalDP = new decimal[rs.Rows.Count]; decimal[] TotalANG = new decimal[rs.Rows.Count]; for (int i = 0; i < rs.Rows.Count; i++) { if (!Response.IsClientConnected) { break; } TableRow r = new TableRow(); TableCell c; r.VerticalAlign = VerticalAlign.Top; r.Attributes["ondblclick"] = "popEditKontrak('" + rs.Rows[i]["NoKontrak"] + "')"; c = new TableCell(); c.Text = Cf.Pk(rs.Rows[i]["NoKontrak"]); c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = new TableCell(); c.Text = Cf.IndoWeek(Convert.ToDateTime(rs.Rows[i]["TglKontrak"])) + "<br />" + Cf.Day(rs.Rows[i]["TglKontrak"]); c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Day(rs.Rows[i]["TglInput"]); c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Str(rs.Rows[i]["Cs"]) + "<br />" + "KTP: " + rs.Rows[i]["NoKTP"].ToString() + "<br />" + rs.Rows[i]["NoTelp"].ToString() + "<br />" + rs.Rows[i]["NoHP"].ToString() ; c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = new TableCell(); c.Text = Str.Lantai(Cf.Pk(rs.Rows[i]["NoUnit"])); c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = new TableCell(); c.Text = Str.NoUnit(Cf.Pk(rs.Rows[i]["NoUnit"])); c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Str(rs.Rows[i]["Jenis"]); c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Num(rs.Rows[i]["NilaiKontrak"]); c.HorizontalAlign = HorizontalAlign.Right; r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Str(rs.Rows[i]["Skema"]); c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Str(rs.Rows[i]["Ag"]); c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = new TableCell(); c.Text = TglBayar(Cf.Pk(rs.Rows[i]["NoKontrak"])); c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = new TableCell(); c.Text = Pembayaran(Cf.Pk(rs.Rows[i]["NoKontrak"]), "BF"); TotalBF[i] = TotalBayar(Cf.Pk(rs.Rows[i]["NoKontrak"]), "BF"); c.HorizontalAlign = HorizontalAlign.Right; r.Cells.Add(c); c = new TableCell(); c.Text = Pembayaran(Cf.Pk(rs.Rows[i]["NoKontrak"]), "DP"); TotalDP[i] = TotalBayar(Cf.Pk(rs.Rows[i]["NoKontrak"]), "DP"); c.HorizontalAlign = HorizontalAlign.Right; r.Cells.Add(c); c = new TableCell(); c.Text = Pembayaran(Cf.Pk(rs.Rows[i]["NoKontrak"]), "ANG"); TotalANG[i] = TotalBayar(Cf.Pk(rs.Rows[i]["NoKontrak"]), "ANG"); c.HorizontalAlign = HorizontalAlign.Right; r.Cells.Add(c); rpt.Rows.Add(r); t1 = t1 + (decimal)rs.Rows[i]["NilaiKontrak"]; t2 = t2 + (decimal)TotalBF[i]; t3 = t3 + (decimal)TotalDP[i]; t4 = t4 + (decimal)TotalANG[i]; if (i == (rs.Rows.Count - 1)) { SubTotal(t1, t2, t3, t4); } } }
private void Report() { param.Visible = false; rpt.Visible = true; lblHeader.Text = "<p>" + Mi.Pt + "</p>" + "<h1 class='title'>Laporan Sales Performance</h1>" ; System.Text.StringBuilder x = new System.Text.StringBuilder(); x.Append("Sales : " + ddlAgent.SelectedItem.Text); x.Append("<br />Status Agent : " + status.SelectedItem.ToString()); if (filtertgl.SelectedValue.ToString() == "0") { x.Append("<br />Tgl Kontrak : " + Cf.Day(dari.Text) + " s/d " + Cf.Day(sampai.Text)); } else { x.Append("<br />Tgl Kontrak : As Of : " + Cf.Day(tglasof.Text)); } string hitung = ""; if (kuantitas.Checked) { hitung = kuantitas.Text; } if (rupiah.Checked) { hitung = rupiah.Text; } x.Append("<br />Perhitungan : " + hitung); x.Append("<br />Project : " + project.SelectedItem.Text); x.Append("<br /><br /><span style='font-weight: normal;'>Laporan dihasilkan pada hari : " + Cf.IndoWeek(DateTime.Today) + ", " + Cf.Date(DateTime.Now) + " dari workstation : " + Act.IP + " dan username : "******"</span>" ); lblSubHeader.Text = x.ToString(); Fill(); }
private void Fill() { string Status = ""; if (statusA.Checked) { Status = " AND a.Status = 'A'"; } if (statusB.Checked) { Status = " AND a.Status = 'B'"; } string tgl = ""; string order = ""; if (tglkontrak.Checked) { tgl = "TglKontrak"; order = "NoKontrak"; } DateTime Dari = Convert.ToDateTime(dari.Text); DateTime Sampai = Convert.ToDateTime(sampai.Text); if (Dari > Sampai) { DateTime x = Sampai; Sampai = Dari; Dari = x; } string Lokasi = ""; if (lokasi.SelectedIndex != 0) { Lokasi = " AND Lokasi = '" + Cf.Str(lokasi.SelectedValue) + "'"; } string Agent = ""; if (agent.SelectedIndex != 0) { Agent = " AND Principal = '" + Cf.Str(agent.SelectedValue) + "'"; } decimal t1 = 0, t2 = 0; string strSql = "SELECT a.*" + ", b.Nama AS Cs" + ", b.NoKTP" + ", b.NoTelp" + ", b.NoHP" + ", c.Nama AS Ag" + ", c.Principal" + ", (SELECT ISNULL(SUM(NilaiPelunasan), 0) FROM MS_PELUNASAN WHERE NoKontrak = a.NoKontrak) AS TotalBFR" + " FROM MS_KONTRAK a" + " INNER JOIN MS_CUSTOMER b ON a.NoCustomer = b.NoCustomer" + " INNER JOIN MS_AGENT c ON a.NoAgent = c.NoAgent" + " WHERE a.NoKontrak NOT IN" + " (" + " SELECT NoKontrak" + " FROM" + " (" + " SELECT NoKontrak, SUM(NilaiPelunasan) AS Total" + " FROM MS_PELUNASAN" + " GROUP BY NoKontrak" + " )" + " AS table1 WHERE Total >= 10000000" + " )" + " AND CONVERT(varchar, " + tgl + " ,112) >= '" + Cf.Tgl112(Dari) + "'" + " AND CONVERT(varchar, " + tgl + ", 112) <= '" + Cf.Tgl112(Sampai) + "'" + " AND Jenis IN (" + Rpt.inSql(jenis) + ")" + Lokasi + Status + Agent + " ORDER BY " + order ; DataTable rs = Db.Rs(strSql); for (int i = 0; i < rs.Rows.Count; i++) { if (!Response.IsClientConnected) { break; } TableRow r = new TableRow(); TableCell c; r.VerticalAlign = VerticalAlign.Top; r.Attributes["ondblclick"] = "popEditKontrak('" + rs.Rows[i]["NoKontrak"] + "')"; c = new TableCell(); c.Text = Cf.Pk(rs.Rows[i]["NoKontrak"]); c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = new TableCell(); c.Text = Cf.IndoWeek(Convert.ToDateTime(rs.Rows[i]["TglKontrak"])) + "<br />" + Cf.Day(rs.Rows[i]["TglKontrak"]); c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Str(rs.Rows[i]["Cs"]) + "<br />" + "KTP: " + rs.Rows[i]["NoKTP"].ToString() + "<br />" + rs.Rows[i]["NoTelp"].ToString() + "<br />" + rs.Rows[i]["NoHP"].ToString() ; c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = new TableCell(); c.Text = Str.Lantai(Cf.Pk(rs.Rows[i]["NoUnit"])); c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = new TableCell(); c.Text = Str.Blok(Cf.Pk(rs.Rows[i]["NoUnit"])); c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = new TableCell(); c.Text = Str.NoUnit(Cf.Pk(rs.Rows[i]["NoUnit"])); c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Str(rs.Rows[i]["Jenis"]); c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Num(rs.Rows[i]["NilaiKontrak"]); c.HorizontalAlign = HorizontalAlign.Right; r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Str(rs.Rows[i]["Skema"]); c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = new TableCell(); c.Text = NoTTS(Cf.Pk(rs.Rows[i]["NoKontrak"])); c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = new TableCell(); c.Text = CaraBayar(Cf.Pk(rs.Rows[i]["NoKontrak"])); c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Num(rs.Rows[i]["TotalBFR"]); c.HorizontalAlign = HorizontalAlign.Right; r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Str(rs.Rows[i]["Ag"]); c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); rpt.Rows.Add(r); t1 = t1 + (decimal)rs.Rows[i]["NilaiKontrak"]; t2 = t2 + (decimal)rs.Rows[i]["TotalBFR"]; if (i == (rs.Rows.Count - 1)) { SubTotal(t1, t2); } } }