C# NetGore.GetParameterName方法代码示例

/// <summary>
/// Copies the column values into the given DbParameterValues using the database column name
/// with a prefixed @ as the key. The key must already exist in the DbParameterValues
/// for the value to be copied over. If any of the keys in the DbParameterValues do not
/// match one of the column names, or if there is no field for a key, then it will be
/// ignored. Because of this, it is important to be careful when using this method
/// since columns or keys can be skipped without any indication.
/// </summary>
/// <param name="source">The object to copy the values from.</param>
/// <param name="paramValues">The DbParameterValues to copy the values into.</param>
public static void TryCopyValues(this IAccountIpsTable source, NetGore.Db.DbParameterValues paramValues)
{
for (int i = 0; i < paramValues.Count; i++)
{
switch (paramValues.GetParameterName(i))
{
case "account_id":
paramValues[i] = (System.Int32)source.AccountID;
break;


case "id":
paramValues[i] = (System.UInt32)source.ID;
break;


case "ip":
paramValues[i] = (System.UInt32)source.Ip;
break;


case "time":
paramValues[i] = (System.DateTime)source.Time;
break;


}

}
}

/// <summary>
/// Copies the column values into the given DbParameterValues using the database column name
/// with a prefixed @ as the key. The key must already exist in the DbParameterValues
/// for the value to be copied over. If any of the keys in the DbParameterValues do not
/// match one of the column names, or if there is no field for a key, then it will be
/// ignored. Because of this, it is important to be careful when using this method
/// since columns or keys can be skipped without any indication.
/// </summary>
/// <param name="source">The object to copy the values from.</param>
/// <param name="paramValues">The DbParameterValues to copy the values into.</param>
public static void TryCopyValues(this IGuildMemberTable source, NetGore.Db.DbParameterValues paramValues)
{
for (int i = 0; i < paramValues.Count; i++)
{
switch (paramValues.GetParameterName(i))
{
case "character_id":
paramValues[i] = (System.Int32)source.CharacterID;
break;


case "guild_id":
paramValues[i] = (System.UInt16)source.GuildID;
break;


case "joined":
paramValues[i] = (System.DateTime)source.Joined;
break;


case "rank":
paramValues[i] = (System.Byte)source.Rank;
break;


}

}
}

/// <summary>
/// Copies the column values into the given DbParameterValues using the database column name
/// with a prefixed @ as the key. The key must already exist in the DbParameterValues
/// for the value to be copied over. If any of the keys in the DbParameterValues do not
/// match one of the column names, or if there is no field for a key, then it will be
/// ignored. Because of this, it is important to be careful when using this method
/// since columns or keys can be skipped without any indication.
/// </summary>
/// <param name="source">The object to copy the values from.</param>
/// <param name="paramValues">The DbParameterValues to copy the values into.</param>
public static void TryCopyValues(this ICharacterStatusEffectTable source, NetGore.Db.DbParameterValues paramValues)
{
for (int i = 0; i < paramValues.Count; i++)
{
switch (paramValues.GetParameterName(i))
{
case "character_id":
paramValues[i] = (System.Int32)source.CharacterID;
break;


case "id":
paramValues[i] = (System.Int32)source.ID;
break;


case "power":
paramValues[i] = (System.UInt16)source.Power;
break;


case "status_effect_id":
paramValues[i] = (System.Byte)source.StatusEffect;
break;


case "time_left_secs":
paramValues[i] = (System.UInt16)source.TimeLeftSecs;
break;


}

}
}

