public ActionResult Index(BasePagerModel pager)
{
if (!User.Identity.IsAuthenticated)
{
return(RedirectToRoute(new { controller = "Login", action = "LogOut" }));
}
int uid = PageValidate.FilterParam(User.Identity.Name);
if (!RoleCheck.CheckHasAuthority(uid, db, "用户管理"))
{
return(RedirectToRoute(new { controller = "Error", action = "Index", err = "没有权限。" }));
}
if (pager == null)
{
pager = new BasePagerModel();
}
ViewData["search"] = pager;
var list = (from user in db.User_Info
join uvr in db.User_vs_Role
on user.user_id equals uvr.uvr_user_id into T1
from t1 in T1.DefaultIfEmpty()
join role in db.Dic_Role
on t1.uvr_role_id equals role.role_id into T2
from t2 in T2.DefaultIfEmpty()
join ue in db.User_Extend
on user.user_id equals ue.user_id into T3
from t3 in T3.DefaultIfEmpty()
join dept in db.Dic_Department
on t3.user_dept_id equals dept.dept_id into T4
from t4 in T4.DefaultIfEmpty()
join post in db.Dic_Post
on t3.user_post_id equals post.post_id into T5
from t5 in T5.DefaultIfEmpty()
orderby user.user_id ascending
select new UserListModel
{
id = user.user_id,
name = user.user_name,
roleName = t2.role_name == null?"":t2.role_name,
stateTxt = user.user_state == 1 ? "正常" : (user.user_state == 2 ? "锁定" : (user.user_state == 0 ? "未启用" : "未知")),
realName = user.real_name,
times = user.user_login_times,
deptName = t4.dept_name == null?"":t4.dept_name,
postName = t5.post_name == null?"":t5.post_name,
picture = t3.user_picture == null?"default.jpg":t3.user_picture,
loginTimes = user.user_login_times
}).Skip((pager.PageIndex - 1) * pager.PageSize).Take(pager.PageSize).ToList();
foreach (var item in list)
{
item.realName = Common.DEncrypt.AESEncrypt.Decrypt(item.realName);
}
return(View(list));
}
List <TeacherCourse> getTeacherCourse(TeacherSearch model)
{
var courses = (from c in db.Course_Infos
join a in db.User_Infos
on c.c_assistant_id equals a.user_id into T1
from t1 in T1.DefaultIfEmpty()
join s in db.Dic_Subjects
on c.c_sub_id equals s.sub_id
join se in db.Course_Seasons
on c.c_cs_id equals se.c_season_id
join room in db.Sys_ClassRooms
on c.c_room equals room.room_id into T2
from t2 in T2.DefaultIfEmpty()
join school in db.Sys_Schools
on t2.room_school_id equals school.sys_school_id into T3
from t3 in T3.DefaultIfEmpty()
where (c.c_teacher_id == model.id || c.c_assistant_id == model.id) && (se.c_is_used == model.isAll ? se.c_is_used : true)
orderby new { se.c_is_used, se.c_season_id, c.c_sub_id }
select new TeacherCourse
{
name = c.course_name,
assistantName = t1.user_name,
subjectName = s.sub_name,
timeInfo = c.c_time_info == null ? "" : c.c_time_info,
stunum = db.Student_vs_Courses.Where(x => x.svc_course_id == c.course_id).Count(),
roomName = t2.room_name == null ? "" : t2.room_name,
schoolName = t3.sys_school_name == null ? "" : t3.sys_school_name,
c_is_used = se.c_is_used,
season = se.c_season_id,
subject = c.c_sub_id
}).ToList();
if (courses.Count() == 0)
{
return(null);
}
foreach (var course in courses)
{
DateTime min = DateTime.Now.AddMinutes(-10);
DateTime max = DateTime.Now.AddMinutes(120);
var cvt = db.Course_vs_Times.Where(x => x.cvt_course_id == course.id && x.cvt_time >= min && x.cvt_time <= max).FirstOrDefault();
if (cvt != null)
{
course.cvt = cvt.cvt_id;
}
else
{
course.cvt = 0;
}
}
return(courses);
}
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);
}
// GET: Course/Edit/5
public ActionResult Edit(int?id)
{
CreateSelect();
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CourseModel course = (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()
where c.course_id == id
select new CourseModel
{
id = c.course_id,
assistant = c.c_assistant_id,
cost = c.course_cost,
introduce = c.course_introduce,
max = c.course_max_num,
name = c.course_name,
room = t1.room_id,
season = (int)c.c_cs_id,
subject = c.c_sub_id,
teacher = c.c_teacher_id,
type = c.c_type_id,
school = t2.sys_school_id
}).FirstOrDefault();
if (course == null)
{
return(HttpNotFound());
}
var group = from cvt in db.Course_vs_Times
where cvt.cvt_course_id == id
group cvt by new { cvt.cvt_course_id, cvt.cvt_group } into g
select new
{
Key = g.Key,
Count = g.Count()
};
if (group != null && group.Count() > 0)
{
course.ListTimes = new List <ListTime>();
foreach (var g in group)
{
var top = (from cvt in db.Course_vs_Times
where cvt.cvt_course_id == g.Key.cvt_course_id && cvt.cvt_group == g.Key.cvt_group
orderby cvt.cvt_time ascending
select new ListTime
{
day = (int)cvt.cvt_dayofweek,
lessonTime = cvt.cvt_time.ToString(),
lastlong = cvt.cvt_duration,
count = g.Count,
cgroup = (int)cvt.cvt_group
}).FirstOrDefault();
if (top != null)
{
var list = from cvt in db.Course_vs_Times
join r in db.Sys_ClassRooms
on cvt.cvt_room_id 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 st in db.Dic_Course_States
on cvt.cvt_state equals st.cstate_id into T3
from t3 in T3.DefaultIfEmpty()
where cvt.cvt_course_id == g.Key.cvt_course_id && cvt.cvt_group == g.Key.cvt_group
orderby cvt.cvt_time ascending
select new ListDetailTime
{
id = cvt.cvt_id,
time = cvt.cvt_time,
timeStr = cvt.cvt_time.ToString(),
info = cvt.cvt_info,
state = cvt.cvt_state,
isextra = cvt.cvt_is_extra,
room = t1.room_id,
school = t2.sys_school_id,
stateName = t3.cstate_name
};
top.times = list.ToList();
if (course.beginDate.Ticks == 0)
{
course.beginDate = list.First().time;
}
else if (course.beginDate > list.First().time)
{
course.beginDate = list.First().time;
}
}
course.ListTimes.Add(top);
}
}
else
{
return(View(course));
}
var csts = from cst in db.Course_SuspendTimes
join c in db.Course_Infos
on cst.cst_course_id equals c.course_id
where c.course_id == id
select cst.cst_suspend_time;
course.SuspendDays = csts.ToArray();
return(View(course));
}
