From 9ead841625fd9cfd9dcc4098f97277dacf064882 Mon Sep 17 00:00:00 2001
From: sunpengfei <i@angelzzz.com>
Date: 星期四, 14 八月 2025 09:23:29 +0800
Subject: [PATCH] feat:开发
---
FlexJobApi.Core/Utils/ResourceUtils/ResourceUtils.cs | 78
FlexJobApi.FlexJobServer.Application/FlexJobApi.FlexJobServer.Application.xml | 8
FlexJobApi.Core/Utils/ResourceUtils/ResourceModel.cs | 5
FlexJobApi.Core/Entities/CommonServer/Resource.cs | 5
FlexJobApi.FlexJobServer.Application/Tasks/Queries/TaskInfoQueryHandler.cs | 2
FlexJobApi.UserServer.Application/Users/Queries/GetPersonalUserInfosQueryHandler.cs | 97 +
FlexJobApi.Core/Models/FlexJobServer/TaskCheckReceive/Commands/ExportTaskCheckReceiveTaskUsersCommand.cs | 61
FlexJobApi.Database.Migrations/Migrations/20250813150148_UpdateResource0813.cs | 29
FlexJobApi.Database.Migrations/Migrations/LogDb/20250813150002_UpdateResource0813.cs | 22
FlexJobApi.Database.Migrations/Migrations/LogDb/20250813150002_UpdateResource0813.Designer.cs | 429 ++++++
FlexJobApi.Core/FlexJobApi.Core.xml | 234 +++
FlexJobApi.UserServer.Application/FlexJobApi.UserServer.Application.xml | 26
FlexJobApi.Database.Migrations/REDEME.MD | 4
FlexJobApi.Core/Utils/AliyunUtils/AliyunOSSUtils.cs | 72 +
FlexJobApi.Core/Utils/ResourceUtils/ResourceServiceAttribute.cs | 5
FlexJobApi.UserServer.Application/Users/Queries/GetOperationUserInfosQueryHandler.cs | 2
FlexJobApi.FlexJobServer.Application/Class1.cs | 12
FlexJobApi.FlexJobServer.Application/TaskCheckReceives/Commands/TaskCheckReceiveCommandHandler.cs | 29
FlexJobApi.UserServer.Application/EnterpriseEmployees/Commands/EnterpriseEmployeesCommandHandler.cs | 13
FlexJobApi.Database.Migrations/Migrations/20250813150148_UpdateResource0813.Designer.cs | 2527 ++++++++++++++++++++++++++++++++++++++
FlexJobApi.Core/Models/UserServer/EnterpriseEmployees/Commands/ImportEnterpriseEmployeesCommand.cs | 27
FlexJobApi.Core/Utils/ExcelUtils/ExcelUtils.cs | 81 +
FlexJobApi.Core/Models/UserServer/Users/Queries/GetPersonalUserInfosQuery.cs | 125 +
FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs | 11
FlexJobApi.Core/FlexJobApi.Core.csproj | 2
25 files changed, 3,871 insertions(+), 35 deletions(-)
diff --git a/FlexJobApi.Core/Entities/CommonServer/Resource.cs b/FlexJobApi.Core/Entities/CommonServer/Resource.cs
index e5d201a..fa4e71e 100644
--- a/FlexJobApi.Core/Entities/CommonServer/Resource.cs
+++ b/FlexJobApi.Core/Entities/CommonServer/Resource.cs
@@ -77,6 +77,11 @@
public EnumResourceMethod Method { get; set; }
/// <summary>
+ /// 鏂囦欢涓婁紶
+ /// </summary>
+ public bool FileUpload { get; set; }
+
+ /// <summary>
/// 璺敱鍖哄煙
/// </summary>
public string RouteArea { get; set; }
diff --git a/FlexJobApi.Core/FlexJobApi.Core.csproj b/FlexJobApi.Core/FlexJobApi.Core.csproj
index ec69fa3..7b5fbc5 100644
--- a/FlexJobApi.Core/FlexJobApi.Core.csproj
+++ b/FlexJobApi.Core/FlexJobApi.Core.csproj
@@ -18,6 +18,7 @@
<ItemGroup>
<PackageReference Include="aliyun-net-sdk-core" Version="1.5.6" />
+ <PackageReference Include="Aliyun.OSS.SDK.NetCore" Version="2.14.1" />
<PackageReference Include="Consul" Version="1.7.14.8" />
<PackageReference Include="EFCore.BulkExtensions" Version="9.0.1" />
<PackageReference Include="Furion" Version="4.9.7.106" />
@@ -25,6 +26,7 @@
<PackageReference Include="Furion.Extras.ObjectMapper.Mapster" Version="4.9.7.106" />
<PackageReference Include="MediatR" Version="13.0.0" />
<PackageReference Include="Microsoft.Extensions.Caching.StackExchangeRedis" Version="9.0.7" />
+ <PackageReference Include="MiniExcel" Version="1.41.3" />
<PackageReference Include="RabbitMQ.Client" Version="6.8.1" />
<PackageReference Include="Swashbuckle.AspNetCore.Newtonsoft" Version="9.0.3" />
</ItemGroup>
diff --git a/FlexJobApi.Core/FlexJobApi.Core.xml b/FlexJobApi.Core/FlexJobApi.Core.xml
index cbc22a2..307761e 100644
--- a/FlexJobApi.Core/FlexJobApi.Core.xml
+++ b/FlexJobApi.Core/FlexJobApi.Core.xml
@@ -515,6 +515,11 @@
璇锋眰鏂瑰紡
</summary>
</member>
+ <member name="P:FlexJobApi.Core.Resource.FileUpload">
+ <summary>
+ 鏂囦欢涓婁紶
+ </summary>
+ </member>
<member name="P:FlexJobApi.Core.Resource.RouteArea">
<summary>
璺敱鍖哄煙
@@ -3813,6 +3818,51 @@
楠屾敹鐘舵��
</summary>
</member>
+ <member name="T:FlexJobApi.Core.ExportTaskCheckReceiveTaskUsersCommand">
+ <summary>
+ 瀵煎嚭楠屾敹璁板綍
+ </summary>
+ </member>
+ <member name="P:FlexJobApi.Core.ExportTaskCheckReceiveTaskUsersCommand.Id">
+ <summary>
+ 浠诲姟Id
+ </summary>
+ </member>
+ <member name="P:FlexJobApi.Core.ExportTaskCheckReceiveTaskUsersCommandModel.Name">
+ <summary>
+ 濮撳悕
+ </summary>
+ </member>
+ <member name="P:FlexJobApi.Core.ExportTaskCheckReceiveTaskUsersCommandModel.Identity">
+ <summary>
+ 韬唤璇佸彿
+ </summary>
+ </member>
+ <member name="P:FlexJobApi.Core.ExportTaskCheckReceiveTaskUsersCommandModel.ContactPhoneNumber">
+ <summary>
+ 鎵嬫満鍙�
+ </summary>
+ </member>
+ <member name="P:FlexJobApi.Core.ExportTaskCheckReceiveTaskUsersCommandModel.CheckReceiveStatus">
+ <summary>
+ 楠屾敹鐘舵��
+ </summary>
+ </member>
+ <member name="P:FlexJobApi.Core.ExportTaskCheckReceiveTaskUsersCommandModel.CheckReceiveTime">
+ <summary>
+ 楠屾敹鏃堕棿
+ </summary>
+ </member>
+ <member name="P:FlexJobApi.Core.ExportTaskCheckReceiveTaskUsersCommandModel.Bank">
+ <summary>
+ 寮�鎴疯
+ </summary>
+ </member>
+ <member name="P:FlexJobApi.Core.ExportTaskCheckReceiveTaskUsersCommandModel.Code">
+ <summary>
+ 閾惰鍗″彿
+ </summary>
+ </member>
<member name="T:FlexJobApi.Core.SubmitCheckReceiveTaskCommand">
<summary>
浠诲姟鎻愪氦楠屾敹
@@ -5706,6 +5756,22 @@
<member name="P:FlexJobApi.Core.ImportEnterpriseEmployeesCommand.ExcelUrl">
<summary>
Excel鍦板潃
+ </summary>
+ </member>
+ <member name="P:FlexJobApi.Core.ImportEnterpriseEmployeesCommandModel.Name">
+ <summary>
+ 濮撳悕
+ </summary>
+ </member>
+ <member name="P:FlexJobApi.Core.ImportEnterpriseEmployeesCommandModel.ContactPhoneNumber">
+ <summary>
+ 鎵嬫満鍙�
+ </summary>
+ <remarks>鑱旂郴鐢佃瘽</remarks>
+ </member>
+ <member name="P:FlexJobApi.Core.ImportEnterpriseEmployeesCommandModel.Identity">
+ <summary>
+ 韬唤璇佸彿
</summary>
</member>
<member name="T:FlexJobApi.Core.GetEnterpriseEmployeeQuery">
@@ -8361,7 +8427,123 @@
</member>
<member name="T:FlexJobApi.Core.GetPersonalUserInfosQuery">
<summary>
- 鏌ヨ鐏靛伐鍒嗛〉鍒楄〃鏁版嵁
+ 鏌ヨC绔汉鍛樺垎椤靛垪琛ㄦ暟鎹�
+ </summary>
+ </member>
+ <member name="P:FlexJobApi.Core.GetPersonalUserInfosQuery.Keywords">
+ <summary>
+ 鍏抽敭瀛楋紙濮撳悕/鎵嬫満/韬唤璇佸彿/瀹㈡埛锛�
+ </summary>
+ </member>
+ <member name="P:FlexJobApi.Core.GetPersonalUserInfosQuery.HireTimeBegin">
+ <summary>
+ 鏈�杩戝綍鐢ㄦ椂闂�-鏈�鏃╂椂闂�
+ </summary>
+ </member>
+ <member name="P:FlexJobApi.Core.GetPersonalUserInfosQuery.HireTimeEnd">
+ <summary>
+ 鏈�杩戝綍鐢ㄦ椂闂�-鏈�鏅氭椂闂�
+ </summary>
+ </member>
+ <member name="P:FlexJobApi.Core.GetPersonalUserInfosQuery.SignContractBegin">
+ <summary>
+ 鏈�杩戠绾︽椂闂�-鏈�鏃╂椂闂�
+ </summary>
+ </member>
+ <member name="P:FlexJobApi.Core.GetPersonalUserInfosQuery.SignContractEnd">
+ <summary>
+ 鏈�杩戠绾︽椂闂�-鏈�鏅氭椂闂�
+ </summary>
+ </member>
+ <member name="P:FlexJobApi.Core.GetPersonalUserInfosQuery.IsReal">
+ <summary>
+ 鏄惁宸插疄鍚�
+ </summary>
+ </member>
+ <member name="T:FlexJobApi.Core.GetPersonalUserInfosQueryResult">
+ <summary>
+ 鏌ヨC绔汉鍛樺垎椤靛垪琛ㄦ暟鎹�-缁撴灉
+ </summary>
+ </member>
+ <member name="T:FlexJobApi.Core.GetPersonalUserInfosQueryResultItem">
+ <summary>
+ 鏌ヨC绔汉鍛樺垎椤靛垪琛ㄦ暟鎹�-缁撴灉-椤�
+ </summary>
+ </member>
+ <member name="P:FlexJobApi.Core.GetPersonalUserInfosQueryResultItem.Id">
+ <summary>
+ Id
+ </summary>
+ </member>
+ <member name="P:FlexJobApi.Core.GetPersonalUserInfosQueryResultItem.Name">
+ <summary>
+ 濮撳悕
+ </summary>
+ </member>
+ <member name="P:FlexJobApi.Core.GetPersonalUserInfosQueryResultItem.ContactPhoneNumber">
+ <summary>
+ 鎵嬫満鍙�
+ </summary>
+ <remarks>鑱旂郴鐢佃瘽</remarks>
+ </member>
+ <member name="P:FlexJobApi.Core.GetPersonalUserInfosQueryResultItem.Identity">
+ <summary>
+ 韬唤璇佸彿
+ </summary>
+ </member>
+ <member name="P:FlexJobApi.Core.GetPersonalUserInfosQueryResultItem.Gender">
+ <summary>
+ 鎬у埆
+ </summary>
+ </member>
+ <member name="P:FlexJobApi.Core.GetPersonalUserInfosQueryResultItem.Age">
+ <summary>
+ 骞撮緞
+ </summary>
+ </member>
+ <member name="P:FlexJobApi.Core.GetPersonalUserInfosQueryResultItem.ProvinceCode">
+ <summary>
+ 甯搁┗鐪佷唤缂栧彿
+ </summary>
+ </member>
+ <member name="P:FlexJobApi.Core.GetPersonalUserInfosQueryResultItem.ProvinceContent">
+ <summary>
+ 甯搁┗鐪佷唤
+ </summary>
+ </member>
+ <member name="P:FlexJobApi.Core.GetPersonalUserInfosQueryResultItem.CityCode">
+ <summary>
+ 甯搁┗鍩庡競缂栧彿
+ </summary>
+ </member>
+ <member name="P:FlexJobApi.Core.GetPersonalUserInfosQueryResultItem.CityContent">
+ <summary>
+ 甯搁┗鍩庡競
+ </summary>
+ </member>
+ <member name="P:FlexJobApi.Core.GetPersonalUserInfosQueryResultItem.Enterprises">
+ <summary>
+ 鎵�灞炲晢鎴�
+ </summary>
+ </member>
+ <member name="P:FlexJobApi.Core.GetPersonalUserInfosQueryResultItem.IsReal">
+ <summary>
+ 鏄惁瀹炲悕
+ </summary>
+ </member>
+ <member name="P:FlexJobApi.Core.GetPersonalUserInfosQueryResultItem.RealTime">
+ <summary>
+ 瀹炲悕鏃堕棿
+ </summary>
+ </member>
+ <member name="P:FlexJobApi.Core.GetPersonalUserInfosQueryResultItem.HireTime">
+ <summary>
+ 鏈�杩戝綍鐢ㄦ椂闂�
+ </summary>
+ </member>
+ <member name="P:FlexJobApi.Core.GetPersonalUserInfosQueryResultItem.SignContractTime">
+ <summary>
+ 鏈�杩戠绾︽椂闂�
</summary>
</member>
<member name="T:FlexJobApi.Core.GetUserInfoRolesQuery">
@@ -8462,6 +8644,41 @@
<summary>
闃块噷浜慜SS宸ュ叿
</summary>
+ </member>
+ <member name="M:FlexJobApi.Core.AliyunOSSUtils.Upload(System.String,System.String,System.String)">
+ <summary>
+ 涓婁紶鏂囦欢
+ </summary>
+ <param name="scene"></param>
+ <param name="url"></param>
+ <param name="filename"></param>
+ <returns></returns>
+ </member>
+ <member name="M:FlexJobApi.Core.AliyunOSSUtils.Upload(System.String,Microsoft.AspNetCore.Http.IFormFile,System.String)">
+ <summary>
+ 涓婁紶鏂囦欢
+ </summary>
+ <param name="scene"></param>
+ <param name="file"></param>
+ <param name="filename"></param>
+ <returns></returns>
+ </member>
+ <member name="M:FlexJobApi.Core.AliyunOSSUtils.Upload(System.String,System.IO.Stream,System.String)">
+ <summary>
+ 涓婁紶鏂囦欢
+ </summary>
+ <param name="scene"></param>
+ <param name="stream"></param>
+ <param name="filename"></param>
+ <returns></returns>
+ </member>
+ <member name="M:FlexJobApi.Core.AliyunOSSUtils.GetUrl(System.String,System.String)">
+ <summary>
+ 鑾峰彇Url
+ </summary>
+ <param name="url"></param>
+ <param name="process"></param>
+ <returns></returns>
</member>
<member name="M:FlexJobApi.Core.CollectionUtils.DistinctAdd``1(System.Collections.Generic.List{``0},``0,System.Collections.Generic.IEqualityComparer{``0})">
<summary>
@@ -8951,6 +9168,11 @@
閲婃斁闈炴墭绠¤祫婧�
</summary>
</member>
+ <member name="T:FlexJobApi.Core.ExcelUtils">
+ <summary>
+ Excel宸ュ叿
+ </summary>
+ </member>
<member name="P:FlexJobApi.Core.IFriendlyResult.TraceId">
<summary>
璺熻釜Id
@@ -9306,6 +9528,11 @@
璇锋眰鏂瑰紡
</summary>
</member>
+ <member name="P:FlexJobApi.Core.ResourceModel.FileUpload">
+ <summary>
+ 鏂囦欢涓婁紶
+ </summary>
+ </member>
<member name="P:FlexJobApi.Core.ResourceModel.RouteArea">
<summary>
璺敱鍖哄煙
@@ -9356,6 +9583,11 @@
璇锋眰鏂瑰紡
</summary>
</member>
+ <member name="P:FlexJobApi.Core.ResourceAttribute.FileUpload">
+ <summary>
+ 鏂囦欢涓婁紶
+ </summary>
+ </member>
<member name="T:FlexJobApi.Core.ResourceControllerAttribute">
<summary>
璧勬簮鎺у埗鍣ㄧ壒鎬�
diff --git a/FlexJobApi.Core/Models/FlexJobServer/TaskCheckReceive/Commands/ExportTaskCheckReceiveTaskUsersCommand.cs b/FlexJobApi.Core/Models/FlexJobServer/TaskCheckReceive/Commands/ExportTaskCheckReceiveTaskUsersCommand.cs
new file mode 100644
index 0000000..c5895c8
--- /dev/null
+++ b/FlexJobApi.Core/Models/FlexJobServer/TaskCheckReceive/Commands/ExportTaskCheckReceiveTaskUsersCommand.cs
@@ -0,0 +1,61 @@
+锘縰sing MediatR;
+using System;
+using System.Collections.Generic;
+using System.ComponentModel.DataAnnotations;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace FlexJobApi.Core
+{
+ /// <summary>
+ /// 瀵煎嚭楠屾敹璁板綍
+ /// </summary>
+ [Resource([EnumResourceController.TaskCheckReceive])]
+ public class ExportTaskCheckReceiveTaskUsersCommand : IRequest<string>
+ {
+ /// <summary>
+ /// 浠诲姟Id
+ /// </summary>
+ public Guid Id { get; set; }
+ }
+
+ public class ExportTaskCheckReceiveTaskUsersCommandModel
+ {
+ /// <summary>
+ /// 濮撳悕
+ /// </summary>
+ public string Name { get; set; }
+
+ /// <summary>
+ /// 韬唤璇佸彿
+ /// </summary>
+ public string Identity { get; set; }
+
+ /// <summary>
+ /// 鎵嬫満鍙�
+ /// </summary>
+ public string ContactPhoneNumber { get; set; }
+
+ /// <summary>
+ /// 楠屾敹鐘舵��
+ /// </summary>
+ public EnumTaskUserSubmitCheckReceiveStatus? CheckReceiveStatus { get; set; }
+
+ /// <summary>
+ /// 楠屾敹鏃堕棿
+ /// </summary>
+ public DateTime? CheckReceiveTime { get; set; }
+
+ /// <summary>
+ /// 寮�鎴疯
+ /// </summary>
+ public string Bank { get; set; }
+
+ /// <summary>
+ /// 閾惰鍗″彿
+ /// </summary>
+ public string Code { get; set; }
+
+ }
+}
diff --git a/FlexJobApi.Core/Models/UserServer/EnterpriseEmployees/Commands/ImportEnterpriseEmployeesCommand.cs b/FlexJobApi.Core/Models/UserServer/EnterpriseEmployees/Commands/ImportEnterpriseEmployeesCommand.cs
index f47b21b..a9eaa68 100644
--- a/FlexJobApi.Core/Models/UserServer/EnterpriseEmployees/Commands/ImportEnterpriseEmployeesCommand.cs
+++ b/FlexJobApi.Core/Models/UserServer/EnterpriseEmployees/Commands/ImportEnterpriseEmployeesCommand.cs
@@ -1,6 +1,10 @@
锘縰sing MediatR;
+using Microsoft.AspNetCore.Http;
+using MiniExcelLibs.Attributes;
+using Newtonsoft.Json;
using System;
using System.Collections.Generic;
+using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
@@ -18,4 +22,27 @@
/// </summary>
public string ExcelUrl { get; set; }
}
+
+ public class ImportEnterpriseEmployeesCommandModel
+ {
+ /// <summary>
+ /// 濮撳悕
+ /// </summary>
+ [Required]
+ public string Name { get; set; }
+
+ /// <summary>
+ /// 鎵嬫満鍙�
+ /// </summary>
+ /// <remarks>鑱旂郴鐢佃瘽</remarks>
+ [MaxLength(11)]
+ [Required]
+ public string ContactPhoneNumber { get; set; }
+
+ /// <summary>
+ /// 韬唤璇佸彿
+ /// </summary>
+ [Required]
+ public string Identity { get; set; }
+ }
}
diff --git a/FlexJobApi.Core/Models/UserServer/Users/Queries/GetPersonalUserInfosQuery.cs b/FlexJobApi.Core/Models/UserServer/Users/Queries/GetPersonalUserInfosQuery.cs
index 96e2dd7..98e3326 100644
--- a/FlexJobApi.Core/Models/UserServer/Users/Queries/GetPersonalUserInfosQuery.cs
+++ b/FlexJobApi.Core/Models/UserServer/Users/Queries/GetPersonalUserInfosQuery.cs
@@ -7,9 +7,130 @@
namespace FlexJobApi.Core
{
/// <summary>
- /// 鏌ヨ鐏靛伐鍒嗛〉鍒楄〃鏁版嵁
+ /// 鏌ヨC绔汉鍛樺垎椤靛垪琛ㄦ暟鎹�
/// </summary>
- public class GetPersonalUserInfosQuery:PagedList
+ [Resource([EnumResourceController.User])]
+ public class GetPersonalUserInfosQuery : PagedListQuery<GetPersonalUserInfosQueryResult, GetPersonalUserInfosQueryResultItem>
{
+ /// <summary>
+ /// 鍏抽敭瀛楋紙濮撳悕/鎵嬫満/韬唤璇佸彿/瀹㈡埛锛�
+ /// </summary>
+ public string Keywords { get; set; }
+
+ /// <summary>
+ /// 鏈�杩戝綍鐢ㄦ椂闂�-鏈�鏃╂椂闂�
+ /// </summary>
+ public DateTime? HireTimeBegin { get; set; }
+
+ /// <summary>
+ /// 鏈�杩戝綍鐢ㄦ椂闂�-鏈�鏅氭椂闂�
+ /// </summary>
+ public DateTime? HireTimeEnd { get; set; }
+
+ /// <summary>
+ /// 鏈�杩戠绾︽椂闂�-鏈�鏃╂椂闂�
+ /// </summary>
+ public DateTime? SignContractBegin { get; set; }
+
+ /// <summary>
+ /// 鏈�杩戠绾︽椂闂�-鏈�鏅氭椂闂�
+ /// </summary>
+ public DateTime? SignContractEnd { get; set; }
+
+ /// <summary>
+ /// 鏄惁宸插疄鍚�
+ /// </summary>
+ public bool? IsReal { get; set; }
+ }
+
+ /// <summary>
+ /// 鏌ヨC绔汉鍛樺垎椤靛垪琛ㄦ暟鎹�-缁撴灉
+ /// </summary>
+ public class GetPersonalUserInfosQueryResult : PagedListQueryResult<GetPersonalUserInfosQueryResultItem>
+ {
+
+ }
+
+ /// <summary>
+ /// 鏌ヨC绔汉鍛樺垎椤靛垪琛ㄦ暟鎹�-缁撴灉-椤�
+ /// </summary>
+ public class GetPersonalUserInfosQueryResultItem
+ {
+ /// <summary>
+ /// Id
+ /// </summary>
+ public Guid Id { get; set; }
+
+ /// <summary>
+ /// 濮撳悕
+ /// </summary>
+ public string Name { get; set; }
+
+ /// <summary>
+ /// 鎵嬫満鍙�
+ /// </summary>
+ /// <remarks>鑱旂郴鐢佃瘽</remarks>
+ public string ContactPhoneNumber { get; set; }
+
+ /// <summary>
+ /// 韬唤璇佸彿
+ /// </summary>
+ public string Identity { get; set; }
+
+ /// <summary>
+ /// 鎬у埆
+ /// </summary>
+ public EnumUserGender? Gender { get; set; }
+
+ /// <summary>
+ /// 骞撮緞
+ /// </summary>
+ public int? Age { get; set; }
+
+ /// <summary>
+ /// 甯搁┗鐪佷唤缂栧彿
+ /// </summary>
+ public string ProvinceCode { get; set; }
+
+ /// <summary>
+ /// 甯搁┗鐪佷唤
+ /// </summary>
+ public string ProvinceContent { get; set; }
+
+ /// <summary>
+ /// 甯搁┗鍩庡競缂栧彿
+ /// </summary>
+ public string CityCode { get; set; }
+
+ /// <summary>
+ /// 甯搁┗鍩庡競
+ /// </summary>
+ public string CityContent { get; set; }
+
+ /// <summary>
+ /// 鎵�灞炲晢鎴�
+ /// </summary>
+ public List<string> Enterprises { get; set; }
+
+ /// <summary>
+ /// 鏄惁瀹炲悕
+ /// </summary>
+ public bool IsReal { get; set; }
+
+ /// <summary>
+ /// 瀹炲悕鏃堕棿
+ /// </summary>
+ public DateTime? RealTime { get; set; }
+
+ /// <summary>
+ /// 鏈�杩戝綍鐢ㄦ椂闂�
+ /// </summary>
+ public DateTime? HireTime { get; set; }
+
+ /// <summary>
+ /// 鏈�杩戠绾︽椂闂�
+ /// </summary>
+ public DateTime? SignContractTime { get; set; }
+
}
}
diff --git a/FlexJobApi.Core/Utils/AliyunUtils/AliyunOSSUtils.cs b/FlexJobApi.Core/Utils/AliyunUtils/AliyunOSSUtils.cs
index 43ad92f..e7b569a 100644
--- a/FlexJobApi.Core/Utils/AliyunUtils/AliyunOSSUtils.cs
+++ b/FlexJobApi.Core/Utils/AliyunUtils/AliyunOSSUtils.cs
@@ -2,13 +2,16 @@
using Aliyun.Acs.Core.Auth.Sts;
using Aliyun.Acs.Core.Http;
using Aliyun.Acs.Core.Profile;
+using Aliyun.OSS;
using Furion;
+using Furion.HttpRemote;
+using Microsoft.AspNetCore.Http;
+using Microsoft.CodeAnalysis;
+using Microsoft.Extensions.Options;
using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Text;
+using System.Diagnostics;
+using System.IO;
using System.Threading.Tasks;
-using static System.Runtime.InteropServices.JavaScript.JSType;
namespace FlexJobApi.Core
{
@@ -40,5 +43,66 @@
};
return result;
}
+
+ /// <summary>
+ /// 涓婁紶鏂囦欢
+ /// </summary>
+ /// <param name="scene"></param>
+ /// <param name="url"></param>
+ /// <param name="filename"></param>
+ /// <returns></returns>
+ public static string Upload(string scene, string url, string filename = null)
+ {
+ var stream = App.GetRequiredService<IHttpRemoteService>().GetAsStream(url);
+ return Upload(scene, stream, filename);
+ }
+
+ /// <summary>
+ /// 涓婁紶鏂囦欢
+ /// </summary>
+ /// <param name="scene"></param>
+ /// <param name="file"></param>
+ /// <param name="filename"></param>
+ /// <returns></returns>
+ public static string Upload(string scene, IFormFile file, string filename = null)
+ {
+ var stream = file.OpenReadStream();
+ return Upload(scene, stream, filename);
+ }
+
+ /// <summary>
+ /// 涓婁紶鏂囦欢
+ /// </summary>
+ /// <param name="scene"></param>
+ /// <param name="stream"></param>
+ /// <param name="filename"></param>
+ /// <returns></returns>
+ public static string Upload(string scene, Stream stream, string filename = null)
+ {
+ var options = App.GetOptions<AliyunOptions>().OSS;
+ var client = new OssClient(options.Endpoint, options.AccessKeyId, options.AccessSecret);
+ var key = $"Resource/{scene}/{DateTime.Now:yyyy-MM-dd}/{filename}";
+ client.PutObject(options.BucketName, key, stream);
+ return key;
+ }
+
+ /// <summary>
+ /// 鑾峰彇Url
+ /// </summary>
+ /// <param name="url"></param>
+ /// <param name="process"></param>
+ /// <returns></returns>
+ public static string GetUrl(string url, string process = null)
+ {
+ var options = App.GetOptions<AliyunOptions>().OSS;
+ var client = new OssClient(options.Endpoint, options.AccessKeyId, options.AccessSecret);
+ var req = new GeneratePresignedUriRequest(options.BucketName, url, SignHttpMethod.Get)
+ {
+ Expiration = DateTime.Now.AddHours(1),
+ Process = process
+ };
+ url = client.GeneratePresignedUri(req).ToString();
+ return url;
+ }
}
}
diff --git a/FlexJobApi.Core/Utils/ExcelUtils/ExcelUtils.cs b/FlexJobApi.Core/Utils/ExcelUtils/ExcelUtils.cs
new file mode 100644
index 0000000..c13dd1d
--- /dev/null
+++ b/FlexJobApi.Core/Utils/ExcelUtils/ExcelUtils.cs
@@ -0,0 +1,81 @@
+锘縰sing Furion;
+using Furion.HttpRemote;
+using MiniExcelLibs;
+using MiniExcelLibs.Attributes;
+using MiniExcelLibs.OpenXml;
+using Newtonsoft.Json;
+using System;
+using System.Collections.Generic;
+using System.IO;
+using System.Linq;
+using System.Reflection;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace FlexJobApi.Core
+{
+ /// <summary>
+ /// Excel宸ュ叿
+ /// </summary>
+ public static class ExcelUtils
+ {
+ public static async Task<List<T>> ImportExcelFromOSS<T>(this string url)
+ where T : class, new()
+ {
+ var config = new OpenXmlConfiguration();
+ var xmlDoc = await XmlDocUtils.GetXmlDocAsync();
+ config.DynamicColumns = typeof(T).GetProperties().Select(it =>
+ {
+ var column = new DynamicExcelColumn(it.Name)
+ {
+ Name = it.GetXmlDocMemberAsync(xmlDoc).Result.Summary,
+ Ignore = it.GetCustomAttribute<JsonIgnoreAttribute>() != null
+ };
+ return column;
+ }).ToArray();
+ url = AliyunOSSUtils.GetUrl(url);
+ var stream = await App.GetRequiredService<IHttpRemoteService>().GetAsStreamAsync(url);
+
+ var query = await MiniExcel.QueryAsync<T>(stream, configuration: config);
+ return query.ToList();
+ }
+
+ public static async Task<string> ExportExcelToOSS<T>(this List<T> models, string scene, string filename)
+ where T : class, new()
+ {
+ var xmlDoc = await XmlDocUtils.GetXmlDocAsync();
+ var config = new OpenXmlConfiguration();
+ config.TableStyles = TableStyles.None;
+ config.AutoFilter = false;
+ config.DynamicColumns = typeof(T).GetProperties().Select(it =>
+ {
+ var propertyType = it.PropertyType;
+ if (propertyType.IsGenericType && propertyType.GetGenericTypeDefinition() == typeof(Nullable<>))
+ {
+ propertyType = propertyType.GetGenericArguments()[0];
+ }
+ var column = new DynamicExcelColumn(it.Name)
+ {
+ Name = it.GetXmlDocMemberAsync(xmlDoc).Result.Summary,
+ Ignore = it.GetCustomAttribute<JsonIgnoreAttribute>() != null,
+ CustomFormatter = v =>
+ {
+ if (propertyType.IsEnum)
+ {
+ var models = EnumUtils.GetModel(propertyType).Result;
+ var enumValue = (int)v;
+ var model = models.Items.FirstOrDefault(i => i.Value == enumValue);
+ return model?.Description;
+ }
+ return v;
+ }
+ };
+ return column;
+ }).ToArray();
+ var stream = new MemoryStream();
+ await MiniExcel.SaveAsAsync(stream, models, configuration: config);
+ stream.Seek(0, SeekOrigin.Begin);
+ return AliyunOSSUtils.Upload(scene, stream, filename);
+ }
+ }
+}
diff --git a/FlexJobApi.Core/Utils/ResourceUtils/ResourceModel.cs b/FlexJobApi.Core/Utils/ResourceUtils/ResourceModel.cs
index cf9d314..0deca91 100644
--- a/FlexJobApi.Core/Utils/ResourceUtils/ResourceModel.cs
+++ b/FlexJobApi.Core/Utils/ResourceUtils/ResourceModel.cs
@@ -77,6 +77,11 @@
public EnumResourceMethod Method { get; set; }
/// <summary>
+ /// 鏂囦欢涓婁紶
+ /// </summary>
+ public bool FileUpload { get; set; }
+
+ /// <summary>
/// 璺敱鍖哄煙
/// </summary>
public string RouteArea { get; set; }
diff --git a/FlexJobApi.Core/Utils/ResourceUtils/ResourceServiceAttribute.cs b/FlexJobApi.Core/Utils/ResourceUtils/ResourceServiceAttribute.cs
index 3be7424..cf2e110 100644
--- a/FlexJobApi.Core/Utils/ResourceUtils/ResourceServiceAttribute.cs
+++ b/FlexJobApi.Core/Utils/ResourceUtils/ResourceServiceAttribute.cs
@@ -31,6 +31,11 @@
/// 璇锋眰鏂瑰紡
/// </summary>
public EnumResourceMethod? Method { get; set; }
+
+ /// <summary>
+ /// 鏂囦欢涓婁紶
+ /// </summary>
+ public bool FileUpload { get; set; }
}
/// <summary>
diff --git a/FlexJobApi.Core/Utils/ResourceUtils/ResourceUtils.cs b/FlexJobApi.Core/Utils/ResourceUtils/ResourceUtils.cs
index 139d6ff..f381e16 100644
--- a/FlexJobApi.Core/Utils/ResourceUtils/ResourceUtils.cs
+++ b/FlexJobApi.Core/Utils/ResourceUtils/ResourceUtils.cs
@@ -78,7 +78,9 @@
model.RouteArea = resourceService.RouteArea;
model.Route = $"/api/{resourceService.RouteArea ?? "main"}/{controller}/{model.ActionName}";
model.Method =
- request.BaseType?.IsGenericType == true && request.BaseType.GetGenericTypeDefinition() == typeof(PagedListQuery<,>)
+ resourceAttribute.Method.HasValue
+ ? resourceAttribute.Method.Value
+ : request.BaseType?.IsGenericType == true && request.BaseType.GetGenericTypeDefinition() == typeof(PagedListQuery<,>)
? EnumResourceMethod.Post
: new List<string> { "Post", "Add", "Create", "Insert", "Submit" }.Any(it => request.Name.StartsWith(it, StringComparison.OrdinalIgnoreCase))
? EnumResourceMethod.Post
@@ -89,6 +91,7 @@
: new List<string> { "Delete", "Remove ", "Clear" }.Any(it => request.Name.StartsWith(it, StringComparison.OrdinalIgnoreCase))
? EnumResourceMethod.Delete
: EnumResourceMethod.Post;
+ model.FileUpload = resourceAttribute.FileUpload;
model.Code = requestXmlDoc?.Name;
model.Name = $"{model.ControllerSummary}-{model.ActionSummary}";
model.AllowAnonymous = resourceAttribute.AllowAnonymous;
@@ -172,7 +175,21 @@
public static void DynamicControllersHotPlug(List<Resource> resources, IDynamicApiRuntimeChangeProvider provider = null)
{
provider = provider ?? App.GetRequiredService<IDynamicApiRuntimeChangeProvider>();
- foreach (var resource in resources)
+ var controllers = resources
+ .GroupBy(it => new
+ {
+ it.ApplicationName,
+ it.Controller,
+ it.ControllerSummary,
+ it.RouteArea
+ })
+ .Select(it => new
+ {
+ it.Key,
+ Actions = it.ToList()
+ })
+ .ToList();
+ foreach (var controller in controllers)
{
var code = $@"
using FlexJobApi.Core;
@@ -186,43 +203,64 @@
using System.Collections.Generic;
using System.ComponentModel;
-namespace {resource.ApplicationName}.{resource.Controller}.{resource.ActionName}Request
+
+namespace {controller.Key.ApplicationName}.{controller.Key.Controller}
{{
/// <summary>
- /// {resource.ControllerSummary}
+ /// {controller.Key.ControllerSummary}
/// </summary>
- [Route(""api/{resource.RouteArea}/[controller]"")]
- public class {resource.Controller}AppService(IMediator mediator) : IDynamicApiController
+ [Route(""api/{controller.Key.RouteArea}/[controller]"")]
+ public class {controller.Key.Controller}AppService(IMediator mediator) : IDynamicApiController
{{
- private readonly IMediator mediator = mediator;
+ private readonly IMediator mediator = mediator;";
+
+ foreach (var action in controller.Actions)
+ {
+ var result = action.ResponseTypeName.IsNull() ? "Task" : $"Task<{action.ResponseTypeName}>";
+ code += @$"
/// <summary>
- /// {resource.ActionSummary}
+ /// {action.ActionSummary}
/// </summary>
/// <param name=""request""></param>
/// <returns></returns>";
- if (resource.AllowAnonymous)
- {
- code += $@"
+ if (action.AllowAnonymous)
+ {
+ code += $@"
[AllowAnonymous]";
- }
- var result = resource.ResponseTypeName.IsNull() ? "Task" : $"Task<{resource.ResponseTypeName}>";
- code += $@"
- [Http{resource.Method}]
- public {result} {resource.ActionName}({resource.RequestTypeName} request)
+ }
+ code += $@"
+ [Http{action.Method}]";
+ if (action.FileUpload)
+ {
+ code += @"
+ [Consumes(""multipart/form-data"")]";
+ }
+ code += @$"
+ public {result} {action.ActionName}(";
+ if (action.FileUpload)
+ {
+ code += "[FromForm] ";
+ }
+ code += $@"{action.RequestTypeName} request)
{{
return mediator.Send(request);
- }}
+ }}";
+ }
- }}
-}}
+ code += @"
+ }
+}
";
try
{
var dynamicAssembly = App.CompileCSharpClassCode(code);
provider.AddAssembliesWithNotifyChanges(dynamicAssembly);
var dynamicAssemblyName = dynamicAssembly.GetName().Name;
- resource.DynamicAssemblyName = dynamicAssemblyName;
+ foreach (var action in controller.Actions)
+ {
+ action.DynamicAssemblyName = dynamicAssemblyName;
+ }
}
catch (Exception ex)
{
diff --git a/FlexJobApi.Database.Migrations/Migrations/20250813150148_UpdateResource0813.Designer.cs b/FlexJobApi.Database.Migrations/Migrations/20250813150148_UpdateResource0813.Designer.cs
new file mode 100644
index 0000000..71506ac
--- /dev/null
+++ b/FlexJobApi.Database.Migrations/Migrations/20250813150148_UpdateResource0813.Designer.cs
@@ -0,0 +1,2527 @@
+锘�// <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("20250813150148_UpdateResource0813")]
+ partial class UpdateResource0813
+ {
+ /// <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<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .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?>("UpdatedUserId")
+ .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<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .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?>("UpdatedUserId")
+ .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<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .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?>("UpdatedUserId")
+ .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<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("EnterpriseName")
+ .IsRequired()
+ .HasMaxLength(128)
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<string>("IndustryTypeCode")
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<bool>("IsCheckedBankCard")
+ .HasColumnType("bit");
+
+ 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>("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<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?>("UpdatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.HasIndex("CityCode");
+
+ 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<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .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<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?>("UpdatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.ToTable("EnterpriseAuth");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.EnterpriseEmployee", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<int?>("Age")
+ .HasColumnType("int");
+
+ b.Property<string>("ContactPhoneNumber")
+ .HasMaxLength(11)
+ .HasColumnType("nvarchar(11)");
+
+ b.Property<string>("ContractUrl")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<Guid>("EnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<int?>("EnterpriseSignContractStatus")
+ .HasColumnType("int");
+
+ b.Property<DateTime?>("EnterpriseSignContractTime")
+ .HasColumnType("datetime2");
+
+ b.Property<int?>("Gender")
+ .HasColumnType("int");
+
+ b.Property<int>("HireStatus")
+ .HasColumnType("int");
+
+ b.Property<DateTime?>("HireTime")
+ .HasColumnType("datetime2");
+
+ b.Property<string>("Identity")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("IdentityBackImg")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("IdentityImg")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<string>("Name")
+ .HasMaxLength(32)
+ .HasColumnType("nvarchar(32)");
+
+ 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.Property<int?>("UserSignContractStatus")
+ .HasColumnType("int");
+
+ b.Property<DateTime?>("UserSignContractTime")
+ .HasColumnType("datetime2");
+
+ b.HasKey("Id");
+
+ b.HasIndex("EnterpriseId");
+
+ b.HasIndex("UserId");
+
+ b.ToTable("EnterpriseEmployee");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.EnterpriseUserCollect", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTime?>("CollectedTime")
+ .HasColumnType("datetime2");
+
+ b.Property<DateTime?>("ContactedTime")
+ .HasColumnType("datetime2");
+
+ b.Property<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<Guid>("EnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<bool>("IsCollected")
+ .HasColumnType("bit");
+
+ b.Property<bool>("IsContacted")
+ .HasColumnType("bit");
+
+ 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("EnterpriseId");
+
+ b.HasIndex("UserId");
+
+ b.ToTable("EnterpriseUserCollect");
+ });
+
+ 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<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .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?>("UpdatedUserId")
+ .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<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("DynamicAssemblyName")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<bool>("FileUpload")
+ .HasColumnType("bit");
+
+ 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")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("ResponseTypeName")
+ .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?>("UpdatedUserId")
+ .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<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .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?>("UpdatedUserId")
+ .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<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .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?>("UpdatedUserId")
+ .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<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .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?>("UpdatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.HasIndex("ResourceId");
+
+ b.HasIndex("RoleId");
+
+ b.ToTable("RoleResource");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.ScheduleJobDetail", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("AssemblyName")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<bool>("Concurrent")
+ .HasColumnType("bit");
+
+ b.Property<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("Description")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("GroupName")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<bool>("IncludeAnnotations")
+ .HasColumnType("bit");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<string>("JobId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("JobType")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("Properties")
+ .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?>("UpdatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.ToTable("ScheduleJobDetail");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.ScheduleJobTrigger", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("Args")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("AssemblyName")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("Description")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<long>("ElapsedTime")
+ .HasColumnType("bigint");
+
+ b.Property<DateTime?>("EndTime")
+ .HasColumnType("datetime2");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<string>("JobId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<DateTime?>("LastRunTime")
+ .HasColumnType("datetime2");
+
+ b.Property<long>("MaxNumberOfErrors")
+ .HasColumnType("bigint");
+
+ b.Property<long>("MaxNumberOfRuns")
+ .HasColumnType("bigint");
+
+ b.Property<DateTime?>("NextRunTime")
+ .HasColumnType("datetime2");
+
+ b.Property<long>("NumRetries")
+ .HasColumnType("bigint");
+
+ b.Property<long>("NumberOfErrors")
+ .HasColumnType("bigint");
+
+ b.Property<long>("NumberOfRuns")
+ .HasColumnType("bigint");
+
+ b.Property<bool>("ResetOnlyOnce")
+ .HasColumnType("bit");
+
+ b.Property<string>("Result")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<int>("RetryTimeout")
+ .HasColumnType("int");
+
+ b.Property<bool>("RunOnStart")
+ .HasColumnType("bit");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<bool>("StartNow")
+ .HasColumnType("bit");
+
+ b.Property<DateTime?>("StartTime")
+ .HasColumnType("datetime2");
+
+ b.Property<long>("Status")
+ .HasColumnType("bigint");
+
+ b.Property<string>("TraceId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("TriggerId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("TriggerType")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<DateTimeOffset?>("UpdatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("UpdatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.ToTable("ScheduleJobTrigger");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.TaskInfo", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("AddressDetail")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("AddressName")
+ .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<int?>("CheckReceiveStatus")
+ .HasColumnType("int");
+
+ b.Property<DateTime?>("CheckReceiveTime")
+ .HasColumnType("datetime2");
+
+ b.Property<string>("CityCode")
+ .HasColumnType("nvarchar(128)");
+
+ 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>("EndTime")
+ .HasColumnType("datetime2");
+
+ b.Property<Guid>("EnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<int>("GenderLimit")
+ .HasColumnType("int");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<DateTime?>("LastCheckReceiveTime")
+ .HasColumnType("datetime2");
+
+ b.Property<DateTime?>("LastSubmitTime")
+ .HasColumnType("datetime2");
+
+ b.Property<decimal?>("Latitude")
+ .HasColumnType("decimal(18,6)");
+
+ b.Property<decimal?>("Longitude")
+ .HasColumnType("decimal(18,6)");
+
+ b.Property<string>("Name")
+ .IsRequired()
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("ProvinceCode")
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<int>("RecommendStatus")
+ .HasColumnType("int");
+
+ b.Property<int>("ReleaseStatus")
+ .HasColumnType("int");
+
+ b.Property<decimal>("ServiceFee")
+ .HasColumnType("decimal(18,2)");
+
+ b.Property<int>("SettlementCycle")
+ .HasColumnType("int");
+
+ b.Property<int?>("SettlementStatus")
+ .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?>("UpdatedUserId")
+ .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<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<Guid>("TaskInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("TraceId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<DateTimeOffset?>("UpdatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("UpdatedUserId")
+ .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<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<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?>("UpdatedUserId")
+ .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<int?>("ArrangeStatus")
+ .HasColumnType("int");
+
+ b.Property<DateTime?>("ArrangeTime")
+ .HasColumnType("datetime2");
+
+ b.Property<int?>("CheckReceiveStatus")
+ .HasColumnType("int");
+
+ b.Property<DateTime?>("CheckReceiveTime")
+ .HasColumnType("datetime2");
+
+ b.Property<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<Guid>("EnterpriseEmployeeId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<DateTime?>("LastCheckReceiveTime")
+ .HasColumnType("datetime2");
+
+ b.Property<DateTime?>("LastSubmitTime")
+ .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?>("UpdatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.HasIndex("EnterpriseEmployeeId");
+
+ b.HasIndex("TaskInfoId");
+
+ b.ToTable("TaskInfoUser");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.TaskInfoUserSubmit", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<int>("CheckReceiveStatus")
+ .HasColumnType("int");
+
+ b.Property<DateTime?>("CheckReceiveTime")
+ .HasColumnType("datetime2");
+
+ b.Property<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTime>("Date")
+ .HasColumnType("datetime2");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<Guid>("TaskInfoUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("TraceId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<DateTimeOffset?>("UpdatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("UpdatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.HasIndex("TaskInfoUserId");
+
+ b.ToTable("TaskInfoUserSubmit");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.TaskInfoUserSubmitFile", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("File")
+ .IsRequired()
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<Guid>("SubmitId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("TraceId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<DateTimeOffset?>("UpdatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("UpdatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.HasIndex("SubmitId");
+
+ b.ToTable("TaskInfoUserSubmitFile");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.TaskUserCollect", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ 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<Guid>("TaskInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ 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("TaskInfoId");
+
+ b.HasIndex("UserId");
+
+ b.ToTable("TaskUserCollect");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.User", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<int?>("Age")
+ .HasColumnType("int");
+
+ b.Property<string>("Avatar")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<DateTime?>("Birthday")
+ .HasColumnType("datetime2");
+
+ b.Property<string>("CityCode")
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<string>("ContactPhoneNumber")
+ .HasMaxLength(11)
+ .HasColumnType("nvarchar(11)");
+
+ b.Property<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("EducationalBackgroundCode")
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<Guid?>("EnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<int?>("FreeTime")
+ .HasColumnType("int");
+
+ b.Property<int?>("Gender")
+ .HasColumnType("int");
+
+ b.Property<int?>("Height")
+ .HasColumnType("int");
+
+ b.Property<string>("Identity")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<bool>("IsCheckPhoneNumber")
+ .HasColumnType("bit");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<bool>("IsReal")
+ .HasColumnType("bit");
+
+ b.Property<int?>("JobSeekingStatus")
+ .HasColumnType("int");
+
+ b.Property<int>("Level")
+ .HasColumnType("int");
+
+ b.Property<string>("Name")
+ .HasMaxLength(32)
+ .HasColumnType("nvarchar(32)");
+
+ b.Property<string>("Password")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("PersonalIdentityCode")
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<string>("PhoneNumber")
+ .HasMaxLength(11)
+ .HasColumnType("nvarchar(11)");
+
+ b.Property<string>("ProvinceCode")
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<int?>("RealAccess")
+ .HasColumnType("int");
+
+ b.Property<int?>("RealMethod")
+ .HasColumnType("int");
+
+ b.Property<DateTime?>("RealTime")
+ .HasColumnType("datetime2");
+
+ 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?>("UpdatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("UserName")
+ .IsRequired()
+ .HasMaxLength(32)
+ .HasColumnType("nvarchar(32)");
+
+ 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.ToTable("User");
+
+ 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,
+ Level = 999,
+ Name = "绠＄悊鍛�",
+ Password = "iEYggKrMhQ3ASUGLobra1w==:fn/DsMJUbD9FGpvBvR3moMpMPptdxzZlourPVhU479I=",
+ Sort = 0,
+ Status = 10,
+ Type = 100,
+ UserName = "system"
+ });
+ });
+
+ 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<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .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>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<string>("Name")
+ .IsRequired()
+ .HasMaxLength(32)
+ .HasColumnType("nvarchar(32)");
+
+ b.Property<string>("PhoneNumber")
+ .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?>("UpdatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.ToTable("UserAuth");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserBankCard", 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<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .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?>("UpdatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<Guid>("UserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.HasIndex("UserId");
+
+ b.ToTable("UserBankCard");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserCredential", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("BackImg")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("Code")
+ .HasMaxLength(128)
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .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?>("UpdatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<Guid>("UserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.HasIndex("TypeCode");
+
+ b.HasIndex("UserId");
+
+ b.ToTable("UserCredential");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserDepartment", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .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?>("UpdatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<Guid>("UserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.HasIndex("DepartmentId");
+
+ b.HasIndex("UserId");
+
+ b.ToTable("UserDepartment");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserExpectJob", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("ExpectJobCode")
+ .IsRequired()
+ .HasColumnType("nvarchar(128)");
+
+ 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("ExpectJobCode");
+
+ b.HasIndex("UserId");
+
+ b.ToTable("UserExpectJob");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserPhoto", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .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?>("UpdatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<Guid>("UserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.HasIndex("UserId");
+
+ b.ToTable("UserPhoto");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserRole", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ 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<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?>("UpdatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<Guid>("UserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.HasIndex("RoleId");
+
+ b.HasIndex("UserId");
+
+ b.ToTable("UserRole");
+ });
+
+ 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.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("IndustryType");
+
+ b.Navigation("Province");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.EnterpriseAuth", b =>
+ {
+ b.HasOne("FlexJobApi.Core.Enterprise", "Enterprise")
+ .WithOne("EnterpriseAuth")
+ .HasForeignKey("FlexJobApi.Core.EnterpriseAuth", "Id")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("Enterprise");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.EnterpriseEmployee", b =>
+ {
+ b.HasOne("FlexJobApi.Core.Enterprise", "Enterprise")
+ .WithMany()
+ .HasForeignKey("EnterpriseId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.HasOne("FlexJobApi.Core.User", "User")
+ .WithMany("EnterpriseEmployees")
+ .HasForeignKey("UserId");
+
+ b.Navigation("Enterprise");
+
+ b.Navigation("User");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.EnterpriseUserCollect", b =>
+ {
+ b.HasOne("FlexJobApi.Core.Enterprise", "Enterprise")
+ .WithMany()
+ .HasForeignKey("EnterpriseId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.HasOne("FlexJobApi.Core.User", "User")
+ .WithMany("EnterpriseUserCollects")
+ .HasForeignKey("UserId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("Enterprise");
+
+ b.Navigation("User");
+ });
+
+ 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.Cascade)
+ .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.EnterpriseEmployee", "EnterpriseEmployee")
+ .WithMany("TaskInfoUsers")
+ .HasForeignKey("EnterpriseEmployeeId")
+ .OnDelete(DeleteBehavior.Restrict)
+ .IsRequired();
+
+ b.HasOne("FlexJobApi.Core.TaskInfo", "TaskInfo")
+ .WithMany("TaskInfoUsers")
+ .HasForeignKey("TaskInfoId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("EnterpriseEmployee");
+
+ b.Navigation("TaskInfo");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.TaskInfoUserSubmit", b =>
+ {
+ b.HasOne("FlexJobApi.Core.TaskInfoUser", "TaskInfoUser")
+ .WithMany("Submits")
+ .HasForeignKey("TaskInfoUserId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("TaskInfoUser");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.TaskInfoUserSubmitFile", b =>
+ {
+ b.HasOne("FlexJobApi.Core.TaskInfoUserSubmit", "Submit")
+ .WithMany("Files")
+ .HasForeignKey("SubmitId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("Submit");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.TaskUserCollect", b =>
+ {
+ b.HasOne("FlexJobApi.Core.TaskInfo", "TaskInfo")
+ .WithMany("TaskUserCollects")
+ .HasForeignKey("TaskInfoId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.HasOne("FlexJobApi.Core.User", "User")
+ .WithMany()
+ .HasForeignKey("UserId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("TaskInfo");
+
+ b.Navigation("User");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.User", 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("Users")
+ .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.Navigation("City");
+
+ b.Navigation("EducationalBackground");
+
+ b.Navigation("Enterprise");
+
+ b.Navigation("PersonalIdentity");
+
+ b.Navigation("Province");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserAuth", b =>
+ {
+ b.HasOne("FlexJobApi.Core.User", "User")
+ .WithOne("UserAuth")
+ .HasForeignKey("FlexJobApi.Core.UserAuth", "Id")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("User");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserBankCard", b =>
+ {
+ b.HasOne("FlexJobApi.Core.User", "User")
+ .WithMany("BankCards")
+ .HasForeignKey("UserId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("User");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserCredential", b =>
+ {
+ b.HasOne("FlexJobApi.Core.DictionaryData", "Type")
+ .WithMany()
+ .HasForeignKey("TypeCode")
+ .HasPrincipalKey("Code")
+ .OnDelete(DeleteBehavior.Restrict)
+ .IsRequired();
+
+ b.HasOne("FlexJobApi.Core.User", "User")
+ .WithMany("UserCredentials")
+ .HasForeignKey("UserId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("Type");
+
+ b.Navigation("User");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserDepartment", b =>
+ {
+ b.HasOne("FlexJobApi.Core.Department", "Department")
+ .WithMany()
+ .HasForeignKey("DepartmentId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.HasOne("FlexJobApi.Core.User", "User")
+ .WithMany("UserDepartments")
+ .HasForeignKey("UserId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("Department");
+
+ b.Navigation("User");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserExpectJob", b =>
+ {
+ b.HasOne("FlexJobApi.Core.DictionaryData", "ExpectJob")
+ .WithMany()
+ .HasForeignKey("ExpectJobCode")
+ .HasPrincipalKey("Code")
+ .OnDelete(DeleteBehavior.Restrict)
+ .IsRequired();
+
+ b.HasOne("FlexJobApi.Core.User", "User")
+ .WithMany("UserExpectJobs")
+ .HasForeignKey("UserId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("ExpectJob");
+
+ b.Navigation("User");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserPhoto", b =>
+ {
+ b.HasOne("FlexJobApi.Core.User", "User")
+ .WithMany("Photos")
+ .HasForeignKey("UserId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("User");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserRole", b =>
+ {
+ b.HasOne("FlexJobApi.Core.Role", "Role")
+ .WithMany("UserRoles")
+ .HasForeignKey("RoleId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.HasOne("FlexJobApi.Core.User", "User")
+ .WithMany("UserRoles")
+ .HasForeignKey("UserId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("Role");
+
+ b.Navigation("User");
+ });
+
+ 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("EnterpriseAuth");
+
+ b.Navigation("Users");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.EnterpriseEmployee", b =>
+ {
+ b.Navigation("TaskInfoUsers");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.Menu", b =>
+ {
+ b.Navigation("Children");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.Role", b =>
+ {
+ b.Navigation("RoleMenus");
+
+ b.Navigation("RoleResources");
+
+ b.Navigation("UserRoles");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.TaskInfo", b =>
+ {
+ b.Navigation("Benefits");
+
+ b.Navigation("CredentialLimits");
+
+ b.Navigation("TaskInfoUsers");
+
+ b.Navigation("TaskUserCollects");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.TaskInfoUser", b =>
+ {
+ b.Navigation("Submits");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.TaskInfoUserSubmit", b =>
+ {
+ b.Navigation("Files");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.User", b =>
+ {
+ b.Navigation("BankCards");
+
+ b.Navigation("EnterpriseEmployees");
+
+ b.Navigation("EnterpriseUserCollects");
+
+ b.Navigation("Photos");
+
+ b.Navigation("UserAuth");
+
+ b.Navigation("UserCredentials");
+
+ b.Navigation("UserDepartments");
+
+ b.Navigation("UserExpectJobs");
+
+ b.Navigation("UserRoles");
+ });
+#pragma warning restore 612, 618
+ }
+ }
+}
diff --git a/FlexJobApi.Database.Migrations/Migrations/20250813150148_UpdateResource0813.cs b/FlexJobApi.Database.Migrations/Migrations/20250813150148_UpdateResource0813.cs
new file mode 100644
index 0000000..2368c76
--- /dev/null
+++ b/FlexJobApi.Database.Migrations/Migrations/20250813150148_UpdateResource0813.cs
@@ -0,0 +1,29 @@
+锘縰sing Microsoft.EntityFrameworkCore.Migrations;
+
+#nullable disable
+
+namespace FlexJobApi.Database.Migrations.Migrations
+{
+ /// <inheritdoc />
+ public partial class UpdateResource0813 : Migration
+ {
+ /// <inheritdoc />
+ protected override void Up(MigrationBuilder migrationBuilder)
+ {
+ migrationBuilder.AddColumn<bool>(
+ name: "FileUpload",
+ table: "Resource",
+ type: "bit",
+ nullable: false,
+ defaultValue: false);
+ }
+
+ /// <inheritdoc />
+ protected override void Down(MigrationBuilder migrationBuilder)
+ {
+ migrationBuilder.DropColumn(
+ name: "FileUpload",
+ table: "Resource");
+ }
+ }
+}
diff --git a/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs b/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs
index 0039b18..959fc7c 100644
--- a/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs
+++ b/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs
@@ -701,6 +701,9 @@
b.Property<string>("DynamicAssemblyName")
.HasColumnType("nvarchar(max)");
+ b.Property<bool>("FileUpload")
+ .HasColumnType("bit");
+
b.Property<bool>("IsDeleted")
.HasColumnType("bit");
@@ -2100,7 +2103,7 @@
.IsRequired();
b.HasOne("FlexJobApi.Core.User", "User")
- .WithMany()
+ .WithMany("EnterpriseUserCollects")
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
@@ -2268,7 +2271,7 @@
modelBuilder.Entity("FlexJobApi.Core.TaskUserCollect", b =>
{
b.HasOne("FlexJobApi.Core.TaskInfo", "TaskInfo")
- .WithMany()
+ .WithMany("TaskUserCollects")
.HasForeignKey("TaskInfoId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
@@ -2481,6 +2484,8 @@
b.Navigation("CredentialLimits");
b.Navigation("TaskInfoUsers");
+
+ b.Navigation("TaskUserCollects");
});
modelBuilder.Entity("FlexJobApi.Core.TaskInfoUser", b =>
@@ -2499,6 +2504,8 @@
b.Navigation("EnterpriseEmployees");
+ b.Navigation("EnterpriseUserCollects");
+
b.Navigation("Photos");
b.Navigation("UserAuth");
diff --git a/FlexJobApi.Database.Migrations/Migrations/LogDb/20250813150002_UpdateResource0813.Designer.cs b/FlexJobApi.Database.Migrations/Migrations/LogDb/20250813150002_UpdateResource0813.Designer.cs
new file mode 100644
index 0000000..11aa306
--- /dev/null
+++ b/FlexJobApi.Database.Migrations/Migrations/LogDb/20250813150002_UpdateResource0813.Designer.cs
@@ -0,0 +1,429 @@
+锘�// <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.LogDb
+{
+ [DbContext(typeof(LogDbContext))]
+ [Migration("20250813150002_UpdateResource0813")]
+ partial class UpdateResource0813
+ {
+ /// <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.ConsoleLog", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<int>("Access")
+ .HasColumnType("int");
+
+ b.Property<string>("ClientIpAddress")
+ .HasMaxLength(32)
+ .HasColumnType("nvarchar(32)");
+
+ b.Property<string>("Content")
+ .IsRequired()
+ .HasColumnType("nvarchar(max)");
+
+ 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>("Level")
+ .HasColumnType("int");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<string>("StackTrace")
+ .HasColumnType("nvarchar(max)");
+
+ 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("ConsoleLog");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.DbAuditLog", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ 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<string>("NewValues")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("OldValues")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<int>("Operate")
+ .HasColumnType("int");
+
+ b.Property<Guid>("PrimaryKey")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<string>("TableName")
+ .IsRequired()
+ .HasMaxLength(128)
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<string>("TraceId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<DateTimeOffset?>("UpdatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("UpdatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.ToTable("DbAuditLog");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.Entities.Common.ResourceLog", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("ClientIpAddress")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("Domain")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<long>("ElapsedMilliseconds")
+ .HasColumnType("bigint");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<bool>("IsSuccess")
+ .HasColumnType("bit");
+
+ b.Property<int>("Method")
+ .HasColumnType("int");
+
+ b.Property<string>("Path")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("RefererUrl")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("Request")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("RequestHeaders")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("Response")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("ResponseHeaders")
+ .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?>("UpdatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.ToTable("ResourceLog");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.ExceptionLog", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("Code")
+ .HasMaxLength(32)
+ .HasColumnType("nvarchar(32)");
+
+ 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<string>("Message")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<string>("StackTrace")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("TraceId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("Type")
+ .HasMaxLength(256)
+ .HasColumnType("nvarchar(256)");
+
+ b.Property<DateTimeOffset?>("UpdatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("UpdatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.ToTable("ExceptionLog");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.QueueLog", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<int>("Access")
+ .HasColumnType("int");
+
+ b.Property<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("Data")
+ .IsRequired()
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<long>("ElapsedMilliseconds")
+ .HasColumnType("bigint");
+
+ b.Property<string>("EventId")
+ .IsRequired()
+ .HasMaxLength(128)
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<bool>("IsConsumOnce")
+ .HasColumnType("bit");
+
+ 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.HasKey("Id");
+
+ b.ToTable("QueueLog");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.ScheduleJobTriggerTimeline", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<long>("ElapsedTime")
+ .HasColumnType("bigint");
+
+ b.Property<string>("Exception")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<string>("JobId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<DateTime?>("LastRunTime")
+ .HasColumnType("datetime2");
+
+ b.Property<int>("Mode")
+ .HasColumnType("int");
+
+ b.Property<DateTime?>("NextRunTime")
+ .HasColumnType("datetime2");
+
+ b.Property<long>("NumberOfRuns")
+ .HasColumnType("bigint");
+
+ b.Property<string>("Result")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<long>("Status")
+ .HasColumnType("bigint");
+
+ b.Property<string>("TraceId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("TriggerId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<DateTimeOffset?>("UpdatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("UpdatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.ToTable("ScheduleJobTriggerTimeline");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.SmsLog", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<int>("Access")
+ .HasColumnType("int");
+
+ b.Property<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTime?>("Expiry")
+ .HasColumnType("datetime2");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<bool>("IsUsed")
+ .HasColumnType("bit");
+
+ b.Property<string>("PhoneNumber")
+ .IsRequired()
+ .HasMaxLength(11)
+ .HasColumnType("nvarchar(11)");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<string>("TemplateCode")
+ .IsRequired()
+ .HasMaxLength(128)
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<string>("TemplateParam")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("TraceId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<DateTimeOffset?>("UpdatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("UpdatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.ToTable("SmsLog");
+ });
+#pragma warning restore 612, 618
+ }
+ }
+}
diff --git a/FlexJobApi.Database.Migrations/Migrations/LogDb/20250813150002_UpdateResource0813.cs b/FlexJobApi.Database.Migrations/Migrations/LogDb/20250813150002_UpdateResource0813.cs
new file mode 100644
index 0000000..3128055
--- /dev/null
+++ b/FlexJobApi.Database.Migrations/Migrations/LogDb/20250813150002_UpdateResource0813.cs
@@ -0,0 +1,22 @@
+锘縰sing Microsoft.EntityFrameworkCore.Migrations;
+
+#nullable disable
+
+namespace FlexJobApi.Database.Migrations.Migrations.LogDb
+{
+ /// <inheritdoc />
+ public partial class UpdateResource0813 : Migration
+ {
+ /// <inheritdoc />
+ protected override void Up(MigrationBuilder migrationBuilder)
+ {
+
+ }
+
+ /// <inheritdoc />
+ protected override void Down(MigrationBuilder migrationBuilder)
+ {
+
+ }
+ }
+}
diff --git a/FlexJobApi.Database.Migrations/REDEME.MD b/FlexJobApi.Database.Migrations/REDEME.MD
index 9b5e905..b8e33b5 100644
--- a/FlexJobApi.Database.Migrations/REDEME.MD
+++ b/FlexJobApi.Database.Migrations/REDEME.MD
@@ -1,7 +1,7 @@
-------------------------------主数据库---------------------------------------
新增迁移文件
-dotnet ef migrations add UpdateEnterprise0813 -s "../FlexJobApi.Web.Entry" -c DefaultDbContext
+dotnet ef migrations add UpdateResource0813 -s "../FlexJobApi.Web.Entry" -c DefaultDbContext
删除迁移文件
dotnet ef migrations remove -s "../FlexJobApi.Web.Entry" -c DefaultDbContext
@@ -12,7 +12,7 @@
-------------------------------日志数据库---------------------------------------
新增迁移文件
-dotnet ef migrations add Update0810 -s "../FlexJobApi.Web.Entry" -c LogDbContext
+dotnet ef migrations add UpdateResource0813 -s "../FlexJobApi.Web.Entry" -c LogDbContext
删除迁移文件
dotnet ef migrations remove -s "../FlexJobApi.Web.Entry" -c LogDbContext
diff --git a/FlexJobApi.FlexJobServer.Application/Class1.cs b/FlexJobApi.FlexJobServer.Application/Class1.cs
new file mode 100644
index 0000000..58936bd
--- /dev/null
+++ b/FlexJobApi.FlexJobServer.Application/Class1.cs
@@ -0,0 +1,12 @@
+锘縰sing System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace FlexJobApi.FlexJobServer.Application
+{
+ internal class Class1
+ {
+ }
+}
diff --git a/FlexJobApi.FlexJobServer.Application/FlexJobApi.FlexJobServer.Application.xml b/FlexJobApi.FlexJobServer.Application/FlexJobApi.FlexJobServer.Application.xml
index d7aa267..ae42c5d 100644
--- a/FlexJobApi.FlexJobServer.Application/FlexJobApi.FlexJobServer.Application.xml
+++ b/FlexJobApi.FlexJobServer.Application/FlexJobApi.FlexJobServer.Application.xml
@@ -30,6 +30,14 @@
<param name="cancellationToken"></param>
<returns></returns>
</member>
+ <member name="M:FlexJobApi.FlexJobServer.Application.TaskCheckReceiveCommandHandler.Handle(FlexJobApi.Core.ExportTaskCheckReceiveTaskUsersCommand,System.Threading.CancellationToken)">
+ <summary>
+ 瀵煎嚭楠屾敹璁板綍
+ </summary>
+ <param name="request"></param>
+ <param name="cancellationToken"></param>
+ <returns></returns>
+ </member>
<member name="T:FlexJobApi.FlexJobServer.Application.TaskCheckReceiveQueryHandler">
<summary>
浠诲姟楠屾敹鏌ヨ澶勭悊鍣�
diff --git a/FlexJobApi.FlexJobServer.Application/TaskCheckReceives/Commands/TaskCheckReceiveCommandHandler.cs b/FlexJobApi.FlexJobServer.Application/TaskCheckReceives/Commands/TaskCheckReceiveCommandHandler.cs
index aae3fb4..4a5a2c2 100644
--- a/FlexJobApi.FlexJobServer.Application/TaskCheckReceives/Commands/TaskCheckReceiveCommandHandler.cs
+++ b/FlexJobApi.FlexJobServer.Application/TaskCheckReceives/Commands/TaskCheckReceiveCommandHandler.cs
@@ -20,7 +20,8 @@
IRepository<TaskInfoUserSubmit> repTaskInfoUserSubmit
) :
IRequestHandler<SubmitCheckReceiveTaskCommand, Guid>,
- IRequestHandler<CheckReceiveTaskCommand, Guid>
+ IRequestHandler<CheckReceiveTaskCommand, Guid>,
+ IRequestHandler<ExportTaskCheckReceiveTaskUsersCommand, string>
{
private readonly IRepository<TaskInfo> repTaskInfo = repTaskInfo;
private readonly IRepository<TaskInfoUser> repTaskInfoUser = repTaskInfoUser;
@@ -154,5 +155,31 @@
await repTaskInfoUserSubmit.UpdateAsync(submit);
return submit.Id;
}
+
+ /// <summary>
+ /// 瀵煎嚭楠屾敹璁板綍
+ /// </summary>
+ /// <param name="request"></param>
+ /// <param name="cancellationToken"></param>
+ /// <returns></returns>
+ public async Task<string> Handle(ExportTaskCheckReceiveTaskUsersCommand request, CancellationToken cancellationToken)
+ {
+ var models = await repTaskInfoUserSubmit.AsQueryable().AsNoTracking()
+ .Where(it => it.TaskInfoUser.TaskInfoId == request.Id)
+ .Select(it => new ExportTaskCheckReceiveTaskUsersCommandModel
+ {
+ Name = it.TaskInfoUser.EnterpriseEmployee.User.Name,
+ Identity = it.TaskInfoUser.EnterpriseEmployee.User.Identity,
+ ContactPhoneNumber = it.TaskInfoUser.EnterpriseEmployee.User.ContactPhoneNumber,
+ CheckReceiveStatus = it.CheckReceiveStatus,
+ CheckReceiveTime = it.CheckReceiveTime,
+ Bank = "123",
+ Code = "456"
+ })
+ .ToListAsync(cancellationToken);
+ var url = await models.ExportExcelToOSS("TaskCheckReceive/Export", "楠屾敹璁板綍.xlsx");
+ url = AliyunOSSUtils.GetUrl(url);
+ return url;
+ }
}
}
diff --git a/FlexJobApi.FlexJobServer.Application/Tasks/Queries/TaskInfoQueryHandler.cs b/FlexJobApi.FlexJobServer.Application/Tasks/Queries/TaskInfoQueryHandler.cs
index 48d49a8..11d952f 100644
--- a/FlexJobApi.FlexJobServer.Application/Tasks/Queries/TaskInfoQueryHandler.cs
+++ b/FlexJobApi.FlexJobServer.Application/Tasks/Queries/TaskInfoQueryHandler.cs
@@ -136,7 +136,7 @@
{
q = q.Where(it => it.GenderLimit == request.GenderLimit);
}
- if (logier.Type == EnumUserType.Personal && request.IsCollected == true)
+ if (logier != null && logier.Type == EnumUserType.Personal && request.IsCollected == true)
{
q = q.Where(it => it.TaskUserCollects.Any(c => c.UserId == logier.Id));
}
diff --git a/FlexJobApi.UserServer.Application/EnterpriseEmployees/Commands/EnterpriseEmployeesCommandHandler.cs b/FlexJobApi.UserServer.Application/EnterpriseEmployees/Commands/EnterpriseEmployeesCommandHandler.cs
index fbda053..cd62045 100644
--- a/FlexJobApi.UserServer.Application/EnterpriseEmployees/Commands/EnterpriseEmployeesCommandHandler.cs
+++ b/FlexJobApi.UserServer.Application/EnterpriseEmployees/Commands/EnterpriseEmployeesCommandHandler.cs
@@ -1,9 +1,12 @@
锘縰sing FlexJobApi.Core;
+using Furion;
using Furion.DatabaseAccessor;
using Furion.FriendlyException;
+using Furion.HttpRemote;
using Mapster;
using MediatR;
using Microsoft.EntityFrameworkCore;
+using MiniExcelLibs;
using System;
using System.Collections.Generic;
using System.Linq;
@@ -23,8 +26,16 @@
{
private readonly IRepository<EnterpriseEmployee> rep = rep;
- public Task<int> Handle(ImportEnterpriseEmployeesCommand request, CancellationToken cancellationToken)
+ /// <summary>
+ /// 瀵煎叆鐏靛伐淇℃伅
+ /// </summary>
+ /// <param name="request"></param>
+ /// <param name="cancellationToken"></param>
+ /// <returns></returns>
+ public async Task<int> Handle(ImportEnterpriseEmployeesCommand request, CancellationToken cancellationToken)
{
+ var models = await request.ExcelUrl.ImportExcelFromOSS<ImportEnterpriseEmployeesCommandModel>();
+ Console.WriteLine();
throw new NotImplementedException();
}
diff --git a/FlexJobApi.UserServer.Application/FlexJobApi.UserServer.Application.xml b/FlexJobApi.UserServer.Application/FlexJobApi.UserServer.Application.xml
index 23cfbcd..9a3d2d3 100644
--- a/FlexJobApi.UserServer.Application/FlexJobApi.UserServer.Application.xml
+++ b/FlexJobApi.UserServer.Application/FlexJobApi.UserServer.Application.xml
@@ -166,6 +166,14 @@
鐏靛伐鍛戒护澶勭悊鍣�
</summary>
</member>
+ <member name="M:FlexJobApi.UserServer.Application.EnterpriseEmployeesCommandHandler.Handle(FlexJobApi.Core.ImportEnterpriseEmployeesCommand,System.Threading.CancellationToken)">
+ <summary>
+ 瀵煎叆鐏靛伐淇℃伅
+ </summary>
+ <param name="request"></param>
+ <param name="cancellationToken"></param>
+ <returns></returns>
+ </member>
<member name="M:FlexJobApi.UserServer.Application.EnterpriseEmployeesCommandHandler.Handle(FlexJobApi.Core.EditEnterpriseEmployeeCommand,System.Threading.CancellationToken)">
<summary>
缂栬緫鐏靛伐淇℃伅
@@ -702,6 +710,24 @@
<member name="M:FlexJobApi.UserServer.Application.GetOperationUserInfosQueryHandler.Handle(FlexJobApi.Core.GetOperationUserInfosQuery,System.Threading.CancellationToken)">
<inheritdoc/>
</member>
+ <member name="T:FlexJobApi.UserServer.Application.GetPersonalUserInfosQueryHandler">
+ <summary>
+ C绔汉鍛樻煡璇㈠鐞嗗櫒
+ </summary>
+ </member>
+ <member name="M:FlexJobApi.UserServer.Application.GetPersonalUserInfosQueryHandler.#ctor(Furion.DatabaseAccessor.IRepository{FlexJobApi.Core.User})">
+ <summary>
+ C绔汉鍛樻煡璇㈠鐞嗗櫒
+ </summary>
+ </member>
+ <member name="M:FlexJobApi.UserServer.Application.GetPersonalUserInfosQueryHandler.Handle(FlexJobApi.Core.GetPersonalUserInfosQuery,System.Threading.CancellationToken)">
+ <summary>
+ 鏌ヨC绔汉鍛樺垎椤靛垪琛ㄦ暟鎹�
+ </summary>
+ <param name="request"></param>
+ <param name="cancellationToken"></param>
+ <returns></returns>
+ </member>
<member name="T:FlexJobApi.UserServer.Application.GetUserInfoRolesQueryHandler">
<summary>
鏌ヨ鐢ㄦ埛瑙掕壊鍒楄〃
diff --git a/FlexJobApi.UserServer.Application/Users/Queries/GetOperationUserInfosQueryHandler.cs b/FlexJobApi.UserServer.Application/Users/Queries/GetOperationUserInfosQueryHandler.cs
index e9b2cc5..f1badb8 100644
--- a/FlexJobApi.UserServer.Application/Users/Queries/GetOperationUserInfosQueryHandler.cs
+++ b/FlexJobApi.UserServer.Application/Users/Queries/GetOperationUserInfosQueryHandler.cs
@@ -24,7 +24,7 @@
/// <inheritdoc/>
public async Task<PagedListQueryResult<GetOperationUserInfosQueryResultItem>> Handle(GetOperationUserInfosQuery request, CancellationToken cancellationToken)
{
- var result = await request.PageModel.GetPagedListAsync<Core.User, GetOperationUserInfosQueryResultItem>(
+ var result = await request.PageModel.GetPagedListAsync<User, GetOperationUserInfosQueryResultItem>(
q =>
{
q = q.OrderByDescending(it => it.Level).ThenByDescending(it => it.CreatedTime)
diff --git a/FlexJobApi.UserServer.Application/Users/Queries/GetPersonalUserInfosQueryHandler.cs b/FlexJobApi.UserServer.Application/Users/Queries/GetPersonalUserInfosQueryHandler.cs
new file mode 100644
index 0000000..5ee6ff5
--- /dev/null
+++ b/FlexJobApi.UserServer.Application/Users/Queries/GetPersonalUserInfosQueryHandler.cs
@@ -0,0 +1,97 @@
+锘縰sing FlexJobApi.Core;
+using Furion.DatabaseAccessor;
+using MediatR;
+using Microsoft.EntityFrameworkCore;
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace FlexJobApi.UserServer.Application
+{
+ /// <summary>
+ /// C绔汉鍛樻煡璇㈠鐞嗗櫒
+ /// </summary>
+ public class GetPersonalUserInfosQueryHandler(
+ IRepository<User> rep
+ ) :
+ IRequestHandler<GetPersonalUserInfosQuery, GetPersonalUserInfosQueryResult>
+ {
+ private readonly IRepository<User> rep = rep;
+
+ /// <summary>
+ /// 鏌ヨC绔汉鍛樺垎椤靛垪琛ㄦ暟鎹�
+ /// </summary>
+ /// <param name="request"></param>
+ /// <param name="cancellationToken"></param>
+ /// <returns></returns>
+ public async Task<GetPersonalUserInfosQueryResult> Handle(GetPersonalUserInfosQuery request, CancellationToken cancellationToken)
+ {
+ var logier = JwtUtils.GetCurrentLogier();
+ var q = rep.AsQueryable().AsNoTracking();
+ if (request.Keywords.IsNotNull())
+ {
+ q = q.Where(it =>
+ it.Name.Contains(request.Keywords)
+ || it.ContactPhoneNumber.Contains(request.Keywords)
+ || it.Identity.Contains(request.Keywords)
+ || it.EnterpriseEmployees.Any(e => e.Enterprise.EnterpriseName.Contains(request.Keywords)));
+ }
+ if (request.HireTimeBegin.HasValue && request.HireTimeEnd.HasValue)
+ {
+ q = q.Where(it =>
+ it.EnterpriseEmployees.Any(e =>
+ e.HireStatus == EnumTaskUserHireStatus.Pass
+ && e.HireTime.HasValue
+ && request.HireTimeBegin <= e.HireTime
+ && e.HireTime <= request.HireTimeEnd));
+ }
+ if (request.SignContractBegin.HasValue && request.SignContractEnd.HasValue)
+ {
+ q = q.Where(it =>
+ it.EnterpriseEmployees.Any(e =>
+ e.UserSignContractStatus == EnumTaskUserSignContractStatus.Pass
+ && e.UserSignContractTime.HasValue
+ && request.SignContractBegin <= e.UserSignContractTime
+ && e.UserSignContractTime <= request.SignContractEnd
+ || e.EnterpriseSignContractStatus == EnumTaskUserSignContractStatus.Pass
+ && e.EnterpriseSignContractTime.HasValue
+ && request.SignContractBegin <= e.EnterpriseSignContractTime
+ && e.EnterpriseSignContractTime <= request.SignContractEnd));
+ }
+ if (request.IsReal.HasValue)
+ {
+ q = q.Where(it => it.IsReal == request.IsReal);
+ }
+ var s = q.Select(it => new GetPersonalUserInfosQueryResultItem
+ {
+ Id = it.Id,
+ Name = it.Name,
+ ContactPhoneNumber = it.ContactPhoneNumber,
+ Identity = it.Identity,
+ Gender = it.Gender,
+ Age = it.Age,
+ ProvinceCode = it.ProvinceCode,
+ ProvinceContent = it.Province.Content,
+ CityCode = it.CityCode,
+ CityContent = it.City.Content,
+ Enterprises = it.EnterpriseEmployees.Select(e => e.Enterprise.EnterpriseName).ToList(),
+ IsReal = it.IsReal,
+ RealTime = it.RealTime,
+ HireTime = it.EnterpriseEmployees
+ .OrderByDescending(e => e.HireTime)
+ .Where(e => e.HireStatus == EnumTaskUserHireStatus.Pass && e.HireTime.HasValue)
+ .Select(e => e.HireTime)
+ .FirstOrDefault(),
+ SignContractTime = it.EnterpriseEmployees
+ .OrderByDescending(e => e.EnterpriseSignContractTime > e.UserSignContractTime ? e.EnterpriseSignContractTime : e.UserSignContractTime)
+ .Where(e => e.HireStatus == EnumTaskUserHireStatus.Pass && e.HireTime.HasValue)
+ .Select(e => e.HireTime)
+ .FirstOrDefault(),
+ });
+ var result = await request.PageModel.GetPagedListAsync<GetPersonalUserInfosQueryResult, GetPersonalUserInfosQueryResultItem>(s, cancellationToken);
+ return result;
+ }
+ }
+}
--
Gitblit v1.9.1