/// <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);
}
}
/// <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; }
}