/// <summary>
/// 查看玩家资料
/// </summary>
/// <param name="serverIP">服务器Ip</param>
/// <param name="account">帐号名</param>
/// <returns></returns>
public static DataSet ACCOUNT_QUERY(string serverIP, string strname, ref string strDesc)
{
DataSet result = null;
string sql = "";
int zone = 0;
string serverName = "";
try
{
serverName = CommonInfo.JW2_FindDBName(serverIP);
// zone = CommonInfo.JW2_GetZone_Query(13,serverName);
// if(serverName=="华北一区"||serverName=="华东一区"||serverName=="华南一区"||serverName=="西南一区")
// {
serverIP = CommonInfo.JW2_FindDBIP(serverIP, 1);
sql = "select sql_statement from sqlexpress where sql_type='JW2_ACCOUNT_QUERYBYACCOUNT_bak' and sql_condition='JW2_ACCOUNT_QUERYBYACCOUNT_bak'";
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, strname);
result = MySqlHelper.ExecuteDataset(SqlHelper.JW2GetConnectionString(serverIP, SqlHelper.jw2User, SqlHelper.jw2UserPwd, SqlHelper.jw2gameDB), sql);
}
// }
// else
// {
// sql = "select sql_statement from sqlexpress where sql_type='JW2_ACCOUNT_QUERYBYACCOUNT_ORACLE' and sql_condition='JW2_ACCOUNT_QUERYBYACCOUNT_ORACLE'";
// 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,strname,zone);
// result = CommonInfo.RunOracle(sql,SqlHelper.oracleData,SqlHelper.oracleUser,SqlHelper.oraclePwd);
// }
// }
}
catch (MySqlException ex)
{
strDesc = "数据库连接失败";
SqlHelper.errLog.WriteLog("浏览JW2_ACCOUNT_QUERY_玩家" + strname + "信息服务器IP" + serverIP + ex.Message);
}
return(result);
}
/// <summary>
/// 购买日志
/// </summary>
public static DataSet MoneyLog_Query(string serverIP, int usersn, int goodstype, string BeginTime, string EndTime, int type, string itemName)
{
DataSet result = new DataSet();;
int itemID = 0;
string sql = "";
int zone = 0;
string serverName = "";
try
{
serverName = CommonInfo.JW2_FindDBName(serverIP);
zone = CommonInfo.JW2_GetZone_Query(13, serverName);
if (serverName == "华北一区" || serverName == "华东一区" || serverName == "华南一区" || serverName == "西南一区")
{
serverIP = CommonInfo.JW2_FindDBIP(serverIP, 4);
sql = "select sql_statement from sqlexpress where sql_type='JW2_AgainBuyLog_Query_new' and sql_condition='" + type + "'";
System.Data.DataSet ds = SqlHelper.ExecuteDataset(sql);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
if (itemName == "")
{
if (goodstype == 1)
{
sql = ds.Tables[0].Rows[0].ItemArray[0].ToString();
sql = string.Format(sql, usersn, "M", "G", "C", BeginTime, EndTime, "");
}
else if (goodstype == 2)
{
sql = ds.Tables[0].Rows[0].ItemArray[0].ToString();
sql = string.Format(sql, usersn, "M", "M", "M", BeginTime, EndTime, "");
}
else if (goodstype == 3)
{
sql = ds.Tables[0].Rows[0].ItemArray[0].ToString();
sql = string.Format(sql, usersn, "G", "G", "G", BeginTime, EndTime, "");
}
else if (goodstype == 4)
{
sql = ds.Tables[0].Rows[0].ItemArray[0].ToString();
sql = string.Format(sql, usersn, "C", "C", "C", BeginTime, EndTime, "");
}
result = MySqlHelper.ExecuteDataset(SqlHelper.JW2GetConnectionString(serverIP, SqlHelper.jw2User, SqlHelper.jw2UserPwd, SqlHelper.jw2logDB), sql);
}
else
{
System.Data.DataSet ds1 = CommonInfo.JW2_ProductNameToID(itemName);
for (int i = 0; i < ds1.Tables[0].Rows.Count; i++)
{
itemID = int.Parse(ds1.Tables[0].Rows[i].ItemArray[0].ToString());
string str = "and goodsindex=" + itemID.ToString();
if (goodstype == 1)
{
sql = ds.Tables[0].Rows[0].ItemArray[0].ToString();
sql = string.Format(sql, usersn, "M", "G", "C", BeginTime, EndTime, str);
}
else if (goodstype == 2)
{
sql = ds.Tables[0].Rows[0].ItemArray[0].ToString();
sql = string.Format(sql, usersn, "M", "M", "M", BeginTime, EndTime, str);
}
else if (goodstype == 3)
{
sql = ds.Tables[0].Rows[0].ItemArray[0].ToString();
sql = string.Format(sql, usersn, "G", "G", "G", BeginTime, EndTime, str);
}
else if (goodstype == 4)
{
sql = ds.Tables[0].Rows[0].ItemArray[0].ToString();
sql = string.Format(sql, usersn, "C", "C", "C", BeginTime, EndTime, "");
}
result.Merge(MySqlHelper.ExecuteDataset(SqlHelper.JW2GetConnectionString(serverIP, SqlHelper.jw2User, SqlHelper.jw2UserPwd, SqlHelper.jw2logDB), sql));
}
}
}
}
else
{
sql = "select sql_statement from sqlexpress where sql_type='JW2_AgainBuyLog_Oracle_Query' and sql_condition='" + type + "'";
System.Data.DataSet ds2 = SqlHelper.ExecuteDataset(sql);
if (ds2 != null && ds2.Tables[0].Rows.Count > 0)
{
if (itemName == "")
{
if (goodstype == 1)
{
sql = ds2.Tables[0].Rows[0].ItemArray[0].ToString();
sql = string.Format(sql, usersn, "M", "G", BeginTime, EndTime, "", zone);
}
else if (goodstype == 2)
{
sql = ds2.Tables[0].Rows[0].ItemArray[0].ToString();
sql = string.Format(sql, usersn, "M", "M", BeginTime, EndTime, "", zone);
}
else if (goodstype == 3)
{
sql = ds2.Tables[0].Rows[0].ItemArray[0].ToString();
sql = string.Format(sql, usersn, "G", "G", BeginTime, EndTime, "", zone);
}
result = CommonInfo.RunOracle(sql, SqlHelper.oracleData, SqlHelper.oracleUser, SqlHelper.oraclePwd);
}
else
{
System.Data.DataSet ds3 = CommonInfo.JW2_ProductNameToID(itemName);
for (int i = 0; i < ds3.Tables[0].Rows.Count; i++)
{
itemID = int.Parse(ds3.Tables[0].Rows[i].ItemArray[0].ToString());
string str = "and buy_goods=" + itemID.ToString();
if (goodstype == 1)
{
sql = ds2.Tables[0].Rows[0].ItemArray[0].ToString();
sql = string.Format(sql, usersn, "M", "G", BeginTime, EndTime, str, zone);
}
else if (goodstype == 2)
{
sql = ds2.Tables[0].Rows[0].ItemArray[0].ToString();
sql = string.Format(sql, usersn, "M", "M", BeginTime, EndTime, str, zone);
}
else if (goodstype == 3)
{
sql = ds2.Tables[0].Rows[0].ItemArray[0].ToString();
sql = string.Format(sql, usersn, "G", "G", BeginTime, EndTime, str, zone);
}
result = CommonInfo.RunOracle(sql, SqlHelper.oracleData, SqlHelper.oracleUser, SqlHelper.oraclePwd);
}
}
}
}
}
catch (MySqlException ex)
{
SqlHelper.errLog.WriteLog("浏览JW2_MoneyLog_Query_查看玩家" + usersn.ToString() + "购买日志服务器IP" + serverIP + type.ToString() + "开始时间" + BeginTime + "结束时间" + EndTime + goodstype.ToString() + ex.Message);
}
return(result);
}