using System.ComponentModel.DataAnnotations.Schema;
|
using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// 入库检检验表头
|
/// </summary>
|
[Table("QS_ITEM_OQC_REQ")]
|
[SugarTable("QS_ITEM_OQC_REQ")] //用于SqlSugar
|
public class QsItemOqcReq
|
{
|
/// <summary>
|
/// 序列SEQ_QS_RKJ
|
/// </summary>
|
[Column("ID")]
|
[SugarColumn(IsPrimaryKey = true, OracleSequenceName = "SEQ_QS_RKJ",
|
ColumnName = "ID")] //用于SqlSugar
|
public decimal? Id { get; set; }
|
|
/// <summary>
|
/// 检验单号
|
/// </summary>
|
[SugarColumn(ColumnName = "RELEASE_NO")]
|
public string? ReleaseNo { get; set; }
|
|
/// <summary>
|
/// 检验日期
|
/// </summary>
|
[SugarColumn(ColumnName = "FCHECK_DATE")]
|
public DateTime? FcheckDate { get; set; }
|
|
/// <summary>
|
/// 检验人员
|
/// </summary>
|
[SugarColumn(ColumnName = "FCHECK_BY")]
|
public string? FcheckBy { get; set; }
|
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_NO")]
|
public string? ItemNo { get; set; }
|
|
/// <summary>
|
/// 检验结果
|
/// </summary>
|
[SugarColumn(ColumnName = "FCHECK_RESU")]
|
public string? FcheckResu { get; set; }
|
|
/// <summary>
|
/// 创建人
|
/// </summary>
|
[SugarColumn(ColumnName = "CREATE_BY")]
|
public string? CreateBy { get; set; }
|
|
/// <summary>
|
/// 创建日期
|
/// </summary>
|
[SugarColumn(ColumnName = "CREATE_DATE")]
|
public DateTime? CreateDate { get; set; }
|
|
/// <summary>
|
/// 更新人
|
/// </summary>
|
[SugarColumn(ColumnName = "LASTUPDATE_BY")]
|
public string? LastupdateBy { get; set; }
|
|
/// <summary>
|
/// 更新日期
|
/// </summary>
|
[SugarColumn(ColumnName = "LASTUPDATE_DATE")]
|
public DateTime? LastupdateDate { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "MODIFY1_BY")]
|
public string? Modify1By { get; set; }
|
|
/// <summary>
|
/// 工单号
|
/// </summary>
|
[SugarColumn(ColumnName = "BILL_NO")]
|
public string? BillNo { get; set; }
|
|
/// <summary>
|
/// 模具号
|
/// </summary>
|
[SugarColumn(ColumnName = "MOID_NUM")]
|
public string? MoidNum { get; set; }
|
|
/// <summary>
|
/// 审核人
|
/// </summary>
|
[SugarColumn(ColumnName = "FSUBMIT_BY")]
|
public string? FsubmitBy { get; set; }
|
|
/// <summary>
|
/// 审核时间
|
/// </summary>
|
[SugarColumn(ColumnName = "FSUBMIT_DATE")]
|
public DateTime? FsubmitDate { get; set; }
|
|
/// <summary>
|
/// 审核状态
|
/// </summary>
|
[SugarColumn(ColumnName = "FSUBMIT")]
|
public decimal? Fsubmit { get; set; }
|
|
/// <summary>
|
/// 备注
|
/// </summary>
|
[SugarColumn(ColumnName = "REMARKS")]
|
public string? Remarks { get; set; }
|
|
/// <summary>
|
/// 物料ID
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_ID")]
|
public decimal? ItemId { get; set; }
|
|
/// <summary>
|
/// 送检批次
|
/// </summary>
|
[SugarColumn(ColumnName = "RBILL_NO")]
|
public string? RbillNo { get; set; }
|
|
/// <summary>
|
/// 车间
|
/// </summary>
|
[SugarColumn(ColumnName = "WORK_SHOP")]
|
public string? WorkShop { get; set; }
|
|
/// <summary>
|
/// 部门ID
|
/// </summary>
|
[SugarColumn(ColumnName = "DEPARTMENT_ID")]
|
public string? DepartmentId { get; set; }
|
|
/// <summary>
|
/// 生产线编号
|
/// </summary>
|
[SugarColumn(ColumnName = "LINE_NO")]
|
public string? LineNo { get; set; }
|
|
// 添加以下字段以适应查询返回的数据
|
[SugarColumn(IsIgnore = true)] public string? ItemName { get; set; }
|
|
[SugarColumn(IsIgnore = true)] public string? ItemModel { get; set; }
|
|
[SugarColumn(IsIgnore = true)] public string? TaskNo { get; set; }
|
|
[SugarColumn(IsIgnore = true)] public string? CbillNo { get; set; }
|
|
[SugarColumn(IsIgnore = true)] public string? Dab001 { get; set; }
|
|
[SugarColumn(IsIgnore = true)] public string? Daa015 { get; set; }
|
|
/// <summary>
|
/// 送检数量
|
/// </summary>
|
[SugarColumn(ColumnName = "QUANTITY")]
|
public decimal? Quantity { get; set; }
|
|
/// <summary>
|
/// 不良原因
|
/// </summary>
|
[SugarColumn(ColumnName = "BLYY")]
|
public string? Blyy { get; set; }
|
|
/// <summary>
|
/// 评审状态
|
/// </summary>
|
[SugarColumn(ColumnName = "PSZT")]
|
public string? Pszt { get; set; }
|
|
/// <summary>
|
/// 所属车间
|
/// </summary>
|
[SugarColumn(ColumnName = "SSCJ")]
|
public string? Sscj { get; set; }
|
|
/// <summary>
|
/// 不良描述
|
/// </summary>
|
[SugarColumn(ColumnName = "FNG_DESC")]
|
public string? FngDesc { get; set; }
|
}
|
