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带出关联表中的数据的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。