lighting_control/server/dao/area.go

package dao

import "server/global"

// Area 分区
type Area struct {
	global.GVA_MODEL
	GatewayID uint   `json:"gatewayId" gorm:"column:gateway_id;comment:关联网关ID"`
	AreaNo    string `json:"areaNo" gorm:"column:area_no;comment:区号(00 00 格式)"`
	AreaName  string `json:"areaName" gorm:"column:area_name;comment:分区名称(兼容汉字映射)"`
}

func (Area) TableName() string {
	return "area"
}

func QueryAllAreas() (areas []Area, err error) {
	err = global.GVA_DB.Model(&Area{}).Find(&areas).Error
	return
}

func (a Area) CreateArea() error {
	return global.GVA_DB.Create(&a).Error
}

func (a Area) UpdateArea() error {
	return global.GVA_DB.Save(&a).Error
}

func DeleteArea(id int) error {
	return global.GVA_DB.Unscoped().Delete(&Area{}, id).Error
}