// // System.Data.SqlTypes.SqlMoney // // Author: // Tim Coleman // Ville Palo // // (C) Copyright 2002 Tim Coleman // using System; using System.Globalization; namespace System.Data.SqlTypes { public struct SqlMoney : INullable, IComparable { #region Fields decimal value; private bool notNull; public static readonly SqlMoney MaxValue = new SqlMoney (922337203685477.5807m); public static readonly SqlMoney MinValue = new SqlMoney (-922337203685477.5808m); public static readonly SqlMoney Null; public static readonly SqlMoney Zero = new SqlMoney (0); #endregion #region Constructors public SqlMoney (decimal value) { if (value > 922337203685477.5807m || value < -922337203685477.5808m) throw new OverflowException (); value = Decimal.Round (value, 4); int [] bits = Decimal.GetBits (value); int scaleDiff = 4 - ((bits [3] & 0x7FFF0000) >> 16); decimal tmp = value; // integrify if (scaleDiff > 0) for (int i = 0; i < scaleDiff; i++) tmp *= 10; else if (scaleDiff < 0) for (int i = 0; i > scaleDiff; i--) tmp /= 10; int [] tmpbits = decimal.GetBits (tmp); tmpbits [3] = (value < 0) ? 0x8004 << 16 : 0x40000; this.value = new decimal (tmpbits); notNull = true; } public SqlMoney (double value) : this ((decimal)value) { } public SqlMoney (int value) : this ((decimal)value) { } public SqlMoney (long value) : this ((decimal)value) { } #endregion #region Properties public bool IsNull { get { return !notNull; } } public decimal Value { get { if (this.IsNull) throw new SqlNullValueException (); else return value; } } #endregion #region Methods public static SqlMoney Add (SqlMoney x, SqlMoney y) { return (x + y); } public int CompareTo (object value) { if (value == null) return 1; else if (!(value is SqlMoney)) throw new ArgumentException (Locale.GetText ("Value is not a System.Data.SqlTypes.SqlMoney")); else if (((SqlMoney)value).IsNull) return 1; else return this.value.CompareTo (((SqlMoney)value).Value); } public static SqlMoney Divide (SqlMoney x, SqlMoney y) { return (x / y); } public override bool Equals (object value) { if (!(value is SqlMoney)) return false; if (this.IsNull && ((SqlMoney)value).IsNull) return true; else if (((SqlMoney)value).IsNull) return false; else return (bool) (this == (SqlMoney)value); } public static SqlBoolean Equals (SqlMoney x, SqlMoney y) { return (x == y); } public override int GetHashCode () { return (int)value; } public static SqlBoolean GreaterThan (SqlMoney x, SqlMoney y) { return (x > y); } public static SqlBoolean GreaterThanOrEqual (SqlMoney x, SqlMoney y) { return (x >= y); } public static SqlBoolean LessThan (SqlMoney x, SqlMoney y) { return (x < y); } public static SqlBoolean LessThanOrEqual (SqlMoney x, SqlMoney y) { return (x <= y); } public static SqlMoney Multiply (SqlMoney x, SqlMoney y) { return (x * y); } public static SqlBoolean NotEquals (SqlMoney x, SqlMoney y) { return (x != y); } public static SqlMoney Parse (string s) { decimal d = Decimal.Parse (s); if (d > SqlMoney.MaxValue.Value || d < SqlMoney.MinValue.Value) throw new OverflowException (""); return new SqlMoney (d); } public static SqlMoney Subtract (SqlMoney x, SqlMoney y) { return (x - y); } public decimal ToDecimal () { return value; } public double ToDouble () { return (double)value; } public int ToInt32 () { return (int) Math.Round (value); } public long ToInt64 () { return (long) Math.Round (value); } public SqlBoolean ToSqlBoolean () { return ((SqlBoolean)this); } public SqlByte ToSqlByte () { return ((SqlByte)this); } public SqlDecimal ToSqlDecimal () { return ((SqlDecimal)this); } public SqlDouble ToSqlDouble () { return ((SqlDouble)this); } public SqlInt16 ToSqlInt16 () { return ((SqlInt16)this); } public SqlInt32 ToSqlInt32 () { return ((SqlInt32)this); } public SqlInt64 ToSqlInt64 () { return ((SqlInt64)this); } public SqlSingle ToSqlSingle () { return ((SqlSingle)this); } public SqlString ToSqlString () { return ((SqlString)this); } public override string ToString () { if (!notNull) return "Null"; else return value.ToString (); } public static SqlMoney operator + (SqlMoney x, SqlMoney y) { checked { return new SqlMoney (x.Value + y.Value); } } public static SqlMoney operator / (SqlMoney x, SqlMoney y) { checked { return new SqlMoney (x.Value / y.Value); } } public static SqlBoolean operator == (SqlMoney x, SqlMoney y) { if (x.IsNull || y.IsNull) return SqlBoolean.Null; else return new SqlBoolean (x.Value == y.Value); } public static SqlBoolean operator > (SqlMoney x, SqlMoney y) { if (x.IsNull || y.IsNull) return SqlBoolean.Null; else return new SqlBoolean (x.Value > y.Value); } public static SqlBoolean operator >= (SqlMoney x, SqlMoney y) { if (x.IsNull || y.IsNull) return SqlBoolean.Null; else return new SqlBoolean (x.Value >= y.Value); } public static SqlBoolean operator != (SqlMoney x, SqlMoney y) { if (x.IsNull || y.IsNull) return SqlBoolean.Null; else return new SqlBoolean (!(x.Value == y.Value)); } public static SqlBoolean operator < (SqlMoney x, SqlMoney y) { if (x.IsNull || y.IsNull) return SqlBoolean.Null; else return new SqlBoolean (x.Value < y.Value); } public static SqlBoolean operator <= (SqlMoney x, SqlMoney y) { if (x.IsNull || y.IsNull) return SqlBoolean.Null; return new SqlBoolean (x.Value <= y.Value); } public static SqlMoney operator * (SqlMoney x, SqlMoney y) { checked { return new SqlMoney (x.Value * y.Value); } } public static SqlMoney operator - (SqlMoney x, SqlMoney y) { checked { return new SqlMoney (x.Value - y.Value); } } public static SqlMoney operator - (SqlMoney n) { return new SqlMoney (-(n.Value)); } public static explicit operator SqlMoney (SqlBoolean x) { if (x.IsNull) return Null; else { checked { return new SqlMoney ((decimal)x.ByteValue); } } } public static explicit operator SqlMoney (SqlDecimal x) { if (x.IsNull) return Null; else { checked { return new SqlMoney (x.Value); } } } public static explicit operator SqlMoney (SqlDouble x) { if (x.IsNull) return Null; else { checked { return new SqlMoney ((decimal)x.Value); } } } public static explicit operator decimal (SqlMoney x) { return x.Value; } public static explicit operator SqlMoney (SqlSingle x) { if (x.IsNull) return Null; else { checked { return new SqlMoney ((decimal)x.Value); } } } public static explicit operator SqlMoney (SqlString x) { checked { return SqlMoney.Parse (x.Value); } } public static implicit operator SqlMoney (decimal x) { return new SqlMoney (x); } public static implicit operator SqlMoney (SqlByte x) { if (x.IsNull) return Null; else return new SqlMoney ((decimal)x.Value); } public static implicit operator SqlMoney (SqlInt16 x) { if (x.IsNull) return Null; else return new SqlMoney ((decimal)x.Value); } public static implicit operator SqlMoney (SqlInt32 x) { if (x.IsNull) return Null; else return new SqlMoney (x.Value); } public static implicit operator SqlMoney (SqlInt64 x) { if (x.IsNull) return Null; else return new SqlMoney (x.Value); } #endregion } }