/// <summary>
/// 获取排行榜信息
/// </summary>
/// <returns></returns>
public static RankListDto GetRankListDto()
{
MySqlCommand cmd = new MySqlCommand("select name,coin from user order by coin desc", sqlConnection);
MySqlDataReader reader = cmd.ExecuteReader();
rankListDto.Clear(); // 先清空排行榜信息
if (reader.HasRows)
{
while (reader.Read())
{
RankItemDto dto = new RankItemDto(reader.GetString("name"), reader.GetInt32("coin"));
rankListDto.Add(dto);
}
reader.Close();
return(rankListDto);
}
reader.Close();
return(null);
}
/// <summary>
/// 获取排行榜信息
/// </summary>
/// <returns></returns>
public static RankListDto GetRankListDto()
{
MySqlCommand cmd = new MySqlCommand("select UserName,Coin from userinfo order by Coin desc", sqlConcect);
MySqlDataReader reader = cmd.ExecuteReader();
rankListDto.Clear();
if (reader.HasRows)
{
while (reader.Read())
{
RankItemDto dto = new RankItemDto(reader.GetString("UserName"), reader.GetInt32("Coin"));
rankListDto.Add(dto);
}
reader.Close();
return(rankListDto);
}
reader.Close();
return(null);
}
void GenerateRankList(RankListDto dto)
{
//先清空排行榜里面的东西，再重新生成一份
foreach (Transform child in scrollViewContentTransform)
{
Destroy(child.gameObject);
}
GameObject rankListItemPrefab = ResourceManager.GetRankListItem();
List <RankItemDto> list = dto.list;
for (int i = 0; i < list.Count; i++)
{
RankItemDto item = list[i];
GameObject rankListItem = Instantiate(rankListItemPrefab);
rankListItem.GetComponent <RankListItem>().SetInfo(i + 1, item.username, item.coin);
rankListItem.transform.SetParent(scrollViewContentTransform);
rankListItem.transform.localScale = Vector3.one;
}
}
public static RankListDto GetRankListDto(int maxCount = 10)
{
MySqlCommand cmd = connection.CreateCommand();
cmd.CommandText = "select username,coin from user_info order by coin desc";
MySqlDataReader reader = cmd.ExecuteReader();
RankListDto resultList = new RankListDto();
RankItemDto item = new RankItemDto();
int count = 0;
if (reader.HasRows)
{
while (reader.Read() && count < maxCount)
{
item.username = reader.GetString("username");
item.coin = reader.GetInt32("coin");
resultList.list.Add(item);
count += 1;
}
}
reader.Close();
return(resultList);
}
