ABP-VNext 用户权限管理系统实战02---用户权限表的创建与迁移

 [Comment("菜单表")]
 [Table("t_identity_menu")]
 public class Menu : AuditedAggregateRoot<Guid>, ISoftDelete, IMultiTenant
 {
     [MaxLength(200)]
     [Comment("菜单名")]
     public string Name { get; set; }
 
     [MaxLength(50)]
     [Comment("菜单编码")]
     public int Code { get; set; }
    
     [MaxLength(36)]
     [Comment("父级菜单标识")]
     public Guid ParentId { get; set; }

     [Comment("层级")]
     public int Level { get; set; }

     [MaxLength(200)]
     [Comment("图标路径")]
     public string IconUrl { get; set; }

     [MaxLength(200)]
     [Comment("跳转路径")]
     public string RedirectUrl { get; set; }

     [Comment("菜单类型 0 APP 1 web")]
     public int MenuType { get; set; }


     [Comment("地址类型")]
     public int MenuInOut { get; set; }

  
     [Comment("排序")]
     public int Sort { get; set; }
   
     [Comment("是否启用")]
     public bool IsActive { get; set; }

     [Comment("是否删除")]
     public bool IsDeleted { get; set; }
  
     [Comment("租户Id")]
     public Guid? TenantId { set; get; }

    
     [Comment("用户归属系统Id")]
     [MaxLength(20)]
     public string SystemId { get; set; }
 
     [Comment("备注")]
     [MaxLength(500)]
     public string Remark { get; set; }
 }

  [Comment("角色权限中间表")]
  [Table("t_identity_role_authority")]
  public class RoleAuthority : AuditedAggregateRoot<Guid>, ISoftDelete, IMultiTenant
  {/// <summary>
   /// 角色id
   /// </summary>
      [MaxLength(36)]
      [Comment("角色标识")]
      public Guid RoleId { get; set; }

      /// <summary>
      /// 权限id
      /// </summary>
      [MaxLength(36)]
      [Comment("权限标识")]
      public Guid AuthId { get; set; }
     
      [Comment("是否删除")]
      public bool IsDeleted { get; set; }
      /// <summary>
      /// 租户Id
      /// </summary>
      public Guid? TenantId { get; set; }

      /// <summary>
      /// 构造函数
      /// </summary>
      /// <param name="id"></param>
      /// <param name="tenantId"></param>
      /// <param name="roleId"></param>
      /// <param name="authId"></param>
      public RoleAuthority(Guid id, Guid? tenantId, Guid roleId, Guid authId)
      {
          TenantId = tenantId;
          Id = id;
          RoleId = roleId;
          AuthId = authId;
      }
  }

[Comment("角色扩展表")]
[Table("t_identity_role_expand")]
public class RoleExpand : AuditedAggregateRoot<Guid>
{

    public RoleExpand(Guid Id, int RoleType, Guid RoleId, int RoleStatus)
    {
        this.Id = Id;
        this.RoleId = RoleId;
        this.RoleType = RoleType;
        this.RoleStatus = RoleStatus;
    }

    [MaxLength(36)]
    [Comment("角色标识")]
    public Guid RoleId { get; set; }
   
    [Comment("角色类型")]
    public int RoleType { get; set; }
 
    [MaxLength(36)]
    [Comment("用户状态：0启用、1禁用")]
    public int RoleStatus { get; set; }
  
    [MaxLength(20)]
    [Comment("归属系统Id")]
    public string SystemId { get; set; }
}

[Comment("角色菜单中间表")]
[Table("t_identity_role_menu")]
public class RoleMenu : AuditedAggregateRoot<Guid>, ISoftDelete
{
   
    [MaxLength(36)]
    [Comment("角色标识")]
    public Guid RoleId { get; set; }

   
    [MaxLength(36)]
    [Comment("菜单标识")]
    public Guid MenuId { get; set; }
    

    [Comment("是否删除")]
    public bool IsDeleted { get; set; }
}

 [Comment("用户扩展表")]
 [Table("t_identity_user_expand")]
 public  class UserExpand : AuditedAggregateRoot<Guid>
 {
     public UserExpand(Guid Id, int UserType, Guid UserId, UserStatusEnum userStatus = UserStatusEnum.Enable, int isConfirm = 0)
     {
         this.Id = Id;
         this.UserId = UserId;
         this.UserType = UserType;
         this.UserStatus = userStatus;
         this.IsConfirm = isConfirm;
     }
  
     [MaxLength(36)]
     [Comment("用户标识")]
     public Guid UserId { get; set; }
    

     [Comment("用户类型")]
     public int UserType { get; set; }


     [Comment("用户状态")]
     public UserStatusEnum UserStatus { get; set; }

  

     [Comment("是否已确认结果，0未确认，1已确认")]
     public int IsConfirm { get; set; }

  
     [MaxLength(200)]
     [Comment("用户图像")]
     public string HeadFileUrl { get; set; }

  
     [MaxLength(20)]
     [Comment("归属系统Id")]
     public string SystemId { get; set; }
     [Comment("锁定状态")]
     public bool? IsLock { get; set; }
 
     [Comment("登录失败次数")]
     public int? LoginFailedCount { get; set; }

     [Comment("锁定时间")]
     public DateTime? LockTime { get; set; }


     [Comment("锁定人")]
     public Guid? LockUserId { get; set; }

    
     [Comment("解锁时间")]
     public DateTime? UnLockTime { get; set; }

  
     [Comment("解锁人")]
     public Guid? UnLockUserId { get; set; }
 }

 public class EFCoreDbContextFactory : IDesignTimeDbContextFactory<EFCoreMigrationDbContext>
 {

     public EFCoreMigrationDbContext CreateDbContext(string[] args)
     {

         var configuration = BuildConfiguration();

         var builder = new DbContextOptionsBuilder<EFCoreMigrationDbContext>()
             .UseMySql(configuration.GetConnectionString("Default"),
             ServerVersion.AutoDetect(configuration.GetConnectionString("Default")), o => o.SchemaBehavior(MySqlSchemaBehavior.Ignore));

         return new EFCoreMigrationDbContext(builder.Options);
     }

     private static IConfigurationRoot BuildConfiguration()
     {
         var builder = new ConfigurationBuilder()
             .SetBasePath(Directory.GetCurrentDirectory())
             .AddJsonFile("appsettings.json", optional: false);

         return builder.Build();
     }
 }

public class EFCoreMigrationDbContext : AbpDbContext<EFCoreMigrationDbContext>
{
    public EFCoreMigrationDbContext(
        DbContextOptions<EFCoreMigrationDbContext> options
        ) : base(options)
    {

    }
    #region 用户权限管理模块
    public DbSet<Menu> Menus { get; set; }
    public DbSet<RoleAuthority> RoleAuthoritys { get; set; }
    public DbSet<Authority> Authoritys { get; set; }
    public DbSet<RoleMenu> RoleMenus { get; set; }
    public DbSet<UserExpand> UserExpands { get; set; }
    #endregion


    protected override void OnModelCreating(ModelBuilder builder)
    {


        builder.ConfigureIdentityManagement();
        base.OnModelCreating(builder);

    }
}

"ConnectionStrings": {
  "Default": "Server=123.249.14.34;Port=3306; Database=bridge; User=root; Password=xxxx;"
},