【GVA】gorm多对多关联使用Preload带出关联表中的数据

db.Limit(limit).Offset(offset).Preload("BusinessSystemList").Find(&projectManagements).Error

// GetProjectManagementInfoList 分页获取ProjectManagement记录 // Author [piexlmax](https://github.com/piexlmax) func (projectManagementService *ProjectManagementService) GetProjectManagementInfoList(info autoCodeReq.ProjectManagementSearch) (err error, list interface{}, total int64) {limit := info.PageSizeoffset := info.PageSize * (info.Page - 1)// 创建dbdb := global.GVA_DB.Model(&autocode.ProjectManagement{})var projectManagements []autocode.ProjectManagement// 如果有条件搜索 下方会自动创建搜索语句if info.ProjectName != "" {db = db.Where("`project_name` LIKE ?", "%"+info.ProjectName+"%")}if info.ProjectDesc != "" {db = db.Where("`project_desc` LIKE ?", "%"+info.ProjectDesc+"%")}if info.ProjectManager != 0 {db = db.Where("`project_manager` = ?", info.ProjectManager)}if info.CustomerName != "" {db = db.Where("`customer_name` LIKE ?", "%"+info.CustomerName+"%")}if info.ProjectStartDate != nil {db = db.Where("`project_start_date` = ?", info.ProjectStartDate)}if info.ProjectEndDate != nil {db = db.Where("`project_end_date` = ?", info.ProjectEndDate)}err = db.Count(&total).Errorif err != nil {return}// err = db.Limit(limit).Offset(offset).Find(&projectManagements).Error// 带出businessSystemListerr = db.Limit(limit).Offset(offset).Preload("BusinessSystemList").Find(&projectManagements).Errorreturn err, projectManagements, total }

总结

以上是生活随笔为你收集整理的【GVA】gorm多对多关联使用Preload带出关联表中的数据的全部内容，希望文章能够帮你解决所遇到的问题。

如果觉得生活随笔网站内容还不错，欢迎将生活随笔推荐给好友。