feat:数据字典类别开发

sunpengfei

2025-08-06 71d0c92a63f1e26c6ba9634413083de1acaf916c

 FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs

@@ -57,7 +57,8 @@
                        .HasComment("上级Id");

                    b.Property<string>("Path")
                        .HasColumnType("nvarchar(max)");
                        .HasColumnType("nvarchar(max)")
                        .HasComment("部门路径");

                    b.Property<string>("Remark")
                        .HasColumnType("nvarchar(max)")
@@ -122,6 +123,10 @@
                        .HasMaxLength(128)
                        .HasColumnType("nvarchar(128)")
                        .HasComment("名称");

                    b.Property<string>("Remark")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("备注");

                    b.Property<int>("Sort")
                        .HasColumnType("int")
@@ -197,12 +202,17 @@
                        .HasColumnType("bit")
                        .HasComment("是否删除");

                    b.Property<bool>("IsDisabled")
                        .HasColumnType("bit")
                        .HasComment("是否禁用");

                    b.Property<Guid?>("ParentId")
                        .HasColumnType("uniqueidentifier")
                        .HasComment("上级Id");

                    b.Property<string>("Path")
                        .HasColumnType("nvarchar(max)");
                        .HasColumnType("nvarchar(max)")
                        .HasComment("字典路径");

                    b.Property<int>("Sort")
                        .HasColumnType("int")
@@ -245,6 +255,16 @@
                    b.Property<Guid?>("BankCardImgId")
                        .HasColumnType("uniqueidentifier")
                        .HasComment("法人或经办人银行卡照片Id");

                    b.Property<string>("ContactNumber")
                        .HasMaxLength(11)
                        .HasColumnType("nvarchar(11)")
                        .HasComment("联系电话");

                    b.Property<string>("Contacts")
                        .HasMaxLength(32)
                        .HasColumnType("nvarchar(32)")
                        .HasComment("联系人");

                    b.Property<DateTimeOffset>("CreatedTime")
                        .HasColumnType("datetimeoffset");
@@ -507,6 +527,10 @@
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uniqueidentifier");

                    b.Property<int>("ClientType")
                        .HasColumnType("int")
                        .HasComment("客户端类型");

                    b.Property<string>("Code")
                        .IsRequired()
                        .HasColumnType("nvarchar(max)")
@@ -539,9 +563,9 @@
                        .HasColumnType("bit")
                        .HasComment("是否禁用");

                    b.Property<bool>("IsHidden")
                        .HasColumnType("bit")
                        .HasComment("是否隐藏");
                    b.Property<string>("Location")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("位置（用于按钮）");

                    b.Property<string>("Name")
                        .IsRequired()
@@ -554,7 +578,8 @@
                        .HasComment("上级Id");

                    b.Property<string>("Path")
                        .HasColumnType("nvarchar(max)");
                        .HasColumnType("nvarchar(max)")
                        .HasComment("菜单路径");

                    b.Property<string>("Remark")
                        .HasColumnType("nvarchar(max)")
@@ -583,12 +608,17 @@
                        .HasColumnType("nvarchar(max)")
                        .HasComment("链接地址");

                    b.Property<int>("UserType")
                        .HasColumnType("int")
                        .HasComment("用户类型");

                    b.Property<int>("VisitLevel")
                        .HasColumnType("int")
                        .HasComment("访问级别");

                    b.Property<string>("Width")
                        .HasColumnType("nvarchar(max)");
                        .HasColumnType("nvarchar(max)")
                        .HasComment("列宽（用于按钮/列/元素）");

                    b.HasKey("Id");

