Beispiel #1
0
        public static int updateRoleStart(string nOperatorName, int nVersionNo, long nAccountId, int nServerId, int nRoleId)
        {
            string operatorName_ = OperatorAspect.getOperator(nOperatorName, nVersionNo);

            if ("" == operatorName_)
            {
                return(ConstAspect.mOperator);
            }

            int result_ = ConstAspect.mFail;

            SqlConnection sqlConnection_ = new SqlConnection();

            sqlConnection_.ConnectionString = ConstAspect.mConnectionString;
            sqlConnection_.Open();

            SqlCommand sqlCommand_ = new SqlCommand();

            sqlCommand_.Connection  = sqlConnection_;
            sqlCommand_.CommandType = CommandType.Text;
            sqlCommand_.CommandText = string.Format(mUpdateRoleStart, nServerId, nRoleId, operatorName_, nAccountId);
            try
            {
                sqlCommand_.ExecuteNonQuery();
                result_ = ConstAspect.mSucess;
            }
            catch (SqlException)
            {
                result_ = ConstAspect.mSql;
            }
            sqlConnection_.Close();
            return(result_);
        }
Beispiel #2
0
        public static int getRoleCount(string nOperatorName, int nVersionNo, long nAccountId, int nServerId)
        {
            string operatorName_ = OperatorAspect.getOperator(nOperatorName, nVersionNo);

            if ("" == operatorName_)
            {
                return(0);
            }

            SqlConnection sqlConnection_ = new SqlConnection();

            sqlConnection_.ConnectionString = ConstAspect.mConnectionString;
            sqlConnection_.Open();

            SqlCommand sqlCommand_ = new SqlCommand();

            sqlCommand_.Connection  = sqlConnection_;
            sqlCommand_.CommandType = CommandType.Text;
            sqlCommand_.CommandText = string.Format(mRoleCount, operatorName_, nAccountId, nServerId);
            SqlDataReader sqlDataReader_ = sqlCommand_.ExecuteReader();
            int           roleCount_     = 0;

            if (sqlDataReader_.Read())
            {
                roleCount_ = sqlDataReader_.GetInt32(0);
            }
            sqlDataReader_.Close();
            sqlConnection_.Close();
            return(roleCount_);
        }
Beispiel #3
0
        public static bool createRole(string nOperatorName, int nVersionNo, long nAccountId, int nServerId, string nRoleName, short nRoleRace)
        {
            string operatorName_ = OperatorAspect.getOperator(nOperatorName, nVersionNo);

            if ("" == operatorName_)
            {
                return(false);
            }

            SqlConnection sqlConnection_ = new SqlConnection();

            sqlConnection_.ConnectionString = ConstAspect.mConnectionString;
            sqlConnection_.Open();

            SqlCommand sqlCommand_ = new SqlCommand();

            sqlCommand_.Connection  = sqlConnection_;
            sqlCommand_.CommandType = CommandType.Text;
            sqlCommand_.CommandText = string.Format(mCreateRole, operatorName_, nAccountId, nServerId, nServerId, nRoleName, nRoleRace);
            bool result_ = false;

            try
            {
                sqlCommand_.ExecuteNonQuery();
                result_ = true;
            }
            catch (SqlException)
            {
                result_ = false;
            }
            sqlConnection_.Close();
            return(result_);
        }
Beispiel #4
0
        public static ServerInfo getServerInfo(string nOperatorName, int nVersionNo, int nServerId)
        {
            initServerState(false);

            string operatorName_ = OperatorAspect.getOperator(nOperatorName, nVersionNo);

            if ("" == operatorName_)
            {
                return(null);
            }

            return(mServerStates[operatorName_].getServerInfo(nServerId));
        }
Beispiel #5
0
        public static List <ServerItem> getServerList(string nOperatorName, int nVersionNo)
        {
            initServerState(false);

            string operatorName_ = OperatorAspect.getOperator(nOperatorName, nVersionNo);

            if ("" == operatorName_)
            {
                return(null);
            }

            return(mServerStates[operatorName_].getServerList());
        }
