course.go 3.5 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495
  1. // Package postgre
  2. /**
  3. * @ File:
  4. * @ Date: 2021/5/27 10:13
  5. * @ Author: JYQ
  6. * @ Description:
  7. */
  8. package postgre
  9. type PGCourse struct {
  10. }
  11. func (PGCourse) StdListQuery(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  12. err = getClient().Raw("select fn_cd_std_list_query(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  13. Scan(&result).Error
  14. return
  15. }
  16. func (PGCourse) ClassListByOrderDate(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  17. err = getClient().Raw("select fn_stt_class_list_by_order_date(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  18. Scan(&result).Error
  19. return
  20. }
  21. func (PGCourse) ClassStartPrepare(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  22. err = getClient().Raw("select fn_cd_class_start_prepare(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  23. Scan(&result).Error
  24. return
  25. }
  26. func (PGCourse) ClassDetailListQuery(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  27. err = getClient().Raw("select fn_cd_class_detail_list_query(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  28. Scan(&result).Error
  29. return
  30. }
  31. func (PGCourse) ClassDetailAdd(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  32. err = getClient().Raw("select fn_cd_class_detail_add(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  33. Scan(&result).Error
  34. return
  35. }
  36. func (PGCourse) ClassDetailDel(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  37. err = getClient().Raw("select fn_cd_class_detail_del(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  38. Scan(&result).Error
  39. return
  40. }
  41. func (PGCourse) ClassTmpUserDetailAdd(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  42. err = getClient().Raw("select fn_cd_class_tmp_user_detail_add(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  43. Scan(&result).Error
  44. return
  45. }
  46. func (PGCourse) ClassTmpUserDetailDel(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  47. err = getClient().Raw("select fn_cd_class_tmp_user_detail_del(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  48. Scan(&result).Error
  49. return
  50. }
  51. func (PGCourse) ClassDetailStatusEdit(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  52. err = getClient().Raw("select fn_cd_class_detail_status_edit(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  53. Scan(&result).Error
  54. return
  55. }
  56. func (PGCourse) ClassStartConfirm(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  57. err = getClient().Raw("select fn_cd_class_start_confirm(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  58. Scan(&result).Error
  59. return
  60. }
  61. func (PGCourse) ClassOverConfirm(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  62. err = getClient().Raw("select fn_cd_class_over_confirm(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  63. Scan(&result).Error
  64. return
  65. }
  66. func (PGCourse) ClassGiveUpConfirm(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
  67. err = getClient().Raw("select fn_cd_class_give_up_confirm(? ,? ,?, ? )", optUserId, objectShopId, jsonStr, verfStr).
  68. Scan(&result).Error
  69. return
  70. }