private void Tampil() { list.Visible = true; reprint.Visible = false; Js.AutoPrint(this); //increment Db.Execute("UPDATE MS_SKL SET PrintSKL = PrintSKL + 1 WHERE NoSKL = '" + NoSKL + "'"); //Logfile DataTable rs = Db.Rs("SELECT " + " CONVERT(varchar, TglSKL, 106) AS [Tanggal]" + ",NoSKL" + ",Ref AS [Ref.]" + ",NoSKLManual" + ",Used AS [No.YgDigunakan]" + " FROM MS_SKL WHERE NoSKL = '" + NoSKL + "'"); Db.Execute("EXEC spLogSKL" + " '" + DateTime.Now + "'" + " ,'P-SKL'" + ",'" + Act.UserID + "'" + ",'" + Act.IP + "'" + ",'" + NoSKL.ToString() + "'" + ",'" + Cf.LogCapture(rs) + "'" ); }
private void Tampil() { list.Visible = true; reprint.Visible = false; Js.AutoPrint(this); //increment Db.Execute("UPDATE MS_TTR SET PrintTTR = PrintTTR + 1 WHERE NoTTR = '" + NoTTR + "'"); //Logfile DataTable rs = Db.Rs("SELECT " + " CONVERT(varchar, TglTTR, 106) AS [Tanggal]" + ", NoReservasi AS [No. Reservasi]" + ",Unit" + ",Customer" + ",CaraBayar AS [Cara Bayar]" + ",Ket AS [Keterangan]" + ",Total" + ",NoBG AS [No. BG]" + ",CONVERT(varchar, TglBG, 106) AS [Tanggal BG]" + " FROM MS_TTR WHERE NoTTR = '" + NoTTR + "'"); Db.Execute("EXEC spLogTTR" + " 'P-TTR'" + ",'" + Act.UserID + "'" + ",'" + Act.IP + "'" + ",'" + Cf.LogCapture(rs) + "'" + ",'" + NoTTR + "'" ); decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM MS_TTR_LOG ORDER BY LogID DESC"); string Project = Db.SingleString("SELECT Project FROM MS_UNIT WHERE NoUnit = (SELECT NoUnit FROM MS_TTR WHERE NoTTR = '" + NoTTR + "')"); Db.Execute("UPDATE MS_TTR_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID); }
private void Tampil() { list.Visible = true; reprint.Visible = false; Js.AutoPrint(this); //increment Db.Execute("UPDATE MS_BAST SET PrintBAST = PrintBAST + 1 WHERE NoKontrak = '" + NoKontrak + "'"); //Logfile DataTable rs = Db.Rs("SELECT " + " B.NoKontrak AS [No. Kontrak]" + ", B.NoUnit AS [Unit]" + ", C.Nama AS [Customer]" + ", A.PrintBAST AS [Print Counter]" + " 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 = '" + NoKontrak + "'"); Db.Execute("EXEC spLogKontrak" + " 'P-BAST'" + ",'" + Act.UserID + "'" + ",'" + Act.IP + "'" + ",'" + Cf.LogCapture(rs) + "'" + ",'" + NoKontrak.ToString() + "'" ); decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM MS_KONTRAK_LOG ORDER BY LogID DESC"); string Project = Db.SingleString("SELECT Project FROM MS_KONTRAK WHERE NoKontrak = '" + NoKontrak + "'"); Db.Execute("UPDATE MS_KONTRAK_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID); }
private void Tampil() { list.Visible = true; reprint.Visible = false; Js.AutoPrint(this); //increment Db.Execute("UPDATE " + Mi.DbPrefix + "FINANCEAR..MS_REAL_KPA SET PrintReal = PrintReal + 1 WHERE NoReal=" + NoRealisasi); //Logfile DataTable rs = Db.Rs("SELECT " + " CONVERT(varchar, TglInput, 106) AS [Tanggal]" + ",NoPengajuan" + ",CONVERT(varchar, TglReal, 106) AS [Tanggal Realisasi]" + ",Total" + ",Ket" + " FROM ISC064_FINANCEAR..MS_REAL_KPA WHERE NoReal = " + NoRealisasi); Db.Execute("EXEC ISC064_FINANCEAR..spLogRealKPA" + " 'P-RKPA'" + ",'" + Act.UserID + "'" + ",'" + Act.IP + "'" + ",'" + Cf.LogCapture(rs) + "'" + ",'" + NoRealisasi + "'" ); decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM " + Mi.DbPrefix + "FINANCEAR..MS_REAL_KPA_LOG ORDER BY LogID DESC"); string Project = Db.SingleString("SELECT Project FROM " + Mi.DbPrefix + "FINANCEAR..MS_PENGAJUAN_KPA WHERE NoPengajuan = (SELECT NoPengajuan FROM " + Mi.DbPrefix + "FINANCEAR..MS_REAL_KPA WHERE NoReal = '" + NoRealisasi + "')"); Db.Execute("UPDATE " + Mi.DbPrefix + "FINANCEAR..MS_REAL_KPA_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID); }
private void Tampil() { list.Visible = true; reprint.Visible = false; Js.AutoPrint(this); //increment Db.Execute("UPDATE MS_KASMASUK SET PrintKM = PrintKM + 1 WHERE NoVoucher = " + NoVoucher); //Logfile DataTable rs = Db.Rs("SELECT " + " NoVoucher AS [No. Voucher]" + ",CONVERT(varchar,Tgl,106) AS Tgl" + ",Acc AS [No. Account]" + ",CaraBayar AS [Cara Bayar]" + ",AlatBayar AS [Alat Bayar]" + ",DiterimaDari AS [Diterima Dari]" + ",Keterangan" + ",Nilai" + " FROM MS_KASMASUK WHERE NoVoucher = " + NoVoucher); Db.Execute("EXEC spLogKasMasuk" + " 'P-KM'" + ",'" + Act.UserID + "'" + ",'" + Act.IP + "'" + ",'" + Cf.LogCapture(rs) + "'" + ",'" + NoVoucher.ToString().PadLeft(5, '0') + "'" ); }
private void Tampil() { list.Visible = true; reprint.Visible = false; Js.AutoPrint(this); //increment Db.Execute("UPDATE MS_RESERVASI SET PrintWL = PrintWL + 1 WHERE NoReservasi = " + NoReservasi); //Logfile DataTable rs = Db.Rs("SELECT " + " MS_RESERVASI.NoUnit AS [Unit]" + ",MS_CUSTOMER.Nama AS [Customer]" + ",PrintWL AS [Print Counter]" + " FROM MS_RESERVASI INNER JOIN MS_CUSTOMER ON MS_RESERVASI.NoCustomer = MS_CUSTOMER.NoCustomer" + " WHERE MS_RESERVASI.NoReservasi = " + NoReservasi ); Db.Execute("EXEC spLogReservasi" + " 'P-WL'" + ",'" + Act.UserID + "'" + ",'" + Act.IP + "'" + ",'" + Cf.LogCapture(rs) + "'" + ",'" + NoReservasi.ToString().PadLeft(5, '0') + "'" ); decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM MS_RESERVASI_LOG ORDER BY LogID DESC"); string Project = Db.SingleString("SELECT Project FROM MS_UNIT WHERE NoStock = (SELECT NoStock FROM MS_RESERVASI WHERE NoReservasi = '" + NoReservasi + "')"); Db.Execute("UPDATE MS_RESERVASI_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID); }
private void Tampil() { list.Visible = true; reprint.Visible = false; Js.AutoPrint(this); //increment Db.Execute("UPDATE MS_TUNGGAKAN SET PrintST = PrintST + 1 WHERE NoTunggakan = " + NoTunggakan); //Logfile DataTable rs = Db.Rs("SELECT " + " CONVERT(varchar, TglTunggakan, 106) AS [Tanggal]" + ",Tipe" + ",Ref AS [Ref.]" + ",Unit" + ",Customer" + ",Total" + ",LevelTunggakan AS [Level]" + " FROM MS_TUNGGAKAN WHERE NoTunggakan = " + NoTunggakan); Db.Execute("EXEC spLogTunggakan" + " 'P-ST'" + ",'" + Act.UserID + "'" + ",'" + Act.IP + "'" + ",'" + Cf.LogCapture(rs) + "'" + ",'" + NoTunggakan.ToString().PadLeft(7, '0') + "'" ); decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM MS_TUNGGAKAN_LOG ORDER BY LogID DESC"); string Project = Db.SingleString("SELECT Project FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_KONTRAK WHERE NoKontrak = (SELECT Ref FROM MS_TUNGGAKAN WHERE NoTunggakan = '" + NoTunggakan + "') "); Db.Execute("UPDATE MS_TUNGGAKAN_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID); }
private void Tampil() { list.Visible = true; reprint.Visible = false; Js.AutoPrint(this); //increment Db.Execute("UPDATE MS_KONTRAK_GIMMICK SET PrintGimmick = PrintGimmick + 1 WHERE NoKontrak = '" + NoKontrak + "'"); //Logfile DataTable rs = Db.Rs("SELECT " + " a.NoKontrak AS [No. Kontrak]" + ",b.NoUnit AS [Unit]" + ",(Select Nama from MS_CUSTOMER c where c.NoCustomer = b.NoCustomer) AS Customer" + ",a.PrintGimmick AS [Print Gimmick Counter]" + " FROM MS_KONTRAK_GIMMICK a INNER JOIN MS_KONTRAK b" + " ON a.NoKontrak = b.NoKontrak" + " WHERE a.NoKontrak = '" + NoKontrak + "'"); Db.Execute("EXEC spLogKontrak" + " 'P-GIM'" + ",'" + Act.UserID + "'" + ",'" + Act.IP + "'" + ",'" + Cf.LogCapture(rs) + "'" + ",'" + NoKontrak.ToString() + "'" ); decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM MS_KONTRAK_LOG ORDER BY LogID DESC"); string Project = Db.SingleString("SELECT Project FROM MS_KONTRAK WHERE NoKontrak = '" + NoKontrak + "'"); Db.Execute("UPDATE MS_KONTRAK_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID); }
protected void ok_Click(object sender, System.EventArgs e) { if (Valid()) { a.Visible = false; b.Visible = true; int intFrom = Convert.ToInt32(tbDari.Text); int intTo = Convert.ToInt32(tbSampai.Text); if (intFrom > intTo) { int x = intTo; intTo = intFrom; intFrom = x; } for (int i = intFrom; i <= intTo; i++) { SetTemplate(i.ToString()); if (i <= (intTo - 1)) { Label l = new Label(); l.Text = "<div style='page-break-after: always;'></div>"; list.Controls.Add(l); } } Js.AutoPrint(this); } }
private void Tampil() { list.Visible = true; reprint.Visible = false; Js.AutoPrint(this); //increment Db.Execute("UPDATE " + Mi.DbPrefix + "FINANCEAR..MS_TTS SET PrintTTS = PrintTTS + 1 WHERE NoTTS = " + NoTTS); //Logfile DataTable rs = Db.Rs("SELECT " + " CONVERT(varchar, TglTTS, 106) AS [Tanggal]" + ",Tipe" + ",Ref AS [Ref.]" + ",Unit" + ",Customer" + ",CaraBayar AS [Cara Bayar]" + ",Ket AS [Keterangan]" + ",Total" + ",NoBG AS [No. BG]" + ",CONVERT(varchar, TglBG, 106) AS [Tanggal BG]" + " FROM " + Mi.DbPrefix + "FINANCEAR..MS_TTS WHERE NoTTS = " + NoTTS); Db.Execute("EXEC " + Mi.DbPrefix + "FINANCEAR..spLogTTS" + " 'P-TTS'" + ",'" + Act.UserID + "'" + ",'" + Act.IP + "'" + ",'" + Cf.LogCapture(rs) + "'" + ",'" + NoTTS.ToString().PadLeft(7, '0') + "'" ); }
private void Tampil() { list.Visible = true; reprint.Visible = false; int c = Db.SingleInteger("SELECT PrintRefund FROM MS_NUP WHERE NoNUP='" + NoNUP + "' AND Tipe = '" + Tipe + "'"); //Logfile DataTable rsLog = Db.Rs("SELECT " + " MS_NUP.NoNUP AS [NUP]" + ",MS_NUP.Tipe AS [NUP]" + ",MS_CUSTOMER.Nama AS [Customer]" + " FROM MS_NUP INNER JOIN MS_CUSTOMER" + " ON MS_NUP.NoCustomer = MS_CUSTOMER.NoCustomer" + " WHERE MS_NUP.NoNUP = '" + NoNUP + "' AND Tipe = '" + Tipe + "'"); Db.Execute("EXEC spLogNUP" + " 'P-RFNUP'" + ",'" + Act.UserID + "'" + ",'" + Act.IP + "'" + ",'" + Cf.LogCapture(rsLog) + "'" + ",'" + NoNUP + "'" ); Js.AutoPrint(this); }
protected void Page_Load(object sender, System.EventArgs e) { Act.Pass(); Act.NoCache(); SetTemplate(); Js.AutoPrint(this); }
protected void Page_Load(object sender, System.EventArgs e) { if (!Page.IsPostBack) { Fill(); Js.AutoPrint(this); } }
protected void print_Click(object sender, System.EventArgs e) { if (valid()) { reprint.Visible = false; Js.AutoPrint(this); Fill(); } }
protected void Page_Load(object sender, System.EventArgs e) { //Act.Pass(); if (!Page.IsPostBack) { //InitForm(); //Js.Focus(this, print); Js.AutoPrint(this); //reprint.Visible = false; Fill(); //BelumPrint();//daftar Tunggakan yang belum print } }
protected void Page_Load(object sender, EventArgs e) { Js.AutoPrint(this); string strSql = "SELECT * FROM MS_PRIORITY A INNER JOIN MS_UNIT B ON A.NoStock = B.NoStock WHERE NoNUP = '" + NoNUP + "'"; DataTable rs = Db.Rs(strSql); nounit.Text = rs.Rows[0]["NoUnit"].ToString(); priority.Text = NoNUP; nomorunit.Text = rs.Rows[0]["NoUnit"].ToString(); namacust.Text = Db.SingleString("SELECT Nama FROM MS_CUSTOMER WHERE NoNUP ='" + NoNUP + "'"); tipe.Text = Db.SingleString("SELECT Nama FROM REF_JENIS WHERE Jenis = '" + rs.Rows[0]["Jenis"].ToString() + "'"); luas.Text = Cf.Num(rs.Rows[0]["luas"]); harga.Text = Cf.Num(rs.Rows[0]["NilaiKontrak"]); }
private void Tampil() { list.Visible = true; reprint.Visible = false; Js.AutoPrint(this); //increment Db.Execute("UPDATE MS_RESERVASI SET PrintBForm = PrintBForm + 1 WHERE NoReservasi = '" + NoReservasi + "'"); //Logfile DataTable rs = Db.Rs("SELECT " + " NoReservasi AS [No. Reservasi]" + ",NoUnit AS [Unit]" + ",NoUrut AS [No. Urut]" + ",NoStock AS [No. Stock]" + ",MS_CUSTOMER.Nama AS [Customer]" + ",MS_AGENT.Nama + ' ' + MS_AGENT.Principal AS [Agent]" + ",CONVERT(varchar,Tgl,106) AS [Tanggal]" + ",CONVERT(varchar,TglExpire,100) AS [Batas Waktu]" + ",Netto AS [Nilai Pengikatan]" + ",MS_RESERVASI.Skema AS [Skema]" + ",NoQueue AS [NUP]" + ",MS_RESERVASI.NoRefferatorAgent" + ",MS_RESERVASI.NoRefferatorCustomer" + " FROM MS_RESERVASI INNER JOIN MS_CUSTOMER ON MS_RESERVASI.NoCustomer = MS_CUSTOMER.NoCustomer" + " INNER JOIN MS_AGENT ON MS_RESERVASI.NoAgent = MS_AGENT.NoAgent" + " WHERE NoReservasi = " + NoReservasi ); Db.Execute("EXEC spLogReservasi" + " 'P-BFORM'" + ",'" + Act.UserID + "'" + ",'" + Act.IP + "'" + ",'" + Cf.LogCapture(rs) + "'" + ",'" + NoReservasi.ToString().PadLeft(5, '0') + "'" ); decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM MS_RESERVASI_LOG ORDER BY LogID DESC"); Db.Execute("UPDATE MS_RESERVASI_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID); }
private void Tampil() { list.Visible = true; reprint.Visible = false; Js.AutoPrint(this); //increment Db.Execute("UPDATE MS_MEMO SET PrintMEMO = PrintMEMO + 1 WHERE NoMEMO = " + NoMEMO); //Logfile DataTable rs = Db.Rs("SELECT " + " CONVERT(varchar, TglMEMO, 106) AS [Tanggal]" + ",Tipe" + ",Ref AS [Ref.]" + ",Unit" + ",Customer" + ",CaraBayar AS [Cara Bayar]" + ",Ket AS [Keterangan]" + ",Total" + ",NoBG AS [No. BG]" + ",CONVERT(varchar, TglBG, 106) AS [Tanggal BG]" + ",NoMEMO AS [No. MEMO Sistem]" + ",NoMEMO2 AS [No. MEMO]" + ",CONVERT(varchar, TglMEMO, 106) AS [Tanggal MEMO]" + " FROM MS_MEMO WHERE NoMEMO = " + NoMEMO); Db.Execute("EXEC spLogMEMO" + " 'P-MEMO'" + ",'" + Act.UserID + "'" + ",'" + Act.IP + "'" + ",'" + Cf.LogCapture(rs) + "'" + ",'" + NoMEMO.ToString().PadLeft(7, '0') + "'" ); decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM MS_MEMO_LOG ORDER BY LogID DESC"); string Project = Db.SingleString("SELECT Project FROM MS_MEMO WHERE NoMEMO = '" + NoMEMO + "'"); Db.Execute("UPDATE MS_MEMO_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID); }
private void Tampil() { list.Visible = true; reprint.Visible = false; Js.AutoPrint(this); //increment Db.Execute("UPDATE MS_TTS SET PrintBKM = PrintBKM + 1 WHERE NoTTS = " + NoTTS); //Logfile DataTable rs = Db.Rs("SELECT " + " CONVERT(varchar, TglTTS, 106) AS [Tanggal]" + ",Tipe" + ",Ref AS [Ref.]" + ",Unit" + ",Customer" + ",CaraBayar AS [Cara Bayar]" + ",Ket AS [Keterangan]" + ",Total" + ",NoBG AS [No. BG]" + ",CONVERT(varchar, TglBG, 106) AS [Tanggal BG]" + ",NoBKM AS [No. BKM]" + ",CONVERT(varchar, TglBKM, 106) AS [Tanggal BKM]" + " FROM MS_TTS WHERE NoTTS = " + NoTTS); Db.Execute("EXEC spLogTTS" + " 'P-BKM'" + ",'" + Act.UserID + "'" + ",'" + Act.IP + "'" + ",'" + Cf.LogCapture(rs) + "'" + ",'" + NoTTS.ToString().PadLeft(7, '0') + "'" ); decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM MS_TTS_LOG ORDER BY LogID DESC"); string Project = Db.SingleString("SELECT Project FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_KONTRAK WHERE NoKontrak = (SELECT Ref FROM MS_TTS WHERE NoTTS = '" + NoTTS + "')"); Db.Execute("UPDATE MS_TTS_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID); }
private void Print() { int From = 0, To = 0; if (Request.QueryString["from"] != null && Request.QueryString["To"] != null) { From = Convert.ToInt32(Request.QueryString["from"]); To = Convert.ToInt32(Request.QueryString["to"]); } if (From > To) { int x = To; To = From; From = x; } string strSql = "SELECT NoTTS" + " FROM MS_TTS" + " WHERE NoBKM >= " + From + " AND NoBKM <= " + To ; DataTable rs = Db.Rs(strSql); for (int i = 0; i < rs.Rows.Count; i++) { SetTemplate(Cf.Pk(rs.Rows[i]["NoTTS"])); if (i <= (To - 1)) { Label l = new Label(); l.Text = "<div style='page-break-after: always;'></div>"; list.Controls.Add(l); } } Js.AutoPrint(this); }
private void Tampil() { list.Visible = true; reprint.Visible = false; Js.AutoPrint(this); //increment Db.Execute("UPDATE MS_KONTRAK SET PrintFPS = PrintFPS + 1 WHERE NoKontrak = '" + NoKontrak + "'"); //Logfile DataTable rs = Db.Rs("SELECT " + " CONVERT(varchar, TglKontrak, 106) AS [Tanggal]" + ",NoKontrak AS [No Kontrak]" + ",NoCustomer AS [No Customer]" + ",Gross" + ",NoUnit AS [No Unit]" + ",NoAJB AS [No AJB]" + ",CaraBayar AS [Cara Bayar]" + ",KetWawancara AS [Keterangan]" + ",NilaiKontrak AS [Nilai Kontrak]" + ",NoFPS AS [No. FPS]" + " FROM MS_KONTRAK WHERE NoKontrak = '" + NoKontrak + "'"); Db.Execute("EXEC spLogKontrak" + " 'P-FPS'" + ",'" + Act.UserID + "'" + ",'" + Act.IP + "'" + ",'" + Cf.LogCapture(rs) + "'" + ",'" + NoKontrak.ToString().PadLeft(7, '0') + "'" ); decimal LogID = Db.SingleDecimal("SELECT TOP 1 LogID FROM MS_KONTRAK_LOG ORDER BY LogID DESC"); string Project = Db.SingleString("SELECT Project FROM MS_KONTRAK WHERE NoKontrak = '" + NoKontrak + "'"); Db.Execute("UPDATE MS_KONTRAK_LOG SET Project = '" + Project + "' WHERE LogID = " + LogID); }
protected void print_Click(object sender, System.EventArgs e) { Js.AutoPrint(this); Fill(); }
protected void Page_Load(object sender, System.EventArgs e) { SetTemplate(); Js.AutoPrint(this); }