labsop_mcs/backend/src/dashoo.cn/mms_api/business/equipment/equipment.go

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
}