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() { param.Visible = false; rpt.Visible = true; lblHeader.Text = Mi.Pt + "<br />" + "Laporan NUP" ; System.Text.StringBuilder x = new System.Text.StringBuilder(); string addStr = "Semua Admin"; string addStrTipe = "Semua Tipe"; if (admin.SelectedIndex != 0) { addStr = Db.SingleString("SELECT Nama FROM ISC064_SECURITY..USERNAME WHERE UserID='" + admin.SelectedValue + "'"); } x.Append("<br />Untuk tanggal : " + Cf.Day(tglawal.Text) + " s/d " + Cf.Day(tglakhir.Text)); x.Append("<br />Untuk Admin : " + Cf.Str(addStr)); x.Append("<br />Untuk Tipe : " + Cf.Str(addStrTipe)); 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(); }
private void Fill() { btnlog.Attributes["onclick"] = "location.href='LogPk.aspx?Tb=REF_KOMISI_OVER_LOG&Pk=" + SN + "'"; btndel.Attributes["onclick"] = "location.href='KomisiOverDel.aspx?SN=" + SN + "'"; overpro.Attributes["onfocus"] = "tempnum=CalcFocus(this);"; overpro.Attributes["onkeyup"] = "CalcType(this,tempnum);"; overpro.Attributes["onblur"] = "CalcBlur(this);"; overcross.Attributes["onfocus"] = "tempnum=CalcFocus(this);"; overcross.Attributes["onkeyup"] = "CalcType(this,tempnum);"; overcross.Attributes["onblur"] = "CalcBlur(this);"; string strSql = "SELECT * FROM REF_KOMISI_OVER WHERE SN = " + SN; DataTable rs = Db.Rs(strSql); if (rs.Rows.Count == 0) { Response.Redirect("/CustomError/Deleted.html"); } else { jabatan.Text = rs.Rows[0]["Jabatan"].ToString(); overpro.Text = Cf.Num(rs.Rows[0]["Project"]); overcross.Text = Cf.Num(rs.Rows[0]["CrossSelling"]); tglInput.Text = Cf.Date(rs.Rows[0]["TglInput"]); tglEdit.Text = Cf.Date(rs.Rows[0]["TglEdit"]); } }
private void Report() { param.Visible = false; rpt.Visible = true; lblHeader.Text = Mi.Pt + "<br />" + "Laporan Outstanding Tagihan" + "<br />" + "Per " + Cf.Day(tgl.Text) ; System.Text.StringBuilder x = new System.Text.StringBuilder(); 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(); }
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(); }
private void Fill() { string Project = Db.SingleString("SELECT Project FROM MS_UNIT WHERE NoStock = '" + NoStock + "'"); cancel.Attributes["onclick"] = "location.href = 'ReservasiDaftar2.aspx?NoStock=" + NoStock + "'"; btnbaru.Attributes["onclick"] = "location.href = 'CustomerDaftar.aspx?NoStock=" + NoStock + "&reserve=1&project=" + Project + "'"; DataTable rs = Db.Rs("SELECT Luas, LuasSG, LuasNett, PriceList, NoUnit, Lokasi FROM MS_UNIT WHERE NoStock = '" + NoStock + "'"); if (rs.Rows.Count == 0) { Response.Redirect("/CustomError/Deleted.html"); } else { nounit.Text = "<a href=\"javascript:popUnit('" + NoStock + "')\">" + rs.Rows[0]["NoUnit"].ToString() + "</a>"; luasbangunan.Text = Cf.Num(rs.Rows[0]["LuasNett"]); luastanah.Text = Cf.Num(rs.Rows[0]["LuasSG"]); pl.Text = Cf.Num(rs.Rows[0]["PriceList"]); tgl.Text = Cf.Day(DateTime.Today); string ParamID = "BatasReservasi";// + Project; string ParamReserve = Db.SingleString("SELECT VALUE FROM " + Mi.DbPrefix + "SECURITY..REF_PARAM WHERE ParamID = '" + ParamID + "'"); if (!String.IsNullOrEmpty(ParamReserve)) { string[] value = ParamReserve.Split(';'); int jarak = Convert.ToInt16(value[0]); switch (value[1]) { case "1": batas.Text = Cf.Date(DateTime.Now.AddMinutes(+jarak)); break; case "2": batas.Text = Cf.Date(DateTime.Now.AddHours(+jarak)); break; case "3": batas.Text = Cf.Date(DateTime.Now.AddDays(+jarak)); break; default: batas.Text = Cf.Date(DateTime.Now.AddMinutes(+jarak)); break; } } else { ok.Enabled = false; batasc.Text = "Parameter batas reservasi belum ada. Silahkan hubungi admin terkait."; } } lokasi.Items.Add(new ListItem("-")); DataTable rs2 = Db.Rs("SELECT * FROM REF_LOKASI_KONTRAK WHERE Project = '" + Project + "' ORDER BY SN"); for (int i = 0; i < rs2.Rows.Count; i++) { lokasi.Items.Add(new ListItem(rs2.Rows[i]["Nama"].ToString(), rs2.Rows[i]["SN"].ToString())); } //string Lokasi = Db.SingleString("SELECT Nama FROM REF_LOKASI WHERE Lokasi = '" + rs.Rows[0]["Lokasi"].ToString() + "' AND Project = '" + Project + "'"); //lokasi.SelectedValue = Lokasi; }
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 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 Report() { param.Visible = false; rpt.Visible = true; rptTotal.Visible = true; lblHeader.Text = Mi.Pt + "<br />" + "Laporan Hasil Launching NUP" ; System.Text.StringBuilder x = new System.Text.StringBuilder(); string addStrAktivasi = "Semua"; string addStrStatus = "Semua"; string addStrProject = "Semua Project"; //aktivasi if (aktivasi.SelectedIndex == 1) { addStrAktivasi = " Aktif"; } else if (aktivasi.SelectedIndex == 2) { addStrAktivasi = " Non Aktif"; } //status if (status.SelectedValue == "PilihUnit") { addStrStatus = " Pilih Unit"; } else if (status.SelectedValue == "SudahClosing") { addStrStatus = " Sudah Closing"; } else if (status.SelectedValue == "SudahBayar") { addStrStatus = " Sudah Bayar"; } x.Append("<br />Tgl. Launching : " + Cf.Day(tglawal.Text) + " s/d " + Cf.Day(tglakhir.Text)); x.Append("<br />Untuk Aktivasi : " + Cf.Str(addStrAktivasi)); x.Append("<br />Untuk Status : " + Cf.Str(addStrStatus)); x.Append("<br />Untuk Project : " + Cf.Str(addStrProject)); 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 Header() { string header = "<h2>" + Mi.Pt + "</h2>"; header += "<h1 class='title'>LAPORAN PEMBATALAN</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 : eProperty Mobile oleh user " + UserID + "<br /><br />"; headReport.InnerHtml = header; }
private void newHeader() { string header = "<h2>" + Mi.Pt + "</h2>"; header += "<h1>LAPORAN CUSTOM TAGIHAN</h1>"; header += "Periode : " + Cf.Day(dari.Text) + " s/d " + Cf.Day(sampai.Text); 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 Pembatalan</h1>"; header += "<h4>Project : " + project.SelectedItem.Text + "</h4>"; header += "Periode : " + Cf.Day(dari.Text) + " s/d " + Cf.Day(sampai.Text); 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 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 COLLECTION</h1>"; header += "Periode : " + Cf.Monthname(Convert.ToInt32(Dari)) + " s/d " + Cf.Monthname(Convert.ToInt32(Sampai)) + " " + Tahun; header += "Project : " + Project; header += "Perusahaan : " + Perusahaan; 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 = "<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 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(); }
protected void Page_Load(object sender, System.EventArgs e) { Act.Pass(); Act.NoCache(); DataTable rs = Db.Rs("SELECT " + " LogID" + ",TglApprove" + ",ApprovedBy" + ",CASE WHEN Approve = 1 THEN 'Approved' WHEN Approve = 2 THEN 'Rejected' END AS Approve" + ",(SELECT Nama FROM " + Mi.DbPrefix + "SECURITY..USERNAME WHERE UserID = " + Tb + ".ApprovedBy) AS Nama" + ",NoKontrak" + ",Lvl" + ",CASE WHEN Tipe = 1 THEN 'Pengalihan Hak' WHEN Tipe = 2 THEN 'Pindah Unit' WHEN Tipe = 3 THEN 'Batal Kontrak' WHEN Tipe = 4 THEN 'Diskon' END AS Tipe" + ",CASE WHEN Finish = 1 THEN 'Selesai' ELSE 'Belum Selesai' END AS Finish" + ",Komentar FROM " + Tb + " WHERE LogID = " + LogID); if (rs.Rows.Count == 0) { Response.Redirect("/CustomError/Deleted.html"); } else { sumber.Text = Request.QueryString["sumber"]; logid.Text = LogID; tgl.Text = Cf.Date(rs.Rows[0]["TglApprove"]); user.Text = rs.Rows[0]["ApprovedBy"].ToString(); //ip.Text = rs.Rows[0]["IP"].ToString(); //BindAktivitas(rs.Rows[0]["Approve"].ToString()); pk.Text = rs.Rows[0]["NoKontrak"].ToString(); //ket.Text = rs.Rows[0]["Ket"].ToString().Replace("<br>","\n"); ket.Text = "Tipe : " + rs.Rows[0]["Tipe"].ToString() + ", Action : " + rs.Rows[0]["Approve"].ToString() + ", Komentar : " + rs.Rows[0]["Komentar"].ToString() + ", Status :" + rs.Rows[0]["Finish"].ToString(); if (!Act.Sec("AL:" + Request.PhysicalPath)) { ok.Enabled = false; } if ((string)rs.Rows[0]["Approve"] != "") { ok.Enabled = false; approveinfo.Text = (string)rs.Rows[0]["Approve"]; } } BindButton(); }
protected void Header() { Label l; l = new Label(); l.Text = Mi.Pt; l.Text += "<h1 class='title'>Daily Report</h1>"; l.Text += "<h2>per " + Cf.Day(Tgl) + "</h2>"; l.Text += "Laporan dihasilkan pada hari : " + Cf.IndoWeek(DateTime.Today) + ", " + Cf.Date(DateTime.Now) + " dari workstation : eProperty Mobile" + " dan username : "******"<br /><br />"; rpt.Controls.Add(l); }
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 Fill() { btnlog.Attributes["onclick"] = "location.href='LogPk.aspx?Tb=REF_KOMISI_CF_LOG&Pk=" + Lvl + "'"; btndel.Attributes["onclick"] = "location.href='KomisiCFDel.aspx?Lvl=" + Lvl + "'"; atas.Attributes["onfocus"] = "tempnum=CalcFocus(this);"; atas.Attributes["onkeyup"] = "CalcType(this,tempnum);"; atas.Attributes["onblur"] = "CalcBlur(this);"; bawah.Attributes["onfocus"] = "tempnum=CalcFocus(this);"; bawah.Attributes["onkeyup"] = "CalcType(this,tempnum);"; bawah.Attributes["onblur"] = "CalcBlur(this);"; gm.Attributes["onfocus"] = "tempnum=CalcFocus(this);"; gm.Attributes["onkeyup"] = "CalcType(this,tempnum);"; gm.Attributes["onblur"] = "CalcBlur(this);"; sm.Attributes["onfocus"] = "tempnum=CalcFocus(this);"; sm.Attributes["onkeyup"] = "CalcType(this,tempnum);"; sm.Attributes["onblur"] = "CalcBlur(this);"; manager.Attributes["onfocus"] = "tempnum=CalcFocus(this);"; manager.Attributes["onkeyup"] = "CalcType(this,tempnum);"; manager.Attributes["onblur"] = "CalcBlur(this);"; string strSql = "SELECT * FROM REF_KOMISI_CF WHERE Lvl ='" + Lvl + "'"; DataTable rs = Db.Rs(strSql); if (rs.Rows.Count == 0) { Response.Redirect("/CustomError/Deleted.html"); } else { ket.Text = rs.Rows[0]["Keterangan"].ToString(); atas.Text = Cf.Num(rs.Rows[0]["NilaiAtas"]); bawah.Text = Cf.Num(rs.Rows[0]["NilaiBawah"]); gm.Text = Cf.Num(rs.Rows[0]["NilaiGM"]); sm.Text = Cf.Num(rs.Rows[0]["NilaiSM"]); manager.Text = Cf.Num(rs.Rows[0]["NilaiM"]); tglInput.Text = Cf.Date(rs.Rows[0]["TglInput"]); tglEdit.Text = Cf.Date(rs.Rows[0]["TglEdit"]); } }
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 newHeader() { string tipe = ""; tipe = Tipe.Replace("-", ","); string header = "<h2>" + Mi.Pt + "</h2>"; header += "<h1 class='title'>LAPORAN PENJUALAN TAHUNAN</h1>"; header += "Periode : " + Thn1 + " s/d " + Thn2; header += "<br/>Jenis : " + tipe.Replace("%", " "); header += "<br/>Lokasi : " + Lokasi; header += "<br/>Principal : " + Agent; header += "<br/>Perusahaan : " + Perusahaan; header += "<br/>Project : " + Project; 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); }
protected void Page_Load(object sender, System.EventArgs e) { Act.Pass(); Act.NoCache(); if (!Page.IsPostBack) { InitForm(); if (Request.QueryString["NoUnit"] != null) { unit.Text = Request.QueryString["NoUnit"]; nostock.Text = NoStock; } unit.Text = Db.SingleString( "SELECT NoUnit FROM MS_UNIT WHERE NoStock = '" + NoStock + "'"); tglhold.Text = Cf.Day(DateTime.Today); tglholdexp.Text = Cf.Date(DateTime.Now.AddMonths(1)); } }
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 Header() { System.Text.StringBuilder x = new System.Text.StringBuilder(); x.Append("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(BlnDari)) + " " + Convert.ToInt32(ThnDari) + " s/d " + Cf.Monthname(Convert.ToInt32(BlnSampai)) + " " + Convert.ToInt32(ThnSampai) + "<br />" + x + "<br />" + "<br />" ; }
private void Fill() { aKey.HRef = "javascript:openModal('EditKey.aspx?UserID=" + UserID + "','350','150')"; btnlog.Attributes["onclick"] = "location.href='LogPk.aspx?Tb=USERNAME_LOG&Pk=" + UserID + "'"; btndel.Attributes["onclick"] = "location.href='DelUser.aspx?UserID=" + UserID + "'"; string strSql = "SELECT * FROM USERNAME WHERE UserID = '" + UserID + "'"; DataTable rs = Db.Rs(strSql); if (rs.Rows.Count == 0) { Response.Redirect("/CustomError/Deleted.html"); } else { userid.Text = rs.Rows[0]["UserID"].ToString(); nama.Text = rs.Rows[0]["Nama"].ToString(); email.Text = rs.Rows[0]["Email"].ToString(); seclevel.SelectedValue = rs.Rows[0]["SecLevel"].ToString(); agent.SelectedValue = rs.Rows[0]["NoAgent"].ToString(); gantipass.Checked = (bool)rs.Rows[0]["GantiPass"]; rotasipass.Text = rs.Rows[0]["RotasiPass"].ToString(); tglinput.Text = Cf.Date(rs.Rows[0]["TglInput"]); tgllogin.Text = Cf.Date(rs.Rows[0]["TglLogin"]); tglpass.Text = Cf.Date(rs.Rows[0]["TglPass"]); if (rs.Rows[0]["Status"].ToString() == "A") { status.ForeColor = Color.Green; status.Text = "Aktif"; } else { status.ForeColor = Color.Red; status.Text = "Blokir"; } } }
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(); }