//保存到数据库中,update //作废 public void SaveDB2() { StringBuilder sb = new StringBuilder(); List <SQLiteParameter> lp = new List <SQLiteParameter>(); sb.Append("update MagicInfo set "); sb.Append(" Name=@Name, "); lp.Add(new SQLiteParameter("Name", Name)); sb.Append(" BaseCost=@BaseCost, "); lp.Add(new SQLiteParameter("BaseCost", BaseCost)); sb.Append(" LevelCost=@LevelCost, "); lp.Add(new SQLiteParameter("LevelCost", LevelCost)); sb.Append(" Icon=@Icon, "); lp.Add(new SQLiteParameter("Icon", Icon)); sb.Append(" Level1=@Level1, "); lp.Add(new SQLiteParameter("Level1", Level1)); sb.Append(" Level2=@Level2, "); lp.Add(new SQLiteParameter("Level2", Level2)); sb.Append(" Level3=@Level3, "); lp.Add(new SQLiteParameter("Level3", Level3)); sb.Append(" Need1=@Need1, "); lp.Add(new SQLiteParameter("Need1", Need1)); sb.Append(" Need2=@Need2, "); lp.Add(new SQLiteParameter("Need2", Need2)); sb.Append(" Need3=@Need3, "); lp.Add(new SQLiteParameter("Need3", Need3)); sb.Append(" DelayBase=@DelayBase, "); lp.Add(new SQLiteParameter("DelayBase", DelayBase)); sb.Append(" DelayReduction=@DelayReduction, "); lp.Add(new SQLiteParameter("DelayReduction", DelayReduction)); sb.Append(" PowerBase=@PowerBase, "); lp.Add(new SQLiteParameter("PowerBase", PowerBase)); sb.Append(" PowerBonus=@PowerBonus, "); lp.Add(new SQLiteParameter("PowerBonus", PowerBonus)); sb.Append(" MPowerBase=@MPowerBase, "); lp.Add(new SQLiteParameter("MPowerBase", MPowerBase)); sb.Append(" MPowerBonus=@MPowerBonus, "); lp.Add(new SQLiteParameter("MPowerBonus", MPowerBonus)); sb.Append(" Range=@Range, "); lp.Add(new SQLiteParameter("Range", Range)); sb.Append(" MultiplierBase=@MultiplierBase, "); lp.Add(new SQLiteParameter("MultiplierBase", MultiplierBase)); sb.Append(" MultiplierBonus=@MultiplierBonus "); lp.Add(new SQLiteParameter("MultiplierBonus", MultiplierBonus)); sb.Append(" where Spell=@Spell"); lp.Add(new SQLiteParameter("Spell", Spell)); //执行更新 MirConfigDB.Execute(sb.ToString(), lp.ToArray()); }
/// <summary> /// 加载所有的魔法技能,从数据库中加载 /// </summary> /// <returns></returns> public static List <MagicInfo> loadAll() { List <MagicInfo> list = new List <MagicInfo>(); //DbDataReader read = MirConfigDB.ExecuteReader("select Name,BaseCost,LevelCost,Icon,Level1,Level2,Level3,Need1,Need2,Need3,DelayBase,DelayReduction,PowerBase,PowerBonus,MPowerBase,MPowerBonus,Range,Spell,MultiplierBase,MultiplierBonus from MagicInfo"); DbDataReader read = MirConfigDB.ExecuteReader("select * from MagicInfo"); while (read.Read()) { MagicInfo magic = new MagicInfo(); if (read.IsDBNull(read.GetOrdinal("Name"))) { continue; } magic.Name = read.GetString(read.GetOrdinal("Name")); if (magic.Name == null) { continue; } magic.BaseCost = read.GetByte(read.GetOrdinal("BaseCost")); magic.LevelCost = read.GetByte(read.GetOrdinal("LevelCost")); magic.Icon = read.GetByte(read.GetOrdinal("Icon")); magic.Level1 = read.GetByte(read.GetOrdinal("Level1")); magic.Level2 = read.GetByte(read.GetOrdinal("Level2")); magic.Level3 = read.GetByte(read.GetOrdinal("Level3")); magic.Need1 = (ushort)read.GetInt32(read.GetOrdinal("Need1")); magic.Need2 = (ushort)read.GetInt32(read.GetOrdinal("Need2")); magic.Need3 = (ushort)read.GetInt32(read.GetOrdinal("Need3")); magic.DelayBase = (uint)read.GetInt32(read.GetOrdinal("DelayBase")); magic.DelayReduction = (uint)read.GetInt32(read.GetOrdinal("DelayReduction")); magic.PowerBase = (ushort)read.GetInt32(read.GetOrdinal("PowerBase")); magic.PowerBonus = (ushort)read.GetInt32(read.GetOrdinal("PowerBonus")); magic.MPowerBase = (ushort)read.GetInt32(read.GetOrdinal("MPowerBase")); magic.MPowerBonus = (ushort)read.GetInt32(read.GetOrdinal("MPowerBonus")); magic.Range = read.GetByte(read.GetOrdinal("Range")); magic.Spell = (Spell)read.GetByte(read.GetOrdinal("Spell")); magic.MultiplierBase = read.GetFloat(read.GetOrdinal("MultiplierBase")); magic.MultiplierBonus = read.GetFloat(read.GetOrdinal("MultiplierBonus")); list.Add(magic); } return(list); }