From 313c5cbe5c63fa07f78fa24d8cc33b75435a266f Mon Sep 17 00:00:00 2001
From: sunpengfei <i@angelzzz.com>
Date: 星期四, 07 八月 2025 17:00:40 +0800
Subject: [PATCH] feat:字典优化
---
FlexJobApi.Database.Migrations/Migrations/20250807085934_UpdateDictionaryData0807.Designer.cs | 1844 ++++++++++++++++++++++++++++++++++++++++++++++++++++++
FlexJobApi.Database.Migrations/Migrations/20250807085934_UpdateDictionaryData0807.cs | 61 +
FlexJobApi.Core/Entities/Common/DictionaryData.cs | 5
FlexJobApi.Core/Models/Main/Tasks/Queries/GetTaskInfosQuery.cs | 21
FlexJobApi.Application/Dictionaries/Queries/DictionaryDatasQueryHandler.cs | 4
FlexJobApi.Core/FlexJobApi.Core.xml | 25
FlexJobApi.Application/Tasks/Queries/TaskInfoQueryHandler.cs | 19
FlexJobApi.Database.Migrations/REDEME.MD | 2
FlexJobApi.Application/FlexJobApi.Application.xml | 8
FlexJobApi.Core/Utils/DistributedCacheUtils/DistributedCacheServiceComponent.cs | 1
FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs | 12
11 files changed, 1,999 insertions(+), 3 deletions(-)
diff --git a/FlexJobApi.Application/Dictionaries/Queries/DictionaryDatasQueryHandler.cs b/FlexJobApi.Application/Dictionaries/Queries/DictionaryDatasQueryHandler.cs
index ce569c1..7e064f7 100644
--- a/FlexJobApi.Application/Dictionaries/Queries/DictionaryDatasQueryHandler.cs
+++ b/FlexJobApi.Application/Dictionaries/Queries/DictionaryDatasQueryHandler.cs
@@ -85,6 +85,10 @@
{
q = q.Where(it => it.ParentId == request.ParentId);
}
+ if (request.CategoryCode == "70" || request.CategoryId == new Guid("B21FE000-BB7F-4498-08E9-08DDD572EF73"))
+ {
+ q = q.Where(it => it.Deep <= 3);
+ }
if (request.Keywords.IsNotNull())
{
q = q.Where(it =>
diff --git a/FlexJobApi.Application/FlexJobApi.Application.xml b/FlexJobApi.Application/FlexJobApi.Application.xml
index e8cce9e..d060bfd 100644
--- a/FlexJobApi.Application/FlexJobApi.Application.xml
+++ b/FlexJobApi.Application/FlexJobApi.Application.xml
@@ -162,5 +162,13 @@
<param name="cancellationToken"></param>
<returns></returns>
</member>
+ <member name="M:FlexJobApi.Application.TaskInfoQueryHandler.Handle(FlexJobApi.Core.GetTaskInfosQuery,System.Threading.CancellationToken)">
+ <summary>
+ 鏌ヨ浠诲姟鍒嗛〉鍒楄〃
+ </summary>
+ <param name="request"></param>
+ <param name="cancellationToken"></param>
+ <returns></returns>
+ </member>
</members>
</doc>
diff --git a/FlexJobApi.Application/Tasks/Queries/TaskInfoQueryHandler.cs b/FlexJobApi.Application/Tasks/Queries/TaskInfoQueryHandler.cs
index adc9d1b..f3fc70b 100644
--- a/FlexJobApi.Application/Tasks/Queries/TaskInfoQueryHandler.cs
+++ b/FlexJobApi.Application/Tasks/Queries/TaskInfoQueryHandler.cs
@@ -1,5 +1,6 @@
锘縰sing FlexJobApi.Core;
using Furion.DatabaseAccessor;
+using Furion.FriendlyException;
using Mapster;
using MediatR;
using Microsoft.EntityFrameworkCore;
@@ -16,8 +17,10 @@
/// </summary>
public class TaskInfoQueryHandler(
IRepository<TaskInfo> rep
- )
- : IRequestHandler<GetTaskInfoQuery, GetTaskInfoQueryResult>
+ ) :
+ IRequestHandler<GetTaskInfoQuery, GetTaskInfoQueryResult>,
+ IRequestHandler<GetTaskInfosQuery, PagedListQueryResult<GetTaskInfosQueryResultItem>>
+
{
private readonly IRepository<TaskInfo> rep = rep;
@@ -33,5 +36,17 @@
.ProjectToType<GetTaskInfoQueryResult>()
.FirstOrDefaultAsync(cancellationToken);
}
+
+ /// <summary>
+ /// 鏌ヨ浠诲姟鍒嗛〉鍒楄〃
+ /// </summary>
+ /// <param name="request"></param>
+ /// <param name="cancellationToken"></param>
+ /// <returns></returns>
+ public Task<PagedListQueryResult<GetTaskInfosQueryResultItem>> Handle(GetTaskInfosQuery request, CancellationToken cancellationToken)
+ {
+ //return request.PageModel.GetPagedListAsync<TaskInfo, >()
+ throw new Exception();
+ }
}
}
diff --git a/FlexJobApi.Core/Entities/Common/DictionaryData.cs b/FlexJobApi.Core/Entities/Common/DictionaryData.cs
index b7d1383..13f5c64 100644
--- a/FlexJobApi.Core/Entities/Common/DictionaryData.cs
+++ b/FlexJobApi.Core/Entities/Common/DictionaryData.cs
@@ -89,6 +89,11 @@
public string Field5 { get; set; }
/// <summary>
+ /// 娣卞害
+ /// </summary>
+ public int Deep { get; set; }
+
+ /// <summary>
/// 鏄惁绂佺敤
/// </summary>
public bool IsDisabled { get; set; }
diff --git a/FlexJobApi.Core/FlexJobApi.Core.xml b/FlexJobApi.Core/FlexJobApi.Core.xml
index 666c230..f4271d6 100644
--- a/FlexJobApi.Core/FlexJobApi.Core.xml
+++ b/FlexJobApi.Core/FlexJobApi.Core.xml
@@ -159,6 +159,11 @@
瀛楁5
</summary>
</member>
+ <member name="P:FlexJobApi.Core.DictionaryData.Deep">
+ <summary>
+ 娣卞害
+ </summary>
+ </member>
<member name="P:FlexJobApi.Core.DictionaryData.IsDisabled">
<summary>
鏄惁绂佺敤
@@ -2925,6 +2930,26 @@
鎶ュ悕浜烘暟
</summary>
</member>
+ <member name="P:FlexJobApi.Core.GetTaskInfosQueryResultItem.Status">
+ <summary>
+ 浠诲姟鐘舵��
+ </summary>
+ </member>
+ <member name="P:FlexJobApi.Core.GetTaskInfosQueryResultItem.BeginTime">
+ <summary>
+ 浠诲姟寮�濮嬫椂闂�
+ </summary>
+ </member>
+ <member name="P:FlexJobApi.Core.GetTaskInfosQueryResultItem.EndTime">
+ <summary>
+ 浠诲姟缁撴潫鏃堕棿
+ </summary>
+ </member>
+ <member name="P:FlexJobApi.Core.GetTaskInfosQueryResultItem.ReleaseStatus">
+ <summary>
+ 鍙戝竷鐘舵��
+ </summary>
+ </member>
<member name="T:FlexJobApi.Core.TaskInfoQueryable">
<summary>
浠诲姟鏌ヨ
diff --git a/FlexJobApi.Core/Models/Main/Tasks/Queries/GetTaskInfosQuery.cs b/FlexJobApi.Core/Models/Main/Tasks/Queries/GetTaskInfosQuery.cs
index 1a490d5..655a275 100644
--- a/FlexJobApi.Core/Models/Main/Tasks/Queries/GetTaskInfosQuery.cs
+++ b/FlexJobApi.Core/Models/Main/Tasks/Queries/GetTaskInfosQuery.cs
@@ -74,5 +74,26 @@
/// 鎶ュ悕浜烘暟
/// </summary>
public int UserCount { get; set; }
+
+ /// <summary>
+ /// 浠诲姟鐘舵��
+ /// </summary>
+ public EnumTaskStatus Status { get; set; }
+
+ /// <summary>
+ /// 浠诲姟寮�濮嬫椂闂�
+ /// </summary>
+ public DateTime BeginTime { get; set; }
+
+ /// <summary>
+ /// 浠诲姟缁撴潫鏃堕棿
+ /// </summary>
+ public DateTime EndTime { get; set; }
+
+ /// <summary>
+ /// 鍙戝竷鐘舵��
+ /// </summary>
+ public EnumTaskReleaseStatus ReleaseStatus { get; set; }
+
}
}
diff --git a/FlexJobApi.Core/Utils/DistributedCacheUtils/DistributedCacheServiceComponent.cs b/FlexJobApi.Core/Utils/DistributedCacheUtils/DistributedCacheServiceComponent.cs
index 5c991f9..eae0f21 100644
--- a/FlexJobApi.Core/Utils/DistributedCacheUtils/DistributedCacheServiceComponent.cs
+++ b/FlexJobApi.Core/Utils/DistributedCacheUtils/DistributedCacheServiceComponent.cs
@@ -1,5 +1,6 @@
锘縰sing Furion;
using Microsoft.Extensions.DependencyInjection;
+using StackExchange.Redis;
using System;
using System.Collections.Generic;
using System.Linq;
diff --git a/FlexJobApi.Database.Migrations/Migrations/20250807085934_UpdateDictionaryData0807.Designer.cs b/FlexJobApi.Database.Migrations/Migrations/20250807085934_UpdateDictionaryData0807.Designer.cs
new file mode 100644
index 0000000..c245794
--- /dev/null
+++ b/FlexJobApi.Database.Migrations/Migrations/20250807085934_UpdateDictionaryData0807.Designer.cs
@@ -0,0 +1,1844 @@
+锘�// <auto-generated />
+using System;
+using FlexJobApi.EntityFramework.Core;
+using Microsoft.EntityFrameworkCore;
+using Microsoft.EntityFrameworkCore.Infrastructure;
+using Microsoft.EntityFrameworkCore.Metadata;
+using Microsoft.EntityFrameworkCore.Migrations;
+using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
+
+#nullable disable
+
+namespace FlexJobApi.Database.Migrations.Migrations
+{
+ [DbContext(typeof(DefaultDbContext))]
+ [Migration("20250807085934_UpdateDictionaryData0807")]
+ partial class UpdateDictionaryData0807
+ {
+ /// <inheritdoc />
+ protected override void BuildTargetModel(ModelBuilder modelBuilder)
+ {
+#pragma warning disable 612, 618
+ modelBuilder
+ .HasAnnotation("ProductVersion", "9.0.7")
+ .HasAnnotation("Relational:MaxIdentifierLength", 128);
+
+ SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder);
+
+ modelBuilder.Entity("FlexJobApi.Core.Department", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<Guid>("EnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<bool>("IsDisabled")
+ .HasColumnType("bit");
+
+ b.Property<string>("Name")
+ .IsRequired()
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<Guid?>("ParentId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("Path")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("Remark")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<string>("TraceId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<DateTimeOffset?>("UpdatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("UpdatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.HasIndex("EnterpriseId");
+
+ b.HasIndex("ParentId");
+
+ b.ToTable("Department");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.DictionaryCategory", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("Code")
+ .IsRequired()
+ .HasMaxLength(128)
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("FieldNames")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<string>("Name")
+ .IsRequired()
+ .HasMaxLength(128)
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<string>("Remark")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<string>("TraceId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<DateTimeOffset?>("UpdatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("UpdatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.ToTable("DictionaryCategory");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.DictionaryData", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<Guid>("CategoryId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("Code")
+ .IsRequired()
+ .HasMaxLength(128)
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<string>("Content")
+ .IsRequired()
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<int>("Deep")
+ .HasColumnType("int");
+
+ b.Property<string>("Field1")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("Field2")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("Field3")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("Field4")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("Field5")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<bool>("IsDisabled")
+ .HasColumnType("bit");
+
+ b.Property<Guid?>("ParentId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("Path")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<string>("TraceId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<DateTimeOffset?>("UpdatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("UpdatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.HasIndex("CategoryId");
+
+ b.HasIndex("Code")
+ .IsUnique();
+
+ b.HasIndex("ParentId");
+
+ b.ToTable("DictionaryData");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.Enterprise", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("BankBranchName")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("BankCard")
+ .HasMaxLength(32)
+ .HasColumnType("nvarchar(32)");
+
+ b.Property<string>("BankName")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("CityCode")
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<string>("ContactEmail")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("ContactPhoneNumber")
+ .HasMaxLength(11)
+ .HasColumnType("nvarchar(11)");
+
+ b.Property<string>("Contacts")
+ .HasMaxLength(32)
+ .HasColumnType("nvarchar(32)");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<Guid>("EnterpriseAuthId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("IndustryTypeCode")
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<bool>("IsCheckedBankCard")
+ .HasColumnType("bit");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<string>("MainBusiness")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<decimal?>("MergeSignCost")
+ .HasColumnType("decimal(18,2)");
+
+ b.Property<int?>("PayAccess")
+ .HasColumnType("int");
+
+ b.Property<string>("ProvinceCode")
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<int?>("RealAccess")
+ .HasColumnType("int");
+
+ b.Property<decimal?>("RealVerifyCost")
+ .HasColumnType("decimal(18,2)");
+
+ b.Property<decimal?>("SignCost")
+ .HasColumnType("decimal(18,2)");
+
+ b.Property<int?>("SmsAccess")
+ .HasColumnType("int");
+
+ b.Property<decimal>("SmsCost")
+ .HasColumnType("decimal(18,2)");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<string>("TraceId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<DateTimeOffset?>("UpdatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("UpdatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.HasIndex("CityCode");
+
+ b.HasIndex("EnterpriseAuthId");
+
+ b.HasIndex("IndustryTypeCode");
+
+ b.HasIndex("ProvinceCode");
+
+ b.ToTable("Enterprise");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.EnterpriseAuth", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("BankCard")
+ .HasMaxLength(32)
+ .HasColumnType("nvarchar(32)");
+
+ b.Property<string>("BankCardImg")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("EnterpriseName")
+ .IsRequired()
+ .HasMaxLength(128)
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<int?>("EnterpriseRealMethod")
+ .HasColumnType("int");
+
+ b.Property<string>("Identity")
+ .HasMaxLength(18)
+ .HasColumnType("nvarchar(18)");
+
+ b.Property<string>("IdentityBackImg")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("IdentityImg")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<bool>("IsReal")
+ .HasColumnType("bit");
+
+ b.Property<string>("LegalIdentity")
+ .HasMaxLength(18)
+ .HasColumnType("nvarchar(18)");
+
+ b.Property<string>("LegalPerson")
+ .HasMaxLength(32)
+ .HasColumnType("nvarchar(32)");
+
+ b.Property<string>("LicenseImage")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("Name")
+ .HasMaxLength(32)
+ .HasColumnType("nvarchar(32)");
+
+ b.Property<int?>("PersonalRealMethod")
+ .HasColumnType("int");
+
+ b.Property<string>("PhoneNumber")
+ .HasMaxLength(11)
+ .HasColumnType("nvarchar(11)");
+
+ b.Property<bool?>("Proxy")
+ .HasColumnType("bit");
+
+ b.Property<string>("ProxyPowerAttorneyUrl")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("SocietyCreditCode")
+ .IsRequired()
+ .HasMaxLength(18)
+ .HasColumnType("nvarchar(18)");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<string>("TraceId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<DateTimeOffset?>("UpdatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("UpdatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.ToTable("EnterpriseAuth");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.Menu", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<int>("ClientType")
+ .HasColumnType("int");
+
+ b.Property<string>("Code")
+ .IsRequired()
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("Group")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("Icon")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<bool>("IsCache")
+ .HasColumnType("bit");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<bool>("IsDisabled")
+ .HasColumnType("bit");
+
+ b.Property<string>("Location")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("Name")
+ .IsRequired()
+ .HasMaxLength(128)
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<Guid?>("ParentId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("Path")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("Remark")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<string>("TraceId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<int>("Type")
+ .HasColumnType("int");
+
+ b.Property<DateTimeOffset?>("UpdatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("UpdatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("Url")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<int>("UserType")
+ .HasColumnType("int");
+
+ b.Property<int>("VisitLevel")
+ .HasColumnType("int");
+
+ b.Property<string>("Width")
+ .HasColumnType("nvarchar(max)");
+
+ b.HasKey("Id");
+
+ b.HasIndex("ParentId");
+
+ b.ToTable("Menu");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.Resource", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("ActionName")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("ActionSummary")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<bool>("AllowAnonymous")
+ .HasColumnType("bit");
+
+ b.Property<string>("ApplicationName")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("Code")
+ .IsRequired()
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<int>("Controller")
+ .HasColumnType("int");
+
+ b.Property<string>("ControllerSummary")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("DynamicAssemblyName")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<bool>("IsExpired")
+ .HasColumnType("bit");
+
+ b.Property<int>("Method")
+ .HasColumnType("int");
+
+ b.Property<string>("Name")
+ .IsRequired()
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("RequestTypeFullName")
+ .IsRequired()
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("RequestTypeName")
+ .IsRequired()
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("ResponseTypeFullName")
+ .IsRequired()
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("ResponseTypeName")
+ .IsRequired()
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("Route")
+ .IsRequired()
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("RouteArea")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<int>("Service")
+ .HasColumnType("int");
+
+ b.Property<string>("ServiceName")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<string>("TraceId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<DateTimeOffset?>("UpdatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("UpdatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.ToTable("Resource");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.Role", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<int>("ClientType")
+ .HasColumnType("int");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<int>("DataPower")
+ .HasColumnType("int");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<bool>("IsDisabled")
+ .HasColumnType("bit");
+
+ b.Property<int>("MinLevel")
+ .HasColumnType("int");
+
+ b.Property<string>("Name")
+ .IsRequired()
+ .HasMaxLength(128)
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<string>("Remark")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<string>("TraceId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<DateTimeOffset?>("UpdatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("UpdatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<int>("UserType")
+ .HasColumnType("int");
+
+ b.HasKey("Id");
+
+ b.ToTable("Role");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.RoleMenu", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<Guid>("MenuId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<Guid>("RoleId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<string>("TraceId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<DateTimeOffset?>("UpdatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("UpdatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.HasIndex("MenuId");
+
+ b.HasIndex("RoleId");
+
+ b.ToTable("RoleMenu");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.RoleResource", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<int>("DataPower")
+ .HasColumnType("int");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<Guid>("ResourceId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<Guid>("RoleId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<string>("TraceId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<DateTimeOffset?>("UpdatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("UpdatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.HasIndex("ResourceId");
+
+ b.HasIndex("RoleId");
+
+ b.ToTable("RoleResource");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.TaskInfo", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("Address")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<int>("AgeMaxLimit")
+ .HasColumnType("int");
+
+ b.Property<int>("AgeMinLimit")
+ .HasColumnType("int");
+
+ b.Property<DateTime>("BeginTime")
+ .HasColumnType("datetime2");
+
+ b.Property<int>("BillingMethod")
+ .HasColumnType("int");
+
+ b.Property<string>("CityCode")
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<string>("Code")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTime>("EndTime")
+ .HasColumnType("datetime2");
+
+ b.Property<Guid>("EnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<int>("GenderLimit")
+ .HasColumnType("int");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<string>("Name")
+ .IsRequired()
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("ProvinceCode")
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<int>("ReleaseStatus")
+ .HasColumnType("int");
+
+ b.Property<decimal>("ServiceFee")
+ .HasColumnType("decimal(18,2)");
+
+ b.Property<int>("SettlementCycle")
+ .HasColumnType("int");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<int>("Status")
+ .HasColumnType("int");
+
+ b.Property<string>("TraceId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<DateTimeOffset?>("UpdatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("UpdatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.HasIndex("CityCode");
+
+ b.HasIndex("EnterpriseId");
+
+ b.HasIndex("ProvinceCode");
+
+ b.ToTable("TaskInfo");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.TaskInfoBenefit", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("BenefitCode")
+ .IsRequired()
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<Guid>("TaskInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("TraceId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<DateTimeOffset?>("UpdatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("UpdatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.HasIndex("BenefitCode");
+
+ b.HasIndex("TaskInfoId");
+
+ b.ToTable("TaskInfoBenefit");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.TaskInfoCredentialLimit", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<Guid>("TaskInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("TraceId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("TypeCode")
+ .IsRequired()
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<DateTimeOffset?>("UpdatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("UpdatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.HasIndex("TaskInfoId");
+
+ b.HasIndex("TypeCode");
+
+ b.ToTable("TaskInfoCredentialLimit");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.TaskInfoUser", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<int>("HireStatus")
+ .HasColumnType("int");
+
+ b.Property<DateTime?>("HireTime")
+ .HasColumnType("datetime2");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<int?>("SignContractStatus")
+ .HasColumnType("int");
+
+ b.Property<DateTime?>("SignContractTime")
+ .HasColumnType("datetime2");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<Guid>("TaskInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("TraceId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<DateTimeOffset?>("UpdatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("UpdatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<Guid>("UserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.HasIndex("TaskInfoId");
+
+ b.HasIndex("UserInfoId");
+
+ b.ToTable("TaskInfoUser");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserAuth", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("BankCard")
+ .HasMaxLength(32)
+ .HasColumnType("nvarchar(32)");
+
+ b.Property<string>("BankCardImg")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("Identity")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("IdentityBackImg")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("IdentityImg")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<bool>("IsCheckPhoneNumber")
+ .HasColumnType("bit");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<bool>("IsReal")
+ .HasColumnType("bit");
+
+ b.Property<string>("Name")
+ .IsRequired()
+ .HasMaxLength(32)
+ .HasColumnType("nvarchar(32)");
+
+ b.Property<string>("Password")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("PhoneNumber")
+ .HasMaxLength(11)
+ .HasColumnType("nvarchar(11)");
+
+ b.Property<int?>("RealAccess")
+ .HasColumnType("int");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<string>("TraceId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<DateTimeOffset?>("UpdatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("UpdatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("UserName")
+ .IsRequired()
+ .HasMaxLength(32)
+ .HasColumnType("nvarchar(32)");
+
+ b.HasKey("Id");
+
+ b.ToTable("UserAuth");
+
+ b.HasData(
+ new
+ {
+ Id = new Guid("11111111-1111-1111-1111-111111111111"),
+ CreatedTime = new DateTimeOffset(new DateTime(2000, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 8, 0, 0, 0)),
+ IsCheckPhoneNumber = false,
+ IsDeleted = false,
+ IsReal = false,
+ Name = "绠＄悊鍛�",
+ Password = "iEYggKrMhQ3ASUGLobra1w==:fn/DsMJUbD9FGpvBvR3moMpMPptdxzZlourPVhU479I=",
+ Sort = 0,
+ UserName = "system"
+ });
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserInfo", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("Avatar")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("CityCode")
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("EducationalBackgroundCode")
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<Guid?>("EnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<int?>("FreeTime")
+ .HasColumnType("int");
+
+ b.Property<int?>("Height")
+ .HasColumnType("int");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<int?>("JobSeekingStatus")
+ .HasColumnType("int");
+
+ b.Property<int>("Level")
+ .HasColumnType("int");
+
+ b.Property<string>("PersonalIdentityCode")
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<string>("ProvinceCode")
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<string>("Remark")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<int>("Status")
+ .HasColumnType("int");
+
+ b.Property<string>("TraceId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<int>("Type")
+ .HasColumnType("int");
+
+ b.Property<DateTimeOffset?>("UpdatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("UpdatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<Guid>("UserAuthId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<int?>("Weight")
+ .HasColumnType("int");
+
+ b.Property<string>("WorkExperience")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("WorkSeniority")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("WxmpOpenId")
+ .HasMaxLength(32)
+ .HasColumnType("nvarchar(32)");
+
+ b.HasKey("Id");
+
+ b.HasIndex("CityCode");
+
+ b.HasIndex("EducationalBackgroundCode");
+
+ b.HasIndex("EnterpriseId");
+
+ b.HasIndex("PersonalIdentityCode");
+
+ b.HasIndex("ProvinceCode");
+
+ b.HasIndex("UserAuthId");
+
+ b.ToTable("UserInfo");
+
+ b.HasData(
+ new
+ {
+ Id = new Guid("11111111-1111-1111-1111-111111111112"),
+ CreatedTime = new DateTimeOffset(new DateTime(2000, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 8, 0, 0, 0)),
+ IsDeleted = false,
+ Level = 999,
+ Sort = 0,
+ Status = 0,
+ Type = 100,
+ UserAuthId = new Guid("11111111-1111-1111-1111-111111111111")
+ });
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserInfoBankCard", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("Bank")
+ .IsRequired()
+ .HasMaxLength(128)
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<string>("Code")
+ .IsRequired()
+ .HasMaxLength(32)
+ .HasColumnType("nvarchar(32)");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<string>("PhoneNumber")
+ .IsRequired()
+ .HasMaxLength(11)
+ .HasColumnType("nvarchar(11)");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<string>("TraceId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<DateTimeOffset?>("UpdatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("UpdatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<Guid>("UserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.HasIndex("UserInfoId");
+
+ b.ToTable("UserInfoBankCard");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserInfoCredential", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("BackImg")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("Code")
+ .IsRequired()
+ .HasMaxLength(128)
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTime>("EndDate")
+ .HasColumnType("datetime2");
+
+ b.Property<string>("Img")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<bool>("IsForever")
+ .HasColumnType("bit");
+
+ b.Property<string>("IssueUnit")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<DateTime>("StartDate")
+ .HasColumnType("datetime2");
+
+ b.Property<string>("TraceId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("TypeCode")
+ .IsRequired()
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<DateTimeOffset?>("UpdatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("UpdatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<Guid>("UserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.HasIndex("TypeCode");
+
+ b.HasIndex("UserInfoId");
+
+ b.ToTable("UserInfoCredential");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserInfoDepartment", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<Guid>("DepartmentId")
+ .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?>("UpdatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<Guid>("UserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.HasIndex("DepartmentId");
+
+ b.HasIndex("UserInfoId");
+
+ b.ToTable("UserInfoDepartment");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserInfoExpectJob", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<string>("PersonalIdentityCode")
+ .IsRequired()
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<string>("TraceId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<DateTimeOffset?>("UpdatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("UpdatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<Guid>("UserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.HasIndex("PersonalIdentityCode");
+
+ b.HasIndex("UserInfoId");
+
+ b.ToTable("UserInfoExpectJob");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserInfoPhoto", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("Img")
+ .HasColumnType("nvarchar(max)");
+
+ 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?>("UpdatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<Guid>("UserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.HasIndex("UserInfoId");
+
+ b.ToTable("UserInfoPhoto");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserInfoRole", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<Guid>("RoleId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<string>("TraceId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<DateTimeOffset?>("UpdatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("UpdatedUserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<Guid>("UserInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.HasIndex("RoleId");
+
+ b.HasIndex("UserInfoId");
+
+ b.ToTable("UserInfoRole");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.Department", b =>
+ {
+ b.HasOne("FlexJobApi.Core.Enterprise", "Enterprise")
+ .WithMany("Departments")
+ .HasForeignKey("EnterpriseId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.HasOne("FlexJobApi.Core.Department", "Parent")
+ .WithMany("Children")
+ .HasForeignKey("ParentId");
+
+ b.Navigation("Enterprise");
+
+ b.Navigation("Parent");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.DictionaryData", b =>
+ {
+ b.HasOne("FlexJobApi.Core.DictionaryCategory", "Category")
+ .WithMany()
+ .HasForeignKey("CategoryId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.HasOne("FlexJobApi.Core.DictionaryData", "Parent")
+ .WithMany("Children")
+ .HasForeignKey("ParentId");
+
+ b.Navigation("Category");
+
+ b.Navigation("Parent");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.Enterprise", b =>
+ {
+ b.HasOne("FlexJobApi.Core.DictionaryData", "City")
+ .WithMany()
+ .HasForeignKey("CityCode")
+ .HasPrincipalKey("Code")
+ .OnDelete(DeleteBehavior.Restrict);
+
+ b.HasOne("FlexJobApi.Core.EnterpriseAuth", "EnterpriseAuth")
+ .WithMany()
+ .HasForeignKey("EnterpriseAuthId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.HasOne("FlexJobApi.Core.DictionaryData", "IndustryType")
+ .WithMany()
+ .HasForeignKey("IndustryTypeCode")
+ .HasPrincipalKey("Code")
+ .OnDelete(DeleteBehavior.Restrict);
+
+ b.HasOne("FlexJobApi.Core.DictionaryData", "Province")
+ .WithMany()
+ .HasForeignKey("ProvinceCode")
+ .HasPrincipalKey("Code")
+ .OnDelete(DeleteBehavior.Restrict);
+
+ b.Navigation("City");
+
+ b.Navigation("EnterpriseAuth");
+
+ b.Navigation("IndustryType");
+
+ b.Navigation("Province");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.Menu", b =>
+ {
+ b.HasOne("FlexJobApi.Core.Menu", "Parent")
+ .WithMany("Children")
+ .HasForeignKey("ParentId");
+
+ b.Navigation("Parent");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.RoleMenu", b =>
+ {
+ b.HasOne("FlexJobApi.Core.Menu", "Menu")
+ .WithMany()
+ .HasForeignKey("MenuId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.HasOne("FlexJobApi.Core.Role", "Role")
+ .WithMany("RoleMenus")
+ .HasForeignKey("RoleId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("Menu");
+
+ b.Navigation("Role");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.RoleResource", b =>
+ {
+ b.HasOne("FlexJobApi.Core.Resource", "Resource")
+ .WithMany()
+ .HasForeignKey("ResourceId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.HasOne("FlexJobApi.Core.Role", "Role")
+ .WithMany("RoleResources")
+ .HasForeignKey("RoleId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("Resource");
+
+ b.Navigation("Role");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.TaskInfo", b =>
+ {
+ b.HasOne("FlexJobApi.Core.DictionaryData", "City")
+ .WithMany()
+ .HasForeignKey("CityCode")
+ .HasPrincipalKey("Code")
+ .OnDelete(DeleteBehavior.Restrict);
+
+ b.HasOne("FlexJobApi.Core.Enterprise", "Enterprise")
+ .WithMany()
+ .HasForeignKey("EnterpriseId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.HasOne("FlexJobApi.Core.DictionaryData", "Province")
+ .WithMany()
+ .HasForeignKey("ProvinceCode")
+ .HasPrincipalKey("Code")
+ .OnDelete(DeleteBehavior.Restrict);
+
+ b.Navigation("City");
+
+ b.Navigation("Enterprise");
+
+ b.Navigation("Province");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.TaskInfoBenefit", b =>
+ {
+ b.HasOne("FlexJobApi.Core.DictionaryData", "Benefit")
+ .WithMany()
+ .HasForeignKey("BenefitCode")
+ .HasPrincipalKey("Code")
+ .OnDelete(DeleteBehavior.Restrict)
+ .IsRequired();
+
+ b.HasOne("FlexJobApi.Core.TaskInfo", "TaskInfo")
+ .WithMany("Benefits")
+ .HasForeignKey("TaskInfoId")
+ .OnDelete(DeleteBehavior.Restrict)
+ .IsRequired();
+
+ b.Navigation("Benefit");
+
+ b.Navigation("TaskInfo");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.TaskInfoCredentialLimit", b =>
+ {
+ b.HasOne("FlexJobApi.Core.TaskInfo", "TaskInfo")
+ .WithMany("CredentialLimits")
+ .HasForeignKey("TaskInfoId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.HasOne("FlexJobApi.Core.DictionaryData", "Type")
+ .WithMany()
+ .HasForeignKey("TypeCode")
+ .HasPrincipalKey("Code")
+ .OnDelete(DeleteBehavior.Restrict)
+ .IsRequired();
+
+ b.Navigation("TaskInfo");
+
+ b.Navigation("Type");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.TaskInfoUser", b =>
+ {
+ b.HasOne("FlexJobApi.Core.TaskInfo", "TaskInfo")
+ .WithMany()
+ .HasForeignKey("TaskInfoId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.HasOne("FlexJobApi.Core.UserInfo", "UserInfo")
+ .WithMany()
+ .HasForeignKey("UserInfoId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("TaskInfo");
+
+ b.Navigation("UserInfo");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserInfo", b =>
+ {
+ b.HasOne("FlexJobApi.Core.DictionaryData", "City")
+ .WithMany()
+ .HasForeignKey("CityCode")
+ .HasPrincipalKey("Code")
+ .OnDelete(DeleteBehavior.Restrict);
+
+ b.HasOne("FlexJobApi.Core.DictionaryData", "EducationalBackground")
+ .WithMany()
+ .HasForeignKey("EducationalBackgroundCode")
+ .HasPrincipalKey("Code")
+ .OnDelete(DeleteBehavior.Restrict);
+
+ b.HasOne("FlexJobApi.Core.Enterprise", "Enterprise")
+ .WithMany("UserInfos")
+ .HasForeignKey("EnterpriseId");
+
+ b.HasOne("FlexJobApi.Core.DictionaryData", "PersonalIdentity")
+ .WithMany()
+ .HasForeignKey("PersonalIdentityCode")
+ .HasPrincipalKey("Code")
+ .OnDelete(DeleteBehavior.Restrict);
+
+ b.HasOne("FlexJobApi.Core.DictionaryData", "Province")
+ .WithMany()
+ .HasForeignKey("ProvinceCode")
+ .HasPrincipalKey("Code")
+ .OnDelete(DeleteBehavior.Restrict);
+
+ b.HasOne("FlexJobApi.Core.UserAuth", "UserAuth")
+ .WithMany("UserInfos")
+ .HasForeignKey("UserAuthId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("City");
+
+ b.Navigation("EducationalBackground");
+
+ b.Navigation("Enterprise");
+
+ b.Navigation("PersonalIdentity");
+
+ b.Navigation("Province");
+
+ b.Navigation("UserAuth");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserInfoBankCard", b =>
+ {
+ b.HasOne("FlexJobApi.Core.UserInfo", "UserInfo")
+ .WithMany()
+ .HasForeignKey("UserInfoId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("UserInfo");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserInfoCredential", b =>
+ {
+ b.HasOne("FlexJobApi.Core.DictionaryData", "Type")
+ .WithMany()
+ .HasForeignKey("TypeCode")
+ .HasPrincipalKey("Code")
+ .OnDelete(DeleteBehavior.Restrict)
+ .IsRequired();
+
+ b.HasOne("FlexJobApi.Core.UserInfo", "UserInfo")
+ .WithMany("UserInfoCredentials")
+ .HasForeignKey("UserInfoId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("Type");
+
+ b.Navigation("UserInfo");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserInfoDepartment", b =>
+ {
+ b.HasOne("FlexJobApi.Core.Department", "Department")
+ .WithMany()
+ .HasForeignKey("DepartmentId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.HasOne("FlexJobApi.Core.UserInfo", "UserInfo")
+ .WithMany("UserInfoDepartments")
+ .HasForeignKey("UserInfoId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("Department");
+
+ b.Navigation("UserInfo");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserInfoExpectJob", b =>
+ {
+ b.HasOne("FlexJobApi.Core.DictionaryData", "PersonalIdentity")
+ .WithMany()
+ .HasForeignKey("PersonalIdentityCode")
+ .HasPrincipalKey("Code")
+ .OnDelete(DeleteBehavior.Restrict)
+ .IsRequired();
+
+ b.HasOne("FlexJobApi.Core.UserInfo", "UserInfo")
+ .WithMany("UserInfoExpectJobs")
+ .HasForeignKey("UserInfoId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("PersonalIdentity");
+
+ b.Navigation("UserInfo");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserInfoPhoto", b =>
+ {
+ b.HasOne("FlexJobApi.Core.UserInfo", "UserInfo")
+ .WithMany()
+ .HasForeignKey("UserInfoId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("UserInfo");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserInfoRole", b =>
+ {
+ b.HasOne("FlexJobApi.Core.Role", "Role")
+ .WithMany("UserInfoRoles")
+ .HasForeignKey("RoleId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.HasOne("FlexJobApi.Core.UserInfo", "UserInfo")
+ .WithMany("UserInfoRoles")
+ .HasForeignKey("UserInfoId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("Role");
+
+ b.Navigation("UserInfo");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.Department", b =>
+ {
+ b.Navigation("Children");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.DictionaryData", b =>
+ {
+ b.Navigation("Children");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.Enterprise", b =>
+ {
+ b.Navigation("Departments");
+
+ b.Navigation("UserInfos");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.Menu", b =>
+ {
+ b.Navigation("Children");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.Role", b =>
+ {
+ b.Navigation("RoleMenus");
+
+ b.Navigation("RoleResources");
+
+ b.Navigation("UserInfoRoles");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.TaskInfo", b =>
+ {
+ b.Navigation("Benefits");
+
+ b.Navigation("CredentialLimits");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserAuth", b =>
+ {
+ b.Navigation("UserInfos");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserInfo", b =>
+ {
+ b.Navigation("UserInfoCredentials");
+
+ b.Navigation("UserInfoDepartments");
+
+ b.Navigation("UserInfoExpectJobs");
+
+ b.Navigation("UserInfoRoles");
+ });
+#pragma warning restore 612, 618
+ }
+ }
+}
diff --git a/FlexJobApi.Database.Migrations/Migrations/20250807085934_UpdateDictionaryData0807.cs b/FlexJobApi.Database.Migrations/Migrations/20250807085934_UpdateDictionaryData0807.cs
new file mode 100644
index 0000000..cfcbbad
--- /dev/null
+++ b/FlexJobApi.Database.Migrations/Migrations/20250807085934_UpdateDictionaryData0807.cs
@@ -0,0 +1,61 @@
+锘縰sing Microsoft.EntityFrameworkCore.Migrations;
+
+#nullable disable
+
+namespace FlexJobApi.Database.Migrations.Migrations
+{
+ /// <inheritdoc />
+ public partial class UpdateDictionaryData0807 : Migration
+ {
+ /// <inheritdoc />
+ protected override void Up(MigrationBuilder migrationBuilder)
+ {
+ migrationBuilder.AddColumn<string>(
+ name: "Code",
+ table: "TaskInfo",
+ type: "nvarchar(max)",
+ nullable: true);
+
+ migrationBuilder.AddColumn<int>(
+ name: "ReleaseStatus",
+ table: "TaskInfo",
+ type: "int",
+ nullable: false,
+ defaultValue: 0);
+
+ migrationBuilder.AddColumn<int>(
+ name: "Status",
+ table: "TaskInfo",
+ type: "int",
+ nullable: false,
+ defaultValue: 0);
+
+ migrationBuilder.AddColumn<int>(
+ name: "Deep",
+ table: "DictionaryData",
+ type: "int",
+ nullable: false,
+ defaultValue: 0);
+ }
+
+ /// <inheritdoc />
+ protected override void Down(MigrationBuilder migrationBuilder)
+ {
+ migrationBuilder.DropColumn(
+ name: "Code",
+ table: "TaskInfo");
+
+ migrationBuilder.DropColumn(
+ name: "ReleaseStatus",
+ table: "TaskInfo");
+
+ migrationBuilder.DropColumn(
+ name: "Status",
+ table: "TaskInfo");
+
+ migrationBuilder.DropColumn(
+ name: "Deep",
+ table: "DictionaryData");
+ }
+ }
+}
diff --git a/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs b/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs
index 7af560f..a69c87f 100644
--- a/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs
+++ b/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs
@@ -149,6 +149,9 @@
b.Property<Guid?>("CreatedUserInfoId")
.HasColumnType("uniqueidentifier");
+ b.Property<int>("Deep")
+ .HasColumnType("int");
+
b.Property<string>("Field1")
.HasColumnType("nvarchar(max)");
@@ -740,6 +743,9 @@
b.Property<string>("CityCode")
.HasColumnType("nvarchar(128)");
+ b.Property<string>("Code")
+ .HasColumnType("nvarchar(max)");
+
b.Property<DateTimeOffset>("CreatedTime")
.HasColumnType("datetimeoffset");
@@ -765,6 +771,9 @@
b.Property<string>("ProvinceCode")
.HasColumnType("nvarchar(128)");
+ b.Property<int>("ReleaseStatus")
+ .HasColumnType("int");
+
b.Property<decimal>("ServiceFee")
.HasColumnType("decimal(18,2)");
@@ -774,6 +783,9 @@
b.Property<int>("Sort")
.HasColumnType("int");
+ b.Property<int>("Status")
+ .HasColumnType("int");
+
b.Property<string>("TraceId")
.HasColumnType("nvarchar(max)");
diff --git a/FlexJobApi.Database.Migrations/REDEME.MD b/FlexJobApi.Database.Migrations/REDEME.MD
index 75c52e5..2c63e08 100644
--- a/FlexJobApi.Database.Migrations/REDEME.MD
+++ b/FlexJobApi.Database.Migrations/REDEME.MD
@@ -1,7 +1,7 @@
-------------------------------主数据库---------------------------------------
新增迁移文件
-dotnet ef migrations add UpdateDictionaryData -s "../FlexJobApi.Web.Entry" -c DefaultDbContext
+dotnet ef migrations add UpdateDictionaryData0807 -s "../FlexJobApi.Web.Entry" -c DefaultDbContext
删除迁移文件
dotnet ef migrations remove -s "../FlexJobApi.Web.Entry" -c DefaultDbContext
--
Gitblit v1.9.1