Beispiel #6
0
        public static int getServerId(string nOperatorName, int nVersionNo)
        {
            initServerState(false);

            string operatorName_ = OperatorAspect.getOperator(nOperatorName, nVersionNo);

            if ("" == operatorName_)
            {
                return(0);
            }

            return(mServerStates[operatorName_].getServerId());
        }
Beispiel #7
0
        public static AgentInfo getIdleAgent(string nOperatorName, int nVersionNo)
        {
            initAgent(false);

            string operatorName_ = OperatorAspect.getOperator(nOperatorName, nVersionNo);

            if ("" == operatorName_)
            {
                return(null);
            }

            return(mAgentStates[operatorName_].getIdleAgent());
        }
Beispiel #8
0
        public static List <RoleItem> getRoleList(string nOperatorName, int nVersionNo, long nAccountId)
        {
            string operatorName_ = OperatorAspect.getOperator(nOperatorName, nVersionNo);

            if ("" == operatorName_)
            {
                return(null);
            }

            List <RoleItem> roleItems_ = null;

            SqlConnection sqlConnection_ = new SqlConnection();

            sqlConnection_.ConnectionString = ConstAspect.mConnectionString;
            sqlConnection_.Open();

            SqlCommand sqlCommand_ = new SqlCommand();

            sqlCommand_.Connection  = sqlConnection_;
            sqlCommand_.CommandType = CommandType.Text;
            sqlCommand_.CommandText = string.Format(mRoleList, operatorName_, nAccountId);
            SqlDataReader sqlDataReader_ = sqlCommand_.ExecuteReader();

            while (sqlDataReader_.Read())
            {
                if (null == roleItems_)
                {
                    roleItems_ = new List <RoleItem>();
                }
                RoleItem roleItem_ = new RoleItem();
                roleItem_.mServerId  = sqlDataReader_.GetInt32(0);
                roleItem_.mRoleId    = sqlDataReader_.GetInt32(1);
                roleItem_.mRoleType  = sqlDataReader_.GetInt16(2);
                roleItem_.mRoleName  = sqlDataReader_.GetString(3).Trim();
                roleItem_.mRoleRace  = sqlDataReader_.GetInt16(4);
                roleItem_.mRoleStep  = sqlDataReader_.GetInt16(5);
                roleItem_.mRoleLevel = sqlDataReader_.GetInt32(6);
                roleItems_.Add(roleItem_);
            }
            sqlDataReader_.Close();
            sqlConnection_.Close();
            return(roleItems_);
        }
Beispiel #9
0
        public static RoleItem getRoleInfo(string nOperatorName, int nVersionNo, long nAccountId, int nRoleId, int nServerId)
        {
            string operatorName_ = OperatorAspect.getOperator(nOperatorName, nVersionNo);

            if ("" == operatorName_)
            {
                return(null);
            }

            RoleItem roleItem_ = null;

            SqlConnection sqlConnection_ = new SqlConnection();

            sqlConnection_.ConnectionString = ConstAspect.mConnectionString;
            sqlConnection_.Open();

            SqlCommand sqlCommand_ = new SqlCommand();

            sqlCommand_.Connection  = sqlConnection_;
            sqlCommand_.CommandType = CommandType.Text;
            sqlCommand_.CommandText = string.Format(mRoleInfo, operatorName_, nAccountId, nRoleId, nServerId);
            SqlDataReader sqlDataReader_ = sqlCommand_.ExecuteReader();

            if (sqlDataReader_.Read())
            {
                roleItem_            = new RoleItem();
                roleItem_.mServerId  = nServerId;
                roleItem_.mRoleId    = nRoleId;
                roleItem_.mRoleType  = sqlDataReader_.GetInt16(0);
                roleItem_.mRoleName  = sqlDataReader_.GetString(1).Trim();
                roleItem_.mRoleRace  = sqlDataReader_.GetInt16(2);
                roleItem_.mRoleStep  = sqlDataReader_.GetInt16(3);
                roleItem_.mRoleLevel = sqlDataReader_.GetInt32(4);
            }
            sqlDataReader_.Close();
            sqlConnection_.Close();
            return(roleItem_);
        }