开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > OA系统 > 查看源码
k_left_menu.aspx.cs
资源名称：web.rar　[点击查看]
上传用户：xrffrp
上传日期：2022-03-25
资源大小：22155k
文件大小：5k
源码类别：

OA系统

开发平台：

ASP/ASPX

k_left_menu.aspx.cs：源码内容
  1. using System;
  2. using System.Data;
  3. using System.Configuration;
  4. using System.Collections;
  5. using System.Web;
  6. using System.Web.Security;
  7. using System.Web.UI;
  8. using System.Web.UI.WebControls;
  9. using System.Web.UI.WebControls.WebParts;
  10. using System.Web.UI.HtmlControls;
  11. using System.Data.SqlClient;
  13. public partial class web_Default : System.Web.UI.Page
  14. {
  15.     protected void Page_Load(object sender, EventArgs e)
  16.     {
  17.         if (Session["user_id"] == null)
  18.         {
  19.             Response.Write("<script>window.open('login.aspx','_top');</script>");
  20.         }
  21.         if (!IsPostBack)
  22.         {
  23.             if (Session["user_id"] != null)
  24.             {
  25.                 BindTree();
  26.             }
  27.             
  28.         }
  29.     }
  30.     public void BindTree()
  31.     {
  32.         SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["oaconnection"].ConnectionString);
  33.         SqlDataAdapter sda = new SqlDataAdapter("select a.id,name,menu_url,parent_id,target,is_open,is_dir from oa_sys_child_menu as a left join oa_user_group_detail as b on a.id=b.menu_id left join oa_employee as c on b.main_id=c.user_group where a.id=8 and c.id="+Session["user_id"] , con);
  34.         DataSet ds = new DataSet();
  35.         sda.Fill(ds, "1");
  37.         TreeNode parentnode;
  38.         TreeNode childnode;
  39.         TreeNode townnode;
  40.         TreeNode townnode1;
  41.         //TreeView1.ShowLines = true;
  42.         foreach (DataRow parentrow in ds.Tables["1"].Rows)
  43.         {
  44.             //绑定第一层节点
  45.             parentnode = new TreeNode(parentrow["name"].ToString(), parentrow["id"].ToString(), "../Images/tree/folder.gif");
  46.             //运行时候先不展开子节点
  47.             parentnode.Expanded = true;
  48.             parentnode.NavigateUrl = (parentrow["menu_url"]).ToString();
  49.             parentnode.Target = (parentrow["target"]).ToString();
  50.             TreeView1.Nodes.Add(parentnode);
  51.             SqlDataAdapter adapter = new SqlDataAdapter("select a.id,name,menu_url,parent_id,target,is_open,is_dir from oa_sys_child_menu as a left join oa_user_group_detail as b on a.id=b.menu_id left join oa_employee as c on b.main_id=c.user_group where parent_id =" + parentrow["id"].ToString()+"and c.id="+Session["user_id"], con);
  52.             adapter.Fill(ds, "2");
  54.             if (ds.Tables["2"].Rows.Count > 0)
  55.             {
  56.                 //绑定第二层节点
  57.                 foreach (DataRow childrow in ds.Tables["2"].Rows)
  58.                 {
  59.                     childnode = new TreeNode(childrow["name"].ToString(), childrow["id"].ToString(), "../Images/tree/folder.gif");
  60.                     parentnode.ChildNodes.Add(childnode);
  62.                     SqlDataAdapter adapter2 = new SqlDataAdapter("select a.id,name,menu_url,parent_id,target,is_open,is_dir from oa_sys_child_menu as a left join oa_user_group_detail as b on a.id=b.menu_id left join oa_employee as c on b.main_id=c.user_group where parent_id=" + childrow["id"].ToString()+"and c.id="+Session["user_id"], con);
  63.                     adapter2.Fill(ds, "3");
  64.                     childnode.Expanded = false;
  65.                     childnode.NavigateUrl = childrow["menu_url"].ToString();
  66.                     childnode.Target = childrow["menu_url"].ToString();
  68.                     if (ds.Tables["3"].Rows.Count > 0)
  69.                     {
  70.                         //绑定第三层节点
  71.                         foreach (DataRow townrow in ds.Tables["3"].Rows)
  72.                         {
  73.                             townnode = new TreeNode(townrow["name"].ToString(), townrow["id"].ToString(), "../Images/tree/folder.gif");
  74.                             childnode.ChildNodes.Add(townnode);
  75.                             townnode.NavigateUrl = (townrow["menu_url"]).ToString();
  76.                             townnode.Target = (townrow["target"]).ToString();
  78.                             SqlDataAdapter adapter3 = new SqlDataAdapter("select a.id,name,menu_url,parent_id,target,is_open,is_dir from oa_sys_child_menu as a left join oa_user_group_detail as b on a.id=b.menu_id left join oa_employee as c on b.main_id=c.user_group where parent_id=" + townrow["id"].ToString()+"and c.id="+Session["user_id"], con);
  79.                             adapter3.Fill(ds, "4");
  80.                             townnode.Expanded = false;
  81.                             townnode.NavigateUrl = (townrow["menu_url"]).ToString();
  82.                             townnode.Target = (townrow["target"]).ToString();
  83.                             
  84.                             if (ds.Tables["4"].Rows.Count > 0)
  85.                             {
  86.                                 foreach (DataRow townrow1 in ds.Tables["4"].Rows)
  87.                                 {
  88.                                     townnode1 = new TreeNode(townrow1["name"].ToString(), townrow1["id"].ToString(), "../Images/tree/folder.gif");
  89.                                     townnode.ChildNodes.Add(townnode1);
  90.                                    
  91.                                 }
  92.                                 ds.Tables["4"].Clear();
  93.                             }
  94.                         } ds.Tables["3"].Clear();
  95.                     }
  96.                 }
  97.                 ds.Tables["2"].Clear();
  98.             }
  99.         }
  100.         con.Close();
  101.     }
  102. }