/// <summary>
/// 修改经验
/// </summary>
public static int MODIFYEXP_QUERY(string serverIP, int usersn, float iExp, int userByID, string UserName, ref string strDesc)
{
int result = -1;
string sql = null;
try
{
//查询等级对应的经验值
long iLevel = CommonInfo.JW2_ExpToLevel(iExp);
//修改等级1
serverIP = CommonInfo.JW2_FindDBIP(serverIP, 7);
sql = "select sql_statement from sqlexpress where sql_type='JW2_MODIFYLEVEL_QUERY1' and sql_condition = 'JW2_MODIFYLEVEL_QUERY1'";
System.Data.DataSet ds = SqlHelper.ExecuteDataset(sql);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
sql = ds.Tables[0].Rows[0].ItemArray[0].ToString();
sql = string.Format(sql, iLevel, usersn);
result = MySqlHelper.ExecuteNonQuery(SqlHelper.JW2GetConnectionString(serverIP, SqlHelper.jw2User, SqlHelper.jw2UserPwd, SqlHelper.jw2gameDB), sql);
}
//修改等级2
serverIP = CommonInfo.JW2_FindDBIP(serverIP, 9);
sql = "select sql_statement from sqlexpress where sql_type='JW2_MODIFYLEVEL_QUERY2' and sql_condition = 'JW2_MODIFYLEVEL_QUERY2'";
System.Data.DataSet ds1 = SqlHelper.ExecuteDataset(sql);
if (ds1 != null && ds1.Tables[0].Rows.Count > 0)
{
sql = ds1.Tables[0].Rows[0].ItemArray[0].ToString();
sql = string.Format(sql, iLevel, usersn);
result += MySqlHelper.ExecuteNonQuery(SqlHelper.JW2GetConnectionString(serverIP, SqlHelper.jw2User, SqlHelper.jw2UserPwd, SqlHelper.jw2messengerDB), sql);
}
//修改经验
serverIP = CommonInfo.JW2_FindDBIP(serverIP, 7);
sql = "select sql_statement from sqlexpress where sql_type='JW2_MODIFYEXP_QUERY' and sql_condition = 'JW2_MODIFYEXP_QUERY'";
System.Data.DataSet ds2 = SqlHelper.ExecuteDataset(sql);
if (ds2 != null && ds2.Tables[0].Rows.Count > 0)
{
sql = ds2.Tables[0].Rows[0].ItemArray[0].ToString();
sql = string.Format(sql, iExp, usersn);
result += MySqlHelper.ExecuteNonQuery(SqlHelper.JW2GetConnectionString(serverIP, SqlHelper.jw2User, SqlHelper.jw2UserPwd, SqlHelper.jw2gameDB), sql);
}
if (result == 3)
{
strDesc = "修改玩家：" + UserName.ToString() + "，等级：" + iLevel.ToString() + "，经验：" + iExp.ToString() + "，成功，请稍等，系统处理中！";
SqlHelper.insertGMtoolsLog(userByID, "劲舞团II", serverIP, "JW2_MODIFYEXP_QUERY", "修改玩家：" + UserName.ToString() + "，等级：" + iLevel.ToString() + "，经验：" + iExp.ToString() + "，成功(修改经验,jw2)");
}
else
{
strDesc = "修改玩家：" + UserName.ToString() + "，等级：" + iLevel.ToString() + "，经验：" + iExp.ToString() + "，失败，请确认该角色是否存在！";
SqlHelper.insertGMtoolsLog(userByID, "劲舞团II", serverIP, "JW2_MODIFYEXP_QUERY", "修改玩家：" + UserName.ToString() + "，等级：" + iLevel.ToString() + "，经验：" + iExp.ToString() + "，失败(修改经验,jw2)");
}
}
catch (System.Exception ex)
{
strDesc = "数据库连接失败，请重新尝试！";
SqlHelper.errLog.WriteLog("浏览JW2_MODIFYEXP_QUERY_玩家" + usersn.ToString() + "-" + UserName + "修改经验服务器IP" + serverIP + ex.Message);
}
return(result);
}