Asp.Net MVC+BootStrap+EF6.0实现简单的用户角色权限管理1

时间：2023-03-08 16:06:10

首先给上项目的整体框架图：Asp.Net MVC+BootStrap+EF6.0实现简单的用户角色权限管理1，这里我没有使用BLL，因为感觉太烦了就没有去使用。

那么接下来我们首先先去Model层中添加Model。

管理员类：

using System;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations;

using System.ComponentModel.DataAnnotations.Schema;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace AuthorDesign.Model {

    /// <summary>

    /// 管理员

    /// </summary>

    public class Admin {

        /// <summary>

        /// 管理员ID（主键）

        /// </summary>

        [Key]

        public int Id { get; set; }

        /// <summary>

        /// 用户名

        /// </summary>

        [StringLength()]

        [Column(TypeName="varchar")]

        public string AdminName { get; set; }

        /// <summary>

        /// 手机号码

        /// </summary>

        [StringLength()]

        [Column(TypeName = "varchar")]

        public string Mobile { get; set; }

        /// <summary>

        /// 邮箱

        /// </summary>

        [StringLength()]

        [Column(TypeName = "varchar")]

        public string Email { get; set; }

        /// <summary>

        /// 密码

        /// </summary>

        [StringLength()]

        [Column(TypeName = "varchar")]

        public string Password { get; set; }

        /// <summary>

        /// 密码盐值

        /// </summary>

        [StringLength()]

        [Column(TypeName = "varchar")]

        public string Salt { get; set; }

        /// <summary>

        /// 对应角色Id

        /// </summary>

        public int AuthoryId { get; set; }

        /// <summary>

        /// 添加时间

        /// </summary>

        public DateTime CreateTime { get; set; }

        /// <summary>

        /// 是否超级管理员

        /// </summary>

        public Byte IsSuperAdmin { get; set; }

        /// <summary>

        /// 上次登录时间

        /// </summary>

        public DateTime LastLoginTime { get; set; }

        /// <summary>

        /// 上次登录地址

        /// </summary>

        [StringLength()]

        [Column(TypeName = "nvarchar")]

        public string LastLoginAddress { get; set; }

        /// <summary>

        /// 上次登录端口基本信息

        /// </summary>

        [StringLength()]

        [Column(TypeName = "varchar")]

        public string LastLoginInfo { get; set; }

        /// <summary>

        /// 上次登录Ip

        /// </summary>

        [StringLength()]

        [Column(TypeName = "varchar")]

        public string LastLoginIp { get; set; }

        public Admin(){

            CreateTime = DateTime.Now;

            LastLoginTime = DateTime.Now;

        }

    }

}

[Key]这个事用来设置主键的，[StringLength(30)]是用来控制在创建数据库的时候控制长度，[Column(TypeName="varchar")]是用来创建该字段在数据库中的类型。我在创建的时候没有使用外键，因本人对外键不熟所以没使用。Byte类型就相当于数据库的tinyint类型。

页面与页面动作联系表：

using System;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations;

using System.ComponentModel.DataAnnotations.Schema;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace AuthorDesign.Model {

    /// <summary>

    /// 页面与页面动作联系表

    /// </summary>

    public class ActionToPage {

        /// <summary>

        /// 自增Id

        /// </summary>

        [Key]

        public int Id { get; set; }

        /// <summary>

        /// 页面Id

        /// </summary>

        public int PageId { get; set; }

        /// <summary>

        /// 动作集合（用json存储）

        /// </summary>

        [StringLength()]

        [Column(TypeName = "varchar")]

        public string ActionList { get; set; }

        /// <summary>

        /// 是否删除

        /// </summary>

        public Byte IsDelete { get; set; }

    }

}

管理员登录日志：

using System;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations;

