Hidistro.SqlDal/Store/RoleDao.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

namespace Hidistro.SqlDal.Store
{
    using Hidistro.Entities;
    using Hidistro.Entities.Store;
    using Microsoft.Practices.EnterpriseLibrary.Data;
    using System;
    using System.Collections.Generic;
    using System.Data;
    using System.Data.Common;
    using System.Text;

    public class RoleDao
    {
        private Database database = DatabaseFactory.CreateDatabase();

        public void AddPrivilegeInRoles(int roleId, string strPermissions)
        {
            string[] strArray = strPermissions.Split(new char[] { ',' });
            StringBuilder builder = new StringBuilder(" ");
            if ((strArray != null) && (strArray.Length > 0))
            {
                foreach (string str in strArray)
                {
                    builder.AppendFormat("INSERT INTO Hishop_PrivilegeInRoles (RoleId, Privilege) VALUES (@RoleId, {0}); ", str);
                }
            }
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand(builder.ToString());
            this.database.AddInParameter(sqlStringCommand, "RoleId", DbType.String, roleId);
            this.database.ExecuteNonQuery(sqlStringCommand);
        }

        public bool AddRole(RoleInfo role)
        {
            string query = "INSERT INTO aspnet_Roles (RoleName, Description,IsDefault) VALUES (@RoleName, @Description,@IsDefault);";
            if (role.IsDefault)
            {
            }
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand(query);
            this.database.AddInParameter(sqlStringCommand, "RoleName", DbType.String, role.RoleName);
            this.database.AddInParameter(sqlStringCommand, "Description", DbType.String, role.Description);
            this.database.AddInParameter(sqlStringCommand, "IsDefault", DbType.Boolean, role.IsDefault);
            return (this.database.ExecuteNonQuery(sqlStringCommand) > 0);
        }

        public void ClearRolePrivilege(int roleId)
        {
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand("DELETE FROM Hishop_PrivilegeInRoles WHERE RoleId = @RoleId");
            this.database.AddInParameter(sqlStringCommand, "RoleId", DbType.Int32, roleId);
            this.database.ExecuteNonQuery(sqlStringCommand);
        }

        public bool DeleteRole(int roleId)
        {
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand("if( select count(*) from aspnet_Managers where RoleId = @RoleId ) = 0 DELETE FROM aspnet_Roles WHERE RoleId = @RoleId");
            this.database.AddInParameter(sqlStringCommand, "RoleId", DbType.Int32, roleId);
            return (this.database.ExecuteNonQuery(sqlStringCommand) > 0);
        }

        public IList<int> GetPrivilegeByRoles(int roleId)
        {