c#加载树代码例子.doc

c#加载树代码例子using System;using System.Collections.Generic;using System.Web;using System.Data;using System.Data.Common;using System.Web.SessionState;using System.Text;using eMIS;using eMIS.Data;public class GetTreeHtml : IHttpHandler , IRequiresSessionState public void ProcessRequest (HttpContext context) string s; int i; string nid = context.Request.QueryStringnid.ToString(); s = context.Request.QueryStringfields.ToString(); string fields = s.Split(,); string table = context.Request.QueryStringtable.ToString(); int level = int.Parse(context.Request.QueryStringlevel.ToString(); string parentValues = context.Request.QueryStringvalues.ToString(); string values = parentValues.Split(,); string condition = context.Request.QueryStringcon.ToString(); bool iscom = (context.Request.QueryStringcount.ToString() = 1); string unit = context.Request.QueryStringunit.ToString(); bool IsParent; bool IsLast; int IsDisabled; string newnid; string wwwroot = context.Request.ApplicationPath; if (wwwroot = /) wwwroot = ; string imgpath = wwwroot + /Common6/Code/Elements/Tree/Images; StringBuilder sb = new StringBuilder(); sb.Append(); string sqlwhere; string sql = select distinct + fieldslevel + from + table ; if (condition = ) sqlwhere = where 1=1 ; else sqlwhere = where + condition + ; for (i=1;i=level;i+) sqlwhere += and + fieldsi-1 + = + valuesi-1 + ; sql += sqlwhere + order by + fieldslevel; if (level = fields.Length-1) IsParent = false; else IsParent = true; DataManager dm = new DataManager(); DataTable dt = dm.ExecuteTable(sql); int l = dt.Rows.Count; string desc, Img1, Img2, Img3, pvalues,count; for(i=0;il;i+) newnid = nid + _ + i.ToString(); desc = dt.Rowsi0.ToString(); if (i=l-1) IsLast = true; else IsLast = false; if (IsParent) IsDisabled = 0; else IsDisabled = 1; if (IsParent) if (IsLast) Img1 = imgpath + /img-plus-end.gif; else Img1 = imgpath + /img-plus-cont.gif; Img2 = imgpath + /img-folder.gif; else if (IsLast) Img1 = imgpath + /img-branch-end.gif; else Img1 = imgpath + /img-branch-cont.gif; Img2 = imgpath + /img-folder.gif; if (IsLast) Img3 = ; else Img3 = imgpath + /img-vert-line.gif; if (parentValues = ) pvalues = parentValues + desc; else pvalues = parentValues + , + desc; sb.Append(); sb.Append(); sb.Append(); sb.Append(); sb.Append(); sb.Append(); if (iscom) count = + getCount(dm.Operator,table,sqlwhere + and + fieldslevel + = + desc + ) + ; else count = ; if (IsParent) sb.Append( + desc + unit + count + ); else sb.Append( + desc + unit +count + ); sb.Append(); if (IsParent) sb.Append(); sb.Append(); sb.Append(); context.Response.Write(sb.ToString(); private string getCount(eDbOperator dbOperator,string table,string w) string ret = 0; DbDataReader r = dbOperator.Exe