#region 声明 //---------------------------------------------------------------------- // // 作者: 李淼(Nick.Lee) // // ASP.NET环境下完整的treeview控件使用方案类 // // 时间:2005-2-17 // [email protected] // 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()) { Microsoft.Web.UI.WebControls.TreeNode thirdNode=new Microsoft.Web.UI.WebControls.TreeNode(); thirdNode.Text=fil3.mySqlReader["ProductID"].ToString(); thirdNode.CheckBox=true; // thirdNode.NavigateUrl=fil3.mySqlReader["ProductID"].ToString(); nextNode.Nodes.Add(thirdNode); } fil3.mySqlReader.Close(); fil3.mySqlConnection.Close(); } fil2.mySqlReader.Close(); fil2.mySqlConnection.Close(); } fil1.mySqlReader.Close(); fil1.mySqlConnection.Close();
} */ #endregion
} }

|