コード例 #1
0
    protected void Page_Load(object sender, EventArgs e)
    {
        this.btnCustomerCodeSearch.Attributes.Add("style", "visibility: hidden;");

        DataSet ds = new DataSet();

        if (!IsPostBack)
        {
            ds = LOV.SP_PRIFilePath();
            if (ds.Tables[0].Rows.Count > 0)
            {
                if (Session["FTPUserID"] == "")
                {
                    PathReader     p1    = new PathReader();
                    DatabaseConfig dbObj = new DatabaseConfig();
                    dbObj = p1.Deserialize_Data();
                    DAL_EXP1.Utility.Startup_Util.DB_Route = "Data Source=" + dbObj.DB + ";Persist Security Info=True;User ID=" + dbObj.UserID + ";Password="******";Unicode=True;Pooling=false";
                    Session["FTPUserID"]   = dbObj.FTPUSERID.ToString();
                    Session["FTPPASSWORD"] = dbObj.FTPPASSWORD.ToString();
                    Session["FTPIP"]       = dbObj.FTPIP.ToString();
                }
                string   strpath = ds.Tables[0].Rows[0]["fileupload"].ToString();
                string   test    = FO.getFileList(strpath, Session["FTPUserID"].ToString(), Session["FTPPASSWORD"].ToString());
                string[] Array   = test.ToString().Split(',');
                foreach (String t in Array)
                {
                    TXT_Description.Items.Add(t);
                    TXT_Description.DataBind();
                }
            }
        }
    }
コード例 #2
0
    protected void Page_Load(object sender, EventArgs e)
    {
        //DatabaseConfig D = new DatabaseConfig();
        //D = Deserialize_Data();

        //Startup_Util.DB_Route = //"Data Source=" + Startup_Util.DcryptionPWD(D.Server) + ";Initial Catalog=" + Startup_Util.DcryptionPWD(D.D2) + ";User ID=" + Startup_Util.DcryptionPWD(D.UserID) + ";Password="******"Data Source=" + Startup_Util.DcryptionPWD(D.Server) + ";Initial Catalog=" + Startup_Util.DcryptionPWD(D.D3) + ";User ID=" + Startup_Util.DcryptionPWD(D.UserID) + ";Password="******"Data Source=" + D.DB + ";Persist Security Info=True;User ID=" + D.UserID + ";Password="******";Unicode=True;Pooling=false";



        //Session["FtpUserID"] = Startup_Util.DcryptionPWD(D.FTPUSERID);
        //Session["FTPPASSWORD"] = Startup_Util.DcryptionPWD(D.FTPPASSWORD);
        //Session["FWIP"] = Startup_Util.DcryptionPWD(D.FWIP);


        Session["FtpUserID"]   = "a";
        Session["FTPPASSWORD"] = "******";
        //Session["FWIP"] = Startup_Util.DcryptionPWD(D.FWIP);
    }
コード例 #3
0
    public DBUniversalUploadProcess()
    {
        PathReader     p1 = new PathReader();
        DatabaseConfig D  = new DatabaseConfig();

        D = p1.Deserialize_Data();
        DAL_EXP1.Utility.Startup_Util.DB_Route = "Data Source=" + D.DB +
                                                 ";Persist Security Info=True;User ID=" + D.UserID + ";Password="******";";
        ConnectionString = DAL_EXP1.Utility.Startup_Util.DB_Route;
    }
コード例 #4
0
    public DatabaseConnection_Util()
    {
        PathReader     p1 = new PathReader();
        DatabaseConfig D  = new DatabaseConfig();

        D = p1.Deserialize_Data();
        DAL_EXP1.Utility.Startup_Util.DB_Route = "Data Source=" + D.DB + ";Persist Security Info=True;User ID=" + D.UserID + ";Password="******";Unicode=True;Pooling=false";
        ConnectionString = DAL_EXP1.Utility.Startup_Util.DB_Route;
        ConnectionMaker();
    }
