本文整理汇总了C#中IQueryAdapter.runQuery方法的典型用法代码示例。如果您正苦于以下问题:C# IQueryAdapter.runQuery方法的具体用法?C# IQueryAdapter.runQuery怎么用?C# IQueryAdapter.runQuery使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类IQueryAdapter
的用法示例。
在下文中一共展示了IQueryAdapter.runQuery方法的11个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: UpdateInDatabase
public static void UpdateInDatabase(IWiredTrigger wiredItem, IQueryAdapter dbClient)
{
RemoveFromDatabase(wiredItem, dbClient);
RoomItem item = wiredItem.GetOriginalWiredItem();
InteractionType type = item.GetBaseItem().InteractionType;
if (WiredLoaderObject.HasSettings(type))
{
string[] data = (wiredItem as IWiredSettingsTrigger).GetSettings();
dbClient.setQuery("INSERT INTO `wired_data` (`wired_id`, `data_one`, `data_two`, `data_three`, `data_four`) VALUES (@id, @data1, @data2, @data3, @data4) ");
dbClient.addParameter("id", item.Id);
dbClient.addParameter("data1", data.Length >= 1 ? data[0] : "");
dbClient.addParameter("data2", data.Length >= 2 ? data[1] : "");
dbClient.addParameter("data3", data.Length >= 3 ? data[2] : "");
dbClient.addParameter("data4", data.Length >= 4 ? data[3] : "");
dbClient.runQuery();
}
if (WiredLoaderObject.HasOriginalItemLocations(type))
{
Dictionary<uint, OriginalItemLocation> originalLoc = (wiredItem as IWiredOriginalItemTrigger).GetOriginalItemLocation();
foreach (OriginalItemLocation itemLoc in originalLoc.Values)
{
dbClient.setQuery("INSERT INTO `wired_original_item_locations` (`wired_id`,`item_id`, `original_x`, `original_y`, `rotation`, `extradata`, `height`) VALUES (@wid, @id, @orx, @ory, @orrot, @data, @height)");
dbClient.addParameter("wid", item.Id);
dbClient.addParameter("id", itemLoc.itemID);
dbClient.addParameter("orx", itemLoc.X);
dbClient.addParameter("ory", itemLoc.Y);
dbClient.addParameter("orrot", itemLoc.Rot);
dbClient.addParameter("data", itemLoc.ExtraData);
dbClient.addParameter("height", itemLoc.Height);
dbClient.runQuery();
}
}
if (WiredLoaderObject.NeedsFurnitures(type))
{
List<RoomItem> items = (wiredItem as IWiredFurniTrigger).getAffectedItemList();
foreach (RoomItem rItem in items)
{
dbClient.setQuery("INSERT INTO `wired_to_item` (`wired_id`, `trigger_item`) VALUES (@id, @triggeritem)");
dbClient.addParameter("id", item.Id);
dbClient.addParameter("triggeritem", rItem.Id);
dbClient.runQuery();
}
}
}
示例2: SaveTrigger
internal static void SaveTrigger(IQueryAdapter dbClient, int itemID, int triggetItemID)
{
dbClient.setQuery("INSERT INTO trigger_in_place (original_trigger,triggers_item) VALUES (@my_id,@trigger_item)");
dbClient.addParameter("my_id", itemID);
dbClient.addParameter("trigger_item", triggetItemID);
dbClient.runQuery();
}
示例3: SaveMessage
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();
}
示例4: SaveToDatabase
public void SaveToDatabase(IQueryAdapter dbClient)
{
dbClient.setQuery("REPLACE INTO trigger_item SET trigger_id = @id, trigger_input = 'integer', trigger_data = @trigger_data , all_user_triggerable = 0");
dbClient.addParameter("id", (int)this.item.Id);
dbClient.addParameter("trigger_data", timeout);
dbClient.runQuery();
}
示例5: SaveTriggerItem
internal static void SaveTriggerItem(IQueryAdapter dbClient, int triggerID, string triggerInput, string triggerData2, string triggerData, bool allUsertriggerable)
{
dbClient.runFastQuery("DELETE FROM trigger_item WHERE trigger_id = " + triggerID);
dbClient.setQuery("INSERT INTO trigger_item (trigger_id,trigger_input,trigger_data,trigger_data_2,all_user_triggerable) VALUES (@id,@triggerinput,@trigger_data,@trigger_data_2,@triggerable)");
dbClient.addParameter("id", triggerID);
dbClient.addParameter("triggerinput", triggerInput);
dbClient.addParameter("trigger_data", triggerData);
dbClient.addParameter("trigger_data_2", triggerData2);
dbClient.addParameter("triggerable", allUsertriggerable ? 1 : 0);
dbClient.runQuery();
}
示例6: Execute
internal void Execute(IQueryAdapter dbClient)
{
if (this.queryCount == 0)
{
return;
}
this.queries = this.queries.Remove(checked(this.queries.Length - 1), 1);
dbClient.setQuery(this.queries.ToString());
foreach (KeyValuePair<string, object> current in this.parameters)
{
dbClient.addParameter(current.Key, current.Value);
}
dbClient.runQuery();
}
示例7: RemoveFromDatabase
public static void RemoveFromDatabase(IWiredTrigger wiredItem, IQueryAdapter dbClient)
{
RoomItem item = wiredItem.GetOriginalWiredItem();
InteractionType type = item.GetBaseItem().InteractionType;
if(WiredLoaderObject.HasSettings(type))
{
dbClient.setQuery("DELETE FROM wired_data WHERE wired_id = @id");
dbClient.addParameter("id", item.Id);
dbClient.runQuery();
}
if (WiredLoaderObject.HasOriginalItemLocations(type))
{
dbClient.setQuery("DELETE FROM wired_original_item_locations WHERE wired_id = @id");
dbClient.addParameter("id", item.Id);
dbClient.runQuery();
}
if (WiredLoaderObject.NeedsFurnitures(type))
{
dbClient.setQuery("DELETE FROM wired_to_item WHERE wired_id = @id");
dbClient.addParameter("id", item.Id);
dbClient.runQuery();
}
}
示例8: Execute
internal void Execute(IQueryAdapter dbClient)
{
if (queryCount == 0)
return;
queries = queries.Remove(queries.Length - 1, 1);
dbClient.setQuery(queries.ToString());
foreach (KeyValuePair<string, object> parameter in parameters)
{
dbClient.addParameter(parameter.Key, parameter.Value);
}
dbClient.runQuery();
}
示例9: SaveToDatabase
public void SaveToDatabase(IQueryAdapter dbClient)
{
WiredUtillity.SaveTriggerItem(dbClient, (int)itemID, "integer", string.Empty, delay.ToString(), false);
if (dbClient.dbType == Database_Manager.Database.DatabaseType.MSSQL)
{
dbClient.runFastQuery("DELETE FROM trigger_rotation WHERE item_id = " + itemID);
dbClient.setQuery("INSERT INTO trigger_rotation(item_id,rotation_status,movement_status) VALUES (@id,@rot_id,@mov_id)");
}
else
dbClient.setQuery("REPLACE INTO trigger_rotation SET item_id = @id, rotation_status = @rot_id, movement_status = @mov_id");
dbClient.addParameter("id", (int)itemID);
dbClient.addParameter("rot_id", (int)this.rotation);
dbClient.addParameter("mov_id", (int)this.movement);
dbClient.runQuery();
lock (items)
{
dbClient.runFastQuery("DELETE FROM trigger_in_place WHERE original_trigger = '" + this.itemID + "'");
foreach (RoomItem i in items)
{
WiredUtillity.SaveTrigger(dbClient, (int)itemID, (int)i.Id);
}
}
}
示例10: SaveToDatabase
public void SaveToDatabase(IQueryAdapter dbClient)
{
if (dbClient.dbType == Pici.Storage.Database.DatabaseType.MSSQL)
{
dbClient.runFastQuery("DELETE FROM trigger_item WHERE trigger_id = " + item.Id);
dbClient.setQuery("REPLACE INTO trigger_item SET trigger_id = @id, trigger_input = 'integer', trigger_data = @trigger_data , all_user_triggerable = 0");
}
else
dbClient.setQuery("REPLACE INTO trigger_item SET trigger_id = @id, trigger_input = 'integer', trigger_data = @trigger_data , all_user_triggerable = 0");
dbClient.addParameter("id", (int)this.item.Id);
dbClient.addParameter("trigger_data", timeout);
dbClient.runQuery();
}
示例11: SaveToDatabase
public void SaveToDatabase(IQueryAdapter dbClient)
{
WiredUtillity.SaveTriggerItem(dbClient, (int)itemID, "integer", string.Empty, "0", false);
lock (items)
{
dbClient.runFastQuery("DELETE FROM trigger_in_place WHERE original_trigger = '" + this.itemID + "'");
State.Clear();
Pos.Clear();
Rot.Clear();
foreach (RoomItem i in items)
{
if (i != null)
{
if (WiredUtillity.TypeIsWired(i.GetBaseItem().InteractionType))
MatchState = 0;
dbClient.setQuery("INSERT INTO trigger_in_place (original_trigger,triggers_item, extradata) VALUES (@my_id,@trigger_item,@extra)");
dbClient.addParameter("my_id", itemID);
dbClient.addParameter("trigger_item", i.Id);
dbClient.addParameter("extra", MatchState + "-" + i.ExtraData + ";" + MatchRot + "-" + i.Rot + ";" + MatchPos + "-" + i.GetX + "," + i.GetY);
dbClient.runQuery();
if (MatchPos == 1)
{
Pos.Add(i, new Point(i.GetX, i.GetY));
}
if (MatchRot == 1)
{
Rot.Add(i, i.Rot);
}
if (MatchState == 1)
{
State.Add(i, i.ExtraData);
}
}
}
}
}