65 lines
1.7 KiB
C#
65 lines
1.7 KiB
C#
using FreeSql.DataAnnotations;
|
||
using System;
|
||
|
||
namespace FATrace.Model
|
||
{
|
||
/// <summary>
|
||
/// Excel 文件导入日志,用于追踪每次导入结果与行数统计
|
||
/// </summary>
|
||
[Table(Name = "FileImportLog")]
|
||
public class FileImportLog
|
||
{
|
||
/// <summary>
|
||
/// 主键
|
||
/// </summary>
|
||
[Column(IsPrimary = true, IsIdentity = true)]
|
||
public long Id { get; set; }
|
||
|
||
/// <summary>
|
||
/// 文件名(包含时间戳),例如:20251218161818.xlsx
|
||
/// </summary>
|
||
[Column(StringLength = 260)]
|
||
public string? FileName { get; set; }
|
||
|
||
/// <summary>
|
||
/// 源文件完整路径
|
||
/// </summary>
|
||
[Column(StringLength = 500)]
|
||
public string? SourcePath { get; set; }
|
||
|
||
/// <summary>
|
||
/// 归档后完整路径
|
||
/// </summary>
|
||
[Column(StringLength = 500)]
|
||
public string? ArchivePath { get; set; }
|
||
|
||
/// <summary>
|
||
/// 导入开始时间
|
||
/// </summary>
|
||
public DateTime StartTime { get; set; }
|
||
|
||
/// <summary>
|
||
/// 导入结束时间
|
||
/// </summary>
|
||
public DateTime EndTime { get; set; }
|
||
|
||
/// <summary>
|
||
/// 导入状态:Success / Failed / Partial 等
|
||
/// </summary>
|
||
[Column(StringLength = 20)]
|
||
public string? Status { get; set; }
|
||
|
||
/// <summary>
|
||
/// 错误或摘要信息
|
||
/// </summary>
|
||
[Column(StringLength = 1000)]
|
||
public string? Message { get; set; }
|
||
|
||
/// <summary>
|
||
/// 每个 Sheet 的行数统计摘要,例如:FactoryInbound=100;FactoryOutbound=50
|
||
/// </summary>
|
||
[Column(StringLength = 1000)]
|
||
public string? SheetRowStats { get; set; }
|
||
}
|
||
}
|