Warroom/warroom-system/Library/Mirle.Component.Database.Model.WES/Current/CurMaterialDataDto.cs

using System;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Text.Json.Serialization;

namespace Mirle.Component.Database.Model.WES
{
    /// <summary>
    /// 即時物料資訊類別
    /// </summary>
    [Table("CUR_MATERIAL_DATA")]
    public class CurMaterialDataDto
    {
        /// <summary>
        /// 儲存區編號
        /// </summary>
        /// <remarks>STG[Floor][Sequence * 2]</remarks>
        [Column(Name = "STORAGE_ID")]
        [Required, Key, StringLength(6), JsonPropertyName("STORAGE_ID"), JsonPropertyOrder(1)]
        public string STORAGE_ID { get; set; }
        /// <summary>
        /// 儲位編號
        /// </summary>
        [Column(Name = "LOC_ID")]
        [Required, Key, StringLength(9), JsonPropertyName("LOC_ID"), JsonPropertyOrder(2)]
        public string LOC_ID { get; set; }
        /// <summary>
        /// 命令序號
        /// </summary>
        /// <remarks>
        /// Warehouse Executeing System Command Sequence Number <br/>
        /// W[YYYYMMDDHH][Sequence * 5] <br/>
        /// </remarks>
        [Column(Name = "CMD_SNO")]
        [Required, StringLength(20), JsonPropertyName("CMD_SNO"), JsonPropertyOrder(3)]
        public string CMD_SNO { get; set; }
        /// <summary>
        /// 載具編號
        /// </summary>
        /// <remarks>棧板編號/物流箱號</remarks>
        [Column(Name = "CARRIER_ID")]
        [Required, StringLength(64), JsonPropertyName("CARRIER_ID"), JsonPropertyOrder(4)]
        public string CARRIER_ID { get; set; }
        /// <summary>
        /// 物料編號
        /// </summary>
        /// <remarks>M[Product Type][Sequnece * 2]</remarks>
        [Column(Name = "MATERILA_ID")]
        [Required, StringLength(30), JsonPropertyName("MATERILA_ID"), JsonPropertyOrder(5)]
        public string MATERILA_ID { get; set; }
        /// <summary>
        /// 物料批號
        /// </summary>
        [Column(Name = "MATERILA_BATCH")]
        [JsonPropertyName("MATERILA_BATCH"), JsonPropertyOrder(6)]
        public int MATERILA_BATCH { get; set; }
        /// <summary>
        /// 物料數量
        /// </summary>
        [Column(Name = "MATERIAL_QUANTITY")]
        [Required, JsonPropertyName("MATERIAL_QUANTITY"), JsonPropertyOrder(7)]
        public int MATERIAL_QUANTITY { get; set; } = 1;
        /// <summary>
        /// 物料重量 (KG)
        /// </summary>
        [Column(Name = "MATERIAL_WEIGHT")]
        [JsonPropertyName("MATERIAL_WEIGHT"), JsonPropertyOrder(8)]
        public double MATERIAL_WEIGHT { get; set; }
        /// <summary>
        /// 程式名稱
        /// </summary>
        [Column(Name = "PROGRAM_NAME")]
        [Required, StringLength(30), JsonPropertyName("PROGRAM_NAME"), JsonPropertyOrder(9)]
        public string PROGRAM_NAME { get; set; }
        /// <summary>
        /// 更新時間
        /// </summary>
        [Column(Name = "UPDATE_TIME")]
        [Required, JsonPropertyName("UPDATE_TIME"), JsonPropertyOrder(10)]
        public DateTime UPDATE_TIME { get; set; } = DateTime.Now;
    }
}