userrole.cs

动易SiteFactory&#8482 网上商店系统1.0源代码

                while (reader.Read())
                {
                    list.Add(GetRoleInfoFromrdr(reader));
                }
            }
            return list;
        }

        public IList<string> GetRoleListByOperateCode(OperateCode operateCode)
        {
            Parameters parms = new Parameters();
            parms.AddInParameter("@OperateCode", DbType.Int32, operateCode);
            string strSqlText = "SELECT RoleId FROM PE_Roles_Permissions WHERE OperateCode=@OperateCode";
            return CreateRoleList(parms, strSqlText);
        }

        public IList<string> GetRoleListByOperateCode(int operateCode)
        {
            Parameters parms = new Parameters();
            parms.AddInParameter("@OperateCode", DbType.Int32, operateCode);
            string strSqlText = "SELECT RoleId FROM PE_Roles_Permissions WHERE OperateCode=@OperateCode";
            return CreateRoleList(parms, strSqlText);
        }

        public IList<string> GetRoleListByOperateCodeFieldName(OperateCode operateCode, int modelId, string fieldName)
        {
            Parameters parms = new Parameters();
            parms.AddInParameter("@OperateCode", DbType.Int32, operateCode);
            parms.AddInParameter("@ModelID", DbType.Int32, modelId);
            parms.AddInParameter("@FieldName", DbType.String, fieldName);
            string strSqlText = "SELECT RoleId FROM PE_Role_Field_Permissions WHERE OperateCode=@OperateCode AND ModelID=@ModelID AND FieldName=@FieldName";
            return CreateRoleList(parms, strSqlText);
        }

        public IList<string> GetRoleListByOperateCodeNode(OperateCode operateCode, int nodeId)
        {
            Parameters parms = new Parameters();
            parms.AddInParameter("@OperateCode", DbType.Int32, operateCode);
            parms.AddInParameter("@NodeID", DbType.Int32, nodeId);
            string strSqlText = "SELECT RoleId FROM PE_Role_Node_Permissions WHERE  OperateCode=@OperateCode AND NodeID=@NodeID";
            return CreateRoleList(parms, strSqlText);
        }

        public IList<string> GetRoleListByOperateCodeSpecialId(OperateCode operateCode, int specialId)
        {
            Parameters parms = new Parameters();
            parms.AddInParameter("@OperateCode", DbType.Int32, operateCode);
            parms.AddInParameter("@SpecialId", DbType.Int32, specialId);
            string strSqlText = "SELECT RoleId FROM  PE_Role_Special_Permissions WHERE  OperateCode=@OperateCode AND  SpecialId=@SpecialId";
            return CreateRoleList(parms, strSqlText);
        }

        public IList<RoleInfo> GetRoleListByRoleId(int adminId)
        {
            IList<RoleInfo> list = new List<RoleInfo>();
            string strSql = "SELECT * FROM PE_Roles WHERE (RoleID IN (SELECT RoleID FROM PE_Admin_Roles WHERE (AdminID = @AdminID)))";
            Parameters cmdParams = new Parameters("@AdminID", DbType.Int32, adminId);
            using (NullableDataReader reader = DBHelper.ExecuteReaderSql(strSql, cmdParams))
            {
                while (reader.Read())
                {
                    list.Add(GetRoleInfoFromrdr(reader));
                }
            }
            return list;
        }

        public IList<RoleInfo> GetRoleListNotInRole(int adminId)
        {
            IList<RoleInfo> list = new List<RoleInfo>();
            string strSql = "SELECT * FROM PE_Roles WHERE (RoleID NOT IN (SELECT RoleID FROM PE_Admin_Roles WHERE (AdminID = @AdminID)))";
            Parameters cmdParams = new Parameters("@AdminID", DbType.Int32, adminId);
            using (NullableDataReader reader = DBHelper.ExecuteReaderSql(strSql, cmdParams))
            {
                while (reader.Read())
                {
                    list.Add(GetRoleInfoFromrdr(reader));
                }
            }
            return list;
        }

        public string GetRoleNodeId(string roleId, OperateCode operateCode)
        {
            string strCommand = "select Distinct NodeID from PE_Role_Node_Permissions where RoleID in(" + roleId + ")  And OperateCode = @OperateCode";
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@RoleId", DbType.String, roleId);
            cmdParams.AddInParameter("@OperateCode", DbType.Int32, operateCode);
            StringBuilder builder = new StringBuilder();
            using (NullableDataReader reader = DBHelper.ExecuteReader(CommandType.Text, strCommand, cmdParams))
            {
                while (reader.Read())
                {
                    if (builder.Length > 0)
                    {
                        builder.Append("," + reader.GetInt32("NodeID").ToString());
                    }
                    else
                    {
                        builder.Append(reader.GetInt32("NodeID").ToString());
                    }
                }
            }
            return builder.ToString();
        }

        public string GetRoleNodeId(string roleId, OperateCode[] arrOperateCode)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("select Distinct NodeID from PE_Role_Node_Permissions where RoleID in(" + roleId + ") ");
            foreach (OperateCode code in arrOperateCode)
            {
                builder.Append(" Or OperateCode = " + ((int) code));
            }
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@RoleId", DbType.String, roleId);
            StringBuilder builder2 = new StringBuilder();
            using (NullableDataReader reader = DBHelper.ExecuteReader(CommandType.Text, builder.ToString(), cmdParams))
            {
                while (reader.Read())
                {
                    if (builder2.Length > 0)
                    {
                        builder2.Append("," + reader.GetInt32("NodeID").ToString());
                    }
                    else
                    {
                        builder2.Append(reader.GetInt32("NodeID").ToString());
                    }
                }
            }
            return builder2.ToString();
        }

        public IList<RoleSpecialPermissionsInfo> GetSpecialPermissionsByRoleId(int roleId, OperateCode operateCode)
        {
            IList<RoleSpecialPermissionsInfo> list = new List<RoleSpecialPermissionsInfo>();
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@RoleID", DbType.Int32, roleId);
            cmdParams.AddInParameter("@OperateCode", DbType.Int32, operateCode);
            string strCommand = "SELECT * FROM PE_Role_Special_Permissions WHERE RoleID =@RoleID And OperateCode=@OperateCode";
            using (NullableDataReader reader = DBHelper.ExecuteReader(CommandType.Text, strCommand, cmdParams))
            {
                while (reader.Read())
                {
                    RoleSpecialPermissionsInfo item = new RoleSpecialPermissionsInfo();
                    item.GroupId = reader.GetInt32("RoleID");
                    item.OperateCode = (OperateCode) reader.GetInt32("OperateCode");
                    item.SpecialId = reader.GetInt32("SpecialID");
                    list.Add(item);
                }
            }
            return list;
        }

        public IList<RoleSpecialPermissionsInfo> GetSpecialPermissionsBySpecialId(int specialId)
        {
            IList<RoleSpecialPermissionsInfo> list = new List<RoleSpecialPermissionsInfo>();
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@SpecialID", DbType.Int32, specialId);
            string strCommand = "SELECT * FROM PE_Role_Special_Permissions WHERE SpecialID =@SpecialID";
            using (NullableDataReader reader = DBHelper.ExecuteReader(CommandType.Text, strCommand, cmdParams))
            {
                while (reader.Read())
                {
                    RoleSpecialPermissionsInfo item = new RoleSpecialPermissionsInfo();
                    item.GroupId = reader.GetInt32("RoleID");
                    item.OperateCode = (OperateCode) reader.GetInt32("OperateCode");
                    item.SpecialId = reader.GetInt32("SpecialID");
                    list.Add(item);
                }
            }
            return list;
        }

        public IList<RoleSpecialPermissionsInfo> GetSpecialPermssionList(int roleId, int specialId)
        {
            IList<RoleSpecialPermissionsInfo> list = new List<RoleSpecialPermissionsInfo>();
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@RoleID", DbType.Int32, roleId);
            cmdParams.AddInParameter("@SpecialId", DbType.Int32, specialId);
            string strCommand = "SELECT * FROM PE_Role_Special_Permissions WHERE RoleID =@RoleID And SpecialId=@SpecialId";
            using (NullableDataReader reader = DBHelper.ExecuteReader(CommandType.Text, strCommand, cmdParams))
            {
                while (reader.Read())
                {
                    RoleSpecialPermissionsInfo item = new RoleSpecialPermissionsInfo();
                    item.GroupId = reader.GetInt32("RoleID");
                    item.OperateCode = (OperateCode) reader.GetInt32("OperateCode");
                    item.SpecialId = reader.GetInt32("SpecialID");
                    list.Add(item);
                }
            }
            return list;
        }

        public int GetTotalOfRoles()
        {
            return this.m_TotalOfRoles;
        }

        public bool IsExist(string roleName)
        {
            string strSql = "SELECT COUNT(*) FROM PE_Roles WHERE RoleName=@RoleName";
            Parameters cmdParams = new Parameters("@RoleName", DbType.String, roleName);
            return DBHelper.ExistsSql(strSql, cmdParams);
        }

        public bool Update(RoleInfo roleInfo)
        {
            string strSql = "UPDATE PE_Roles SET RoleName=@RoleName,Description=@Description WHERE RoleId=@RoleId";
            Parameters cmdParams = GetParameters(roleInfo);
            return DBHelper.ExecuteSql(strSql, cmdParams);
        }
    }
}