C# DbParameterValues类代码示例

 /// <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, DbParameterValues paramValues)
 {
     paramValues["id"] = (UInt16)source.ID;
     paramValues["repeatable"] = source.Repeatable;
     paramValues["reward_cash"] = source.RewardCash;
     paramValues["reward_exp"] = 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, DbParameterValues paramValues)
 {
     paramValues["ai_id"] = (ushort?)source.AIID;
     paramValues["alliance_id"] = (Byte)source.AllianceID;
     paramValues["body_id"] = (UInt16)source.BodyID;
     paramValues["chat_dialog"] = (ushort?)source.ChatDialog;
     paramValues["exp"] = source.Exp;
     paramValues["give_cash"] = source.GiveCash;
     paramValues["give_exp"] = source.GiveExp;
     paramValues["id"] = (UInt16)source.ID;
     paramValues["level"] = source.Level;
     paramValues["move_speed"] = source.MoveSpeed;
     paramValues["name"] = source.Name;
     paramValues["respawn"] = source.Respawn;
     paramValues["shop_id"] = (ushort?)source.ShopID;
     paramValues["statpoints"] = source.StatPoints;
     paramValues["stat_agi"] = (Int16)source.GetStat(StatType.Agi);
     paramValues["stat_defence"] = (Int16)source.GetStat(StatType.Defence);
     paramValues["stat_int"] = (Int16)source.GetStat(StatType.Int);
     paramValues["stat_maxhit"] = (Int16)source.GetStat(StatType.MaxHit);
     paramValues["stat_maxhp"] = (Int16)source.GetStat(StatType.MaxHP);
     paramValues["stat_maxmp"] = (Int16)source.GetStat(StatType.MaxMP);
     paramValues["stat_minhit"] = (Int16)source.GetStat(StatType.MinHit);
     paramValues["stat_str"] = (Int16)source.GetStat(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 IItemTemplateTable source, DbParameterValues paramValues)
 {
     paramValues["action_display_id"] = (ushort?)source.ActionDisplayID;
     paramValues["description"] = source.Description;
     paramValues["equipped_body"] = source.EquippedBody;
     paramValues["graphic"] = (UInt16)source.Graphic;
     paramValues["height"] = source.Height;
     paramValues["hp"] = (Int16)source.HP;
     paramValues["id"] = (UInt16)source.ID;
     paramValues["mp"] = (Int16)source.MP;
     paramValues["name"] = source.Name;
     paramValues["range"] = source.Range;
     paramValues["stat_agi"] = (Int16)source.GetStat(StatType.Agi);
     paramValues["stat_defence"] = (Int16)source.GetStat(StatType.Defence);
     paramValues["stat_int"] = (Int16)source.GetStat(StatType.Int);
     paramValues["stat_maxhit"] = (Int16)source.GetStat(StatType.MaxHit);
     paramValues["stat_maxhp"] = (Int16)source.GetStat(StatType.MaxHP);
     paramValues["stat_maxmp"] = (Int16)source.GetStat(StatType.MaxMP);
     paramValues["stat_minhit"] = (Int16)source.GetStat(StatType.MinHit);
     paramValues["stat_req_agi"] = (Int16)source.GetReqStat(StatType.Agi);
     paramValues["stat_req_int"] = (Int16)source.GetReqStat(StatType.Int);
     paramValues["stat_req_str"] = (Int16)source.GetReqStat(StatType.Str);
     paramValues["stat_str"] = (Int16)source.GetStat(StatType.Str);
     paramValues["type"] = (Byte)source.Type;
     paramValues["value"] = source.Value;
     paramValues["weapon_type"] = (Byte)source.WeaponType;
     paramValues["width"] = 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 ICharacterTemplateEquippedTable source, DbParameterValues paramValues)
 {
     paramValues["chance"] = (UInt16)source.Chance;
     paramValues["character_template_id"] = (UInt16)source.CharacterTemplateID;
     paramValues["id"] = source.ID;
     paramValues["item_template_id"] = (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 ICharacterQuestStatusTable source, DbParameterValues paramValues)
 {
     paramValues["character_id"] = (Int32)source.CharacterID;
     paramValues["completed_on"] = source.CompletedOn;
     paramValues["quest_id"] = (UInt16)source.QuestID;
     paramValues["started_on"] = 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 IGuildTable source, DbParameterValues paramValues)
 {
     paramValues["created"] = source.Created;
     paramValues["id"] = (UInt16)source.ID;
     paramValues["name"] = source.Name;
     paramValues["tag"] = 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 IAccountIpsTable source, DbParameterValues paramValues)
 {
     paramValues["account_id"] = (Int32)source.AccountID;
     paramValues["id"] = source.ID;
     paramValues["ip"] = source.Ip;
     paramValues["time"] = 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, DbParameterValues paramValues)
 {
     paramValues["guild_id"] = (ushort?)source.GuildID;
     paramValues["id"] = source.ID;
     paramValues["user_id"] = (Int32)source.UserID;
     paramValues["when"] = 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 ICharacterTable source, DbParameterValues paramValues)
 {
     paramValues["ai_id"] = (ushort?)source.AIID;
     paramValues["body_id"] = (UInt16)source.BodyID;
     paramValues["cash"] = source.Cash;
     paramValues["character_template_id"] = (ushort?)source.CharacterTemplateID;
     paramValues["chat_dialog"] = (ushort?)source.ChatDialog;
     paramValues["exp"] = source.Exp;
     paramValues["hp"] = (Int16)source.HP;
     paramValues["id"] = (Int32)source.ID;
     paramValues["level"] = source.Level;
     paramValues["load_map_id"] = (UInt16)source.LoadMapID;
     paramValues["load_x"] = source.LoadX;
     paramValues["load_y"] = source.LoadY;
     paramValues["move_speed"] = source.MoveSpeed;
     paramValues["mp"] = (Int16)source.MP;
     paramValues["name"] = source.Name;
     paramValues["respawn_map_id"] = (ushort?)source.RespawnMapID;
     paramValues["respawn_x"] = source.RespawnX;
     paramValues["respawn_y"] = source.RespawnY;
     paramValues["shop_id"] = (ushort?)source.ShopID;
     paramValues["statpoints"] = source.StatPoints;
     paramValues["stat_agi"] = (Int16)source.GetStat(StatType.Agi);
     paramValues["stat_defence"] = (Int16)source.GetStat(StatType.Defence);
     paramValues["stat_int"] = (Int16)source.GetStat(StatType.Int);
     paramValues["stat_maxhit"] = (Int16)source.GetStat(StatType.MaxHit);
     paramValues["stat_maxhp"] = (Int16)source.GetStat(StatType.MaxHP);
     paramValues["stat_maxmp"] = (Int16)source.GetStat(StatType.MaxMP);
     paramValues["stat_minhit"] = (Int16)source.GetStat(StatType.MinHit);
     paramValues["stat_str"] = (Int16)source.GetStat(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 IWorldStatsCountUserKillNpcTable source, DbParameterValues paramValues)
 {
     paramValues["count"] = source.Count;
     paramValues["last_update"] = source.LastUpdate;
     paramValues["npc_template_id"] = (UInt16)source.NPCTemplateID;
     paramValues["user_id"] = (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 IGuildMemberTable source, DbParameterValues paramValues)
 {
     paramValues["character_id"] = (Int32)source.CharacterID;
     paramValues["guild_id"] = (UInt16)source.GuildID;
     paramValues["joined"] = source.Joined;
     paramValues["rank"] = (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 ICharacterQuestStatusKillsTable source, DbParameterValues paramValues)
 {
     paramValues["character_id"] = (Int32)source.CharacterID;
     paramValues["character_template_id"] = (UInt16)source.CharacterTemplateID;
     paramValues["count"] = source.Count;
     paramValues["quest_id"] = (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 ICharacterStatusEffectTable source, DbParameterValues paramValues)
 {
     paramValues["character_id"] = (Int32)source.CharacterID;
     paramValues["id"] = (Int32)source.ID;
     paramValues["power"] = source.Power;
     paramValues["status_effect_id"] = (Byte)source.StatusEffect;
     paramValues["time_left_secs"] = 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, DbParameterValues paramValues)
 {
     paramValues["chance"] = (UInt16)source.Chance;
     paramValues["character_template_id"] = (UInt16)source.CharacterTemplateID;
     paramValues["id"] = source.ID;
     paramValues["item_template_id"] = (UInt16)source.ItemTemplateID;
     paramValues["max"] = source.Max;
     paramValues["min"] = 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 IWorldStatsUserLevelTable source, DbParameterValues paramValues)
 {
     paramValues["character_id"] = (Int32)source.CharacterID;
     paramValues["id"] = source.ID;
     paramValues["level"] = source.Level;
     paramValues["map_id"] = (ushort?)source.MapID;
     paramValues["when"] = source.When;
     paramValues["x"] = source.X;
     paramValues["y"] = source.Y;
 }