예제 #1
0
        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) + "'"
                       );
        }
예제 #2
0
        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);
        }
예제 #3
0
        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);
        }
예제 #4
0
        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);
        }
예제 #5
0
        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') + "'"
                       );
        }
예제 #6
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);
        }
예제 #7
0
        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);
        }
예제 #8
0
        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);
        }
예제 #9
0
        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);
            }
        }
예제 #10
0
        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') + "'"
                       );
        }
예제 #11
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);
        }
예제 #12
0
        protected void Page_Load(object sender, System.EventArgs e)
        {
            Act.Pass();
            Act.NoCache();

            SetTemplate();
            Js.AutoPrint(this);
        }
예제 #13
0
 protected void Page_Load(object sender, System.EventArgs e)
 {
     if (!Page.IsPostBack)
     {
         Fill();
         Js.AutoPrint(this);
     }
 }
예제 #14
0
 protected void print_Click(object sender, System.EventArgs e)
 {
     if (valid())
     {
         reprint.Visible = false;
         Js.AutoPrint(this);
         Fill();
     }
 }
예제 #15
0
        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
            }
        }
예제 #16
0
        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"]);
        }
예제 #17
0
        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);
        }
예제 #18
0
        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);
        }
예제 #19
0
        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);
        }
예제 #20
0
        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);
        }
예제 #21
0
        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);
        }
예제 #22
0
 protected void print_Click(object sender, System.EventArgs e)
 {
     Js.AutoPrint(this);
     Fill();
 }
예제 #23
0
 protected void Page_Load(object sender, System.EventArgs e)
 {
     SetTemplate();
     Js.AutoPrint(this);
 }