transaction.go 1.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748
  1. package hall
  2. import (
  3. "runtime/debug"
  4. "bet24.com/servers/payment/db"
  5. "bet24.com/database"
  6. "bet24.com/log"
  7. )
  8. // 师徒登录(绑定)
  9. func register(req register_req) register_resp {
  10. defer func() {
  11. if err := recover(); err != nil {
  12. log.Error("transaction recover err %v", err)
  13. log.Error("%s", debug.Stack())
  14. }
  15. }()
  16. var resp register_resp
  17. statement := database.NewStatement()
  18. statement.SetNeedReturnValue(false)
  19. statement.SetOpenRecordSet(true)
  20. statement.SetProcName("H5_AllUser_Register")
  21. statement.AddParamter("@IMei", database.AdParamInput, database.AdVarChar, 64, req.IMei)
  22. statement.AddParamter("@NickName", database.AdParamInput, database.AdNVarChar, 32, req.NickName)
  23. statement.AddParamter("@Sex", database.AdParamInput, database.AdInteger, 4, req.Sex)
  24. statement.AddParamter("@FaceID", database.AdParamInput, database.AdInteger, 4, req.FaceID)
  25. statement.AddParamter("@FaceUrl", database.AdParamInput, database.AdVarChar, 1024, req.FaceUrl)
  26. statement.AddParamter("@PartnerID", database.AdParamInput, database.AdInteger, 4, req.PartnerID)
  27. statement.AddParamter("@Version", database.AdParamInput, database.AdInteger, 4, req.Version)
  28. statement.AddParamter("@IPAddress", database.AdParamInput, database.AdVarChar, 16, req.IpAddress)
  29. sqlstring := statement.GenSql()
  30. // log.Debug(sqlstring)
  31. retRows := db.CenterDB.ExecSql(sqlstring)
  32. if len(retRows) <= 0 {
  33. return resp
  34. }
  35. ret := retRows[0]
  36. resp.RetCode = int((*ret[0].(*interface{})).(int64))
  37. resp.UserID = int((*ret[1].(*interface{})).(int64))
  38. resp.NickName = (*ret[2].(*interface{})).(string)
  39. // log.Debug("register.resp==>%+v", resp)
  40. return resp
  41. }