/// <summary>
/// 轉換 FieldDbType 為 SqlDbType。
/// </summary>
/// <param name="fieldDbType">FieldType列舉。</param>
public static SqlDbType ToSqlDbType(EFieldDbType fieldDbType)
{
switch (fieldDbType)
{
case EFieldDbType.String: return(SqlDbType.NVarChar);
case EFieldDbType.Text: return(SqlDbType.NVarChar);
case EFieldDbType.Boolean: return(SqlDbType.Bit);
case EFieldDbType.Integer: return(SqlDbType.Int);
case EFieldDbType.Currency: return(SqlDbType.Money);
case EFieldDbType.Double: return(SqlDbType.Float);
case EFieldDbType.DateTime: return(SqlDbType.DateTime);
case EFieldDbType.GUID: return(SqlDbType.UniqueIdentifier);
case EFieldDbType.Binary: return(SqlDbType.Binary);
default:
throw new GException("{0} can't convert to SqlDbType", fieldDbType.ToString());
}
}
/// <summary>
/// 轉換 FieldDbType 為 OracleTypem。
/// </summary>
/// <param name="fieldDbType">FieldType列舉。</param>
public static OracleType ToOracleType(EFieldDbType fieldDbType)
{
switch (fieldDbType)
{
case EFieldDbType.String: return(OracleType.NChar);
case EFieldDbType.Text: return(OracleType.NVarChar);
case EFieldDbType.Boolean: return(OracleType.Char);
case EFieldDbType.Integer: return(OracleType.Int32);
case EFieldDbType.Double: return(OracleType.Double);
case EFieldDbType.DateTime: return(OracleType.DateTime);
case EFieldDbType.Currency: return(OracleType.Number);
case EFieldDbType.GUID: return(OracleType.NVarChar);
default:
throw new GException("{0} can't convert to OracleType", fieldDbType.ToString());
}
}