using SqlSugar;

namespace PadApplication.Entites.DbModels;

/// <summary>
///     机台报工记录
/// </summary>
[SugarTable("MES_REPORTING")]
public class MesReporting
{
    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_JTBG",
        IsPrimaryKey = true)]
    public decimal Id { get; set; }

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

    /// <summary>
    ///     产品编码
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_NO")]
    public string? ItemNo { get; set; }

    /// <summary>
    ///     已产数量
    /// </summary>
    [SugarColumn(ColumnName = "OK_QTY")]
    public decimal? OkQty { get; set; }

    /// <summary>
    ///     报废数量
    /// </summary>
    [SugarColumn(ColumnName = "BF_QTY")]
    public decimal? BfQty { get; set; }

    /// <summary>
    ///     机台编号
    /// </summary>
    [SugarColumn(ColumnName = "MACHINE_NO")]
    public string? MachineNo { get; set; }

    /// <summary>
    ///     据点
    /// </summary>
    [SugarColumn(ColumnName = "ADDRESS_CODE")]
    public string? AddressCode { get; set; }

    /// <summary>
    ///     报工人
    /// </summary>
    [SugarColumn(ColumnName = "BG_PERSON")]
    public string? BgPerson { get; set; }

    /// <summary>
    ///     报工时间
    /// </summary>
    [SugarColumn(ColumnName = "BG_DATE")]
    public DateTime? BgDate { get; set; }

    /// <summary>
    ///     最后修改人
    /// </summary>
    [SugarColumn(ColumnName = "LASTUPDATE_BY")]
    public string? LastupdateBy { get; set; }

    /// <summary>
    ///     最后修改时间
    /// </summary>
    [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
    public DateTime? LastupdateDate { get; set; }

    /// <summary>
    ///     产品条码
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_NO_CADE")]
    public string? ItemNoCade { get; set; }

    /// <summary>
    ///     料头克重
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_HEAD_WEIGHT")]
    public decimal? ItemHeadWeight { get; set; }

    /// <summary>
    ///     不良名称
    /// </summary>
    [SugarColumn(ColumnName = "BF_ITEM_NAME")]
    public string? BfItemName { get; set; }

    /// <summary>
    ///     部门ID
    /// </summary>
    [SugarColumn(ColumnName = "DEPARTMENT_ID")]
    public string? DepartmentId { get; set; }

    /// <summary>
    ///     审核人
    /// </summary>
    [SugarColumn(ColumnName = "CHECK_BY")]
    public string? CheckBy { get; set; }

    /// <summary>
    ///     审核时间
    /// </summary>
    [SugarColumn(ColumnName = "CHECK_DATE")]
    public DateTime? CheckDate { get; set; }

    /// <summary>
    ///     审核状态: 0 未审核，1审核
    /// </summary>
    [SugarColumn(ColumnName = "CHECK_TYPE")]
    public decimal? CheckType { get; set; }

    /// <summary>
    ///     创建人
    /// </summary>
    [SugarColumn(ColumnName = "CREATE_BY")]
    public string? CreateBy { get; set; }

    /// <summary>
    ///     备注
    /// </summary>
    [SugarColumn(ColumnName = "REMARK")]
    public string? Remark { get; set; }

    /// <summary>
    ///     累计采集数
    /// </summary>
    [SugarColumn(ColumnName = "CJ_QTY")]
    public decimal? CjQty { get; set; }

    /// <summary>
    ///     累计打印数
    /// </summary>
    [SugarColumn(ColumnName = "DY_QTY")]
    public decimal? DyQty { get; set; }

    /// <summary>
    ///     累计不良数
    /// </summary>
    [SugarColumn(ColumnName = "BL_QTY")]
    public decimal? BlQty { get; set; }
    
    /// <summary>
    ///     机台面板数
    /// </summary>
    [SugarColumn(ColumnName = "JT_QTY")]
    public decimal? JtQty { get; set; }
    
    /// <summary>
    ///     初始值
    /// </summary>
    [SugarColumn(ColumnName = "CS_QTY")]
    public decimal? CsQty { get; set; }

    [SugarColumn(IsIgnore = true)] public string? StaffName { get; set; }
}