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
{
///
/// MTOC_Data
///
public class DalMtocData : BaseDALSQL, IDalMtocData
{
#region 对象实例及构造函数
public static DalMtocData Instance
{
get
{
return new DalMtocData();
}
}
public DalMtocData() : base("MTOC_Data","Id")
{
this.sortField = "Id";
this.isDescending = false;
}
#endregion
///
/// 将DataReader的属性值转化为实体类的属性值,返回实体类
///
/// 有效的DataReader对象
/// 实体类对象
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;
}
///
/// 将实体对象的属性值转化为Hashtable对应的键值
///
/// 有效的实体对象
/// 包含键值映射的Hashtable
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;
}
}
}