everlight.eap/backend/DllEapEntity/OFILM/Ofilmcmk.cs

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; }
    }
}