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);
}
}
