using SqlSugar;

namespace MES.Service.Modes;


/// <summary>
/// 实验室检测数据表
/// </summary>
[SugarTable("V_LABORATORY")]
public class VLaboratory
{
    /// <summary>
    /// 主键ID
    /// </summary>
    [SugarColumn(ColumnName = "ID",
        IsPrimaryKey = true)]
    public decimal 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>
    /// 物料id
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_ID")]
    public int? ItemId { get; set; }

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

    /// <summary>
    /// 物料名称
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_NAME")]
    public string? ItemName { get; set; }

    /// <summary>
    /// 物料规格
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_MODEL")]
    public string? ItemModel { get; set; }

    /// <summary>
    /// 生产车间id
    /// </summary>
    [SugarColumn(ColumnName = "DEPARTMENTID")]
    public int? DepartmentId { get; set; }

    /// <summary>
    /// 生产车间编码
    /// </summary>
    [SugarColumn(ColumnName = "DEPARTMENTCODE")]
    public string? DepartmentCode { get; set; }

    /// <summary>
    /// 销售订单号
    /// </summary>
    [SugarColumn(ColumnName = "SALE_ORDER_NOC")]
    public string? SaleOrderNoc { get; set; }
}