Core/SM/Bll/RoleByUserBll.cs

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

using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using Common.Provider;
using Core.SM.Dal;
using Common;
using Newtonsoft.Json.Linq;
using Core.SM.Model;
using Common.Data.SqlServer;
using System.Data;
using Common.Data;
using Common.Data.Filter;

namespace Core.SM.Bll
{
    public class RoleByUserBll
    {
        public static RoleByUserBll Instance
        {
            get { return SingletonProvider<RoleByUserBll>.Instance; }
        }

        /// <summary>
        /// 判斷角色授權存在
        /// </summary>
        /// <param name="roleid">角色KeyId</param>
        /// <param name="userid">用戶KeyId</param>
        /// <param name="keyid">KeyId</param>
        /// <returns></returns>
        
        public bool HasRoleByUser(int roleid, int userid, int keyid = 0)
        {
            var allRoles = from n in RoleByUserDal.Instance.GetAll()
                           where n.RoleId == roleid && n.UserId == userid && n.KeyId != keyid
                           select n;
            return allRoles.Any();
        }





    }
}