コード例 #5
0
    public OleDbConnection GetConnection1()
    {
        //PathReader p1 = new PathReader();
        //DatabaseConfig D = new DatabaseConfig();
        //D = p1.Deserialize_Data();
        //DAL_EXP1.Utility.Startup_Util.DB_Route = "Data Source=" + D.DB + ";Persist Security Info=True;User ID=" + D.UserID + ";Password="******";Unicode=True;Pooling=false";
        //strCon_Global1 = DAL_EXP1.Utility.Startup_Util.DB_Route;

        PathReader     p1 = new PathReader();
        DatabaseConfig D  = new DatabaseConfig();

        D = p1.Deserialize_Data();
        DAL_EXP1.Utility.Startup_Util.DB_Route = "Data Source=" + D.DB + ";Persist Security Info=True;User ID=" + D.UserID + ";Password="******";Unicode=True;Pooling=false";
        //      strCon_Global1 = DAL_EXP1.Utility.Startup_Util.DB_Route;
        // strCon_Global1 = "Provider=MSDAORA.1;Password=mcbcs ;User ID=mcbcs;Data Source=orcl";
        strCon_Global1 = "Provider=MSDAORA.1;Password="******";User ID=" + D.UserID + ";Data Source=" + D.DB;
        return(new OleDbConnection(strCon_Global1));
    }
コード例 #6
0
    public MCBReportClass()
    {
        ////PathReader p1 = new PathReader();
        ////DatabaseConfig D = new DatabaseConfig();
        ////D = p1.Deserialize_Data();
        ////DAL_EXP1.Utility.Startup_Util.DB_Route = "Data Source=" + D.DB + ";Persist Security Info=True;User ID=" + D.UserID + ";Password="******";Unicode=True;Pooling=false";
        //////strCon_Global1 = DAL_EXP1.Utility.Startup_Util.DB_Route;
        //////strCon_Global1 = "Provider=MSDAORA.1;Password=mcbcs ;User ID=mcbcs_test;Data Source=nt";
        ////strCon_Global1 = ConfigurationManager.AppSettings["ConnectionString1"].ToString();
        PathReader     p1 = new PathReader();
        DatabaseConfig D  = new DatabaseConfig();

        D = p1.Deserialize_Data();
        DAL_EXP1.Utility.Startup_Util.DB_Route = "Data Source=" + D.DB + ";Persist Security Info=True;User ID=" + D.UserID + ";Password="******";Unicode=True;Pooling=false";
        /// strCon_Global1 = DAL_EXP1.Utility.Startup_Util.DB_Route;
        strCon_Global1   = "Provider=MSDAORA.1;Password="******";User ID=" + D.UserID + ";Data Source=" + D.DB;
        strCon_GlobalOra = "Password="******";User ID=" + D.UserID + ";Data Source=" + D.DB;
        //Data Source=orcl;Persist Security Info=True;User ID=mcbcs;Password=mcbcs;Unicode=True;Pooling=false
    }
コード例 #7
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            lbl_Message.Text = "";
            if ((Session["FTPUserID"].ToString() == "") || (Session["FTPPASSWORD"].ToString() == ""))
            {
                PathReader     p1    = new PathReader();
                DatabaseConfig dbObj = new DatabaseConfig();
                dbObj = p1.Deserialize_Data();
                DAL_EXP1.Utility.Startup_Util.DB_Route = "Data Source=" + dbObj.DB + ";Persist Security Info=True;User ID=" + dbObj.UserID + ";Password="******";Unicode=True;Pooling=false";
                Session["FTPUserID"]   = dbObj.FTPUSERID.ToString();
                Session["FTPPASSWORD"] = dbObj.FTPPASSWORD.ToString();
                Session["FTPIP"]       = dbObj.FTPIP.ToString();
            }

            ftpFileList();
        }
    }