本文整理汇总了C#中IQueryAdapter.AddParameter方法的典型用法代码示例。如果您正苦于以下问题:C# IQueryAdapter.AddParameter方法的具体用法?C# IQueryAdapter.AddParameter怎么用?C# IQueryAdapter.AddParameter使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类IQueryAdapter
的用法示例。
在下文中一共展示了IQueryAdapter.AddParameter方法的3个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: SaveMessage
/// <summary>
/// Saves the message.
/// </summary>
/// <param name="dbClient">The database client.</param>
/// <param name="toId">To identifier.</param>
/// <param name="fromId">From identifier.</param>
/// <param name="message">The message.</param>
internal static void SaveMessage(IQueryAdapter dbClient, uint toId, uint fromId, string message)
{
dbClient.SetQuery(
"INSERT INTO messenger_offline_messages (to_id, from_id, Message, timestamp) VALUES (@tid, @fid, @msg, UNIX_TIMESTAMP())");
dbClient.AddParameter("tid", toId);
dbClient.AddParameter("fid", fromId);
dbClient.AddParameter("msg", message);
dbClient.RunQuery();
}
示例2: Execute
/// <summary>
/// Executes the specified database client.
/// </summary>
/// <param name="dbClient">The database client.</param>
internal void Execute(IQueryAdapter dbClient)
{
if (_queryCount == 0)
return;
_queries = _queries.Remove(_queries.Length - 1, 1);
dbClient.SetQuery(_queries.ToString());
foreach (KeyValuePair<string, object> current in _parameters)
dbClient.AddParameter(current.Key, current.Value);
dbClient.RunQuery();
}
示例3: SaveFurniture
/// <summary>
/// Saves the furniture.
/// </summary>
/// <param name="dbClient">The database client.</param>
/// <param name="session">The session.</param>
public void SaveFurniture(IQueryAdapter dbClient, GameClient session = null)
{
try
{
if (!_updatedItems.Any() && !_removedItems.Any() && _room.GetRoomUserManager().PetCount <= 0)
return;
foreach (uint itemId in _removedItems)
dbClient.RunFastQuery($"UPDATE items_rooms SET room_id='0', x='0', y='0', z='0', rot='0' WHERE id = {itemId}");
foreach (RoomItem roomItem in _updatedItems.Select(GetItem).Where(roomItem => roomItem != null))
{
if (roomItem.GetBaseItem() != null && roomItem.GetBaseItem().IsGroupItem)
{
try
{
string[] gD = roomItem.GroupData.Split(';');
roomItem.ExtraData = roomItem.ExtraData + ";" + gD[1] + ";" + gD[2] + ";" + gD[3];
}
catch
{
roomItem.ExtraData = string.Empty;
}
}
if (roomItem.RoomId == 0)
continue;
if (roomItem.GetBaseItem().Name.Contains("wallpaper_single") ||
roomItem.GetBaseItem().Name.Contains("floor_single") ||
roomItem.GetBaseItem().Name.Contains("landscape_single"))
{
dbClient.RunFastQuery($"DELETE FROM items_rooms WHERE id = {roomItem.Id} LIMIT 1");
continue;
}
if (roomItem.IsFloorItem)
{
dbClient.SetQuery(
$"UPDATE items_rooms SET room_id={roomItem.RoomId}, [email protected], x={roomItem.X}, y={roomItem.Y}, z='{roomItem.Z.ToString(CultureInfo.InvariantCulture).Replace(',', '.')}', rot={roomItem.Rot} WHERE id={roomItem.Id}");
dbClient.AddParameter("extraData",
!string.IsNullOrEmpty(roomItem.ExtraData) ? roomItem.ExtraData : string.Empty);
dbClient.RunQuery();
}
else
{
dbClient.SetQuery(
$"UPDATE items_rooms SET room_id={roomItem.RoomId}, [email protected], [email protected] WHERE id={roomItem.Id}");
dbClient.AddParameter("extraData",
!string.IsNullOrEmpty(roomItem.ExtraData) ? roomItem.ExtraData : string.Empty);
dbClient.AddParameter("wallPos", roomItem.WallCoord);
dbClient.RunQuery();
}
}
_room.GetRoomUserManager().AppendPetsUpdateString(dbClient);
session?.GetHabbo().GetInventoryComponent().RunDbUpdate();
_updatedItems.Clear();
_removedItems.Clear();
}
catch (Exception ex)
{
ServerLogManager.LogCriticalException("Error during saving furniture for room " + _room.RoomId +
". Stack: " + ex);
}
}