1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889 |
- using ProjectBase.Data.BaseDAL.BaseDatabase;
- using ProjectBase.Util;
- using SIASUN.Autopilot.DAL.IDALSQL;
- using SIASUN.Autopilot.Model;
- using System;
- using System.Collections;
- using System.Collections.Generic;
- using System.Data;
- using System.Text;
- namespace SIASUN.Autopilot.DAL.DALSQL
- {
- public class DalWhite : BaseDALSQL<MoWhite>, IDalWhite
- {
- #region 对象实例及构造函数
- public static DalWhite Instance
- {
- get
- {
- return new DalWhite();
- }
- }
- public DalWhite() : base("black", new string[] { "black_id" })
- {
- this.sortField = "black_id";
- this.isDescending = false;
- }
- #endregion
- /// <summary>
- /// 将DataReader的属性值转化为实体类的属性值,返回实体类
- /// </summary>
- /// <param name="dr">有效的DataReader对象</param>
- /// <returns>实体类对象</returns>
- protected override MoWhite DataReaderToEntity(IDataReader dataReader)
- {
- MoWhite info = new MoWhite();
- SmartDataReader reader = new SmartDataReader(dataReader);
- info.ID = reader.GetInt64("black_id");
- info.Name = reader.GetString("black_name");
- info.UserAccount = reader.GetString("black_UserAccount");
- info.UserName = reader.GetString("black_UserName");
- info.Type = reader.GetInt32("black_type");
- info.Forbid = Convert.ToBoolean(reader.GetInt32("black_forbid"));
- info.IPStart = reader.GetString("black_ipStart");
- info.IPEnd = reader.GetString("black_ipEnd");
- info.Note = reader.GetString("black_note");
- info.CreatorAccount = reader.GetString("black_creatorAccount");
- info.CreatorName = reader.GetString("black_creatorName");
- info.CreateTime = Convert.ToDateTime(reader.GetString("black_createTime"));
- info.EditorAccount = reader.GetString("black_editorAccount");
- info.EditorName = reader.GetString("black_editorName");
- info.EditTime = Convert.ToDateTime(reader.GetString("black_editorTime"));
- return info;
- }
- /// <summary>
- /// 将实体对象的属性值转化为Hashtable对应的键值
- /// </summary>
- /// <param name="obj">有效的实体对象</param>
- /// <returns>包含键值映射的Hashtable</returns>
- protected override Hashtable GetHashByEntity(MoWhite obj)
- {
- MoWhite info = obj as MoWhite;
- Hashtable hash = new Hashtable();
- //hash.Add("logIn_id", info.ID);
- hash.Add("black_name", info.Name);
- hash.Add("black_UserAccount", info.UserAccount);
- hash.Add("black_UserName", info.UserName);
- hash.Add("black_type", info.Type);
- hash.Add("black_forbid", info.Forbid);
- hash.Add("black_ipStart", info.IPStart);
- hash.Add("black_ipEnd", info.IPEnd);
- hash.Add("black_note", info.Note);
- hash.Add("black_creatorAccount", info.CreatorAccount);
- hash.Add("black_creatorName", info.CreatorName);
- hash.Add("black_createTime", info.CreateTime);
- hash.Add("black_editorAccount", info.EditorAccount);
- hash.Add("black_editorName", info.EditorName);
- hash.Add("black_editorTime", info.EditTime);
- return hash;
- }
- }
- }
|