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