Exemple #1
0
        private void GetConnectString()
        {
            BUS.LIST_QD_SCHEMAControl schCtr = new LIST_QD_SCHEMAControl();

            DTO.LIST_QD_SCHEMAInfo schInf = schCtr.Get(_sqlBuilder.Database, _sqlBuilder.Table, ref _sErr);
            string keyconn       = schInf.DEFAULT_CONN;
            string connectstring = _config.GetConnection(ref keyconn, "AP");

            _sqlBuilder.ConnID        = keyconn;
            _sqlBuilder.StrConnectDes = connectstring;
            _strConnectDes            = connectstring;
        }
Exemple #2
0
        private static void LoadConfig(string db)
        {
            string __documentDirectory = System.Environment.GetFolderPath(System.Environment.SpecialFolder.MyDocuments) + "\\" + Form_QD.DocumentFolder;
            string _strConnect         = "";
            string _strConnectDes      = "";
            string __templatePath      = "";
            string __reportPath        = "";
            string _appPath            = Application.StartupPath;

            try
            {
                QDConfig _config = new QDConfig();
                if (File.Exists(__documentDirectory + "\\Configuration\\QDConfig.tvc"))
                {
                    _config.LoadConfig(__documentDirectory + "\\Configuration\\QDConfig.tvc");

                    string key = "";
                    _strConnect    = _config.GetConnection(ref key, "QD");
                    key            = "";
                    _strConnectDes = _config.GetConnection(ref key, "AP");

                    if (_config.DIR.Rows.Count > 0)
                    {
                        __templatePath = _config.DIR.Rows[0]["TMP"].ToString();
                        __reportPath   = _config.DIR.Rows[0]["RPT"].ToString();
                    }

                    if (_config.SYS.Rows.Count > 0)
                    {
                        ReportGenerator.User2007 = (bool)_config.SYS.Rows[0][_config.SYS.USE2007Column];
                    }
                }
                QueryBuilder.SQLBuilder.SetConnection(_strConnect);
                ReportGenerator.Config = _config;
                CmdManager.Db          = db;
                CmdManager.AppConnect  = _strConnect;
                CmdManager.RepConnect  = _strConnectDes;
                CmdManager.ReptPath    = __reportPath;
                CmdManager.TempPath    = __templatePath;
            }
            catch (Exception ex)
            {
            }
        }