//载入数据 public void DB_Load() { String sql = string.Format("select id,name,guanjue from cq_user ORDER BY guanjue DESC"); MySqlCommand command = new MySqlCommand(sql, MysqlConn.GetConn()); MysqlConn.Conn_Open(); MySqlDataReader reader = command.ExecuteReader(); //最多五十个排名 const int MAX_JUEWEI = 50; int index = 0; while(reader.Read()) { if (!reader.HasRows)break; ulong guanjue = reader.GetUInt64("guanjue"); if (guanjue == 0) break; GuanJueInfo info = new GuanJueInfo(); info.guanjue = guanjue; info.id = reader.GetUInt32("id"); info.name = reader.GetString("name"); info.name = Coding.Latin1ToGB2312(info.name); mListInfo.Add(info); index++; if (index > MAX_JUEWEI) break; } MysqlConn.Conn_Close(); command.Dispose(); }
public void Create(byte[] msg) { PackIn inpack = new PackIn(msg); inpack.ReadUInt16(); int count = inpack.ReadInt32(); for (int i = 0; i < count; i++) { GuanJueInfo info = new GuanJueInfo(); info.Create(inpack); list_item.Add(info); } }
public UPDATEGUANJUEDATA() { mparam = Define.UPDATEGUANJUEDATA; info = new GuanJueInfo(); }
//更新爵位信息 public void UpdateGuanJueInfo(GuanJueInfo info) { //先删-- 然后再排序 for (int i = 0; i < mListInfo.Count; i++) { if (mListInfo[i].id == info.id) { mListInfo.RemoveAt(i); break; } } bool bInsert = false; for (int i = 0; i < mListInfo.Count; i++) { if (info.guanjue > mListInfo[i].guanjue) { mListInfo.Insert(i, info); bInsert = true; break; } } if (!bInsert && mListInfo.Count < GameBase.Config.Define.MAX_JUEWEICOUNT) { mListInfo.Add(info); } }
public void SetValue(int play_id,String name, ulong guanjue) { // bool bFind = false; for (int i = 0; i < mList.Count; i++) { if (mList[i].id == play_id) { //mList[i].guanjue = guanjue; mList.RemoveAt(i); //bFind = true; break; } } GuanJueInfo info = new GuanJueInfo(); info.id = (uint)play_id; info.name = name; info.guanjue = guanjue; //插入-- bool bInsert = false; for (int i = 0; i < mList.Count; i++) { if (guanjue > mList[i].guanjue) { mList.Insert(i, info); bInsert = true; break; } } if (!bInsert && mList.Count < GameBase.Config.Define.MAX_JUEWEICOUNT) { mList.Add(info); } }