App_Code/User/AdminUser.cs

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

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

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

namespace BLL.User
{
    /// <summary>
    /// 管理员
    /// </summary>
    public class AdminUser
    {
        public AdminUser()
        {
            //
            // TODO: 在此处添加构造函数逻辑
            //
        }
        /// <summary>
        /// 验证用户角色的权限
        /// </summary>
        /// <param name="mnuid"></param>
        public static bool checkUserRole(string mnuid, string uid)
        {
            if (string.IsNullOrEmpty(mnuid))
            {   
                return false;
            }
            try
            {
                string sql = "SELECT count(*)" +
	                        " FROM Sy_RoleMnu INNER JOIN"+
	                        " Sy_Role ON Sy_RoleMnu.Sy_RoleFK = Sy_Role.PKID INNER JOIN"+
	                        " Sy_menu on Sy_RoleMnu.Sy_menufk = sy_menu.pkid INNER JOIN"+
	                        " Sy_UserRole on Sy_Role.PKID = sy_userrole.sy_rolefk inner join"+
	                        " sy_user on sy_userrole.sy_userfk = sy_user.pkid"+
	                        " where Sy_User.PKID = '{0}' and"+
                            " Sy_RoleMnu.Sy_menufk = '{1}'";

                sql = string.Format(sql,uid, mnuid);
                string iR = CSA.DAL.DBAccess.ExecuteScalar(sql).ToString();
                if (iR != "0") return true;
                else return false;
            }
            catch(Exception ex)
            {
                return false;
            }
        }
        public const string KEY = "admin_id";
        public static bool verifyUser(string uid, string pwd)
        {
            string sql = "select * from sy_user where code='" + CSA.Text.Util.getSqlStr(uid) + "'";
            DataTable dt = CSA.DAL.DBAccess.getRS(sql);