using Cksoft.Unity; using System; namespace DllEapEntity { [Table("ofilmcmk")] public class Ofilmcmk:BaseEntity { ////自动产生代码开始&&此行不能删除 #region 自动产生代码 public Ofilmcmk() { base.EntityStatusID = 1; } [ColDetail(10,"ID",1,1,100,1,"a.ID","",1,1)] [Key] [Identity] public int ID { get; set; } [ColDetail(20,"课别",1,1,100,1,"a.Classes","",1,1)] public string Classes { get; set; } [ColDetail(30,"楼层",1,1,100,1,"a.floor","",1,1)] public string floor { get; set; } [ColDetail(40,"客户",1,1,100,1,"a.customer","",1,1)] public string customer { get; set; } [ColDetail(50,"设备ID",1,1,100,1,"a.macID","",1,1)] public string macID { get; set; } [ColDetail(60,"位置",1,1,100,1,"a.position","",1,1)] public string position { get; set; } [ColDetail(100,"附件",1,1,100,1,"a.enclosureSrc","",1,1)] public string enclosureSrc { get; set; } [ColDetail(110,"录入人代码",1,1,100,1,"a.RecCode","",1,1)] public string RecCode { get; set; } [ColDetail(120,"录入日期",1,1,100,1,"a.RecTime","",1,1)] public DateTime RecTime { get; set; } [ColDetail(130,"修改 人代码",1,1,100,1,"a.ModCode","",1,1)] public string ModCode { get; set; } [ColDetail(140,"修改时间",1,1,100,1,"a.ModTime","",1,1)] public DateTime ModTime { get; set; } [ColDetail(150,"下次取值时间",1,1,100,1,"a.NextTime","",1,1)] public DateTime NextTime { get; set; } [ColDetail(160,"录入人",1,0,100,1,"b.FName","",1,1)] public string RecName { get; set; } [ColDetail(170,"修改人",1,0,100,1,"c.FName","",1,1)] public string ModName { get; set; } [ColDetail(180,"XCmk",1,1,100,1,"a.XCmk","",1,1)] public string XCmk { get; set; } [ColDetail(190,"YCmk",1,1,100,1,"a.YCmk","",1,1)] public string YCmk { get; set; } [ColDetail(200,"TCmk",1,1,100,1,"a.TCmk","",1,1)] public string TCmk { get; set; } [ColDetail(210,"XP",1,1,100,1,"a.XP","",1,1)] public string XP { get; set; } [ColDetail(220,"YP",1,1,100,1,"a.YP","",1,1)] public string YP { get; set; } [ColDetail(230,"TP",1,1,100,1,"a.TP","",1,1)] public string TP { get; set; } [ColDetail(240,"xcmk图片",1,1,100,1,"a.XCmkImg","",1,1)] public string XCmkImg { get; set; } [ColDetail(250,"ycmk图片",1,1,100,1,"a.YCmkImg","",1,1)] public string YCmkImg { get; set; } [ColDetail(260,"tcmk图片",1,1,100,1,"a.TCmkImg","",1,1)] public string TCmkImg { get; set; } [ColDetail(270,"xp图片",1,1,100,1,"a.XPImg","",1,1)] public string XPImg { get; set; } [ColDetail(280,"yp图片",1,1,100,1,"a.YPImg","",1,1)] public string YPImg { get; set; } [ColDetail(290,"tp图片",1,1,100,1,"a.TPImg","",1,1)] public string TPImg { get; set; } [ColDetail(300,"XSpc图片",1,1,100,1,"a.XSpcImg","",1,1)] public string XSpcImg { get; set; } [ColDetail(310,"YSpc图片",1,1,100,1,"a.YSpcImg","",1,1)] public string YSpcImg { get; set; } [ColDetail(320,"TSpc图片",1,1,100,1,"a.TSpcImg","",1,1)] public string TSpcImg { get; set; } [ColDetail(330,"本次取值日期",1,1,100,1,"a.ThisTime","",1,1)] public DateTime ThisTime { get; set; } [ColDetail(340,"XCmkImgName",1,1,100,1,"a.XCmkImgName","",1,1)] public string XCmkImgName { get; set; } [ColDetail(350,"YCmkImgName",1,1,100,1,"a.YCmkImgName","",1,1)] public string YCmkImgName { get; set; } [ColDetail(360,"TCmkImgName",1,1,100,1,"a.TCmkImgName","",1,1)] public string TCmkImgName { get; set; } [ColDetail(370,"XPImgName",1,1,100,1,"a.XPImgName","",1,1)] public string XPImgName { get; set; } [ColDetail(380,"YPImgName",1,1,100,1,"a.YPImgName","",1,1)] public string YPImgName { get; set; } [ColDetail(390,"TPImgName",1,1,100,1,"a.TPImgName","",1,1)] public string TPImgName { get; set; } [ColDetail(400,"XSpcImgName",1,1,100,1,"a.XSpcImgName","",1,1)] public string XSpcImgName { get; set; } [ColDetail(410,"YSpcImgName",1,1,100,1,"a.YSpcImgName","",1,1)] public string YSpcImgName { get; set; } [ColDetail(420,"TSpcImgName",1,1,100,1,"a.TSpcImgName","",1,1)] public string TSpcImgName { get; set; } [ColDetail(430,"enclosureSrcName",1,1,100,1,"a.enclosureSrcName","",1,1)] public string enclosureSrcName { get; set; } public override string GetSelectSql() { return string.Format($"select { GetQueryColSql()} from { GetQueryTabSql()}"); } public override string GetQueryColSql() { string sqlstr = "a.ID ID,a.Classes Classes,a.floor floor,a.customer customer,a.macID macID,a.position position,a.enclosureSrc enclosureSrc,a.RecCode RecCode"; sqlstr += ",a.RecTime RecTime,a.ModCode ModCode,a.ModTime ModTime,a.NextTime NextTime,b.FName RecName,c.FName ModName,a.XCmk XCmk,a.YCmk YCmk,a.TCmk TCmk"; sqlstr += ",a.XP XP,a.YP YP,a.TP TP,a.XCmkImg XCmkImg,a.YCmkImg YCmkImg,a.TCmkImg TCmkImg,a.XPImg XPImg,a.YPImg YPImg,a.TPImg TPImg,a.XSpcImg XSpcImg"; sqlstr += ",a.YSpcImg YSpcImg,a.TSpcImg TSpcImg,a.ThisTime ThisTime,a.XCmkImgName XCmkImgName,a.YCmkImgName YCmkImgName,a.TCmkImgName TCmkImgName"; sqlstr += ",a.XPImgName XPImgName,a.YPImgName YPImgName,a.TPImgName TPImgName,a.XSpcImgName XSpcImgName,a.YSpcImgName YSpcImgName,a.TSpcImgName TSpcImgName"; sqlstr += ",a.enclosureSrcName enclosureSrcName,0 EntityStatusID"; return sqlstr; } public override string GetQueryTabSql() { string sqlstr=" ofilmcmk a "; sqlstr+=" left outer join staff b on a.RecCode =b.FCode"; sqlstr+=" left outer join staff c on a.ModCode =c.FCode"; return sqlstr; } public override string GetQuerySortSql() { return ""; } #endregion ////自动产生代码结束&&此行不能删除 /// [Ignore] public string XCmkImgBase { get; set; } [Ignore] public string YCmkImgBase { get; set; } [Ignore] public string TCmkImgBase { get; set; } [Ignore] public string XPImgBase { get; set; } [Ignore] public string YPImgBase { get; set; } [Ignore] public string TPImgBase { get; set; } [Ignore] public string XSpcImgBase { get; set; } [Ignore] public string YSpcImgBase { get; set; } [Ignore] public string TSpcImgBase { get; set; } } }