using System.ComponentModel.DataAnnotations;
|
using System.ComponentModel.DataAnnotations.Schema;
|
using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// 首检图片信息表
|
/// </summary>
|
[Table("QS_ITEM_IPI_IMAGE")]
|
[SugarTable("QS_ITEM_IPI_IMAGE")]
|
public class QsItemIpiImage
|
{
|
/// <summary>
|
/// 主键 - 使用序列 SEQ_IPI_IMAGE
|
/// </summary>
|
[Key]
|
[Column("ID")]
|
[SugarColumn(IsPrimaryKey = true, OracleSequenceName = "SEQ_IPI_IMAGE",
|
ColumnName = "ID")]
|
public decimal? Id { get; set; }
|
|
/// <summary>
|
/// 检验项目ID（关联 QS_ITEM_IPI_ITEM 表）
|
/// </summary>
|
[Column("FID")]
|
[SugarColumn(ColumnName = "FID")]
|
public decimal? Fid { get; set; }
|
|
/// <summary>
|
/// 质检类型：1=首检，2=巡检，3=入库检，4=来料检验，5=超期检验
|
/// </summary>
|
[Column("QS_TYPE")]
|
[SugarColumn(ColumnName = "QS_TYPE")]
|
public decimal? QsType { get; set; }
|
|
/// <summary>
|
/// 图片二进制数据（LONG RAW类型）
|
/// </summary>
|
[Column("IMAGE_DATA")]
|
[SugarColumn(ColumnName = "IMAGE_DATA")]
|
public byte[]? ImageData { get; set; }
|
|
/// <summary>
|
/// 图片文件名
|
/// </summary>
|
[Column("PICTURENAME")]
|
[SugarColumn(ColumnName = "PICTURENAME")]
|
[StringLength(200, ErrorMessage = "图片名称长度不能超出200")]
|
public string? Picturename { get; set; }
|
|
/// <summary>
|
/// 检验单ID（关联 QS_ITEM_IPI_REQ 表）
|
/// </summary>
|
[Column("GID")]
|
[SugarColumn(ColumnName = "GID")]
|
public decimal? Gid { get; set; }
|
|
/// <summary>
|
/// 备用字段 PID（兼容旧代码）
|
/// </summary>
|
[Column("PID")]
|
[SugarColumn(ColumnName = "PID")]
|
public decimal? Pid { get; set; }
|
|
/// <summary>
|
/// 检验项目名称（来自 QS_ITEM_IPI_ITEM.PROJ_NAME）
|
/// </summary>
|
[Column("JY_NAME")]
|
[SugarColumn(ColumnName = "JY_NAME")]
|
[StringLength(500, ErrorMessage = "检验项目名称长度不能超出500")]
|
public string? JyName { get; set; }
|
|
/// <summary>
|
/// 创建时间
|
/// </summary>
|
[Column("CREATE_DATE")]
|
[SugarColumn(ColumnName = "CREATE_DATE")]
|
public DateTime? CreateDate { get; set; }
|
|
/// <summary>
|
/// 创建人
|
/// </summary>
|
[Column("CREATE_BY")]
|
[SugarColumn(ColumnName = "CREATE_BY")]
|
[StringLength(50, ErrorMessage = "创建人长度不能超出50")]
|
public string? CreateBy { get; set; }
|
|
/// <summary>
|
/// Base64编码的图片数据（用于前端显示，不存储到数据库）
|
/// </summary>
|
[SugarColumn(IsIgnore = true)]
|
public string? Base64Data { get; set; }
|
}
|
