using System.ComponentModel.DataAnnotations;
|
using System.ComponentModel.DataAnnotations.Schema;
|
using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// 检验项目主表
|
/// </summary>
|
[Table("MES_QA")]
|
[SugarTable("MES_QA")] //用于SqlSugar
|
public class MesQa
|
{
|
/// <summary>
|
/// 创建人
|
/// </summary>
|
[Column("CREATE_BY")]
|
[SugarColumn(ColumnName = "CREATE_BY")] //用于SqlSugar
|
[StringLength(20, ErrorMessage = "创建人长度不能超出20")]
|
public string? CreateBy { get; set; }
|
|
/// <summary>
|
/// 创建时间
|
/// </summary>
|
[Column("CREATE_DATE")]
|
[SugarColumn(ColumnName = "CREATE_DATE")] //用于SqlSugar
|
public DateTime? CreateDate { get; set; }
|
|
/// <summary>
|
/// 审核状态
|
/// </summary>
|
[Column("FSUBMIT")]
|
[SugarColumn(ColumnName = "FSUBMIT")] //用于SqlSugar
|
public decimal? Fsubmit { get; set; }
|
|
/// <summary>
|
/// 审核人
|
/// </summary>
|
[Column("FSUBMIT_BY")]
|
[SugarColumn(ColumnName = "FSUBMIT_BY")] //用于SqlSugar
|
[StringLength(50, ErrorMessage = "审核人长度不能超出50")]
|
public string? FsubmitBy { get; set; }
|
|
/// <summary>
|
/// 审核时间
|
/// </summary>
|
[Column("FSUBMIT_DATE")]
|
[SugarColumn(ColumnName = "FSUBMIT_DATE")] //用于SqlSugar
|
public DateTime? FsubmitDate { get; set; }
|
|
/// <summary>
|
/// 序列SEQ_QS
|
/// </summary>
|
[Column("ID")]
|
[SugarColumn(ColumnName = "ID")] //用于SqlSugar
|
public decimal? Id { get; set; }
|
|
/// <summary>
|
/// 物料编号
|
/// </summary>
|
[Column("ITEM_NO")]
|
[SugarColumn(ColumnName = "ITEM_NO")] //用于SqlSugar
|
[StringLength(50, ErrorMessage = "物料编号长度不能超出50")]
|
public string? ItemNo { get; set; }
|
|
/// <summary>
|
/// 1为首检，2为巡检，3为入库检
|
/// </summary>
|
[Column("QS_TYPE")]
|
[SugarColumn(ColumnName = "QS_TYPE")] //用于SqlSugar
|
[StringLength(1, ErrorMessage = "1为首检，2为巡检，3为入库检长度不能超出1")]
|
public string? QsType { get; set; }
|
|
/// <summary>
|
/// 工序ID
|
/// </summary>
|
[Column("PROC_ID")]
|
[SugarColumn(ColumnName = "PROC_ID")] //用于SqlSugar
|
public decimal? procid { get; set; }
|
}
|
