/// <summary> /// 设置命令参数对象的 DbType属性 /// </summary> /// <param name="parameter">命令参数对象</param> /// <param name="dbType">DbType属性</param> public static void DbType(this OracleParameter parameter, object dbType) { if (dbType != null) { if (dbType is DbType) { parameter.DbType = (DbType)dbType; } else if (dbType is OracleDbType) { parameter.OracleDbType = (OracleDbType)dbType; } else { OracleUtils.ThrowException(dbType); } } }
/// <summary> /// 是否日期+时间类型 /// </summary> /// <param name="dbType">DbType属性</param> public static bool IsDateTime(object dbType) { if (dbType == null) { return(false); } else if (dbType is DbType) { return(((DbType)dbType) == System.Data.DbType.DateTime); } else if (dbType is OracleDbType) { return(((OracleDbType)dbType) == OracleDbType.TimeStamp); } else { return(OracleUtils.ThrowException(dbType)); } }
/// <summary> /// 检查是否Unicode数据类型 /// </summary> /// <param name="dbType">DbType属性</param> public static bool IsUnicode(object dbType) { if (dbType == null) { return(true); } else if (dbType is DbType) { return(((DbType)dbType) == System.Data.DbType.String || ((DbType)dbType) == System.Data.DbType.StringFixedLength); } else if (dbType is OracleDbType) { return(((OracleDbType)dbType) == OracleDbType.NVarchar2 || ((OracleDbType)dbType) == OracleDbType.NChar || ((OracleDbType)dbType) == OracleDbType.NClob); } else { return(OracleUtils.ThrowException(dbType)); } }