using System.ComponentModel.DataAnnotations.Schema;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace AuthorDesign.Model {

    /// <summary>

    /// 管理员登录日志

    /// </summary>

    public class AdminLoginLog {

        /// <summary>

        /// 管理员登录记录Id

        /// </summary>

        [Key]

        public int AdminLoginLogId { get; set; }

        /// <summary>

        /// 管理员Id

        /// </summary>

        public int AdminId { get; set; }

        /// <summary>

        /// 管理员登录地址

        /// </summary>

        [StringLength()]

        [Column(TypeName = "nvarchar")]

        public string AdminLoginAddress { get; set; }

        /// <summary>

        /// 管理员登录IP

        /// </summary>

        [StringLength()]

        [Column(TypeName = "varchar")]

        public string AdminLoginIP { get; set; }

        /// <summary>

        /// 管理员登录时间

        /// </summary>

        public DateTime AdminLoginTime { get; set; }

        /// <summary>

        /// 浏览器信息或者APP信息

        /// </summary>

        [Column(TypeName = "varchar")]

        [StringLength()]

        public string AdminLoginInfo { get; set; }

        public AdminLoginLog() {

            AdminLoginTime = DateTime.Now;

        }

    }

}

管理员操作类：

using System;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations;

using System.ComponentModel.DataAnnotations.Schema;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace AuthorDesign.Model {

    /// <summary>

    /// 管理员操作类

    /// </summary>

    public class AdminOperation {

        [Key]

        public int AdminOperationId { get; set; }

        /// <summary>

        /// 管理员Id

        /// </summary>

        public int AdminId { get; set; }

        /// <summary>

        /// 权限Id

        /// </summary>

        public int AuthoryId { get; set; }

        /// <summary>

        /// 动作Id（1：增，2：修改，3：查看，4：删除）

        /// </summary>

        public int Action { get; set; }

        /// <summary>

        /// 操作标题

        /// </summary>

        [StringLength()]

        [Column(TypeName = "nvarchar")]

        public string Title { get; set; }

        /// <summary>

        /// 操作详情

        /// </summary>

        [StringLength()]

        [Column(TypeName = "nvarchar")]

        public string Content { get; set; }

        /// <summary>

        /// 操作IP

        /// </summary>

        [StringLength()]

        [Column(TypeName = "varchar")]

        public string OperateIP { get; set; }

        /// <summary>

        /// 操作地址

        /// </summary>

        [StringLength()]

        [Column(TypeName = "nvarchar")]

        public string OperateAddress { get; set; }

        /// <summary>

        /// 浏览器信息或者APP信息

        /// </summary>

        [StringLength()]

        [Column(TypeName = "varchar")]

        public string OperateInfo { get; set; }

        /// <summary>

        /// 创建时间

        /// </summary>

        public DateTime CreateTime { get; set; }

        public AdminOperation() {

            CreateTime = DateTime.Now;

        }

    }

}

用户与页面和页面动作联系表：

using System;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations;

using System.ComponentModel.DataAnnotations.Schema;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace AuthorDesign.Model {

    /// <summary>

    /// 用户与页面和页面动作联系表

    /// </summary>

    public class AdminToPage {

        /// <summary>

        ///

        /// </summary>

        [Key]

        public int Id { get; set; }

        /// <summary>

        /// 管理员Id

        /// </summary>

        public int AdminId { get; set; }

        /// <summary>

        /// 页面Id

        /// </summary>

        public int PageId { get; set; }

        /// <summary>

        /// 动作集合（用json存储）

        /// </summary>

        [StringLength()]

        [Column(TypeName = "varchar")]

        public string ActionList { get; set; }

        /// <summary>

        /// 是否显示

        /// </summary>

        public Byte IsShow { get; set; }

        /// <summary>

        /// 是否删除

        /// </summary>

        public Byte IsDelete { get; set; }

    }

}

角色：

using System;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations;

using System.ComponentModel.DataAnnotations.Schema;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace AuthorDesign.Model {

    /// <summary>

    /// 角色

    /// </summary>

    public class Authory {

        /// <summary>

        /// 角色Id

        /// </summary>

        [Key]

        public int Id { get; set; }

        /// <summary>

        /// 角色名称

        /// </summary>

        [StringLength()]

        [Column(TypeName = "varchar")]

        public string Name { get; set; }

        /// <summary>

        /// 角色简介

        /// </summary>

        [StringLength()]

        [Column(TypeName = "varchar")]

        public string Intro { get; set; }

        /// <summary>

        /// 角色状态（0:正常;1:已删除）

        /// </summary>

        public Byte State { get; set; }

    }

}

角色与页面和页面动作之间联系：

using System;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations;

