} //读取表格//得到所有角色列表 internal List <TmSoulerDB> GetTmSoulerDBsList() { MySqlCommand mySqlCommand = new MySqlCommand("select * from " + DatabaseFormName, TmMysqlConnection.Connection);//读取数据函数 MySqlDataReader reader = mySqlCommand.ExecuteReader(); try { List <TmSoulerDB> itemDBs = new List <TmSoulerDB>(); while (reader.Read()) { if (reader.HasRows) { TmSoulerDB item = new TmSoulerDB(); item.Id = reader.GetInt32(0); item.Name = reader.GetString(1); item.UserId = reader.GetInt32(2); item.SoulerId = reader.GetInt32(3); item.Exp = reader.GetInt32(4); item.Level = reader.GetInt32(5); item.Coin = reader.GetInt32(6); item.Diamond = reader.GetInt32(7); item.Hp = reader.GetInt32(8); item.Mp = reader.GetInt32(9); item.State = reader.GetInt32(10); item.CdTime = reader.GetDouble(11); item.ServerId = reader.GetInt32(12); item.SenceId = reader.GetInt32(13); item.px = reader.GetDouble(14); item.py = reader.GetDouble(15); item.pz = reader.GetDouble(16); item.ax = reader.GetDouble(17); item.ay = reader.GetDouble(18); item.az = reader.GetDouble(19); item.CreateDate = reader.GetString(20); itemDBs.Add(item); } } return(itemDBs); } catch (Exception) { Console.WriteLine("查询失败...168"); return(null); } finally { reader.Close(); } } //读取表格//得到所有角色列表
Dictionary <int, TmSoulerDB> GetEngineersByMyself(TmSoulerDB soulerDB, Dictionary <int, TmSoulerDB> soulerDBs) { Dictionary <int, TmSoulerDB> dbs = new Dictionary <int, TmSoulerDB>(); List <TmSoulerDB> list = new List <TmSoulerDB>(soulerDBs.Values); for (int i = 0; i < list.Count; i++) { double xx = Math.Abs(soulerDB.px - list[i].px); double zz = Math.Abs(soulerDB.pz - list[i].pz); if (xx < 100 && zz < 100) { dbs.Add(list[i].Id, list[i]); } } dbs.Remove(soulerDB.Id); return(dbs); }
void GetdbofEngineerLogin(object sender, TmParameter parameter) { int rolerId = TmParameterTool.GetJsonValue <int>(parameter, ElevenCode.EngineerLogin.ToString()); Console.WriteLine(TmTimerTool.CurrentTime() + " TmEngineerMysql,rolerId:" + rolerId); TmSoulerDB db = GetTmSoulerdbById(rolerId); Console.WriteLine(TmTimerTool.CurrentTime() + " db:" + db.Name); if (db != null) { (sender as TmEngineerHandler).Engineers.Add(rolerId, db); } else { Console.WriteLine(TmTimerTool.CurrentTime() + " 没有角色"); } }
void GetRoler(TmParameter tmp) { Engineer = TmParameterTool.GetJsonValue <TmSoulerDB>(tmp, tmp.ElevenCode.ToString()); Console.WriteLine(TmTimerTool.CurrentTime() + " engineer: " + Engineer.Name); }