package equipment import ( "time" ) //查询数据 type Trigger_Abnormal struct { Id int `xorm:"not null pk autoincr INT(11)"` DataItem int `xorm:"INT(11)"` CreateUserId int `xorm:"VARCHAR(50)"` CreateBy string `xorm:"VARCHAR(50)"` UserName string `xorm:"VARCHAR(50)"` CreateOn time.Time `xorm:"DATETIME created"` Serial string `xorm:"VARCHAR(500)"` Time time.Time `field:"time,f"` } //查询数据1 type Trigger_Abnormal1 struct { CreateBy string `xorm:"VARCHAR(50)"` CreateOn time.Time `xorm:"DATETIME created"` Serial string `xorm:"VARCHAR(500)"` Time time.Time `field:"time,f"` Online int `xorm:"INT(10)"` } type EquipMent struct { Id int `xorm:"not null pk autoincr INT(10)"` ModelId int `xorm:"INT(10)"` Code string `xorm:"VARCHAR(50)"` DeviceState int `xorm:"INT(10)"` ChannelState int `xorm:"INT(10)"` ChannelNum int `xorm:"INT(10)"` SortCode int `xorm:"INT(10)"` Enabled int `xorm:"not null default 1 INT(10)"` CreateOn time.Time `xorm:"DATETIME created" form:"-" json:"-"` CreateUserId int `xorm:"INT(11)" form:"-" json:"-"` CreateBy string `xorm:"VARCHAR(50)" form:"-"` ModifiedOn time.Time `xorm:"DATETIME updated" form:"-" json:"-"` ModifiedUserId int `xorm:"INT(11)" form:"-" json:"-"` ModifiedBy string `xorm:"VARCHAR(50)" form:"-" json:"-"` Local string `xorm:"VARCHAR(50)"` Latitude int `xorm:"INT(10)"` Longitude int `xorm:"INT(10)"` OrganizeId int `xorm:"INT(10)"` OrganizeName string `xorm:"VARCHAR(50)"` } type Base_User struct { Id int `xorm:"not null pk autoincr INT(10)"` AccCode string `xorm:"VARCHAR(50)"` Username string `xorm:"VARCHAR(50)"` Realname string `xorm:"VARCHAR(50)"` } type EquipMentModel struct { Id int `xorm:"not null pk autoincr INT(10)"` DItem int `xorm:"INT(10)"` DItemName string `xorm:"VARCHAR(50)"` Brands string `xorm:"VARCHAR(50)"` DModel string `xorm:"VARCHAR(50)"` Structure string `xorm:"VARCHAR(50)"` Photo string `xorm:"VARCHAR(50)"` LowTemperature int `xorm:"INT(10)"` HightTemperature int `xorm:"INT(10)"` SortCode int `xorm:"INT(10)"` Enabled int `xorm:"not null default 1 INT(10)"` CreateOn time.Time `xorm:"DATETIME created" form:"-" json:"-"` CreateUserId int `xorm:"INT(11)" form:"-" json:"-"` CreateBy string `xorm:"VARCHAR(50)" form:"-"` ModifiedOn time.Time `xorm:"DATETIME updated" form:"-" json:"-"` ModifiedUserId int `xorm:"INT(11)" form:"-" json:"-"` ModifiedBy string `xorm:"VARCHAR(50)" form:"-" json:"-"` Remark string `xorm:"VARCHAR(50)"` SpareData string `xorm:"VARCHAR(50)"` } type EquipMentSort struct { Id int `xorm:"<- not null pk autoincr INT(10)"` UserId int `xorm:"INT(10)"` EquipMentlId int `xorm:"INT(10)"` SortCode int `xorm:"INT(10)"` CreateOn time.Time `xorm:"DATETIME created" form:"-" json:"-"` CreateUserId int `xorm:"INT(11)" form:"-" json:"-"` CreateBy string `xorm:"VARCHAR(50)" form:"-"` ModifiedOn time.Time `xorm:"DATETIME updated" form:"-" json:"-"` ModifiedUserId int `xorm:"INT(11)" form:"-" json:"-"` ModifiedBy string `xorm:"VARCHAR(50)" form:"-" json:"-"` } type EquipmentSet struct { Id int Code string SortCode int DeviceState int OrganizeId int OrganizeName string Brands string TagCode string MaxValue string MinValue string DModel string Photo string CTitle string //传感器名称,会有多个,已逗号隔开 CSerial string //传感器序列号,会有多个,已逗号隔开 CDataItem string //传感器类型,会有多个,已逗号隔开 } type EquipmentReport struct { OrganizeId int //组织ID OrganizeName string //组织名称 DItem int //设备类型 DItemName string //设备类型名 Num int //设备数量 Ids string //设备ID,多个用逗号隔开 Triggercount int } type EquipmentIdCode struct { Id string Code string } type Base_UserEquipments struct { Id int `xorm:"<- not null pk autoincr INT(10)"` AccCode string `xorm:"VARCHAR(50)"` UserId int `xorm:"INT(10)"` EquipmentId int `xorm:"not null INT(10)"` Sortcode int `xorm:"INT(10)"` Enabled int `xorm:"not null default 1 INT(10)"` Description string `xorm:"VARCHAR(100)"` Createon time.Time `xorm:"DATETIME created" form:"-" json:"-"` Createuserid int `xorm:"INT(11)" form:"-" json:"-"` Createby string `xorm:"VARCHAR(50)" form:"-" json:"-"` Modifiedon time.Time `xorm:"DATETIME updated" form:"-" json:"-"` Modifieduserid int `xorm:"INT(11)" form:"-" json:"-"` Modifiedby string `xorm:"VARCHAR(50)" form:"-" json:"-"` } //报警历史 type Record_History struct { Id int ProjectSourse string ProjectAccount string ProjectAccountName string SendTo string ActionType string Message string IsRead int IsSend int SendErrorMsg string DeviceId string DeviceName string ChannelCode string ChannelName string CreateOn time.Time CreateUserId int CreateBy string ModifiedOn time.Time ModifiedUserId int ModifiedBy string CausePerson string }