} //读取表格//得到所有角色列表
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);
}
