CS_GIS/Data/Data.ADO/AdoDataReader.cs

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.OleDb;

using Tofly.Data.General;
using System.Data.Common;

namespace Tofly.Data.ADO
{
    /// <summary>
    /// 定义Ado的oledb类型数据读取对象
    /// </summary>
    public class AdoDataReader : IDataReader
    {
        private DbDataReader pReader;
        private IRow pRow;
        private IWorkspace workspace = null;
        public AdoDataReader(DbDataReader pReader,IWorkspace workspace)
        {
            if (pReader == null)
                throw new Exception();

            if (workspace == null)
                throw new Exception();

            this.pReader = pReader;
            this.workspace = workspace;
        }

        /// <summary>
        /// 获取当前行
        /// </summary>
        public IRow Row
        {
            get 
            {
                return pRow; 
            }
        }

        /// <summary>
        /// 将读取器前进到结果集中的下一个记录
        /// </summary>
        /// <returns></returns>
        public bool Read()
        {
            if (pReader.Read())
            {
                pRow = new RowBase();
                Dictionary<string, object> oValue = new Dictionary<string, object>();
                Type type;
                object temp = null;
                for (int i = 0; i < pReader.FieldCount; i++)
                {
                    type = pReader.GetFieldType(i);
                    string sss = pReader.GetName(i);
                    if (type == typeof(System.DateTime) && workspace.WorkspaceType == WorkspaceType.SqlLite)
                    {
                        temp = null;
                        if (!pReader.IsDBNull(i))
                        {
                            temp = pReader.GetString(i);
                            DateTime time;
                            bool success = DateTime.TryParse(temp.ToString(), out time);
                            if (success)
                                temp = time;
                            else
                                temp = null;
                        }

                        oValue.Add(pReader.GetName(i).ToUpper().Trim(), temp);
                    }
                    else
                        oValue.Add(pReader.GetName(i).ToUpper().Trim(), pReader.GetValue(i));
                }
                pRow.OriginalObjects = oValue;
                return true;
            }
            else
            {
                return false;
            }
        }

        #region IDisposable

        private bool disposed = false;

        public void Dispose()
        {
            Dispose(true);
            GC.SuppressFinalize(this);
        }

        private void Dispose(bool disposing)
        {
            if (!this.disposed)
            {
                pReader.Dispose();
                pReader = null;
            }
            disposed = true;
        }

        ~AdoDataReader()
        {
            Dispose(false);
        }
        #endregion
    }
}