C# NetGore类代码示例

/// <summary>
/// Copies the column values into the given DbParameterValues using the database column name
/// with a prefixed @ as the key. The keys must already exist in the DbParameterValues;
///  this method will not create them if they are missing.
/// </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 CopyValues(this IGuildMemberTable source, NetGore.Db.DbParameterValues paramValues)
{
paramValues["character_id"] = (System.Int32)source.CharacterID;
paramValues["guild_id"] = (System.UInt16)source.GuildID;
paramValues["joined"] = (System.DateTime)source.Joined;
paramValues["rank"] = (System.Byte)source.Rank;
}

/// <summary>
/// Copies the column values into the given DbParameterValues using the database column name
/// with a prefixed @ as the key. The keys must already exist in the DbParameterValues;
///  this method will not create them if they are missing.
/// </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 CopyValues(this ICharacterTemplateEquippedTable source, NetGore.Db.DbParameterValues paramValues)
{
paramValues["chance"] = (System.UInt16)source.Chance;
paramValues["character_template_id"] = (System.UInt16)source.CharacterTemplateID;
paramValues["id"] = (System.Int32)source.ID;
paramValues["item_template_id"] = (System.UInt16)source.ItemTemplateID;
}

/// <summary>
/// Copies the column values into the given DbParameterValues using the database column name
/// with a prefixed @ as the key. The keys must already exist in the DbParameterValues;
///  this method will not create them if they are missing.
/// </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 CopyValues(this ICharacterQuestStatusKillsTable source, NetGore.Db.DbParameterValues paramValues)
{
paramValues["character_id"] = (System.Int32)source.CharacterID;
paramValues["character_template_id"] = (System.UInt16)source.CharacterTemplateID;
paramValues["count"] = (System.UInt16)source.Count;
paramValues["quest_id"] = (System.UInt16)source.QuestID;
}

/// <summary>
/// Copies the column values into the given DbParameterValues using the database column name
/// with a prefixed @ as the key. The keys must already exist in the DbParameterValues;
///  this method will not create them if they are missing.
/// </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 CopyValues(this IItemTemplateTable source, NetGore.Db.DbParameterValues paramValues)
{
paramValues["action_display_id"] = (System.Nullable<System.UInt16>)source.ActionDisplayID;
paramValues["description"] = (System.String)source.Description;
paramValues["equipped_body"] = (System.String)source.EquippedBody;
paramValues["graphic"] = (System.UInt16)source.Graphic;
paramValues["height"] = (System.Byte)source.Height;
paramValues["hp"] = (System.Int16)source.HP;
paramValues["id"] = (System.UInt16)source.ID;
paramValues["mp"] = (System.Int16)source.MP;
paramValues["name"] = (System.String)source.Name;
paramValues["range"] = (System.UInt16)source.Range;
paramValues["stat_agi"] = (System.Int16)source.GetStat((DemoGame.StatType)DemoGame.StatType.Agi);
paramValues["stat_defence"] = (System.Int16)source.GetStat((DemoGame.StatType)DemoGame.StatType.Defence);
paramValues["stat_int"] = (System.Int16)source.GetStat((DemoGame.StatType)DemoGame.StatType.Int);
paramValues["stat_maxhit"] = (System.Int16)source.GetStat((DemoGame.StatType)DemoGame.StatType.MaxHit);
paramValues["stat_maxhp"] = (System.Int16)source.GetStat((DemoGame.StatType)DemoGame.StatType.MaxHP);
paramValues["stat_maxmp"] = (System.Int16)source.GetStat((DemoGame.StatType)DemoGame.StatType.MaxMP);
paramValues["stat_minhit"] = (System.Int16)source.GetStat((DemoGame.StatType)DemoGame.StatType.MinHit);
paramValues["stat_req_agi"] = (System.Int16)source.GetReqStat((DemoGame.StatType)DemoGame.StatType.Agi);
paramValues["stat_req_int"] = (System.Int16)source.GetReqStat((DemoGame.StatType)DemoGame.StatType.Int);
paramValues["stat_req_str"] = (System.Int16)source.GetReqStat((DemoGame.StatType)DemoGame.StatType.Str);
paramValues["stat_str"] = (System.Int16)source.GetStat((DemoGame.StatType)DemoGame.StatType.Str);
paramValues["type"] = (System.Byte)source.Type;
paramValues["value"] = (System.Int32)source.Value;
paramValues["weapon_type"] = (System.Byte)source.WeaponType;
paramValues["width"] = (System.Byte)source.Width;
}

