本文整理汇总了C#中IQueryAdapter.getRow方法的典型用法代码示例。如果您正苦于以下问题:C# IQueryAdapter.getRow方法的具体用法?C# IQueryAdapter.getRow怎么用?C# IQueryAdapter.getRow使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类IQueryAdapter
的用法示例。
在下文中一共展示了IQueryAdapter.getRow方法的8个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: LoadItem
internal static WiredLoaderObject LoadItem(RoomItem item, Room room, IQueryAdapter dbClient)
{
InteractionType type = item.GetBaseItem().InteractionType;
List<RoomItem> items = null;
if (NeedsFurnitures(type))
{
dbClient.setQuery("SELECT trigger_item FROM wired_to_item WHERE wired_id = " + item.Id);
DataTable dTable = dbClient.getTable();
RoomItem targetItem;
items = new List<RoomItem>(5);
foreach (DataRow dRows in dTable.Rows)
{
targetItem = room.GetRoomItemHandler().GetItem(Convert.ToUInt32(dRows[0]));
if (targetItem == null || items.Contains(targetItem))
{
continue;
}
items.Add(targetItem);
}
}
string[] settings = null;
if(HasSettings(type))
{
settings = new string[4];
dbClient.setQuery("SELECT data_one, data_two,data_three, data_four FROM wired_data WHERE wired_id = " + item.Id);
DataRow dRow = dbClient.getRow();
if (dRow != null)
{
for (int i = 0; i < 4; i++)
{
settings[i] = dRow[i].ToString();
}
}
else
{
settings = new string[] { "", "", "", "" };
}
}
Dictionary<uint, OriginalItemLocation> originalPositionList = null;
if (HasOriginalItemLocations(type))
{
originalPositionList = new Dictionary<uint, OriginalItemLocation>(5);
dbClient.setQuery("SELECT item_id, original_x, original_y, rotation, height, extradata FROM wired_original_item_locations WHERE wired_id = " + item.Id);
DataTable dTable = dbClient.getTable();
foreach (DataRow dRows in dTable.Rows)
{
originalPositionList.Add(uint.Parse(dRows[0].ToString()), new OriginalItemLocation(uint.Parse(dRows[0].ToString()), int.Parse(dRows[1].ToString()), int.Parse(dRows[2].ToString()), (double)Convert.ToDecimal(dRows[4]), int.Parse(dRows[3].ToString()), dRows[5].ToString()));
}
}
return new WiredLoaderObject(items, originalPositionList, settings);
}
示例2: LoadFromDatabase
public void LoadFromDatabase(IQueryAdapter dbClient, Room insideRoom)
{
dbClient.setQuery("SELECT trigger_data FROM trigger_item WHERE trigger_id = @id ");
dbClient.addParameter("id", (int)this.item.Id);
DataRow dRow = dbClient.getRow();
if (dRow != null)
this.requiredCycles = Convert.ToInt32(dRow[0].ToString());
else
this.requiredCycles = 20;
}
示例3: LoadFromDatabase
public void LoadFromDatabase(IQueryAdapter dbClient, Room insideRoom)
{
dbClient.setQuery("SELECT trigger_data FROM trigger_item WHERE trigger_id = @id ");
dbClient.addParameter("id", (int)this.item.Id);
DataRow dRow = dbClient.getRow();
if (dRow != null)
this.userName = dRow[0].ToString();
else
this.userName = string.Empty;
this.isOneUser = !string.IsNullOrEmpty(this.userName);
}
示例4: LoadFromDatabase
public void LoadFromDatabase(IQueryAdapter dbClient, Room insideRoom)
{
dbClient.setQuery("SELECT trigger_data, trigger_data_2 FROM trigger_item WHERE trigger_id = @id ");
dbClient.addParameter("id", (int)this.itemID);
DataRow dRow = dbClient.getRow();
if (dRow != null)
{
this.maxCountPerGame = Convert.ToInt32(dRow[0].ToString());
this.scoreToGive = Convert.ToInt32(dRow[1].ToString());
}
else
{
maxCountPerGame = 0;
scoreToGive = 0;
}
}
示例5: LoadFromDatabase
public void LoadFromDatabase(IQueryAdapter dbClient, Room insideRoom)
{
dbClient.setQuery("SELECT trigger_data, all_user_triggerable FROM trigger_item WHERE trigger_id = @id ");
dbClient.addParameter("id", (int)this.item.Id);
DataRow dRow = dbClient.getRow();
if (dRow != null)
{
this.triggerMessage = dRow[0].ToString();
this.isOwnerOnly = dRow[1].ToString() == "1";
}
else
{
this.triggerMessage = string.Empty;
this.isOwnerOnly = false;
}
}
示例6: LoadFromDatabase
public void LoadFromDatabase(IQueryAdapter dbClient, Room insideRoom)
{
dbClient.setQuery("SELECT trigger_data FROM trigger_item WHERE trigger_id = @id ");
dbClient.addParameter("id", (int)this.item.Id);
DataRow dRow = dbClient.getRow();
if (dRow != null)
this.requiredCycles = Convert.ToInt32(dRow[0].ToString());
else
this.requiredCycles = 0;
dbClient.setQuery("SELECT triggers_item FROM trigger_in_place WHERE original_trigger = " + this.item.Id);
DataTable dTable = dbClient.getTable();
RoomItem targetItem;
foreach (DataRow dRows in dTable.Rows)
{
targetItem = insideRoom.GetRoomItemHandler().GetItem(Convert.ToUInt32(dRows[0]));
if (targetItem == null || this.items.Contains(targetItem))
continue;
targetItem.OnUserWalksOnFurni += targetItem_OnUserWalksOnFurni;
this.items.Add(targetItem);
}
}
示例7: LoadFromDatabase
public void LoadFromDatabase(IQueryAdapter dbClient, Room insideRoom)
{
dbClient.setQuery("SELECT trigger_data FROM trigger_item WHERE trigger_id = @id ");
dbClient.addParameter("id", (int)this.itemID);
this.delay = dbClient.getInteger();
dbClient.setQuery("SELECT rotation_status, movement_status FROM trigger_rotation WHERE item_id = @id");
dbClient.addParameter("id", (int)this.itemID);
DataRow dRow = dbClient.getRow();
if (dRow != null)
{
this.rotation = (RotationState)Convert.ToInt32(dRow[0]);
this.movement = (MovementState)Convert.ToInt32(dRow[1]);
}
else
{
rotation = RotationState.none;
movement = MovementState.none;
}
dbClient.setQuery("SELECT triggers_item FROM trigger_in_place WHERE original_trigger = " + this.itemID);
DataTable dTable = dbClient.getTable();
RoomItem targetItem;
foreach (DataRow dRows in dTable.Rows)
{
targetItem = insideRoom.GetRoomItemHandler().GetItem(Convert.ToUInt32(dRows[0]));
if (targetItem == null || this.items.Contains(targetItem))
{
continue;
}
this.items.Add(targetItem);
}
}
示例8: LoadFromDatabase
public void LoadFromDatabase(IQueryAdapter dbClient, Room insideRoom)
{
dbClient.setQuery("SELECT trigger_data FROM trigger_item WHERE trigger_id = @id ");
dbClient.addParameter("id", (int)this.itemID);
DataRow dRow = dbClient.getRow();
if (dRow != null)
{
this.delay = Convert.ToInt32(dRow[0].ToString());
}
else
{
delay = 20;
}
dbClient.setQuery("SELECT triggers_item,extradata FROM trigger_in_place WHERE original_trigger = " + this.itemID);
DataTable dTable = dbClient.getTable();
if (dTable == null)
return;
//RoomItem targetItem;
foreach (DataRow dRows in dTable.Rows)
{
/*targetItem = insideRoom.GetRoomItemHandler().GetItem(Convert.ToUInt32(dRows[0]));
if (targetItem == null || this.items.Contains(targetItem))
continue;
string[] Op = dRows[1].ToString().Split(';');
if (Op[0].Split('-')[0].ToString() == "1")
{
MatchState = 1;
State.Add(targetItem, Op[0].Split('-')[1].ToString());
}
if (Op[1].Split('-')[0].ToString() == "1")
{
MatchRot = 1;
Rot.Add(targetItem, int.Parse(Op[1].Split('-')[1]));
}
if (Op[2].Split('-')[0].ToString() == "1")
{
MatchPos = 1;
Pos.Add(targetItem, new Point(int.Parse(Op[2].Split('-')[1].Split(',')[0]), int.Parse(Op[2].Split('-')[1].Split(',')[1])));
}
this.items.Add(targetItem);*/
}
}