/// <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);
}
