data_entry.go 473 B

123456789101112131415161718192021
  1. package models
  2. import "rdluck_tools/orm"
  3. //数据录入
  4. type EdbInfo struct {
  5. UserId int
  6. SecName string `orm:"column(SEC_NAME);" description:"指标名称"`
  7. NoticeTime string
  8. Frequency string
  9. }
  10. //获取日度指标
  11. func GetEdbInfoByFrequency(frequency string) (items []*EdbInfo, err error) {
  12. sql := `SELECT * FROM edbinfo WHERE frequency=? AND notice_time<>'' `
  13. o := orm.NewOrm()
  14. o.Using("edb")
  15. _, err = o.Raw(sql, frequency).QueryRows(&items)
  16. return
  17. }