You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
82 lines
3.1 KiB
82 lines
3.1 KiB
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;
|
|
}
|
|
}
|