//获取金币排行榜,前50 protected void GetScoreRank(HttpContext context) { StringBuilder msg = new StringBuilder( ); int pageIndex = GameRequest.GetInt("pageindex", 1); int pageSize = GameRequest.GetInt("pagesize", 10); int userID = GameRequest.GetInt("UserID", 0); if (pageIndex <= 0) { pageIndex = 1; } if (pageSize <= 0) { pageSize = 10; } if (pageSize > 50) { pageSize = 50; } //获取用户排行 string sqlQuery = string.Format("SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY Score DESC) as ChartID,UserID,Score FROM GameScoreInfo) a WHERE UserID={0}", userID); DataSet dsUser = treasureFacade.GetDataSetByWhere(sqlQuery); int uChart = 0; Int64 uScore = 0; if (dsUser.Tables[0].Rows.Count != 0) { uChart = Convert.ToInt32(dsUser.Tables[0].Rows[0]["ChartID"]); uScore = Convert.ToInt64(dsUser.Tables[0].Rows[0]["Score"]); } //获取总排行 DataSet ds = treasureFacade.GetList("GameScoreInfo", pageIndex, pageSize, " ORDER BY Score DESC", " ", "UserID,Score").PageSet; if (ds.Tables[0].Rows.Count > 0) { msg.Append("["); //添加用户排行 msg.Append("{\"NickName\":\"" + Fetch.GetNickNameByUserID(userID) + "\",\"Score\":" + uScore + ",\"Rank\":" + uChart + "},"); foreach (DataRow dr in ds.Tables[0].Rows) { msg.Append("{\"NickName\":\"" + Fetch.GetNickNameByUserID(Convert.ToInt32(dr["UserID"])) + "\",\"Score\":" + dr["Score"] + "},"); } msg.Remove(msg.Length - 1, 1); msg.Append("]"); } else { msg.Append("{}"); } context.Response.Write(msg.ToString( )); }
//获取金币排行榜,前50 protected void GetScoreRank(HttpContext context) { StringBuilder msg = new StringBuilder( ); int pageIndex = GameRequest.GetInt("pageindex", 1); int pageSize = GameRequest.GetInt("pagesize", 10); if (pageIndex <= 0) { pageIndex = 1; } if (pageSize <= 0) { pageSize = 10; } if (pageSize > 50) { pageSize = 50; } DataSet ds = treasureFacade.GetList("GameScoreInfo", pageIndex, pageSize, " ORDER BY Score DESC", " WHERE UserID IN(SELECT UserID FROM QPAccountsDBLink.QPAccountsDB.dbo.AccountsInfo)", "UserID,Score").PageSet; if (ds.Tables[0].Rows.Count > 0) { msg.Append("["); foreach (DataRow dr in ds.Tables[0].Rows) { msg.Append("{\"NickName\":\"" + Fetch.GetNickNameByUserID(Convert.ToInt32(dr["UserID"])) + "\",\"Score\":" + dr["Score"] + "},"); } msg.Remove(msg.Length - 1, 1); msg.Append("]"); } else { msg.Append("{}"); } context.Response.Write(msg.ToString( )); }