/// <summary> /// 递归处理 tree结构 /// </summary> /// <param name="Fid">父ID</param> private List<TKtree> getTree(int Fid) { DAL dal = new DAL(); string SQL = "SELECT * FROM [CNGTZ].[dbo].[TK_分类] where 上级编号=@父ID@ ORDER BY 同级排序"; SQL = SQL.Replace("@父ID@", Fid.ToString()); DataTable dt = dal.RunSqlDataTable(SQL); List<TKtree> chirdren = new List<TKtree>(); foreach (DataRow row in dt.Rows) { TKtree tree = new TKtree(); tree.attributes.Fid = Fid; tree.id = int.Parse(row["编号"].ToString()); tree.text = row["分类名称"].ToString(); tree.children = getTree(tree.id); chirdren.Add(tree); } return chirdren; }
/// <summary> /// 获取题库 分类 json 树 /// </summary> /// <param name="context"></param> public void TKgetTree(HttpContext context) { List<TKtree> TK = new List<TKtree>(); TKtree treeRoot = new TKtree(); treeRoot.attributes.Fid = 0; //treeRoot.state = "open"; treeRoot.id = 1; treeRoot.text = "所有题库"; treeRoot.children = getTree(treeRoot.id); TK.Add(treeRoot); string jsonT = Json.Json_转换到json<List<TKtree>>(TK); Sys.DebugMes(jsonT); context.Response.Write(jsonT); }