| | |
| | | "apsClient/pkg/sqlitex" |
| | | "errors" |
| | | "fmt" |
| | | "gorm.io/gorm" |
| | | "github.com/jinzhu/gorm" |
| | | "sync" |
| | | ) |
| | | |
| | | type ( |
| | | // PlcBrand plc品牌 |
| | | PlcBrand struct { |
| | | Id int `json:"id" gorm:"column:id;type:int;primary_key;AUTO_INCREMENT"` |
| | | Name string `json:"name" gorm:"column:name;type:varchar(255);not null;default:'';comment:名称"` |
| | | gorm.Model |
| | | Name string `json:"name" gorm:"column:name;type:varchar(255);not null;default:''"` |
| | | } |
| | | |
| | | // PlcBrandSearch plc品牌搜索条件 |
| | |
| | | |
| | | func (slf *PlcBrandSearch) build() *gorm.DB { |
| | | var db = slf.Orm.Model(&PlcBrand{}) |
| | | if slf.Id != 0 { |
| | | db = db.Where("id = ?", slf.Id) |
| | | if slf.ID != 0 { |
| | | db = db.Where("id = ?", slf.ID) |
| | | } |
| | | |
| | | return db |
| | |
| | | |
| | | func (slf *PlcBrandSearch) CreateBatch(records []*PlcBrand) error { |
| | | var db = slf.build() |
| | | return db.Create(records).Error |
| | | for _, record := range records{ |
| | | db.Create(record) |
| | | } |
| | | return nil |
| | | } |
| | | |
| | | func (slf *PlcBrandSearch) Delete() error { |
| | |
| | | return record, err |
| | | } |
| | | |
| | | func (slf *PlcBrandSearch) SetId(id int) *PlcBrandSearch { |
| | | slf.Id = id |
| | | func (slf *PlcBrandSearch) SetId(id uint) *PlcBrandSearch { |
| | | slf.ID = id |
| | | return slf |
| | | } |
| | | |
| | |
| | | } |
| | | |
| | | func (slf *PlcBrandSearch) Save(record *PlcBrand) error { |
| | | if record.Id == 0 { |
| | | if record.ID == 0 { |
| | | return errors.New("id为空") |
| | | } |
| | | var db = slf.build() |
| | |
| | | return |
| | | } |
| | | records := []*PlcBrand{ |
| | | {1, "欧姆龙"}, |
| | | {2, "西门子"}, |
| | | {3, "松下"}, |
| | | {Name: "欧姆龙"}, |
| | | {Name: "西门子"}, |
| | | {Name: "松下"}, |
| | | } |
| | | err := slf.CreateBatch(records) |
| | | if err != nil { |