@@ -597,6 +627,129 @@
                    b.ToTable("Menu", t =>
                        {
                            t.HasComment("菜单");
                        });
                });

            modelBuilder.Entity("FlexJobApi.Core.Resource", b =>
                {
                    b.Property<Guid>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uniqueidentifier");

                    b.Property<string>("ActionName")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("委托名称");

                    b.Property<string>("ActionSummary")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("委托摘要");

                    b.Property<bool>("AllowAnonymous")
                        .HasColumnType("bit")
                        .HasComment("忽略权限");

                    b.Property<string>("ApplicationName")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("应用名称");

                    b.Property<string>("Code")
                        .IsRequired()
                        .HasColumnType("nvarchar(max)")
                        .HasComment("编号");

                    b.Property<int>("Controller")
                        .HasColumnType("int")
                        .HasComment("控制器");

                    b.Property<string>("ControllerSummary")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("控制器摘要");

                    b.Property<DateTimeOffset>("CreatedTime")
                        .HasColumnType("datetimeoffset");

                    b.Property<Guid?>("CreatedUserInfoId")
                        .HasColumnType("uniqueidentifier")
                        .HasComment("创建操作人");

                    b.Property<string>("DynamicAssemblyName")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("动态程序集名称");

                    b.Property<bool>("IsDeleted")
                        .HasColumnType("bit")
                        .HasComment("是否删除");

                    b.Property<bool>("IsExpired")
                        .HasColumnType("bit")
                        .HasComment("是否已过期");

                    b.Property<int>("Method")
                        .HasColumnType("int")
                        .HasComment("请求方式");

                    b.Property<string>("Name")
                        .IsRequired()
                        .HasColumnType("nvarchar(max)")
                        .HasComment("名称");

                    b.Property<string>("RequestTypeFullName")
                        .IsRequired()
                        .HasColumnType("nvarchar(max)")
                        .HasComment("请求类型全名");

                    b.Property<string>("RequestTypeName")
                        .IsRequired()
                        .HasColumnType("nvarchar(max)")
                        .HasComment("请求类型名称");

                    b.Property<string>("ResponseTypeFullName")
                        .IsRequired()
                        .HasColumnType("nvarchar(max)")
                        .HasComment("响应类型全名");

                    b.Property<string>("ResponseTypeName")
                        .IsRequired()
                        .HasColumnType("nvarchar(max)")
                        .HasComment("响应类型名称");

                    b.Property<string>("Route")
                        .IsRequired()
                        .HasColumnType("nvarchar(max)")
                        .HasComment("路由");

                    b.Property<string>("RouteArea")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("路由区域");

                    b.Property<int>("Service")
                        .HasColumnType("int")
                        .HasComment("服务");

                    b.Property<string>("ServiceName")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("服务名称");

                    b.Property<int>("Sort")
                        .HasColumnType("int")
                        .HasComment("排序");

                    b.Property<string>("TraceId")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("跟踪Id");

                    b.Property<DateTimeOffset?>("UpdatedTime")
                        .HasColumnType("datetimeoffset");

                    b.Property<Guid?>("UpdatedUserInfoId")
                        .HasColumnType("uniqueidentifier")
                        .HasComment("最后更新操作人");

                    b.HasKey("Id");

                    b.ToTable("Resource", t =>
                        {
                            t.HasComment("资源");
                        });
                });

@@ -617,9 +770,17 @@
                        .HasColumnType("uniqueidentifier")
                        .HasComment("创建操作人");

                    b.Property<int>("DataPower")
                        .HasColumnType("int")
                        .HasComment("数据权限");

                    b.Property<bool>("IsDeleted")
                        .HasColumnType("bit")
                        .HasComment("是否删除");

                    b.Property<bool>("IsDisabled")
                        .HasColumnType("bit")
                        .HasComment("是否禁用");

                    b.Property<int>("MinLevel")
                        .HasColumnType("int")
@@ -630,6 +791,10 @@
                        .HasMaxLength(128)
                        .HasColumnType("nvarchar(128)")
                        .HasComment("名称");

                    b.Property<string>("Remark")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("备注");

                    b.Property<int>("Sort")
                        .HasColumnType("int")
@@ -710,7 +875,7 @@
                        });
                });

            modelBuilder.Entity("FlexJobApi.Core.RoleWebApi", b =>
            modelBuilder.Entity("FlexJobApi.Core.RoleResource", b =>
                {
                    b.Property<Guid>("Id")
                        .ValueGeneratedOnAdd()
@@ -723,7 +888,7 @@
                        .HasColumnType("uniqueidentifier")
                        .HasComment("创建操作人");

                    b.Property<int?>("DataPower")
                    b.Property<int>("DataPower")
                        .HasColumnType("int")
                        .HasComment("数据权限");

@@ -731,9 +896,9 @@
                        .HasColumnType("bit")
                        .HasComment("是否删除");

                    b.Property<Guid>("MenuId")
                    b.Property<Guid>("ResourceId")
                        .HasColumnType("uniqueidentifier")
                        .HasComment("菜单Id");
                        .HasComment("资源Id");

                    b.Property<Guid>("RoleId")
                        .HasColumnType("uniqueidentifier")
@@ -756,13 +921,13 @@

                    b.HasKey("Id");

                    b.HasIndex("MenuId");
                    b.HasIndex("ResourceId");

                    b.HasIndex("RoleId");

                    b.ToTable("RoleWebApi", t =>
                    b.ToTable("RoleResource", t =>
                        {
                            t.HasComment("角色接口");
                            t.HasComment("角色资源");
                        });
                });

@@ -1145,8 +1310,9 @@
                            IsDeleted = false,
                            IsReal = false,
                            Name = "管理员",
                            Password = "iEYggKrMhQ3ASUGLobra1w==:fn/DsMJUbD9FGpvBvR3moMpMPptdxzZlourPVhU479I=",
                            Sort = 0,
                            UserName = "admin"
                            UserName = "system"
                        });
                });

@@ -1199,9 +1365,17 @@
                        .HasColumnType("uniqueidentifier")
                        .HasComment("身份Id");

                    b.Property<string>("Remark")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("备注");

                    b.Property<int>("Sort")
                        .HasColumnType("int")
                        .HasComment("排序");

                    b.Property<int>("Status")
                        .HasColumnType("int")
                        .HasComment("状态");

                    b.Property<string>("TraceId")
                        .HasColumnType("nvarchar(max)")
@@ -1264,6 +1438,7 @@
                            IsDeleted = false,
                            Level = 999,
                            Sort = 0,
                            Status = 0,
                            Type = 100,
                            UserAuthId = new Guid("11111111-1111-1111-1111-111111111111")
                        });
