pref:菜单优化

sunpengfei

2025-08-04 7374d934381f81e835314f60dc411b963614d803

 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)")
@@ -84,7 +85,7 @@

                    b.HasIndex("ParentId");

                    b.ToTable("Department", t =>
                    b.ToTable("Department", null, t =>
                        {
                            t.HasComment("部门");
                        });
@@ -140,7 +141,7 @@

                    b.HasKey("Id");

                    b.ToTable("DictionaryCategory", t =>
                    b.ToTable("DictionaryCategory", null, t =>
                        {
                            t.HasComment("字典类别");
                        });
@@ -202,7 +203,8 @@
                        .HasComment("上级Id");

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

                    b.Property<int>("Sort")
                        .HasColumnType("int")
@@ -225,7 +227,7 @@

                    b.HasIndex("ParentId");

                    b.ToTable("DictionaryData", t =>
                    b.ToTable("DictionaryData", null, t =>
                        {
                            t.HasComment("字典数据");
                        });
@@ -348,7 +350,7 @@

                    b.HasIndex("LicenseImageId");

                    b.ToTable("Enterprise", t =>
                    b.ToTable("Enterprise", null, t =>
                        {
                            t.HasComment("企业");
                        });
@@ -439,7 +441,7 @@

                    b.HasKey("Id");

                    b.ToTable("FileStore", t =>
                    b.ToTable("FileStore", null, t =>
                        {
                            t.HasComment("文件存储");
                        });
@@ -495,7 +497,7 @@

                    b.HasIndex("StoreId");

                    b.ToTable("FileVirtualPath", t =>
                    b.ToTable("FileVirtualPath", null, t =>
                        {
                            t.HasComment("文件虚拟路径");
                        });
@@ -506,6 +508,10 @@
                    b.Property<Guid>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uniqueidentifier");

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

                    b.Property<string>("Code")
                        .IsRequired()
@@ -539,9 +545,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 +560,8 @@
                        .HasComment("上级Id");

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

                    b.Property<string>("Remark")
                        .HasColumnType("nvarchar(max)")
@@ -583,20 +590,103 @@
                        .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");

                    b.HasIndex("ParentId");

                    b.ToTable("Menu", t =>
                    b.ToTable("Menu", null, t =>
                        {
                            t.HasComment("菜单");
                        });
                });

            modelBuilder.Entity("FlexJobApi.Core.Resource", 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>("IsExpired")
                        .HasColumnType("bit")
                        .HasComment("是否已过期");

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

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

                    b.Property<string>("RequestTypeName")
                        .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>("Service")
                        .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.HasKey("Id");

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

@@ -652,7 +742,7 @@

                    b.HasKey("Id");

                    b.ToTable("Role", t =>
                    b.ToTable("Role", null, t =>
                        {
                            t.HasComment("角色");
                        });
@@ -704,13 +794,13 @@

                    b.HasIndex("RoleId");

                    b.ToTable("RoleMenu", t =>
                    b.ToTable("RoleMenu", null, t =>
                        {
                            t.HasComment("角色菜单");
                        });
                });

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

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

@@ -731,9 +821,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 +846,13 @@

                    b.HasKey("Id");

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

                    b.HasIndex("RoleId");

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

@@ -853,7 +943,7 @@

                    b.HasIndex("EnterpriseId");

                    b.ToTable("TaskInfo", t =>
                    b.ToTable("TaskInfo", null, t =>
                        {
                            t.HasComment("任务信息");
                        });
@@ -908,7 +998,7 @@

                    b.HasIndex("BenefitId1");

                    b.ToTable("TaskInfoBenefit", t =>
                    b.ToTable("TaskInfoBenefit", null, t =>
                        {
                            t.HasComment("任务福利");
                        });
@@ -960,7 +1050,7 @@

                    b.HasIndex("TypeId");

                    b.ToTable("TaskInfoCredentialLimit");
                    b.ToTable("TaskInfoCredentialLimit", (string)null);
                });

            modelBuilder.Entity("FlexJobApi.Core.TaskInfoUser", b =>
@@ -1025,7 +1115,7 @@

                    b.HasIndex("UserInfoId");

                    b.ToTable("TaskInfoUser", t =>
                    b.ToTable("TaskInfoUser", null, t =>
                        {
                            t.HasComment("任务用户信息");
                        });
@@ -1131,7 +1221,7 @@

                    b.HasIndex("IdentityImgId");

                    b.ToTable("UserAuth", t =>
                    b.ToTable("UserAuth", null, t =>
                        {
                            t.HasComment("用户");
                        });
@@ -1145,8 +1235,9 @@
                            IsDeleted = false,
                            IsReal = false,
                            Name = "管理员",
                            Password = "iEYggKrMhQ3ASUGLobra1w==:fn/DsMJUbD9FGpvBvR3moMpMPptdxzZlourPVhU479I=",
                            Sort = 0,
                            UserName = "admin"
                            UserName = "system"
                        });
                });

@@ -1251,7 +1342,7 @@

                    b.HasIndex("UserAuthId");

                    b.ToTable("UserInfo", t =>
                    b.ToTable("UserInfo", null, t =>
                        {
                            t.HasComment("用户信息");
                        });
@@ -1327,7 +1418,7 @@

                    b.HasIndex("UserInfoId");

                    b.ToTable("UserInfoBankCard", t =>
                    b.ToTable("UserInfoBankCard", null, t =>
                        {
                            t.HasComment("用户银行卡信息");
                        });
@@ -1413,7 +1504,7 @@

                    b.HasIndex("UserInfoId");

                    b.ToTable("UserInfoCredential", t =>
                    b.ToTable("UserInfoCredential", null, t =>
                        {
                            t.HasComment("用户信息资格证书");
                        });
@@ -1465,7 +1556,7 @@

                    b.HasIndex("UserInfoId");

                    b.ToTable("UserInfoDepartment", t =>
                    b.ToTable("UserInfoDepartment", null, t =>
                        {
                            t.HasComment("用户信息部门");
                        });
@@ -1517,7 +1608,7 @@

                    b.HasIndex("UserInfoId");

                    b.ToTable("UserInfoExpectJob", t =>
                    b.ToTable("UserInfoExpectJob", null, t =>
                        {
                            t.HasComment("用户信息期望岗位");
                        });
@@ -1569,7 +1660,7 @@

                    b.HasIndex("UserInfoId");

                    b.ToTable("UserInfoPhoto", t =>
                    b.ToTable("UserInfoPhoto", null, t =>
                        {
                            t.HasComment("用户信息生活照");
                        });
@@ -1621,71 +1712,9 @@

                    b.HasIndex("UserInfoId");

                    b.ToTable("UserInfoRole", t =>
                    b.ToTable("UserInfoRole", null, t =>
                        {
                            t.HasComment("用户信息角色");
                        });
                });

            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("接口");
                        });
                });

@@ -1783,21 +1812,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");
                });
@@ -2082,7 +2111,7 @@
                {
                    b.Navigation("RoleMenus");

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

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