//保存到数据库中,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);
}