예제 #1
0
        public HttpResponseMessage WinDataByUser([FromUri] GameWinDataRequest request)
        {
            ResultData resultData = new ResultData();

            int intUid = UserTokenUtils.getIdByTokenString(request.token);

            if (intUid == -1)
            {
                resultData.status  = "1";
                resultData.message = "token解析失败";
                return(ToJsonUtil.toJson(resultData));
            }

            int intGameId = 0;

            if (string.IsNullOrWhiteSpace(request.gameId) || !int.TryParse(request.gameId, out intGameId))
            {
                resultData.status  = "1";
                resultData.message = "游戏ID不正确";
                return(ToJsonUtil.toJson(resultData));
            }

            resultData.status = "0";
            var dataList = game_RecordDAL.GetWinDataByUser(intUid, request.gameId, request.topNumber);

            if (dataList != null && dataList.Count > 0)
            {
                resultData.data = dataList.Select(p => new { time = p.time_stamp.ToString("yyyy-MM-dd HH:mm:ss"), remark = p.result_message.TrimEnd(',') });
            }

            return(ToJsonUtil.toJson(resultData));
        }
예제 #2
0
        public UserAccount getUserInfoByToken(string token)
        {
            if (string.IsNullOrEmpty(token) || "null" == token || "undefined" == token)
            {
                return(null);
            }
            int    userId = UserTokenUtils.getIdByTokenString(token);
            string sql    = @"SELECT *,
case when DATEDIFF(day, addtime, getdate())> isnull((select top 1 value from rrl_config where item = 'NewUser_Confirm_Days'),7)
then '0' ELSE '1' end as is_news_user
 FROM rrl_user WHERE id = @id";

            try
            {
                SqlDataBase db   = new SqlDataBase();
                UserAccount user = db.Single <UserAccount>(sql, new { id = userId });
                return(user);
            }
            catch (Exception)
            {
                return(null);
            }

            /*
             * string sql = "SELECT * FROM rrl_user WHERE short_time_token = @token";
             * try
             * {
             *  SqlDataBase db = new SqlDataBase();
             *  UserAccount user = db.Single<UserAccount>(sql, new { token = token });
             *  return user;
             * }
             * catch (Exception)
             * {
             *
             *  return null;
             * }
             */
        }