MESProductionWeb/AntORM/Ant.ORM/Table/MDataTable.cs

using System;
using System.Collections;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Ant.ORM.SQL;
using System.Reflection;
using Ant.ORM.Tool;


namespace Ant.ORM.Table
{
    /// <summary>
    /// 表格
    /// </summary>
    public class MDataTable : IDataReader, IEnumerable,System.ComponentModel.IListSource
    {
        /// <summary>
        /// 从DataReader隐式转换成MDataTable
        /// </summary>
        public static implicit operator MDataTable(System.Data.Common.DbDataReader sdr)
        {
            MDataTable mTable = new MDataTable("default");
            if (sdr != null)
            {
                CellStruct mStruct;
                MDataRow mRecord = new MDataRow();
                int columnState = 0;
                while (sdr.Read())
                {
                    for (int i = 0; i < sdr.FieldCount; i++)
                    {
                        if (columnState == 0)
                        {
                            mStruct = new CellStruct(sdr.GetName(i), DataType.GetSqlType(sdr.GetFieldType(i)), false, true, -1, ParameterDirection.InputOutput);
                            MDataCell mdc = new MDataCell(ref mStruct, sdr.GetValue(i));
                            mRecord.Add(mdc);
                            mTable.Columns.Add(mStruct);
                        }
                        if (sdr[mRecord[i]._CellStruct.ColumnName] == null || sdr[mRecord[i]._CellStruct.ColumnName].ToString() == string.Empty)
                        {
                            mRecord[i].Value = DBNull.Value;
                        }
                        else
                        {
                            mRecord[i].Value = sdr[mRecord[i]._CellStruct.ColumnName]; //sdr.GetValue(i);
                        }
                    }
                    columnState++;
                    mTable.Rows.Add(mRecord.Clone());
                }
                mRecord.Clear();
                mRecord = null;
                sdr.Close();
                sdr.Dispose();
                sdr = null;
            }
            return mTable;

        }

        #region 属性
        private List<MDataRow> _Mdr;
        public List<MDataRow> Rows
        {
            get
            {
                return _Mdr;
            }
        }
        public MDataTable()
        {
            Init("default");
        }
        public MDataTable(string tableName)
        {
            Init(tableName);
        }
        private void Init(string tableName)
        {
            _Mdr = new List<MDataRow>();
            _TableName = tableName;
            if (_Columns == null)
            {
                _Columns = new MDataColumn(this);
            }
        }
        private string _TableName = string.Empty;
        public string TableName
        {
            get
            {
                return _TableName;
            }
            set
            {
                _TableName = value;
            }
        }

        private MDataColumn _Columns;
        public MDataColumn Columns
        {
            get
            {

                //if (_Mdr != null && _Mdr.Count > 0)
                //{
                //    _Columns = _Mdr[0].Columns;
                //}
                return _Columns;
            }
        }
        /// <summary>
        /// 新增一列
        /// </summary>
        /// <returns></returns>
        public MDataRow NewRow()
        {
            MDataRow mdr = new MDataRow();
            mdr.TableName = _TableName;
            CellStruct mdcStruct = null;
            for (int i = 0; i < _Columns.Count; i++)
            {
                mdcStruct = _Columns[i];
                mdr.Add(new MDataCell(ref mdcStruct));
            }
            return mdr;
        }
        #endregion

        #region 方法
        internal void LoadRow(MDataRow row)
        {
            if (this.Columns.Count == 0 && row != null && row.Count > 0)
            {
                foreach (MDataCell cell in row)
                {
                    this.Columns.Add(cell._CellStruct);
                }
                _TableName = row.TableName;
                if (row[0].Value != null && row[0].Value != DBNull.Value)
                {
                    _Mdr.Add(row);
                }
            }
        }
        /// <summary>
        /// 转换成DataTable
        /// </summary>
        public DataTable ToDataTable()
        {
            DataTable dt = new DataTable(_TableName);
            if (Columns != null && Columns.Count > 0)
            {
                foreach (CellStruct item in Columns)
                {
                    dt.Columns.Add(item.ColumnName,item.ValueType);
                }
                foreach (MDataRow row in Rows)
                {
                    DataRow dr = dt.NewRow();
                    for (int i = 0; i < Columns.Count; i++)
                    {
                        dr[i] = row[i].Value;
                    }
                    dt.Rows.Add(dr);
                }
            }
            return dt;
        }
        /// <summary>
        /// 从Json字符串反加载成MDataTable
        /// </summary>
        public static MDataTable LoadFromJson(string json)
        {
            JsonHelper helper = new JsonHelper();
            return helper.Load(json);
        }
        /// <summary>
        /// 输出Json字符串
        /// </summary>
        public string ToJson()
        {
            JsonHelper helper = new JsonHelper();
            helper.Fill(this);
            return helper.ToString();
        }
        /// <summary>
        /// 将数据表绑定到列表控件
        /// </summary>
        /// <param name="control">列表控件[包括Repeater/DataList/GridView/DataGrid等]</param>
        public void Bind(object control)
        {
            MBindUI.Bind(control, this);
        }

