当前位置: 首页>>代码示例>>C#>>正文


C# MySqlCommand.Delete方法代码示例

本文整理汇总了C#中PhoenixProject.Database.MySqlCommand.Delete方法的典型用法代码示例。如果您正苦于以下问题:C# MySqlCommand.Delete方法的具体用法?C# MySqlCommand.Delete怎么用?C# MySqlCommand.Delete使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在PhoenixProject.Database.MySqlCommand的用法示例。


在下文中一共展示了MySqlCommand.Delete方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。

示例1: Claim

        public static void Claim(uint kimo, Client.GameState owner)
        {
            MySqlCommand command = new MySqlCommand(MySqlCommandType.DELETE);

            command.Delete("claimitems", "ItemUID", kimo).And("GainerUID", owner.Entity.UID).Execute();
            //ClaimItem.Delete(item.Item.UID);
        }
开发者ID:Mromany,项目名称:Conquista5679-TheHunterSource-,代码行数:7,代码来源:ClaimItemTable.cs

示例2: Disband

 public static void Disband(Game.ConquerStructures.Society.Guild guild)
 {
     MySqlCommand command = new MySqlCommand(MySqlCommandType.UPDATE);
     command.Update("entities").Set("GuildID", 0).Where("GuildID", guild.ID).Execute();
     ServerBase.Kernel.Guilds.Remove(guild.ID);
     command = new MySqlCommand(MySqlCommandType.DELETE);
     command.Delete("guilds", "ID", guild.ID).Execute();
 }
开发者ID:Mromany,项目名称:Conquista5679-TheHunterSource-,代码行数:8,代码来源:GuildTable.cs

示例3: RemoveItem

        public static void RemoveItem(Client.GameState client)
        {
            MySqlCommand command = new MySqlCommand(MySqlCommandType.DELETE);
            command.Delete("prizenpc", "Owner", client.Entity.UID).And("type", "2").Execute();

            PrizeNpcInformations.Remove(client.Entity.UID);
            MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT).Select("prizenpc").Where("Owner", client.Entity.UID);
            PhoenixProject.Database.MySqlReader r = new PhoenixProject.Database.MySqlReader(cmd);
            if (r.Read())
            {
                PrizeNpcInfo info = new PrizeNpcInfo();
                info.Owner = r.ReadUInt32("Owner");
                info.type = r.ReadUInt32("type");
                info.amount = r.ReadUInt32("amount");
                info.itemid = r.ReadUInt32("itemid");
                PrizeNpcInformations.Add(info.Owner, info);
            }
            //Console.WriteLine("PrizeNpc Loaded.");
            r.Close();
            r.Dispose();
        }
开发者ID:Mromany,项目名称:Conquista5679-TheHunterSource-,代码行数:21,代码来源:PrizeNPC.cs

示例4: RemoveEnemy

 public static void RemoveEnemy(Game.ConquerStructures.Society.Guild guild, uint enemy)
 {
     MySqlCommand command = new MySqlCommand(MySqlCommandType.DELETE);
     command.Delete("guildenemy", "GuildID", guild.ID).And("EnemyID", enemy).Execute();
 }
开发者ID:Mromany,项目名称:Conquista5679-TheHunterSource-,代码行数:5,代码来源:GuildTable.cs

示例5: RemoveReincarnated

 public static void RemoveReincarnated(Game.Entity entity)
 {
     MySqlCommand cmd = new MySqlCommand(MySqlCommandType.DELETE);
     cmd.Delete("reincarnation", "uid", entity.UID).Execute();
 }
开发者ID:Mromany,项目名称:Conquista5679-TheHunterSource-,代码行数:5,代码来源:ReincarnationTable.cs

示例6: DeleteArsenalItem

 public static void DeleteArsenalItem(uint uid, uint i_uid, Arsenal_ID aid)
 {
     MySqlCommand Command = new MySqlCommand(MySqlCommandType.DELETE);
     Command.Delete("pt_arsenal_inscribed", "uid", uid).And("iten_id", i_uid).Execute();
 }
开发者ID:Mromany,项目名称:Conquista5679-TheHunterSource-,代码行数:5,代码来源:ArsenalTable.cs

示例7: DeleteArsenal

 public static void DeleteArsenal(uint s_id, Arsenal_ID id)
 {
     MySqlCommand Command = new MySqlCommand(MySqlCommandType.DELETE);
     Command.Delete("pt_arsenal", "syn_id", s_id).And("arsenal_id", (byte)id).Execute();
 }
