树型结构递归 实体递归 JSON格式

CREATE TABLE [dbo].[P_Category](
	[Code] [varchar](36) NOT NULL PRIMARY KEY,
	[Parent_Code] [varchar](36) NULL,
	[Depth] [int] NULL,
	[Name] [varchar](50) NULL
) 
GO

INSERT [dbo].[P_Category] ([Code], [Parent_Code], [Depth], [Name]) VALUES (N‘101‘, N‘1‘, 2, N‘木门‘)
INSERT [dbo].[P_Category] ([Code], [Parent_Code], [Depth], [Name]) VALUES (N‘10101‘, N‘101‘, 3, N‘室内木门‘)
INSERT [dbo].[P_Category] ([Code], [Parent_Code], [Depth], [Name]) VALUES (N‘1010101‘, N‘10101‘, 4, N‘A02‘)
INSERT [dbo].[P_Category] ([Code], [Parent_Code], [Depth], [Name]) VALUES (N‘101010101‘, N‘10101‘, 5, N‘A01‘)
INSERT [dbo].[P_Category] ([Code], [Parent_Code], [Depth], [Name]) VALUES (N‘10101010101‘, N‘101010101‘, 6, N‘A0101‘)
INSERT [dbo].[P_Category] ([Code], [Parent_Code], [Depth], [Name]) VALUES (N‘102‘, N‘1‘, 2, N‘B‘)
INSERT [dbo].[P_Category] ([Code], [Parent_Code], [Depth], [Name]) VALUES (N‘10201‘, N‘102‘, 3, N‘B1‘)
INSERT [dbo].[P_Category] ([Code], [Parent_Code], [Depth], [Name]) VALUES (N‘1020101‘, N‘10201‘, 4, N‘B2‘)

private List<Category> CategoryCacheAllList { get; set; }

[Route("")]
public HttpResponseMessage Get()
{
	var list = CacheHelper<List<Category>>.GetCache(CategoryAllListCacheKEY);
	if (list == null)
	{
		CategoryCacheAllList = CategoryService.GetCacheList(); //取得数据库里面所有数据
		list = new List<Category>();
		CategoryJson(list, "1"); 
		CacheHelper<List<Category>>.SetCache(CategoryAllListCacheKEY, list);
	}
	return Request.CreateResponse(HttpStatusCode.OK, list);
 	//下面的代码这个没试
	//string json = JsonConvert.SerializeObject(categoryList, Formatting.Indented);
	//return json;	
}


/// <summary>
/// 取得兄弟节点
/// </summary>
/// <param name="categoryList"></param>
/// <param name="parentCode"></param>
public void CategoryJson(List<Category> categoryList, string parentCode)
{
	var list = CategoryCacheAllList.FindAll(p => p.ParentCode == parentCode);
	if (list.Count > 0)
	{
		foreach (var item in list)
		{
			CategoryTreeJson(item, item.Code);
			categoryList.Add(item);
		}
	}
}

/// <summary>
/// 递归出子对象
/// </summary>
/// <param name="sbCategory"></param>
/// <param name="parentCode"></param>
private void CategoryTreeJson(Category sbCategory, string parentCode)
{
	var list = CategoryCacheAllList.FindAll(p => p.ParentCode == parentCode);
	if (list.Count > 0)
	{
		sbCategory.Children = new List<Category>();
		foreach (var item in list)
		{
			CategoryTreeJson(item, item.Code);
			sbCategory.Children.Add(item);
		}
	}
}