/// <summary>
        /// 查看玩家资料
        /// </summary>
        /// <param name="serverIP">服务器Ip</param>
        /// <param name="account">昵称</param>
        /// <returns></returns>
        public static DataSet USERNICK_QUERY(string serverIP, string strname)
        {
            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_QUERYBYNICKNAME_Bak' and sql_condition='JW2_ACCOUNT_QUERYBYNICKNAME_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_QUERYBYNICKNAME_ORACLE' and sql_condition='JW2_ACCOUNT_QUERYBYNICKNAME_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)
            {
                SqlHelper.errLog.WriteLog("浏览JW2_USERNICK_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);
        }