Web扩充控件（二）-------树型控件使用

最新推荐文章于 2024-12-09 10:08:48 发布

转载最新推荐文章于 2024-12-09 10:08:48 发布 · 614 阅读

文章标签：

#web #database #join #string #数据库 #access

本文介绍了两种树型控件的使用方法：梅花雪树型控件和微软自带的Treeview控件。梅花雪树型控件适用于大数据量场景，而Treeview控件则在小数据量下表现优秀。文中详细展示了如何生成用于控件展示的数据文件。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

现在树型控件使用越来越广泛，这里简要介绍一下Treeview和梅花雪树型控件的使用。不对之处，还请大家不吝指正。

1.梅花雪树型控件
在大数据量上效率比Treeview高不少，像优快云上都用它。
以下是生成向ACCESS数据库导入数据的文件方法
using System;
using System.Data;
using System.Collections;
using System.Drawing;
using System.Web;
using System.Web.UI;
using System.Data.SqlClient;
using System.IO;

namespace My.Components
{
/// <summary>
/// XMLControl 的摘要说明。
/// </summary>
public class XMLControl
{
protected Database db;

  public XMLControl()
  {
   //
   // TODO: 在此处添加构造函数逻辑
   //
   db=new Database();//数据库操作类
  }
#region 写 TXT 文件的内容
  //=======================================================================================================||
  //写 TXT 文件的内容显示控制
  public string creatTxt()
  {
   ArrayList StateID = new ArrayList();
   ArrayList CountryId= new ArrayList();
   ArrayList CountryName=new ArrayList();

   ArrayList StateName=new ArrayList();
   ArrayList CityID   = new ArrayList();
   ArrayList AreaName = new ArrayList();
   ArrayList AreaID   = new ArrayList();
   ArrayList CityName = new ArrayList();
   ArrayList CityStateId=new ArrayList();
   ArrayList StateCountryId=new ArrayList();


   string strJs     = "ID,parentId,text,hint,icon,data,url,target,method/n";

   //加上顶层世界的树型节点的主目录
   strJs=strJs+"1,0,all over the world,all over the world,,,http://localhost/test/main.aspx?id=1,main,/n";
   //strJs = strJs + "<Troot> /n";

   //取得所有国家编号列表，保存到数组CountryId中
   SqlDataReader drCountry =db.Reader("select * from country Order By country_Name ASC");
   if(drCountry.HasRows)
   {
    while(drCountry.Read())
    {
     CountryId.Add((1000-int.Parse(drCountry["country_Id"].ToString())).ToString());

     CountryName.Add(drCountry["country_name"].ToString());
    }
    for(int i=0;i<=CountryId.Count-1;i++)
    {
     strJs = strJs+CountryId[i]+",1,"+CountryName[i]+","+CountryName[i]+",,,http://localhost/test/main.aspx? id="+CountryId[i]+",main,alert('欢迎网页脚本控件集-MzTreeView10')/n";
    }
   }

   //取得所有州编号列表，保存到数组StateID中
   SqlDataReader drState =db.Reader("select * from state left join country on state_countryid=country_id Order By state_Name ASC");
   if(drState.HasRows)
   {
    while(drState.Read())
    {
     StateID.Add((100000-int.Parse(drState["state_Id"].ToString())).ToString());
     StateCountryId.Add((1000-int.Parse(drState["state_countryid"].ToString())).ToString());

     StateName.Add(drState["state_name"].ToString());
    }
    for(int i=0;i<=StateID.Count-1;i++)
    {
     //strJs = strJs + "    <Item id=/""+StateID[i]+"/" pid=/""+StateCountryId[i]+"/">"+StateName[i]+"</Item>/n";
     strJs = strJs+StateID[i]+","+StateCountryId[i]+","+StateName[i]+","+StateName[i]+",,,http://localhost/test/main.aspx?id="+StateID[i]+",main,/n";
    }
   }

   //取得所有城市编号列表，保存到数组CityID中
   SqlDataReader drCity = db.Reader("SELECT * FROM city left join state on city_statid=state_id Order By city_Name ASC");
   CityID.Clear();
   if (drCity.HasRows)
   {
    while (drCity.Read())
    {
     CityID.Add ((10000000-int.Parse(drCity["city_Id"].ToString())).ToString());
     CityName.Add(drCity["city_Name"].ToString());
     //StateID.Add((100000-int.Parse(drCity["state_Id"].ToString())).ToString());
     StateName.Add(drCity["state_name"].ToString());
     CityStateId.Add((100000-int.Parse(drCity["city_statId"].ToString())).ToString());
    }


    for (int i=0;i<=CityID.Count-1;i++)
    {
     CityName[i].ToString().Replace("&","/");

     //strJs = strJs + "    <Item id=/""+CityID[i]+"/" pid=/""+CityStateId[i]+"/">"+CityName[i]+"</Item>/n";
     strJs = strJs+CityID[i]+","+CityStateId[i]+","+CityName[i]+","+CityName[i]+",,,http://localhost/test/main.aspx?id="+CityID[i]+",main,/n";
     SqlDataReader drArea = db.Reader("SELECT * FROM area left join city on area_cityid=city_id left join state on city_statid=state_id left join country on state_countryid=country_id Where area_cityid='"+(10000000-int.Parse((CityID[i]).ToString()))+"' Order By area_Name ASC");
     AreaName.Clear();
     AreaID.Clear();

     if (drArea.HasRows)
     {
      while (drArea.Read())
      {
       AreaName.Add(drArea["area_Name"].ToString());
       AreaID.Add((1000000000-int.Parse(drArea["area_Id"].ToString())).ToString());

      }
      drArea.Close();
      for (int j=0;j<=AreaID.Count-1;j++)
      {
       //strJs = strJs + "    <Item id=/""+AreaID[j].ToString()+"/" pid=/""+CityID[i]+"/">"+AreaName[j].ToString()+"</Item> /n";
       strJs = strJs+AreaID[j]+","+CityID[i]+","+AreaName[j]+","+AreaName[j]+",,,http://localhost/test/main.aspx?id="+AreaID[j]+",main,/n";
      }
     }
    }
   }
   strJs = strJs + "/n";
   drCountry.Close();
   drState.Close();
   drCity.Close();

   return strJs;
  }
  #endregion