开发者ID:Mromany,项目名称:Conquista5679-TheHunterSource-,代码行数:5,代码来源:ArsenalTable.cs

示例8: DeleteSpell

 public static void DeleteSpell(Client.GameState client, ushort ID)
 {
     MySqlCommand command = new MySqlCommand(MySqlCommandType.DELETE);
     command.Delete("skills", "ID", ID).And("EntityID", client.Entity.UID).Execute();
 }
开发者ID:Mromany,项目名称:Conquista5679-TheHunterSource-,代码行数:5,代码来源:SkillTable.cs

示例9: RemovePartner

 public static void RemovePartner(Client.GameState client, uint partnerID)
 {
     MySqlCommand cmd = new MySqlCommand(MySqlCommandType.DELETE);
     cmd.Delete("partners", "partnerid", partnerID).And("entityid", client.Entity.UID).Execute();
     cmd = new MySqlCommand(MySqlCommandType.DELETE);
     cmd.Delete("partners", "entityid", partnerID).And("partnerid", client.Entity.UID).Execute();
 }
开发者ID:Mromany,项目名称:Conquista5679-TheHunterSource-,代码行数:7,代码来源:KnownPersons.cs

示例10: RemoveMentor

 public static void RemoveMentor(uint apprenticeuid)
 {
     MySqlCommand cmd = new MySqlCommand(MySqlCommandType.DELETE);
     cmd.Delete("apprentice", "apprenticeid", apprenticeuid).Execute();
 }
开发者ID:Mromany,项目名称:Conquista5679-TheHunterSource-,代码行数:5,代码来源:KnownPersons.cs

示例11: RemoveFriend

 public static void RemoveFriend(Client.GameState client, uint friendID)
 {
     MySqlCommand cmd = new MySqlCommand(MySqlCommandType.DELETE);
     cmd.Delete("friends", "friendid", friendID).And("entityid", client.Entity.UID).Execute();
     cmd = new MySqlCommand(MySqlCommandType.DELETE);
     cmd.Delete("friends", "entityid", friendID).And("friendid", client.Entity.UID).Execute();
 }
开发者ID:Mromany,项目名称:Conquista5679-TheHunterSource-,代码行数:7,代码来源:KnownPersons.cs

示例12: RemoveEnemy

 public static void RemoveEnemy(Client.GameState client, uint enemyID)
 {
     MySqlCommand cmd = new MySqlCommand(MySqlCommandType.DELETE);
     cmd.Delete("enemy", "enemyid", enemyID).And("entityid", client.Entity.UID).Execute();
 }
开发者ID:Mromany,项目名称:Conquista5679-TheHunterSource-,代码行数:5,代码来源:KnownPersons.cs

示例13: RemoveApprentice

 public static void RemoveApprentice(Client.GameState client, uint apprenticeID)
 {
     MySqlCommand cmd = new MySqlCommand(MySqlCommandType.DELETE);
     cmd.Delete("apprentice", "apprenticeid", apprenticeID).Execute();
 }
开发者ID:Mromany,项目名称:Conquista5679-TheHunterSource-,代码行数:5,代码来源:KnownPersons.cs

示例14: RemoveAdding

 public static void RemoveAdding(uint UID, uint addingid)
 {
     MySqlCommand cmd = new MySqlCommand(MySqlCommandType.DELETE);
     cmd.Delete("itemadding", "uid", UID).And("addingid", addingid).Execute();
 }
开发者ID:Mromany,项目名称:Conquista5679-TheHunterSource-,代码行数:5,代码来源:ItemAddingTable.cs

示例15: DeleteRelation

 public void DeleteRelation(UInt32 Relative, Network.GamePackets.ClanRelations.RelationTypes type)
 {
     MySqlCommand Command = new MySqlCommand(MySqlCommandType.DELETE);
     Command.Delete("clanrelation", "clanid", this.ClanId).And("AssociatedId", Relative).And("type", Convert.ToByte(type)).Execute();
     //Console.WriteLine("2222");
 }
开发者ID:Mromany,项目名称:Conquista5679-TheHunterSource-,代码行数:6,代码来源:Clans.cs


注:本文中的PhoenixProject.Database.MySqlCommand.Delete方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。