Esempio n. 1
0
        /// <summary>
        /// 查询用户所属的菜单信息
        /// </summary>
        /// <param name="userno">用户编码</param>
        /// <returns></returns>
        public List <sysmenu> QueryMenus(string userno)
        {
            SysUserRoleDal userroledal = new SysUserRoleDal();
            sysuser_role   userrole    = new sysuser_role()
            {
                userno = userno, roleno = "Administrator"
            };

            userrole = userroledal.QueryEntity(userrole);
            string strSQL = "select a.* from sysmenu a order by a.menusort";
            List <DBMemberEntity> entitys = new List <DBMemberEntity>();

            if (userrole == null)
            {
                strSQL = @"select a.*
                             from sysmenu a,sysuser_role b,sysrole_menu c
                            where a.menuno = c.menuno
                              and c.roleno = b.roleno
                              and b.userno = @userno
                            order by a.menusort";
                entitys.AddMember("userno", userno);
            }
            DataSet        ds    = dbhelper.Query(strSQL, entitys);
            List <sysmenu> menus = new List <sysmenu>();

            if (ds != null && ds.Tables.Count > 0)
            {
                menus = ModelHelper.ToModel <List <sysmenu> >(ds.Tables[0]);
            }
            return(menus);
        }
Esempio n. 2
0
        /// <summary>
        /// 获得用户对应菜单的权限
        /// </summary>
        /// <param name="userno">用户编号</param>
        /// <param name="menuno">菜单编号</param>
        /// <returns></returns>
        public List <syspower> QueryUserPower(string userno, string menuno)
        {
            SysUserRoleDal userroledal = new SysUserRoleDal();
            sysuser_role   userrole    = new sysuser_role()
            {
                userno = userno, roleno = "Administrator"
            };

            userrole = userroledal.QueryEntity(userrole);
            string strSQL = @"select a.* 
                                from syspower a,sysmenu_power b
                               where a.powerno = b.powerno
                                 and b.menuno = @menuno";
            List <DBMemberEntity> entitys = new List <DBMemberEntity>();

            if (userrole == null)
            {
                strSQL = @"select d.*
                             from syspower a,sysuser_role b,sysrole_menu c,sysrole_menu_power d
                            where b.roleno = c.roleno
                              and c.roleno = d.roleno
                              and c.menuno = d.menuno
                              and d.powerno = a.powerno
                              and b.userno = @userno
                              and c.menuno = @menuno";
                entitys.AddMember("userno", userno);
                entitys.AddMember("menuno", menuno);
            }
            else
            {
                entitys.AddMember("menuno", menuno);
            }
            DataSet         ds     = dbhelper.Query(strSQL, entitys);
            List <syspower> powers = new List <syspower>();

            if (ds != null && ds.Tables.Count > 0)
            {
                powers = ModelHelper.ToModel <List <syspower> >(ds.Tables[0]);
            }
            return(powers);
        }