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