/// <summary>
/// Copies the column values into the given DbParameterValues using the database column name
/// with a prefixed @ as the key. The keys must already exist in the DbParameterValues;
///  this method will not create them if they are missing.
/// </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 CopyValues(this IViewUserCharacterTable source, NetGore.Db.DbParameterValues paramValues)
{
paramValues["ai_id"] = (System.Nullable<System.UInt16>)source.AIID;
paramValues["body_id"] = (System.UInt16)source.BodyID;
paramValues["cash"] = (System.Int32)source.Cash;
paramValues["character_template_id"] = (System.Nullable<System.UInt16>)source.CharacterTemplateID;
paramValues["chat_dialog"] = (System.Nullable<System.UInt16>)source.ChatDialog;
paramValues["exp"] = (System.Int32)source.Exp;
paramValues["hp"] = (System.Int16)source.HP;
paramValues["id"] = (System.Int32)source.ID;
paramValues["level"] = (System.Int16)source.Level;
paramValues["load_map_id"] = (System.UInt16)source.LoadMapID;
paramValues["load_x"] = (System.UInt16)source.LoadX;
paramValues["load_y"] = (System.UInt16)source.LoadY;
paramValues["move_speed"] = (System.UInt16)source.MoveSpeed;
paramValues["mp"] = (System.Int16)source.MP;
paramValues["name"] = (System.String)source.Name;
paramValues["respawn_map_id"] = (System.Nullable<System.UInt16>)source.RespawnMapID;
paramValues["respawn_x"] = (System.Single)source.RespawnX;
paramValues["respawn_y"] = (System.Single)source.RespawnY;
paramValues["shop_id"] = (System.Nullable<System.UInt16>)source.ShopID;
paramValues["statpoints"] = (System.Int32)source.StatPoints;
paramValues["stat_agi"] = (System.Int16)source.StatAgi;
paramValues["stat_defence"] = (System.Int16)source.StatDefence;
paramValues["stat_int"] = (System.Int16)source.StatInt;
paramValues["stat_maxhit"] = (System.Int16)source.StatMaxhit;
paramValues["stat_maxhp"] = (System.Int16)source.StatMaxhp;
paramValues["stat_maxmp"] = (System.Int16)source.StatMaxmp;
paramValues["stat_minhit"] = (System.Int16)source.StatMinhit;
paramValues["stat_str"] = (System.Int16)source.StatStr;
}

/// <summary>
/// Copies the column values into the given DbParameterValues using the database column name
/// with a prefixed @ as the key. The keys must already exist in the DbParameterValues;
///  this method will not create them if they are missing.
/// </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 CopyValues(this IQuestTable source, NetGore.Db.DbParameterValues paramValues)
{
paramValues["id"] = (System.UInt16)source.ID;
paramValues["repeatable"] = (System.Boolean)source.Repeatable;
paramValues["reward_cash"] = (System.Int32)source.RewardCash;
paramValues["reward_exp"] = (System.Int32)source.RewardExp;
}

/// <summary>
/// Copies the column values into the given DbParameterValues using the database column name
/// with a prefixed @ as the key. The keys must already exist in the DbParameterValues;
///  this method will not create them if they are missing.
/// </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 CopyValues(this ICharacterTemplateTable source, NetGore.Db.DbParameterValues paramValues)
{
paramValues["ai_id"] = (System.Nullable<System.UInt16>)source.AIID;
paramValues["alliance_id"] = (System.Byte)source.AllianceID;
paramValues["body_id"] = (System.UInt16)source.BodyID;
paramValues["chat_dialog"] = (System.Nullable<System.UInt16>)source.ChatDialog;
paramValues["exp"] = (System.Int32)source.Exp;
paramValues["give_cash"] = (System.Int32)source.GiveCash;
paramValues["give_exp"] = (System.Int32)source.GiveExp;
paramValues["id"] = (System.UInt16)source.ID;
paramValues["level"] = (System.Int16)source.Level;
paramValues["move_speed"] = (System.UInt16)source.MoveSpeed;
paramValues["name"] = (System.String)source.Name;
paramValues["respawn"] = (System.UInt16)source.Respawn;
paramValues["shop_id"] = (System.Nullable<System.UInt16>)source.ShopID;
paramValues["statpoints"] = (System.Int32)source.StatPoints;
paramValues["stat_agi"] = (System.Int16)source.GetStat((DemoGame.StatType)DemoGame.StatType.Agi);
paramValues["stat_defence"] = (System.Int16)source.GetStat((DemoGame.StatType)DemoGame.StatType.Defence);
paramValues["stat_int"] = (System.Int16)source.GetStat((DemoGame.StatType)DemoGame.StatType.Int);
paramValues["stat_maxhit"] = (System.Int16)source.GetStat((DemoGame.StatType)DemoGame.StatType.MaxHit);
paramValues["stat_maxhp"] = (System.Int16)source.GetStat((DemoGame.StatType)DemoGame.StatType.MaxHP);
paramValues["stat_maxmp"] = (System.Int16)source.GetStat((DemoGame.StatType)DemoGame.StatType.MaxMP);
paramValues["stat_minhit"] = (System.Int16)source.GetStat((DemoGame.StatType)DemoGame.StatType.MinHit);
paramValues["stat_str"] = (System.Int16)source.GetStat((DemoGame.StatType)DemoGame.StatType.Str);
}

