public void run()
{
Exception exp = null;
OleDbCommand cmd = new OleDbCommand();
OleDbParameter param = cmd.Parameters.Add(new OleDbParameter("MyParam", "abcd"));
try
{
BeginCase("check value");
Compare(param.Value, "abcd");
}
catch (Exception ex) { exp = ex; }
finally{ EndCase(exp); exp = null; }
param = cmd.Parameters.Add("MyParam", OleDbType.VarChar, 50);
try
{
BeginCase("check parameter type");
Compare(param.GetType().FullName, typeof(OleDbParameter).FullName);
}
catch (Exception ex) { exp = ex; }
finally{ EndCase(exp); exp = null; }
try
{
BeginCase("check parameter name");
Compare(param.ParameterName, "MyParam");
}
catch (Exception ex) { exp = ex; }
finally{ EndCase(exp); exp = null; }
}
/// <summary>
/// 데이타베이스 매개 변수 구하기
/// </summary>
/// <param name="pDBManagerType">데이타베이스 관리자 종류</param>
/// <param name="strParameterName">매개 변수명</param>
/// <param name="pParameterDirection">매개 변수 방향</param>
/// <param name="pDataType">데이타 종류</param>
/// <param name="nDataSize">데이타 크기</param>
/// <param name="byDataScale">데이타 정밀도</param>
/// <returns>데이타베이스 매개 변수</returns>
private DbParameter GetDbParameter(DBManagerType pDBManagerType, string strParameterName, ParameterDirection pParameterDirection, DbType pDataType, int nDataSize, byte byDataScale)
{
try
{
DbParameter pDbParameter;
switch (pDBManagerType)
{
case DBManagerType.SQLServer: pDbParameter = new SqlParameter(); break;
case DBManagerType.Oracle: pDbParameter = new OracleParameter(); break;
case DBManagerType.MySql: pDbParameter = new MySqlParameter(); break;
case DBManagerType.OleDB: pDbParameter = new OleDbParameter(); break;
default: return(null);
}
pDbParameter.ParameterName = strParameterName;
pDbParameter.Direction = pParameterDirection;
pDbParameter.DbType = pDataType;
pDbParameter.Size = nDataSize;
if (pDbParameter.GetType() == typeof(SqlParameter))
{
(pDbParameter as SqlParameter).Scale = byDataScale;
}
return(pDbParameter);
}
catch (Exception pException)
{
throw new ExceptionManager
(
this,
"GetDbParameter(strParameterName, pParameterDirection, pDataType, nDataSize, byDataScale)",
pException
);
}
}