using ProjectBase.Data.BaseDAL.BaseDatabase;
using ProjectBase.Util;
using SIMDP.DAL.IDALSQL;
using SIMDP.Model;
using System;
using System.Collections;
using System.Data;

namespace SIMDP.DAL.DALSQL
{
    /// <summary>
    /// MTOC_Data
    /// </summary>
	public class DalMtocData : BaseDALSQL<MoMtocData>, IDalMtocData
	{
		#region 对象实例及构造函数

		public static DalMtocData Instance
		{
			get
			{
				return new DalMtocData();
			}
		}
		public DalMtocData() : base("MTOC_Data","Id")
		{
			this.sortField = "Id";
			this.isDescending = false;
		}

		#endregion

		/// <summary>
		/// 将DataReader的属性值转化为实体类的属性值，返回实体类
		/// </summary>
		/// <param name="dr">有效的DataReader对象</param>
		/// <returns>实体类对象</returns>
		protected override MoMtocData DataReaderToEntity(IDataReader dataReader)
		{
			MoMtocData info = new MoMtocData();
			SmartDataReader reader = new SmartDataReader(dataReader);
			
			info.Id = reader.GetInt64("Id");
			info.Vin = reader.GetString("VIN");
			info.Model = reader.GetInt32("Model");
			info.Color = reader.GetInt32("Color");
			info.Initial_Time = reader.GetDateTime("Initial_Time");
			info.Fetch_Time = reader.GetDateTime("Fetch_Time");
			info.Remark = reader.GetString("Remark");
			
			return info;
		}

		/// <summary>
		/// 将实体对象的属性值转化为Hashtable对应的键值
		/// </summary>
		/// <param name="obj">有效的实体对象</param>
		/// <returns>包含键值映射的Hashtable</returns>
        protected override Hashtable GetHashByEntity(MoMtocData obj)
		{
		    MoMtocData info = obj as MoMtocData;
			Hashtable hash = new Hashtable(); 
			
 			hash.Add("VIN", info.Vin);
 			hash.Add("Model", info.Model);
 			hash.Add("Color", info.Color);
 			hash.Add("Initial_Time", info.Initial_Time);
 			hash.Add("Fetch_Time", info.Fetch_Time);
 			hash.Add("Remark", info.Remark);
 				
			return hash;
		}

     

    }
}