ad88/getRootMenu.aspx.cs

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

using System;
using System.Data;
using System.Configuration;
using System.Collections;
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;

public partial class admin_getRootMenu : Page
{
    public DataTable dt = new DataTable();
    protected void Page_Load(object sender, EventArgs e)
    {
        string sql = "select c.code,c.name from sy_roleMnu a" +
                    " inner join Sy_Role b on a.sy_roleFK=b.pkid" +
                    " inner join Sy_Menu c on a.sy_menuFK=c.pkid" +
                    " inner join Sy_userrole d on d.sy_roleFK=b.pkid" +
                    " where d.sy_userFK='{0}' and len(c.code)=2" +
                    " group by c.code,c.name,c.SortNo" +
                    " order by c.SortNo,c.code";

        string userfk = BLL.User.AdminUser.getLoginInfo()["pkid"].ToString();
        sql = string.Format(sql, userfk);
        dt = CSA.DAL.DBAccess.getRS(sql);
    }
}