/// <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);
}