        /// <summary>
        /// 转实体列表
        /// </summary>
        /// <param name="useEmit">是否使用Emit方式转换[数据越多[大于500条]性能越高],不写默认自适应判断</param>
        /// <typeparam name="T"></typeparam>
        /// <returns></returns>
        public List<T> ToList<T>(params bool[] useEmit)
        {
            List<T> list = new List<T>();
            if (Rows != null && Rows.Count > 0)
            {
                if ((Rows.Count > 500 && useEmit.Length == 0) || (useEmit.Length > 0 && useEmit[0]))
                {
                    FastToT<T>.EmitHandle emit = FastToT<T>.Create(this);
                    foreach (MDataRow row in Rows)
                    {
                        list.Add(emit(row));
                    }
                }
                else
                {
                    foreach (MDataRow row in Rows)
                    {
                        T obj = (T)Activator.CreateInstance(typeof(T));
                        PropertyInfo[] pis = obj.GetType().GetProperties();
                        MDataCell cell = null;
                        for (int i = 0; i < pis.Length; i++)
                        {
                            cell = row[pis[i].Name];
                            if (cell == null || cell._CellValue.IsNull)
                            {
                                continue;
                            }
                            pis[i].SetValue(obj, cell.Value, null);
                        }
                        list.Add(obj);
                    }
                }
            }
            return list;
        }

        #endregion

        private int _Ptr = 0;
        #region IDataReader 成员

        public void Close()
        {
            _Mdr.Clear();
        }

        public int Depth
        {
            get
            {
                if (_Mdr != null)
                {
                    return _Mdr.Count;
                }
                return 0;
            }
        }

        public DataTable GetSchemaTable()
        {
            return null;
        }

        public bool IsClosed
        {
            get
            {
                return true;
            }
        }

        public bool NextResult()
        {
            if (_Ptr < _Mdr.Count - 1)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        public bool Read()
        {
            if (_Ptr < _Mdr.Count)
            {
                _Ptr++;
                return true;
            }
            else
            {
		        _Ptr = 0;
                return false;
            }
        }

        public int RecordsAffected
        {
            get
            {
                return -1;
            }
        }

        #endregion

        #region IDisposable 成员

        public void Dispose()
        {
            _Mdr.Clear();
            _Mdr = null;
        }

        #endregion

        #region IDataRecord 成员

        public int FieldCount
        {
            get
            {
                if (this.Columns != null)
                {
                    return this.Columns.Count;
                }
                return 0;
            }
        }

        public bool GetBoolean(int i)
        {
            return (bool)_Mdr[_Ptr][i].Value;
        }

        public byte GetByte(int i)
        {
            return (byte)_Mdr[_Ptr][i].Value;
        }

        public long GetBytes(int i, long fieldOffset, byte[] buffer, int bufferoffset, int length)
        {
            throw new Exception(AppConst.Global_NotImplemented);
        }

        public char GetChar(int i)
        {
            return (char)_Mdr[_Ptr][i].Value;
        }

        public long GetChars(int i, long fieldoffset, char[] buffer, int bufferoffset, int length)
        {
            throw new Exception(AppConst.Global_NotImplemented);
        }

        public IDataReader GetData(int i)
        {
            return this;
        }

        public string GetDataTypeName(int i)
        {
            return "";
            //return _Mdr[_Ptr][i]._CellValue.Value.GetType().Name;
            //return DataType.GetDbType(_Mdr[_Ptr][i]._CellStruct.SqlType.ToString()).ToString();
        }

        public DateTime GetDateTime(int i)
        {
            return (DateTime)_Mdr[_Ptr][i].Value;
        }

        public decimal GetDecimal(int i)
        {
            return (decimal)_Mdr[_Ptr][i].Value;
        }

        public double GetDouble(int i)
        {
            return (double)_Mdr[_Ptr][i].Value;
        }

        public Type GetFieldType(int i)
        {
            return _Columns[i].ValueType;
            //return _Mdr[_Ptr][i]._CellStruct.ValueType;
        }

        public float GetFloat(int i)
        {
            return (float)_Mdr[_Ptr][i].Value;
        }

        public Guid GetGuid(int i)
        {
            return (Guid)_Mdr[_Ptr][i].Value;
        }

        public short GetInt16(int i)
        {
            return (short)_Mdr[_Ptr][i].Value;
        }

        public int GetInt32(int i)
        {
            return (int)_Mdr[_Ptr][i].Value;
        }

        public long GetInt64(int i)
        {
            return (long)_Mdr[_Ptr][i].Value;
        }

        public string GetName(int i)
        {
            return _Columns[i].ColumnName;
            //return _Mdr[_Ptr][i]._CellStruct.ColumnName;
        }

        public int GetOrdinal(string name)
        {
            return _Columns.GetIndex(name);
        }

        public string GetString(int i)
        {
            return Convert.ToString(_Mdr[_Ptr][i].Value);
        }

        public object GetValue(int i)
        {
           return _Mdr[_Ptr][i].Value;
        }

        public int GetValues(object[] values)
        {
            for (int i = 0; i < values.Length; i++)
            {
               values[i] = _Mdr[_Ptr - 1][i].Value;
            }
            return values.Length;
        }

        public bool IsDBNull(int i)
        {
            return _Mdr[_Ptr][i]._CellValue.IsNull;
        }

        public object this[string name]
        {
            get
            {
                return null;
            }
        }

        public object this[int i]
        {
            get
            {
                return _Mdr[i];
            }
        }

        #endregion

        #region IEnumerable 成员

        public IEnumerator GetEnumerator()
        {
            return new System.Data.Common.DbEnumerator(this);
        }

        #endregion

        #region IListSource 成员

        public bool ContainsListCollection
        {
            get
            {
                return true;
            }
        }

        public IList GetList()
        {
            return Rows;
        }

        #endregion
    }
    
}