protected void Fill() { string strSql = "SELECT" + " LogID" + ",Tgl" + ",Aktivitas" + ",UserID" + ",IP" + ",(SELECT Nama FROM " + Mi.DbPrefix + "SECURITY..USERNAME WHERE UserID = MS_SKL_LOG.UserID) AS Nama" + ",Pk" + " FROM MS_SKL_LOG" + " WHERE Pk = '" + Pk + "' ORDER BY LogID"; DataTable rs = Db.Rs(strSql); Rpt.NoData(rpt, rs, "Log file tidak tersedia."); 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]["Tgl"]); c.Wrap = false; r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Time(rs.Rows[i]["Tgl"]); r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["UserID"].ToString(); r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["Nama"].ToString(); c.Wrap = false; r.Cells.Add(c); c = new TableCell(); c.Text = "<a href=\"javascript:popLog('" + rs.Rows[i]["LogID"] + "','MS_SKL_LOG','MS_SKL','" + Pk + "')\">" + rs.Rows[i]["Aktivitas"].ToString() + "</a>"; r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["Pk"].ToString(); c.Wrap = false; r.Cells.Add(c); Rpt.Border(r); rpt.Rows.Add(r); } }
protected void fill(byte Lvl) { DataTable rs = Db.Rs("SELECT * FROM REF_APPROVAL WHERE Lvl=" + Lvl + " AND Tipe=" + TipeApproval + " AND Project='" + Project + "'"); for (int i = 0; i < rs.Rows.Count; i++) { if (!Response.IsClientConnected) { break; } TableRow r = new TableRow(); TableCell c; c = new TableCell(); c.Text = " "; r.Cells.Add(c); c = new TableCell(); c.Text = Db.SingleString("SELECT Nama FROM Username WHERE UserID='" + rs.Rows[i]["UserID"].ToString() + "'") + " (" + rs.Rows[i]["UserID"].ToString() + ")"; r.Cells.Add(c); Rpt.Border(r); rpt.Rows.Add(r); if (i == rs.Rows.Count - 1) { fillNext(Lvl); } } }
private void Fill() { string Project = Request.QueryString["project"]; string query = "SELECT * FROM REF_FP WHERE STATUS = 0 AND Convert(varchar,TglTerimaFP,112) <= '" + Request.QueryString["tgl"] + "' AND Project = '" + Project + "' ORDER BY NoFPS, NoUrut"; DataTable rs = Db.Rs(query); Rpt.NoData(rpt, rs, "Tidak ditemukan nomor faktur pajak 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]["NoFPS"] + "','" + Request.QueryString["ctrl1"] + "','" + Request.QueryString["ctrl2"] + "')\">" + rs.Rows[i]["NoFPS"] + "</a>" ; r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Day(rs.Rows[i]["TglTerimaFP"]); r.Cells.Add(c); Rpt.Border(r); rpt.Rows.Add(r); } }
private void FillTb() { string strSql = "SELECT " + " NoKontrak" + ",TglKontrak" + ",MS_CUSTOMER.Nama AS Cs" + ",MS_AGENT.Nama + ' ' + MS_AGENT.Principal AS Ag" + ",MS_KONTRAK.Status" + " FROM MS_KONTRAK INNER JOIN MS_CUSTOMER ON MS_KONTRAK.NoCustomer = MS_CUSTOMER.NoCustomer" + " INNER JOIN MS_AGENT ON MS_KONTRAK.NoAgent = MS_AGENT.NoAgent" + " WHERE NoStock = '" + NoStock + "'" + " ORDER BY TglKontrak, NoKontrak"; DataTable rs = Db.Rs(strSql); 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='KontrakEdit.aspx?NoKontrak=" + rs.Rows[i]["NoKontrak"] + "'>" + rs.Rows[i]["NoKontrak"].ToString() + "</a>"; c.Wrap = false; r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["Status"].ToString(); c.Wrap = false; r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Day(rs.Rows[i]["TglKontrak"]); c.Wrap = false; r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["Cs"].ToString(); c.Wrap = false; r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["Ag"].ToString(); c.Wrap = false; r.Cells.Add(c); c = new TableCell(); c.Text = ""; c.Wrap = false; r.Cells.Add(c); Rpt.Border(r); rpt.Rows.Add(r); } }
private void Fill() { string strSql = "SELECT" + " DISTINCT(NoKontrak)" + " FROM MIGRATE_TAGIHAN" + " WHERE NoKontrak LIKE '%" + Cf.Str(nokontrak.Text) + "%'" + " AND Approved = 0" + " ORDER BY NoKontrak"; DataTable rs = Db.Rs(strSql); Rpt.NoData(rpt, rs, "Tidak terdapat kontrak dengan kriteria seperti tersebut diatas."); for (int i = 0; i < rs.Rows.Count; i++) { TableRow r = new TableRow(); TableCell c; c = new TableCell(); c.Text = "<a href='MigrateJadwal2.aspx?NoKontrak=" + rs.Rows[i]["NoKontrak"] + "'>Next...</a>"; r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["NoKontrak"].ToString(); r.Cells.Add(c); c = new TableCell(); c.Text = "<a style='font:8pt' href=\"javascript:hapus('" + rs.Rows[i]["NoKontrak"] + "')\">Delete...</a>"; r.Cells.Add(c); Rpt.Border(r); rpt.Rows.Add(r); } }
private void Fill() { string strSql = "SELECT DISTINCT" + " NoUnit" + ",Koordinat" + " FROM MS_UNIT" + " WHERE Peta = '" + f + "'" + " ORDER BY NoUnit"; DataTable rs = Db.Rs(strSql); Rpt.NoData(rpt, rs, "Floor plan ini belum memiliki koordinat."); 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]["NoUnit"].ToString(); r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Cut(rs.Rows[i]["Koordinat"], 100); r.Cells.Add(c); Rpt.Border(r); rpt.Rows.Add(r); } }
protected void Fill() { DataTable rs = Db.Rs("SELECT * FROM REF_PROJECT"); 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:popProject('" + rs.Rows[i]["Project"].ToString() + "')\"> Open </a>"; r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["Project"].ToString(); r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["Nama"].ToString(); r.Cells.Add(c); Rpt.Border(r); rpt.Rows.Add(r); } }
private void Fill() { string strSql = "SELECT *" + ",(SELECT Nama FROM " + Mi.DbPrefix + "SECURITY..USERNAME WHERE UserID = MS_PJT_JURNAL.UserID) AS Nama" + " FROM MS_PJT_JURNAL" + " WHERE NoPJT = '" + NoPJT + "'" + " ORDER BY JurnalID"; DataTable rs = Db.Rs(strSql); Rpt.NoData(rpt, rs, "Jurnal untuk pemberitahuan jatuh tempo 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 = Cf.Day(rs.Rows[i]["Tgl"]); c.Wrap = false; r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Time(rs.Rows[i]["Tgl"]); r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["UserID"].ToString(); r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["Nama"].ToString(); c.Wrap = false; r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["Ket"].ToString(); r.Cells.Add(c); c = new TableCell(); if (System.IO.File.Exists(Request.PhysicalApplicationPath + "JurnalPJT\\" + rs.Rows[i]["JurnalID"] + ".jpg")) { c.Text = "<a href=\"javascript:popGambar('JurnalPJT/" + rs.Rows[i]["JurnalID"] + ".jpg')\">View</a>"; } else { c.Text = " "; } r.Cells.Add(c); Rpt.Border(r); rpt.Rows.Add(r); } }
private void FillDetil() { DataTable rs2 = Db.Rs("SELECT * FROM " + Mi.DbPrefix + "FINANCEAR..MS_PENGAJUAN_KPA_DETIL WHERE NoPengajuan=" + nomor); for (int i = 0; i < rs2.Rows.Count; i++) { TableCell c; TableRow r = new TableRow(); c = new TableCell(); c.Text = rs2.Rows[i]["NoKontrak"].ToString(); r.Cells.Add(c); c = new TableCell(); c.Text = rs2.Rows[i]["Nama"].ToString(); r.Cells.Add(c); c = new TableCell(); c.Text = rs2.Rows[i]["NoUnit"].ToString(); r.Cells.Add(c); c = new TableCell(); c.CssClass = "txt_num"; c.Text = Cf.Num(rs2.Rows[i]["Nilai"]); r.Cells.Add(c); Rpt.Border(r); rpt.Rows.Add(r); } }
protected void fill() { tipeapproval.InnerText = "Approval for " + LibControls.Bind.TipeApproval(TipeApproval) + " Project " + Project; DataTable rs = Db.Rs("SELECT Distinct(Lvl) FROM REF_APPROVAL WHERE Tipe=" + TipeApproval + " AND Project = '" + Project + "'"); int Count = Db.SingleInteger("SELECT ISNULL(COUNT(*),0) FROM REF_APPROVAL WHERE Tipe=" + TipeApproval + " AND Project = '" + Project + "'"); if (rs.Rows.Count == 0) { anew.Visible = true; anew.HRef = "ApprovalDetailEdit.aspx?lvl=1&tipe=" + TipeApproval + "&project=" + Project; } for (int i = 0; i < rs.Rows.Count; i++) { if (!Response.IsClientConnected) { break; } TableRow r = new TableRow(); TableCell c; c = new TableCell(); c.Text = "<h2>" + rs.Rows[i]["lvl"].ToString() + "</h2>"; c.ColumnSpan = 2; r.Cells.Add(c); Rpt.Border(r); rpt.Rows.Add(r); fill(Convert.ToByte(rs.Rows[i]["lvl"])); } }
private void Fill() { string strSql = "SELECT" + " DISTINCT(NoTTS)" + " FROM MIGRATE_PEMBAYARAN" + " WHERE NoKontrak = '" + Request.QueryString["No"] + "'" + " AND Approved = 0" + " ORDER BY NoTTS"; DataTable rs = Db.Rs(strSql); Rpt.NoData(rpt, rs, "Tidak terdapat tts dengan kriteria seperti tersebut diatas."); for (int i = 0; i < rs.Rows.Count; i++) { TableRow r = new TableRow(); TableCell c; c = new TableCell(); c.Text = "<a href='MigratePembayaran3.aspx?No=" + Request.QueryString["No"] + "&NoTTS=" + rs.Rows[i]["NoTTS"] + "'>Next...</a>"; r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["NoTTS"].ToString(); r.Cells.Add(c); Rpt.Border(r); rpt.Rows.Add(r); } }
private void Fill() { string strSql = "SELECT" + " NoUnit" + ",NoKontrak" + ",Status" + ",TglKontrak" + ",Customer" + ",Agent" + " FROM MIGRATE_KONTRAK" + " WHERE NoKontrak LIKE '%" + Cf.Str(nokontrak.Text) + "%'" + " AND Approved = 0" + " ORDER BY NoKontrak"; DataTable rs = Db.Rs(strSql); Rpt.NoData(rpt, rs, "Tidak terdapat kontrak dengan kriteria seperti tersebut diatas."); for (int i = 0; i < rs.Rows.Count; i++) { TableRow r = new TableRow(); TableCell c; c = new TableCell(); c.Text = "<a href='MigrateKontrak2.aspx?NoKontrak=" + rs.Rows[i]["NoKontrak"] + "'>Next...</a>"; r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["NoKontrak"].ToString(); r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Day(Convert.ToDateTime(rs.Rows[i]["TglKontrak"])); r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["Status"].ToString(); r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["NoUnit"].ToString(); r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["Customer"].ToString(); r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["Agent"].ToString(); r.Cells.Add(c); c = new TableCell(); c.Text = "<a style='font:8pt' href=\"javascript:hapus('" + rs.Rows[i]["NoKontrak"] + "')\">Delete...</a>"; r.Cells.Add(c); Rpt.Border(r); rpt.Rows.Add(r); } }
protected void display_Click(object sender, EventArgs e) { rpt.Visible = true; string kunci = ""; if (key.Text != "") { kunci = " AND ISC064_MARKETINGJUAL..MS_KOMISI.NoAgent LIKE '%" + key.Text + "%'or ISC064_MARKETINGJUAL..MS_AGENT.Nama LIKE '%" + key.Text + "%' "; } string PeriodeKomisi = ""; if (periodekomisi.SelectedIndex != 0) { string[] z = periodekomisi.SelectedValue.Split(','); PeriodeKomisi = " AND YEAR(TglKontrak) = " + z[0] + " AND MONTH(TglKontrak) = " + z[1]; } string strSql = "SELECT" + " a.NoAgent" + ",a.NamaKomisi AS Ag" + ",a.NoAgent" + " FROM MS_KOMISI a" + " INNER JOIN MS_KONTRAK c ON a.NoKontrak = c.NoKontrak" + " INNER JOIN MS_AGENT b ON c.NoAgent = b.NoAgent" + " WHERE 1=1" + kunci + PeriodeKomisi + " ORDER BY a.NamaKomisi"; DataTable rs = Db.Rs(strSql); Rpt.NoData(rpt, rs, "Tidak terdapat agent dengan kriteria seperti tersebut 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]["NoAgent"].ToString() + "')\">" + rs.Rows[i]["Ag"].ToString() + "</a><br>"; r.Cells.Add(c); c = new TableCell(); c.Text = "<a href=\"LaporanMasterKomisi.aspx?NoAgent=" + rs.Rows[i]["NoAgent"].ToString() + "&PeriodeKomisi=" + periodekomisi.SelectedItem + "\">" + "Screen Preview" + "</a><br>" + "<a href=\"LaporanMasterKomisi.aspx?NoAgent=" + rs.Rows[i]["NoAgent"].ToString() + "&PeriodeKomisi=" + periodekomisi.SelectedItem + "&Excel=1\">Export to Excel</a>"; r.Cells.Add(c); Rpt.Border(r); rpt.Rows.Add(r); } }
private void FillRsv() { string strSql = "SELECT " + " NoUrut" + ",Tgl" + ",MS_CUSTOMER.Nama AS Cs" + ",NoUnit" + ",MS_RESERVASI.Status" + ",NoReservasi" + ",MS_RESERVASI.TglExpire" + " FROM MS_RESERVASI INNER JOIN MS_CUSTOMER ON MS_RESERVASI.NoCustomer = MS_CUSTOMER.NoCustomer" + " WHERE NoAgent = " + NoAgent + " ORDER BY NoUrut"; DataTable rs = Db.Rs(strSql); 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]["NoReservasi"].ToString().PadLeft(5, '0'); c.Wrap = false; r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["Status"].ToString(); r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Day(rs.Rows[i]["Tgl"]); r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["Cs"].ToString(); r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["NoUnit"].ToString(); r.Cells.Add(c); c = new TableCell(); c.Text = "W.List : " + rs.Rows[i]["NoUrut"] + ", " + Cf.Date(rs.Rows[i]["TglExpire"]); c.Wrap = false; r.Cells.Add(c); Rpt.Border(r); rpt.Rows.Add(r); } }
private void Fill() { string strSql = "SELECT *" + " FROM MS_RESERVASI_OBS" + " WHERE Reminder = 0" + " ORDER BY NoObs"; DataTable rs = Db.Rs(strSql); Rpt.NoData(rpt, rs, "Reminder untuk topik diatas 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]["NoObs"].ToString().PadLeft(5, '0'); r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["NoUnit"].ToString() + "<br /><i>NUP: " + rs.Rows[i]["NoQueue"].ToString() + "</i>" + "<br /><strong><font style='font-size: 15pt;'>" + rs.Rows[i]["NoUrut"].ToString() + "</font></strong>" ; r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Str(rs.Rows[i]["Customer"]) + "<br />" + Cf.Str(rs.Rows[i]["Agent"]) ; r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Date(rs.Rows[i]["Tgl"]) + "<br />" + Cf.Date(rs.Rows[i]["TglExpire"]) ; r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Str(rs.Rows[i]["Skema"]) + "<br />" + Cf.Num(rs.Rows[i]["Netto"]) ; r.Cells.Add(c); c = new TableCell(); c.Text = "<a href='ReminderObsProses.aspx?NoObs=" + Cf.Pk(rs.Rows[i]["NoObs"]) + "' onclick=\"javascript:return confirm('Anda yakin ingin follow up?');\" />Follow up...</a>"; r.Cells.Add(c); Rpt.Border(r); rpt.Rows.Add(r); } }
private void Fill() { var d = Db.Rs("Select * from ms_siteplan where id='" + IDx + "'"); if (d.Rows.Count == 0) { Response.Redirect("/CustomError/Deleted.html"); } var r = d.Rows[0]; nama.Text = r["Nama"].ToString(); if (File.Exists(Server.MapPath(".").ToLower().Replace("adminjual", "") + r["PathGambarDasar"].ToString())) { imgdasar.ImageUrl = Path.Combine(Request.PhysicalApplicationPath.ToLower(), r["PathGambarDasar"].ToString());// r["PathGambarDasar"].ToString(); } //if (File.Exists(Server.MapPath(".").ToLower().Replace("adminjual", "") + r["PathGambarTransparent"].ToString())) //{ // imgtransparent.ImageUrl =r["PathGambarTransparent"].ToString(); //} if ((bool)r["isParent"]) { tr1.Visible = tr2.Visible = rpt.Visible = false; } string strSql = "SELECT DISTINCT" + " NoUnit" + ",Koordinat" + " FROM MS_UNIT" + " WHERE Peta = '" + r["Nama"] + "'" + " ORDER BY NoUnit"; DataTable rs = Db.Rs(strSql); Rpt.NoData(rpt, rs, "Floor plan ini belum memiliki koordinat."); for (int i = 0; i < rs.Rows.Count; i++) { if (!Response.IsClientConnected) { break; } TableRow tr = new TableRow(); TableCell c; c = new TableCell(); c.Text = rs.Rows[i]["NoUnit"].ToString(); tr.Cells.Add(c); c = new TableCell(); c.Text = Cf.Cut(rs.Rows[i]["Koordinat"], 100); tr.Cells.Add(c); Rpt.Border(tr); rpt.Rows.Add(tr); } }
protected void Fill() { noslip.Text = NoSlip; tglslip.Text = Cf.Day(Db.SingleTime("SELECT TOP 1 TglSetoran FROM MS_TTS WHERE NoSlip = " + NoSlip)); string strSql = "SELECT *" + " FROM MS_TTS" + " WHERE NoSlip = " + NoSlip ; DataTable rs = Db.Rs(strSql); Rpt.NoData(rpt, rs, "Tidak ada cek giro untuk slip setoran di atas."); 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]["NoBG"].ToString(); c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Day(rs.Rows[i]["TglBG"]); c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["NoTTS"].ToString().PadLeft(7, '0'); c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["Customer"].ToString(); c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["Unit"].ToString(); c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Num(rs.Rows[i]["Total"]); c.HorizontalAlign = HorizontalAlign.Right; r.Cells.Add(c); rpt.Rows.Add(r); Rpt.Border(r); } }
private void FillTb() { string strSql = "SELECT " + " Tgl" + ",CASE Aktivitas" + " WHEN 'L' THEN 'Log-In Normal'" + " WHEN 'S' THEN 'Sign-Out Normal'" + " WHEN 'DL' THEN 'Double Login'" + " WHEN 'SP' THEN 'Salah Password'" + " WHEN 'B' THEN 'Blokir'" + " WHEN 'A' THEN 'Aktivasi'" + " WHEN 'GP' THEN 'Ganti Password'" + " END AS Aktivitas" + ",IP" + " FROM SECURITY_LOG" + " WHERE MONTH(Tgl) = " + bulan.SelectedValue + " AND YEAR(Tgl) = " + tahun.SelectedValue + " AND UserID = '" + UserID + "'" + " ORDER BY LogID"; DataTable rs = Db.Rs(strSql); Rpt.NoData(rpt, rs, "Tidak ada security log untuk periode diatas."); for (int i = 0; i < rs.Rows.Count; i++) { if (!Response.IsClientConnected) { break; } TableRow r = new TableRow(); TableCell c; DateTime d = Convert.ToDateTime(rs.Rows[i]["Tgl"]); c = new TableCell(); c.Text = d.Day.ToString(); r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Time(d); r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["Aktivitas"].ToString(); r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["IP"].ToString(); r.Cells.Add(c); Rpt.Border(r); rpt.Rows.Add(r); } }
protected void FillCF(string NoKontrak) { string strSql1 = "select*,b.NoAgent as Ag from ms_komisi_cf a inner join ms_komisi_cf_detail b on a.NoCF = b.NoCF where b.Nilai > 0 and a.project = '" + Project + "' AND NoKontrak = '" + NoKontrak + "'"; DataTable rs = Db.Rs(strSql1); Rpt.NoData(rpt2, rs, "Daftar komisi 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(); string Nama = Db.SingleString("SELECT Nama FROM MS_AGENT WHERE NoAgent = '" + rs.Rows[i]["Ag"].ToString() + "'"); c.Text = Nama; r.Cells.Add(c); c = new TableCell(); string TipeAgent = Db.SingleString("SELECT Tipe FROM REF_AGENT_TIPE WHERE ID = (SELECT SalesTipe FROM MS_AGENT WHERE NoAgent = '" + rs.Rows[i]["NoAgent"].ToString() + "')"); c.Text = TipeAgent; r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Num(Math.Round(Convert.ToDecimal(rs.Rows[i]["Nilai"]))); r.Cells.Add(c); int b = Db.SingleInteger("SELECT COUNT(*) FROM MS_KOMISI_CFR WHERE NoCFP IN (SELECT NoCFP FROM MS_KOMISI_CFP_DETAIL WHERE NoCF = '" + rs.Rows[i]["NoCF"] + "' AND SN_NoCF = '" + rs.Rows[i]["SN"] + "')"); c = new TableCell(); if (b > 0) { decimal Nilai = Db.SingleDecimal("SELECT Nilai FROM MS_KOMISI_CFR_DETAIL WHERE NoCF = '" + rs.Rows[i]["NoCF"] + "' AND NoAgent = '" + rs.Rows[i]["Ag"] + "'"); c.Text = Cf.Num(Nilai); } r.Cells.Add(c); DateTime TglKontrak = Db.SingleTime("Select TglKontrak From MS_KONTRAK Where NoKontrak = '" + NoKontrak + "'"); c = new TableCell(); c.Text = ""; if (b > 0) { DateTime tgl = Db.SingleTime("SELECT Tgl FROM MS_KOMISI_CFR WHERE NoCFP IN (SELECT NoCFP FROM MS_KOMISI_CFP_DETAIL WHERE NoCF = '" + rs.Rows[i]["NoCF"] + "' AND SN_NoCF = '" + rs.Rows[i]["SN"] + "')"); c.Text = Cf.Day(tgl.ToString()); } r.Cells.Add(c); Rpt.Border(r); rpt2.Rows.Add(r); } }
protected void Fill() { string strSql = "SELECT DISTINCT NoSlip" + " FROM MS_TTS" + " WHERE NoSlip <> 0" ; DataTable rs = Db.Rs(strSql); Rpt.NoData(tb, rs, "Tidak ada slip setoran."); 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='SlipLaporan.aspx?NoSlip=" + rs.Rows[i]["NoSlip"].ToString() + "'>" + rs.Rows[i]["NoSlip"].ToString().PadLeft(7, '0') + "</a>" ; c.HorizontalAlign = HorizontalAlign.Center; r.Cells.Add(c); c = new TableCell(); c.Text = Db.SingleInteger( "SELECT COUNT(NoTTS)" + " FROM MS_TTS" + " WHERE NoSlip = " + rs.Rows[i]["NoSlip"].ToString() ).ToString(); c.HorizontalAlign = HorizontalAlign.Right; r.Cells.Add(c); c = new TableCell(); c.Text = Db.SingleInteger( "SELECT COUNT(DISTINCT NoBG)" + " FROM MS_TTS" + " WHERE NoSlip = " + rs.Rows[i]["NoSlip"].ToString() ).ToString(); c.HorizontalAlign = HorizontalAlign.Right; r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Num(Db.SingleDecimal("SELECT ISNULL(SUM(Total), 0) FROM MS_TTS WHERE NoSlip = " + rs.Rows[i]["NoSlip"].ToString())); c.HorizontalAlign = HorizontalAlign.Right; r.Cells.Add(c); tb.Rows.Add(r); Rpt.Border(r); } }
private void Fill() { string strSql = "SELECT" + " NoKontrak" + ",NoUnit" + ",MS_CUSTOMER.Nama AS Cs" + ",MS_AGENT.Nama + ' ' + MS_AGENT.Principal AS Ag" + ",NilaiKontrak" + " FROM MS_KONTRAK INNER JOIN MS_CUSTOMER" + " ON MS_KONTRAK.NoCustomer = MS_CUSTOMER.NoCustomer" + " INNER JOIN MS_AGENT" + " ON MS_KONTRAK.NoAgent = MS_AGENT.NoAgent" + " WHERE MS_KONTRAK.FlagKomisi = 2" + " ORDER BY MS_KONTRAK.NoKontrak"; DataTable rs = Db.Rs(strSql); Rpt.NoData(rpt, rs, "Reminder untuk topik diatas 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 = "<a href=\"javascript:popJadwalKomisi('" + rs.Rows[i]["NoKontrak"] + "');\">" + rs.Rows[i]["NoKontrak"].ToString() + "</a>"; r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["NoUnit"].ToString(); r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["Cs"].ToString(); r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["Ag"].ToString(); r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Num(rs.Rows[i]["NilaiKontrak"]); c.HorizontalAlign = HorizontalAlign.Right; r.Cells.Add(c); Rpt.Border(r); rpt.Rows.Add(r); } }
private void Fill(Table rpt, int myID) { string strSql = "SELECT " + " NoKontrak" + ",TglKontrak" + ",NoUnit" + ",NilaiKontrak" + " FROM MS_KONTRAK " + " WHERE NoCustomer = " + myID + " AND Project IN(" + Act.ProjectListSql + ")" + " ORDER BY NoKontrak"; DataTable rs = Db.Rs(strSql); Rpt.NoData(rpt, rs, "Customer tidak memiliki histori kontrak."); 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:popEditKontrak('" + rs.Rows[i]["NoKontrak"] + "')\">" + rs.Rows[i]["NoKontrak"] + "</a>"; c.Wrap = false; r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Day(rs.Rows[i]["TglKontrak"]); c.Wrap = false; r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["NoUnit"].ToString(); c.Wrap = false; r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Num(rs.Rows[i]["NilaiKontrak"]); c.HorizontalAlign = HorizontalAlign.Right; c.Wrap = false; r.Cells.Add(c); Rpt.Border(r); rpt.Rows.Add(r); } }
private void FillTb() { string strSql = "SELECT " + " NoKontrak" + ",TglKontrak" + ",MS_CUSTOMER.Nama AS Cs" + ",NoUnit" + ",MS_KONTRAK.Status" + " FROM MS_KONTRAK INNER JOIN MS_CUSTOMER ON MS_KONTRAK.NoCustomer = MS_CUSTOMER.NoCustomer" + " WHERE NoAgent = " + NoAgent + " ORDER BY NoKontrak"; DataTable rs = Db.Rs(strSql); 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]["NoKontrak"].ToString(); c.Wrap = false; r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["Status"].ToString(); r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Day(rs.Rows[i]["TglKontrak"]); r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["Cs"].ToString(); r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["NoUnit"].ToString(); r.Cells.Add(c); c = new TableCell(); c.Text = ""; c.Wrap = false; r.Cells.Add(c); Rpt.Border(r); rpt.Rows.Add(r); } }
private void Fill() { string addq = ""; //if(metode.SelectedIndex==1) // addq = " AND a.Status = 1"; //else if(metode.SelectedIndex==2) // addq = " AND a.Status = 0"; string strSql = "SELECT " + " a.*" + ",b.Nama AS csNama" + " FROM MS_NUP a" + " INNER JOIN MS_CUSTOMER b ON a.NoCustomer = b.NoCustomer " + " WHERE b.Nama" + " LIKE '%" + Cf.Str(keyword.Text) + "%'" + addq + " ORDER BY a.NoNUP"; DataTable rs = Db.Rs(strSql); Rpt.NoData(rpt, rs, "Tidak ditemukan data NUP 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 = rs.Rows[i]["NoNUP"].ToString(); r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["csNama"].ToString(); r.Cells.Add(c); string namaAgent = Db.SingleString("SELECT ISNULL(Nama,'') FROM MS_AGENT WHERE NoAgent=" + Convert.ToInt32(rs.Rows[i]["NoAgent"])); c = new TableCell(); c.Text = namaAgent; r.Cells.Add(c); Rpt.Border(r); rpt.Rows.Add(r); } }
private void Fill(string Tb, string Ket) { string strSql = ""; strSql = "SELECT * FROM MS_NUP WHERE NoNUP NOT IN (SELECT NoNUP FROM MS_NUP_PELUNASAN)"; //strSql = "SELECT " // + " NoKontrak AS Ref" // + ",NoUnit" // + " FROM " + Tb + "..MS_KONTRAK AS MS_KONTRAK INNER JOIN " + Tb + "..MS_CUSTOMER AS MS_CUSTOMER ON MS_KONTRAK.NoCustomer = MS_CUSTOMER.NoCustomer " // + " WHERE NoKontrak + NoUnit + Nama" // + " LIKE '%" + Cf.Str(keyword.Text) + "%'" // + " AND MS_KONTRAK.Status = 'A'" // + " ORDER BY NoKontrak"; DataTable rs = Db.Rs(strSql); for (int i = 0; i < rs.Rows.Count; i++) { if (!Response.IsClientConnected) { break; } TableRow r = new TableRow(); TableCell c; c = new TableCell(); string strMultiple = ""; // if(Ket != "TENANT") // strMultiple = " / <a href=\"javascript:location.href='TTSRegistrasiMulti.aspx?Ref=" + rs.Rows[i]["Ref"].ToString() + "&Tipe=" + Ket + "'\">multiple</a>"; c.Text = rs.Rows[i]["NoNUP"].ToString() + "<br /><a href=\"javascript:call('" + rs.Rows[i]["NoNUP"] + "','NUP')\">Next</a>" + strMultiple ; r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["Status"].ToString(); r.Cells.Add(c); Rpt.Border(r); rpt.Rows.Add(r); } }
private void FillTable() { string strSql = "SELECT * FROM MS_PJT WHERE Tipe = '" + Tipe + "' AND Ref = '" + Ref + "'"; DataTable rs = Db.Rs(strSql); decimal t1 = 0; 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='PJTEdit.aspx?NoPJT=" + rs.Rows[i]["NoPJT"] + "'>" + rs.Rows[i]["NoPJT"].ToString() + "</a>"; c.Wrap = false; r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Day(rs.Rows[i]["TglPJT"]); c.Wrap = false; r.Cells.Add(c); c = new TableCell(); c.Text = Ket(rs.Rows[i]["NoPJT"].ToString()); c.Wrap = false; r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Num(rs.Rows[i]["Total"]); c.HorizontalAlign = HorizontalAlign.Right; c.Wrap = false; r.Cells.Add(c); Rpt.Border(r); rpt.Rows.Add(r); t1 = t1 + (decimal)rs.Rows[i]["Total"]; if (i == rs.Rows.Count - 1) { SubTotal(t1); } } }
protected void FillDetil() { DataTable rs2 = Db.Rs("SELECT * FROM MS_PELUNASAN_KPA WHERE NoRealKPA=" + NoReal); 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(); c.Wrap = false; 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; } c.Wrap = false; r.Cells.Add(c); c = new TableCell(); c.Text = rs2.Rows[i]["NoKontrak"].ToString(); c.Wrap = false; r.Cells.Add(c); c = new TableCell(); c.Text = tts.Rows[0]["Customer"].ToString(); c.Wrap = false; r.Cells.Add(c); c = new TableCell(); c.Text = tts.Rows[0]["Unit"].ToString(); c.Wrap = false; r.Cells.Add(c); c = new TableCell(); c.CssClass = "txt_num"; c.Text = Cf.Num(rs2.Rows[i]["NilaiPelunasan"]); c.Wrap = false; r.Cells.Add(c); Rpt.Border(r); rpt.Rows.Add(r); } }
protected void FillDetil() { DataTable rs2 = Db.Rs("SELECT * FROM " + Mi.DbPrefix + "FINANCEAR..MS_PENGAJUAN_KPA_DETIL WHERE NoPengajuan=" + NoPengajuan); for (int i = 0; i < rs2.Rows.Count; i++) { TableCell c; TableRow r = new TableRow(); c = new TableCell(); c.Text = rs2.Rows[i]["NoKontrak"].ToString(); c.Wrap = false; r.Cells.Add(c); c = new TableCell(); c.Text = rs2.Rows[i]["Nama"].ToString(); c.Wrap = false; r.Cells.Add(c); c = new TableCell(); c.Text = rs2.Rows[i]["NoUnit"].ToString(); c.Wrap = false; r.Cells.Add(c); c = new TableCell(); c.CssClass = "txt_num"; c.Text = Cf.Num(rs2.Rows[i]["Nilai"]); c.Wrap = false; r.Cells.Add(c); c = new TableCell(); c.CssClass = "txt_num"; decimal NilaiRetensi = Db.SingleDecimal("SELECT Total FROM " + Mi.DbPrefix + "FINANCEAR..MS_REAL_KPA WHERE NoPengajuan = '" + rs2.Rows[i]["NoPengajuan"] + "'"); c.Text = Cf.Num(NilaiRetensi); c.Wrap = false; r.Cells.Add(c); c = new TableCell(); c.CssClass = "txt_num"; string NoReal = Db.SingleString("SELECT FORMAT(NoReal,'000000#') FROM " + Mi.DbPrefix + "FINANCEAR..MS_REAL_KPA WHERE NoPengajuan = '" + rs2.Rows[i]["NoPengajuan"] + "'"); //int SifatPPN = (Kategori.ToUpper() == "") ? 1 : 0; c.Text = NoReal; c.Wrap = false; r.Cells.Add(c); Rpt.Border(r); rpt.Rows.Add(r); } }
private void Fill() { DateTime tgl = Convert.ToDateTime(date.Text); string strSql = "SELECT TglLogin, TglLogout, UserID, IP, Nama, SecLevel FROM LOGIN" + " WHERE CONVERT(varchar,TglLogin,112) = '" + Cf.Tgl112(tgl) + "'" + " ORDER BY TglLogin"; DataTable rs = Db.Rs(strSql); Rpt.NoData(rpt, rs, "Tidak ada catatan absensi untuk tanggal tersebut."); 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.Time(rs.Rows[i]["TglLogin"]); r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Time(rs.Rows[i]["TglLogout"]); r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["UserID"].ToString(); r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["Nama"].ToString(); r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["SecLevel"].ToString(); r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["IP"].ToString(); r.Cells.Add(c); Rpt.Border(r); rpt.Rows.Add(r); } }
protected void Fill() { string StrSql = "SELECT a.NoVA, b.Nama, a.NoUnit FROM ISC064_MARKETINGJUAL..MS_KONTRAK a INNER JOIN ISC064_MARKETINGJUAL..MS_CUSTOMER b ON" + " a.NoCustomer = b.NoCustomer WHERE a.NoVA!='' AND a.STATUS='A'" + " AND a.NoVA IN (SELECT NOVA FROM REF_VA WHERE Bank='BRI')"; DataTable rs = Db.Rs(StrSql); for (int i = 0; i < rs.Rows.Count; i++) { if (!Response.IsClientConnected) { break; } TableRow r = new TableRow(); TableCell c; c = new TableCell(); c.Text = (i + 1).ToString(); r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["Nama"].ToString(); c.Wrap = false; r.Cells.Add(c); string kdcust = rs.Rows[i]["NoVA"].ToString().Substring(5); string briva = rs.Rows[i]["NoVA"].ToString().Substring(0, 5); c = new TableCell(); c.Text = kdcust; r.Cells.Add(c); c = new TableCell(); c.Text = briva; r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["NoUnit"].ToString() + " - " + Mi.Pt; c.Wrap = false; r.Cells.Add(c); Rpt.Border(r); rpt.Rows.Add(r); } }