123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990 |
- 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.Linq;
- using System.Text;
- using System.Threading.Tasks;
- namespace SIASUN.Autopilot.DAL.DALSQL
- {
- /// <summary>
- /// 菜单管理
- /// </summary>
- public class DalMenuInfo : BaseDALSQL<MoMenuInfo>, IDalMenuInfo
- {
- #region 对象实例及构造函数
- public static DalMenuInfo Instance
- {
- get
- {
- return new DalMenuInfo();
- }
- }
- public DalMenuInfo() : base("menu", new string[] { "menu_sequence" })
- {
- this.sortField = "menu_sequence";
- this.isDescending = false;
- }
- #endregion
- /// <summary>
- /// 将DataReader的属性值转化为实体类的属性值,返回实体类
- /// </summary>
- /// <param name="dr">有效的DataReader对象</param>
- /// <returns>实体类对象</returns>
- protected override MoMenuInfo DataReaderToEntity(IDataReader dataReader)
- {
- MoMenuInfo info = new MoMenuInfo();
- SmartDataReader reader = new SmartDataReader(dataReader);
- info.ID = reader.GetString("menu_id");
- info.Name = reader.GetString("menu_name");
- info.PID = reader.GetString("menu_parent_id");
- info.Icon = reader.GetString("menu_icon");
- info.Seq = reader.GetString("menu_sequence");
- info.FunctionId = reader.GetString("menu_function_id");
- info.WinformType = reader.GetString("menu_winform_type");
- info.Url = reader.GetString("menu_url");
- info.WebIcon = reader.GetString("menu_webicon");
- info.Creator_ID = reader.GetString("menu_create_id");
- info.CreateTime = Convert.ToDateTime(reader.GetString("menu_create_time"));
- info.Deleted = Convert.ToBoolean(reader.GetInt32("menu_delete"));
- info.Visible = Convert.ToBoolean(reader.GetInt32("menu_visible"));
- return info;
- }
- /// <summary>
- /// 将实体对象的属性值转化为Hashtable对应的键值
- /// </summary>
- /// <param name="obj">有效的实体对象</param>
- /// <returns>包含键值映射的Hashtable</returns>
- protected override Hashtable GetHashByEntity(MoMenuInfo obj)
- {
- MoMenuInfo info = obj as MoMenuInfo;
- Hashtable hash = new Hashtable();
- hash.Add("menu_id", info.ID);
- hash.Add("menu_name", info.Name);
- hash.Add("menu_parent_id", info.PID);
- hash.Add("menu_icon", info.Icon);
- hash.Add("menu_sequence", info.Seq);
- hash.Add("menu_function_id", info.FunctionId);
- hash.Add("menu_winform_type", info.WinformType);
- hash.Add("menu_url", info.Url);
- hash.Add("menu_webicon", info.WebIcon);
- hash.Add("menu_create_id", info.Creator_ID);
- hash.Add("menu_create_time", info.CreateTime);
- hash.Add("menu_delete", info.Deleted);
- hash.Add("menu_visible", info.Visible);
- return hash;
- }
- }
- }
|