using System;
using System.Data;
using QMAPP.Entity;
using QMFrameWork.Data.Attributes;

namespace QMAPP.FJC.Entity.CompleteStatistics.Table
{
    /// <summary>
    /// 完工统计表
    /// </summary>
    [DBTable(TableName = "T_AW_COMPLETE_TJSTATISTICS", TimeStampColumn = "UPDATETIME")]
    public class T_AW_COMPLETE_TJSTATISTICS : BaseEntity
    {
        /// <summary>
        /// 设备信息主键
        /// </summary>
        [DBColumn(ColumnName = "PID", DataType = DbType.String, IsKey = true)]
        public string PID { get; set; }

        /// <summary>
        /// 零件号
        /// </summary>
        [DBColumn(ColumnName = "MATERIALNO", DataType = DbType.String)]
        public string MATERIALNO { get; set; }

        /// <summary>
        /// 系统统计数量
        /// </summary>
        [DBColumn(ColumnName = "SYSCOMPLETECOUNT", DataType = DbType.Int32)]
        public int SYSCOMPLETECOUNT { get; set; }

        /// <summary>
        /// 人工统计数量
        /// </summary>
        [DBColumn(ColumnName = "COMPLETECOUNT", DataType = DbType.Int32)]
        public int COMPLETECOUNT { get; set; }

        /// <summary>
        /// 开始时间
        /// </summary>
        [DBColumn(ColumnName = "STARTTIME", DataType = DbType.DateTime)]
        public DateTime STARTTIME { get; set; }

        /// <summary>
        /// 结束时间
        /// </summary>
        [DBColumn(ColumnName = "ENDTIME", DataType = DbType.DateTime)]
        public DateTime ENDTIME { get; set; }

        /// <summary>
        /// 订单号
        /// </summary>
        [DBColumn(ColumnName = "ORDERNO", DataType = DbType.String)]
        public string ORDERNO { get; set; }

        /// <summary>
        /// 创建时间
        /// </summary>
        [DBColumn(ColumnName = "CREATETIME", DataType = DbType.DateTime)]
        public DateTime CREATETIME { get; set; }

        /// <summary>
        /// 创建者
        /// </summary>
        [DBColumn(ColumnName = "CREATEUSER", DataType = DbType.String)]
        public string CREATEUSER { get; set; }

        /// <summary>
        /// 更新时间
        /// </summary>
        [DBColumn(ColumnName = "UPDATETIME", DataType = DbType.DateTime)]
        public DateTime UPDATETIME { get; set; }

        /// <summary>
        /// 更新者
        /// </summary>
        [DBColumn(ColumnName = "UPDATEUSER", DataType = DbType.String)]
        public string UPDATEUSER { get; set; }

        /// <summary>
        /// 删除标识
        /// </summary>
        [DBColumn(ColumnName = "DELFLAG", DataType = DbType.String)]
        public string DELFLAG { get; set; }

        /// <summary>
        /// 产线
        /// </summary>
        [DBColumn(ColumnName = "line", DataType = DbType.String)]
        public string line { get; set; }
    }
}