ASP.NET MVC4.0+EF+LINQ+bui+bootstrap+网站+角色权限管理系统（1）

本系列的的角色权限管理主要采用Dotnet MVC4工程内置的权限管理模块Simplemembership实现，主要有关文件是InitializeSimpleMembershipAttribute.cs和AccountModels.cs

下面是对这两个文件的了解和改造

WebSecurity.InitializeDatabaseConnection("DefaultConnection", "UserProfile", "UserId", "UserName", autoCreateTables: true);表示数据库表不存在的情况下，通过连接到包含用户信息的数据库以及使用指定的成员资格或角色提供程序来初始化成员资格系统。

首先创建一个MVCSystem的空数据库，如下：

然后改造配置文件Web.config数据库链接，注意这里的name="DefaultConnection"与上面的WebSecurity.InitializeDatabaseConnection("DefaultConnection", "UserProfile", "UserId", "UserName", autoCreateTables: true);相同

然后运行程序，在空数据库MVCSystem中生成以下数据表（有的可能无法生存webpages_Permission，webpages_PermissionsInRoles表，不过没关系，手动建（字段参考下图）就可以了）

对于运行后无法自动生成数据表的同学，可以点击一下Home page上的注册按钮！

接下来创建和改造Models类：

AccountModels.cs【管理员管理页面的一些基本的ViewModel】

 1 using System;
 2 using System.Collections.Generic;
 3 using System.ComponentModel.DataAnnotations;
 4 using System.ComponentModel.DataAnnotations.Schema;
 5 using System.Data.Entity;
 6 using System.Globalization;
 7 using System.Web.Security;
 8 
 9 namespace MVCSystem.Web.Models
10 {
11    
12 
13     public class RegisterExternalLoginModel
14     {
15         [Required]
16         [Display(Name = "用户名")]
17         public string UserName { get; set; }
18 
19         public string ExternalLoginData { get; set; }
20     }
21 
22     public class LocalPasswordModel
23     {
24         [Required]
25         [DataType(DataType.Password)]
26         [Display(Name = "当前密码")]
27         public string OldPassword { get; set; }
28 
29         [Required]
30         [StringLength(100, ErrorMessage = "{0} 必须至少包含 {2} 个字符。", MinimumLength = 6)]
31         [DataType(DataType.Password)]
32         [Display(Name = "新密码")]
33         public string NewPassword { get; set; }
34 
35         [DataType(DataType.Password)]
36         [Display(Name = "确认新密码")]
37         [Compare("NewPassword", ErrorMessage = "新密码和确认密码不匹配。")]
38         public string ConfirmPassword { get; set; }
39     }
40 
41     public class LoginModel
42     {
43         [Required]
44         [Display(Name = "用户名")]
45         public string UserName { get; set; }
46 
47         [Required]
48         [DataType(DataType.Password)]
49         [Display(Name = "密码")]
50         public string Password { get; set; }
51 
52         [Display(Name = "记住我?")]
53         public bool RememberMe { get; set; }
54     }
55 
56     public class RegisterModel
57     {
58         [Required]
59         [Display(Name = "用户名")]
60         public string UserName { get; set; }
61 
62         [Required]
63         [StringLength(100, ErrorMessage = "{0} 必须至少包含 {2} 个字符。", MinimumLength = 6)]
64         [DataType(DataType.Password)]
65         [Display(Name = "密码")]
66         public string Password { get; set; }
67 
68         [DataType(DataType.Password)]
69         [Display(Name = "确认密码")]
70         [Compare("Password", ErrorMessage = "密码和确认密码不匹配。")]
71         public string ConfirmPassword { get; set; }
72     }
73 
74     public class ExternalLogin
75     {
76         public string Provider { get; set; }
77         public string ProviderDisplayName { get; set; }
78         public string ProviderUserId { get; set; }
79     }
80 }

View Code

M_UserProfile.cs【我们可以扩展管理员数据表字段，电话，地址，邮箱等】

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Web;namespace MVCSystem.Web.Models
{[Table("UserProfile")]public class M_UserProfile{[Key][DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)][Display(Name = "ID")]public int UserId { get; set; }[Display(Name = "用户名")][StringLength(250)]public string UserName { get; set; }[Display(Name = "邮件地址")][StringLength(250)]public string Email { get; set; }}
}

