62,054
社区成员
发帖
与我相关
我的任务
分享
# region 绑定菜单
private void BindMenu()
{
string sql;
sql = "select cSupMenuCode,cMenuCode,cMenuName,cPathURL,iSorting,cispage from u_Menu where cMenuCode in (select cMenuCode from u_Purview where cUserCode='" + ((EPG_User)Session["user"]).UserCode + "' and cView=1) and ((cSupMenuCode like '" + (Request["id"] == null ? Session["link"] : Request["id"]) + "%' or cMenuCode='" + (Request["id"] == null ? Session["link"] : Request["id"]) + "') or (cMenuCode='1')) order by iSorting,cMenuCode";
//sql = "select cSupMenuCode,cMenuCode,cMenuName,cPathURL,iSorting,cispage from u_Menu where cMenuCode in (select cMenuCode from u_Purview where cUserCode='Admin' and cView=1) and ((cSupMenuCode like '" + (Request["id"] == null ? Session["link"] : Request["id"]) + "%' or cMenuCode='" + (Request["id"] == null ? Session["link"] : Request["id"]) + "') or (cMenuCode='1')) order by iSorting,cMenuCode";
DataTable ctbl=EPG.ExecQuerySql(sql);
string aa = "";
for (int i = 0; i < ctbl.Rows.Count; i++)
{
if ((ctbl.Rows[i]["cSupMenuCode"].ToString() == null ? "-1" : ctbl.Rows[i]["cSupMenuCode"].ToString()) == "1" || (ctbl.Rows[i]["cSupMenuCode"].ToString() == null ? "-1" : ctbl.Rows[i]["cSupMenuCode"].ToString()) == "-1")
{
aa += " d.add(" + ctbl.Rows[i]["cMenuCode"].ToString() + "," + (ctbl.Rows[i]["cSupMenuCode"] == null ? "-1" : ctbl.Rows[i]["cSupMenuCode"].ToString()) + ",'" + ctbl.Rows[i]["cMenuName"] + "','','" + ctbl.Rows[i]["cMenuName"] + "','mainFrame');";
}
else
{
aa += " d.add(" + ctbl.Rows[i]["cMenuCode"] + "," + (ctbl.Rows[i]["cSupMenuCode"] == null ? "-1" : ctbl.Rows[i]["cSupMenuCode"].ToString()) + ",'" + ctbl.Rows[i]["cMenuName"].ToString() + "','" + ctbl.Rows[i]["cPathURL"] + "?MenuCode=" + ctbl.Rows[i]["cMenuCode"].ToString() + "','" + ctbl.Rows[i]["cMenuName"].ToString() + "','mainFrame');";
}
}
string outstring = "<SCRIPT type='text/javascript'>" +
"try{" +
"d = new dTree('d');" +
"d.config.closeSameLevel = true;" +
"d.config.useStatusText = true; " + aa + "document.write(d);d.closeAll();" +
"}catch(e){;}";
outstring += "</SCRIPT>";
this.LiteralMenu.Text = outstring;
}
# endregion