using System.ComponentModel.DataAnnotations;
|
using System.ComponentModel.DataAnnotations.Schema;
|
using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// IQC抽检表头
|
/// </summary>
|
[Table("MES_QA_ITEMS_DETECT_02")]
|
[SugarTable("MES_QA_ITEMS_DETECT_02")] //用于SqlSugar
|
public class MesQaItemsDetect02
|
{
|
/// <summary>
|
/// SEQ_QM_ID
|
/// </summary>
|
[Key]
|
[Column("ID")]
|
[SugarColumn(IsPrimaryKey = true, OracleSequenceName = "SEQ_QM_ID",
|
ColumnName = "ID")] //用于SqlSugar
|
public decimal Id { get; set; }
|
|
/// <summary>
|
/// 入库单号
|
/// </summary>
|
[Column("AUFNR")]
|
[SugarColumn(ColumnName = "AUFNR")] //用于SqlSugar
|
[StringLength(100, ErrorMessage = "入库单号长度不能超出100")]
|
public string? Aufnr { get; set; }
|
|
/// <summary>
|
/// 条码
|
/// </summary>
|
[Column("BARCODE_A")]
|
[SugarColumn(ColumnName = "BARCODE_A")] //用于SqlSugar
|
[StringLength(100, ErrorMessage = "条码长度不能超出100")]
|
public string? BarcodeA { get; set; }
|
|
/// <summary>
|
/// 条码
|
/// </summary>
|
[Column("BARCODE_B")]
|
[SugarColumn(ColumnName = "BARCODE_B")] //用于SqlSugar
|
[StringLength(100, ErrorMessage = "条码长度不能超出100")]
|
public string? BarcodeB { get; set; }
|
|
/// <summary>
|
/// 产品编码
|
/// </summary>
|
[Column("BOARD_ITEM")]
|
[SugarColumn(ColumnName = "BOARD_ITEM")] //用于SqlSugar
|
[StringLength(100, ErrorMessage = "产品编码长度不能超出100")]
|
public string? BoardItem { get; set; }
|
|
/// <summary>
|
/// 认证要求
|
/// </summary>
|
[Column("CARD")]
|
[SugarColumn(ColumnName = "CARD")] //用于SqlSugar
|
[StringLength(100, ErrorMessage = "认证要求长度不能超出100")]
|
public string? Card { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[Column("CLASS_NAME")]
|
[SugarColumn(ColumnName = "CLASS_NAME")] //用于SqlSugar
|
[StringLength(100, ErrorMessage = "ClassName长度不能超出100")]
|
public string? ClassName { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[Column("CLASS_NO")]
|
[SugarColumn(ColumnName = "CLASS_NO")] //用于SqlSugar
|
[StringLength(100, ErrorMessage = "ClassNo长度不能超出100")]
|
public string? ClassNo { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[Column("COMPANY")]
|
[SugarColumn(ColumnName = "COMPANY")] //用于SqlSugar
|
[StringLength(20, ErrorMessage = "Company长度不能超出20")]
|
public string? Company { 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("CUST_NAME")]
|
[SugarColumn(ColumnName = "CUST_NAME")] //用于SqlSugar
|
[StringLength(100, ErrorMessage = "客户长度不能超出100")]
|
public string? CustName { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[Column("FAC_LEVEL")]
|
[SugarColumn(ColumnName = "FAC_LEVEL")] //用于SqlSugar
|
[StringLength(100, ErrorMessage = "FacLevel长度不能超出100")]
|
public string? FacLevel { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[Column("FACTORY")]
|
[SugarColumn(ColumnName = "FACTORY")] //用于SqlSugar
|
[StringLength(100, ErrorMessage = "Factory长度不能超出100")]
|
public string? Factory { get; set; }
|
|
/// <summary>
|
/// 销售方向
|
/// </summary>
|
[Column("FANG")]
|
[SugarColumn(ColumnName = "FANG")] //用于SqlSugar
|
[StringLength(100, ErrorMessage = "销售方向长度不能超出100")]
|
public string? Fang { get; set; }
|
|
/// <summary>
|
/// 送检数量
|
/// </summary>
|
[Column("FBATCH_QTY")]
|
[SugarColumn(ColumnName = "FBATCH_QTY")] //用于SqlSugar
|
public decimal? FbatchQty { get; set; }
|
|
/// <summary>
|
/// 作废标识
|
/// </summary>
|
[Column("FCANCEL")]
|
[SugarColumn(ColumnName = "FCANCEL")] //用于SqlSugar
|
[StringLength(2, ErrorMessage = "作废标识长度不能超出2")]
|
public string? Fcancel { 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_LEVEL")]
|
[SugarColumn(ColumnName = "FCHECK_LEVEL")] //用于SqlSugar
|
[StringLength(50, ErrorMessage = "不合格程度长度不能超出50")]
|
public string? FcheckLevel { get; set; }
|
|
/// <summary>
|
/// 特记事项
|
/// </summary>
|
[Column("FCHECK_MEMO")]
|
[SugarColumn(ColumnName = "FCHECK_MEMO")] //用于SqlSugar
|
[StringLength(500, ErrorMessage = "特记事项长度不能超出500")]
|
public string? FcheckMemo { get; set; }
|
|
/// <summary>
|
/// IPQC检验员
|
/// </summary>
|
[Column("FCHECK_RESU")]
|
[SugarColumn(ColumnName = "FCHECK_RESU")] //用于SqlSugar
|
[StringLength(100, ErrorMessage = "IPQC检验员长度不能超出100")]
|
public string? FcheckResu { get; set; }
|
|
/// <summary>
|
/// 设备编号
|
/// </summary>
|
[Column("FEQP")]
|
[SugarColumn(ColumnName = "FEQP")] //用于SqlSugar
|
[StringLength(100, ErrorMessage = "设备编号长度不能超出100")]
|
public string? Feqp { get; set; }
|
|
/// <summary>
|
/// 不良描述
|
/// </summary>
|
[Column("FNG_DESC")]
|
[SugarColumn(ColumnName = "FNG_DESC")] //用于SqlSugar
|
[StringLength(2000, ErrorMessage = "不良描述长度不能超出2000")]
|
public string? FngDesc { get; set; }
|
|
/// <summary>
|
/// 处理方法
|
/// </summary>
|
[Column("FNG_HANDLE")]
|
[SugarColumn(ColumnName = "FNG_HANDLE")] //用于SqlSugar
|
[StringLength(100, ErrorMessage = "处理方法长度不能超出100")]
|
public string? FngHandle { get; set; }
|
|
/// <summary>
|
/// 生产日期
|
/// </summary>
|
[Column("FPROD_DATE")]
|
[SugarColumn(ColumnName = "FPROD_DATE")] //用于SqlSugar
|
public DateTime? FprodDate { get; set; }
|
|
/// <summary>
|
/// 生产类型
|
/// </summary>
|
[Column("FPROD_TYPE")]
|
[SugarColumn(ColumnName = "FPROD_TYPE")] //用于SqlSugar
|
[StringLength(200, ErrorMessage = "生产类型长度不能超出200")]
|
public string? FprodType { get; set; }
|
|
/// <summary>
|
/// 二次判定结果
|
/// </summary>
|
[Column("FSECOND_RESU")]
|
[SugarColumn(ColumnName = "FSECOND_RESU")] //用于SqlSugar
|
[StringLength(100, ErrorMessage = "二次判定结果长度不能超出100")]
|
public string? FsecondResu { get; set; }
|
|
/// <summary>
|
/// 1为首检，2为完工检验
|
/// </summary>
|
[Column("FSTATUS")]
|
[SugarColumn(ColumnName = "FSTATUS")] //用于SqlSugar
|
public decimal? Fstatus { 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>
|
/// </summary>
|
[Column("FTYPE")]
|
[SugarColumn(ColumnName = "FTYPE")] //用于SqlSugar
|
[StringLength(100, ErrorMessage = "Ftype长度不能超出100")]
|
public string? Ftype { get; set; }
|
|
/// <summary>
|
/// 版本
|
/// </summary>
|
[Column("FVERSION")]
|
[SugarColumn(ColumnName = "FVERSION")] //用于SqlSugar
|
public decimal? Fversion { get; set; }
|
|
/// <summary>
|
/// 处置人
|
/// </summary>
|
[Column("IPQC_BY")]
|
[SugarColumn(ColumnName = "IPQC_BY")] //用于SqlSugar
|
[StringLength(50, ErrorMessage = "处置人长度不能超出50")]
|
public string? IpqcBy { get; set; }
|
|
/// <summary>
|
/// 处置日期
|
/// </summary>
|
[Column("IPQC_DATE")]
|
[SugarColumn(ColumnName = "IPQC_DATE")] //用于SqlSugar
|
public DateTime? IpqcDate { get; set; }
|
|
/// <summary>
|
/// 审核标识
|
/// </summary>
|
[Column("IPQC_STATUS")]
|
[SugarColumn(ColumnName = "IPQC_STATUS")] //用于SqlSugar
|
public decimal? IpqcStatus { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[Column("ISMODIFY1")]
|
[SugarColumn(ColumnName = "ISMODIFY1")] //用于SqlSugar
|
public decimal? Ismodify1 { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[Column("ITEM_NO")]
|
[SugarColumn(ColumnName = "ITEM_NO")] //用于SqlSugar
|
[StringLength(100, ErrorMessage = "ItemNo长度不能超出100")]
|
public string? ItemNo { 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>
|
/// 工位ID
|
/// </summary>
|
[Column("LINEINFO_ID")]
|
[SugarColumn(ColumnName = "LINEINFO_ID")] //用于SqlSugar
|
[StringLength(20, ErrorMessage = "工位ID长度不能超出20")]
|
public string? LineinfoId { get; set; }
|
|
/// <summary>
|
/// 线体编号
|
/// </summary>
|
[Column("LINE_NO")]
|
[SugarColumn(ColumnName = "LINE_NO")] //用于SqlSugar
|
[StringLength(100, ErrorMessage = "线体编号长度不能超出100")]
|
public string? LineNo { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[Column("LOT_NO")]
|
[SugarColumn(ColumnName = "LOT_NO")] //用于SqlSugar
|
[StringLength(100, ErrorMessage = "LotNo长度不能超出100")]
|
public string? LotNo { get; set; }
|
|
/// <summary>
|
/// 处置人
|
/// </summary>
|
[Column("MANAGE_BY")]
|
[SugarColumn(ColumnName = "MANAGE_BY")] //用于SqlSugar
|
[StringLength(50, ErrorMessage = "处置人长度不能超出50")]
|
public string? ManageBy { get; set; }
|
|
/// <summary>
|
/// 处置日期
|
/// </summary>
|
[Column("MANAGE_DATE")]
|
[SugarColumn(ColumnName = "MANAGE_DATE")] //用于SqlSugar
|
public DateTime? ManageDate { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[Column("MAX_CHECK_QTY")]
|
[SugarColumn(ColumnName = "MAX_CHECK_QTY")] //用于SqlSugar
|
public decimal? MaxCheckQty { get; set; }
|
|
/// <summary>
|
/// 原因分析
|
/// </summary>
|
[Column("MEMO_A")]
|
[SugarColumn(ColumnName = "MEMO_A")] //用于SqlSugar
|
[StringLength(4000, ErrorMessage = "原因分析长度不能超出4000")]
|
public string? MemoA { get; set; }
|
|
/// <summary>
|
/// 临时对策
|
/// </summary>
|
[Column("MEMO_B")]
|
[SugarColumn(ColumnName = "MEMO_B")] //用于SqlSugar
|
[StringLength(4000, ErrorMessage = "临时对策长度不能超出4000")]
|
public string? MemoB { get; set; }
|
|
/// <summary>
|
/// 长期对策
|
/// </summary>
|
[Column("MEMO_C")]
|
[SugarColumn(ColumnName = "MEMO_C")] //用于SqlSugar
|
[StringLength(4000, ErrorMessage = "长期对策长度不能超出4000")]
|
public string? MemoC { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[Column("MENU_ID")]
|
[SugarColumn(ColumnName = "MENU_ID")] //用于SqlSugar
|
public decimal? MenuId { get; set; }
|
|
/// <summary>
|
/// 审核人
|
/// </summary>
|
[Column("MODIFY1_BY")]
|
[SugarColumn(ColumnName = "MODIFY1_BY")] //用于SqlSugar
|
[StringLength(100, ErrorMessage = "审核人长度不能超出100")]
|
public string? Modify1By { get; set; }
|
|
/// <summary>
|
/// 审核日期
|
/// </summary>
|
[Column("MODIFY1_DATE")]
|
[SugarColumn(ColumnName = "MODIFY1_DATE")] //用于SqlSugar
|
public DateTime? Modify1Date { get; set; }
|
|
/// <summary>
|
/// 审核标识
|
/// </summary>
|
[Column("MODIFY1_FLAG")]
|
[SugarColumn(ColumnName = "MODIFY1_FLAG")] //用于SqlSugar
|
public decimal? Modify1Flag { get; set; }
|
|
/// <summary>
|
/// 品版
|
/// </summary>
|
[Column("PINGPAI")]
|
[SugarColumn(ColumnName = "PINGPAI")] //用于SqlSugar
|
[StringLength(100, ErrorMessage = "品版长度不能超出100")]
|
public string? Pingpai { get; set; }
|
|
/// <summary>
|
/// 计划数量
|
/// </summary>
|
[Column("PLAN_QTY")]
|
[SugarColumn(ColumnName = "PLAN_QTY")] //用于SqlSugar
|
public decimal? PlanQty { get; set; }
|
|
/// <summary>
|
/// PQC类型说明
|
/// </summary>
|
[Column("PQC_TEXT")]
|
[SugarColumn(ColumnName = "PQC_TEXT")] //用于SqlSugar
|
[StringLength(200, ErrorMessage = "PQC类型说明长度不能超出200")]
|
public string? PqcText { get; set; }
|
|
/// <summary>
|
/// PQC检验类型
|
/// </summary>
|
[Column("PQC_TYPE")]
|
[SugarColumn(ColumnName = "PQC_TYPE")] //用于SqlSugar
|
[StringLength(30, ErrorMessage = "PQC检验类型长度不能超出30")]
|
public string? PqcType { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[Column("PROC_NAME")]
|
[SugarColumn(ColumnName = "PROC_NAME")] //用于SqlSugar
|
[StringLength(100, ErrorMessage = "ProcName长度不能超出100")]
|
public string? ProcName { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[Column("PROC_NO")]
|
[SugarColumn(ColumnName = "PROC_NO")] //用于SqlSugar
|
[StringLength(100, ErrorMessage = "ProcNo长度不能超出100")]
|
public string? ProcNo { get; set; }
|
|
/// <summary>
|
/// 检验单号
|
/// </summary>
|
[Column("RELEASE_NO")]
|
[SugarColumn(ColumnName = "RELEASE_NO")] //用于SqlSugar
|
[StringLength(100, ErrorMessage = "检验单号长度不能超出100")]
|
public string? ReleaseNo { get; set; }
|
|
/// <summary>
|
/// 工作中心
|
/// </summary>
|
[Column("WORKSHOP_CENTER_CODE")]
|
[SugarColumn(ColumnName = "WORKSHOP_CENTER_CODE")] //用于SqlSugar
|
[StringLength(100, ErrorMessage = "工作中心长度不能超出100")]
|
public string? WorkshopCenterCode { get; set; }
|
|
/// <summary>
|
/// 工作中心
|
/// </summary>
|
[Column("GID")]
|
[SugarColumn(ColumnName = "GID")] //用于SqlSugar
|
[StringLength(100, ErrorMessage = "GID100")]
|
public decimal? Gid { get; set; }
|
}
|
