예제 #1
0
        private void Fill()
        {
            cancel.Attributes["onclick"]  = "location.href='PJTEdit.aspx?NoPJT=" + NoPJT + "'";
            cancel2.Attributes["onclick"] = "location.href='PJTEdit.aspx?NoPJT=" + NoPJT + "'";

            string    strSql = "SELECT PrintPJT FROM MS_PJT WHERE NoPJT = '" + NoPJT + "'";
            DataTable rs     = Db.Rs(strSql);

            if (rs.Rows.Count == 0)
            {
                Response.Redirect("/CustomError/NoPrint.html");
            }
            else
            {
                count.Text = rs.Rows[0]["PrintPJT"].ToString();
                if ((int)rs.Rows[0]["PrintPJT"] == 0)
                {
                    Tampil(); //langsung tampil
                    ConvertPdf();
                    Response.Redirect(Param.PathLinkFilePDFCollection + NoPJT.Replace("/", "_").Replace("\\", "_") + Project + "_PJT.pdf");
                }
                else
                {
                    //mekanisme reprint
                    list.Visible    = false;
                    reprint.Visible = true;
                    Js.Focus(this, username);

                    if (Session["SalahPass"] == null)
                    {
                        Session["SalahPass"] = "******";                         //Hitung password salah berapa kali
                    }
                    else
                    {
                        if (Session["SalahPass"].ToString() != "0")
                        {
                            salah.Text = Session["SalahPass"] + "x salah";
                        }
                    }
                }
            }
        }
예제 #2
0
        private void Valid(string Username)
        {
            Session["SalahPass"] = null;

            //Logfile otorisasi
            DataTable rs = Db.Rs("SELECT "
                                 + " CONVERT(varchar, TglPJT, 106) AS [Tanggal]"
                                 + ",Tipe"
                                 + ",Ref AS [Ref.]"
                                 + ",Unit"
                                 + ",Customer"
                                 + ",Total"
                                 + " FROM MS_PJT WHERE NoPJT = '" + NoPJT + "'");

            Db.Execute("EXEC spLogPJT"
                       + " 'R-PJT'"
                       + ",'" + Username + "'"
                       + ",'" + Act.IP + "'"
                       + ",'" + Cf.LogCapture(rs) + "'"
                       + ",'" + NoPJT.ToString().PadLeft(7, '0') + "'"
                       );

            decimal LogID   = Db.SingleDecimal("SELECT TOP 1 LogID FROM MS_PJT_LOG ORDER BY LogID DESC");
            string  Project = Db.SingleString("SELECT Project FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_KONTRAK WHERE NoKontrak = (SELECT Ref FROM MS_PJT WHERE NoPJT = '" + NoPJT + "') ");

            Db.Execute("UPDATE MS_PJT_LOG SET Project = '" + Project + "' WHERE LogID  = " + LogID);

            Tampil();
            string file  = Param.PathFilePDFCollection + NoPJT.Replace("/", "_").Replace("\\", "_") + Project + "_PJT.pdf";
            bool   exist = System.IO.File.Exists(file);

            if (exist)
            {
                System.IO.File.Delete(file);
            }
            ConvertPdf();
            Response.Redirect(Param.PathLinkFilePDFCollection + NoPJT.Replace("/", "_").Replace("\\", "_") + Project + "_PJT.pdf");
        }