using System.ComponentModel.DataAnnotations;
|
using System.ComponentModel.DataAnnotations.Schema;
|
using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// 首检子表
|
/// </summary>
|
[Table("QS_ITEM_IPI_ITEM")]
|
[SugarTable("QS_ITEM_IPI_ITEM")] //用于SqlSugar
|
public class QsItemIpiItem
|
{
|
/// <summary>
|
/// 序列SEQ_QS_IPI
|
/// </summary>
|
[Key]
|
[Column("ID")]
|
[SugarColumn(IsPrimaryKey = true, OracleSequenceName = "SEQ_QS_IPI",
|
ColumnName = "ID")]
|
public decimal? Id { get; set; }
|
|
/// <summary>
|
/// 接收水平
|
/// </summary>
|
[Column("FAC_LEVEL")]
|
[SugarColumn(ColumnName = "FAC_LEVEL")] //用于SqlSugar
|
[StringLength(1000, ErrorMessage = "接收水平长度不能超出100")]
|
public string? FacLevel { get; set; }
|
|
/// <summary>
|
/// 检验水平
|
/// </summary>
|
[Column("FCHECK_LEVEL")]
|
[SugarColumn(ColumnName = "FCHECK_LEVEL")] //用于SqlSugar
|
[StringLength(1000, ErrorMessage = "检验水平长度不能超出100")]
|
public string? FcheckLevel { get; set; }
|
|
/// <summary>
|
/// 检验方法
|
/// </summary>
|
[Column("INSPECTION_METHOD")]
|
[SugarColumn(ColumnName = "INSPECTION_METHOD")] //用于SqlSugar
|
[StringLength(500, ErrorMessage = "检验方法长度不能超出500")]
|
public string? InspectionMethod { get; set; }
|
|
/// <summary>
|
/// 质量要求
|
/// </summary>
|
[Column("ITEM_MOD")]
|
[SugarColumn(ColumnName = "ITEM_MOD")] //用于SqlSugar
|
[StringLength(500, ErrorMessage = "质量要求长度不能超出500")]
|
public string? ItemMod { get; set; }
|
|
/// <summary>
|
/// 检验个数
|
/// </summary>
|
[Column("LEVEL_NUM")]
|
[SugarColumn(ColumnName = "LEVEL_NUM")] //用于SqlSugar
|
public decimal? LevelNum { get; set; }
|
|
/// <summary>
|
/// 最大值
|
/// </summary>
|
[Column("MAX_VALUE")]
|
[SugarColumn(ColumnName = "MAX_VALUE")] //用于SqlSugar
|
public decimal? MaxValue { get; set; }
|
|
/// <summary>
|
/// 最小值
|
/// </summary>
|
[Column("MIN_VALUE")]
|
[SugarColumn(ColumnName = "MIN_VALUE")] //用于SqlSugar
|
public decimal? MinValue { get; set; }
|
|
/// <summary>
|
/// 备注
|
/// </summary>
|
[Column("NOTES")]
|
[SugarColumn(ColumnName = "NOTES")] //用于SqlSugar
|
[StringLength(1000, ErrorMessage = "备注长度不能超出100")]
|
public string? Notes { get; set; }
|
|
/// <summary>
|
/// 检验主表id
|
/// </summary>
|
[Column("PID")]
|
[SugarColumn(ColumnName = "PID")] //用于SqlSugar
|
public decimal? Pid { get; set; }
|
|
/// <summary>
|
/// 项目名称
|
/// </summary>
|
[Column("PROJ_NAME")]
|
[SugarColumn(ColumnName = "PROJ_NAME")] //用于SqlSugar
|
[StringLength(500, ErrorMessage = "项目名称长度不能超出50")]
|
public string? ProjName { get; set; }
|
|
/// <summary>
|
/// 检验标准编码
|
/// </summary>
|
[Column("QS_CODE")]
|
[SugarColumn(ColumnName = "QS_CODE")] //用于SqlSugar
|
[StringLength(1000, ErrorMessage = "检验标准编码长度不能超出100")]
|
public string? QsCode { get; set; }
|
|
/// <summary>
|
/// 检验标准名称
|
/// </summary>
|
[Column("QS_NAME")]
|
[SugarColumn(ColumnName = "QS_NAME")] //用于SqlSugar
|
[StringLength(1000, ErrorMessage = "检验标准名称长度不能超出100")]
|
public string? QsName { get; set; }
|
|
/// <summary>
|
/// 物料ID
|
/// </summary>
|
[Column("ITEM_ID")]
|
[SugarColumn(ColumnName = "ITEM_ID")]
|
public decimal? ItemId { get; set; }
|
/// <summary>
|
/// 穴数
|
/// </summary>
|
[SugarColumn(IsIgnore = true)]
|
public decimal? Mnum { get; set; }
|
/// <summary>
|
/// 堵穴号
|
/// </summary>
|
[SugarColumn(IsIgnore = true)]
|
public string? Dnum { get; set; }
|
|
/// <summary>
|
/// 标准值
|
/// </summary>
|
[Column("STANDARD_VALUE")]
|
[SugarColumn(ColumnName = "STANDARD_VALUE")] //用于SqlSugar
|
public decimal? StandardValue { get; set; }
|
|
/// <summary>
|
/// 使用仪表
|
/// </summary>
|
[Column("USING_INSTRUMENTS")]
|
[SugarColumn(ColumnName = "USING_INSTRUMENTS")] //用于SqlSugar
|
[StringLength(500, ErrorMessage = "使用仪表长度不能超出50")]
|
public string? UsingInstruments { get; set; }
|
|
/// <summary>
|
/// 0表示不合格,1表示合格
|
/// </summary>
|
[Column("IS_PASS")]
|
[SugarColumn(ColumnName = "IS_PASS")] //用于SqlSugar
|
public decimal? IsPass { get; set; }
|
|
|
/// <summary>
|
/// 已检验个数
|
/// </summary>
|
[SugarColumn(IsIgnore = true)]
|
public int? isCheck { get; set; }
|
|
/// <summary>
|
/// 图片地址
|
/// </summary>
|
[Column("PICTURE")]
|
[SugarColumn(ColumnName = "PICTURE")] //用于SqlSugar
|
public byte[]? Picture { get; set; }
|
|
/// <summary>
|
/// 图片名称
|
/// </summary>
|
[Column("PICTURENAME")]
|
[SugarColumn(ColumnName = "PICTURENAME")] //用于SqlSugar
|
[StringLength(32, ErrorMessage = "Picturename长度不能超出32")]
|
public string? Picturename { get; set; }
|
|
[Column("Remarks")]
|
[SugarColumn(ColumnName = "Remarks")] //用于SqlSugar
|
[StringLength(2000, ErrorMessage = "备注不能超出200")]
|
public string? Remarks { get; set; }
|
|
/// <summary>
|
/// 送检批数
|
/// </summary>
|
[Column("SNUM")]
|
[SugarColumn(ColumnName = "SNUM")]
|
public decimal? Snum { get; set; }
|
|
/// <summary>
|
/// 顺序
|
/// </summary>
|
[Column("FORDER")]
|
[SugarColumn(ColumnName = "FORDER")]
|
public decimal? Forder { get; set; }
|
|
/// <summary>
|
/// 穴号信息（用于前端显示）
|
/// </summary>
|
[SugarColumn(IsIgnore = true)]
|
public List<HoleNumberInfo>? HoleNumbers { get; set; }
|
|
[SugarColumn(IsIgnore = true)] public string? result { get; set; }
|
[SugarColumn(IsIgnore = true)] public string? imageData { get; set; }
|
|
/// <summary>
|
/// 图片列表（用于多图片展示）
|
/// </summary>
|
[SugarColumn(IsIgnore = true)] public List<ImageInfo>? imageList { get; set; }
|
}
|
|
/// <summary>
|
/// 图片信息类，用于多图片展示
|
/// </summary>
|
public class ImageInfo
|
{
|
/// <summary>
|
/// 图片ID（QS_ITEM_IPI_IMAGE 表的主键）
|
/// </summary>
|
public decimal Id { get; set; }
|
|
/// <summary>
|
/// 图片文件名
|
/// </summary>
|
public string? FileName { get; set; }
|
|
/// <summary>
|
/// 图片Base64数据
|
/// </summary>
|
public string? Base64Data { get; set; }
|
|
/// <summary>
|
/// 创建时间
|
/// </summary>
|
public DateTime? CreateDate { get; set; }
|
|
/// <summary>
|
/// 创建人
|
/// </summary>
|
public string? CreateBy { get; set; }
|
}
|
