using SqlSugar;
|
using System;
|
|
namespace MES.Service.Modes
|
{
|
/// <summary>
|
/// 实验室检测数据表
|
/// </summary>
|
[SugarTable("MES_LABORATORY")]
|
public class MesLaboratory
|
{
|
/// <summary>
|
/// 主键ID
|
/// </summary>
|
[SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_MES_LABORATORY",
|
IsPrimaryKey = true)]
|
public decimal Id { get; set; }
|
|
/// <summary>
|
/// 工单号
|
/// </summary>
|
[SugarColumn(ColumnName = "BILL_NO", Length = 100)]
|
public string? BillNo { get; set; }
|
|
/// <summary>
|
/// 生产线体编码
|
/// </summary>
|
[SugarColumn(ColumnName = "LINE_NO", Length = 100)]
|
public string? LineNo { get; set; }
|
|
/// <summary>
|
/// 物料id
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_ID")]
|
public int? ItemId { get; set; }
|
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_NO", Length = 64)]
|
public string? ItemNo { get; set; }
|
|
/// <summary>
|
/// 物料名称
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_NAME", Length = 500)]
|
public string? ItemName { get; set; }
|
|
/// <summary>
|
/// 物料规格
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_MODEL", Length = 3000)]
|
public string? ItemModel { get; set; }
|
|
/// <summary>
|
/// 生产车间id
|
/// </summary>
|
[SugarColumn(ColumnName = "DEPARTMENTID")]
|
public int? DepartmentId { get; set; }
|
|
/// <summary>
|
/// 生产车间编码
|
/// </summary>
|
[SugarColumn(ColumnName = "DEPARTMENTCODE", Length = 32)]
|
public string? DepartmentCode { get; set; }
|
|
/// <summary>
|
/// 销售订单号
|
/// </summary>
|
[SugarColumn(ColumnName = "SALE_ORDER_NOC", Length = 50)]
|
public string? SaleOrderNoc { get; set; }
|
|
/// <summary>
|
/// 检验结果
|
/// </summary>
|
[SugarColumn(ColumnName = "INSPECTION_RESULT", Length = 20)]
|
public string? InspectionResult { get; set; }
|
|
/// <summary>
|
/// 创建时间
|
/// </summary>
|
[SugarColumn(ColumnName = "CREATE_TIME", InsertServerTime = true)]
|
public DateTime? CreateTime { get; set; }
|
|
/// <summary>
|
/// 创建人
|
/// </summary>
|
[SugarColumn(ColumnName = "CREATE_BY", Length = 100)]
|
public string? CreateBy { get; set; }
|
|
/// <summary>
|
/// 检验时间
|
/// </summary>
|
[SugarColumn(ColumnName = "INSPECTION_TIME")]
|
public DateTime? InspectionTime { get; set; }
|
|
/// <summary>
|
/// 检验人
|
/// </summary>
|
[SugarColumn(ColumnName = "INSPECTION_BY", Length = 100)]
|
public string? InspectionBy { get; set; }
|
|
|
[SugarColumn(IsIgnore = true)]
|
public string? CreateUser { get; set; }
|
|
//inspection
|
[SugarColumn(IsIgnore = true)]
|
public string? InspectionUser { get; set; }
|
}
|
}
|
