DalMtocData.cs 1.9 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677
  1. using ProjectBase.Data.BaseDAL.BaseDatabase;
  2. using ProjectBase.Util;
  3. using SIMDP.DAL.IDALSQL;
  4. using SIMDP.Model;
  5. using System;
  6. using System.Collections;
  7. using System.Data;
  8. namespace SIMDP.DAL.DALSQL
  9. {
  10. /// <summary>
  11. /// MTOC_Data
  12. /// </summary>
  13. public class DalMtocData : BaseDALSQL<MoMtocData>, IDalMtocData
  14. {
  15. #region 对象实例及构造函数
  16. public static DalMtocData Instance
  17. {
  18. get
  19. {
  20. return new DalMtocData();
  21. }
  22. }
  23. public DalMtocData() : base("MTOC_Data","Id")
  24. {
  25. this.sortField = "Id";
  26. this.isDescending = false;
  27. }
  28. #endregion
  29. /// <summary>
  30. /// 将DataReader的属性值转化为实体类的属性值,返回实体类
  31. /// </summary>
  32. /// <param name="dr">有效的DataReader对象</param>
  33. /// <returns>实体类对象</returns>
  34. protected override MoMtocData DataReaderToEntity(IDataReader dataReader)
  35. {
  36. MoMtocData info = new MoMtocData();
  37. SmartDataReader reader = new SmartDataReader(dataReader);
  38. info.Id = reader.GetInt64("Id");
  39. info.Vin = reader.GetString("VIN");
  40. info.Model = reader.GetInt32("Model");
  41. info.Color = reader.GetInt32("Color");
  42. info.Initial_Time = reader.GetDateTime("Initial_Time");
  43. info.Fetch_Time = reader.GetDateTime("Fetch_Time");
  44. info.Remark = reader.GetString("Remark");
  45. return info;
  46. }
  47. /// <summary>
  48. /// 将实体对象的属性值转化为Hashtable对应的键值
  49. /// </summary>
  50. /// <param name="obj">有效的实体对象</param>
  51. /// <returns>包含键值映射的Hashtable</returns>
  52. protected override Hashtable GetHashByEntity(MoMtocData obj)
  53. {
  54. MoMtocData info = obj as MoMtocData;
  55. Hashtable hash = new Hashtable();
  56. hash.Add("VIN", info.Vin);
  57. hash.Add("Model", info.Model);
  58. hash.Add("Color", info.Color);
  59. hash.Add("Initial_Time", info.Initial_Time);
  60. hash.Add("Fetch_Time", info.Fetch_Time);
  61. hash.Add("Remark", info.Remark);
  62. return hash;
  63. }
  64. }
  65. }