/// <summary> /// 插入一个新账号 /// </summary> /// <param name="acct"></param> /// <param name="password"></param> /// <param name="data"></param> /// <returns>返回主键id</returns> public int InsertNewAccount(string acct, string password, PlayerData data) { string quest = "insert into account set acct = @acct,password = @password,name = " + "@name,level = @level,exp = @exp,power = @power,coin = @coin,diamond = @diamond," + "hp = @hp,ad = @ad,ap = @ap,addef = @addef,apdef = @apdef,dodge = @dodge," + "pierce = @pierce,critical = @critical, guideid = @guideid, strong = @strong," + "crystal = @crystal, time = @time, fubenid = @fubenid"; int id = -1; try { MySqlCommand cmd = new MySqlCommand(quest, conn); cmd.Parameters.AddWithValue("acct", acct); cmd.Parameters.AddWithValue("password", password); cmd.Parameters.AddWithValue("name", data.Name); cmd.Parameters.AddWithValue("level", data.Level); cmd.Parameters.AddWithValue("exp", data.Experience); cmd.Parameters.AddWithValue("power", data.Power); cmd.Parameters.AddWithValue("coin", data.Coin); cmd.Parameters.AddWithValue("diamond", data.Diamond); cmd.Parameters.AddWithValue("hp", data.Hp); cmd.Parameters.AddWithValue("ad", data.Ad); cmd.Parameters.AddWithValue("ap", data.Ap); cmd.Parameters.AddWithValue("addef", data.Addef); cmd.Parameters.AddWithValue("apdef", data.Apdef); cmd.Parameters.AddWithValue("dodge", data.Dodge); cmd.Parameters.AddWithValue("pierce", data.Pierce); cmd.Parameters.AddWithValue("critical", data.Critical); cmd.Parameters.AddWithValue("guideid", data.GuideID); string str = PECommonTool.GetJointString(data.Strong, '#'); cmd.Parameters.AddWithValue("strong", str); cmd.Parameters.AddWithValue("crystal", data.Crystal); cmd.Parameters.AddWithValue("time", data.Time); cmd.Parameters.AddWithValue("fubenid", data.FuBenId); cmd.ExecuteNonQuery(); id = (int)cmd.LastInsertedId; PECommonTool.Log(id.ToString(), LogType.Info); } catch (Exception e) { PECommonTool.Log("InsertNewAccount: " + e.Message, LogType.Error); } return(id); }
/// <summary> /// 修改数据 /// </summary> public bool UpdatePlayerData(int id, PlayerData data) { bool updateSuc = true; string quest = "update account set name = @name,level = @level,exp = @exp,power = @power,coin = @coin,diamond = @diamond," + "hp = @hp,ad = @ad,ap = @ap,addef = @addef,apdef = @apdef,dodge = @dodge," + "pierce = @pierce,critical = @critical, guideid = @guideid,strong = @strong," + "crystal = @crystal, time = @time, fubenid = @fubenid where id=@id "; try { MySqlCommand cmd = new MySqlCommand(quest, conn); cmd.Parameters.AddWithValue("id", id); cmd.Parameters.AddWithValue("name", data.Name); cmd.Parameters.AddWithValue("level", data.Level); cmd.Parameters.AddWithValue("exp", data.Experience); cmd.Parameters.AddWithValue("power", data.Power); cmd.Parameters.AddWithValue("coin", data.Coin); cmd.Parameters.AddWithValue("diamond", data.Diamond); cmd.Parameters.AddWithValue("hp", data.Hp); cmd.Parameters.AddWithValue("ad", data.Ad); cmd.Parameters.AddWithValue("ap", data.Ap); cmd.Parameters.AddWithValue("addef", data.Addef); cmd.Parameters.AddWithValue("apdef", data.Apdef); cmd.Parameters.AddWithValue("dodge", data.Dodge); cmd.Parameters.AddWithValue("pierce", data.Pierce); cmd.Parameters.AddWithValue("critical", data.Critical); cmd.Parameters.AddWithValue("guideid", data.GuideID); string str = PECommonTool.GetJointString(data.Strong, '#'); cmd.Parameters.AddWithValue("strong", str); cmd.Parameters.AddWithValue("crystal", data.Crystal); cmd.Parameters.AddWithValue("time", data.Time); cmd.Parameters.AddWithValue("fubenid", data.FuBenId); cmd.ExecuteNonQuery(); } catch (Exception e) { updateSuc = false; PECommonTool.Log("UpdatePlayerData: " + e.Message, LogType.Error); } return(updateSuc); }