using System.ComponentModel.DataAnnotations.Schema;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace AuthorDesign.Model {

    /// <summary>

    /// 角色与页面和页面动作之间联系

    /// </summary>

    public class AuthoryToPage {

        /// <summary>

        /// 自增Id

        /// </summary>

        [Key]

        public int Id { get; set; }

        /// <summary>

        /// 权限Id

        /// </summary>

        public int AuthoryId { get; set; }

        /// <summary>

        /// 页面Id

        /// </summary>

        public int PageId { get; set; }

        /// <summary>

        /// 动作集合（用json存储）

        /// </summary>

        [StringLength()]

        [Column(TypeName = "varchar")]

        public string ActionList { get; set; }

        /// <summary>

        /// 是否显示

        /// </summary>

        public Byte IsShow { get; set; }

        /// <summary>

        /// 是否删除

        /// </summary>

        public Byte IsDelete { get; set; }

    }

}

页面动作：

using System;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations;

using System.ComponentModel.DataAnnotations.Schema;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace AuthorDesign.Model {

    /// <summary>

    /// 页面动作

    /// </summary>

    public class PageAction {

        /// <summary>

        /// 动作Id

        /// </summary>

        [Key]

        public int Id { get; set; }

        /// <summary>

        /// 动作名称

        /// </summary>

        [StringLength()]

        [Column(TypeName = "varchar")]

        public string Name { get; set; }

        /// <summary>

        /// 动作代码（页面代码）

        /// </summary>

        [StringLength()]

        [Column(TypeName = "varchar")]

        public string ActionCode { get; set; }

        /// <summary>

        /// 是否显示

        /// </summary>

        public Byte IsShow { get; set; }

        /// <summary>

        /// 动作等级

        /// </summary>

        public Byte ActionLevel { get; set; }

    }

}

页面：

using System;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations;

using System.ComponentModel.DataAnnotations.Schema;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace AuthorDesign.Model {

    /// <summary>

    /// 页面

    /// </summary>

    public class PageMenu {

        /// <summary>

        ///

        /// </summary>

        [Key]

        public int Id { get; set; }

        /// <summary>

        /// 页面Id

        /// </summary>

        public int PId { get; set; }

        /// <summary>

        /// 页面名称

        /// </summary>

        [StringLength()]

        [Column(TypeName = "varchar")]

        public string Name { get; set; }

        /// <summary>

        /// 页面路径

        /// </summary>

        [StringLength()]

        [Column(TypeName = "varchar")]

        public string PageUrl { get; set; }

        /// <summary>

        /// 是否显示

        /// </summary>

        public byte IsShow { get; set; }

        /// <summary>

        /// 排序

        /// </summary>

        public int OrderNum { get; set; }

        /// <summary>

        /// 页面图标

        /// </summary>

        [StringLength()]

        [Column(TypeName = "varchar")]

        public string Ico { get; set; }

    }

}

以上就是Model了。

下面的是对基础仓储的编辑（也就是DAL）：

首先安装下EF，Asp.Net MVC+BootStrap+EF6.0实现简单的用户角色权限管理1Asp.Net MVC+BootStrap+EF6.0实现简单的用户角色权限管理1选择6.0安装即可

首先是DbContext：这是EF与数据库连接的上下文。

using AuthorDesign.Model;

using System;

using System.Collections.Generic;

using System.Data.Entity;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace AuthorDesign.DAL {

    public class AuthorDesignContext : DbContext {

        public AuthorDesignContext()

            : base("AuthorDesignContext") {

        }

        public DbSet<ActionToPage> ActionToPages { get; set; }

        public DbSet<Admin> Admins { get; set; }

        public DbSet<AdminLoginLog> AdminLoginLogs { get; set; }

        public DbSet<AdminOperationRepository> AdminOperations { get; set; }

        public DbSet<AdminToPage> AdminToPages { get; set; }

        public DbSet<Authory> Authories { get; set; }

        public DbSet<AuthoryToPage> AuthoryToPages { get; set; }

        public DbSet<PageAction> PageActions { get; set; }

        public DbSet<PageMenu> PageMenus { get; set; }

    }

}

感觉类有点多，下篇继续写关于DAL的，这里一些都是简单的代码。可能本人写的不好，各位看官要是那里可以改进的或者那里有疑问的可以问我。

百度源码下载地址

相关文章