基于JQuery的asp.net comboTree

本次封装采用的是JQuery 中的comboTree控件.在我接触的项目中,或多或少都用到了这个控件,所以就直接拿来封装下吧.具体的生成界面如下:

可以实现多选,并且可以实现获取多选的值.这样一来,在项目中,就可以不用使用大量的listbox或者是checkboxlist来进行绑定了.

具体的公共页面代码(comboTree.ashx)如下:

<%@ WebHandler Language="C#" Class="ComboTree" %>

using System;
using System.Web;
using System.Collections.Generic;

public class ComboTree : IHttpHandler {
    
    public void ProcessRequest (HttpContext context) {
        context.Response.ContentType = "text/plain";
        context.Response.Write(GetJson());
    }


    public static string GetJson()
    {
        string json = "[";
        IList<Tree> t = DB.returnParentTree();
        foreach (Tree model in t)
        {
            if (model != t[t.Count - 1])
            {
                json += GetJsonByModel(model) + ",";
            }
            else
            {
                json += GetJsonByModel(model);
            }
        }
        json += "]";
        json = json.Replace("'", "\"");
        return json;
    }

    public static string GetJsonByModel(Tree t)
    {
        string json = "";
        bool flag = DB.isHaveChild(t.ModuleID);

        json = "{"
                  + "'id':'" + t.ModuleID + "',"
                  + "'text':'" + t.ModuleName + "',"
                  +"'iconCls':'ok',"
                  + "'children':";
        if (!flag)
        {
            json += "null}";
        }
        else
        {
            json += "[";
            IList<Tree> list = DB.getChild(t.ModuleID);
            foreach (Tree tree in list)
            {
                if (tree != list[list.Count - 1])
                {
                    json += GetJsonByModel(tree) + ",";
                }
                else
                {
                    json += GetJsonByModel(tree);
                }
            }
            json += "]}";
        }
        return json;
    }
    
    
    public bool IsReusable {
        get {
            return false;
        }
    }

}

Tree类的代码如下:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

/// <summary>
///Tree 的摘要说明
/// </summary>
public class Tree
{
    public int ModuleID { get; set; }

    public int ParentID { get; set; }

    public string ModulePath { get; set; }

    public string ModuleName { get; set; }

}

数据操作类代码如下:

　　

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.SqlClient;
using System.Data;

/// <summary>
///DB 的摘要说明
/// </summary>
public class DB
{
    public static readonly string connStr = System.Configuration.ConfigurationManager.AppSettings["connStr"];

    public static SqlConnection GetConn()
    {
        SqlConnection conn = new SqlConnection(connStr);
        conn.Open();
        return conn;
    }

    public static DataTable GetDT(string sql)
    {
        DataTable dt = new DataTable();
        using (SqlConnection conn = DB.GetConn())
        {
            SqlDataAdapter sda = new SqlDataAdapter(sql, conn);
            sda.Fill(dt);
        }
        return dt;
    }

    public static IList<Tree> returnParentTree()
    {
        IList<Tree> t = new List<Tree>();
        string sql = "select * from Models where [ParentModuleID]=0 order by OrderBy asc";
        DataTable dt = GetDT(sql);
        foreach (DataRow dr in dt.Rows)
        {
            Tree tParent = new Tree();
            tParent.ModuleID = Int32.Parse(dr["ID"].ToString());
            tParent.ModuleName = dr["ModuleName"].ToString();
            tParent.ModulePath = dr["MenuPath"].ToString();
            tParent.ParentID = Int32.Parse(dr["ParentModuleID"].ToString());
            t.Add(tParent);
        }
        return t;
    }

    public static bool isHaveChild(int id)
    {
        bool flag = false;
        string sql = "select ID from Models where ParentModuleID=" + id + "";
        DataTable dt = GetDT(sql);
        if (dt.Rows.Count > 0)
        {
            flag = true;
        }
        return flag;

    }
    public static IList<Tree> getChild(int id)
    {
        IList<Tree> t = new List<Tree>();
        string sql = "select * from Models where ParentModuleID=" + id + "";
        DataTable dt = GetDT(sql);
        foreach (DataRow dr in dt.Rows)
        {
            Tree tParent = new Tree();
            tParent.ModuleID = Int32.Parse(dr["ID"].ToString());
            tParent.ModuleName = dr["ModuleName"].ToString();
            tParent.ModulePath = dr["MenuPath"].ToString();
            tParent.ParentID = Int32.Parse(dr["ParentModuleID"].ToString());
            t.Add(tParent);
        }
        return t;
    }
}

都是比较简单的,所以就没有做过的的注释.  需要注意的是,在comboTree.ashx页面中,是用到了递归来生成JSON数据的,所以在利用递归生成的时候,一定要注意数据的正确性,否则会出现错误的.