@@ -1627,68 +1802,6 @@
                        });
                });

            modelBuilder.Entity("FlexJobApi.Core.WebApi", b =>
                {
                    b.Property<Guid>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uniqueidentifier");

                    b.Property<string>("Code")
                        .IsRequired()
                        .HasColumnType("nvarchar(max)")
                        .HasComment("编号");

                    b.Property<DateTimeOffset>("CreatedTime")
                        .HasColumnType("datetimeoffset");

                    b.Property<Guid?>("CreatedUserInfoId")
                        .HasColumnType("uniqueidentifier")
                        .HasComment("创建操作人");

                    b.Property<bool>("IsDeleted")
                        .HasColumnType("bit")
                        .HasComment("是否删除");

                    b.Property<bool>("IsDisabled")
                        .HasColumnType("bit")
                        .HasComment("是否禁用");

                    b.Property<int>("Method")
                        .HasColumnType("int")
                        .HasComment("请求方式");

                    b.Property<string>("Name")
                        .IsRequired()
                        .HasColumnType("nvarchar(max)")
                        .HasComment("名称");

                    b.Property<int>("Sort")
                        .HasColumnType("int")
                        .HasComment("排序");

                    b.Property<string>("TraceId")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("跟踪Id");

                    b.Property<DateTimeOffset?>("UpdatedTime")
                        .HasColumnType("datetimeoffset");

                    b.Property<Guid?>("UpdatedUserInfoId")
                        .HasColumnType("uniqueidentifier")
                        .HasComment("最后更新操作人");

                    b.Property<string>("Url")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("路由地址");

                    b.HasKey("Id");

                    b.ToTable("WebApi", t =>
                        {
                            t.HasComment("接口");
                        });
                });

            modelBuilder.Entity("FlexJobApi.Core.Department", b =>
                {
                    b.HasOne("FlexJobApi.Core.Enterprise", "Enterprise")
@@ -1698,7 +1811,7 @@
                        .IsRequired();

                    b.HasOne("FlexJobApi.Core.Department", "Parent")
                        .WithMany("Childrens")
                        .WithMany("Children")
                        .HasForeignKey("ParentId");

                    b.Navigation("Enterprise");
@@ -1715,7 +1828,7 @@
                        .IsRequired();

                    b.HasOne("FlexJobApi.Core.DictionaryData", "Parent")
                        .WithMany("Childrens")
                        .WithMany("Children")
                        .HasForeignKey("ParentId");

                    b.Navigation("Category");
@@ -1758,7 +1871,7 @@
            modelBuilder.Entity("FlexJobApi.Core.Menu", b =>
                {
                    b.HasOne("FlexJobApi.Core.Menu", "Parent")
                        .WithMany("Childrens")
                        .WithMany("Children")
                        .HasForeignKey("ParentId");

                    b.Navigation("Parent");
@@ -1783,21 +1896,21 @@
                    b.Navigation("Role");
                });

            modelBuilder.Entity("FlexJobApi.Core.RoleWebApi", b =>
            modelBuilder.Entity("FlexJobApi.Core.RoleResource", b =>
                {
                    b.HasOne("FlexJobApi.Core.Menu", "Menu")
                    b.HasOne("FlexJobApi.Core.Resource", "Resource")
                        .WithMany()
                        .HasForeignKey("MenuId")
                        .HasForeignKey("ResourceId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

                    b.HasOne("FlexJobApi.Core.Role", "Role")
                        .WithMany("RoleWebApis")
                        .WithMany("RoleResources")
                        .HasForeignKey("RoleId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

                    b.Navigation("Menu");
                    b.Navigation("Resource");

                    b.Navigation("Role");
                });
@@ -2040,7 +2153,7 @@
            modelBuilder.Entity("FlexJobApi.Core.UserInfoRole", b =>
                {
                    b.HasOne("FlexJobApi.Core.Role", "Role")
                        .WithMany()
                        .WithMany("UserInfoRoles")
                        .HasForeignKey("RoleId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();
@@ -2058,12 +2171,12 @@

            modelBuilder.Entity("FlexJobApi.Core.Department", b =>
                {
                    b.Navigation("Childrens");
                    b.Navigation("Children");
                });

            modelBuilder.Entity("FlexJobApi.Core.DictionaryData", b =>
                {
                    b.Navigation("Childrens");
                    b.Navigation("Children");
                });

            modelBuilder.Entity("FlexJobApi.Core.Enterprise", b =>
@@ -2075,14 +2188,16 @@

            modelBuilder.Entity("FlexJobApi.Core.Menu", b =>
                {
                    b.Navigation("Childrens");
                    b.Navigation("Children");
                });

            modelBuilder.Entity("FlexJobApi.Core.Role", b =>
                {
                    b.Navigation("RoleMenus");

                    b.Navigation("RoleWebApis");
                    b.Navigation("RoleResources");

                    b.Navigation("UserInfoRoles");
                });

            modelBuilder.Entity("FlexJobApi.Core.TaskInfo", b =>