using Cksoft.Unity;
using System;

namespace DllEapEntity.OFILM
{
    [Table("machinematerialdetail")]
    public class MachineMaterialDetail : BaseEntity
    {
        ////自动产生代码开始&&此行不能删除
        #region 自动产生代码
        public MachineMaterialDetail()
        {
            base.EntityStatusID = 1;
        }
        [ColDetail(10, "Id", 1, 1, 100, 1, "a.Id", "", 1, 1)]
        [Key]
        [Identity]
        public int Id { get; set; }
        [ColDetail(20, "MstId", 1, 1, 100, 1, "a.MstId", "", 1, 1)]
        public int MstId { get; set; }
        [ColDetail(30, "FDate", 1, 1, 100, 1, "a.FDate", "", 1, 1)]
        public DateTime FDate { get; set; }
        [ColDetail(40, "MacId", 1, 1, 100, 1, "a.MacId", "", 1, 1)]
        public int MacId { get; set; }
        [ColDetail(50, "Category", 1, 1, 100, 1, "a.Category", "", 1, 1)]
        public string Category { get; set; }
        [ColDetail(60, "Reject", 1, 1, 100, 1, "a.Reject", "", 1, 1)]
        public decimal? Reject { get; set; }
        [ColDetail(70, "Total", 1, 1, 100, 1, "a.Total", "", 1, 1)]
        public Int64 Total { get; set; }
        [ColDetail(80, "Stn1", 1, 1, 100, 1, "a.Stn1", "", 1, 1)]
        public Int64 Stn1 { get; set; }
        [ColDetail(90, "Stn2", 1, 1, 100, 1, "a.Stn2", "", 1, 1)]
        public Int64 Stn2 { get; set; }
        [ColDetail(100, "Stn3", 1, 1, 100, 1, "a.Stn3", "", 1, 1)]
        public Int64 Stn3 { get; set; }
        [ColDetail(110, "Stn4", 1, 1, 100, 1, "a.Stn4", "", 1, 1)]
        public Int64 Stn4 { get; set; }
        [ColDetail(120, "RecTime", 1, 1, 100, 1, "a.RecTime", "", 1, 1)]
        public DateTime RecTime { get; set; }
        [ColDetail(130, "ModTime", 1, 1, 100, 1, "a.ModTime", "", 1, 1)]
        public DateTime ModTime { get; set; }
        [ColDetail(140, "机台编号", 1, 0, 100, 1, "c.FCode", "", 1, 1)]
        public string MacCode { get; set; }
        [ColDetail(150, "Shift", 1, 1, 100, 1, "a.Shift", "", 1, 1)]
        public string Shift { get; set; }
        [ColDetail(170, "Recipe", 1, 1, 100, 1, "a.Recipe", "", 1, 1)]
        public string Recipe { get; set; }
        public override string GetSelectSql()
        {
            return string.Format($"select { GetQueryColSql()} from { GetQueryTabSql()}");
        }
        public override string GetQueryColSql()
        {
            string sqlstr = "a.Id Id,a.MstId MstId,a.FDate FDate,a.MacId MacId,a.Category Category,a.Reject Reject,a.Total Total,a.Stn1 Stn1,a.Stn2 Stn2,a.Stn3 Stn3";
            sqlstr += ",a.Stn4 Stn4,a.RecTime RecTime,a.ModTime ModTime,c.FCode MacCode,a.Shift Shift,a.Recipe Recipe,0 EntityStatusID";
            return sqlstr;
        }
        public override string GetQueryTabSql()
        {
            string sqlstr = " machinematerialdetail a ";
            sqlstr += " left outer join machine c on a.macid =c.id";
            return sqlstr;
        }
        public override string GetQuerySortSql()
        {
            return "";
        }
        #endregion
        ////自动产生代码结束&&此行不能删除
    }
}