DAL.MSSQL/DAL_Admin/Role.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

using System.Data.SqlClient;
using System.Data;
namespace DAL.MSSQL.DAL_Admin
{
    public class Role:IDAL.IDAL_Admin.IRole
    {

        /// <summary>
        /// 获取角色下的所有用户
        /// </summary>
        /// <param name="order"></param>
        /// <param name="pageSize"></param>
        /// <param name="pageIndex"></param>
        /// <param name="where"></param>
        /// <param name="totalCount"></param>
        /// <returns></returns>
        public DataTable Get_Search_User(string order, int pageSize, int pageIndex, string where, out int totalCount)
        {
            string tableName = " Sys_User right join Sys_User_Role  on Sys_User.id=Sys_User_Role.user_id ";
            string columns = "  us_id as name,us_is_start as enable,us_is_edit_pwd as is_edit_pwd,us_add_time as add_time ";
            return SqlPagerHelper.Get_Pagers(tableName, columns, order, pageSize, pageIndex, where, out totalCount);
        }

        /// <summary>
        /// 查询所有角色
        /// </summary>
        /// <returns></returns>
       public DataTable Get_Search()
        {
            StringBuilder sb = new StringBuilder();
            sb.Append(" select id,ro_name as name,ro_remarks as remarks,ro_add_time as add_time from Sys_Role ");
            return SqlHelper.GetDataTable(SqlHelper.connStr, CommandType.Text, sb.ToString(), null);
        }

        /// <summary>
        /// 获取角色列表 （下拉框模式）
        /// </summary>
        /// <returns></returns>
        public DataTable Get_Search_a()
        {
            StringBuilder sb = new StringBuilder();
            sb.Append(" Select ro_name as text,id from Sys_Role");

            return SqlHelper.GetDataTable(SqlHelper.connStr, CommandType.Text, sb.ToString(), null);
        }

        /// <summary>
        /// 给角色分配菜单
        /// </summary>
        /// <param name="menu_button_id">格式为"menu_id butto_id,menu_id button_id"</param>
        /// <param name="role_id"></param>
        /// <returns></returns>
        public bool Set_Role_Menu(string menu_button_id, int role_id)
        {