View Code

M_Membership.cs【这个主要存储管理员的信息内容，以后要用到（比如重置密码）】

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Web;namespace MVCSystem.Web.Models
{[Table("webpages_Membership")]public class M_Membership{public M_Membership(){Roles = new List<M_Roles>();}[Key]public int UserId { get; set; }public DateTime? CreateDate { get; set; }public string ConfirmationToken { get; set; }public bool? IsConfirmed { get; set; }public DateTime? LastPasswordFailureDate { get; set; }public int PasswordFailuresSinceLastSuccess { get; set; }public string Password { get; set; }public DateTime? PasswordChangedDate { get; set; }public string PasswordSalt { get; set; }public string PasswordVerificationToken { get; set; }public DateTime? PasswordVerificationTokenExpirationDate { get; set; }public ICollection<M_Roles> Roles { get; set; }}}

View Code

M_Permission.cs【用来存储具体的Action权限】

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Web;namespace MVCSystem.Web.Models
{[Table("webpages_Permission")]public class M_Permission{public M_Permission(){T_PermissionsInRoles = new List<M_PermissionsInRoles>();}[Key][DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)][Display(Name = "权限ID")]public int PermissionId { get; set; }[Display(Name = "名称")]public string PermissionName { get; set; }[ForeignKey("PermissionId")]public ICollection<M_PermissionsInRoles> T_PermissionsInRoles { set; get; }}
}

View Code

M_Roles.cs【角色表，与管理员角色表、角色权限表关联】

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Web;namespace MVCSystem.Web.Models
{ [Table("webpages_Roles")]public class M_Roles{public M_Roles(){T_Members = new List<M_Membership>();T_PermissionsInRoles = new List<M_PermissionsInRoles>();}[Key][Display(Name = "ID")]public int RoleId { get; set; }[Display(Name = "名称")][StringLength(256)]public string RoleName { get; set; }public ICollection<M_Membership> T_Members { get; set; }[ForeignKey("RoleId")]public ICollection<M_PermissionsInRoles> T_PermissionsInRoles { set; get; }}
}

View Code

M_UsersInRoles.cs【用来存储用户的角色】

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Web;namespace MVCSystem.Web.Models
{[Table("webpages_UsersInRoles")]public class M_UsersInRoles{[Key]public int UsersInRolesId { get; set; }public int UserId { get; set; }public int RoleId { get; set; }}
}

View Code

M_PermissionsInRoles.cs【用来存储角色的具体权限】

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Web;namespace MVCSystem.Web.Models
{[Table("webpages_PermissionsInRoles")]public class M_PermissionsInRoles{[Key]public int Id { get; set; }public int RoleId { get; set; }public int PermissionId { get; set; }public M_Roles T_Role { get; set; }public M_Permission T_Permission { get; set; }}
}

View Code

然后创建一个Common文件夹，主要存储一些公告类：

简述：EF5.0包括Code First和DbContext API。DbContext API为EF提供更多的工作方式：Code First，Database First和Model First。

使用DbContext构造函数

1. Code First约定连接

namespace Magic.Unicorn
{
    public class UnicornsContext : DbContext
    {
        public UnicornsContext()
        // C# will call base class parameterless constructor by default
        {
        }
    }
}

用Magic.Unicorn.UnicornsContext作为数据库名，在本机上生成该数据库的连接字符串（SQL Express）。

2. Code First指定数据库名称的约定连接

public class UnicornsContext : DbContext
{
    public UnicornsContext()
        : base("UnicornsDatabase")
    {
    }
}

MVCStystemContext.cs实体类集合

using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using System.Web;
using MVCSystem.Web.Models;namespace MVCSystem.Web.Common
{public class MVCStystemContext : DbContext{public MVCStystemContext(): base("DefaultConnection"){}public DbSet<M_UserProfile> DB_UserProfiles { get; set; }public DbSet<M_Membership> DB_Membership { get; set; }public DbSet<M_Roles> DB_Roles { get; set; }public DbSet<M_UsersInRoles> DB_UsersInRoles { get; set; }}
}