using System.ComponentModel.DataAnnotations;
|
using System.ComponentModel.DataAnnotations.Schema;
|
using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// 巡检检验表头
|
/// </summary>
|
[Table("QS_QA_ITEM_XJ")]
|
[SugarTable("QS_QA_ITEM_XJ")] //用于SqlSugar
|
public class QsQaItemXj
|
{
|
/// <summary>
|
/// 序列SEQ_QS_XJ
|
/// </summary>
|
[Key]
|
[Column("ID")]
|
[SugarColumn(IsPrimaryKey = true, OracleSequenceName = "SEQ_QS_XJ",
|
ColumnName = "ID")] //用于SqlSugar
|
public decimal? Id { get; set; }
|
|
/// <summary>
|
/// 工单号
|
/// </summary>
|
[Column("BILL_NO")]
|
[SugarColumn(ColumnName = "BILL_NO")] //用于SqlSugar
|
[StringLength(50, ErrorMessage = "工单号长度不能超出50")]
|
public string? BillNo { get; set; }
|
|
/// <summary>
|
/// 创建人
|
/// </summary>
|
[Column("CREATE_BY")]
|
[SugarColumn(ColumnName = "CREATE_BY")] //用于SqlSugar
|
[StringLength(100, ErrorMessage = "创建人长度不能超出100")]
|
public string? CreateBy { get; set; }
|
|
/// <summary>
|
/// 创建日期
|
/// </summary>
|
[Column("CREATE_DATE")]
|
[SugarColumn(ColumnName = "CREATE_DATE")] //用于SqlSugar
|
public DateTime? CreateDate { get; set; }
|
|
/// <summary>
|
/// 检验人员
|
/// </summary>
|
[Column("FCHECK_BY")]
|
[SugarColumn(ColumnName = "FCHECK_BY")] //用于SqlSugar
|
[StringLength(100, ErrorMessage = "检验人员长度不能超出100")]
|
public string? FcheckBy { get; set; }
|
|
/// <summary>
|
/// 检验日期
|
/// </summary>
|
[Column("FCHECK_DATE")]
|
[SugarColumn(ColumnName = "FCHECK_DATE")] //用于SqlSugar
|
public DateTime? FcheckDate { get; set; }
|
|
/// <summary>
|
/// 检验结果
|
/// </summary>
|
[Column("FCHECK_RESU")]
|
[SugarColumn(ColumnName = "FCHECK_RESU")] //用于SqlSugar
|
[StringLength(100, ErrorMessage = "检验结果长度不能超出100")]
|
public string? FcheckResu { get; set; }
|
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
[Column("ITEM_NO")]
|
[SugarColumn(ColumnName = "ITEM_NO")] //用于SqlSugar
|
[StringLength(100, ErrorMessage = "物料编码长度不能超出100")]
|
public string? ItemNo { get; set; }
|
|
/// <summary>
|
/// 单位
|
/// </summary>
|
[Column("ITEM_UNIT")]
|
[SugarColumn(ColumnName = "ITEM_UNIT")] //用于SqlSugar
|
[StringLength(100, ErrorMessage = "单位长度不能超出100")]
|
public string? ItemUnit { get; set; }
|
|
/// <summary>
|
/// 更新人
|
/// </summary>
|
[Column("LASTUPDATE_BY")]
|
[SugarColumn(ColumnName = "LASTUPDATE_BY")] //用于SqlSugar
|
[StringLength(100, ErrorMessage = "更新人长度不能超出100")]
|
public string? LastupdateBy { get; set; }
|
|
/// <summary>
|
/// 更新日期
|
/// </summary>
|
[Column("LASTUPDATE_DATE")]
|
[SugarColumn(ColumnName = "LASTUPDATE_DATE")] //用于SqlSugar
|
public DateTime? LastupdateDate { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[Column("MODIFY1_BY")]
|
[SugarColumn(ColumnName = "MODIFY1_BY")] //用于SqlSugar
|
[StringLength(100, ErrorMessage = "Modify1By长度不能超出100")]
|
public string? Modify1By { get; set; }
|
|
/// <summary>
|
/// 检验单号
|
/// </summary>
|
[Column("RELEASE_NO")]
|
[SugarColumn(ColumnName = "RELEASE_NO")] //用于SqlSugar
|
[StringLength(100, ErrorMessage = "检验单号长度不能超出100")]
|
public string? ReleaseNo { get; set; }
|
|
/// <summary>
|
/// 模具号
|
/// </summary>
|
[Column("MOID_NUM")]
|
[SugarColumn(ColumnName = "MOID_NUM")] //用于SqlSugar
|
[StringLength(50, ErrorMessage = "模具号长度不能超出50")]
|
public string? MoidNum { get; set; }
|
|
[Column("Remarks")]
|
[SugarColumn(ColumnName = "Remarks")] //用于SqlSugar
|
[StringLength(200, ErrorMessage = "备注不能超出200")]
|
public string? Remarks { get; set; }
|
|
[SugarColumn(IsIgnore = true)] public decimal? CatQty { get; set; }
|
|
[SugarColumn(IsIgnore = true)] public string? Daa020 { get; set; }
|
|
[SugarColumn(IsIgnore = true)] public string? DetailMem { get; set; }
|
|
[SugarColumn(IsIgnore = true)] public string? TaskNo { get; set; }
|
|
[SugarColumn(IsIgnore = true)] public string? BoardModel { get; set; }
|
[SugarColumn(IsIgnore = true)] public decimal? PlanQty { get; set; }
|
[SugarColumn(IsIgnore = true)] public string? Mocode { get; set; }
|
[SugarColumn(IsIgnore = true)] public string? BoardStyle { get; set; }
|
}
|
