本文整理汇总了C#中Realm.SqlStats方法的典型用法代码示例。如果您正苦于以下问题：C# Realm.SqlStats方法的具体用法？C# Realm.SqlStats怎么用？C# Realm.SqlStats使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Realm的用法示例。
在下文中一共展示了Realm.SqlStats方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: CreateCharacter
public static void CreateCharacter(Realm.Characters.Character character)
{
lock (DatabaseHandler.ConnectionLocker)
{
var sqlText = "INSERT INTO dyn_characters VALUES(@id, @name, @level, @class, @sex, @color, @color2, @color3, @mapinfos, @stats, @items, @spells, @exp)";
var sqlCommand = new MySqlCommand(sqlText, DatabaseHandler.Connection);
var P = sqlCommand.Parameters;
P.Add(new MySqlParameter("@id", character.ID));
P.Add(new MySqlParameter("@name", character.Name));
P.Add(new MySqlParameter("@level", character.Level));
P.Add(new MySqlParameter("@class", character.Class));
P.Add(new MySqlParameter("@sex", character.Sex));
P.Add(new MySqlParameter("@color", character.Color));
P.Add(new MySqlParameter("@color2", character.Color2));
P.Add(new MySqlParameter("@color3", character.Color3));
P.Add(new MySqlParameter("@mapinfos", character.MapID + "," + character.MapCell + "," + character.Dir));
P.Add(new MySqlParameter("@stats", character.SqlStats()));
P.Add(new MySqlParameter("@items", ""));
P.Add(new MySqlParameter("@spells", ""));
P.Add(new MySqlParameter("@exp", 0));
sqlCommand.ExecuteNonQuery();
character.isNewCharacter = false;
}
}示例2: SaveCharacter
public static void SaveCharacter(Realm.Characters.Character character)
{
lock (DatabaseHandler.ConnectionLocker)
{
var sqlText = "UPDATE dyn_characters SET [email protected], [email protected], [email protected], [email protected], [email protected]," +
" [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected] WHERE [email protected]";
var sqlCommand = new MySqlCommand(sqlText, DatabaseHandler.Connection);
var P = sqlCommand.Parameters;
P.Add(new MySqlParameter("@id", character.ID));
P.Add(new MySqlParameter("@name", character.Name));
P.Add(new MySqlParameter("@level", character.Level));
P.Add(new MySqlParameter("@class", character.Class));
P.Add(new MySqlParameter("@sex", character.Sex));
P.Add(new MySqlParameter("@color", character.Color));
P.Add(new MySqlParameter("@color2", character.Color2));
P.Add(new MySqlParameter("@color3", character.Color3));
P.Add(new MySqlParameter("@mapinfos", character.MapID + "," + character.MapCell + "," + character.Dir));
P.Add(new MySqlParameter("@stats", character.SqlStats()));
P.Add(new MySqlParameter("@items", character.GetItemsToSave()));
P.Add(new MySqlParameter("@spells", character.SpellsInventary.SaveSpells()));
P.Add(new MySqlParameter("@exp", character.Exp));
sqlCommand.ExecuteNonQuery();
}
}