createtreeajax.aspx.cs

纯ajax无限级树形菜单 纯ajax无限级树形菜单源码

// (c) Copyright XXXXXXX Corporation.
// 无级别限制Aajx树型菜单
// See http://www.ddyuanlin.com/test/tree.aspx
// Email:[e-mail]
// 2007.9.19 Alpha 

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

using System.Data.SqlClient;
using System.Text;

/// <summary>
/// 生成当前结点子树
/// </summary>
public partial class Manage_BaseData_CreateTreeAjax : System.Web.UI.Page
{
   //数据库连接字符串
    private const string CONNSTRING = "server=.;database=PubData;uid=sa;pwd=123456";
    //当前结点代码
    private string BaseDataCode = "";
    //Sql代码
    private string Sqlstr = "";
    //样式名称
    private string ClassName="";
    //孙子结点数目
    private int SubCount;
    //子结点数目
    private int PrantCount;
    //DataSet对象
    private DataSet Ds;
    //子结点代码
    private string BaseCode = "";
    //子结点名称
    private string BaseName = "";
    //Javascript事件名
    private string JsAction="";
    //样式表名称
    private string IfShowClass = "";
    //子符串变量
    StringBuilder Sb;

    /// <summary>
    /// 页面初始化
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void Page_Load(object sender, EventArgs e)
    {
        //获得当前结点代码
        BaseDataCode = Request.QueryString["ID"];
        if (BaseDataCode != "" || BaseDataCode != "")
        {
            Sqlstr = "SELECT BaseDataCode, BaseDataName, LevelType,ParentCode FROM SysBaseData WHERE (ParentCode = '" + BaseDataCode + "') AND (VaildType = '0') ORDER BY SerialNumberID";
            using (SqlConnection Conn = new SqlConnection(CONNSTRING))
            {
                SqlDataAdapter Da = new SqlDataAdapter(Sqlstr, Conn);
                Conn.Open();

                Ds = new DataSet();
                Da.Fill(Ds,"Dt");

                Sb = new StringBuilder();      
     
                //当前结点的子结点数量
                PrantCount = Ds.Tables["Dt"].Rows.Count;

                //循环读出子点结点
                for (int i = 0; i < PrantCount;i++ )
                {
                    //子结点代码
                    BaseCode = Ds.Tables["Dt"].Rows[i][0].ToString().Trim();
                    //子结点名称
                    BaseName = Ds.Tables["Dt"].Rows[i][1].ToString().Trim();

                    //判断该结点下，是否还有子结点
                    Sqlstr = "SELECT count(BaseDataCode) from SysBaseData where ParentCode='" + BaseCode + "'";
                    SqlCommand cmd2 = new SqlCommand(Sqlstr, Conn);
                    //当前结点子结点的子结点数量
                    SubCount = int.Parse(cmd2.ExecuteScalar().ToString());

                    //是否有孙子结点
                    if (SubCount > 0)
                    {
                        //最后一个结点
                        if (i == PrantCount - 1)
                        {
                            ClassName = "folder_close_end";
                            IfShowClass = "";
                        }
                        else
                        {
                            ClassName = "folder_close";
                            IfShowClass = "class='list0'";
                        }    
                        JsAction ="onclick=\"GetData('" + BaseCode + "')\"";
                    }
                    else
                    {
                        //最后一个结点
                        if (i == PrantCount - 1)
                        {
                            ClassName = "file_end";
                            IfShowClass = "";
                        }
                        else
                        {
                            ClassName = "file";
                            IfShowClass = "class='list0'";
                        }
                        JsAction = "";
                    }
                    //生成子树代码
                    Sb.Append("<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">");
                    Sb.Append("<tr><td><div id='M1_" + BaseCode + "' class='" + ClassName + "'" + JsAction + " alt='" + BaseName + "'><a  href='#" + BaseCode + "'' >" + BaseName + "</a></div>");
                    Sb.Append("<div id='M2_" + BaseCode + "' style='display:none' " + IfShowClass + "></div></td></tr>");
                    Sb.Append("</table>");
                }
                //输出
                Response.Write(Sb.ToString());
            }
        }
        else
        {
            Response.Write("没有数据");
        }
    }
}