longzhong.go 618 B

1234567891011121314151617181920
  1. package models
  2. import "rdluck_tools/orm"
  3. func GetLongzhonginfoByClassifyId(classifyId int) (items []*Longzhonginfo, err error) {
  4. sql := `SELECT * FROM longzhonginfo WHERE classify_id=? ORDER BY longzhonginfo_id ASC `
  5. o := orm.NewOrm()
  6. o.Using("edb")
  7. _, err = o.Raw(sql, classifyId).QueryRows(&items)
  8. return
  9. }
  10. func GetLongzhongpriceinfoByClassifyName(productName string) (items []*Longzhongpriceinfo, err error) {
  11. sql := `SELECT * FROM longzhongpriceinfo WHERE product_name=? ORDER BY longzhongpriceinfo_id ASC `
  12. o := orm.NewOrm()
  13. o.Using("edb")
  14. _, err = o.Raw(sql, productName).QueryRows(&items)
  15. return
  16. }