DAL/SysPrivilegesService.cs

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

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

using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using Model;
namespace DAL
{
	/// <summary>
	/// 数据访问类SysPrivilegesService。
	/// </summary>
	public class SysPrivilegesService
	{
		public SysPrivilegesService()
		{}
		#region  成员方法
        /// <summary>
        /// 获取子权限信息总数量
        /// </summary>
        /// <param name="levelNo"></param>
        /// <returns></returns>
        public static int GetSonCount(int roleId, int departId)
        {
            string sql = "select count(levelNo) from SysPrivileges where roleId = " + roleId + " and departmentId = " + departId + " and parentLevelNo <> 0";
            object obj = DBHelperSQL.GetSingle(sql);
            return Convert.ToInt32(obj);
        }


        /// <summary>
        /// 获取子权限信息
        /// </summary>
        /// <param name="levelNo"></param>
        /// <returns></returns>
        public static DataSet GetSonInfo(int roleId,int departId,int levelNo) 
        {
            string sql = "select levelNo from SysPrivileges where roleId = " + roleId + " and departmentId = " + departId + " and parentLevelNo = " + levelNo;
            return DBHelperSQL.Query(sql);
        }

        /// <summary>
        /// 根据角色id和部门id以及起始LevelNo获取左侧权限信息
        /// </summary>
        /// <param name="roleId"></param>
        /// <param name="departId"></param>
        /// <returns></returns>
        public static DataSet GetLeftInfo(int roleId, int departId,int startLevelNo,int endLevelNo)
        {
            string sql = "select * from SysPrivileges where roleId = " + roleId + " and departmentId = " + departId + " and levelNo between " + startLevelNo + " and " + endLevelNo;
            return DBHelperSQL.Query(sql);
        }

        /// <summary>
        /// 根据角色id和部门id获取权限信息（头部的）
        /// </summary>
        /// <param name="roleId"></param>
        /// <param name="departId"></param>
        /// <returns></returns>
        public static DataSet GetLevelInfo(int roleId,int departId)
        {
            string sql = "select * from SysPrivileges where roleId = " + roleId + " and departmentId = " + departId + " and levelNo < 90 order by levelNo asc";