Code:
/ FX-1434 / FX-1434 / 1.0 / untmp / whidbey / REDBITS / ndp / fx / src / Data / System / Data / SQLTypes / SQLMoney.cs / 1 / SQLMoney.cs
//------------------------------------------------------------------------------ //// Copyright (c) Microsoft Corporation. All rights reserved. // //junfang //[....] //[....] //----------------------------------------------------------------------------- //************************************************************************* // @File: SqlMoney.cs // // Create by: JunFang // // Purpose: Implementation of SqlMoney which is equivalent to // data type "money" in SQL Server // // Notes: // // History: // // 09/17/99 JunFang Created and implemented as first drop. // // @EndHeader@ //************************************************************************* using System; using System.Data.Common; using System.Diagnostics; using System.Runtime.InteropServices; using System.Globalization; using System.Xml; using System.Xml.Schema; using System.Xml.Serialization; namespace System.Data.SqlTypes { ////// [Serializable] [StructLayout(LayoutKind.Sequential)] [XmlSchemaProvider("GetXsdType")] public struct SqlMoney : INullable, IComparable, IXmlSerializable { private bool m_fNotNull; // false if null private long m_value; // SQL Server stores money8 as ticks of 1/10000. internal static readonly int x_iMoneyScale = 4; private static readonly long x_lTickBase = 10000; private static readonly double x_dTickBase = (double)x_lTickBase; private static readonly long MinLong = unchecked((long)0x8000000000000000L) / x_lTickBase; private static readonly long MaxLong = 0x7FFFFFFFFFFFFFFFL / x_lTickBase; // constructor // construct a Null private SqlMoney(bool fNull) { m_fNotNull = false; m_value = 0; } // Constructs from a long value without scaling. The ignored parameter exists // only to distinguish this constructor from the constructor that takes a long. // Used only internally. internal SqlMoney(long value, int ignored) { m_value = value; m_fNotNull = true; } ////// Represents a currency value ranging from /// -2 ///(or -922,337,203,685,477.5808) to 2 -1 (or /// +922,337,203,685,477.5807) with an accuracy to /// a ten-thousandth of currency unit to be stored in or retrieved from a /// database. /// /// public SqlMoney(int value) { m_value = (long)value * x_lTickBase; m_fNotNull = true; } ////// Initializes a new instance of the ///class with the value given. /// /// public SqlMoney(long value) { if (value < MinLong || value > MaxLong) throw new OverflowException(SQLResource.ArithOverflowMessage); m_value = value * x_lTickBase; m_fNotNull = true; } ////// Initializes a new instance of the ///class with the value given. /// /// public SqlMoney(Decimal value) { // Since Decimal is a value type, operate directly on value, don't worry about changing it. SqlDecimal snum = new SqlDecimal(value); snum.AdjustScale(x_iMoneyScale - snum.Scale, true); Debug.Assert(snum.Scale == x_iMoneyScale); if (snum.m_data3 != 0 || snum.m_data4 != 0) throw new OverflowException(SQLResource.ArithOverflowMessage); bool fPositive = snum.IsPositive; ulong ulValue = (ulong)snum.m_data1 + ( ((ulong)snum.m_data2) << 32 ); if (fPositive && ulValue > (ulong)(Int64.MaxValue) || !fPositive && ulValue > unchecked((ulong)(Int64.MinValue))) throw new OverflowException(SQLResource.ArithOverflowMessage); m_value = fPositive ? (long)ulValue : unchecked(- (long)ulValue); m_fNotNull = true; } ////// Initializes a new instance of the ///class with the value given. /// /// public SqlMoney(double value) : this(new Decimal(value)) { } // INullable ////// Initializes a new instance of the ///class with the value given. /// /// public bool IsNull { get { return !m_fNotNull;} } // property: Value ////// Gets a value indicating whether the ////// property is assigned to null. /// /// public Decimal Value { get { if (m_fNotNull) return ToDecimal(); else throw new SqlNullValueException(); } } ////// Gets or sets the monetary value of an instance of the ////// class. /// /// public Decimal ToDecimal() { if(IsNull) throw new SqlNullValueException(); bool fNegative = false; long value = m_value; if (m_value < 0) { fNegative = true; value = - m_value; } return new Decimal(unchecked((int)value), unchecked((int)(value >> 32)), 0, fNegative, (byte)x_iMoneyScale); } ///[To be supplied.] ////// public long ToInt64() { if(IsNull) throw new SqlNullValueException(); long ret = m_value / (x_lTickBase / 10); bool fPositive = (ret >= 0); long remainder = ret % 10; ret = ret / 10; if (remainder >= 5) { if (fPositive) ret ++; else ret --; } return ret; } internal long ToSqlInternalRepresentation() { if(IsNull) throw new SqlNullValueException(); return m_value; } ///[To be supplied.] ////// public int ToInt32() { return checked((int)(ToInt64())); } ///[To be supplied.] ////// public double ToDouble() { return Decimal.ToDouble(ToDecimal()); } // Implicit conversion from Decimal to SqlMoney ///[To be supplied.] ////// public static implicit operator SqlMoney(Decimal x) { return new SqlMoney(x); } // Explicit conversion from Double to SqlMoney public static explicit operator SqlMoney(double x) { return new SqlMoney(x); } // Implicit conversion from long to SqlMoney public static implicit operator SqlMoney(long x) { return new SqlMoney(new Decimal(x)); } // Explicit conversion from SqlMoney to Decimal. Throw exception if x is Null. ///[To be supplied.] ////// public static explicit operator Decimal(SqlMoney x) { return x.Value; } ///[To be supplied.] ////// public override String ToString() { if (this.IsNull) { return SQLResource.NullString; } Decimal money = ToDecimal(); // Formatting of SqlMoney: At least two digits after decimal point return money.ToString("#0.00##", (IFormatProvider)null); } ///[To be supplied.] ////// public static SqlMoney Parse(String s) { // Try parsing the format of '#0.00##' generated by ToString() by using the // culture invariant NumberFormatInfo as well as the current culture's format // Decimal d; SqlMoney money; const NumberStyles SqlNumberStyle = NumberStyles.AllowCurrencySymbol | NumberStyles.AllowDecimalPoint | NumberStyles.AllowParentheses | NumberStyles.AllowTrailingSign | NumberStyles.AllowLeadingSign | NumberStyles.AllowTrailingWhite | NumberStyles.AllowLeadingWhite; if ( s == SQLResource.NullString) { money = SqlMoney.Null; } else if (Decimal.TryParse(s, SqlNumberStyle, NumberFormatInfo.InvariantInfo, out d)) { money = new SqlMoney(d); } else { money = new SqlMoney(Decimal.Parse(s, NumberStyles.Currency, NumberFormatInfo.CurrentInfo)); } return money; } // Unary operators ///[To be supplied.] ////// public static SqlMoney operator -(SqlMoney x) { if (x.IsNull) return Null; if (x.m_value == MinLong) throw new OverflowException(SQLResource.ArithOverflowMessage); return new SqlMoney(-x.m_value, 0); } // Binary operators // Arithmetic operators ///[To be supplied.] ////// public static SqlMoney operator +(SqlMoney x, SqlMoney y) { try { return(x.IsNull || y.IsNull) ? Null : new SqlMoney(checked(x.m_value + y.m_value), 0); } catch (OverflowException) { throw new OverflowException(SQLResource.ArithOverflowMessage); } } ///[To be supplied.] ////// public static SqlMoney operator -(SqlMoney x, SqlMoney y) { try { return(x.IsNull || y.IsNull) ? Null : new SqlMoney(checked(x.m_value - y.m_value), 0); } catch (OverflowException) { throw new OverflowException(SQLResource.ArithOverflowMessage); } } ///[To be supplied.] ////// public static SqlMoney operator *(SqlMoney x, SqlMoney y) { return (x.IsNull || y.IsNull) ? Null : new SqlMoney(Decimal.Multiply(x.ToDecimal(), y.ToDecimal())); } ///[To be supplied.] ////// public static SqlMoney operator /(SqlMoney x, SqlMoney y) { return (x.IsNull || y.IsNull) ? Null : new SqlMoney(Decimal.Divide(x.ToDecimal(), y.ToDecimal())); } // Implicit conversions // Implicit conversion from SqlBoolean to SqlMoney ///[To be supplied.] ////// public static explicit operator SqlMoney(SqlBoolean x) { return x.IsNull ? Null : new SqlMoney((int)x.ByteValue); } // Implicit conversion from SqlByte to SqlMoney ///[To be supplied.] ////// public static implicit operator SqlMoney(SqlByte x) { return x.IsNull ? Null : new SqlMoney((int)x.Value); } // Implicit conversion from SqlInt16 to SqlMoney ///[To be supplied.] ////// public static implicit operator SqlMoney(SqlInt16 x) { return x.IsNull ? Null : new SqlMoney((int)x.Value); } // Implicit conversion from SqlInt32 to SqlMoney ///[To be supplied.] ////// public static implicit operator SqlMoney(SqlInt32 x) { return x.IsNull ? Null : new SqlMoney(x.Value); } // Implicit conversion from SqlInt64 to SqlMoney ///[To be supplied.] ////// public static implicit operator SqlMoney(SqlInt64 x) { return x.IsNull ? Null : new SqlMoney(x.Value); } // Explicit conversions // Explicit conversion from SqlSingle to SqlMoney ///[To be supplied.] ////// public static explicit operator SqlMoney(SqlSingle x) { return x.IsNull ? Null : new SqlMoney((double)x.Value); } // Explicit conversion from SqlDouble to SqlMoney ///[To be supplied.] ////// public static explicit operator SqlMoney(SqlDouble x) { return x.IsNull ? Null : new SqlMoney(x.Value); } // Explicit conversion from SqlDecimal to SqlMoney ///[To be supplied.] ////// public static explicit operator SqlMoney(SqlDecimal x) { return x.IsNull ? SqlMoney.Null : new SqlMoney(x.Value); } // Explicit conversion from SqlString to SqlMoney // Throws FormatException or OverflowException if necessary. ///[To be supplied.] ////// public static explicit operator SqlMoney(SqlString x) { return x.IsNull ? Null : new SqlMoney(Decimal.Parse(x.Value,NumberStyles.Currency,null)); } // Builtin functions // Overloading comparison operators ///[To be supplied.] ////// public static SqlBoolean operator==(SqlMoney x, SqlMoney y) { return(x.IsNull || y.IsNull) ? SqlBoolean.Null : new SqlBoolean(x.m_value == y.m_value); } ///[To be supplied.] ////// public static SqlBoolean operator!=(SqlMoney x, SqlMoney y) { return ! (x == y); } ///[To be supplied.] ////// public static SqlBoolean operator<(SqlMoney x, SqlMoney y) { return(x.IsNull || y.IsNull) ? SqlBoolean.Null : new SqlBoolean(x.m_value < y.m_value); } ///[To be supplied.] ////// public static SqlBoolean operator>(SqlMoney x, SqlMoney y) { return(x.IsNull || y.IsNull) ? SqlBoolean.Null : new SqlBoolean(x.m_value > y.m_value); } ///[To be supplied.] ////// public static SqlBoolean operator<=(SqlMoney x, SqlMoney y) { return(x.IsNull || y.IsNull) ? SqlBoolean.Null : new SqlBoolean(x.m_value <= y.m_value); } ///[To be supplied.] ////// public static SqlBoolean operator>=(SqlMoney x, SqlMoney y) { return(x.IsNull || y.IsNull) ? SqlBoolean.Null : new SqlBoolean(x.m_value >= y.m_value); } //-------------------------------------------------- // Alternative methods for overloaded operators //-------------------------------------------------- // Alternative method for operator + public static SqlMoney Add(SqlMoney x, SqlMoney y) { return x + y; } // Alternative method for operator - public static SqlMoney Subtract(SqlMoney x, SqlMoney y) { return x - y; } // Alternative method for operator * public static SqlMoney Multiply(SqlMoney x, SqlMoney y) { return x * y; } // Alternative method for operator / public static SqlMoney Divide(SqlMoney x, SqlMoney y) { return x / y; } // Alternative method for operator == public static SqlBoolean Equals(SqlMoney x, SqlMoney y) { return (x == y); } // Alternative method for operator != public static SqlBoolean NotEquals(SqlMoney x, SqlMoney y) { return (x != y); } // Alternative method for operator < public static SqlBoolean LessThan(SqlMoney x, SqlMoney y) { return (x < y); } // Alternative method for operator > public static SqlBoolean GreaterThan(SqlMoney x, SqlMoney y) { return (x > y); } // Alternative method for operator <= public static SqlBoolean LessThanOrEqual(SqlMoney x, SqlMoney y) { return (x <= y); } // Alternative method for operator >= public static SqlBoolean GreaterThanOrEqual(SqlMoney x, SqlMoney y) { return (x >= y); } // Alternative method for conversions. public SqlBoolean ToSqlBoolean() { return (SqlBoolean)this; } public SqlByte ToSqlByte() { return (SqlByte)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 SqlDecimal ToSqlDecimal() { return (SqlDecimal)this; } public SqlSingle ToSqlSingle() { return (SqlSingle)this; } public SqlString ToSqlString() { return (SqlString)this; } // IComparable // Compares this object to another object, returning an integer that // indicates the relationship. // Returns a value less than zero if this < object, zero if this = object, // or a value greater than zero if this > object. // null is considered to be less than any instance. // If object is not of same type, this method throws an ArgumentException. ///[To be supplied.] ////// public int CompareTo(Object value) { if (value is SqlMoney) { SqlMoney i = (SqlMoney)value; return CompareTo(i); } throw ADP.WrongType(value.GetType(), typeof(SqlMoney)); } public int CompareTo(SqlMoney value) { // If both Null, consider them equal. // Otherwise, Null is less than anything. if (IsNull) return value.IsNull ? 0 : -1; else if (value.IsNull) return 1; if (this < value) return -1; if (this > value) return 1; return 0; } // Compares this instance with a specified object ///[To be supplied.] ////// public override bool Equals(Object value) { if (!(value is SqlMoney)) { return false; } SqlMoney i = (SqlMoney)value; if (i.IsNull || IsNull) return (i.IsNull && IsNull); else return (this == i).Value; } // For hashing purpose ///[To be supplied.] ////// public override int GetHashCode() { // Don't use Value property, because Value will convert to Decimal, which is not necessary. return IsNull ? 0 : m_value.GetHashCode(); } ///[To be supplied.] ////// XmlSchema IXmlSerializable.GetSchema() { return null; } ///[To be supplied.] ////// void IXmlSerializable.ReadXml(XmlReader reader) { string isNull = reader.GetAttribute("nil", XmlSchema.InstanceNamespace); if (isNull != null && XmlConvert.ToBoolean(isNull)) { this.m_fNotNull = false; } else { SqlMoney money = new SqlMoney(XmlConvert.ToDecimal(reader.ReadElementString())); this.m_fNotNull = money.m_fNotNull; this.m_value = money.m_value; } } ///[To be supplied.] ////// void IXmlSerializable.WriteXml(XmlWriter writer) { if (IsNull) { writer.WriteAttributeString("xsi", "nil", XmlSchema.InstanceNamespace, "true"); } else { writer.WriteString( XmlConvert.ToString(ToDecimal()) ); } } ///[To be supplied.] ////// public static XmlQualifiedName GetXsdType(XmlSchemaSet schemaSet) { return new XmlQualifiedName("decimal", XmlSchema.Namespace); } ///[To be supplied.] ////// public static readonly SqlMoney Null = new SqlMoney(true); ////// Represents a null value that can be assigned to /// the ///property of an instance of /// the class. /// /// public static readonly SqlMoney Zero = new SqlMoney(0); ////// Represents the zero value that can be assigned to the ///property of an instance of /// the class. /// /// public static readonly SqlMoney MinValue = new SqlMoney(unchecked((long)0x8000000000000000L), 0); ////// Represents the minimum value that can be assigned /// to ///property of an instance of /// the /// class. /// /// public static readonly SqlMoney MaxValue = new SqlMoney(0x7FFFFFFFFFFFFFFFL, 0); } // SqlMoney } // namespace System.Data.SqlTypes // File provided for Reference Use Only by Microsoft Corporation (c) 2007. // Copyright (c) Microsoft Corporation. All rights reserved./// Represents the maximum value that can be assigned to /// the ///property of an instance of /// the /// class. ///
Link Menu
This book is available now!
Buy at Amazon US or
Buy at Amazon UK
- AsyncStreamReader.cs
- HeaderCollection.cs
- TcpHostedTransportConfiguration.cs
- BindingCompleteEventArgs.cs
- MsmqBindingFilter.cs
- ItemsControl.cs
- UpdatePanelControlTrigger.cs
- DataServiceExpressionVisitor.cs
- GeneralTransform3DCollection.cs
- Dictionary.cs
- RecordManager.cs
- AlignmentXValidation.cs
- ClientTarget.cs
- RuntimeArgumentHandle.cs
- EventItfInfo.cs
- SafeRegistryHandle.cs
- SamlAction.cs
- GroupBox.cs
- VirtualizedContainerService.cs
- TargetParameterCountException.cs
- connectionpool.cs
- ButtonColumn.cs
- DataGridViewDataConnection.cs
- TrackingServices.cs
- QilTernary.cs
- SqlRowUpdatedEvent.cs
- HierarchicalDataTemplate.cs
- Validator.cs
- Item.cs
- ConfigurationLocation.cs
- DisplayNameAttribute.cs
- ConstructorArgumentAttribute.cs
- EventTask.cs
- DefaultBinder.cs
- GlyphManager.cs
- Stylus.cs
- AudioFormatConverter.cs
- RangeExpression.cs
- MultiViewDesigner.cs
- DefaultAutoFieldGenerator.cs
- CodeEventReferenceExpression.cs
- counter.cs
- JpegBitmapEncoder.cs
- TransformerInfoCollection.cs
- StreamResourceInfo.cs
- View.cs
- Visual3DCollection.cs
- XomlSerializationHelpers.cs
- CollectionsUtil.cs
- BooleanToVisibilityConverter.cs
- RoutedEventArgs.cs
- HttpCapabilitiesSectionHandler.cs
- ActivityMarkupSerializationProvider.cs
- XdrBuilder.cs
- HyperlinkAutomationPeer.cs
- SortDescription.cs
- SortKey.cs
- ShapingWorkspace.cs
- ManagedCodeMarkers.cs
- PeerNameRegistration.cs
- InternalBufferOverflowException.cs
- ConnectionOrientedTransportBindingElement.cs
- RoutedUICommand.cs
- BindingUtils.cs
- TemplateLookupAction.cs
- TreeViewImageKeyConverter.cs
- TreeViewCancelEvent.cs
- SqlNode.cs
- SafeRightsManagementHandle.cs
- SvcMapFileLoader.cs
- PauseStoryboard.cs
- ISFTagAndGuidCache.cs
- DbCommandTree.cs
- XamlSerializationHelper.cs
- PassportIdentity.cs
- AnnotationMap.cs
- ToolStripPanelDesigner.cs
- LoadMessageLogger.cs
- Codec.cs
- ExpandSegmentCollection.cs
- ApplicationCommands.cs
- QueryContext.cs
- ControlType.cs
- SQLConvert.cs
- OdbcTransaction.cs
- ObjectDataSourceMethodEventArgs.cs
- DesignTableCollection.cs
- GradientBrush.cs
- EtwTrackingBehavior.cs
- TypeSystem.cs
- DelegatedStream.cs
- GcHandle.cs
- HtmlInputSubmit.cs
- ExtendedProtectionPolicyElement.cs
- QueryProcessor.cs
- ThaiBuddhistCalendar.cs
- Metadata.cs
- PartialList.cs
- ZeroOpNode.cs
- Control.cs