using Cksoft.Unity;
using System;

namespace DllEapEntity
{
    [Table("bioutput")]
    public class BIOutput:BaseEntity
    {
        ////自动产生代码开始&&此行不能删除
        #region 自动产生代码
        public BIOutput()
        {
            base.EntityStatusID = 1;
        }
        [ColDetail(80,"Id",1,1,100,1,"a.Id","",1,1)]
        [Key]
        [Identity]
        public int Id { get; set; }
        [ColDetail(90,"Device_Code",1,1,100,1,"a.Device_Code","",1,1)]
        public string Device_Code { get; set; }
        [ColDetail(100,"FDate",1,1,100,1,"a.FDate","",1,1)]
        public DateTime FDate { get; set; }
        [ColDetail(110,"All_Product",1,1,100,1,"a.All_Product","",1,1)]
        public int All_Product { get; set; }
        [ColDetail(120,"Goods",1,1,100,1,"a.Goods","",1,1)]
        public int Goods { get; set; }
        [ColDetail(130,"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.Device_Code Device_Code,a.FDate FDate,a.All_Product All_Product,a.Goods Goods,a.Recipe Recipe,0 EntityStatusID";
             return sqlstr;
        }
        public override string GetQueryTabSql()
        {
            string sqlstr=" bioutput a ";
            return sqlstr;
        }
        public override string GetQuerySortSql()
        {
            return "";
        }
        #endregion
        ////自动产生代码结束&&此行不能删除

        public string Factory { get; set; }
        public string Plant { get; set; }
        public string Floor { get; set; }
        public string Line { get; set; }
        public string Project { get; set; }
        public string Dev_Type { get; set; }
        public string Work_Process { get; set; }
    }
}