using SqlSugar;
using WIDESEA_Core.DB.Models;

namespace WIDESEA_Model.Models;

/// <summary>
/// 出库分拣表
/// </summary>
[SugarTable("Dt_OutOrderSorting", "出库分拣表")]
public class Dt_OutOrderSorting : BaseEntity
{
    /// <summary>
    /// 分拣单号，唯一标识分拣任务。
    /// </summary>
    [SugarColumn(ColumnName = "SortingID", IsPrimaryKey = true, Length = 50, IsNullable = false, IsIdentity = true, ColumnDescription = "分拣单号，唯一标识分拣任务。")]
    public int SortingID { get; set; }

    /// <summary>
    /// 订单号，关联出库订单编号。
    /// </summary>
    [SugarColumn(ColumnName = "OrderID", Length = 50, IsNullable = false, ColumnDescription = "订单号，关联出库订单编号。")]
    public string OrderCode { get; set; }

    /// <summary>
    /// 客户名称。
    /// </summary>
    [SugarColumn(ColumnName = "CustomerName", Length = 100, IsNullable = true, ColumnDescription = "客户名称。")]
    public string? CustomerName { get; set; }

    /// <summary>
    /// 分拣日期，分拣任务的执行日期。
    /// </summary>
    [SugarColumn(ColumnName = "SortingDate", IsNullable = true, ColumnDescription = "分拣日期，分拣任务的执行日期。")]
    public DateTime? SortingDate { get; set; }

    /// <summary>
    /// 分拣员，执行分拣任务的员工名称或编号。
    /// </summary>
    [SugarColumn(ColumnName = "Picker", Length = 50, IsNullable = true, ColumnDescription = "分拣员，执行分拣任务的员工名称或编号。")]
    public string? Picker { get; set; }

    /// <summary>
    /// 分拣状态，分拣任务的状态（如：未开始、进行中、已完成、已取消）。
    /// </summary>
    [SugarColumn(ColumnName = "SortingStatus", Length = 50, IsNullable = true, ColumnDescription = "分拣状态，分拣任务的状态（如：未开始、进行中、已完成、已取消）。")]
    public string? SortingStatus { get; set; }

    /// <summary>
    /// 产品编码，产品的唯一标识码。
    /// </summary>
    [SugarColumn(ColumnName = "MaterielCode", Length = 50, IsNullable = false, ColumnDescription = "产品编码，产品的唯一标识码。")]
    public string MaterielCode { get; set; }

    /// <summary>
    /// 产品名称。
    /// </summary>
    [SugarColumn(ColumnName = "MaterielName", Length = 100, IsNullable = true, ColumnDescription = "产品名称。")]
    public string? MaterielName { get; set; }

    /// <summary>
    /// 规格型号，产品的规格或型号。
    /// </summary>
    [SugarColumn(ColumnName = "Specification", Length = 100, IsNullable = true, ColumnDescription = "规格型号，产品的规格或型号。")]
    public string? Specification { get; set; }

    /// <summary>
    /// 单位，产品的计量单位（如：件、箱、托盘）。
    /// </summary>
    [SugarColumn(ColumnName = "Unit", Length = 20, IsNullable = true, ColumnDescription = "单位，产品的计量单位（如：件、箱、托盘）。")]
    public string? Unit { get; set; }

    /// <summary>
    /// 需求数量，订单中需要分拣的产品数量。
    /// </summary>
    [SugarColumn(ColumnName = "RequiredQuantity", IsNullable = true, ColumnDescription = "需求数量，订单中需要分拣的产品数量。")]
    public int? RequiredQuantity { get; set; }

    /// <summary>
    /// 分拣数量，实际分拣的产品数量。
    /// </summary>
    [SugarColumn(ColumnName = "SortedQuantity", IsNullable = true, ColumnDescription = "分拣数量，实际分拣的产品数量。")]
    public int? SortedQuantity { get; set; }

    /// <summary>
    /// 库存位置，产品在仓库中的存储位置。
    /// </summary>
    [SugarColumn(ColumnName = "StockLocation", Length = 50, IsNullable = true, ColumnDescription = "库存位置，产品在仓库中的存储位置。")]
    public string? StockLocation { get; set; }

    /// <summary>
    /// 分拣顺序，分拣任务的执行顺序。
    /// </summary>
    [SugarColumn(ColumnName = "SortingOrder", IsNullable = true, ColumnDescription = "分拣顺序，分拣任务的执行顺序。")]
    public int? SortingOrder { get; set; }

    /// <summary>
    /// 分拣区域，产品所在的仓库区域。
    /// </summary>
    [SugarColumn(ColumnName = "SortingZone", Length = 50, IsNullable = true, ColumnDescription = "分拣区域，产品所在的仓库区域。")]
    public string? SortingZone { get; set; }

    /// <summary>
    /// 分拣方式，分拣的方法（如：人工分拣、自动化分拣）。
    /// </summary>
    [SugarColumn(ColumnName = "SortingMethod", Length = 50, IsNullable = true, ColumnDescription = "分拣方式，分拣的方法（如：人工分拣、自动化分拣）。")]
    public string? SortingMethod { get; set; }

    /// <summary>
    /// 分拣备注，分拣过程中的特殊说明或注意事项。
    /// </summary>
    [SugarColumn(ColumnName = "SortingRemarks", Length = 500, IsNullable = true, ColumnDescription = "分拣备注，分拣过程中的特殊说明或注意事项。")]
    public string? SortingRemarks { get; set; }

    /// <summary>
    /// 分拣完成时间，分拣任务完成的具体时间。
    /// </summary>
    [SugarColumn(ColumnName = "SortingCompletionTime", IsNullable = true, ColumnDescription = "分拣完成时间，分拣任务完成的具体时间。")]
    public DateTime? SortingCompletionTime { get; set; }

    /// <summary>
    /// 分拣差异，需求数量与分拣数量的差异。
    /// </summary>
    [SugarColumn(ColumnName = "SortingDifference", IsNullable = true, ColumnDescription = "分拣差异，需求数量与分拣数量的差异。")]
    public int? SortingDifference { get; set; }

    /// <summary>
    /// 差异原因，分拣差异的原因（如：库存不足、分拣错误）。
    /// </summary>
    [SugarColumn(ColumnName = "DifferenceReason", Length = 500, IsNullable = true, ColumnDescription = "差异原因，分拣差异的原因（如：库存不足、分拣错误）。")]
    public string? DifferenceReason { get; set; }

    /// <summary>
    /// 复核员，对分拣结果进行复核的员工姓名或编号。
    /// </summary>
    [SugarColumn(ColumnName = "Reviewer", Length = 50, IsNullable = true, ColumnDescription = "复核员，对分拣结果进行复核的员工姓名或编号。")]
    public string? Reviewer { get; set; }

    /// <summary>
    /// 复核结果，复核的结果（如：通过、需重新分拣）。
    /// </summary>
    [SugarColumn(ColumnName = "ReviewResult", Length = 50, IsNullable = true, ColumnDescription = "复核结果，复核的结果（如：通过、需重新分拣）。")]
    public string? ReviewResult { get; set; }

    /// <summary>
    /// 备注，其他需要记录的信息或特殊说明。
    /// </summary>
    [SugarColumn(ColumnName = "Comments", Length = 500, IsNullable = true, ColumnDescription = "备注，其他需要记录的信息或特殊说明。")]
    public string? Comments { get; set; }
}