public ActionResult GetMoralClassTree(int moralId)
{
using (var db = new XkSystem.Models.DbContext())
{
var gradeList = Areas.Basis.Controllers.GradeController.SelectList();
var MoralClassList = Areas.Moral.Controllers.MoralClassController.SelectList(moralId);
//学段Id
var sectionId = (from p in db.Table <Moral.Entity.tbMoral>() where p.Id == moralId select p.tbYear.Id).FirstOrDefault();
var result = new List <Code.TreeHelper>();
foreach (var grade in gradeList)
{
var node = new Code.TreeHelper();
node.name = grade.Text;
node.Id = 0;
node.open = true;
node.isChecked = false;
node.children = GetMoralClassTreeSub(sectionId, grade.Value.ConvertToInt(), MoralClassList);
result.Add(node);
}
var treeList = new List <Code.TreeHelper>();
var root = new Code.TreeHelper();
root.name = "全部班级";
root.Id = 0;
root.open = true;
root.isChecked = false;
root.children = result;
treeList.Add(root);
return(Json(treeList, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetElectiveClassTree(int electiveId)
{
using (var db = new XkSystem.Models.DbContext())
{
var gradeList = Areas.Basis.Controllers.GradeController.SelectList();
var electiveClassList = SelectList(electiveId);
var result = new List <Code.TreeHelper>();
foreach (var grade in gradeList)
{
var node = new Code.TreeHelper();
node.name = grade.Text;
node.Id = 0;
node.open = true;
node.isChecked = false;
node.children = GetElectiveClassTreeSub(grade.Value.ConvertToInt(), electiveClassList);
result.Add(node);
}
var treeList = new List <Code.TreeHelper>();
var root = new Code.TreeHelper();
root.name = "全部班级";
root.Id = 0;
root.open = true;
root.isChecked = false;
root.children = result;
treeList.Add(root);
return(Json(treeList, JsonRequestBehavior.AllowGet));
}
}
private List <Code.TreeHelper> GetCourseTreeSub(List <Course.Entity.tbCourse> courseList, List <Perform.Entity.tbPerformCourse> tbPerformCourseListOur)
{
var result = new List <Code.TreeHelper>();
foreach (var course in courseList)
{
var node = new Code.TreeHelper();
node.name = course.CourseName;
node.Id = course.Id;
node.open = true;
node.isChecked = tbPerformCourseListOur.Where(d => d.tbCourse.Id == course.Id).FirstOrDefault() == null ? false : true;
node.children = null;
result.Add(node);
}
return(result);
}
private List <Code.TreeHelper> GetCourseTreeSub(List <Dto.ClassStudent.SelectClassStudent> courseList)
{
var result = new List <Code.TreeHelper>();
foreach (var item in courseList)
{
var node = new Code.TreeHelper();
node.name = item.StudentName;
node.Id = item.SysUserId;
node.open = true;
node.isChecked = false;
node.children = null;
result.Add(node);
}
return(result);
}
private List <Code.TreeHelper> GetElectiveClassTreeSub(int gradeId, List <Dto.ElectiveClass.Info> electiveClassList)
{
var classList = Areas.Basis.Controllers.ClassController.SelectList(0, gradeId);
var result = new List <Code.TreeHelper>();
foreach (var cla in classList)
{
var node = new Code.TreeHelper();
node.name = cla.Text;
node.Id = cla.Value.ConvertToInt();
node.open = true;
node.isChecked = electiveClassList.Where(d => d.ClassId == node.Id).FirstOrDefault() == null ? false : true;
node.children = null;
result.Add(node);
}
return(result);
}
private List <Code.TreeHelper> GetSurveyClassTreeSub(int yearId, int gradeId, List <System.Web.Mvc.SelectListItem> surveyClassList)
{
var classList = Areas.Basis.Controllers.ClassController.SelectListByYearType(Code.EnumHelper.YearType.Section, yearId, gradeId);
var result = new List <Code.TreeHelper>();
foreach (var cla in classList)
{
var node = new Code.TreeHelper();
node.name = cla.Text;
node.Id = cla.Value.ConvertToInt();
node.open = true;
node.isChecked = surveyClassList.Where(d => d.Value == cla.Value).FirstOrDefault() == null ? false : true;
node.children = null;
result.Add(node);
}
return(result);
}
public List <Code.TreeHelper> GetCourseTree(List <Code.TreeHelper> result, List <Course.Entity.tbSubject> tbSubject, List <Course.Entity.tbCourse> tbCourse, List <Perform.Entity.tbPerformCourse> tbPerformCourseListOur)
{
using (var db = new XkSystem.Models.DbContext())
{
foreach (var subject in tbSubject)
{
var node = new Code.TreeHelper();
node.name = subject.SubjectName;
node.Id = subject.Id;
node.open = true;
node.isChecked = false;
node.chkDisabled = false;
var courseList = (from p in tbCourse.Where(d => d.tbSubject.Id == subject.Id)
select p).ToList();
node.children = GetCourseTreeSub(courseList, tbPerformCourseListOur);
result[0].children.Add(node);
}
return(result);
}
}
public List <Code.TreeHelper> GetCourseTree(List <Code.TreeHelper> result, List <Basis.Entity.tbClass> tbClass, List <Dto.ClassStudent.SelectClassStudent> tbClassStudent)
{
using (var db = new XkSystem.Models.DbContext())
{
foreach (var item in tbClass)
{
var node = new Code.TreeHelper();
node.name = item.ClassName;
node.Id = item.Id;
node.open = false;
node.isChecked = false;
node.chkDisabled = false;
var classStudent = (from p in tbClassStudent.Where(d => d.ClassId == item.Id)
select p).ToList();
node.children = GetCourseTreeSub(classStudent);
result[0].children.Add(node);
}
return(result);
}
}
public ActionResult GetRoleTree(int roleId)
{
using (var db = new XkSystem.Models.DbContext())
{
var menus = (from p in db.Table <Sys.Entity.tbSysMenu>()
.Include(d => d.tbMenuParent)
where p.tbProgram.Id == Code.Common.ProgramId &&
p.IsDisable == false
select p).ToList();
var rolePower = (from p in db.Table <Sys.Entity.tbSysRolePower>()
where p.tbSysRole.Id == roleId
select p.tbSysMenu.Id).ToList();
var result = new List <Code.TreeHelper>();
foreach (var menu in menus.Where(m => m.tbMenuParent == null).OrderBy(d => d.No))
{
result.Add(new Code.TreeHelper()
{
Id = menu.Id,
name = menu.MenuName,
open = true,
isChecked = rolePower.Where(d => d == menu.Id).Any(),
children = AddChildrenTreeByMenuId(menus.Where(m => m.tbMenuParent != null).ToList(), menu.Id, rolePower)
});
}
var treeList = new List <Code.TreeHelper>();
var root = new Code.TreeHelper();
root.name = "全部";
root.Id = 0;
root.open = true;
root.isChecked = false;
root.children = result;
treeList.Add(root);
return(Json(treeList, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetSurveyClassTree(int surveyId)
{
using (var db = new XkSystem.Models.DbContext())
{
var survey = (from p in db.Table <Entity.tbSurvey>()
where p.Id == surveyId
select new
{
YearId = p.tbYear.Id
}).FirstOrDefault();
var gradeList = Areas.Basis.Controllers.GradeController.SelectList();
var surveyClassList = Areas.Survey.Controllers.SurveyClassController.SelectList(surveyId);
var result = new List <Code.TreeHelper>();
foreach (var grade in gradeList)
{
var node = new Code.TreeHelper();
node.name = grade.Text;
node.Id = grade.Value.ConvertToInt();
node.open = true;
node.isChecked = false;
node.children = GetSurveyClassTreeSub(survey.YearId, grade.Value.ConvertToInt(), surveyClassList);
result.Add(node);
}
var treeList = new List <Code.TreeHelper>();
var root = new Code.TreeHelper();
root.name = "全部";
root.Id = 0;
root.open = true;
root.isChecked = false;
root.children = result;
treeList.Add(root);
return(Json(treeList, JsonRequestBehavior.AllowGet));
}
}
