高翔 / ECS-ZJHX · Files

using System;
using System.ComponentModel.DataAnnotations.Schema;

namespace HHECS.Model.Entities
{
    /// <summary>
    /// 工序跟踪表
    /// </summary>
    [Serializable]
    [Table("base_step_trace")]

    public class BaseStepTrace : BaseEntityCU<int>
    {
        /// <summary>
        /// 线体
        /// </summary>
        [Column("lineId")]
        public int LineId { get; set; }

        /// <summary>
        /// 项目号
        /// </summary>
        [Column("woNumber")]
        public string WoNumber { get; set; }

        /// <summary>
        /// 组号
        /// </summary>
        [Column("productCode")]
        public string ProductCode { get; set; }

        /// <summary>
        /// 其他编码(管段号、焊口号)
        /// </summary>
        [Column("otherCode")]
        public string OtherCode { get; set; }

        /// <summary>
        /// 工单明细ID
        /// </summary>
        [Column("serialNumber")]
        public string SerialNumber { get; set; }

        /// <summary>
        /// 工单类型
        /// </summary>
        [Column("woType")]
        public string WoType { get; set; }

        /// <summary>
        /// 物料编码
        /// </summary>
        [Column("materialCode")]
        public string MaterialCode { get; set; }

        /// <summary>
        /// 另一个物料编码
        /// </summary>
        [Column("otherMaterialCode")]
        public string OtherMaterialCode { get; set; }


        /// <summary>
	    /// 当前工艺路线
	    /// </summary>
        [Column("processRouteDetailId")]
        public int? ProcessRouteDetailId { get; set; }

        /// <summary>
	    /// 当前工位
	    /// </summary>
        [Column("stationId")]
        public int? StationId { get; set; }

        /// <summary>
	    /// 下道工艺路线
	    /// </summary>
        [Column("nextProcessRouteDetailId")]
        public int? NextProcessRouteDetailId { get; set; }

        /// <summary>
        /// 下道工位
        /// </summary>
        [Column("nextStationId")]
        public int? NextStationId { get; set; }

        /// <summary>
	    /// 是否不良
	    /// </summary>
        [Column("isNG")]
        public bool? IsNG { get; set; }

        /// <summary>
	    /// 不良代号
	    /// </summary>
        [Column("nGcode")]
        public string NGcode { get; set; }

        /// <summary>
        /// 列编码
        /// </summary>
        [Column("wcsLine")]
        public string WCSLine { get; set; }

        /// <summary>
        /// 层编码
        /// </summary>
        [Column("wcsLayer")]
        public string WCSLayer { get; set; }

        /// <summary>
        /// 任务生成方式
        /// 默认为 0 自动任务，为 1 手动任务
        /// </summary>
        [Column("createType")]
        public int CreateType { get; set; }

        /// <summary>
        /// 人工确认起始点
        /// </summary>
        [Column("manualStartPoint")]
        public string ManualStartPoint { get; set; }

        /// <summary>
        /// 状态
        /// </summary>
        [Column("status")]
        public int Status { get; set; }

        /// <summary> 
	    /// 进站时间  or设备执行生产时间
	    /// </summary>
        [Column("stationInTime")]
        public DateTime? StationInTime { get; set; }

        /// <summary>
	    /// 出站时间 or设备执行生产时间
	    /// </summary>
        [Column("stationOutTime")]
        public DateTime? StationOutTime { get; set; }

        /// <summary>
	    /// 进线时间
	    /// </summary>
        [Column("lineInTime")]
        public DateTime? LineInTime { get; set; }

        /// <summary>
	    /// 出线时间
	    /// </summary>
        [Column("lineOutTime")]
        public DateTime? LineOutTime { get; set; }

        #region 添加的实体，用于存放相关信息

        /// <summary>
        /// 线体
        /// </summary>
        [NotMapped]
        public Line LineVM { get; set; }

        /// <summary>
        /// 工单类型描述
        /// </summary>
        [NotMapped]
        public string WoTypeDesc { get; set; }

        /// <summary>
        /// 物料信息
        /// </summary>
        [NotMapped]
        public BaseMaterial MaterialVM { get; set; }

        /// <summary>
        /// 工艺路线头
        /// </summary>
        [NotMapped]
        public BaseProcessRouteHead ProcessRouteHead { get; set; }

        /// <summary>
        /// 当前工艺路线明细
        /// </summary>
        [NotMapped]
        public BaseProcessRouteDetail ProcessRouteDetail { get; set; }

        /// <summary>
        /// 下一个工艺路线明细
        /// </summary>
        [NotMapped]
        public BaseProcessRouteDetail NextProcessRouteDetail { get; set; }

        /// <summary>
        /// 当前工位信息
        /// </summary>
        [NotMapped]
        public BaseWorkStation StationIdVM { get; set; }

        /// <summary>
        /// 下个工位信息
        /// </summary>
        [NotMapped]
        public BaseWorkStation NextStationIdVM { get; set; }

        /// <summary>
        /// 状态描述
        /// </summary>
        [NotMapped]
        public string StatusDesc { get; set; }

        /// <summary>
        /// 状态vm
        /// </summary>
        [NotMapped]
        public int StatusVM { get; set; }

        #endregion
    }

}