using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using Microsoft.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
namespace OAManage
{
/// <summary>
/// menu_left 的摘要说明。
/// </summary>
///
public class menu_left : System.Web.UI.Page
{
protected Microsoft.Web.UI.WebControls.TreeView tvMenu;
private SqlConnection Conn;
SqlDataAdapter myCmd;
DataSet ds;
protected System.Web.UI.WebControls.ImageButton imgbtn_AddChildNode;
protected System.Web.UI.WebControls.ImageButton imgbtn_DelNode;
protected System.Web.UI.WebControls.ImageButton imgbtn_AddRootNode;
protected System.Web.UI.WebControls.HyperLink Hyperlink5;
protected System.Web.UI.WebControls.TextBox txt_Mytext;
protected System.Web.UI.WebControls.ImageButton imgbtn_AddBrotherNode;
protected System.Web.UI.WebControls.Repeater rpt_Graduate;
string cmdSelect;
private void Page_Load(object sender, System.EventArgs e)
{ Conn=new SqlConnection(ConfigurationSettings.AppSettings["SQLConnString"].ToString());
CreateDataSet();
InitTree(tvMenu.Nodes,"0");
}
private DataSet CreateDataSet()
{
cmdSelect="select * from ccop_CourNode";
myCmd=new SqlDataAdapter(cmdSelect,Conn);
ds=new DataSet();
myCmd.Fill(ds,"tree");
return ds;
}
//建树的基本思路是:从根节点开始递归调用显示子树
private void InitTree(TreeNodeCollection Nds,string parentId)
{
DataView dv=new DataView();
TreeNode tmpNd;
string intId;
dv.Table=ds.Tables["tree"];
dv.RowFilter="pNodeID='" + parentId + "'" ;
foreach(DataRowView drv in dv)
{
tmpNd=new TreeNode();
tmpNd.ID=drv["NodeId"].ToString();
tmpNd.Text=drv["NodeText"].ToString();
tmpNd.ImageUrl="images/Node.gif";//+drv["Icon"].ToString();
tmpNd.NavigateUrl="menu_left.aspx?pNode="+drv["NodeID"].ToString();
Nds.Add(tmpNd);
intId=drv["pNodeID"].ToString();
InitTree(tmpNd.Nodes,tmpNd.ID);
}
}
void databind()
{
if ( Request.QueryString["pNode"].ToString ()!=string.Empty )
{ string PNodeID =Request.QueryString["pNode"].ToString();
string sql="select * from ccop_CourNode where pNode='" + PNodeID +"'";
}
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
}
}