using System.ComponentModel.DataAnnotations;
|
using System.ComponentModel.DataAnnotations.Schema;
|
using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// 首检主表
|
/// </summary>
|
[Table("QS_ITEM_IPI_REQ")]
|
[SugarTable("QS_ITEM_IPI_REQ")] //用于SqlSugar
|
public class QsItemIpiReq
|
{
|
/// <summary>
|
/// 首检单号
|
/// </summary>
|
[Column("BILL_NO")]
|
[SugarColumn(ColumnName = "BILL_NO")] //用于SqlSugar
|
[StringLength(50, ErrorMessage = "首检单号长度不能超出50")]
|
public string? BillNo { get; set; }
|
|
/// <summary>
|
/// 备注
|
/// </summary>
|
[Column("COMMENTS")]
|
[SugarColumn(ColumnName = "COMMENTS")] //用于SqlSugar
|
[StringLength(500, ErrorMessage = "备注长度不能超出500")]
|
public string? Comments { get; set; }
|
|
/// <summary>
|
/// 完成时间
|
/// </summary>
|
[Column("COMPLETE_TIME")]
|
[SugarColumn(ColumnName = "COMPLETE_TIME")] //用于SqlSugar
|
public DateTime? CompleteTime { get; set; }
|
|
/// <summary>
|
/// 创建时间
|
/// </summary>
|
[Column("CREATE_TIME")]
|
[SugarColumn(ColumnName = "CREATE_TIME")] //用于SqlSugar
|
public DateTime? CreateTime { get; set; }
|
|
/// <summary>
|
/// 序列SEQ_QS_IPI
|
/// </summary>
|
[Column("ID")]
|
[SugarColumn(IsPrimaryKey = true, OracleSequenceName = "SEQ_QS_IPI",
|
ColumnName = "ID")]
|
public decimal? Id { get; set; }
|
|
/// <summary>
|
/// 0表示不合格,1表示合格
|
/// </summary>
|
[Column("IS_PASS")]
|
[SugarColumn(ColumnName = "IS_PASS")] //用于SqlSugar
|
public decimal? IsPass { get; set; }
|
|
/// <summary>
|
/// 产品规格
|
/// </summary>
|
[Column("ITEM_MOD")]
|
[SugarColumn(ColumnName = "ITEM_MOD")] //用于SqlSugar
|
[StringLength(1000, ErrorMessage = "产品规格长度不能超出1000")]
|
public string? ItemMod { get; set; }
|
|
/// <summary>
|
/// 产品名
|
/// </summary>
|
[Column("ITEM_NAME")]
|
[SugarColumn(ColumnName = "ITEM_NAME")] //用于SqlSugar
|
[StringLength(200, ErrorMessage = "产品名长度不能超出200")]
|
public string? ItemName { get; set; }
|
|
/// <summary>
|
/// 产品编号
|
/// </summary>
|
[Column("ITEM_NO")]
|
[SugarColumn(ColumnName = "ITEM_NO")] //用于SqlSugar
|
[StringLength(50, ErrorMessage = "产品编号长度不能超出50")]
|
public string? ItemNo { get; set; }
|
|
/// <summary>
|
/// 产线
|
/// </summary>
|
[Column("LINE")]
|
[SugarColumn(ColumnName = "LINE")] //用于SqlSugar
|
[StringLength(50, ErrorMessage = "产线长度不能超出50")]
|
public string? Line { get; set; }
|
|
/// <summary>
|
/// 产线名
|
/// </summary>
|
[Column("LINE_NAME")]
|
[SugarColumn(ColumnName = "LINE_NAME")] //用于SqlSugar
|
[StringLength(50, ErrorMessage = "产线名长度不能超出50")]
|
public string? LineName { get; set; }
|
|
/// <summary>
|
/// 排产单号
|
/// </summary>
|
[Column("PBAID")]
|
[SugarColumn(ColumnName = "PBAID")] //用于SqlSugar
|
public decimal? Pbaid { get; set; }
|
|
/// <summary>
|
/// 审核日期
|
/// </summary>
|
[Column("STATUS_DATE")]
|
[SugarColumn(ColumnName = "STATUS_DATE")] //用于SqlSugar
|
public DateTime? StatusDate { get; set; }
|
|
/// <summary>
|
/// 审核人
|
/// </summary>
|
[Column("STATUS_USER")]
|
[SugarColumn(ColumnName = "STATUS_USER")] //用于SqlSugar
|
[StringLength(50, ErrorMessage = "审核人长度不能超出50")]
|
public string? StatusUser { get; set; }
|
|
/// <summary>
|
/// 车间编码
|
/// </summary>
|
[Column("WORKSHOP_CODE")]
|
[SugarColumn(ColumnName = "WORKSHOP_CODE")] //用于SqlSugar
|
[StringLength(50, ErrorMessage = "车间编码长度不能超出50")]
|
public string? WorkshopCode { get; set; }
|
|
/// <summary>
|
/// 车间名
|
/// </summary>
|
[Column("WORKSHOP_NAME")]
|
[SugarColumn(ColumnName = "WORKSHOP_NAME")] //用于SqlSugar
|
[StringLength(50, ErrorMessage = "车间名长度不能超出50")]
|
public string? WorkshopName { 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; }
|
/// <summary>
|
/// 首检时机
|
/// </summary>
|
[Column("TYPE")]
|
[SugarColumn(ColumnName = "TYPE")] //用于SqlSugar
|
public string? Type { 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
|
public string? FsubmitBy { get; set; }
|
|
/// <summary>
|
/// 审核时间
|
/// </summary>
|
[Column("FSUBMIT_DATE")]
|
[SugarColumn(ColumnName = "FSUBMIT_DATE")] //用于SqlSugar
|
public DateTime? FsubmitDate { get; set; }
|
|
}
|
