/// <summary> /// 消费日志 /// </summary> public static DataSet CashMoney_Log(string serverIP, int usersn, int type, string BeginTime, string EndTime) { DataSet result = null; string sql = ""; try { if (type == 6) { int ZoneID = CommonInfo.JW2_ServerIPToZoneID(serverIP); sql = "select sql_statement from sqlexpress where sql_type='JW2_Center_BuyInfo' and sql_condition='JW2_Center_BuyInfo'"; 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, ZoneID, usersn, BeginTime, EndTime); result = CommonInfo.RunOracle(sql, ZoneID); } } else if (type == 15) { serverIP = CommonInfo.JW2_FindDBIP(serverIP, 4); sql = "select sql_statement from sqlexpress where sql_type='jw2_wedding_log_Query' and sql_condition='jw2_wedding_log_Query'"; 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, usersn, type, BeginTime, EndTime); result = MySqlHelper.ExecuteDataset(SqlHelper.JW2GetConnectionString(serverIP, SqlHelper.jw2User, SqlHelper.jw2UserPwd, SqlHelper.jw2logDB), sql); } } else { serverIP = CommonInfo.JW2_FindDBIP(serverIP, 4); sql = "select sql_statement from sqlexpress where sql_type='JW2_CashMoney_Log' and sql_condition='JW2_CashMoney_Log'"; 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, usersn, type, BeginTime, EndTime); result = MySqlHelper.ExecuteDataset(SqlHelper.JW2GetConnectionString(serverIP, SqlHelper.jw2User, SqlHelper.jw2UserPwd, SqlHelper.jw2logDB), sql); } } } catch (MySqlException ex) { SqlHelper.errLog.WriteLog("浏览JW2_CashMoney_Log_查看玩家" + usersn.ToString() + "消费日志服务器IP" + serverIP + type.ToString() + "开始时间" + BeginTime + "结束时间" + EndTime + ex.Message); } return(result); }
/// <summary> /// 中间件身上道具查询 /// </summary> public static DataSet CenterAvAtarItem_Equip_Query(string serverIP, int usersn) { DataSet result = null; string sql = ""; try { int zoneID = CommonInfo.JW2_ServerIPToZoneID(serverIP); sql = "select sql_statement from sqlexpress where sql_type='JW2_Gtavatar_Equip' and sql_condition='JW2_Gtavatar_Equip'"; 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, usersn); result = CommonInfo.RunOracle(sql, zoneID); } } catch (MySqlException ex) { SqlHelper.errLog.WriteLog("浏览JW2_CenterAvAtarItem_Equip_Query_查看玩家" + usersn.ToString() + "中间件身上道具查询服务器IP" + serverIP + ex.Message); } return(result); }