List <CourseModel> SearchCourse(PageInfo pageInfo)
{
CreateSelect();
var courses = (from c in db.Course_Infos
join r in db.Sys_ClassRooms
on c.c_room equals r.room_id into T1
from t1 in T1.DefaultIfEmpty()
join s in db.Sys_Schools
on t1.room_school_id equals s.sys_school_id into T2
from t2 in T2.DefaultIfEmpty()
join ty in db.Dic_Course_Types
on c.c_type_id equals ty.ct_id into T3
from t3 in T3.DefaultIfEmpty()
join tea in db.User_Infos
on c.c_teacher_id equals tea.user_id into T4
from t4 in T4.DefaultIfEmpty()
join ass in db.User_Infos
on c.c_assistant_id equals ass.user_id into T5
from t5 in T5.DefaultIfEmpty()
join season in db.Course_Seasons
on c.c_cs_id equals season.c_season_id into T6
from t6 in T6.DefaultIfEmpty()
join sub in db.Dic_Subjects
on c.c_sub_id equals sub.sub_id into T7
from t7 in T7.DefaultIfEmpty()
where t1.room_school_id == (pageInfo.school == 0 ? t1.room_school_id : pageInfo.school)
orderby new { c.c_cs_id, c.c_sub_id, c.course_name }
select new CourseModel
{
id = c.course_id,
assistantName = t5.user_name,
cost = c.course_cost,
introduce = c.course_introduce,
max = c.course_max_num,
name = c.course_name,
room = c.c_room,
roomName = t1.room_id == 0 ? "" : t2.sys_school_name + t1.room_name,
season = c.c_cs_id,
seasonName = t6.c_season_name,
subject = c.c_sub_id,
subjectName = t7.sub_name,
teacher = c.c_teacher_id,
teacherName = t4.user_name,
type = c.c_type_id,
typeName = t3.ct_name,
timeInfo = c.c_time_info
}); //.Skip(pagesize*(pageindex-1)).Take(pagesize).ToList();
if (pageInfo.room != 0)
{
courses = courses.Where(x => x.room == pageInfo.room);
}
if (pageInfo.season != 0)
{
courses = courses.Where(x => x.season == pageInfo.season);
}
if (pageInfo.subject != 0)
{
courses = courses.Where(x => x.subject == pageInfo.subject);
}
if (pageInfo.teacher != 0)
{
courses = courses.Where(x => x.teacher == pageInfo.teacher);
}
if (pageInfo.type != 0)
{
courses = courses.Where(x => x.type == pageInfo.type);
}
if (!string.IsNullOrEmpty(pageInfo.keyword))
{
courses = courses.Where(x => x.name.Contains(pageInfo.keyword));
}
pageInfo.count = courses.Count();
if (pageInfo.pagesize == 0)
{
pageInfo.pagesize = 10;
}
if (pageInfo.pageindex == 0)
{
pageInfo.pageindex = 1;
}
pageInfo.pages = (int)Math.Ceiling((decimal)pageInfo.count / pageInfo.pagesize);
ViewData["search"] = pageInfo;
var list = courses.Skip(pageInfo.pagesize * (pageInfo.pageindex - 1)).Take(pageInfo.pagesize).ToList();
foreach (var course in list)
{
var time = (from cvt in db.Course_vs_Times
where cvt.cvt_course_id == course.id
orderby cvt.cvt_time ascending
select cvt.cvt_time
).FirstOrDefault();
course.beginDate = time;
}
return(list);
}
