OA系统

开发平台：

ASP/ASPX

company_left_menu.aspx.cs：源码内容

							﻿using System;
using System.Data;
using System.Data.SqlClient;
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 web_data_company_left_menu : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        bindtree();
    }
    public void bindtree()
    {
        TreeNode parentnode;
        TreeNode childnode;
        SqlConnection conn = dbConnection.getConnection();
        conn.Open();
        SqlCommand sqlcom = new SqlCommand("select emp_name from oa_employee where id='" + Session["user_id"] + "'", conn);
        SqlDataReader comm = sqlcom.ExecuteReader();
        if (comm.HasRows)
        {
            while (comm.Read())
            {
                parentnode = new TreeNode(comm["emp_name"].ToString(), comm["emp_name"].ToString(), "../Images/tree/folder.gif");
                parentnode.Expanded = true;
                this.TreeView1.Nodes.Add(parentnode);
                childnode = new TreeNode("已处理", "已处理", "../Images/tree/folder.gif");
                childnode.Expanded = false;
                childnode.NavigateUrl = "../data/company_deallist.aspx?id=Y&company=" + comm["emp_name"].ToString();
                childnode.Target = "mainFrame5";
                parentnode.ChildNodes.Add(childnode);
                childnode = new TreeNode("未处理", "未处理", "../Images/tree/folder.gif");
                childnode.Expanded = false;
                childnode.NavigateUrl = "../data/company_deallist.aspx?id=N&company=" + comm["emp_name"].ToString();
                childnode.Target = "mainFrame5";
                parentnode.ChildNodes.Add(childnode);
            }
        }
    }
}

						