学步园

浅谈C# WinForm中实现基于角色的权限菜单

作者：CodingMouse            日期：2008年12月14日

转载请注明文章来源：http://blog.csdn.net/CodingMouse/archive/2008/12/14/3515969.aspx

本博文完整源码已经上传，欢迎下载讨论：http://download.csdn.net/source/913308

基于角色的权限菜单功能的实现在有开发经验的程序员看来仅仅是小菜一碟，然而却让许多初学者苦不堪言。为此，我将我近期花了几天时间写的权限菜单写成文字贴上博客给初学者参考。由于自己也是一个正在努力学习的菜鸟，对问题的分析和见解必然不够透彻，还望过路的老师们多多批评为谢！

一、建立 SQL Server 数据库模型

 1、原始方案
 
  一共设立了五个实体模型：
 
  A、操作员（Operator）：存储系统登录用户的名称、密码、启用状态等信息。
  B、权限组（RightsGroup）：存储系统权限分组（即：权限角色）的名称等信息。
  C、权限关系（RightsRelation）：用于将A项和B项之间的多对多关系拆解成两个一对多关系。
  D、权限列表（RightsList）：存储系统菜单项（即：权限项）的标题、内部名称、权限状态等信息。
  E、权限组关系（RightGroupRelation）：用于将B项和D项之间的多对多关系拆解成两个一对多关系。
  
  通过上面的描述可以清楚看到，C项和E项仅仅是为了拆解多对多关系而设立，实体关系变得相对复杂了点。稍作考虑便知，既然是使用 C# WinForm + SQL Server 来完成这一功能，则可以考虑使用实体类来模拟数据库模型，并将实体类打包成泛型集合后存储到 SQL Server 数据库的 varBinary(max) 字段。这样便可以将原始方案的数据库模型缩减成三个实体模型，降低了关系的复杂程度。将原始方案稍作修改后即可得到如下改进方案。

 
 2、改进方案
  
  如上所述，改进后的方案仅包含如下三个实体模型：
  
  A、操作员（Operator）：存储系统登录用户的名称、密码、启用状态、权限集合等信息。
  B、权限组（RightsGroup）：存储系统权限分组（即：权限角色）的名称、权限集合等信息。
  C、权限关系（RightsRelation）：用于将A项和B项之间的多对多关系拆解成两个一对多关系。
  
  很容易看出，仅将原始方案的 E 项更改为 A项和 B 项的字段，即可将实体关系复杂度降低 40%。现在我们来看看改进方案的 SQL Server 数据库实现脚本代码：

-- 判断是否存在 操作员信息表（Operator），如果存在，则删除表 Operator<br /> if exists(Select * From SysObjects Where Name = 'Operator')<br /> Drop Table [Operator]<br /> Go </p> <p> -- 创建 操作员信息表（Operator）<br /> Create Table [Operator]<br /> (<br /> -- 主键列，自动增长 标识种子为 1<br /> [Id] int identity(1,1) Constraint [PK_OperatorId] Primary Key,</p> <p> -- 操作员姓名<br /> [OperatorName] nVarChar(50) Constraint [UQ_OperatorName] Unique(OperatorName) Not Null,</p> <p> -- 密码<br /> [Password] nVarChar(50) Constraint [CK_Password] Check(len([Password])>=6) Not Null,</p> <p> -- 操作员权限列表<br /> [RightsList] varBinary(max) Null,</p> <p> -- 用户当前状态<br /> [State] bit Constraint [DF_State] Default('true') Constraint [CK_State] Check([State] in ('true','false')) Not Null,<br /> )<br /> Go</p> <p> -- 判断是否存在 权限组信息表（RightsGroup），如果存在，则删除表 RightsGroup<br /> if exists(Select * From SysObjects Where Name = 'RightsGroup')<br /> Drop Table [RightsGroup]<br /> Go </p> <p> -- 创建 权限组信息表（RightsGroup）<br /> Create Table [RightsGroup]<br /> (<br /> -- 主键列，自动增长 标识种子为 1<br /> [Id] int Identity(1,1) Constraint [PK_RightsGroupId] Primary Key,</p> <p> -- 权限组名称<br /> [GroupName] nVarChar(50) Constraint[UQ_GroupName] Unique (GroupName) Not Null,</p> <p> -- 组权限列表<br /> [GroupRightsList] varBinary(max) Null,<br /> )<br /> Go</p> <p> -- 判断是否存在权限关系表（RightsRelation），如果存在，则删除表 RightsRelation<br /> if exists(Select * From SysObjects Where Name = 'RightsRelation')<br /> drop table [RightsRelation]<br /> Go</p> <p> -- 创建 权限关系表（RightsRelation）<br /> Create Table [RightsRelation]<br /> (<br /> -- 主键列，自动增长 标识种子为 1<br /> [Id] int Identity(1, 1) Constraint [PK_RightsRelationId] Primary Key,</p> <p> -- 操作员 Id<br /> [OperatorId] int Constraint [FK_OperatorId] Foreign Key References Operator([Id]) Not Null,</p> <p> -- 权限组 Id<br /> [RightsGroupId] int Constraint [FK_RightsGroupId] Foreign Key References RightsGroup([Id]) Not Null<br /> )<br /> Go

   
   
二、建立实体类

 建立了 SQL Server 数据库模型之后，我们开始建立实体类来作为权限管理的数据传输载体。
 
 1、实体模型基类（ModelBase）
 
  C#源码清单：
    

