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

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

OA系统

开发平台：

ASP/ASPX

resource_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_resource_left_menu : 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.     public void BindTree()
  30.     {
  31.         SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["oaconnection"].ConnectionString);
  32.         SqlDataAdapter sda = new SqlDataAdapter("select a.id,name,menu_url,parent_id,target,is_open,is_dir from oa_sys_child_menu" +
  33.             " 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" +
  34.             " a.id=16 and c.id=" + Session["user_id"], con);
  35.         DataSet ds = new DataSet();
  36.         sda.Fill(ds, "1");
  38.         TreeNode parentnode;
  39.         TreeNode childnode;
  40.         TreeNode townnode;
  41.         TreeNode townnode1;
  42.         //TreeView1.ShowLines = true;
  43.         foreach (DataRow parentrow in ds.Tables["1"].Rows)
  44.         {
  45.             //绑定第一层节点
  46.             parentnode = new TreeNode(parentrow["name"].ToString(), parentrow["id"].ToString(), "../Images/tree/folder.gif");
  47.             //运行时候先不展开子节点
  48.             parentnode.Expanded = true;
  49.             parentnode.NavigateUrl = (parentrow["menu_url"]).ToString();
  50.             parentnode.Target = (parentrow["target"]).ToString();
  51.             TreeView1.Nodes.Add(parentnode);
  52.             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 " +
  53.                 "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);
  54.             adapter.Fill(ds, "2");
  56.             if (ds.Tables["2"].Rows.Count > 0)
  57.             {
  58.                 //绑定第二层节点
  59.                 foreach (DataRow childrow in ds.Tables["2"].Rows)
  60.                 {
  61.                     childnode = new TreeNode(childrow["name"].ToString(), childrow["id"].ToString(), "../Images/tree/folder.gif");
  62.                     parentnode.ChildNodes.Add(childnode);
  64.                     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" +
  65.                         " 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() , con);
  66.                     adapter2.Fill(ds, "3");
  67.                     childnode.Expanded = true;
  68.                     childnode.NavigateUrl = childrow["menu_url"].ToString();
  69.                     childnode.Target = (childrow["target"]).ToString();
  70.                     if (ds.Tables["3"].Rows.Count > 0)
  71.                     {
  72.                         //绑定第三层节点
  73.                         foreach (DataRow townrow in ds.Tables["3"].Rows)
  74.                         {
  75.                             townnode = new TreeNode(townrow["name"].ToString(), townrow["id"].ToString(), "../Images/tree/folder.gif");
  77.                             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" +
  78.                                 " 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() , con);
  79.                             adapter3.Fill(ds, "4");
  80.                             townnode.Expanded = false;
  81.                             childnode.ChildNodes.Add(townnode);
  82.                             townnode.NavigateUrl = (townrow["menu_url"]).ToString();
  83.                             townnode.Target = (townrow["target"]).ToString();
  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.                                     townnode1.NavigateUrl = (townrow1["menu_url"]).ToString();
  91.                                     townnode1.Target = (townrow1["target"]).ToString();
  92.                                 }
  93.                                 ds.Tables["4"].Clear();
  94.                             }
  95.                         } ds.Tables["3"].Clear();
  96.                     }
  97.                 }
  98.                 ds.Tables["2"].Clear();
  99.             }
  100.         }
  101.         con.Close();
  102.     }
  103. }