From 1482f950f2b30835a268ae9e6c6bd817ba47a684 Mon Sep 17 00:00:00 2001 From: sunpengfei <i@angelzzz.com> Date: 星期四, 11 九月 2025 11:13:02 +0800 Subject: [PATCH] feat:开发 --- FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs | 420 +++++++++++++++++++++++++++++++++++++++++++++++++++++------ 1 files changed, 374 insertions(+), 46 deletions(-) diff --git a/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs b/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs index 7198f9d..ed848a4 100644 --- a/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs +++ b/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs @@ -22,6 +22,68 @@ SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder); + modelBuilder.Entity("FlexJobApi.Core.CodeUrl", b => + { + b.Property<Guid>("Id") + .ValueGeneratedOnAdd() + .HasColumnType("uniqueidentifier"); + + b.Property<string>("Code") + .HasColumnType("nvarchar(max)"); + + b.Property<Guid?>("CreatedEnterpriseId") + .HasColumnType("uniqueidentifier"); + + b.Property<DateTimeOffset>("CreatedTime") + .HasColumnType("datetimeoffset"); + + b.Property<Guid?>("CreatedUserId") + .HasColumnType("uniqueidentifier"); + + b.Property<DateTime?>("ExpiredTime") + .HasColumnType("datetime2"); + + b.Property<bool>("IsDeleted") + .HasColumnType("bit"); + + b.Property<string>("ParamValue1") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("ParamValue2") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("ParamValue3") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("ParamValue4") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("ParamValue5") + .HasColumnType("nvarchar(max)"); + + b.Property<int>("Scene") + .HasColumnType("int"); + + b.Property<int>("Sort") + .HasColumnType("int"); + + b.Property<string>("TraceId") + .HasColumnType("nvarchar(max)"); + + b.Property<DateTimeOffset?>("UpdatedTime") + .HasColumnType("datetimeoffset"); + + b.Property<Guid?>("UpdatedUserId") + .HasColumnType("uniqueidentifier"); + + b.Property<string>("Url") + .HasColumnType("nvarchar(max)"); + + b.HasKey("Id"); + + b.ToTable("CodeUrl"); + }); + modelBuilder.Entity("FlexJobApi.Core.ContractTemplate", b => { b.Property<Guid>("Id") @@ -98,7 +160,7 @@ b.HasIndex("EnterpriseId"); - b.ToTable("ContractTemplate", (string)null); + b.ToTable("ContractTemplate"); }); modelBuilder.Entity("FlexJobApi.Core.ContractTemplateValue", b => @@ -159,7 +221,7 @@ b.HasIndex("TemplateId"); - b.ToTable("ContractTemplateValue", (string)null); + b.ToTable("ContractTemplateValue"); }); modelBuilder.Entity("FlexJobApi.Core.Department", b => @@ -217,7 +279,7 @@ b.HasIndex("ParentId"); - b.ToTable("Department", (string)null); + b.ToTable("Department"); }); modelBuilder.Entity("FlexJobApi.Core.DictionaryCategory", b => @@ -268,7 +330,7 @@ b.HasKey("Id"); - b.ToTable("DictionaryCategory", (string)null); + b.ToTable("DictionaryCategory"); }); modelBuilder.Entity("FlexJobApi.Core.DictionaryData", b => @@ -349,7 +411,7 @@ b.HasIndex("ParentId"); - b.ToTable("DictionaryData", (string)null); + b.ToTable("DictionaryData"); }); modelBuilder.Entity("FlexJobApi.Core.ElectronSignSetting", b => @@ -399,7 +461,7 @@ b.HasKey("Id"); - b.ToTable("ElectronSignSetting", (string)null); + b.ToTable("ElectronSignSetting"); }); modelBuilder.Entity("FlexJobApi.Core.Enterprise", b => @@ -527,7 +589,7 @@ b.HasIndex("ProvinceCode"); - b.ToTable("Enterprise", (string)null); + b.ToTable("Enterprise"); }); modelBuilder.Entity("FlexJobApi.Core.EnterpriseAuth", b => @@ -626,7 +688,7 @@ b.HasKey("Id"); - b.ToTable("EnterpriseAuth", (string)null); + b.ToTable("EnterpriseAuth"); }); modelBuilder.Entity("FlexJobApi.Core.EnterpriseCost", b => @@ -680,7 +742,7 @@ b.HasIndex("EnterpriseId"); - b.ToTable("EnterpriseCost", (string)null); + b.ToTable("EnterpriseCost"); }); modelBuilder.Entity("FlexJobApi.Core.EnterpriseElectronSignSetting", b => @@ -723,7 +785,7 @@ b.HasIndex("EnterpriseId"); - b.ToTable("EnterpriseElectronSignSetting", (string)null); + b.ToTable("EnterpriseElectronSignSetting"); }); modelBuilder.Entity("FlexJobApi.Core.EnterpriseEmployee", b => @@ -823,7 +885,7 @@ b.HasIndex("UserId"); - b.ToTable("EnterpriseEmployee", (string)null); + b.ToTable("EnterpriseEmployee"); }); modelBuilder.Entity("FlexJobApi.Core.EnterpriseEmployeeContract", b => @@ -892,7 +954,7 @@ b.HasIndex("EnterpriseEmployeeId"); - b.ToTable("EnterpriseEmployeeContract", (string)null); + b.ToTable("EnterpriseEmployeeContract"); }); modelBuilder.Entity("FlexJobApi.Core.EnterpriseUserCollect", b => @@ -949,7 +1011,7 @@ b.HasIndex("UserId"); - b.ToTable("EnterpriseUserCollect", (string)null); + b.ToTable("EnterpriseUserCollect"); }); modelBuilder.Entity("FlexJobApi.Core.EnterpriseWallet", b => @@ -1012,6 +1074,15 @@ b.Property<Guid>("EnterpriseId") .HasColumnType("uniqueidentifier"); + b.Property<string>("ErrorCode") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("FailReason") + .HasColumnType("nvarchar(max)"); + + b.Property<decimal>("FreezeBalance") + .HasColumnType("decimal(18,2)"); + b.Property<DateTime?>("InvalidTime") .HasColumnType("datetime2"); @@ -1067,7 +1138,7 @@ b.HasIndex("EnterpriseId"); - b.ToTable("EnterpriseWallet", (string)null); + b.ToTable("EnterpriseWallet"); }); modelBuilder.Entity("FlexJobApi.Core.EnterpriseWalletExpandindirectOrder", b => @@ -1164,7 +1235,7 @@ b.HasIndex("WalletId"); - b.ToTable("EnterpriseWalletExpandindirectOrder", (string)null); + b.ToTable("EnterpriseWalletExpandindirectOrder"); }); modelBuilder.Entity("FlexJobApi.Core.EnterpriseWalletExpandindirectOrderFile", b => @@ -1210,7 +1281,7 @@ b.HasIndex("OrderId"); - b.ToTable("EnterpriseWalletExpandindirectOrderFile", (string)null); + b.ToTable("EnterpriseWalletExpandindirectOrderFile"); }); modelBuilder.Entity("FlexJobApi.Core.EnterpriseWalletTransaction", b => @@ -1218,6 +1289,9 @@ b.Property<Guid>("Id") .ValueGeneratedOnAdd() .HasColumnType("uniqueidentifier"); + + b.Property<decimal>("AfterBalance") + .HasColumnType("decimal(18,2)"); b.Property<decimal>("Amount") .HasColumnType("decimal(18,2)"); @@ -1267,6 +1341,12 @@ b.Property<string>("Link") .HasColumnType("nvarchar(max)"); + b.Property<DateTime?>("OperatorTime") + .HasColumnType("datetime2"); + + b.Property<Guid?>("OperatorUserId") + .HasColumnType("uniqueidentifier"); + b.Property<decimal?>("OrderFee") .HasColumnType("decimal(18,2)"); @@ -1278,6 +1358,15 @@ b.Property<string>("ProductCode") .HasColumnType("nvarchar(max)"); + + b.Property<string>("ReceiveAccount") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("ReceiveName") + .HasColumnType("nvarchar(max)"); + + b.Property<Guid?>("ReceiveUserId") + .HasColumnType("uniqueidentifier"); b.Property<string>("ReceiverOpenId") .HasColumnType("nvarchar(max)"); @@ -1299,6 +1388,9 @@ b.Property<string>("SubStatus") .HasColumnType("nvarchar(max)"); + + b.Property<Guid?>("TaskUserId") + .HasColumnType("uniqueidentifier"); b.Property<string>("TraceId") .HasColumnType("nvarchar(max)"); @@ -1323,9 +1415,15 @@ b.HasKey("Id"); + b.HasIndex("OperatorUserId"); + + b.HasIndex("ReceiveUserId"); + + b.HasIndex("TaskUserId"); + b.HasIndex("WalletId"); - b.ToTable("EnterpriseWalletTransaction", (string)null); + b.ToTable("EnterpriseWalletTransaction"); }); modelBuilder.Entity("FlexJobApi.Core.Menu", b => @@ -1413,7 +1511,7 @@ b.HasIndex("ParentId"); - b.ToTable("Menu", (string)null); + b.ToTable("Menu"); }); modelBuilder.Entity("FlexJobApi.Core.Resource", b => @@ -1513,7 +1611,7 @@ b.HasKey("Id"); - b.ToTable("Resource", (string)null); + b.ToTable("Resource"); }); modelBuilder.Entity("FlexJobApi.Core.Role", b => @@ -1571,7 +1669,7 @@ b.HasKey("Id"); - b.ToTable("Role", (string)null); + b.ToTable("Role"); }); modelBuilder.Entity("FlexJobApi.Core.RoleMenu", b => @@ -1616,7 +1714,7 @@ b.HasIndex("RoleId"); - b.ToTable("RoleMenu", (string)null); + b.ToTable("RoleMenu"); }); modelBuilder.Entity("FlexJobApi.Core.RoleResource", b => @@ -1664,7 +1762,7 @@ b.HasIndex("RoleId"); - b.ToTable("RoleResource", (string)null); + b.ToTable("RoleResource"); }); modelBuilder.Entity("FlexJobApi.Core.ScheduleJobDetail", b => @@ -1723,7 +1821,7 @@ b.HasKey("Id"); - b.ToTable("ScheduleJobDetail", (string)null); + b.ToTable("ScheduleJobDetail"); }); modelBuilder.Entity("FlexJobApi.Core.ScheduleJobTrigger", b => @@ -1824,7 +1922,7 @@ b.HasKey("Id"); - b.ToTable("ScheduleJobTrigger", (string)null); + b.ToTable("ScheduleJobTrigger"); }); modelBuilder.Entity("FlexJobApi.Core.TaskInfo", b => @@ -1924,6 +2022,9 @@ b.Property<int>("SettlementCycle") .HasColumnType("int"); + b.Property<Guid?>("SettlementOperatorUserId") + .HasColumnType("uniqueidentifier"); + b.Property<string>("SettlementOrderName") .HasColumnType("nvarchar(max)"); @@ -1974,7 +2075,9 @@ b.HasIndex("ProvinceCode"); - b.ToTable("TaskInfo", (string)null); + b.HasIndex("SettlementOperatorUserId"); + + b.ToTable("TaskInfo"); }); modelBuilder.Entity("FlexJobApi.Core.TaskInfoBenefit", b => @@ -2020,7 +2123,7 @@ b.HasIndex("TaskInfoId"); - b.ToTable("TaskInfoBenefit", (string)null); + b.ToTable("TaskInfoBenefit"); }); modelBuilder.Entity("FlexJobApi.Core.TaskInfoCredentialLimit", b => @@ -2066,7 +2169,7 @@ b.HasIndex("TypeCode"); - b.ToTable("TaskInfoCredentialLimit", (string)null); + b.ToTable("TaskInfoCredentialLimit"); }); modelBuilder.Entity("FlexJobApi.Core.TaskInfoUser", b => @@ -2074,6 +2177,9 @@ b.Property<Guid>("Id") .ValueGeneratedOnAdd() .HasColumnType("uniqueidentifier"); + + b.Property<decimal>("ActualAmount") + .HasColumnType("decimal(18,2)"); b.Property<decimal?>("ActualSettlementAmount") .HasColumnType("decimal(18,2)"); @@ -2162,7 +2268,7 @@ b.HasIndex("TaskInfoId"); - b.ToTable("TaskInfoUser", (string)null); + b.ToTable("TaskInfoUser"); }); modelBuilder.Entity("FlexJobApi.Core.TaskInfoUserSubmit", b => @@ -2211,7 +2317,7 @@ b.HasIndex("TaskInfoUserId"); - b.ToTable("TaskInfoUserSubmit", (string)null); + b.ToTable("TaskInfoUserSubmit"); }); modelBuilder.Entity("FlexJobApi.Core.TaskInfoUserSubmitFile", b => @@ -2255,7 +2361,7 @@ b.HasIndex("SubmitId"); - b.ToTable("TaskInfoUserSubmitFile", (string)null); + b.ToTable("TaskInfoUserSubmitFile"); }); modelBuilder.Entity("FlexJobApi.Core.TaskUserCollect", b => @@ -2300,7 +2406,7 @@ b.HasIndex("UserId"); - b.ToTable("TaskUserCollect", (string)null); + b.ToTable("TaskUserCollect"); }); modelBuilder.Entity("FlexJobApi.Core.User", b => @@ -2447,7 +2553,7 @@ b.HasIndex("ProvinceCode"); - b.ToTable("User", (string)null); + b.ToTable("User"); b.HasData( new @@ -2531,6 +2637,9 @@ b.Property<string>("RealFailMessage") .HasColumnType("nvarchar(max)"); + b.Property<DateTime?>("RealInProcessStartTime") + .HasColumnType("datetime2"); + b.Property<int>("RealStatus") .HasColumnType("int"); @@ -2548,7 +2657,7 @@ b.HasKey("Id"); - b.ToTable("UserAuth", (string)null); + b.ToTable("UserAuth"); }); modelBuilder.Entity("FlexJobApi.Core.UserBankCard", b => @@ -2556,6 +2665,9 @@ b.Property<Guid>("Id") .ValueGeneratedOnAdd() .HasColumnType("uniqueidentifier"); + + b.Property<int>("Access") + .HasColumnType("int"); b.Property<string>("Bank") .HasColumnType("nvarchar(max)"); @@ -2576,14 +2688,8 @@ b.Property<Guid?>("CreatedUserId") .HasColumnType("uniqueidentifier"); - b.Property<string>("Identity") - .HasColumnType("nvarchar(max)"); - b.Property<bool>("IsDeleted") .HasColumnType("bit"); - - b.Property<string>("Name") - .HasColumnType("nvarchar(max)"); b.Property<string>("PhoneNumber") .HasMaxLength(11) @@ -2608,7 +2714,7 @@ b.HasIndex("UserId"); - b.ToTable("UserBankCard", (string)null); + b.ToTable("UserBankCard"); }); modelBuilder.Entity("FlexJobApi.Core.UserCredential", b => @@ -2676,7 +2782,7 @@ b.HasIndex("UserId"); - b.ToTable("UserCredential", (string)null); + b.ToTable("UserCredential"); }); modelBuilder.Entity("FlexJobApi.Core.UserDepartment", b => @@ -2721,7 +2827,7 @@ b.HasIndex("UserId"); - b.ToTable("UserDepartment", (string)null); + b.ToTable("UserDepartment"); }); modelBuilder.Entity("FlexJobApi.Core.UserExpectJob", b => @@ -2767,7 +2873,7 @@ b.HasIndex("UserId"); - b.ToTable("UserExpectJob", (string)null); + b.ToTable("UserExpectJob"); }); modelBuilder.Entity("FlexJobApi.Core.UserManageIndustrialPark", b => @@ -2810,7 +2916,7 @@ b.HasIndex("UserId"); - b.ToTable("UserManageIndustrialPark", (string)null); + b.ToTable("UserManageIndustrialPark"); }); modelBuilder.Entity("FlexJobApi.Core.UserPhoto", b => @@ -2853,7 +2959,7 @@ b.HasIndex("UserId"); - b.ToTable("UserPhoto", (string)null); + b.ToTable("UserPhoto"); }); modelBuilder.Entity("FlexJobApi.Core.UserRole", b => @@ -2898,7 +3004,165 @@ b.HasIndex("UserId"); - b.ToTable("UserRole", (string)null); + b.ToTable("UserRole"); + }); + + modelBuilder.Entity("FlexJobApi.Core.UserWallet", b => + { + b.Property<Guid>("Id") + .ValueGeneratedOnAdd() + .HasColumnType("uniqueidentifier"); + + b.Property<decimal>("Balance") + .HasColumnType("decimal(18,2)"); + + b.Property<Guid?>("CreatedEnterpriseId") + .HasColumnType("uniqueidentifier"); + + b.Property<DateTimeOffset>("CreatedTime") + .HasColumnType("datetimeoffset"); + + b.Property<Guid?>("CreatedUserId") + .HasColumnType("uniqueidentifier"); + + b.Property<bool>("IsDeleted") + .HasColumnType("bit"); + + b.Property<int>("Sort") + .HasColumnType("int"); + + b.Property<string>("TraceId") + .HasColumnType("nvarchar(max)"); + + b.Property<DateTimeOffset?>("UpdatedTime") + .HasColumnType("datetimeoffset"); + + b.Property<Guid?>("UpdatedUserId") + .HasColumnType("uniqueidentifier"); + + b.Property<Guid>("UserId") + .HasColumnType("uniqueidentifier"); + + b.HasKey("Id"); + + b.HasIndex("UserId"); + + b.ToTable("UserWallet"); + }); + + modelBuilder.Entity("FlexJobApi.Core.UserWalletTransaction", b => + { + b.Property<Guid>("Id") + .ValueGeneratedOnAdd() + .HasColumnType("uniqueidentifier"); + + b.Property<decimal>("ActualAmount") + .HasColumnType("decimal(18,2)"); + + b.Property<decimal>("AfterBalance") + .HasColumnType("decimal(18,2)"); + + b.Property<decimal>("Amount") + .HasColumnType("decimal(18,2)"); + + b.Property<DateTime?>("ArrivalTimeEnd") + .HasColumnType("datetime2"); + + b.Property<decimal>("Balance") + .HasColumnType("decimal(18,2)"); + + b.Property<string>("Code") + .HasColumnType("nvarchar(max)"); + + b.Property<Guid?>("CreatedEnterpriseId") + .HasColumnType("uniqueidentifier"); + + b.Property<DateTimeOffset>("CreatedTime") + .HasColumnType("datetimeoffset"); + + b.Property<Guid?>("CreatedUserId") + .HasColumnType("uniqueidentifier"); + + b.Property<string>("EnterpriseName") + .HasColumnType("nvarchar(max)"); + + b.Property<Guid?>("EnterpriseWalletTransactionId") + .HasColumnType("uniqueidentifier"); + + b.Property<string>("ErrorCode") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("FailReason") + .HasColumnType("nvarchar(max)"); + + b.Property<bool>("IsDeleted") + .HasColumnType("bit"); + + b.Property<DateTime?>("OperatorTime") + .HasColumnType("datetime2"); + + b.Property<Guid?>("OperatorUserId") + .HasColumnType("uniqueidentifier"); + + b.Property<string>("ReceiveAccount") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("ReceiveName") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("Remark") + .HasColumnType("nvarchar(max)"); + + b.Property<decimal>("ServiceFee") + .HasColumnType("decimal(18,2)"); + + b.Property<decimal?>("SettlementAmount") + .HasColumnType("decimal(18,2)"); + + b.Property<DateTime?>("SettlementTime") + .HasColumnType("datetime2"); + + b.Property<int>("Sort") + .HasColumnType("int"); + + b.Property<Guid?>("TaskUserId") + .HasColumnType("uniqueidentifier"); + + b.Property<string>("Title") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("TraceId") + .HasColumnType("nvarchar(max)"); + + b.Property<DateTime?>("TransDate") + .HasColumnType("datetime2"); + + b.Property<int>("TransactionStatus") + .HasColumnType("int"); + + b.Property<int>("Type") + .HasColumnType("int"); + + b.Property<DateTimeOffset?>("UpdatedTime") + .HasColumnType("datetimeoffset"); + + b.Property<Guid?>("UpdatedUserId") + .HasColumnType("uniqueidentifier"); + + b.Property<Guid>("WalletId") + .HasColumnType("uniqueidentifier"); + + b.HasKey("Id"); + + b.HasIndex("EnterpriseWalletTransactionId"); + + b.HasIndex("OperatorUserId"); + + b.HasIndex("TaskUserId"); + + b.HasIndex("WalletId"); + + b.ToTable("UserWalletTransaction"); }); modelBuilder.Entity("FlexJobApi.Core.ContractTemplate", b => @@ -3117,11 +3381,29 @@ modelBuilder.Entity("FlexJobApi.Core.EnterpriseWalletTransaction", b => { + b.HasOne("FlexJobApi.Core.User", "OperatorUser") + .WithMany() + .HasForeignKey("OperatorUserId"); + + b.HasOne("FlexJobApi.Core.User", "ReceiveUser") + .WithMany() + .HasForeignKey("ReceiveUserId"); + + b.HasOne("FlexJobApi.Core.TaskInfoUser", "TaskUser") + .WithMany() + .HasForeignKey("TaskUserId"); + b.HasOne("FlexJobApi.Core.EnterpriseWallet", "Wallet") .WithMany() .HasForeignKey("WalletId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); + + b.Navigation("OperatorUser"); + + b.Navigation("ReceiveUser"); + + b.Navigation("TaskUser"); b.Navigation("Wallet"); }); @@ -3193,11 +3475,17 @@ .HasPrincipalKey("Code") .OnDelete(DeleteBehavior.Restrict); + b.HasOne("FlexJobApi.Core.User", "SettlementOperatorUser") + .WithMany() + .HasForeignKey("SettlementOperatorUserId"); + b.Navigation("City"); b.Navigation("Enterprise"); b.Navigation("Province"); + + b.Navigation("SettlementOperatorUser"); }); modelBuilder.Entity("FlexJobApi.Core.TaskInfoBenefit", b => @@ -3463,6 +3751,46 @@ b.Navigation("User"); }); + modelBuilder.Entity("FlexJobApi.Core.UserWallet", b => + { + b.HasOne("FlexJobApi.Core.User", "User") + .WithMany() + .HasForeignKey("UserId") + .OnDelete(DeleteBehavior.Cascade) + .IsRequired(); + + b.Navigation("User"); + }); + + modelBuilder.Entity("FlexJobApi.Core.UserWalletTransaction", b => + { + b.HasOne("FlexJobApi.Core.EnterpriseWalletTransaction", "EnterpriseWalletTransaction") + .WithMany() + .HasForeignKey("EnterpriseWalletTransactionId"); + + b.HasOne("FlexJobApi.Core.User", "OperatorUser") + .WithMany() + .HasForeignKey("OperatorUserId"); + + b.HasOne("FlexJobApi.Core.TaskInfoUser", "TaskUser") + .WithMany() + .HasForeignKey("TaskUserId"); + + b.HasOne("FlexJobApi.Core.UserWallet", "Wallet") + .WithMany() + .HasForeignKey("WalletId") + .OnDelete(DeleteBehavior.Cascade) + .IsRequired(); + + b.Navigation("EnterpriseWalletTransaction"); + + b.Navigation("OperatorUser"); + + b.Navigation("TaskUser"); + + b.Navigation("Wallet"); + }); + modelBuilder.Entity("FlexJobApi.Core.ContractTemplate", b => { b.Navigation("Values"); -- Gitblit v1.9.1