query.go 636 B

123456789101112131415
  1. package voice_broadcast
  2. import "hongze/hongze_yb/global"
  3. func GetBroadcastByCondition(pageIndex, pageSize int) (list []*VoiceBroadcast, err error) {
  4. offset := (pageIndex - 1) * pageSize
  5. err = global.DEFAULT_MYSQL.Model(VoiceBroadcast{}).Offset(offset).Limit(pageSize).Order("create_time DESC").Scan(&list).Error
  6. return
  7. }
  8. func GetBroadcastById(pageIndex, pageSize, broadcastId int) (list []*VoiceBroadcast, err error) {
  9. offset := (pageIndex - 1) * pageSize
  10. err = global.DEFAULT_MYSQL.Model(VoiceBroadcast{}).Where("broadcast_id=?", broadcastId).Offset(offset).Limit(pageSize).Order("create_time DESC").Scan(&list).Error
  11. return
  12. }