using Cksoft.Unity;
using System;
using System.Collections.Generic;

namespace DllEapEntity
{
    [Table("steptrack")]
    public class StepTrack:BaseEntity
    {
        ////自动产生代码开始&&此行不能删除
        #region 自动产生代码
        public StepTrack()
        {
            base.EntityStatusID = 1;
        }
        [ColDetail(10,"Id",1,1,100,1,"a.Id","",1,1)]
        [Key]
        [Identity]
        public int Id { get; set; }
        [ColDetail(30,"ProcessId",1,1,100,1,"a.ProcessId","",1,1)]
        public int ProcessId { get; set; }
        [ColDetail(40,"MacId",1,1,100,1,"a.MacId","",1,1)]
        public int MacId { get; set; }
        [ColDetail(50,"FDate",1,1,100,1,"a.FDate","",1,1)]
        public DateTime FDate { get; set; }
        [ColDetail(60,"类别  1 进站  2 出站",1,1,100,1,"a.Type","",1,1)]
        public int Type { get; set; }
        [ColDetail(70,"RecCode",1,1,100,1,"a.RecCode","",1,1)]
        public string RecCode { get; set; }
        [ColDetail(80,"RecTime",1,1,100,1,"a.RecTime","",1,1)]
        public DateTime RecTime { get; set; }
        [ColDetail(90,"ModCode",1,1,100,1,"a.ModCode","",1,1)]
        public string ModCode { get; set; }
        [ColDetail(100,"ModTime",1,1,100,1,"a.ModTime","",1,1)]
        public DateTime ModTime { get; set; }
        [ColDetail(110,"ProcessCode",1,0,100,1,"b.FCode","",1,1)]
        public string ProcessCode { get; set; }
        [ColDetail(120,"FName",1,0,100,1,"b.FName","",1,1)]
        public string ProcessName { get; set; }
        [ColDetail(130,"代码",1,0,100,1,"c.FCode","",1,1)]
        public string MacCode { get; set; }
        [ColDetail(140,"名称",1,0,100,1,"c.FName","",1,1)]
        public string MacName { get; set; }
        [ColDetail(150,"代码",1,0,100,1,"d.FCode","",1,1)]
        public string MacModelCode { get; set; }
        [ColDetail(160,"名称",1,0,100,1,"d.FName","",1,1)]
        public string MacModelName { get; set; }
        [ColDetail(170,"WaferLot",1,1,100,1,"a.WaferLot","",1,1)]
        public string WaferLot { get; set; }
        [ColDetail(180,"Piece",1,1,100,1,"a.Piece","",1,1)]
        public string Piece { get; set; }
        [ColDetail(190,"BomComponent3",1,1,100,1,"a.BomComponent3","",1,1)]
        public string BomComponent3 { get; set; }
        [ColDetail(200,"WfrSource",1,1,100,1,"a.WfrSource","",1,1)]
        public string WfrSource { get; set; }
        [ColDetail(210,"ProgramName",1,1,100,1,"a.ProgramName","",1,1)]
        public string ProgramName { get; set; }
        [ColDetail(220,"Blade",1,1,100,1,"a.Blade","",1,1)]
        public string Blade { get; set; }
        [ColDetail(230,"CutMode",1,1,100,1,"a.CutMode","",1,1)]
        public string CutMode { get; set; }
        [ColDetail(240,"FName",1,0,100,1,"e.FName","",1,1)]
        public string RecName { get; set; }
        [ColDetail(250,"FName",1,0,100,1,"f.FName","",1,1)]
        public string ModName { get; set; }
        [ColDetail(260, "1  正常  -1  已删除", 1, 1, 100, 1, "a.State", "", 1, 1)]
        public int State { get; set; }
        [ColDetail(270,"Remark",1,1,100,1,"a.Remark","",1,1)]
        public string Remark { get; set; }
        public override string GetSelectSql()
        {
            return string.Format($"select { GetQueryColSql()} from { GetQueryTabSql()}");
        }
        public override string GetQueryColSql()
        {
             string sqlstr = "a.Id Id,a.ProcessId ProcessId,a.MacId MacId,a.FDate FDate,a.Type Type,a.RecCode RecCode,a.RecTime RecTime,a.ModCode ModCode,a.ModTime ModTime";
             sqlstr += ",b.FCode ProcessCode,b.FName ProcessName,c.FCode MacCode,c.FName MacName,d.FCode MacModelCode,d.FName MacModelName,a.WaferLot WaferLot";
             sqlstr += ",a.Piece Piece,a.BomComponent3 BomComponent3,a.WfrSource WfrSource,a.ProgramName ProgramName,a.Blade Blade,a.CutMode CutMode,e.FName RecName";
             sqlstr += ",f.FName ModName,a.State State,a.Remark Remark,0 EntityStatusID";
             return sqlstr;
        }
        public override string GetQueryTabSql()
        {
            string sqlstr=" steptrack a ";
            sqlstr+=" left outer join tprocess b on a.ProcessId =b.id";
            sqlstr+=" left outer join machine c on a.MacId =c.id";
            sqlstr+=" left outer join macmodel d on c.MModeID =d.id";
            sqlstr+=" left outer join staff e on a.reccode =e.fcode";
            sqlstr+=" left outer join staff f on a.modcode =f.fcode";
            return sqlstr;
        }
        public override string GetQuerySortSql()
        {
            return "";
        }
        #endregion
        ////自动产生代码结束&&此行不能删除

        /// <summary>
        /// 是否调取程序
        /// </summary>
        [Ignore]
        public bool CallFunction { get; set; }

        [Ignore]
        public IEnumerable<string> WaferLotAndPieces { get; set; }

        [Ignore]
        public string Action { get; set; }
    }
}