private void TeacherToolStripMenuItem_Click(object sender, EventArgs e) { this.Hide(); TeacherSearch Stud = new TeacherSearch(); Stud.ShowDialog(); }
public PagedResponse <TeacherDto> Execute(TeacherSearch search) { var query = context.Teachers.AsQueryable(); if (!string.IsNullOrEmpty(search.FirstName) || !string.IsNullOrWhiteSpace(search.FirstName)) { query = query.Where(x => x.FirstName.ToLower().Contains(search.FirstName.ToLower())); } if (!string.IsNullOrEmpty(search.LastName) || !string.IsNullOrWhiteSpace(search.LastName)) { query = query.Where(x => x.LastName.ToLower().Contains(search.LastName.ToLower())); } var skipCount = search.PerPage * (search.Page - 1); var reponse = new PagedResponse <TeacherDto> { CurrentPage = search.Page, ItemsPerPage = search.PerPage, TotalCount = query.Count(), Items = query.Skip(skipCount).Take(search.PerPage).AsEnumerable().Select(item => mapper.Map <Teacher, TeacherDto>(item)).ToList() /*Items = query.Skip(skipCount).Take(search.PerPage).Select(x => new TeacherDto * { * Id = x.Id, * FirstName = x.FirstName, * LastName = x.LastName * }).ToList()*/ }; // return(reponse); }
TeachersModel GetInfo(TeacherSearch model) { ViewData["search"] = model; var userInfo = (from u in db.User_Infos where u.user_id == model.id select new TeachersModel { name = u.user_name, times = u.user_login_times }).FirstOrDefault(); var loginInfo = (from l in db.Sys_Logs where l.log_user_id == model.id orderby l.log_time ascending select l ).FirstOrDefault(); if (loginInfo != null) { userInfo.lastDev = loginInfo.log_device; userInfo.lastIp = loginInfo.log_ip; userInfo.lastTime = loginInfo.log_time.ToString("yyyy年MM月dd日 HH时mm分"); } userInfo.courses = getTeacherCourse(model); return(userInfo); }
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); }
private bool IsEditMode = false; //ForEditMode public Assignment() { InitializeComponent(); TeacherSearch.ForeColor = Color.Gray; TeacherSearch.Text = "Search Teacher's Name"; TeacherSearch.Select(TeacherSearch.TextLength, 0); StudentSearch.ForeColor = Color.Gray; StudentSearch.Text = "Search Student's Name"; StudentSearch.Select(StudentSearch.TextLength, 0); StatusSearch.ForeColor = Color.Gray; StatusSearch.Text = "Search Status's Name"; StatusSearch.Select(StatusSearch.Text.Length, 0); //ForDataSearch }
// GET: Teacher/Details/5 public ActionResult Details(int id) { if (!User.Identity.IsAuthenticated) { return(RedirectToRoute(new { controller = "Login", action = "LogOut" })); } int userid = PageValidate.FilterParam(User.Identity.Name); if (!RoleCheck.CheckHasAuthority(userid, db, "用户查询", "用户管理") && id != userid) { return(RedirectToRoute(new { controller = "Error", action = "Index", err = "没有权限。" })); } TeacherSearch model = new TeacherSearch(); model.id = id; return(View(GetInfo(model))); }
public async Task <List <StudentResource> > getStudents(TeacherSearch req) { if (req.myStudents == false) { var val = await ITeacher.getStudents(); return(mapper.Map <List <Students>, List <StudentResource> >(val)); } //for MyStudents==TRUE var res = new List <TeacherStudent>(); if (req.myStudents == true) { res = await ITeacher.getStudentsOf_Teachers(req.TeacherID); } return(mapper.Map <List <TeacherStudent>, List <StudentResource> >(res)); }
public ActionResult TeacherCourses([Bind(Include = "id,isAll")] TeacherSearch model) { if (!User.Identity.IsAuthenticated) { return(RedirectToRoute(new { controller = "Login", action = "Index" })); } int manager_id = PageValidate.FilterParam(User.Identity.Name); if (model.id == 0) { ViewBag.msg = "未选择任课老师或助教"; ViewData["search"] = model; return(View()); } if (!ManagerRoles.CheckHasManageTeacherRole(manager_id, model.id)) { return(RedirectToRoute(new { controller = "Error", action = "Index", err = "没有权限!" })); } List <SelectOption> options = DropDownList.ManagerTeacherSelect(manager_id); ViewBag.Teachers = DropDownList.SetDropDownList(options); ViewData["TeacherCourse"] = getTeacherCourse(model); return(View(model)); }
public ActionResult TeacherCourses(int?id) { if (!User.Identity.IsAuthenticated) { return(RedirectToRoute(new { controller = "Login", action = "Index" })); } int manager_id = PageValidate.FilterParam(User.Identity.Name); List <SelectOption> options = DropDownList.ManagerTeacherSelect(manager_id); ViewBag.Teachers = DropDownList.SetDropDownList(options); if (id == null) { id = manager_id; } if (!ManagerRoles.CheckHasManageTeacherRole(manager_id, (int)id)) { return(RedirectToRoute(new { controller = "Error", action = "Index", err = "没有权限!" })); } TeacherSearch model = new TeacherSearch(); model.id = (int)id; ViewData["TeacherCourse"] = getTeacherCourse(model); return(View(model)); }
private void txtSearch_Enter(object sender, EventArgs e) { TeacherSearch.Clear(); TeacherSearch.ForeColor = Color.Black; }
public IActionResult Get([FromQuery] TeacherSearch search, [FromServices] IGetTeachersQuery query) { return(Ok(executor.ExecuteQuery(query, search))); }