//获取树结构的科目
public class GetSubjectTree
{
public static List<TreeNode> GetTree(DataTable dt, DataTable _SubjectPopedom)
{
List<TreeNode> listNodes = new List<TreeNode>();
foreach (var type in dt.Select("Subjectpid='0'", "Sort ASC"))
{
if (_SubjectPopedom.Select("SubjectID = '" + type["SubjectID"] + "'").Length == 0)
{ //没有权限
continue;
}
var node = CreatNode(type);
node.Expanded = false;
listNodes.Add(node);
FillChildren(type, node.ChildNodes, dt, _SubjectPopedom);
}
return listNodes;
}
public static List<TreeNode> GetTree(DataTable dt, string keyWord, DataTable _SubjectPopedom)
{
if (keyWord == "" || keyWord == null)
{
return GetTree(dt, _SubjectPopedom);
}
else
{
DataTable dtSlt = dt.Clone();
DataColumn[] primaryKeyColumn = new DataColumn[]
{
dtSlt.Columns["Subjectid"]
};
dtSlt.PrimaryKey = primaryKeyColumn;
DataRow[] rows = dt.Select(string.Format("Subjectname like '%{0}%'", keyWord));
foreach (var row in rows)
{
ImportParentRow(dt, dtSlt, row);
}
return GetTree(dtSlt, _SubjectPopedom);
}
}
/// <summary>
/// 创建节点信息
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
private static TreeNode CreatNode(DataRow type)
{
return new TreeNode()
{
Text = type["Subjectname"] + "",
Value = type["Subjectid"] + "",
ImageUrl = "../common/images/address.gif",
NavigateUrl = string.Format("javascript:SelectSubject('{0}')", type["subjectid"].ToString()),
Target = "_self"
};
}
/// <summary>
/// 将DataRow转化为实体
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
private static Subject GetDeptEnity(DataRow type)
{
return new Subject()
{
SubjectID = type["Subjectid"] + "",
SubjectName = type["Subjectname"] + "",
SubjectPID = type["SubjectPID"] + ""
};
}

/// <summary>
/// 递归填充子节点
/// </summary>
/// <param name="parentType"></param>
/// <param name="parentNode"></param>
/// <param name="dt"></param>
private static void FillChildren(DataRow parentType, TreeNodeCollection parentNode, DataTable dt, DataTable _SubjectPopedom)
{
foreach (var type in dt.Select(string.Format("Subjectpid='{0}'", parentType["Subjectid"]), "Sort ASC"))
{
if (_SubjectPopedom.Select("SubjectID = '" + type["SubjectID"] + "'").Length == 0)
{ //没有权限
continue;
}
var node = CreatNode(type);
node.Expanded = false;
parentNode.Add(node);
FillChildren(type, node.ChildNodes, dt, _SubjectPopedom);
}
}
/// <summary>
/// 导入所有父行（包括自己）
/// </summary>
/// <param name="dtSource"></param>
/// <param name="dtSlt"></param>
/// <param name="currentRow"></param>
private static void ImportParentRow(DataTable dtSource, DataTable dtSlt, DataRow currentRow)
{
if (!dtSlt.Rows.Contains(currentRow["Subjectid"])) //不存在则导入行
{
dtSlt.ImportRow(currentRow);
}
if (currentRow["Subjectpid"].ToString().TrimEnd(' ') != "0") //如果还有父项
{
DataRow row = dtSource.Select(string.Format("Subjectid='{0}'", currentRow["Subjectpid"]))[0];
ImportParentRow(dtSource, dtSlt, row);
}
}
}
调用树结构
DataTable dt = appinit.GetAllSubject();
string Sql = "select * from TblSubjectPopedom where UserID=@UserID and popedom = 0";
SqlParameter[] prams = {
new SqlParameter("@UserID",Session["adminid"].ToString())
};
_SubjectPopedom = SqlHelper.Table(Sql, prams);
List<TreeNode> nodes = GetSubjectTree.GetTree(dt, keyword, _SubjectPopedom);
foreach (TreeNode node in nodes)
{
tvMenu.Nodes.Add(node);
}