edb_classify.go 1.2 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950
  1. package data_manage
  2. import (
  3. "eta_gn/eta_task/global"
  4. "time"
  5. )
  6. type EdbClassify struct {
  7. ClassifyID int64 `gorm:"column:classify_id;primaryKey"` //`orm:"column(classify_id);pk"`
  8. ClassifyType uint32
  9. ClassifyName string
  10. ParentID int64
  11. HasData int32
  12. CreateTime time.Time
  13. ModifyTime time.Time
  14. SysUserID int64
  15. SysUserRealName string
  16. Level int64
  17. UniqueCode string
  18. Sort uint32
  19. RootID int64
  20. LastModifyUserID uint32
  21. LastModifyUserRealName string
  22. IsJoinPermission int64
  23. ClassifyNameEn string
  24. }
  25. func GetAllEdbClassifyListByCondition(condition string, pars []interface{}) (item []*EdbClassify, err error) {
  26. sql := ` SELECT * FROM edb_classify WHERE 1=1 `
  27. if condition != "" {
  28. sql += condition
  29. }
  30. sql += `ORDER BY classify_id ASC `
  31. err = global.DmSQL["data"].Raw(sql, pars...).Find(&item).Error
  32. return
  33. }
  34. func AddEdbClassify(item *EdbClassify) (err error) {
  35. err = global.DmSQL["data"].Create(item).Error
  36. if err != nil {
  37. return
  38. }
  39. return
  40. }
  41. func (m *EdbClassify) Update(cols []string) (err error) {
  42. err = global.DmSQL["data"].Select(cols).Updates(m).Error
  43. return
  44. }