nodemanage.aspx.cs

ASP动态树 可以读取数据库,非常好用.希望大家踊跃下载.

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
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 Component;
namespace JSXMLlTree
{
	/// <summary>
	/// NodeManage 的摘要说明。
	/// </summary>
	public class NodeManage : System.Web.UI.Page
	{
		//ClassConn conn = new ClassConn(System.Configuration.ConfigurationSettings.AppSettings["ConnStudy"].ToString());
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			//Response.Write("<meta http-equiv=Content-Type content=text/xml;charset=gb2312/>");
			Response.ContentType ="text/xml";
			if(!IsPostBack)
			{
				Session["CorpId"] = 1;
				string action = Request.QueryString["action"]+"";
				if(action.ToUpper() == "NODESHOW" || action.Length==0)
				{
					NodeShow();
				}
				else if(action.ToUpper() == "NODENEW")
				{
					NodeNew();
				}
				else if(action.ToUpper() == "NODEDELETE")
				{
					NodeDelete();
				}
				else if(action.ToUpper() == "NODEPOWERSHOW")
				{
					nodePowerShow();
				}
				else if(action.ToUpper() == "NODEPOWERSAVE")
				{
					NodePowerSave();
				}
			}
		}
		
		/// <summary>
		/// 输出树节点XML
		/// </summary>
		private void NodeShow()
		{
			Response.Write("<?xml version='1.0' encoding='UTF-8'?>\n");
			Response.Write("<tree id=\"0\">\n");
			//GetAllNode(Session["CorpId"].ToString(),"0"); //原来的递归输出节点
			Response.Write(NodeManager.GetAllNode(Session["CorpId"].ToString(),"0"));
			NodeManager.ClearTreeXML();
			Response.Write("</tree>");
		}


		/// <summary>
		/// 根据权限输出树节点XML
		/// </summary>
		private void nodePowerShow()
		{
			Response.Write("<?xml version='1.0' encoding='UTF-8'?>\n");
			Response.Write("<tree id=\"0\">\n");
			//GetAllNode(Session["CorpId"].ToString(),"0"); //原来的递归输出节点
			Response.Write(NodeManager.GetAllNode(Session["CorpId"].ToString(),"0"));
			NodeManager.ClearTreeXML();
			Response.Write("</tree>");
		}
		


		/// <summary>
		/// 新增节点
		/// </summary>
		private void NodeNew()
		{
			string nodeParentId = Request.QueryString["nodeParentId"]; //父节点
			string nodeText = Request.QueryString["nodeText"];
			string corpId = Session["CorpId"].ToString();
			string nodeUrl = Request.QueryString["nodeUrl"];
			string nodeUrlTarget = Request.QueryString["nodeUrlTarget"];

			Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\" ?> \n");
			Response.Write(NodeManager.InsertNode(nodeParentId,nodeText,corpId,nodeUrl,nodeUrlTarget));
		}
		/// <summary>
		/// 删除节点
		/// </summary>
		private void NodeDelete()
		{
			string nodeId = Request.QueryString["nodeId"];
			if(nodeId !=null)
			{
				Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\" ?> \n");
				Response.Write(NodeManager.DeleteNode(nodeId,Session["CorpId"].ToString()));
			}
		}
		/// <summary>
		/// 保存节点ID
		/// </summary>
		private void NodePowerSave()
		{
			string nodeIds = Request["nodeIds"]; //节点集合
			//nodeIds ="1,3.g";
			Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\" ?> \n");
			Response.Write(NodeManager.SaveNodeIds(nodeIds,Session["EmployeeId"].ToString()));
			//Response.Write(NodeManager.SaveNodeIds(nodeIds,"1"));
		}
		#region//原来的递归输出子节点.
//		private void GetAllNode(string corpId,string parentId)
//		{
//			string sql  = "SELECT id,DeptParentId,DeptName,DeptCorpId,DeptType,DeptUrl,DeptUrlTarget FROM Study_Department "
//				+ " WHERE DeptCorpid = @CorpId  AND DeptParentId =@ParentId "
//				+ " ORDER BY  DeptShowIndex ASC";
//			SqlParameter parmCorpId = conn.MakeParam("@CorpId",corpId);
//			SqlParameter parmParentId = conn.MakeParam("@ParentId",parentId);
//			SqlParameter [] parms = new SqlParameter[]{parmCorpId,parmParentId};
//			DataTable dataTable = null;
//			conn.RunSql(sql,parms,out dataTable);
//			if(dataTable.Rows.Count>0)
//			{
//				for(int i= 0;i<dataTable.Rows.Count;i++)
//				{
//					DataRow row = dataTable.Rows[i];
//					Response.Write("<item id=\"" + row["id"].ToString()+"\" text=\"" +  row["deptName"].ToString()+ "\"  url=\""
//						+ row["deptUrl"].ToString()+"\"  target=\""+ row["deptUrlTarget"].ToString()+"\">\n");
//					sql  = "SELECT count(1) FROM Study_Department "
//						+ " WHERE DeptCorpid = "+corpId+" AND DeptParentId ="+row["id"].ToString();
//
//					conn.strSql = sql;
//					if(conn.GetRsCount()>0)
//					{
//						GetAllNode(corpId,row["id"].ToString());
//					}
//					Response.Write("</item>\n");
//				}
//				//Response.Write("");
//			}
//		}
		#endregion
		#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
	}
}