  #region 生成往Access库中到数据的 TXT 文件
  public void creTxt(Page objPage)
  {
   StreamWriter sw = new StreamWriter(objPage.MapPath("../Inc/txtAll.txt"),false,System.Text.Encoding.UTF8);
   sw.Write(this.creatTxt());
   sw.Flush();
   sw.Close();
  }
  #endregion

}
}

2.微软自带的Treeview控件
特点：感觉可能对浏览器的兼容性可能较好，小数据量速度不错
以下是生成绑定的XML的文件的方法：

using System;
using System.Data;
using System.Collections;
using System.Drawing;
using System.Web;
using System.Web.UI;
using System.Data.SqlClient;
using System.IO;

namespace My.Components
{
/// <summary>
/// XMLControl 的摘要说明。
/// </summary>
public class XMLControl
{
protected Database db;

  public XMLControl()
  {
   //
   // TODO: 在此处添加构造函数逻辑
   //
   db=new Database();//数据库操作类
  }
#region 写 TreeView 三级XML的内容
  //=======================================================================================================||
  //页面城市、地区显示控制
  public string TreeView_3()
  {
   ArrayList StateID = new ArrayList();
   ArrayList StateName=new ArrayList();
   ArrayList CityID   = new ArrayList();
   ArrayList AreaName = new ArrayList();
   ArrayList AreaID   = new ArrayList();
   ArrayList CityName = new ArrayList();
   ArrayList CityStateId=new ArrayList();


   string strJs     = "<?xml version=/"1.0/" encoding=/"utf-8/" ?>/n";
   strJs = strJs + "<TREENODES> /n";

   //取得所有州编号列表，保存到数组StateID中
   SqlDataReader drState =db.Reader("select * from state where state_countryid='3' Order By state_Name ASC");
   StateID.Clear();
   if(drState.HasRows)
   {
    while(drState.Read())
    {
     StateID.Add((100000-int.Parse(drState["state_Id"].ToString())).ToString());
     StateName.Add(drState["state_name"].ToString());
    }
    for(int i=0;i<=StateID.Count-1;i++)
    {
     strJs = strJs + "    <treenode Text=/""+StateName[i]+"/" value=/""+StateID[i]+"/">/n";

     //取得所有城市编号列表，保存到数组CityID中

     SqlDataReader drCity = db.Reader("SELECT * FROM city where city_statid='"+(100000-int.Parse(StateID[i].ToString()))+"' Order By city_Name ASC");
     CityID.Clear();
     if (drCity.HasRows)
     {
      while (drCity.Read())
      {
       CityID.Add ((10000000-int.Parse(drCity["city_Id"].ToString())).ToString());
       CityName.Add(drCity["city_Name"].ToString());
      }


      for (int j=0;j<=CityID.Count-1;j++)
      {
              strJs = strJs + "        <treenode Text=/""+CityName[j]+"/" value=/""+CityID[j]+"/"></treenode> /n";
      }
     }
     //drCity.Close();
     strJs =strJs +"</treenode>/n";
    }
   }

   strJs = strJs + "</TREENODES> /n";
   //drState.Close();


   return strJs;
  }
  #endregion

  #region 生成TreeView XML 文件
  public void treeAu3(Page objPage)
  {
   StreamWriter sw = new StreamWriter(objPage.MapPath("../Inc/treeAU3.xml"),false,System.Text.Encoding.UTF8);
   sw.Write(this.TreeView_3());
   sw.Flush();
   sw.Close();
  }
  #endregion

}
}