/// <summary> /// 获取所有当前教师所教学生【指定班级】 /// </summary> public static List <C_T> Get_Students_ContainsClassInfo(string TeacherUID, Eva_Task task) { List <C_T> student_cls_list = null; try { //获取所有当前教师所教学生 student_cls_list = (from t in Constant.Teacher_List //指定老师 where t.UniqueNo == TeacherUID //课堂 join c in Constant.CourseRoom_List on t.UniqueNo equals c.TeacherUID //班级 join cs in Constant.ClassInfo_List on c.Calss_Id equals cs.ClassNO where task.Class_Id.Contains(cs.ClassNO) join cl in Constant.Class_StudentInfo_List on c.Calss_Id equals cl.Class_Id join stu in Constant.Student_List on cl.UniqueNo equals stu.UniqueNo join user in Constant.UserInfo_List on stu.UniqueNo equals user.UniqueNo join major in Constant.Major_List on t.Major_ID equals major.Id //获取所有学生ID select new C_T() { user = user, major = major, stu = stu, cs = cs, }).ToList(); } catch (Exception ex) { LogHelper.Error(ex); } return(student_cls_list); }
/// <summary> /// 获取所有当前教师所教学生 /// </summary> public static List <Class_StudentInfo> Get_Students_Common(string TeacherUID, Eva_Task task) { List <Class_StudentInfo> student_cls_list = null; try { //获取所有当前教师所教学生 student_cls_list = (from t in Constant.Teacher_List //指定老师 where t.UniqueNo == TeacherUID //课堂 join c in Constant.CourseRoom_List on t.UniqueNo equals c.TeacherUID where task.Class_Id.Contains(c.Calss_Id) //班级 join cl in Constant.Class_StudentInfo_List on c.Calss_Id equals cl.Class_Id //获取所有学生ID select cl).ToList(); } catch (Exception ex) { LogHelper.Error(ex); } return(student_cls_list); }