void refresh()
{
Transform container = needshow[0].transform.FindChild("scroll").FindChild("body").FindChild("container");
container.parent.GetComponent <UIPanel>().clipOffset = Vector2.zero;
container.parent.localPosition = new Vector3(0, 0, 0);
MyUtilTools.clearChild(container);
float starty = 440;
for (int i = 0; i < entitys.Count; i++)
{
RankEntity entity = entitys[i];
GameObject summary = NGUITools.AddChild(container.gameObject, pref_obj);
summary.name = "rank_" + i;
summary.transform.localPosition = new Vector3(0, starty, 0);
UISprite icon = summary.transform.FindChild("icon").GetComponent <UISprite>();
icon.spriteName = entity.face;
UILabel name = summary.transform.FindChild("name").GetComponent <UILabel>();
name.text = entity.nikeName;
UILabel context = summary.transform.FindChild("content").GetComponent <UILabel>();
float stand = 1000000f;
string worthStr = (entity.worth > stand ? (entity.worth / stand + "万") : (entity.worth + ""));
context.text = "总共完成 " + entity.count + " 笔交易,成交总金额 " + worthStr + "元";
starty -= 130;
}
}
// Update is called once per frame
void Update()
{
ByteBuffer buffer = MyUtilTools.tryToLogic("RankEvent");
if (buffer != null)
{
entitys.Clear();
int len = buffer.ReadInt();
for (int i = 0; i < len; i++)
{
RankEntity entity = new RankEntity();
entity.deserialize(buffer);
entitys.Add(entity);
}
click();
refresh();
}
}
public List <RankEntity> getRankList()
{
OpenSql();
String sql = "select * from rank order by score desc limit 10;";
MySqlCommand cmd = new MySqlCommand(sql, mySqlConnection);
List <RankEntity> ret = new List <RankEntity>();
using (MySqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
RankEntity tmp = new RankEntity();
tmp.setUserName(reader.GetString("deviceName"));
tmp.setScore((long)reader.GetUInt64("score"));
ret.Add(tmp);
}
}
CloseSql();
return(ret);
}