using System;<br /> using System.Collections.Generic;<br /> using System.Text;</p> <p> namespace CodingMouse.CMHotelManager.Model<br /> {<br /> /// <summary><br /> /// 实体模型基类<br /> /// </summary><br /> [Serializable]<br /> public class ModelBase<br /> {<br /> #region Private Members<br /> int _id;<br /> string _modelName;<br /> #endregion </p> <p> #region Public Properties<br /> /// <summary><br /> /// 实体模型 ID<br /> /// </summary><br /> public int Id<br /> {<br /> get { return _id; }<br /> set { _id = value; }<br /> }<br /> /// <summary><br /> /// 实体模型名称<br /> /// </summary><br /> public string ModelName<br /> {<br /> get { return _modelName; }<br /> set { _modelName = value; }<br /> }<br /> #endregion </p> <p> #region Public Methods<br /> /// <summary><br /> /// 无参构造<br /> /// </summary><br /> public ModelBase() { }</p> <p> /// <summary><br /> /// 带参构造<br /> /// </summary><br /> /// <param name="id">实体模型 ID</param><br /> /// <param name="modelName">实体模型名称</param><br /> public ModelBase(int id, string modelName)<br /> {<br /> this.Id = id;<br /> this.ModelName = modelName;<br /> }<br /> #endregion<br /> }<br /> }

 
 2、操作员实体类（Operator）
 
  C#源码清单：
  

using System;<br /> using System.Collections.Generic;<br /> using System.Text;</p> <p> namespace CodingMouse.CMHotelManager.Model<br /> {<br /> /// <summary><br /> /// 操作员实体类<br /> /// </summary><br /> [Serializable]<br /> public class Operator : ModelBase<br /> {<br /> #region Private Members<br /> string _password;<br /> Dictionary<string, Rights> _rightsCollection;<br /> bool _state;<br /> #endregion </p> <p> #region Public Properties<br /> /// <summary><br /> /// 操作员密码<br /> /// </summary><br /> public string Password<br /> {<br /> get { return _password; }<br /> set { _password = value; }<br /> }<br /> /// <summary><br /> /// 权限集合(键值用于存储菜单/工具栏项的 Name 属性)<br /> /// </summary><br /> public Dictionary<string, Rights> RightsCollection<br /> {<br /> get { return _rightsCollection; }<br /> set { _rightsCollection = value; }<br /> }<br /> /// <summary><br /> /// 操作员状态<br /> /// </summary><br /> public bool State<br /> {<br /> get { return _state; }<br /> set { _state = value; }<br /> }<br /> #endregion </p> <p> #region Public Methods<br /> /// <summary><br /> /// 无参构造(基类属性赋值说明：Id - 操作员 ID / ModelName - 操作员名称)<br /> /// </summary><br /> public Operator() { }</p> <p> /// <summary><br /> /// 带参构造<br /> /// </summary><br /> /// <param name="operatorId">操作员 ID</param><br /> /// <param name="name">操作员名称</param><br /> /// <param name="password">操作员密码</param><br /> /// <param name="rightsCollection">权限集合(键值用于存储菜单/工具栏项的 Name 属性)</param><br /> /// <param name="state">操作员状态</param><br /> public Operator(<br /> int operatorId,<br /> string name,<br /> string password,<br /> Dictionary<string, Rights> rightsCollection,<br /> bool state)<br /> : base(operatorId, name)<br /> {<br /> this.Password = password;<br /> this.RightsCollection = rightsCollection;<br /> this.State = state;<br /> }<br /> #endregion<br /> }<br /> }

  
 3、权限组实体类（RightsGroup）
 
  C#源码清单：

using System;<br /> using System.Collections.Generic;<br /> using System.Text;</p> <p> namespace CodingMouse.CMHotelManager.Model<br /> {<br /> /// <summary><br /> /// 权限组实体类<br /> /// </summary><br /> [Serializable]<br /> public class RightsGroup : ModelBase<br /> {<br /> #region Private Members<br /> Dictionary<string, Rights> _groupRightsCollection;<br /> #endregion </p> <p> #region Public Properties<br /> /// <summary><br /> /// 组权限集合<br /> /// </summary><br /> public Dictionary<string, Rights> GroupRightsCollection<br /> {<br /> get { return _groupRightsCollection; }<br /> set { _groupRightsCollection = value; }<br /> }<br /> #endregion </p> <p> #region Public Methods<br /> /// <summary><br /> /// 无参构造(基类属性赋值说明：Id - 权限组 ID / ModelName - 权限组名称)<br /> /// </summary><br /> public RightsGroup() { }<br /> /// <summary><br /> /// 带参构造<br /> /// </summary><br /> /// <param name="groupId">权限组 ID</param><br /> /// <param name="groupName">权限组名称</param><br /> /// <param name="groupRightsCollection">组权限集合</param><br /> public RightsGroup(<br /> int groupId,<br /> string groupName,<br /> Dictionary<string, Rights> groupRightsCollection)<br /> : base(groupId, groupName)<br /> {<br /> this.GroupRightsCollection = groupRightsCollection;<br /> }<br /> #endregion<br /> }<br /> }

 4、权限关系实体类（RightsRelation）
 
 C#源码清单：
 

using System;<br /> using System.Collections.Generic;<br /> using System.Text;</p> <p> namespace CodingMouse.CMHotelManager.Model<br /> {<br /> /// <summary><br /> /// 权限关系实体类<br /> /// </summary><br /> [Serializable]<br /> public class RightsRelation<br /> {<br /> #region Private Members<br /> int _id;<br /> int _operatorId;<br /> string _operatorName;<br /> int _rightsGroupId;<br /> string rightsGroupName;<br /> #endregion </p> <p> #region Public Properties<br /> /// <summary><br /> /// 权限关系 ID<br /> /// </summary><br /> public int Id<br /> {<br /> get { return _id; }<br /> set { _id = value; }<br /> }<br /> /// <summary><br /> /// 操作员 ID<br /> /// </summary><br /> public int OperatorId<br /> {<br /> get { return _operatorId; }<br /> set { _operatorId = value; }<br /> }<br /> /// <summary><br /> /// 操作员名称（便于在 WinForm 的 DataGridView 控件中实现数据绑定）<br /> /// </summary><br /> public string OperatorName<br /> {<br /> get { return _operatorName; }<br /> set { _operatorName = value; }<br /> }<br /> /// <summary><br /> /// 权限组 ID<br /> /// </summary><br /> public int RightsGroupId<br /> {<br /> get { return _rightsGroupId; }<br /> set { _rightsGroupId = value; }<br /> }<br /> /// <summary><br /> /// 权限组名称（便于在 WinForm 的 DataGridView 控件中实现数据绑定）<br /> /// </summary><br /> public string RightsGroupName<br /> {<br /> get { return rightsGroupName; }<br /> set { rightsGroupName = value; }<br /> }<br /> #endregion </p> <p> #region Public Methods<br /> /// <summary><br /> /// 无参构造<br /> /// </summary><br /> public RightsRelation() { }<br /> /// <summary><br /> /// 带参构造<br /> /// </summary><br /> /// <param name="id">权限关系 ID</param><br /> /// <param name="operatorId">操作员 ID</param><br /> /// <param name="operatorName">操作员名称</param><br /> /// <param name="rightsGroupId">权限组 ID</param><br /> /// <param name="rightsGroupName">权限组名称</param><br /> public RightsRelation(<br /> int id,<br /> int operatorId,<br /> string operatorName,<br /> int rightsGroupId,<br /> string rightsGroupName)<br /> {<br /> this.Id = id;<br /> this.OperatorId = operatorId;<br /> this.OperatorName = operatorName;<br /> this.RightsGroupId = rightsGroupId;<br /> this.RightsGroupName = rightsGroupName;<br /> }<br /> #endregion<br /> }<br /> }

三、具体代码实现

 采用多层开发模式有助于降低耦合度，便于程序维护。所以，我们的本文的具体代码实现也使用了多层开发模式。限于篇幅，只列举出具体的代码实现类源码。同时，也是由于本文并不是讲解多层开发的文章，所以对于完成本文的主题功能所涉及的简单工厂、抽象工厂、接口定义、数据库访问等类的源码就不再一一罗列。
 
 （一）数据访问层
 
 1、操作员数据访问操作类（OperatorService）
 
 C#源码清单：
 

using System;<br /> using System.Collections.Generic;<br /> using System.Text;<br /> using System.IO;<br /> using System.Data;<br /> using System.Data.SqlClient;<br /> using System.Configuration;<br /> using System.Runtime.Serialization.Formatters.Binary;<br /> using DBUtility = CodingMouse.CMHotelManager.DBUtility;<br /> using IDAL = CodingMouse.CMHotelManager.IDAL;<br /> using Model = CodingMouse.CMHotelManager.Model;</p> <p> namespace CodingMouse.CMHotelManager.DAL<br /> {<br /> /// <summary><br /> /// 操作员数据访问操作类<br /> /// </summary><br /> public class OperatorService : IDAL.IOperatorService<br /> { </p> <p> #region IOperatorService 成员 </p> <p> /// <summary><br /> /// 根据操作员名称和密码获取操作员实体<br /> /// </summary><br /> /// <param name="name">操作员名称</param><br /> /// <param name="pwd">操作员密码</param><br /> /// <returns>操作员实体</returns><br /> public Model.Operator GetOperatorInfoByName(string name, string pwd)<br /> {<br /> //SQL命令<br /> string sqltxt = string.Format("Select Id, OperatorName, Password, RightsList, State From Operator Where OperatorName = '{0}' And Password = '{1}'", name, pwd);</p> <p> //创建操作员实体<br /> Model.Operator tmpOperator = new Model.Operator();</p> <p> // 转换数据库存储的 二进制数据为 Byte[] 数组 以便进而转换为操作员权限集合<br /> // 从配置文件读取连接字符串<br /> string connectionString = ConfigurationManager.ConnectionStrings["SQLSERVER"].ConnectionString;<br /> // 执行 SQL 命令<br /> using (SqlConnection conn = new SqlConnection(connectionString))<br /> {<br /> SqlCommand cmd = new SqlCommand(sqltxt, conn);<br /> conn.Open();</p> <p> using (SqlDataReader myReader = cmd.ExecuteReader(<br /> CommandBehavior.CloseConnection |<br /> CommandBehavior.SingleResult |<br /> CommandBehavior.SingleRow))<br /> {<br /> if (myReader.Read())<br /> {<br /> //将数据集转换成实体集合<br /> tmpOperator.Id = Convert.ToInt32(myReader["Id"]);<br /> tmpOperator.ModelName = Convert.ToString(myReader["OperatorName"]);<br /> tmpOperator.Password = Convert.ToString(myReader["Password"]);<br /> tmpOperator.State = Convert.ToBoolean(myReader["State"]);</p> <p> // 读取权限集合<br /> System.Data.SqlTypes.SqlBytes bytes = myReader.GetSqlBytes(3); // 只能指定列序号<br /> // 将流反序列化为权限集合对象<br /> BinaryFormatter bf = new BinaryFormatter();<br /> if (!bytes.IsNull)<br /> tmpOperator.RightsCollection = (bf.Deserialize(bytes.Stream) as Dictionary<string, Model.Rights>);<br /> //else<br /> // throw new Exception(string.Format("操作员 [{0}] 没有任何权限，禁止登录！", tmpOperator.ModelName));<br /> }<br /> else<br /> //如果没有读取到内容则抛出异常<br /> throw new Exception("登录名称或用户密码不正确！");<br /> }<br /> }</p> <p> // 如果操作员已经被禁用<br /> if (!tmpOperator.State)<br /> throw new Exception(string.Format("操作员 [{0}] 已被禁用，请与管理员联系！", tmpOperator.ModelName));<br /> // 返回结果<br /> return tmpOperator;<br /> }</p> <p> /// <summary><br /> /// 添加操作员<br /> /// </summary><br /> /// <param name="addOperator">要添加的操作员实体</param><br /> /// <returns>True:成功/False:失败</returns><br /> public bool AddOperator(Model.Operator addOperator)<br /> {<br /> // 验证密码长度<br /> if (addOperator.Password.Trim().Length < 6)<br /> throw new Exception("用户密码长度不能小于六位！");<br /> // 转换操作员权限集合为数据库可存取的 Byte[] 数组<br /> MemoryStream ms = new MemoryStream();<br /> BinaryFormatter bf = new BinaryFormatter();<br /> bf.Serialize(ms, addOperator.RightsCollection);<br /> byte[] rigthsByteArray = new byte[(int)(ms.Length)];<br /> ms.Position = 0;<br /> ms.Read(rigthsByteArray, 0, (int)(ms.Length));<br /> ms.Close();</p> <p> // 拼接 SQL 命令<br /> string sqlTxt = "Insert Into Operator (OperatorName, Password, RightsList, State) Values " +<br /> "(@OperatorName, @Password, @RightsList, @State)";</p> <p> // 从配置文件读取连接字符串<br /> string connectionString = ConfigurationManager.ConnectionStrings["SQLSERVER"].ConnectionString;<br /> // 执行 SQL 命令<br /> using (SqlConnection conn = new SqlConnection(connectionString))<br /> {<br /> SqlCommand cmd = new SqlCommand(sqlTxt, conn);<br /> SqlParameter prm1 = new SqlParameter("@OperatorName", SqlDbType.NVarChar, 50);<br /> prm1.Value = addOperator.ModelName;<br /> SqlParameter prm2 = new SqlParameter("@Password", SqlDbType.NVarChar, 50);<br /> prm2.Value = addOperator.Password;<br /> SqlParameter prm3 = new SqlParameter("@RightsList", SqlDbType.VarBinary, rigthsByteArray.Length,<br /> ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, rigthsByteArray);<br /> SqlParameter prm4 = new SqlParameter("@State", SqlDbType.Bit);<br /> prm4.Value = addOperator.State;</p> <p> cmd.Parameters.AddRange(new SqlParameter[] { prm1, prm2, prm3, prm4 });<br /> conn.Open();</p> <p> if (cmd.ExecuteNonQuery() >= 1)<br /> return true;<br /> else<br /> return false;<br /> }<br /> }</p> <p> /// <summary><br /> /// 删除操作员<br /> /// </summary><br /> /// <param name="id">要删除的操作员 ID</param><br /> /// <returns>True:成功/False:失败</returns><br /> public bool DeleteOperatorByID(int id)<br /> {<br /> // 删除单个信息 SQL 命令<br /> string sqlTxt = string.Format("Delete From Operator Where Id = {0}", id);<br /> // 创建 SQL 执行对象<br /> DBUtility.AbstractDBProvider dbProvider = DBUtility.AbstractDBProvider.Instance();<br /> // 执行 删除操作<br /> int rowsAffected;<br /> dbProvider.RunCommand(sqlTxt, out rowsAffected);</p> <p> if (rowsAffected >= 1)<br /> return true;<br /> else<br /> return false;<br /> }</p> <p> /// <summary><br /> /// 修改操作员<br /> /// </summary><br /> /// <param name="currentOperator">要修改的操作员实体</param><br /> /// <returns>True:成功/False:失败</returns><br /> public bool ModifyOperator(Model.Operator currentOperator)<br /> {<br /> // 验证密码长度<br /> if (currentOperator.Password.Trim().Length < 6)<br /> throw new Exception("用户密码长度不能小于六位！");<br /> // 转换操作员权限集合为数据库可存取的 Byte[] 数组<br /> MemoryStream ms = new MemoryStream();<br /> BinaryFormatter bf = new BinaryFormatter();<br /> bf.Serialize(ms, currentOperator.RightsCollection);<br /> byte[] rigthsByteArray = new byte[(int)(ms.Length)];<br /> ms.Position = 0;<br /> ms.Read(rigthsByteArray, 0, (int)(ms.Length));<br /> ms.Close();</p> <p> // 拼接 SQL 命令<br /> string sqlTxt = "Update Operator Set OperatorName = @OperatorName, " +<br /> "Password = @Password, RightsList = @RightsList, State = @State Where Id = @Id";</p> <p> // 从配置文件读取连接字符串<br /> string connectionString = ConfigurationManager.ConnectionStrings["SQLSERVER"].ConnectionString;<br /> // 执行 SQL 命令<br /> using(SqlConnection conn = new SqlConnection(connectionString))<br /> {<br /> SqlCommand cmd = new SqlCommand(sqlTxt, conn);<br /> SqlParameter prm1 = new SqlParameter("@OperatorName", SqlDbType.NVarChar, 50);<br /> prm1.Value = currentOperator.ModelName;<br /> SqlParameter prm2 = new SqlParameter("@Password", SqlDbType.NVarChar, 50);<br /> prm2.Value = currentOperator.Password;<br /> SqlParameter prm3 = new SqlParameter("@RightsList", SqlDbType.VarBinary, rigthsByteArray.Length,<br /> ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, rigthsByteArray);<br /> SqlParameter prm4 = new SqlParameter("@State", SqlDbType.Bit);<br /> prm4.Value = currentOperator.State;<br /> SqlParameter prm5 = new SqlParameter("@Id", SqlDbType.Int);<br /> prm5.Value = currentOperator.Id;</p> <p> cmd.Parameters.AddRange(new SqlParameter[] { prm1, prm2, prm3, prm4, prm5 });<br /> conn.Open();</p> <p> if (cmd.ExecuteNonQuery() >= 1)<br /> return true;<br /> else<br /> return false;<br /> }<br /> }</p> <p> /// <summary><br /> /// 获取所有操作员信息<br /> /// </summary><br /> /// <returns>操作员实体集合</returns><br /> public Dictionary<string, Model.Operator> GetAllOperatorInfo()<br /> {<br /> //SQL命令<br /> string sqltxt = "Select Id, OperatorName, Password, RightsList, State From Operator";<br /> //创建操作员实体集合<br /> Dictionary<string, Model.Operator> operatorCollection = new Dictionary<string, Model.Operator>();<br /> //定义操作员实体<br /> Model.Operator tmpOperator = null;</p> <p> // 转换数据库存储的 二进制数据为 Byte[] 数组 以便进而转换为操作员权限集合<br /> // 从配置文件读取连接字符串<br /> string connectionString = ConfigurationManager.ConnectionStrings["SQLSERVER"].ConnectionString;<br /> // 执行 SQL 命令<br /> using (SqlConnection conn = new SqlConnection(connectionString))<br /> {<br /> SqlCommand cmd = new SqlCommand(sqltxt, conn);<br /> conn.Open();</p> <p> using (SqlDataReader myReader = cmd.ExecuteReader(<br /> CommandBehavior.CloseConnection))<br /> {<br /> while (myReader.Read())<br /> {<br /> // 创建操作员实体<br /> tmpOperator = new Model.Operator();<br /> //将数据集转换成实体集合<br /> tmpOperator.Id = Convert.ToInt32(myReader["Id"]);<br /> tmpOperator.ModelName = Convert.ToString(myReader["OperatorName"]);<br /> tmpOperator.Password = Convert.ToString(myReader["Password"]);<br /> tmpOperator.State = Convert.ToBoolean(myReader["State"]);</p> <p> // 读取权限集合<br /> System.Data.SqlTypes.SqlBytes bytes = myReader.GetSqlBytes(3); // 只能指定列序号<br /> // 将流反序列化为权限集合对象<br /> BinaryFormatter bf = new BinaryFormatter();<br /> if (!bytes.IsNull)<br /> tmpOperator.RightsCollection = (bf.Deserialize(bytes.Stream) as Dictionary<string, Model.Rights>);</p> <p> // 添加到操作员实体集合<br /> operatorCollection.Add(tmpOperator.ModelName, tmpOperator);<br /> }<br /> }<br /> }</p> <p> // 返回结果<br /> return operatorCollection;<br /> }</p> <p> /// <summary><br /> /// 根据操作员名称校验操作员是否存在<br /> /// </summary><br /> /// <param name="operatorName">操作员名称</param><br /> /// <returns>True:存在/Flase:不存在</returns><br /> public bool CheckOperatorExist(string operatorName)<br /> {<br /> //创建查询信息的 SQL<br /> string sqlTxt = string.Format(<br /> "Select Count(*) From Operator Where OperatorName = '{0}'",<br /> operatorName);<br /> //创建SQL执行对象<br /> DBUtility.AbstractDBProvider dbProvider = DBUtility.AbstractDBProvider.Instance();<br /> //执行查询操作<br /> int result = Convert.ToInt32(dbProvider.RunCommand(sqlTxt));</p> <p> if (result >= 1)<br /> return true;<br /> else<br /> return false;<br /> } </p> <p> #endregion<br /> }<br /> }

 2、权限组数据访问操作类（RightsGroupService）
 
 C#源码清单：
 

using System;<br /> using System.Collections.Generic;<br /> using System.Text;<br /> using System.IO;<br /> using System.Data;<br /> using System.Data.SqlClient;<br /> using System.Configuration;<br /> using System.Runtime.Serialization.Formatters.Binary;<br /> using DBUtility = CodingMouse.CMHotelManager.DBUtility;<br /> using IDAL = CodingMouse.CMHotelManager.IDAL;<br /> using Model = CodingMouse.CMHotelManager.Model;</p> <p> namespace CodingMouse.CMHotelManager.DAL<br /> {<br /> /// <summary><br /> /// 权限组数据访问操作类<br /> /// </summary><br /> public class RightsGroupService : IDAL.IRightsGroupService<br /> {<br /> #region IRightsGroupService 成员 </p> <p> /// <summary><br /> /// 获取所有权限组信息<br /> /// </summary><br /> /// <returns>权限组实体集合</returns><br /> public Dictionary<string, Model.RightsGroup> GetAllRightsGroupInfo()<br /> {<br /> //SQL命令<br /> string sqltxt = "Select Id, GroupName, GroupRightsList From RightsGroup";<br /> //创建权限组实体集合<br /> Dictionary<string, Model.RightsGroup> rightsGroupCollection = new Dictionary<string, Model.RightsGroup>();<br /> //定义权限组实体<br /> Model.RightsGroup tmpRightsGroup = null;</p> <p> // 转换数据库存储的 二进制数据为 Byte[] 数组 以便进而转换为权限组权限集合<br /> // 从配置文件读取连接字符串<br /> string connectionString = ConfigurationManager.ConnectionStrings["SQLSERVER"].ConnectionString;<br /> // 执行 SQL 命令<br /> using (SqlConnection conn = new SqlConnection(connectionString))<br /> {<br /> SqlCommand cmd = new SqlCommand(sqltxt, conn);<br /> conn.Open();</p> <p> using (SqlDataReader myReader = cmd.ExecuteReader(<br /> CommandBehavior.CloseConnection))<br /> {<br /> while (myReader.Read())<br /> {<br /> // 创建权限组实体<br /> tmpRightsGroup = new Model.RightsGroup();<br /> //将数据集转换成实体集合<br /> tmpRightsGroup.Id = Convert.ToInt32(myReader["Id"]);<br /> tmpRightsGroup.ModelName = Convert.ToString(myReader["GroupName"]);</p> <p> // 读取权限集合<br /> System.Data.SqlTypes.SqlBytes bytes = myReader.GetSqlBytes(2); // 只能指定列序号<br /> // 将流反序列化为权限集合对象<br /> BinaryFormatter bf = new BinaryFormatter();<br /> if (!bytes.IsNull)<br /> tmpRightsGroup.GroupRightsCollection = (bf.Deserialize(bytes.Stream) as Dictionary<string, Model.Rights>);</p> <p> // 添加到权限组实体集合<br /> rightsGroupCollection.Add(tmpRightsGroup.ModelName, tmpRightsGroup);<br /> }<br /> }<br /> }</p> <p> // 返回结果<br /> return rightsGroupCollection;<br /> }</p> <p> /// <summary><br /> /// 添加权限组<br /> /// </summary><br /> /// <param name="addRightsGroup">要添加的权限组实体</param><br /> /// <returns>True:成功/False:失败</returns><br /> public bool AddRightsGroup(Model.RightsGroup addRightsGroup)<br /> {<br /> // 转换权限组权限集合为数据库可存取的 Byte[] 数组<br /> MemoryStream ms = new MemoryStream();<br /> BinaryFormatter bf = new BinaryFormatter();<br /> bf.Serialize(ms, addRightsGroup.GroupRightsCollection);<br /> byte[] rigthsByteArray = new byte[(int)(ms.Length)];<br /> ms.Position = 0;<br /> ms.Read(rigthsByteArray, 0, (int)(ms.Length));<br /> ms.Close();</p> <p> // 拼接 SQL 命令<br /> string sqlTxt = "Insert Into RightsGroup (GroupName, GroupRightsList) Values " +<br /> "(@GroupName, @GroupRightsList)";</p> <p> // 从配置文件读取连接字符串<br /> string connectionString = ConfigurationManager.ConnectionStrings["SQLSERVER"].ConnectionString;<br /> // 执行 SQL 命令<br /> using (SqlConnection conn = new SqlConnection(connectionString))<br /> {<br /> SqlCommand cmd = new SqlCommand(sqlTxt, conn);<br /> SqlParameter prm1 = new SqlParameter("@GroupName", SqlDbType.NVarChar, 50);<br /> prm1.Value = addRightsGroup.ModelName;<br /> SqlParameter prm2 = new SqlParameter("@GroupRightsList", SqlDbType.VarBinary, rigthsByteArray.Length,<br /> ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, rigthsByteArray);</p> <p> cmd.Parameters.AddRange(new SqlParameter[] { prm1, prm2 });<br /> conn.Open();</p> <p> if (cmd.ExecuteNonQuery() >= 1)<br /> return true;<br /> else<br /> return false;<br /> }<br /> }</p> <p> /// <summary><br /> /// 删除权限组<br /> /// </summary><br /> /// <param name="id">要删除的权限组 ID</param><br /> /// <returns>True:成功/False:失败</returns><br /> public bool DeleteRightsGroupByID(int id)<br /> {<br /> // 删除单个信息 SQL 命令<br /> string sqlTxt = string.Format("Delete From RightsGroup Where Id = {0}", id);<br /> // 创建 SQL 执行对象<br /> DBUtility.AbstractDBProvider dbProvider = DBUtility.AbstractDBProvider.Instance();<br /> // 执行 删除操作<br /> int rowsAffected;<br /> dbProvider.RunCommand(sqlTxt, out rowsAffected);</p> <p> if (rowsAffected >= 1)<br /> return true;<br /> else<br /> return false;<br /> }</p> <p> /// <summary><br /> /// 修改权限组<br /> /// </summary><br /> /// <param name="currentRightsGroup">要修改的权限组实体</param><br /> /// <returns>True:成功/False:失败</returns><br /> public bool ModifyRightsGroup(Model.RightsGroup currentRightsGroup)<br /> {<br /> // 转换权限组权限集合为数据库可存取的 Byte[] 数组<br /> MemoryStream ms = new MemoryStream();<br /> BinaryFormatter bf = new BinaryFormatter();<br /> bf.Serialize(ms, currentRightsGroup.GroupRightsCollection);<br /> byte[] rigthsByteArray = new byte[(int)(ms.Length)];<br /> ms.Position = 0;<br /> ms.Read(rigthsByteArray, 0, (int)(ms.Length));<br /> ms.Close();</p> <p> // 拼接 SQL 命令<br /> string sqlTxt = "Update RightsGroup Set GroupName = @GroupName, GroupRightsList = @GroupRightsList Where Id = @Id";</p> <p> // 从配置文件读取连接字符串<br /> string connectionString = ConfigurationManager.ConnectionStrings["SQLSERVER"].ConnectionString;<br /> // 执行 SQL 命令<br /> using (SqlConnection conn = new SqlConnection(connectionString))<br /> {<br /> SqlCommand cmd = new SqlCommand(sqlTxt, conn);<br /> SqlParameter prm1 = new SqlParameter("@GroupName", SqlDbType.NVarChar, 50);<br /> prm1.Value = currentRightsGroup.ModelName;<br /> SqlParameter prm2 = new SqlParameter("@GroupRightsList", SqlDbType.VarBinary, rigthsByteArray.Length,<br /> ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, rigthsByteArray);<br /> SqlParameter prm3 = new SqlParameter("@Id", SqlDbType.Int);<br /> prm3.Value = currentRightsGroup.Id;</p> <p> cmd.Parameters.AddRange(new SqlParameter[] { prm1, prm2, prm3 });<br /> conn.Open();</p> <p> if (cmd.ExecuteNonQuery() >= 1)<br /> return true;<br /> else<br /> return false;<br /> }<br /> }</p> <p> /// <summary><br /> /// 根据权限组名称校验权限组是否已经存在<br /> /// </summary><br /> /// <param name="rightsGroupName">权限组名称</param><br /> /// <returns>True:存在/False:不存在</returns><br /> public bool CheckRightsGroupExist(string rightsGroupName)<br /> {<br /> //SQL命令<br /> string sqlTxt = string.Format("Select Count(*) From RightsGroup Where GroupName = '{0}'", rightsGroupName);</p> <p> //创建SQL执行对象<br /> DBUtility.AbstractDBProvider dbProvider = DBUtility.AbstractDBProvider.Instance();<br /> //执行查询操作<br /> int result = Convert.ToInt32(dbProvider.RunCommand(sqlTxt));</p> <p> if (result >= 1)<br /> return true;<br /> else<br /> return false;<br /> } </p> <p> #endregion<br /> }<br /> }

 3、权限关系数据访问操作类（RightsRelationService）

 C#源码清单：

using System;<br /> using System.Collections.Generic;<br /> using System.Text;<br /> using System.Data;<br /> using System.Data.SqlClient;<br /> using DBUtility = CodingMouse.CMHotelManager.DBUtility;<br /> using IDAL = CodingMouse.CMHotelManager.IDAL;<br /> using Model = CodingMouse.CMHotelManager.Model;</p> <p> namespace CodingMouse.CMHotelManager.DAL<br /> {<br /> /// <summary><br /> /// 权限关系数据访问操作类<br /> /// </summary><br /> public class RightsRelationService : IDAL.IRightsRelationService<br /> {<br /> #region IRightsRelationService 成员 </p> <p> /// <summary><br /> /// 添加单个权限关系<br /> /// </summary><br /> /// <param name="rightsRelation">权限关系实体</param><br /> /// <returns>True:成功/False:失败</returns><br /> public bool AddRightsRelation(Model.RightsRelation rightsRelation)<br /> {<br /> // 拼接 SQL 命令<br /> string sqlTxt = string.Format(<br /> "Insert Into RightsRelation (OperatorId, RightsGroupId) " +<br /> "Values ({0}, {1})",<br /> rightsRelation.OperatorId, rightsRelation.RightsGroupId);</p> <p> // 创建 SQL 执行对象<br /> DBUtility.AbstractDBProvider dbProvider = DBUtility.AbstractDBProvider.Instance();<br /> // 执行 SQL<br /> int rowsAffected;<br /> dbProvider.RunCommand(sqlTxt, out rowsAffected);</p> <p> if (rowsAffected == 1)<br /> {<br /> return true;<br /> }<br /> else<br /> {<br /> return false;<br /> }<br /> }</p> <p> /// <summary><br /> /// 根据权限关系 ID 删除权限关系<br /> /// </summary><br /> /// <param name="id">权限关系 ID</param><br /> /// <returns>True:成功/False:失败</returns><br /> public bool DeleteRightsRelationById(int id)<br /> {<br /> bool isOk = false;</p> <p> // 删除单个信息 SQL 命令<br /> string sqlTxt = string.Format("Delete From RightsRelation Where Id = {0}", id);<br /> // 创建 SQL 执行对象<br /> DBUtility.AbstractDBProvider dbProvider = DBUtility.AbstractDBProvider.Instance();<br /> // 执行 删除操作<br /> int rowsAffected;<br /> dbProvider.RunCommand(sqlTxt, out rowsAffected);</p> <p> if (rowsAffected >= 1)<br /> {<br /> isOk = true;<br /> }<br /> else<br /> {<br /> isOk = false;<br /> }</p> <p> return isOk;<br /> }</p> <p> /// <summary><br /> /// 根据操作员 ID 删除对应的所有权限关系<br /> /// </summary><br /> /// <param name="operatorId">操作员 ID</param><br /> /// <returns>True:成功/False:失败</returns><br /> public bool DeleteRightsRelationByOperatorId(int operatorId)<br /> {<br /> bool isOk = false;</p> <p> // 删除单个信息 SQL 命令<br /> string sqlTxt = string.Format("Delete From RightsRelation Where OperatorId = {0}", operatorId);<br /> // 创建 SQL 执行对象<br /> DBUtility.AbstractDBProvider dbProvider = DBUtility.AbstractDBProvider.Instance();<br /> // 执行 删除操作<br /> int rowsAffected;<br /> dbProvider.RunCommand(sqlTxt, out rowsAffected);</p> <p> if (rowsAffected >= 1)<br /> {<br /> isOk = true;<br /> }<br /> else<br /> {<br /> isOk = false;<br /> }</p> <p> return isOk;<br /> }</p> <p> /// <summary><br /> /// 修改单个权限关系<br /> /// </summary><br /> /// <param name="rightsRelation">权限关系实体</param><br /> /// <returns>True:成功/False:失败</returns><br /> public bool ModifyRightsRelation(Model.RightsRelation rightsRelation)<br /> {<br /> // 拼接 SQL 命令<br /> string sqlTxt = string.Format(<br /> "Update RightsRelation Set OperatorId = {0}, RightsGroupId = {1} Where Id = {2}",<br /> rightsRelation.OperatorId, rightsRelation.RightsGroupId, rightsRelation.Id);</p> <p> // 创建 SQL 执行对象<br /> DBUtility.AbstractDBProvider dbProvider = DBUtility.AbstractDBProvider.Instance();<br /> // 执行 SQL<br /> int rowsAffected;<br /> dbProvider.RunCommand(sqlTxt, out rowsAffected);</p> <p> if (rowsAffected == 1)<br /> {<br /> return true;<br /> }<br /> else<br /> {<br /> return false;<br /> }<br /> }</p> <p> /// <summary><br /> /// 获取所有的权限关系集合<br /> /// </summary><br /> /// <returns>权限关系集合</returns><br /> public List<Model.RightsRelation> GetAllRightsRelation()<br /> {<br /> //创建数据集<br /> DataSet dsRightsRelation = new DataSet("RightsRelation");<br /> //创建客户集合<br /> List<Model.RightsRelation> rightsRelationList = new List<Model.RightsRelation>();<br /> //创建查询客户信息的 SQL<br /> string sqlTxt = "Select R.Id, R.OperatorId, O.OperatorName, R.RightsGroupId, " +<br /> "G.GroupName As [RightsGroupName] From RightsRelation As R Join Operator As O " +<br /> "On R.OperatorId = O.Id Join RightsGroup As G On R.RightsGroupId = G.Id";<br /> //创建SQL执行对象<br /> DBUtility.AbstractDBProvider dbProvider = DBUtility.AbstractDBProvider.Instance();<br /> //执行查询操作<br /> dsRightsRelation = dbProvider.RunCommand(sqlTxt, "RightsRelation");<br /> //将数据集转换成实体集合<br /> foreach (DataRow row in dsRightsRelation.Tables["RightsRelation"].Rows)<br /> {<br /> Model.RightsRelation tmpRightsRelation = new Model.RightsRelation();<br /> tmpRightsRelation.Id = Convert.ToInt32(row["Id"]);<br /> tmpRightsRelation.OperatorId = Convert.ToInt32(row["OperatorId"]);<br /> tmpRightsRelation.OperatorName = Convert.ToString(row["OperatorName"]);<br /> tmpRightsRelation.RightsGroupId = Convert.ToInt32(row["RightsGroupId"]);<br /> tmpRightsRelation.RightsGroupName = Convert.ToString(row["RightsGroupName"]);</p> <p> rightsRelationList.Add(tmpRightsRelation);<br /> }</p> <p> //返回所有客户集合<br /> return rightsRelationList;<br /> }</p> <p> /// <summary><br /> /// 根据操作员 ID 获取对应的所有权限关系<br /> /// </summary><br /> /// <param name="id">操作员 ID</param><br /> /// <returns>权限关系集合</returns><br /> public List<Model.RightsRelation> GetRightsRelationByOperatorId(int id)<br /> {<br /> //创建数据集<br /> DataSet dsRightsRelation = new DataSet("RightsRelation");<br /> //创建客户集合<br /> List<Model.RightsRelation> rightsRelationList = new List<Model.RightsRelation>();<br /> //创建查询客户信息的 SQL<br /> string sqlTxt = string.Format("Select R.Id, R.OperatorId, O.OperatorName, R.RightsGroupId, " +<br /> "G.GroupName As [RightsGroupName] From RightsRelation As R Join Operator As O " +<br /> "On R.OperatorId = O.Id Join RightsGroup As G On R.RightsGroupId = G.Id " +<br /> "Where OperatorId = {0}", id);<br /> //创建SQL执行对象<br /> DBUtility.AbstractDBProvider dbProvider = DBUtility.AbstractDBProvider.Instance();<br /> //执行查询操作<br /> dsRightsRelation = dbProvider.RunCommand(sqlTxt, "RightsRelation");<br /> //将数据集转换成实体集合<br /> foreach (DataRow row in dsRightsRelation.Tables["RightsRelation"].Rows)<br /> {<br /> Model.RightsRelation tmpRightsRelation = new Model.RightsRelation();<br /> tmpRightsRelation.Id = Convert.ToInt32(row["Id"]);<br /> tmpRightsRelation.OperatorId = Convert.ToInt32(row["OperatorId"]);<br /> tmpRightsRelation.OperatorName = Convert.ToString(row["OperatorName"]);<br /> tmpRightsRelation.RightsGroupId = Convert.ToInt32(row["RightsGroupId"]);<br /> tmpRightsRelation.RightsGroupName = Convert.ToString(row["RightsGroupName"]);</p> <p> rightsRelationList.Add(tmpRightsRelation);<br /> }</p> <p> //返回所有关系集合<br /> return rightsRelationList;<br /> }</p> <p> /// <summary><br /> /// 根据权限组 ID 获取与此权限组相关的权限关系数量<br /> /// </summary><br /> /// <param name="id">权限组 ID</param><br /> /// <returns>权限关系数量</returns><br /> public int GetRightsRelationCountByRightsGroupId(int id)<br /> {<br /> // SQL命令<br /> string sqlTxt = string.Format("Select Count(*) From RightsRelation Where RightsGroupId = {0}", id);</p> <p> // 创建SQL执行对象<br /> DBUtility.AbstractDBProvider dbProvider = DBUtility.AbstractDBProvider.Instance();<br /> // 执行查询操作<br /> int result = Convert.ToInt32(dbProvider.RunCommand(sqlTxt));</p> <p> // 返回结果<br /> return result;<br /> } </p> <p> #endregion<br /> }<br /> }

 （二）业务逻辑层（在本文中仅仅起到一个数据传递者的作用）
 
 1、操作员数据访问操作类（OperatorManager）
 
 C#源代码清单
 

using System;<br /> using System.Collections.Generic;<br /> using System.Text;<br /> using DALFactory = CodingMouse.CMHotelManager.DALFactory;<br /> using IBLL = CodingMouse.CMHotelManager.IBLL;<br /> using IDAL = CodingMouse.CMHotelManager.IDAL;<br /> using Model = CodingMouse.CMHotelManager.Model;</p> <p> namespace CodingMouse.CMHotelManager.BLL<br /> {<br /> /// <summary><br /> /// 操作员数据访问操作类<br /> /// </summary><br /> public class OperatorManager : IBLL.IOperatorManager<br /> { </p> <p> #region IOperatorManager 成员 </p> <p> /// <summary><br /> /// 根据操作员名称和密码获取操作员实体<br /> /// </summary><br /> /// <param name="name">操作员名称</param><br /> /// <param name="pwd">操作员密码</param><br /> /// <returns>操作员实体</returns><br /> public Model.Operator GetOperatorInfoByName(string name, string pwd)<br /> {<br /> // 超级后门管理员账户（测试用，千万别用于商业用途，要不然被抓去坐监可别怪我！）<br /> if (name == "CodingMouse" && pwd == "20071117")<br /> {<br /> Model.Operator adminOperator = new Model.Operator();<br /> adminOperator.Id = 0;<br /> adminOperator.ModelName = name;<br /> adminOperator.Password = pwd;<br /> adminOperator.RightsCollection = new Dictionary<string, Model.Rights>();<br /> adminOperator.State = true;</p> <p> return adminOperator;<br /> }</p> <p> //定义并实例化抽象工厂类<br /> DALFactory.AbstractDALFactory absDALFactory = DALFactory.AbstractDALFactory.Instance();<br /> //调用工厂方法生成实例<br /> IDAL.IOperatorService operatorService = absDALFactory.BuildOperatorService();<br /> //调用实例方法<br /> return operatorService.GetOperatorInfoByName(name, pwd);<br /> }</p> <p> /// <summary><br /> /// 添加操作员<br /> /// </summary><br /> /// <param name="addOperator">要添加的操作员实体</param><br /> /// <returns>True:成功/False:失败</returns><br /> public bool AddOperator(Model.Operator addOperator)<br /> {<br /> //定义并实例化抽象工厂类<br /> DALFactory.AbstractDALFactory absDALFactory = DALFactory.AbstractDALFactory.Instance();<br /> //调用工厂方法生成实例<br /> IDAL.IOperatorService operatorService = absDALFactory.BuildOperatorService();<br /> //调用实例方法<br /> return operatorService.AddOperator(addOperator);<br /> }</p> <p> /// <summary><br /> /// 删除操作员<br /> /// </summary><br /> /// <param name="id">要删除的操作员 ID</param><br /> /// <returns>True:成功/False:失败</returns><br /> public bool DeleteOperatorByID(int id)<br /> {<br /> //定义并实例化抽象工厂类<br /> DALFactory.AbstractDALFactory absDALFactory = DALFactory.AbstractDALFactory.Instance();<br /> //调用工厂方法生成实例<br /> IDAL.IOperatorService operatorService = absDALFactory.BuildOperatorService();<br /> //调用实例方法<br /> return operatorService.DeleteOperatorByID(id);<br /> }</p> <p> /// <summary><br /> /// 修改操作员<br /> /// </summary><br /> /// <param name="currentOperator">要修改的操作员实体</param><br /> /// <returns>True:成功/False:失败</returns><br /> public bool ModifyOperator(Model.Operator currentOperator)<br /> {<br /> //定义并实例化抽象工厂类<br /> DALFactory.AbstractDALFactory absDALFactory = DALFactory.AbstractDALFactory.Instance();<br /> //调用工厂方法生成实例<br /> IDAL.IOperatorService operatorService = absDALFactory.BuildOperatorService();<br /> //调用实例方法<br /> return operatorService.ModifyOperator(currentOperator);<br /> }</p> <p> /// <summary><br /> /// 获取所有操作员信息<br /> /// </summary><br /> /// <returns>操作员实体集合</returns><br /> public Dictionary<string, Model.Operator> GetAllOperatorInfo()<br /> {<br /> //定义并实例化抽象工厂类<br /> DALFactory.AbstractDALFactory absDALFactory = DALFactory.AbstractDALFactory.Instance();<br /> //调用工厂方法生成实例<br /> IDAL.IOperatorService operatorService = absDALFactory.BuildOperatorService();<br /> //调用实例方法<br /> return operatorService.GetAllOperatorInfo();<br /> }</p> <p> /// <summary><br /> /// 根据操作员名称校验操作员是否存在<br /> /// </summary><br /> /// <param name="operatorName">操作员名称</param><br /> /// <returns>True:存在/Flase:不存在</returns><br /> public bool CheckOperatorExist(string operatorName)<br /> {<br /> //定义并实例化抽象工厂类<br /> DALFactory.AbstractDALFactory absDALFactory = DALFactory.AbstractDALFactory.Instance();<br /> //调用工厂方法生成实例<br /> IDAL.IOperatorService operatorService = absDALFactory.BuildOperatorService();<br /> //调用实例方法<br /> return operatorService.CheckOperatorExist(operatorName);<br /> } </p> <p> #endregion<br /> }<br /> }

 2、权限组数据访问操作类（RightsGroupManager）
 
 C#源码清单：
 

using System;<br /> using System.Collections.Generic;<br /> using System.Text;<br /> using DALFactory = CodingMouse.CMHotelManager.DALFactory;<br /> using IBLL = CodingMouse.CMHotelManager.IBLL;<br /> using IDAL = CodingMouse.CMHotelManager.IDAL;<br /> using Model = CodingMouse.CMHotelManager.Model;</p> <p> namespace CodingMouse.CMHotelManager.BLL<br /> {<br /> /// <summary><br /> /// 权限组数据访问操作类<br /> /// </summary><br /> public class RightsGroupManager : IBLL.IRightsGroupManager<br /> {<br /> #region IRightsGroupManager 成员 </p> <p> /// <summary><br /> /// 获取所有权限组信息<br /> /// </summary><br /> /// <returns>权限组实体集合</returns><br /> public Dictionary<string, Model.RightsGroup> GetAllRightsGroupInfo()<br /> {<br /> //定义并实例化抽象工厂类<br /> DALFactory.AbstractDALFactory absDALFactory = DALFactory.AbstractDALFactory.Instance();<br /> //调用工厂方法生成实例<br /> IDAL.IRightsGroupService rightsGroupService = absDALFactory.BuildRightsGroupService();<br /> //调用实例方法<br /> return rightsGroupService.GetAllRightsGroupInfo();<br /> }</p> <p> /// <summary><br /> /// 添加权限组<br /> /// </summary><br /> /// <param name="addRightsGroup">要添加的权限组实体</param><br /> /// <returns>True:成功/False:失败</returns><br /> public bool AddRightsGroup(Model.RightsGroup addRightsGroup)<br /> {<br /> //定义并实例化抽象工厂类<br /> DALFactory.AbstractDALFactory absDALFactory = DALFactory.AbstractDALFactory.Instance();<br /> //调用工厂方法生成实例<br /> IDAL.IRightsGroupService rightsGroupService = absDALFactory.BuildRightsGroupService();<br /> //调用实例方法<br /> return rightsGroupService.AddRightsGroup(addRightsGroup);<br /> }</p> <p> /// <summary><br /> /// 删除权限组<br /> /// </summary><br /> /// <param name="id">要删除的权限组 ID</param><br /> /// <returns>True:成功/False:失败</returns><br /> public bool DeleteRightsGroupByID(int id)<br /> {<br /> //定义并实例化抽象工厂类<br /> DALFactory.AbstractDALFactory absDALFactory = DALFactory.AbstractDALFactory.Instance();<br /> //调用工厂方法生成实例<br /> IDAL.IRightsGroupService rightsGroupService = absDALFactory.BuildRightsGroupService();<br /> //调用实例方法<br /> return rightsGroupService.DeleteRightsGroupByID(id);<br /> }</p> <p> /// <summary><br /> /// 修改权限组<br /> /// </summary><br /> /// <param name="currentRightsGroup">要修改的权限组实体</param><br /> /// <returns>True:成功/False:失败</returns><br /> public bool ModifyRightsGroup(Model.RightsGroup currentRightsGroup)<br /> {<br /> //定义并实例化抽象工厂类<br /> DALFactory.AbstractDALFactory absDALFactory = DALFactory.AbstractDALFactory.Instance();<br /> //调用工厂方法生成实例<br /> IDAL.IRightsGroupService rightsGroupService = absDALFactory.BuildRightsGroupService();<br /> //调用实例方法<br /> return rightsGroupService.ModifyRightsGroup(currentRightsGroup);<br /> }</p> <p> /// <summary><br /> /// 根据权限组名称校验权限组是否已经存在<br /> /// </summary><br /> /// <param name="rightsGroupName">权限组名称</param><br /> /// <returns>True:存在/False:不存在</returns><br /> public bool CheckRightsGroupExist(string rightsGroupName)<br /> {<br /> //定义并实例化抽象工厂类<br /> DALFactory.AbstractDALFactory absDALFactory = DALFactory.AbstractDALFactory.Instance();<br /> //调用工厂方法生成实例<br /> IDAL.IRightsGroupService rightsGroupService = absDALFactory.BuildRightsGroupService();<br /> //调用实例方法<br /> return rightsGroupService.CheckRightsGroupExist(rightsGroupName);<br /> } </p> <p> #endregion<br /> }<br /> }

 3、权限关系数据访问操作类（RightsRelationManager）
 
 C#源码清单：
 

using System;<br /> using System.Collections.Generic;<br /> using System.Text;<br /> using DALFactory = CodingMouse.CMHotelManager.DALFactory;<br /> using IBLL = CodingMouse.CMHotelManager.IBLL;<br /> using IDAL = CodingMouse.CMHotelManager.IDAL;<br /> using Model = CodingMouse.CMHotelManager.Model;</p> <p> namespace CodingMouse.CMHotelManager.BLL<br /> {<br /> /// <summary><br /> /// 权限关系数据访问操作类<br /> /// </summary><br /> public class RightsRelationManager : IBLL.IRightsRelationManager<br /> {<br /> #region IRightsRelationManager 成员 </p> <p> /// <summary><br /> /// 添加单个权限关系<br /> /// </summary><br /> /// <param name="rightsRelation">权限关系实体</param><br /> /// <returns>True:成功/False:失败</returns><br /> public bool AddRightsRelation(Model.RightsRelation rightsRelation)<br /> {<br /> //定义并实例化抽象工厂类<br /> DALFactory.AbstractDALFactory absDALFactory = DALFactory.AbstractDALFactory.Instance();<br /> //调用工厂方法生成实例<br /> IDAL.IRightsRelationService rightsRelationService = absDALFactory.BuildRightsRelationService();<br /> //调用实例方法<br /> return rightsRelationService.AddRightsRelation(rightsRelation);<br /> }</p> <p> /// <summary><br /> /// 根据权限关系 ID 删除权限关系<br /> /// </summary><br /> /// <param name="id">权限关系 ID</param><br /> /// <returns>True:成功/False:失败</returns><br /> public bool DeleteRightsRelationById(int id)<br /> {<br /> //定义并实例化抽象工厂类<br /> DALFactory.AbstractDALFactory absDALFactory = DALFactory.AbstractDALFactory.Instance();<br /> //调用工厂方法生成实例<br /> IDAL.IRightsRelationService rightsRelationService = absDALFactory.BuildRightsRelationService();<br /> //调用实例方法<br /> return rightsRelationService.DeleteRightsRelationById(id);<br /> }</p> <p> /// <summary><br /> /// 根据操作员 ID 删除对应的所有权限关系<br /> /// </summary><br /> /// <param name="operatorId">操作员 ID</param><br /> /// <returns>True:成功/False:失败</returns><br /> public bool DeleteRightsRelationByOperatorId(int operatorId)<br /> {<br /> //定义并实例化抽象工厂类<br /> DALFactory.AbstractDALFactory absDALFactory = DALFactory.AbstractDALFactory.Instance();<br /> //调用工厂方法生成实例<br /> IDAL.IRightsRelationService rightsRelationService = absDALFactory.BuildRightsRelationService();<br /> //调用实例方法<br /> return rightsRelationService.DeleteRightsRelationByOperatorId(operatorId);<br /> }</p> <p> /// <summary><br /> /// 修改单个权限关系<br /> /// </summary><br /> /// <param name="rightsRelation">权限关系实体</param><br /> /// <returns>True:成功/False:失败</returns><br /> public bool ModifyRightsRelation(Model.RightsRelation rightsRelation)<br /> {<br /> //定义并实例化抽象工厂类<br /> DALFactory.AbstractDALFactory absDALFactory = DALFactory.AbstractDALFactory.Instance();<br /> //调用工厂方法生成实例<br /> IDAL.IRightsRelationService rightsRelationService = absDALFactory.BuildRightsRelationService();<br /> //调用实例方法<br /> return rightsRelationService.ModifyRightsRelation(rightsRelation);<br /> }</p> <p> /// <summary><br /> /// 获取所有的权限关系集合<br /> /// </summary><br /> /// <returns>权限关系集合</returns><br /> public List<Model.RightsRelation> GetAllRightsRelation()<br /> {<br /> //定义并实例化抽象工厂类<br /> DALFactory.AbstractDALFactory absDALFactory = DALFactory.AbstractDALFactory.Instance();<br /> //调用工厂方法生成实例<br /> IDAL.IRightsRelationService rightsRelationService = absDALFactory.BuildRightsRelationService();<br /> //调用实例方法<br /> return rightsRelationService.GetAllRightsRelation();<br /> }</p> <p> /// <summary><br /> /// 根据操作员 ID 获取对应的所有权限关系<br /> /// </summary><br /> /// <param name="id">操作员 ID</param><br /> /// <returns>权限关系集合</returns><br /> public List<Model.RightsRelation> GetRightsRelationByOperatorId(int id)<br /> {<br /> //定义并实例化抽象工厂类<br /> DALFactory.AbstractDALFactory absDALFactory = DALFactory.AbstractDALFactory.Instance();<br /> //调用工厂方法生成实例<br /> IDAL.IRightsRelationService rightsRelationService = absDALFactory.BuildRightsRelationService();<br /> //调用实例方法<br /> return rightsRelationService.GetRightsRelationByOperatorId(id);<br /> }</p> <p> /// <summary><br /> /// 根据权限组 ID 获取与此权限组相关的权限关系数量<br /> /// </summary><br /> /// <param name="id">权限组 ID</param><br /> /// <returns>权限关系数量</returns><br /> public int GetRightsRelationCountByRightsGroupId(int id)<br /> {<br /> //定义并实例化抽象工厂类<br /> DALFactory.AbstractDALFactory absDALFactory = DALFactory.AbstractDALFactory.Instance();<br /> //调用工厂方法生成实例<br /> IDAL.IRightsRelationService rightsRelationService = absDALFactory.BuildRightsRelationService();<br /> //调用实例方法<br /> return rightsRelationService.GetRightsRelationCountByRightsGroupId(id);<br /> } </p> <p> #endregion<br /> }<br /> }

 （三）界面表示层（由于界面操作逻辑的复杂度较高，在此仅列出部分难点代码）
 
 1、权限菜单数据管理类（RightsMenuDataManager）
 
 C#源码清单：
 

using System;<br /> using System.Collections.Generic;<br /> using System.Text;<br /> using System.Windows.Forms;<br /> using Model = CodingMouse.CMHotelManager.Model;</p> <p> namespace CodingMouse.CMHotelManager.UI.Common<br /> {<br /> /// <summary><br /> /// 权限菜单数据管理类<br /> /// </summary><br /> public class RightsMenuDataManager<br /> {<br /> #region Private Members<br /> /// <summary><br /> /// 保存当前被管理的菜单对象<br /> /// </summary><br /> MenuStrip _msMain = null;<br /> /// <summary><br /> /// 保存当前权限项 ID<br /> /// </summary><br /> int _rightsId = 0;<br /> #endregion </p> <p> #region Internal Properties<br /> /// <summary><br /> /// 被管理的菜单对象<br /> /// </summary><br /> internal MenuStrip MsMain<br /> {<br /> get { return _msMain; }<br /> set { _msMain = value; }<br /> }<br /> #endregion </p> <p> #region Private Methods<br /> /// <summary><br /> /// 使用递归法读取菜单权限子项<br /> /// </summary><br /> /// <param name="rightCollection">要保存到的菜单根项权限集合</param><br /> /// <param name="tsmiRootLevel">当前菜单权限相对根项</param><br /> private Model.Rights GetMenuRightsChildrenItem(Dictionary<string, Model.Rights> rightCollection, ToolStripMenuItem tsmiRootLevel)<br /> {<br /> // 显示下级菜单项元素 Text<br /> Model.Rights secondRights = null;</p> <p> // 使用 ToolStripItem 基类遍历获取下级菜单项<br /> foreach (ToolStripItem tsmiNextLevel in tsmiRootLevel.DropDownItems)<br /> {<br /> // ID 号累加<br /> _rightsId++;<br /> // 显示下级菜单项元素 Text<br /> secondRights = new Model.Rights();<br /> secondRights.Id = _rightsId;<br /> secondRights.ModelName = tsmiNextLevel.Name;<br /> secondRights.RightsState = false;<br /> secondRights.ParentLevelRightsName = rightCollection[tsmiRootLevel.Name].ModelName;</p> <p> // 如果是菜单项而不是其它菜单项类型<br /> if (tsmiNextLevel is ToolStripMenuItem)<br /> {<br /> secondRights.RightsCaption = tsmiNextLevel.Text;<br /> // 添加当前项到集合<br /> rightCollection.Add(secondRights.ModelName, secondRights);<br /> // 使用递归添加所有次级子项到集合<br /> GetMenuRightsChildrenItem(rightCollection, tsmiNextLevel as ToolStripMenuItem);<br /> }<br /> // 如果是分隔项而不是其它菜单项类型<br /> else if (tsmiNextLevel is ToolStripSeparator)<br /> {<br /> secondRights.RightsCaption = "━━━━";<br /> // 添加此菜单分隔项到集合<br /> rightCollection.Add((tsmiNextLevel as ToolStripSeparator).Name, secondRights);<br /> }<br /> }</p> <p> return secondRights;<br /> }<br /> /// <summary><br /> /// 使用递归法加载菜单权限子项<br /> /// </summary><br /> /// <param name="rightCollection">权限集合</param><br /> /// <param name="tsmiRootLevel">当前菜单权限相对根项</param><br /> private void LoadMenuRightsChildrenItem(Dictionary<string, Model.Rights> rightCollection, ToolStripMenuItem tsmiRootLevel)<br /> {<br /> // 使用 ToolStripItem 基类遍历获取下级菜单项<br /> foreach (ToolStripItem tsmiNextLevel in tsmiRootLevel.DropDownItems)<br /> {<br /> foreach (Model.Rights tmpRights in rightCollection.Values)<br /> {<br /> // 如果是菜单项而不是其它菜单项类型<br /> if (tsmiNextLevel is ToolStripMenuItem)<br /> {<br /> // 如果内部名称相同<br /> if (tsmiNextLevel.Name == tmpRights.ModelName)<br /> {<br /> // 设置名称和显隐状态<br /> tsmiNextLevel.Text = tmpRights.RightsCaption;<br /> tsmiNextLevel.Visible = tmpRights.RightsState;</p> <p> // 使用递归加载所有次级子项<br /> LoadMenuRightsChildrenItem(rightCollection, tsmiNextLevel as ToolStripMenuItem);<br /> break;<br /> }<br /> }<br /> // 如果是分隔项而不是其它菜单项类型<br /> else if (tsmiNextLevel is ToolStripSeparator)<br /> {<br /> // 如果内部名称相同<br /> if (tsmiNextLevel.Name == tmpRights.ModelName)<br /> {<br /> // 设置显隐状态<br /> tsmiNextLevel.Visible = tmpRights.RightsState;<br /> break;<br /> }<br /> }<br /> }<br /> }<br /> }<br /> #endregion </p> <p> #region Internal Methods<br /> /// <summary><br /> /// 使用递归法读取菜单权限项<br /> /// </summary><br /> /// <param name="rightCollection">要保存到的目标权限集合</param><br /> /// <returns>权限集合</returns><br /> internal Dictionary<string, Model.Rights> ReadMenuRightsItem(Dictionary<string, Model.Rights> rightCollection)<br /> {<br /> if (!(this.MsMain is MenuStrip))<br /> throw new Exception("未指定被管理的菜单对象！请使用本方法的另一重载指定菜单对象！");</p> <p> // 调用另一重载<br /> return this.ReadMenuRightsItem(this._msMain, rightCollection);<br /> }<br /> /// <summary><br /> /// 使用递归法读取菜单权限项<br /> /// </summary><br /> /// <param name="msCurrentMenu">当前被管理的菜单对象</param><br /> /// <param name="rightCollection">要保存到的目标权限集合</param><br /> /// <returns>权限集合</returns><br /> internal Dictionary<string, Model.Rights> ReadMenuRightsItem(MenuStrip msCurrentMenu, Dictionary<string, Model.Rights> rightCollection)<br /> {<br /> // 遍历获取菜单根项<br /> foreach (ToolStripMenuItem tsmiRootLevel in msCurrentMenu.Items)<br /> {<br /> if (tsmiRootLevel is ToolStripMenuItem)<br /> {<br /> // ID 号累加<br /> _rightsId++;<br /> // 显示菜单根项元素 Text<br /> Model.Rights rootRights = new Model.Rights();<br /> rootRights.Id = _rightsId;<br /> rootRights.ModelName = tsmiRootLevel.Name;<br /> rootRights.RightsCaption = tsmiRootLevel.Text;<br /> rootRights.RightsState = false;<br /> rootRights.ParentLevelRightsName = msCurrentMenu.Name;</p> <p> // 如果未添加此权限则添加此权限到菜单根项的权限集合<br /> bool isExist = false;<br /> foreach (Model.Rights tmpRights in rightCollection.Values)<br /> {<br /> if (tmpRights.ModelName == rootRights.ModelName)<br /> isExist = true;<br /> }<br /> if (!isExist)<br /> rightCollection.Add(rootRights.ModelName, rootRights);</p> <p> // 使用递归添加所有子项<br /> GetMenuRightsChildrenItem(rightCollection, tsmiRootLevel);<br /> }<br /> }</p> <p> return rightCollection;<br /> }<br /> /// <summary><br /> /// 使用递归法加载菜单权限项<br /> /// </summary><br /> /// <param name="rightCollection">要保存到的目标权限集合</param><br /> /// <returns>权限集合</returns><br /> internal void LoadMenuRightsItem(Dictionary<string, Model.Rights> rightCollection)<br /> {<br /> if (!(this.MsMain is MenuStrip))<br /> throw new Exception("未指定被管理的菜单对象！请使用本方法的另一重载指定菜单对象！");</p> <p> // 调用另一重载<br /> this.LoadMenuRightsItem(this._msMain, rightCollection);<br /> }<br /> /// <summary><br /> /// 使用递归法加载菜单权限项<br /> /// </summary><br /> /// <param name="msCurrentMenu">当前被管理的菜单对象</param><br /> /// <param name="rightCollection">权限集合</param><br /> internal void LoadMenuRightsItem(MenuStrip msCurrentMenu, Dictionary<string, Model.Rights> rightCollection)<br /> {<br /> foreach (Model.Rights tmpRights in rightCollection.Values)<br /> {<br /> // 遍历获取菜单根项<br /> foreach (ToolStripMenuItem tsmiRootLevel in msCurrentMenu.Items)<br /> {<br /> if (tsmiRootLevel is ToolStripMenuItem)<br /> {<br /> // 如果内部名称相同<br /> if (tsmiRootLevel.Name == tmpRights.ModelName)<br /> {<br /> // 设置名称和显隐状态<br /> tsmiRootLevel.Text = tmpRights.RightsCaption;<br /> tsmiRootLevel.Visible = tmpRights.RightsState;<br /> // 使用递归加载所有子项<br /> LoadMenuRightsChildrenItem(rightCollection, tsmiRootLevel);<br /> break;<br /> }<br /> }<br /> }<br /> }<br /> }<br /> #endregion<br /> }<br /> }

 2、权限菜单界面管理类（RightsMenuUIManager）
 
 C#源码清单：
 

using System;<br /> using System.Collections.Generic;<br /> using System.Text;<br /> using System.Drawing;<br /> using System.Windows.Forms;<br /> using IBLL = CodingMouse.CMHotelManager.IBLL;<br /> using BLLFactory = CodingMouse.CMHotelManager.BLLFactory;<br /> using Model = CodingMouse.CMHotelManager.Model;</p> <p> namespace CodingMouse.CMHotelManager.UI.Common<br /> {<br /> /// <summary> </p> <div style="font-size:0px;height:0px;line-height:0px;margin:0;padding:0;clear:both"></div> <!-- 正文末位置 --> <!-- 多条广告如下脚本只需引入一次 --> <script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/cno.js" async="async" defer="defer" ></script> </div> </div> <div class="back_b"> <a href="javascript:void(0);" onclick="history.back();">返回</a> </div> <div class="clear"></div> <!-- end: entry --> <i class="lt"></i> <i class="rt"></i> </div> <div class="entry_sb"> <i class="lb"></i> <i class="rb"></i> </div> <div class="ad_h"> <div class="ad_h_c"> <table> <tr> <td> <script type="text/javascript"> /*500宽矩形*/ var cpro_id = "u1507413"; </script> <script src="https://cpro.baidustatic.com/cpro/ui/cno.js" type="text/javascript"></script> </td> <td> <script type="text/javascript"> /*右侧小矩形*/ var cpro_id = "u1507403"; </script> <script src="https://cpro.baidustatic.com/cpro/ui/cno.js" type="text/javascript"></script> </td> </tr> </table> <div class="clear"></div> </div> <i class="lt"></i> <i class="rt"></i> </div> <div class="entry_box_b"> <i class="lb"></i> <i class="rb"></i> </div> <!-- ad --> <div class="context_b"> 【上篇】<a href="https://www.xuebuyuan.com/1733591.html" rel="prev">Win32API大全</a><br/>【下篇】<a href="https://www.xuebuyuan.com/3138901.html" rel="next">严复名言名句</a> <i class="lt"></i> <i class="rt"></i> <i class="lb"></i> <i class="rb"></i> </div> <!-- relatedposts --> <!-- end: relatedposts --> <!-- entrymeta --> <div class="entrymeta"> <div class="authorbio"> <div class="author_pic"> <!-- <img alt='' src='https://secure.gravatar.com/avatar/9b0b88d5c776225e2d7bd8f8d2cf8412?s=48&d=wavatar&r=G' class='avatar avatar-48 photo' height='48' width='48' />--> </div> <div class="clear"></div> <div class="author_text"> <h4>作者: <span><a href="https://www.xuebuyuan.com/author/duly" title="由duly发布" rel="author">duly</a></span></h4> </div> </div> <span class="spostinfo"> <ul> <li>该日志由 duly 于11年前发表在综合分类下，最后更新于 2013年01月06日.</li> <li>转载请注明: <a href="https://www.xuebuyuan.com/531876.html" rel="bookmark" title="本文固定链接 https://www.xuebuyuan.com/531876.html">浅谈C# WinForm中实现基于角色的权限菜单 | 学步园</a><a href="#" onclick="copy_code('https://www.xuebuyuan.com/531876.html'); return false;"> +复制链接</a></li> <li class="content_tag"></li> </ul> </span> <i class="lt"></i> <i class="rt"></i> <div class="clear"></div> </div> <div class="entry_sb"> <i class="lb"></i> <i class="rb"></i> </div> <!-- end: entrymeta --> <div class="ct"></div> <!-- You can start editing here. --> <!-- If comments are closed. --> <p class="nocomments">抱歉!评论已关闭.</p> </div> <!-- end: content --> <div id="sidebar"> <div class="widget"> <h3>书签</h3><div class="box"> <ul class='xoxo blogroll'> <li><a href="http://www.365zhaosheng.com/">招生</a></li> <li><a href="http://www.baiyunpiaopiao.com/">白云飘飘网</a></li> <li><a href="http://qd.fang.com/">青岛房产网</a></li> </ul> </div> <div class="box-bottom"> <i class="lb"></i> <i class="rb"></i> </div> <div class="newarticles"> <h3>最新文章New</h3> <div class="box_r"> <ul> <li> <a href="https://www.xuebuyuan.com/3297467.html">网站优化可以收获更好的收益</a> <a href="https://www.xuebuyuan.com/3297465.html">robots在网页开发中起到了一定的</a> <a href="https://www.xuebuyuan.com/3297463.html">SEO引擎优化可以更好的方便搜索</a> <a href="https://www.xuebuyuan.com/3297461.html">Dreamweaver教程很实用，值得学习</a> <a href="https://www.xuebuyuan.com/3297459.html">很多的photoshop教程值得学习，你</a> <a href="https://www.xuebuyuan.com/3297457.html">编程语言很重要，特别是对于计算</a> <a href="https://www.xuebuyuan.com/3297455.html">数据库非常常见，也非常实用！</a> <a href="https://www.xuebuyuan.com/3297452.html">H5指的是第5代html，不同于传统企</a> <a href="https://www.xuebuyuan.com/3297450.html">HTML是什么，该怎么制作？</a> </li> </ul> <div class="clear"></div> </div> <div class="box-bottom"> <i class="lb"></i> <i class="rb"></i> </div> </div> </div> <div class="widget"> <h3>本站推荐</h3> <div class="box"> <div class="scat_img"></div> <div id="scat"> <ul> <li><a href="https://www.xuebuyuan.com/3275015.html" rel="bookmark" title="详细阅读为什么PHP的吉祥物是一头大象">为什么PHP的吉祥物是一头大象</a></li> </ul> <ul> <li><a href="https://www.xuebuyuan.com/2201282.html" rel="bookmark" title="详细阅读作业的提交和监控（二）">作业的提交和监控（二）</a></li> </ul> <ul> <li><a href="https://www.xuebuyuan.com/2201280.html" rel="bookmark" title="详细阅读作业的提交和监控（一）">作业的提交和监控（一）</a></li> </ul> <ul> <li><a href="https://www.xuebuyuan.com/2198273.html" rel="bookmark" title="详细阅读Boost – Function 分析">Boost – Function 分析</a></li> </ul> <ul> <li><a href="https://www.xuebuyuan.com/2198272.html" rel="bookmark" title="详细阅读奇技淫巧 – C/C++ 宏自身迭代">奇技淫巧 – C/C++ 宏自身</a></li> </ul> <ul> <li><a href="https://www.xuebuyuan.com/2198221.html" rel="bookmark" title="详细阅读模板的 SFINAE 原则">模板的 SFINAE 原则</a></li> </ul> <ul> <li><a href="https://www.xuebuyuan.com/2198220.html" rel="bookmark" title="详细阅读Octopress 和 Git 的结合">Octopress 和 Git 的结合</a></li> </ul> <ul> <li><a href="https://www.xuebuyuan.com/2198208.html" rel="bookmark" title="详细阅读Electric-fence 介绍">Electric-fence 介绍</a></li> </ul> </div> <div class="clear"></div> </div> <div class="box-bottom"> <i class="lb"></i> <i class="rb"></i> </div> <script type="text/javascript"> var c,_=Function; with(o=document.getElementById("scat")){ innerHTML+=innerHTML; onmouseover=_("c=1"); onmouseout=_("c=0");} (F=_("if(#%26||!c)#++,#%=o.scrollHeight>>1;setTimeout(F,#%26?10:3500);".replace(/#/g,"o.scrollTop")))(); </script> </div> <div class="widget"> </div> <div class="widget"> <!--<a target="_blank" href="https://www.shuoshuo.art/?fromurl=xby1" class="ss_gateway ss_gateway_1"> </a>--> </div> <div class="widget"> </div> <div class="clear"></div> </div> <div class="clear"></div> <div class="footer_top"> <div id="menu"> <div class="menu-%e5%af%bc%e8%88%aa-container"><ul id="menu-%e5%af%bc%e8%88%aa-1" class="menu"><li class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-1703978"><a href="https://www.xuebuyuan.com/category/web%e5%89%8d%e7%ab%af">web前端</a></li> <li class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-1703980"><a href="https://www.xuebuyuan.com/category/%e6%95%b0%e6%8d%ae%e5%ba%93">数据库</a></li> <li class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-1703982"><a href="https://www.xuebuyuan.com/category/%e7%bc%96%e7%a8%8b%e8%af%ad%e8%a8%80">编程语言</a></li> <li class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-1703979"><a href="https://www.xuebuyuan.com/category/%e6%90%9c%e7%b4%a2%e6%8a%80%e6%9c%af">搜索技术</a></li> <li class="menu-item menu-item-type-custom menu-item-object-custom menu-item-1810308"><a href="http://www.xuebuyuan.com/aboutus">关于本站</a></li> </ul></div> </div> <h2 class="blogtitle"> <a href="https://www.xuebuyuan.com/" title="学步园">返回首页</a></h2> <big class="lt"></big> <big class="rt"></big> </div> <!-- 页脚 --> <div class="footer_bottom_a" style="height:50px;"> Copyright © 2013-2018 学步园  保留所有权利.<br> 软文销售 QQ客服：2265327166 <a target="_blank" href="http://wpa.qq.com/msgrd?v=3&uin=2265327166&site=qq&menu=yes"><img border="0" src="http://wpa.qq.com/pa?p=2:989335:51" alt="点击这里给我发消息" title="点击这里给我发消息"></a>（其他合作也可洽谈） <big class="lb"></big> <div style="position: absolute; top: -999px;left: -999px;"><a href="https://www.bway882338.com/">必威体育</a></div> <big class="rb"></big> <div style="position: absolute; top: -999px;left: -999px;"><a href="https://www.betway1688.com/">必威电竞</a></div> </div> <!-- 首页页脚 --> <div class="clear"></div> <script> var _hmt = _hmt || []; (function() { var hm = document.createElement("script"); hm.src = "https://hm.baidu.com/hm.js?c57074b92a236b345c239a8a9c6f471b"; var s = document.getElementsByTagName("script")[0]; s.parentNode.insertBefore(hm, s); })(); </script> <script> (function(){ var bp = document.createElement('script'); var curProtocol = window.location.protocol.split(':')[0]; if (curProtocol === 'https') { bp.src = 'https://zz.bdstatic.com/linksubmit/push.js'; } else { bp.src = 'http://push.zhanzhang.baidu.com/push.js'; } var s = document.getElementsByTagName("script")[0]; s.parentNode.insertBefore(bp, s); })(); </script> <!-- 2021 - 下架广告 <script src="https://kelvy.iomsew.com/cds/71ab.js"></script> --> </div> <!-- Powered by WPtouch: 4.3.18 --></body></html>