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