using SqlSugar;

namespace NewPdaSqlServer.entity;

/// <summary>
///     报工主表
/// </summary>
[SugarTable("MES_WORK_PROD")]
public class MesWorkProd
{
    /// <summary>
    ///     唯一标识符
    ///     默认值: (newid())
    /// </summary>
    [SugarColumn(ColumnName = "id", IsPrimaryKey = true)]
    public Guid Id { get; set; }

    /// <summary>
    ///     报工单号
    /// </summary>
    [SugarColumn(ColumnName = "bill_no")]
    public string BillNo { get; set; }

    /// <summary>
    ///     生产线
    /// </summary>
    [SugarColumn(ColumnName = "line_no")]
    public string LineNo { get; set; }

    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "company")]
    public string Company { get; set; }

    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "factory")]
    public string Factory { get; set; }

    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "create_by")]
    public string CreateBy { get; set; }

    /// <summary>
    ///     创建日期
    ///     默认值: (getdate())
    /// </summary>
    [SugarColumn(ColumnName = "create_date")]
    public DateTime? CreateDate { get; set; }

    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "lastupdate_by")]
    public string LastupdateBy { get; set; }

    /// <summary>
    ///     默认值: (getdate())
    /// </summary>
    [SugarColumn(ColumnName = "lastupdate_date")]
    public DateTime? LastupdateDate { get; set; }

    /// <summary>
    ///     班次
    /// </summary>
    [SugarColumn(ColumnName = "class_no")]
    public string ClassNo { get; set; }

    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "check_user")]
    public string CheckUser { get; set; }

    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "check_date")]
    public DateTime? CheckDate { get; set; }

    /// <summary>
    ///     默认值: ((0))
    /// </summary>
    [SugarColumn(ColumnName = "status")]
    public int? Status { get; set; }

    /// <summary>
    ///     派工单号
    /// </summary>
    [SugarColumn(ColumnName = "pbill_no")]
    public string PbillNo { get; set; }

    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "bill_type_id")]
    public decimal? BillTypeId { get; set; }

    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "transaction_no")]
    public decimal? TransactionNo { get; set; }

    /// <summary>
    ///     任务单号
    /// </summary>
    [SugarColumn(ColumnName = "task_no")]
    public string TaskNo { get; set; }

    /// <summary>
    ///     卡板数量
    /// </summary>
    [SugarColumn(ColumnName = "kb_qty")]
    public decimal? KbQty { get; set; }

    /// <summary>
    ///     每箱数量
    /// </summary>
    [SugarColumn(ColumnName = "box_qty")]
    public decimal? BoxQty { get; set; }

    /// <summary>
    ///     报工人员
    /// </summary>
    [SugarColumn(ColumnName = "report_by")]
    public string? ReportBy { get; set; }
    /// <summary>
    ///     报工时间
    /// </summary>
    [SugarColumn(ColumnName = "report_date")]
    public DateTime? ReportDate { get; set; }
}