Пример #1
0
        /// <summary>
        /// 생성자
        /// </summary>
        /// <param name="_strMainDatabase">데이터베이스 종류 (web.config내 appSettings-MainDatabase)</param>
        public WebDataAccess(string _strMainDatabase)
        {
            try
            {
                // 데이터베이스 연결 문자열 (복호화 된 데이터)
                this.ConnectionStringDecryptValue = Configuration.GetConnectionStringDecryptValue();

                #region + 데이터베이스 연결 문자열을 복호화한다.
                switch (_strMainDatabase.ToUpper())
                {
                case "ORACLE":
                    this.SelectedDatabaseKindEnum = BaseEnumClass.SelectedDatabaseKind.ORACLE;
                    this.g_oracleLibrary          = new OracleLibrary();
                    break;

                case "MSSQL":
                    this.SelectedDatabaseKindEnum = BaseEnumClass.SelectedDatabaseKind.MS_SQL;
                    this.g_msSqlLibrary           = new MSSqlLibrary();
                    break;

                case "MARIADB":
                    this.SelectedDatabaseKindEnum = BaseEnumClass.SelectedDatabaseKind.MARIA_DB;
                    this.g_mariaDBLibrary         = new MariaDBLibrary();
                    break;
                }
                #endregion
            }
            catch (Exception err)
            {
                this.BaseClass.Error(err);
            }
        }
Пример #2
0
        /// <summary>
        /// 데이터셋 형식으로 반환
        /// </summary>
        /// <param name="_strProcedureName">프로시저명</param>
        /// <param name="_dicInputParam">Input 파라메터</param>
        /// <param name="_arrOutputParam">Output 파라메터</param>
        /// <returns></returns>
        public DataSet GetSpDataSet(string _strProcedureName, Dictionary <string, object> _dicInputParam, string[] _arrOutputParam)
        {
            try
            {
                DataSet dsRtnValue = null;

                switch (this.SelectedDatabaseKindEnum)
                {
                case BaseEnumClass.SelectedDatabaseKind.ORACLE:
                {
                    if (this.g_oracleLibrary == null)
                    {
                        this.g_oracleLibrary = new OracleLibrary();
                    }
                    dsRtnValue = this.g_oracleLibrary.GetDataSet(this.ConnectionStringDecryptValue, _strProcedureName, _dicInputParam, _arrOutputParam);
                }
                break;

                case BaseEnumClass.SelectedDatabaseKind.MS_SQL:
                {
                    if (this.g_msSqlLibrary == null)
                    {
                        this.g_msSqlLibrary = new MSSqlLibrary();
                    }
                    dsRtnValue = this.g_msSqlLibrary.GetDataSet(this.ConnectionStringDecryptValue, _strProcedureName, _dicInputParam);
                }
                break;

                case BaseEnumClass.SelectedDatabaseKind.MARIA_DB:
                {
                    if (this.g_mariaDBLibrary == null)
                    {
                        this.g_mariaDBLibrary = new MariaDBLibrary();
                    }
                    dsRtnValue = this.g_mariaDBLibrary.GetDataSet(this.ConnectionStringDecryptValue, _strProcedureName, _dicInputParam);
                }
                break;
                }

                return(dsRtnValue);
            }
            catch { throw; }
        }