| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244 |
- //------------------------------------------------------------------------------
- // <copyright file="DateTimeStorage.cs" company="Microsoft">
- // Copyright (c) Microsoft Corporation. All rights reserved.
- // </copyright>
- // <owner current="true" primary="true">Microsoft</owner>
- // <owner current="true" primary="false">Microsoft</owner>
- // <owner current="false" primary="false">Microsoft</owner>
- //------------------------------------------------------------------------------
- namespace System.Data.Common {
- using System;
- using System.Xml;
- using System.Data.SqlTypes;
- using System.Collections;
- internal sealed class DateTimeStorage : DataStorage {
- private static readonly DateTime defaultValue = DateTime.MinValue;
- private DateTime[] values;
- internal DateTimeStorage(DataColumn column)
- : base(column, typeof(DateTime), defaultValue, StorageType.DateTime) {
- }
- override public Object Aggregate(int[] records, AggregateType kind) {
- bool hasData = false;
- try {
- switch (kind) {
- case AggregateType.Min:
- DateTime min = DateTime.MaxValue;
- for (int i = 0; i < records.Length; i++) {
- int record = records[i];
- if (HasValue(record)) {
- min=(DateTime.Compare(values[record],min) < 0) ? values[record] : min;
- hasData = true;
- }
- }
- if (hasData) {
- return min;
- }
- return NullValue;
- case AggregateType.Max:
- DateTime max = DateTime.MinValue;
- for (int i = 0; i < records.Length; i++) {
- int record = records[i];
- if (HasValue(record)) {
- max=(DateTime.Compare(values[record],max) >= 0) ? values[record] : max;
- hasData = true;
- }
- }
- if (hasData) {
- return max;
- }
- return NullValue;
- case AggregateType.First:
- if (records.Length > 0) {
- return values[records[0]];
- }
- return null;
- case AggregateType.Count:
- int count = 0;
- for (int i = 0; i < records.Length; i++) {
- if (HasValue(records[i])) {
- count++;
- }
- }
- return count;
- }
- }
- catch (OverflowException) {
- throw ExprException.Overflow(typeof(DateTime));
- }
- throw ExceptionBuilder.AggregateException(kind, DataType);
- }
- override public int Compare(int recordNo1, int recordNo2) {
- DateTime valueNo1 = values[recordNo1];
- DateTime valueNo2 = values[recordNo2];
-
- if (valueNo1 == defaultValue || valueNo2 == defaultValue) {
- int bitCheck = CompareBits(recordNo1, recordNo2);
- if (0 != bitCheck) {
- return bitCheck;
- }
- }
- return DateTime.Compare(valueNo1, valueNo2);
- }
- public override int CompareValueTo(int recordNo, object value) {
- System.Diagnostics.Debug.Assert(0 <= recordNo, "Invalid record");
- System.Diagnostics.Debug.Assert(null != value, "null value");
- if (NullValue == value) {
- return (HasValue(recordNo) ? 1 : 0);
- }
- DateTime valueNo1 = values[recordNo];
- if ((defaultValue == valueNo1) && !HasValue(recordNo)) {
- return -1;
- }
- return DateTime.Compare(valueNo1, (DateTime)value);
- }
- public override object ConvertValue(object value) {
- if (NullValue != value) {
- if (null != value) {
- value = ((IConvertible)value).ToDateTime(FormatProvider);
- }
- else {
- value = NullValue;
- }
- }
- return value;
- }
- override public void Copy(int recordNo1, int recordNo2) {
- CopyBits(recordNo1, recordNo2);
- values[recordNo2] = values[recordNo1];
- }
- override public Object Get(int record) {
- // SQLBU 408233: two equal DateTime with different .Kind are equal
- DateTime value = values[record];
- if ((value != defaultValue) || HasValue(record)) {
- return value;
- }
- return NullValue;
- }
- override public void Set(int record, Object value) {
- System.Diagnostics.Debug.Assert(null != value, "null value");
- if (NullValue == value) {
- values[record] = defaultValue;
- SetNullBit(record, true);
- }
- else {
- DateTime retVal;
- DateTime tmpValue = ((IConvertible)value).ToDateTime(FormatProvider);
- switch (DateTimeMode) {
- case DataSetDateTime.Utc:
- if (tmpValue.Kind == DateTimeKind.Utc) {
- retVal = tmpValue;
- }
- else if (tmpValue.Kind == DateTimeKind.Local) {
- retVal = tmpValue.ToUniversalTime();
- }
- else {
- retVal = DateTime.SpecifyKind(tmpValue, DateTimeKind.Utc);
- }
- break;
- case DataSetDateTime.Local:
- if (tmpValue.Kind == DateTimeKind.Local) {
- retVal = tmpValue;
- }
- else if (tmpValue.Kind == DateTimeKind.Utc) {
- retVal = tmpValue.ToLocalTime();
- }
- else {
- retVal = DateTime.SpecifyKind(tmpValue, DateTimeKind.Local);
- }
- break;
- case DataSetDateTime.Unspecified:
- case DataSetDateTime.UnspecifiedLocal:
- retVal = DateTime.SpecifyKind(tmpValue, DateTimeKind.Unspecified);
- break;
- default:
- throw ExceptionBuilder.InvalidDateTimeMode(DateTimeMode);
- }
- values[record] = retVal;
- SetNullBit(record, false);
- }
- }
- override public void SetCapacity(int capacity) {
- DateTime[] newValues = new DateTime[capacity];
- if (null != values) {
- Array.Copy(values, 0, newValues, 0, Math.Min(capacity, values.Length));
- }
- values = newValues;
- base.SetCapacity(capacity);
- }
- override public object ConvertXmlToObject(string s) {
- object retValue;
- if (DateTimeMode == DataSetDateTime.UnspecifiedLocal) {
- retValue = XmlConvert.ToDateTime(s, XmlDateTimeSerializationMode.Unspecified);
- }
- else {
- retValue = XmlConvert.ToDateTime(s, XmlDateTimeSerializationMode.RoundtripKind);
- }
- return retValue;
- }
- override public string ConvertObjectToXml(object value) {
- string retValue;
- if (DateTimeMode == DataSetDateTime.UnspecifiedLocal) {
- retValue = XmlConvert.ToString((DateTime)value, XmlDateTimeSerializationMode.Local);
- }
- else {
- retValue = XmlConvert.ToString((DateTime)value, XmlDateTimeSerializationMode.RoundtripKind);
- }
- return retValue;
- }
- override protected object GetEmptyStorage(int recordCount) {
- return new DateTime[recordCount];
- }
- override protected void CopyValue(int record, object store, BitArray nullbits, int storeIndex) {
- DateTime[] typedStore = (DateTime[]) store;
- bool isnull = !HasValue(record);
- if (isnull || ( 0 == (DateTimeMode & DataSetDateTime.Local))) {
- typedStore[storeIndex] = values[record]; // already universal time
- }
- else {
- typedStore[storeIndex] = values[record].ToUniversalTime();
- }
- nullbits.Set(storeIndex, isnull);
- }
- override protected void SetStorage(object store, BitArray nullbits) {
- values = (DateTime[]) store;
- SetNullStorage(nullbits);
- if (DateTimeMode == DataSetDateTime.UnspecifiedLocal) {
- for (int i = 0; i < values.Length; i++) {
- if (HasValue(i)) {
- values[i] = DateTime.SpecifyKind(values[i].ToLocalTime(), DateTimeKind.Unspecified); //Strip the kind for UnspecifiedLocal.
- }
- }
- }
- else if (DateTimeMode == DataSetDateTime.Local) {
- for (int i = 0; i < values.Length; i++) {
- if (HasValue(i)) {
- values[i] = values[i].ToLocalTime();
- }
- }
- }
- }
- }
- }
|