Sry.Solution.Data/UsersRolesPurviewsData.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Sry.Entity;
using System.Data.SqlClient;
using System.Data;
using Sry.Framework.Dal;
using Sry.Data;

namespace Sry.Solution.Data
{
    /// <summary>
    /// 用户角色权限表
    /// </summary>
    public class UsersRolesPurviewsData
    {
        public DataSet Select(List<string> list, int opt)
        {
            String sql = String.Empty;
            SqlParameter[] par = null;
            switch (opt)
            { 
                case 0:
                    //**得到指定登录名的权限值
                    sql  = @"
                    select a.users_Login,c.roles_Name,d.rpr_PurviewID from Users as a
                    join Users_Roles_Realations as b on a.users_ID=b.urr_UsersID
                    join Roles as c on b.urr_RolesID=c.roles_ID
                    join Roles_Purview_Realations as d on c.roles_ID=d.rpr_RolesID
                    where a.users_Login=@users_Login
                      ";
                    par = new SqlParameter[] { 
                        new SqlParameter("@users_Login",list[0])
                    };
                    break;
                case 1:
                    //**通过指定的ID得到最上层的FatherID
                    sql = "select dbo.func_GetFatherID(@pur_ID)";
                    par = new SqlParameter[] { 
                        new SqlParameter("@pur_ID",list[0])
                    };
                    break;
                case 2:
                    //**得到对应最上层模块的直接下级模块
                    sql = @"
                                select * from Purviews where pur_FatherID=(
                                select pur_ID from purviews where pur_FatherID=0 and pur_Name=@pur_Name)
                            ";
                    par = new SqlParameter[] { 
                        new SqlParameter("@pur_Name",list[0])
                    };
                    break;
                case 3:
                    //**得到对应最上层模块的下下级模块
                    sql = @"
                            select * from Purviews where pur_FatherID =
                            (select pur_ID from Purviews where pur_FatherID=(
                            select pur_ID from purviews where pur_FatherID=0 and pur_Name=@pur_Name)
                            )