package models
|
|
type Dictionary struct {
|
Id string `gorm:"primary_key;column:id;" json:"id"`
|
Value string `gorm:"column:value" json:"value"` //值
|
Name string `gorm:"column:name" json:"name"` //名称
|
Type string `gorm:"column:type" json:"type"` //类型
|
Description string `gorm:"column:description" json:"description"` //描述
|
Sort int `gorm:"column:sort;default:1" json:"sort"`
|
ParentId string `gorm:"column:parent_id;default:0" json:"parent_id"`
|
}
|
|
const (
|
TYPE_VEHICLE_COLOR = "nVehicleColor" //车身颜色
|
TYPE_VEHICLE_TYPE = "nVehicleType" //车辆类型
|
TYPE_PLATE_TYPE = "nPlateType" //车牌类型
|
TYPE_VEHICLE_BRAND = "nVehicleBrand" //车辆品牌
|
)
|
|
func (Dictionary) TableName() string {
|
return "dictionary"
|
}
|
|
func (dic *Dictionary) FindAll() (dics []Dictionary, err error) {
|
if err := db.Table(dic.TableName()).Find(&dics).Error; err != nil {
|
return nil, err
|
}
|
return dics, nil
|
}
|
|
func (dic *Dictionary) FindByType(dicType string) (dics []Dictionary, err error) {
|
if err := db.Table(dic.TableName()).Where("type=?", dicType).Order("sort asc").Scan(&dics).Error; err != nil {
|
return nil, err
|
}
|
return dics, nil
|
}
|
|
func (dic *Dictionary) FindByParentId(parentId string) (dics []Dictionary, err error) {
|
if err := db.Table(dic.TableName()).Where("parent_id=?", parentId).Scan(&dics).Error; err != nil {
|
return nil, err
|
}
|
return dics, nil
|
}
|
|
func (dic *Dictionary) Insert() (bool, error) {
|
if err := db.Table(dic.TableName()).Create(&dic).Error; err != nil {
|
return false, err
|
}
|
return true, nil
|
}
|
|
func (dic *Dictionary) Update() (bool, error) {
|
if err := db.Table(dic.TableName()).Update(&dic).Error; err != nil {
|
return false, err
|
}
|
return true, nil
|
}
|
|
func (dic *Dictionary) SelectById(id string) (bool, error) {
|
result := db.Table(dic.TableName()).Where("id=?", id).First(&dic)
|
if result.Error != nil {
|
return false, err
|
}
|
return result.RecordNotFound(), nil
|
}
|
