示例#1
0
        /// <summary>
        /// 初始化SQL
        /// </summary>
        private static void InitSQL()
        {
            //////////////////////////////////////////////////////////////////////////
            // 开始在编译后的程序集合内获取密码

            Type l_Type = ScriptCompiler.FindTypeByFullName("Demo_R.O.S.E.Scripts.Globals.GlobalConfig");

            if (l_Type != null)
            {
                FieldInfo l_FieldInfo = l_Type.GetField("SQLPassword");
                if (l_FieldInfo != null)
                {
                    string l_strSQLPassword = l_FieldInfo.GetValue(string.Empty) as string;

                    if (l_strSQLPassword != null && l_strSQLPassword != string.Empty)
                    {
                        s_ConfigInfo.SQLPassword = l_strSQLPassword;
                    }
                }


                l_FieldInfo = l_Type.GetField("LoginServerPassword");
                if (l_FieldInfo != null)
                {
                    string l_strLoginPassword = l_FieldInfo.GetValue(string.Empty) as string;

                    if (l_strLoginPassword != null && l_strLoginPassword != string.Empty)
                    {
                        s_ConfigInfo.LoginPassword = l_strLoginPassword;
                    }
                }

                l_FieldInfo = l_Type.GetField("CharServerPassword");
                if (l_FieldInfo != null)
                {
                    string l_strCharPassword = l_FieldInfo.GetValue(string.Empty) as string;

                    if (l_strCharPassword != null && l_strCharPassword != string.Empty)
                    {
                        s_ConfigInfo.CharPassword = l_strCharPassword;
                    }
                }

                l_FieldInfo = l_Type.GetField("WorldServerPassword");
                if (l_FieldInfo != null)
                {
                    string l_strWorldPassword = l_FieldInfo.GetValue(string.Empty) as string;

                    if (l_strWorldPassword != null && l_strWorldPassword != string.Empty)
                    {
                        s_ConfigInfo.WorldPassword = l_strWorldPassword;
                    }
                }
            }

            //////////////////////////////////////////////////////////////////////////
            // 设置SQL的连接信息

            if (s_ConfigInfo.SQLConnection == string.Empty ||
                s_ConfigInfo.SQLUser == string.Empty ||
                s_ConfigInfo.SQLHost == string.Empty ||
                s_ConfigInfo.SQLDatabase == string.Empty)
            {
                s_ConfigInfo.SQLConnectionUrl = BaseDatabase.ConnectionURL;
            }
            else
            {
                BaseDatabase.ConnectionURL = s_ConfigInfo.SQLConnectionUrl = s_ConfigInfo.SQLConnection
                                                                             + "://"
                                                                             + s_ConfigInfo.SQLUser
                                                                             + ":"
                                                                             + s_ConfigInfo.SQLPassword
                                                                             + "@"
                                                                             + s_ConfigInfo.SQLHost
                                                                             //+ ( s_ConfigInfo.m_strSQLPort == 0 ? string.Empty : ":" + s_ConfigInfo.m_strSQLPort ) // 数据库引擎暂时不支持
                                                                             + "/"
                                                                             + s_ConfigInfo.SQLDatabase;
            }

            //////////////////////////////////////////////////////////////////////////
            // 开始连接数据库

            if (s_SQLRecreate == false)
            {
                BaseDatabase.BuildDefault();
            }
            else
            {
                // 重建数据库
                BaseDatabase.BuildRecreate();
            }
        }