树形.txt

关于编辑vb树形结构的vb源代码

protected Microsoft.Web.UI.WebControls.TreeView trvAptm;

		/// <summary>
		/// 初始化方法
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void Page_Load(object sender, System.EventArgs e)
		{	/*树的单击展开*/
			trvAptm.Attributes.Add("ondblclick","treeDblclick(this);");
			//从Session对象中取出登录公司的ID号
			int iCorpID = (Int32)Session["CorpID"];		

			//做出房源树
			string strSql = "Select ID,Name From Corp "
				 + "Where DoFlag=1 And ID="+iCorpID.ToString();

			DataTable dtCorp = DataCenter.GetDataTable(strSql);

			for(int i=0;i<dtCorp.Rows.Count;i++)
			{
				/*将公司加在树的第一层*/
				TreeNode trnCorp    = new TreeNode();
				trnCorp.Text        = dtCorp.Rows[i]["Name"].ToString();
				trnCorp.Target      = "frmRgt";
				trnCorp.ImageUrl	= "../../Img/key.gif";
				trnCorp.NavigateUrl = "./Comu/Default.aspx?id="+dtCorp.Rows[i]["ID"].ToString();
				trnCorp.Expanded	= true;
				trvAptm.Nodes.Add(trnCorp);

				/*将小区加在所属公司下*/

				string strComu    = "Select ID,Num,Name From Community Where DoFlag=1 And CorpID="+dtCorp.Rows[i]["ID"].ToString()+" Order by ID DESC";
				DataTable dtComu  = DataCenter.GetDataTable(strComu);
				
				for(int j=0;j<dtComu.Rows.Count;j++)
				{
					TreeNode trnComu    = new TreeNode();
					trnComu.Text        = dtComu.Rows[j]["Name"].ToString();
					trnComu.Target      = "frmRgt";
					trnComu.ImageUrl	= "../../Img/note.gif";
					trnComu.NavigateUrl = "./Build/Default.aspx?id="+dtComu.Rows[j]["ID"].ToString();
					trnCorp.Nodes.Add(trnComu);

					/*将楼房加在所属小区下*/
					string strBuild   = "Select ID,Num,Name From Building Where  DoFlag=1 And ComuID="+dtComu.Rows[j]["ID"].ToString()+" Order by Num Asc";
					DataTable dtBuild = DataCenter.GetDataTable(strBuild);
					
					for(int k=0;k<dtBuild.Rows.Count;k++)
					{
						TreeNode trnBuild    = new TreeNode();
						trnBuild.Text        = dtBuild.Rows[k]["Name"].ToString();
						trnBuild.Target      = "frmRgt";
						trnBuild.ImageUrl    = "../../Img/housey.gif";
						trnBuild.NavigateUrl = "./Apartment/Default.aspx?id="+dtBuild.Rows[k]["ID"].ToString();

						trnComu.Nodes.Add(trnBuild);
					}
				}
			}
		}