Exemplo n.º 1
0
        /// <summary>
        /// 根据uid获取用户角色信息
        /// </summary>
        /// <param name="uid"></param>
        /// <returns></returns>
        public static List <UserRole> GetUserRoleInfoByUid(Guid uid)
        {
            List <UserRole> list  = new List <UserRole>();
            IDbConnection   conn  = null;
            IDbCommand      cmd   = null;
            IDbTransaction  trans = null;

            try
            {
                IUserRole dp = DataProvider.DbUserRoleDP;
                conn = DbConnOperation.CreateMySqlConnection();
                cmd  = conn.CreateCommand();
                conn.Open();
                trans           = conn.BeginTransaction();
                cmd.Transaction = trans;
                list            = dp.GetUserRoleByUid(cmd, uid);
                trans.Commit();
            }
            catch (Exception ex)
            {
                if (trans != null)
                {
                    trans.Rollback();
                }
                log.Error(string.Format("GetUserRoleByUid()出错,错误信息如下:{0}", ex.Message));
            }
            finally
            {
                if (conn != null)
                {
                    conn.Close();
                }
            }
            return(list);
        }