hongze_cygx/models/industrial_management.go

package models

import (
	"rdluck_tools/orm"
)

//产业列表
func GetIndustrialManagementAll(ChartPermissionId int) (items []*IndustrialManagement, err error) {
	o := orm.NewOrm()
	sql := `SELECT *
		FROM
		cygx_industrial_management AS man 
		WHERE
		man.chart_permission_id = ?`
	_, err = o.Raw(sql, ChartPermissionId).QueryRows(&items)
	return
}

//标的列表
func GetIndustrialSubjectAll(IndustrialManagementId int) (items []*IndustrialSubject, err error) {
	o := orm.NewOrm()
	sql := `SELECT * FROM cygx_industrial_subject WHERE industrial_management_id = ? `
	_, err = o.Raw(sql, IndustrialManagementId).QueryRows(&items)
	return
}

//分析师列表
func GetIndustrialAnalystAll(IndustrialManagementId int) (items []*IndustrialAnalyst, err error) {
	o := orm.NewOrm()
	sql := `SELECT * FROM cygx_industrial_analyst where industrial_management_id = ? `
	_, err = o.Raw(sql, IndustrialManagementId).QueryRows(&items)
	return
}