/// <summary>
/// Copies the column values into the given DbParameterValues using the database column name
/// with a prefixed @ as the key. The keys must already exist in the DbParameterValues;
///  this method will not create them if they are missing.
/// </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 CopyValues(this IAccountIpsTable source, NetGore.Db.DbParameterValues paramValues)
{
paramValues["account_id"] = (System.Int32)source.AccountID;
paramValues["id"] = (System.UInt32)source.ID;
paramValues["ip"] = (System.UInt32)source.Ip;
paramValues["time"] = (System.DateTime)source.Time;
}

/// <summary>
/// Copies the column values into the given DbParameterValues using the database column name
/// with a prefixed @ as the key. The keys must already exist in the DbParameterValues;
///  this method will not create them if they are missing.
/// </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 CopyValues(this IWorldStatsGuildUserChangeTable source, NetGore.Db.DbParameterValues paramValues)
{
paramValues["guild_id"] = (System.Nullable<System.UInt16>)source.GuildID;
paramValues["id"] = (System.UInt32)source.ID;
paramValues["user_id"] = (System.Int32)source.UserID;
paramValues["when"] = (System.DateTime)source.When;
}

/// <summary>
/// Copies the column values into the given DbParameterValues using the database column name
/// with a prefixed @ as the key. The keys must already exist in the DbParameterValues;
///  this method will not create them if they are missing.
/// </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 CopyValues(this IWorldStatsCountUserKillNpcTable source, NetGore.Db.DbParameterValues paramValues)
{
paramValues["count"] = (System.Int32)source.Count;
paramValues["last_update"] = (System.DateTime)source.LastUpdate;
paramValues["npc_template_id"] = (System.UInt16)source.NPCTemplateID;
paramValues["user_id"] = (System.Int32)source.UserID;
}

/// <summary>
/// Copies the column values into the given DbParameterValues using the database column name
/// with a prefixed @ as the key. The keys must already exist in the DbParameterValues;
///  this method will not create them if they are missing.
/// </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 CopyValues(this IGuildTable source, NetGore.Db.DbParameterValues paramValues)
{
paramValues["created"] = (System.DateTime)source.Created;
paramValues["id"] = (System.UInt16)source.ID;
paramValues["name"] = (System.String)source.Name;
paramValues["tag"] = (System.String)source.Tag;
}

/// <summary>
/// Copies the column values into the given DbParameterValues using the database column name
/// with a prefixed @ as the key. The keys must already exist in the DbParameterValues;
///  this method will not create them if they are missing.
/// </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 CopyValues(this ICharacterQuestStatusTable source, NetGore.Db.DbParameterValues paramValues)
{
paramValues["character_id"] = (System.Int32)source.CharacterID;
paramValues["completed_on"] = (System.Nullable<System.DateTime>)source.CompletedOn;
paramValues["quest_id"] = (System.UInt16)source.QuestID;
paramValues["started_on"] = (System.DateTime)source.StartedOn;
}

/// <summary>
/// Copies the column values into the given DbParameterValues using the database column name
/// with a prefixed @ as the key. The keys must already exist in the DbParameterValues;
///  this method will not create them if they are missing.
/// </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 CopyValues(this ICharacterStatusEffectTable source, NetGore.Db.DbParameterValues paramValues)
{
paramValues["character_id"] = (System.Int32)source.CharacterID;
paramValues["id"] = (System.Int32)source.ID;
paramValues["power"] = (System.UInt16)source.Power;
paramValues["status_effect_id"] = (System.Byte)source.StatusEffect;
paramValues["time_left_secs"] = (System.UInt16)source.TimeLeftSecs;
}

/// <summary>
/// Copies the column values into the given DbParameterValues using the database column name
/// with a prefixed @ as the key. The keys must already exist in the DbParameterValues;
///  this method will not create them if they are missing.
/// </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 CopyValues(this ICharacterTemplateInventoryTable source, NetGore.Db.DbParameterValues paramValues)
{
paramValues["chance"] = (System.UInt16)source.Chance;
paramValues["character_template_id"] = (System.UInt16)source.CharacterTemplateID;
paramValues["id"] = (System.Int32)source.ID;
paramValues["item_template_id"] = (System.UInt16)source.ItemTemplateID;
paramValues["max"] = (System.Byte)source.Max;
paramValues["min"] = (System.Byte)source.Min;
}

/// <summary>
/// Copies the column values into the given DbParameterValues using the database column name
/// with a prefixed @ as the key. The keys must already exist in the DbParameterValues;
///  this method will not create them if they are missing.
/// </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 CopyValues(this IWorldStatsUserConsumeItemTable source, NetGore.Db.DbParameterValues paramValues)
{
paramValues["id"] = (System.UInt32)source.ID;
paramValues["item_template_id"] = (System.UInt16)source.ItemTemplateID;
paramValues["map_id"] = (System.Nullable<System.UInt16>)source.MapID;
paramValues["user_id"] = (System.Int32)source.UserID;
paramValues["when"] = (System.DateTime)source.When;
paramValues["x"] = (System.UInt16)source.X;
paramValues["y"] = (System.UInt16)source.Y;
}