using Cksoft.Unity;
using System;

namespace DllEapEntity
{
    [Table("postbondview")]
    public class Postbondview:BaseEntity
    {
        ////自动产生代码开始&&此行不能删除
        #region 自动产生代码
        public Postbondview()
        {
            base.EntityStatusID = 1;
        }
        [ColDetail(10,"Time",1,1,100,1,"a.Time","",1,1)]
        public DateTime  Time { get; set; }
        [ColDetail(20,"TimeMS",1,1,100,1,"a.TimeMS","",1,1)]
        public int TimeMS { get; set; }
        [ColDetail(30,"Unit",1,1,100,1,"a.Unit","",1,1)]
        public int Unit { get; set; }
        [ColDetail(40,"Group",1,1,100,1,"a.Group","",1,1)]
        public int Group { get; set; }
        [ColDetail(50,"Zone",1,1,100,1,"a.Zone","",1,1)]
        public int Zone { get; set; }
        [ColDetail(60,"Pad",1,1,100,1,"a.Pad","",1,1)]
        public int Pad { get; set; }
        [ColDetail(70,"Target",1,1,100,1,"a.Target","",1,1)]
        public int Target { get; set; }
        [ColDetail(80,"Dir",1,1,100,1,"a.Dir","",1,1)]
        public int Dir { get; set; }
        [ColDetail(90,"OffsetX",1,1,100,1,"a.OffsetX","",1,1)]
        public Single OffsetX { get; set; }
        [ColDetail(100,"OffsetY",1,1,100,1,"a.OffsetY","",1,1)]
        public Single OffsetY { get; set; }
        [ColDetail(110,"OffsetT",1,1,100,1,"a.OffsetT","",1,1)]
        public Single OffsetT { get; set; }
        [ColDetail(120,"PRS Code",1,1,100,1,"a.PRS Code","",1,1)]
        public int PRSCode { get; set; }
        [ColDetail(130,"Used",1,1,100,1,"a.Used","",1,1)]
        public bool Used { get; set; }
        [ColDetail(140,"Foreigner",1,1,100,1,"a.Foreigner","",1,1)]
        public bool Foreigner { get; set; }
        [ColDetail(150,"MacCode",1,1,100,1,"a.MacCode","",1,1)]
        public string MacCode { get; set; }
        public override string GetSelectSql()
        {
            return string.Format($"select { GetQueryColSql()} from { GetQueryTabSql()}");
        }
        public override string GetQueryColSql()
        {
             string sqlstr = "a.Time Time,a.TimeMS TimeMS,a.Unit Unit,a.Group Group,a.Zone Zone,a.Pad Pad,a.Target Target,a.Dir Dir,a.OffsetX OffsetX,a.OffsetY OffsetY";
             sqlstr += ",a.OffsetT OffsetT,a.PRSCode PRSCode,a.Used Used,a.Foreigner Foreigner,a.MacCode MacCode,0 EntityStatusID";
             return sqlstr;
        }
        public override string GetQueryTabSql()
        {
            string sqlstr=" postbondview a ";
            return sqlstr;
        }
        public override string GetQuerySortSql()
        {
            return "";
        }
        #endregion
        ////自动产生代码结束&&此行不能删除
    }
}