/// <summary>
/// 树形视图
/// </summary>
/// <returns></returns>
public ActionResult TreeIndex()
{
//var dataList = comService.GetListBy(null);
//var tree = (from c in dataList
// select new TreeVO()
// {
// id = c.CompanyID,
// pid = c.PId,
// name = c.CompanyName
// });
//string strResult = JsonConvert.SerializeObject(tree);
//ViewData["data"] = strResult;
EFDbContext ObjEntity = new EFDbContext();
var stuList = ObjEntity.Student.ToList();
var gradeList = ObjEntity.Grade.ToList();
List <TreeVO> tree = new List <TreeVO>();
foreach (var item in gradeList)
{
TreeVO entity = new TreeVO();
entity.id = item.GradeID;
entity.pid = 0;
entity.name = item.GradeName;
tree.Add(entity);
}
foreach (var item in stuList)
{
TreeVO entity = new TreeVO();
if (item.s_id >= 4)
{
entity.id = item.s_id;
entity.pid = item.s_GradeID;
entity.name = item.s_name;
tree.Add(entity);
}
}
//var tree = (from c in ObjEntity.Grade
// join d in ObjEntity.Student on c.GradeID equals d.s_GradeID
// select new TreeVO()
// {
// id = d.s_id,
// pid = c.GradeID,
// name = d.s_name
// });
string strResult = JsonConvert.SerializeObject(tree);
ViewData["data"] = strResult;
return(View());
}
/// <summary>
/// 属性获取用户
/// </summary>
/// <returns></returns>
public string GetTreeView(string name = "")
{
var deptList = new EFDbContext().Grade.ToList();
var userList = new EFDbContext().Student.ToList();
List <TreeVO> tree = new List <TreeVO>();
if (!string.IsNullOrEmpty(name))
{
userList = userList.Where(c => c.s_name.Contains(name)).ToList();
deptList = (from c in userList join d in deptList on c.s_GradeID equals d.GradeID select d).ToList();
}
foreach (var item in deptList)
{
TreeVO entity = new TreeVO();
entity.id = item.GradeID;
entity.pid = 0;
entity.name = item.GradeName;
tree.Add(entity);
}
foreach (var item in userList)
{
TreeVO entity = new TreeVO();
entity.id = item.s_id;
entity.pid = item.s_GradeID;
entity.name = item.s_name;
tree.Add(entity);
}
string strResult = JsonConvert.SerializeObject(tree);
return(strResult);
}