using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
/// 超期检验视图 V_CQJ
/// </summary>
[SugarTable("V_CQJ")]
public class LtsCqj
{
    /// <summary>
    /// ID
    /// </summary>
    [SugarColumn(ColumnName = "ID")]
    public decimal? Id { get; set; }

    /// <summary>
    /// 检验单号
    /// </summary>
    [SugarColumn(ColumnName = "RELEASE_NO")]
    public string? ReleaseNo { get; set; }

    /// <summary>
    /// 物料ID
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_ID")]
    public decimal? ItemId { get; set; }

    /// <summary>
    /// 物料编码
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_NO")]
    public string? ItemNo { get; set; }

    /// <summary>
    /// 物料名称
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_NAME")]
    public string? ItemName { get; set; }

    /// <summary>
    /// 规格型号
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_MODEL")]
    public string? ItemModel { get; set; }

    /// <summary>
    /// 送检批次
    /// </summary>
    [SugarColumn(ColumnName = "LOT_NO")]
    public string? LotNo { get; set; }

    /// <summary>
    /// 提交标识
    /// </summary>
    [SugarColumn(ColumnName = "FSUBMIT")]
    public decimal? Fsubmit { get; set; }

    /// <summary>
    /// 创建时间
    /// </summary>
    [SugarColumn(ColumnName = "CREATE_DATE")]
    public DateTime? CreateDate { get; set; }

    /// <summary>
    /// 创建人
    /// </summary>
    [SugarColumn(ColumnName = "CJR")]
    public string? Cjr { get; set; }

    /// <summary>
    /// 检验结果
    /// </summary>
    [SugarColumn(ColumnName = "FCHECK_RESU")]
    public string? FcheckResu { get; set; }

    /// <summary>
    /// 备注信息
    /// </summary>
    [SugarColumn(ColumnName = "LOT_NO1")]
    public string? LotNo1 { get; set; }

    /// <summary>
    /// 不良描述
    /// </summary>
    [SugarColumn(ColumnName = "FNG_DESC")]
    public string? FngDesc { get; set; }

    /// <summary>
    /// 送检数量
    /// </summary>
    [SugarColumn(ColumnName = "FBATCH_QTY")]
    public decimal? FbatchQty { get; set; }

    /// <summary>
    /// 提交人
    /// </summary>
    [SugarColumn(ColumnName = "TJR")]
    public string? Tjr { get; set; }

    /// <summary>
    /// 单位
    /// </summary>
    [SugarColumn(ColumnName = "FNUMBER")]
    public string? Fnumber { get; set; }

    /// <summary>
    /// 送检人
    /// </summary>
    [SugarColumn(ColumnName = "SJR")]
    public string? Sjr { get; set; }

    /// <summary>
    /// 送检单号
    /// </summary>
    [SugarColumn(ColumnName = "DECLARATION_NO")]
    public string? DeclarationNo { get; set; }

    /// <summary>
    /// 检验项目数量（非数据库字段，用于前端显示）
    /// </summary>
    [SugarColumn(IsIgnore = true)]
    public int? InspectionItemCount { get; set; }
}