AiDOPWarehouse/server/Plugins/Admin.NET.Plugin.AiDOP/WorkOrder/Entity/WorkOrdMaster.cs

namespace Admin.NET.Plugin.AiDOP.WorkOrder;

/// <summary>
/// 工单主数据（WorkOrdMaster）
/// </summary>
[SugarTable("WorkOrdMaster", "工单主数据")]
public class WorkOrdMaster
{
    /// <summary>自增列</summary>
    [SugarColumn(ColumnName = "RecID", IsPrimaryKey = true, IsIdentity = true)]
    public long RecID { get; set; }

    [SugarColumn(ColumnName = "Domain", Length = 8, IsNullable = true)]
    public string? Domain { get; set; }

    [SugarColumn(ColumnName = "WorkOrd", Length = 64, IsNullable = true)]
    public string? WorkOrd { get; set; }

    [SugarColumn(ColumnName = "ItemNum", Length = 30, IsNullable = true)]
    public string? ItemNum { get; set; }

    [SugarColumn(ColumnName = "Site", Length = 8, IsNullable = true)]
    public string? Site { get; set; }

    [SugarColumn(ColumnName = "Status", Length = 1, IsNullable = true)]
    public string? Status { get; set; }

    [SugarColumn(ColumnName = "Typed", Length = 1, IsNullable = true)]
    public string? Typed { get; set; }

    [SugarColumn(ColumnName = "QtyOrded", IsNullable = true)]
    public decimal? QtyOrded { get; set; }

    [SugarColumn(ColumnName = "QtyCompleted", IsNullable = true)]
    public decimal? QtyCompleted { get; set; }

    [SugarColumn(ColumnName = "QtyReject", IsNullable = true)]
    public decimal? QtyReject { get; set; }

    [SugarColumn(ColumnName = "OrdDate", IsNullable = true)]
    public DateTime? OrdDate { get; set; }

    [SugarColumn(ColumnName = "DueDate", IsNullable = true)]
    public DateTime? DueDate { get; set; }

    [SugarColumn(ColumnName = "ReleaseDate", IsNullable = true)]
    public DateTime? ReleaseDate { get; set; }

    [SugarColumn(ColumnName = "ProdLine", Length = 8, IsNullable = true)]
    public string? ProdLine { get; set; }

    [SugarColumn(ColumnName = "Location", Length = 10, IsNullable = true)]
    public string? Location { get; set; }

    [SugarColumn(ColumnName = "Project", Length = 24, IsNullable = true)]
    public string? Project { get; set; }

    [SugarColumn(ColumnName = "Drawing", Length = 64, IsNullable = true)]
    public string? Drawing { get; set; }

    [SugarColumn(ColumnName = "Rev", Length = 6, IsNullable = true)]
    public string? Rev { get; set; }

    [SugarColumn(ColumnName = "Engineer", Length = 8, IsNullable = true)]
    public string? Engineer { get; set; }

    [SugarColumn(ColumnName = "Remark", Length = 512, IsNullable = true)]
    public string? Remark { get; set; }

    [SugarColumn(ColumnName = "Priority", IsNullable = true)]
    public int? Priority { get; set; }

    [SugarColumn(ColumnName = "Urgent", IsNullable = true)]
    public int? Urgent { get; set; }

    [SugarColumn(ColumnName = "CustNo", Length = 64, IsNullable = true)]
    public string? CustNo { get; set; }

    [SugarColumn(ColumnName = "Class", Length = 64, IsNullable = true)]
    public string? Class { get; set; }

    [SugarColumn(ColumnName = "ItemName", Length = 256, IsNullable = true)]
    public string? ItemName { get; set; }

    [SugarColumn(ColumnName = "Batch", Length = 64, IsNullable = true)]
    public string? Batch { get; set; }

    [SugarColumn(ColumnName = "RoutingCode", Length = 32, IsNullable = true)]
    public string? RoutingCode { get; set; }

    [SugarColumn(ColumnName = "BOMFormula", Length = 32, IsNullable = true)]
    public string? BOMFormula { get; set; }

    // 成本相关字段
    [SugarColumn(ColumnName = "MaterialCost", IsNullable = true)]
    public decimal? MaterialCost { get; set; }

    [SugarColumn(ColumnName = "LaborCost1", IsNullable = true)]
    public decimal? LaborCost1 { get; set; }

    [SugarColumn(ColumnName = "BurdenCost", IsNullable = true)]
    public decimal? BurdenCost { get; set; }

    [SugarColumn(ColumnName = "SubcontractCost1", IsNullable = true)]
    public decimal? SubcontractCost1 { get; set; }

    [SugarColumn(ColumnName = "UnitCost", IsNullable = true)]
    public decimal? UnitCost { get; set; }

    [SugarColumn(ColumnName = "WipCost", IsNullable = true)]
    public decimal? WipCost { get; set; }

    // 其他业务字段
    [SugarColumn(ColumnName = "Ufld1", Length = 64, IsNullable = true)]
    public string? Ufld1 { get; set; }

    [SugarColumn(ColumnName = "Ufld2", Length = 64, IsNullable = true)]
    public string? Ufld2 { get; set; }

    [SugarColumn(ColumnName = "Department", Length = 64, IsNullable = true)]
    public string? Department { get; set; }

    [SugarColumn(ColumnName = "ModelItem", Length = 64, IsNullable = true)]
    public string? ModelItem { get; set; }

    [SugarColumn(ColumnName = "FlowStatus", Length = 32, IsNullable = true)]
    public string? FlowStatus { get; set; }

    // 审批字段
    [SugarColumn(ColumnName = "BusinessID", IsNullable = true)]
    public long? BusinessID { get; set; }

    [SugarColumn(ColumnName = "CreateUser", Length = 8, IsNullable = true)]
    public string? CreateUser { get; set; }

    [SugarColumn(ColumnName = "CreateTime", IsNullable = true)]
    public DateTime? CreateTime { get; set; }

    [SugarColumn(ColumnName = "UpdateUser", Length = 8, IsNullable = true)]
    public string? UpdateUser { get; set; }

    [SugarColumn(ColumnName = "UpdateTime", IsNullable = true)]
    public DateTime? UpdateTime { get; set; }

    [SugarColumn(ColumnName = "IsActive", IsNullable = true)]
    public int? IsActive { get; set; }

    [SugarColumn(ColumnName = "IsConfirm", IsNullable = true)]
    public int? IsConfirm { get; set; }

    /// <summary>租户ID（多租户隔离）</summary>
    [SugarColumn(ColumnName = "tenant_id", IsNullable = true)]
    public long? TenantId { get; set; }
}