/// <summary>
/// Copies the column values into the given DbParameterValues using the database column name
/// with a prefixed @ as the key. The key must already exist in the DbParameterValues
/// for the value to be copied over. If any of the keys in the DbParameterValues do not
/// match one of the column names, or if there is no field for a key, then it will be
/// ignored. Because of this, it is important to be careful when using this method
/// since columns or keys can be skipped without any indication.
/// </summary>
/// <param name="source">The object to copy the values from.</param>
/// <param name="paramValues">The DbParameterValues to copy the values into.</param>
public static void TryCopyValues(this IAllianceHostileTable source, NetGore.Db.DbParameterValues paramValues)
{
for (int i = 0; i < paramValues.Count; i++)
{
switch (paramValues.GetParameterName(i))
{
case "alliance_id":
paramValues[i] = (System.Byte)source.AllianceID;
break;


case "hostile_id":
paramValues[i] = (System.Byte)source.HostileID;
break;


}

}
}

/// <summary>
/// Copies the column values into the given DbParameterValues using the database column name
/// with a prefixed @ as the key. The key must already exist in the DbParameterValues
/// for the value to be copied over. If any of the keys in the DbParameterValues do not
/// match one of the column names, or if there is no field for a key, then it will be
/// ignored. Because of this, it is important to be careful when using this method
/// since columns or keys can be skipped without any indication.
/// </summary>
/// <param name="source">The object to copy the values from.</param>
/// <param name="paramValues">The DbParameterValues to copy the values into.</param>
public static void TryCopyValues(this IItemTemplateTable source, NetGore.Db.DbParameterValues paramValues)
{
for (int i = 0; i < paramValues.Count; i++)
{
switch (paramValues.GetParameterName(i))
{
case "action_display_id":
paramValues[i] = (System.Nullable<System.UInt16>)source.ActionDisplayID;
break;


case "description":
paramValues[i] = (System.String)source.Description;
break;


case "equipped_body":
paramValues[i] = (System.String)source.EquippedBody;
break;


case "graphic":
paramValues[i] = (System.UInt16)source.Graphic;
break;


case "height":
paramValues[i] = (System.Byte)source.Height;
break;


case "hp":
paramValues[i] = (System.Int16)source.HP;
break;


case "id":
paramValues[i] = (System.UInt16)source.ID;
break;


case "mp":
paramValues[i] = (System.Int16)source.MP;
break;


case "name":
paramValues[i] = (System.String)source.Name;
break;


case "range":
paramValues[i] = (System.UInt16)source.Range;
break;


case "stat_agi":
paramValues[i] = (System.Int16)source.GetStat((DemoGame.StatType)DemoGame.StatType.Agi);
break;


case "stat_defence":
paramValues[i] = (System.Int16)source.GetStat((DemoGame.StatType)DemoGame.StatType.Defence);
break;


case "stat_int":
paramValues[i] = (System.Int16)source.GetStat((DemoGame.StatType)DemoGame.StatType.Int);
break;


case "stat_maxhit":
paramValues[i] = (System.Int16)source.GetStat((DemoGame.StatType)DemoGame.StatType.MaxHit);
break;


case "stat_maxhp":
paramValues[i] = (System.Int16)source.GetStat((DemoGame.StatType)DemoGame.StatType.MaxHP);
break;


case "stat_maxmp":
paramValues[i] = (System.Int16)source.GetStat((DemoGame.StatType)DemoGame.StatType.MaxMP);
break;


case "stat_minhit":
paramValues[i] = (System.Int16)source.GetStat((DemoGame.StatType)DemoGame.StatType.MinHit);
break;

//.........这里部分代码省略.........

/// <summary>
/// Copies the column values into the given DbParameterValues using the database column name
/// with a prefixed @ as the key. The key must already exist in the DbParameterValues
/// for the value to be copied over. If any of the keys in the DbParameterValues do not
/// match one of the column names, or if there is no field for a key, then it will be
/// ignored. Because of this, it is important to be careful when using this method
/// since columns or keys can be skipped without any indication.
/// </summary>
/// <param name="source">The object to copy the values from.</param>
/// <param name="paramValues">The DbParameterValues to copy the values into.</param>
public static void TryCopyValues(this IMapTable source, NetGore.Db.DbParameterValues paramValues)
{
for (int i = 0; i < paramValues.Count; i++)
{
switch (paramValues.GetParameterName(i))
{
case "id":
paramValues[i] = (System.UInt16)source.ID;
break;


case "name":
paramValues[i] = (System.String)source.Name;
break;


}

}
}

/// <summary>
/// Copies the column values into the given DbParameterValues using the database column name
/// with a prefixed @ as the key. The key must already exist in the DbParameterValues
/// for the value to be copied over. If any of the keys in the DbParameterValues do not
/// match one of the column names, or if there is no field for a key, then it will be
/// ignored. Because of this, it is important to be careful when using this method
/// since columns or keys can be skipped without any indication.
/// </summary>
/// <param name="source">The object to copy the values from.</param>
/// <param name="paramValues">The DbParameterValues to copy the values into.</param>
public static void TryCopyValues(this ICharacterTemplateInventoryTable source, NetGore.Db.DbParameterValues paramValues)
{
for (int i = 0; i < paramValues.Count; i++)
{
switch (paramValues.GetParameterName(i))
{
case "chance":
paramValues[i] = (System.UInt16)source.Chance;
break;


case "character_template_id":
paramValues[i] = (System.UInt16)source.CharacterTemplateID;
break;


case "id":
paramValues[i] = (System.Int32)source.ID;
break;


case "item_template_id":
paramValues[i] = (System.UInt16)source.ItemTemplateID;
break;


case "max":
paramValues[i] = (System.Byte)source.Max;
break;


case "min":
paramValues[i] = (System.Byte)source.Min;
break;


}

}
}

/// <summary>
/// Copies the column values into the given DbParameterValues using the database column name
/// with a prefixed @ as the key. The key must already exist in the DbParameterValues
/// for the value to be copied over. If any of the keys in the DbParameterValues do not
/// match one of the column names, or if there is no field for a key, then it will be
/// ignored. Because of this, it is important to be careful when using this method
/// since columns or keys can be skipped without any indication.
/// </summary>
/// <param name="source">The object to copy the values from.</param>
/// <param name="paramValues">The DbParameterValues to copy the values into.</param>
public static void TryCopyValues(this ICharacterQuestStatusTable source, NetGore.Db.DbParameterValues paramValues)
{
for (int i = 0; i < paramValues.Count; i++)
{
switch (paramValues.GetParameterName(i))
{
case "character_id":
paramValues[i] = (System.Int32)source.CharacterID;
break;


case "completed_on":
paramValues[i] = (System.Nullable<System.DateTime>)source.CompletedOn;
break;


case "quest_id":
paramValues[i] = (System.UInt16)source.QuestID;
break;


case "started_on":
paramValues[i] = (System.DateTime)source.StartedOn;
break;


}

}
}

/// <summary>
/// Copies the column values into the given DbParameterValues using the database column name
/// with a prefixed @ as the key. The key must already exist in the DbParameterValues
/// for the value to be copied over. If any of the keys in the DbParameterValues do not
/// match one of the column names, or if there is no field for a key, then it will be
/// ignored. Because of this, it is important to be careful when using this method
/// since columns or keys can be skipped without any indication.
/// </summary>
/// <param name="source">The object to copy the values from.</param>
/// <param name="paramValues">The DbParameterValues to copy the values into.</param>
public static void TryCopyValues(this IShopItemTable source, NetGore.Db.DbParameterValues paramValues)
{
for (int i = 0; i < paramValues.Count; i++)
{
switch (paramValues.GetParameterName(i))
{
case "item_template_id":
paramValues[i] = (System.UInt16)source.ItemTemplateID;
break;


case "shop_id":
paramValues[i] = (System.UInt16)source.ShopID;
break;


}

}
}

/// <summary>
/// Copies the column values into the given DbParameterValues using the database column name
/// with a prefixed @ as the key. The key must already exist in the DbParameterValues
/// for the value to be copied over. If any of the keys in the DbParameterValues do not
/// match one of the column names, or if there is no field for a key, then it will be
/// ignored. Because of this, it is important to be careful when using this method
/// since columns or keys can be skipped without any indication.
/// </summary>
/// <param name="source">The object to copy the values from.</param>
/// <param name="paramValues">The DbParameterValues to copy the values into.</param>
public static void TryCopyValues(this IEventCountersItemTemplateTable source, NetGore.Db.DbParameterValues paramValues)
{
for (int i = 0; i < paramValues.Count; i++)
{
switch (paramValues.GetParameterName(i))
{
case "counter":
paramValues[i] = (System.Int64)source.Counter;
break;


case "item_template_event_counter_id":
paramValues[i] = (System.Byte)source.ItemTemplateEventCounterId;
break;


case "item_template_id":
paramValues[i] = (System.UInt16)source.ItemTemplateID;
break;


}

}
}

/// <summary>
/// Copies the column values into the given DbParameterValues using the database column name
/// with a prefixed @ as the key. The key must already exist in the DbParameterValues
/// for the value to be copied over. If any of the keys in the DbParameterValues do not
/// match one of the column names, or if there is no field for a key, then it will be
/// ignored. Because of this, it is important to be careful when using this method
/// since columns or keys can be skipped without any indication.
/// </summary>
/// <param name="source">The object to copy the values from.</param>
/// <param name="paramValues">The DbParameterValues to copy the values into.</param>
public static void TryCopyValues(this ICharacterQuestStatusKillsTable source, NetGore.Db.DbParameterValues paramValues)
{
for (int i = 0; i < paramValues.Count; i++)
{
switch (paramValues.GetParameterName(i))
{
case "character_id":
paramValues[i] = (System.Int32)source.CharacterID;
break;


case "character_template_id":
paramValues[i] = (System.UInt16)source.CharacterTemplateID;
break;


case "count":
paramValues[i] = (System.UInt16)source.Count;
break;


case "quest_id":
paramValues[i] = (System.UInt16)source.QuestID;
break;


}

}
}

/// <summary>
/// Copies the column values into the given DbParameterValues using the database column name
/// with a prefixed @ as the key. The key must already exist in the DbParameterValues
/// for the value to be copied over. If any of the keys in the DbParameterValues do not
/// match one of the column names, or if there is no field for a key, then it will be
/// ignored. Because of this, it is important to be careful when using this method
/// since columns or keys can be skipped without any indication.
/// </summary>
/// <param name="source">The object to copy the values from.</param>
/// <param name="paramValues">The DbParameterValues to copy the values into.</param>
public static void TryCopyValues(this IQuestTable source, NetGore.Db.DbParameterValues paramValues)
{
for (int i = 0; i < paramValues.Count; i++)
{
switch (paramValues.GetParameterName(i))
{
case "id":
paramValues[i] = (System.UInt16)source.ID;
break;


case "repeatable":
paramValues[i] = (System.Boolean)source.Repeatable;
break;


case "reward_cash":
paramValues[i] = (System.Int32)source.RewardCash;
break;


case "reward_exp":
paramValues[i] = (System.Int32)source.RewardExp;
break;


}

}
}

/// <summary>
/// Copies the column values into the given DbParameterValues using the database column name
/// with a prefixed @ as the key. The key must already exist in the DbParameterValues
/// for the value to be copied over. If any of the keys in the DbParameterValues do not
/// match one of the column names, or if there is no field for a key, then it will be
/// ignored. Because of this, it is important to be careful when using this method
/// since columns or keys can be skipped without any indication.
/// </summary>
/// <param name="source">The object to copy the values from.</param>
/// <param name="paramValues">The DbParameterValues to copy the values into.</param>
public static void TryCopyValues(this IViewUserCharacterTable source, NetGore.Db.DbParameterValues paramValues)
{
for (int i = 0; i < paramValues.Count; i++)
{
switch (paramValues.GetParameterName(i))
{
case "ai_id":
paramValues[i] = (System.Nullable<System.UInt16>)source.AIID;
break;


case "body_id":
paramValues[i] = (System.UInt16)source.BodyID;
break;


case "cash":
paramValues[i] = (System.Int32)source.Cash;
break;


case "character_template_id":
paramValues[i] = (System.Nullable<System.UInt16>)source.CharacterTemplateID;
break;


case "chat_dialog":
paramValues[i] = (System.Nullable<System.UInt16>)source.ChatDialog;
break;


case "exp":
paramValues[i] = (System.Int32)source.Exp;
break;


case "hp":
paramValues[i] = (System.Int16)source.HP;
break;


case "id":
paramValues[i] = (System.Int32)source.ID;
break;


case "level":
paramValues[i] = (System.Int16)source.Level;
break;


case "load_map_id":
paramValues[i] = (System.UInt16)source.LoadMapID;
break;


case "load_x":
paramValues[i] = (System.UInt16)source.LoadX;
break;


case "load_y":
paramValues[i] = (System.UInt16)source.LoadY;
break;


case "move_speed":
paramValues[i] = (System.UInt16)source.MoveSpeed;
break;


case "mp":
paramValues[i] = (System.Int16)source.MP;
break;


case "name":
paramValues[i] = (System.String)source.Name;
break;


case "respawn_map_id":
paramValues[i] = (System.Nullable<System.UInt16>)source.RespawnMapID;
break;


case "respawn_x":
paramValues[i] = (System.Single)source.RespawnX;
break;

//.........这里部分代码省略.........

/// <summary>
/// Copies the column values into the given DbParameterValues using the database column name
/// with a prefixed @ as the key. The key must already exist in the DbParameterValues
/// for the value to be copied over. If any of the keys in the DbParameterValues do not
/// match one of the column names, or if there is no field for a key, then it will be
/// ignored. Because of this, it is important to be careful when using this method
/// since columns or keys can be skipped without any indication.
/// </summary>
/// <param name="source">The object to copy the values from.</param>
/// <param name="paramValues">The DbParameterValues to copy the values into.</param>
public static void TryCopyValues(this IAccountTable source, NetGore.Db.DbParameterValues paramValues)
{
for (int i = 0; i < paramValues.Count; i++)
{
switch (paramValues.GetParameterName(i))
{
case "creator_ip":
paramValues[i] = (System.UInt32)source.CreatorIp;
break;


case "current_ip":
paramValues[i] = (System.Nullable<System.UInt32>)source.CurrentIp;
break;


case "email":
paramValues[i] = (System.String)source.Email;
break;


case "friends":
paramValues[i] = (System.String)source.Friends;
break;


case "id":
paramValues[i] = (System.Int32)source.ID;
break;


case "name":
paramValues[i] = (System.String)source.Name;
break;


case "password":
paramValues[i] = (System.String)source.Password;
break;


case "permissions":
paramValues[i] = (System.Byte)source.Permissions;
break;


case "time_created":
paramValues[i] = (System.DateTime)source.TimeCreated;
break;


case "time_last_login":
paramValues[i] = (System.DateTime)source.TimeLastLogin;
break;


}

}
}

/// <summary>
/// Copies the column values into the given DbParameterValues using the database column name
/// with a prefixed @ as the key. The key must already exist in the DbParameterValues
/// for the value to be copied over. If any of the keys in the DbParameterValues do not
/// match one of the column names, or if there is no field for a key, then it will be
/// ignored. Because of this, it is important to be careful when using this method
/// since columns or keys can be skipped without any indication.
/// </summary>
/// <param name="source">The object to copy the values from.</param>
/// <param name="paramValues">The DbParameterValues to copy the values into.</param>
public static void TryCopyValues(this ICharacterTemplateSkillTable source, NetGore.Db.DbParameterValues paramValues)
{
for (int i = 0; i < paramValues.Count; i++)
{
switch (paramValues.GetParameterName(i))
{
case "character_template_id":
paramValues[i] = (System.UInt16)source.CharacterTemplateID;
break;


case "skill_id":
paramValues[i] = (System.Byte)source.SkillID;
break;


}

}
}