AiDOPWarehouse/server/Plugins/Admin.NET.Plugin.AiDOP/Entity/AdoWorkOrder.cs

namespace Admin.NET.Plugin.AiDOP.Entity;

/// <summary>
/// Demo 工单表 ado_work_orders
/// </summary>
[SugarTable("ado_work_orders", "AiDOP Demo 工单")]
public class AdoWorkOrder
{
    [SugarColumn(ColumnDescription = "主键", IsPrimaryKey = true, IsIdentity = true, ColumnDataType = "integer")]
    public long Id { get; set; }

    [SugarColumn(ColumnDescription = "工单号", Length = 50)]
    public string WorkOrderNo { get; set; } = string.Empty;

    [SugarColumn(ColumnDescription = "计划Id", IsNullable = true)]
    public long? PlanId { get; set; }

    [SugarColumn(ColumnDescription = "计划号", Length = 50, IsNullable = true)]
    public string? PlanNo { get; set; }

    [SugarColumn(ColumnDescription = "产品Id", IsNullable = true)]
    public long? ProductId { get; set; }

    [SugarColumn(ColumnDescription = "产品", Length = 200)]
    public string Product { get; set; } = string.Empty;

    [SugarColumn(ColumnDescription = "数量")]
    public int Quantity { get; set; }

    [SugarColumn(ColumnDescription = "已完成数量")]
    public int CompletedQuantity { get; set; }

    [SugarColumn(ColumnDescription = "工作中心", Length = 100)]
    public string WorkCenter { get; set; } = string.Empty;

    [SugarColumn(ColumnDescription = "班组", Length = 100, IsNullable = true)]
    public string? Team { get; set; }

    [SugarColumn(ColumnDescription = "负责人", Length = 100, IsNullable = true)]
    public string? Owner { get; set; }

    [SugarColumn(ColumnDescription = "开始日期", IsNullable = true)]
    public DateTime? StartDate { get; set; }

    [SugarColumn(ColumnDescription = "计划完工", IsNullable = true)]
    public DateTime? PlanEndDate { get; set; }

    [SugarColumn(ColumnDescription = "实际完工", IsNullable = true)]
    public DateTime? ActualEndDate { get; set; }

    [SugarColumn(ColumnDescription = "状态", Length = 50)]
    public string Status { get; set; } = "待生产";

    [SugarColumn(ColumnDescription = "优先级", Length = 50)]
    public string Priority { get; set; } = "中";

    [SugarColumn(ColumnDescription = "备注", Length = 1000, IsNullable = true)]
    public string? Remark { get; set; }

    [SugarColumn(ColumnDescription = "创建时间")]
    public DateTime CreatedTime { get; set; }

    [SugarColumn(ColumnDescription = "更新时间", IsNullable = true)]
    public DateTime? UpdatedTime { get; set; }

    [SugarColumn(ColumnDescription = "创建人", Length = 100, IsNullable = true)]
    public string? CreatedBy { get; set; }
}