/// <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);
}
