#region 声明
//----------------------------------------------------------------------
//
// 作者: 李淼（Nick.Lee）
//
// ASP.NET环境下完整的treeview控件使用方案类
//
// 时间:2005-2-17
// boyorgril@msn.com
// QQ:16503096
//
//----------------------------------------------------------------------
#endregion
using System;
#region 自定义命名空间(可重用)
//调用本身函数引用命名空间
using NickLee.Web.UI;
using System.Data;
#endregion

namespace NickLee.Web.UI
{
/// <summary>
/// menuFill 的摘要说明。
/// </summary>
public class menuFill
{

#region 类公共属性和私有属性
webDataFill topFill=new webDataFill();
webDataFill secFill=new webDataFill();
webDataFill thirdFill=new webDataFill();

private string topMenu;
private string secMenu;
private string thirdMenu;
#endregion

#region 设定属性条件参数

/// <summary>
/// 一级菜单sql语句,例：“select * from baseData_topMenu order by topMenu_Pk;”
/// </summary>
public string sqltopMenuString
{
get{ return topMenu;}
set{ topMenu=value;}
}

/// <summary>
/// 二级菜单sql语句,例：“select * from baseData_secMenu where topMenu_PK=”
/// </summary>
public string sqlsecMenuString
{
get{ return secMenu; }
set{ secMenu=value; }
}

/// <summary>
/// 三级菜单sql语句,例：“select * from baseData_thirdMenu where secMenu_PK=”
/// </summary>
public string sqlthirdMenuString
{
get{ return thirdMenu; }
set{ thirdMenu=value; }
}

#endregion

public menuFill()
{
//
// TODO: 在此处添加构造函数逻辑
//
#region 构造函数初始定义


topFill.ConString=System.Configuration.ConfigurationSettings.AppSettings["SqlConnectionString"];
secFill.ConString=System.Configuration.ConfigurationSettings.AppSettings["SqlConnectionString"];
thirdFill.ConString=System.Configuration.ConfigurationSettings.AppSettings["SqlConnectionString"];

topFill.dataTableName="topFill";
secFill.dataTableName="secFill";
thirdFill.dataTableName="thirdFill";
#endregion
}


#region treeview分级显示，用datareader
/*
*
* private void treeviewReader()
{
webDataFill fil1=new webDataFill();
webDataFill fil2=new webDataFill();
webDataFill fil3=new webDataFill();
fil1.ConString="server=localhost;uid=sa;pwd=sa;database=northwind;";
fil2.ConString="server=localhost;uid=sa;pwd=sa;database=northwind;";
fil3.ConString="server=localhost;uid=sa;pwd=sa;database=northwind;";

fil1.sqlQueryString="SELECT CategoryID, CategoryName FROM Categories";
fil1.sqlClientDataReader();

while(fil1.mySqlReader.Read())
{
Microsoft.Web.UI.WebControls.TreeNode topNode=new Microsoft.Web.UI.WebControls.TreeNode();
topNode.ID=fil1.mySqlReader["CategoryID"].ToString();
topNode.Text=fil1.mySqlReader["CategoryName"].ToString();
TreeView1.Nodes.Add(topNode);

fil2.sqlQueryString = "SELECT ProductID, ProductName FROM Products where categoryID="+Convert.ToInt32(fil1.mySqlReader["CategoryID"]);
fil2.sqlClientDataReader();
while(fil2.mySqlReader.Read())
{
Microsoft.Web.UI.WebControls.TreeNode nextNode=new Microsoft.Web.UI.WebControls.TreeNode();
nextNode.Text=fil2.mySqlReader["ProductName"].ToString();
topNode.Nodes.Add(nextNode);

fil3.sqlQueryString = "SELECT ProductID, ProductName FROM Products where ProductID<5";
fil3.sqlClientDataReader();
while(fil3.mySqlReader.Read())
{