RightControl.Repository/Permissions/RoleRepository.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using Dapper;
using RightControl.IRepository;
using RightControl.Model;
using System.Collections.Generic;
using System.Data;

namespace RightControl.Repository
{
    public class RoleRepository : BaseRepository<RoleModel>, IRoleRepository
    {
        /// <summary>
        /// 获取角色列表
        /// </summary>
        /// <returns></returns>
        public IEnumerable<RoleModel> GetRoleList()
        {
            using (var conn = SqlHelper.SqlConnection())
            {
                var sql = "SELECT Id,RoleName from t_role";
                return conn.Query<RoleModel>(sql);
            }
        }
        public bool DeleteRoleAllByRoleId(int roleId)
        {
            string sql1 = string.Format("DELETE FROM t_role WHERE Id={0}", roleId);
            string sql2 = string.Format("DELETE FROM t_menu_role_action WHERE RoleId={0}", roleId);
            using (var conn = SqlHelper.SqlConnection())
            {
                IDbTransaction transaction = conn.BeginTransaction();
                try
                {
                    conn.Execute(sql1, null, transaction);
                    conn.Execute(sql2, null, transaction);
                    transaction.Commit();
                    return true;
                }
                catch (System.Exception)
                {
                    transaction.Rollback();
                    return false;
                }
            }
        }
    }
}