public class TreeModel
{
public int Id { get; set; }
public string Name { get; set; }
public List<TreeModel> Children = new List<TreeModel>();
}
protected void Page_Load(object sender, EventArgs e)
{
List<TreeModel> a = GetTree(0);
Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(a));
}
public List<TreeModel> GetTree(int id)
{
List<TreeModel> cmbTreeList = new List<TreeModel>();
DataSet ds = DBUtility.DbHelperOra.Query("select * from ??? where id = '"+id+"'");
foreach (DataRow dr in ds.Tables[0].Rows)
{
TreeModel treeModel = new TreeModel();
treeModel.Id = Convert.ToInt32(dr["ID"]);
treeModel.Name = dr["name"].ToString();
treeModel.Children.AddRange(GetTree(treeModel.Id));
cmbTreeList.Add(treeModel);
}
return cmbTreeList;
}