trans_bankInfo.go 1.5 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273
  1. package transaction
  2. import (
  3. "runtime/debug"
  4. "bet24.com/database"
  5. "bet24.com/log"
  6. )
  7. // 银行信息列表
  8. type (
  9. bankInfoList_in struct {
  10. UserID int
  11. }
  12. // 银行卡信息
  13. bankInfo struct {
  14. RealName string // 真实姓名
  15. BankCard string // 银行卡
  16. BankName string // 银行名称
  17. Mobile string // 手机号
  18. EMail string // 邮箱
  19. Address string // 地址
  20. }
  21. bankInfoList_out struct {
  22. List []bankInfo
  23. }
  24. bankInfoList struct {
  25. database.Trans_base
  26. In bankInfoList_in
  27. Out bankInfoList_out
  28. }
  29. )
  30. func NewBankInfoList() *bankInfoList {
  31. return &bankInfoList{}
  32. }
  33. func (this *bankInfoList) DoAction() {
  34. defer func() {
  35. if err := recover(); err != nil {
  36. log.Error("transaction recover err %v", err)
  37. log.Error("%s", debug.Stack())
  38. }
  39. }()
  40. statement := database.NewStatement()
  41. statement.SetNeedReturnValue(false)
  42. statement.SetOpenRecordSet(true)
  43. statement.SetProcName("Pay_BankInfo_GetList")
  44. statement.AddParamter("@UserID", database.AdParamInput, database.AdInteger, 4, this.In.UserID)
  45. sqlstring := statement.GenSql()
  46. retRows := CenterDB.ExecSql(sqlstring)
  47. rowLen := len(retRows)
  48. if rowLen <= 0 {
  49. return
  50. }
  51. this.Out.List = make([]bankInfo, rowLen)
  52. for i := 0; i < rowLen; i++ {
  53. ret := retRows[i]
  54. out := &this.Out.List[i]
  55. out.RealName = (ret[0]).(string)
  56. out.BankCard = (ret[1]).(string)
  57. out.BankName = (ret[2]).(string)
  58. out.Mobile = (ret[3]).(string)
  59. out.EMail = (ret[4]).(string)
  60. out.Address = (ret[5]).(string)
  61. }
  62. }