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