public void GetClassStudentMaps() { //用于序列化实体类的对象 JavaScriptSerializer jss = new JavaScriptSerializer(); //请求中携带的条件 string order = HttpContext.Request.Params["order"]; string searchKey = HttpContext.Request.Params["search"]; int offset = Convert.ToInt32(HttpContext.Request.Params["offset"]); int pageSize = Convert.ToInt32(HttpContext.Request.Params["limit"]); string classID = HttpContext.Request.Params["classID"]; int total = 0; ClassStudentMapManager manager = new ClassStudentMapManager(); List <ClassStudentMapViewEntity> list = manager.GetSearch(Ext.ToIntOrNull(classID), searchKey, order, offset, pageSize, out total); //给分页实体赋值 PageModels <ClassStudentMapViewEntity> model = new PageModels <ClassStudentMapViewEntity>(); model.total = total; if (total % pageSize == 0) { model.page = total / pageSize; } else { model.page = (total / pageSize) + 1; } model.rows = list; //将查询结果返回 HttpContext.Response.Write(jss.Serialize(model)); }
public string PutClassStudentMap(ClassStudentMapEntity entity) { try { if (entity == null) { return("error"); } ClassStudentMapManager manager = new ClassStudentMapManager(); entity.CreateTime = DateTime.Now; entity.CreateTime = DateTime.Now; manager.Update(entity); return("success"); } catch (Exception e) { return(e.ToString()); } }
public string DeleteClassStudentMap(int id) { try { ClassStudentMapManager manager = new ClassStudentMapManager(); ClassStudentMapEntity entity = manager.GetClassStudentMapByID(id); if (entity != null) { entity.Valid = "F"; entity.CreateTime = DateTime.Now; entity.CreateTime = DateTime.Now; manager.Update(entity); } return("success"); } catch (Exception e) { return(e.ToString()); } }
public void GetArrangeClasses() { //用于序列化实体类的对象 JavaScriptSerializer jss = new JavaScriptSerializer(); //请求中携带的条件 string order = HttpContext.Request.Params["order"]; int offset = Convert.ToInt32(HttpContext.Request.Params["offset"]); int pageSize = Convert.ToInt32(HttpContext.Request.Params["limit"]); string student = HttpContext.Request.Params["student"]; string curriculumID = HttpContext.Request.Params["curriculumID"]; string classID = HttpContext.Request.Params["classID"]; string classRoomID = HttpContext.Request.Params["classRoomID"]; string teacherID = HttpContext.Request.Params["teacherID"]; string startTime = HttpContext.Request.Params["startTime"]; DateTime?endTime = null; if (!string.IsNullOrWhiteSpace(startTime)) { endTime = DateTime.Parse(startTime).AddDays(1); } List <int> classList = null; if (!string.IsNullOrWhiteSpace(student)) { classList = new ClassStudentMapManager().GetClassStudentMapViewList(Ext.ToIntOrNull(classID), null, student).Select(r => r.ClassID).ToList(); } int total = 0; ArrangeClassManager manager = new ArrangeClassManager(); List <ArrangeClassViewEntity> list = manager.GetArrangeClassViewList(Ext.ToIntOrNull(curriculumID), Ext.ToIntOrNull(classID), Ext.ToIntOrNull(classRoomID), Ext.ToIntOrNull(teacherID), Ext.ToDateOrNull(startTime), Ext.ToDateOrNull(endTime)); list = list.OrderByDescending(r => r.StartTime).OrderBy(r => r.ClassCode).ToList(); total = list.Count; List <ArrangeClassViewEntity> listView = list.Skip(offset).Take(pageSize).ToList(); if (!string.IsNullOrWhiteSpace(student)) { listView = list.Where(r => classList.Contains(r.ClassID)).Skip(offset).Take(pageSize).ToList(); } //给分页实体赋值 PageModels <ArrangeClassViewEntity> model = new PageModels <ArrangeClassViewEntity>(); model.total = total; if (total % pageSize == 0) { model.page = total / pageSize; } else { model.page = (total / pageSize) + 1; } model.rows = listView; //将查询结果返回 HttpContext.Response.Write(jss.Serialize(model)); }
public string GetClassStudentMapViewList(int?classID, int?studentID) { ClassStudentMapManager manager = new ClassStudentMapManager(); return(new JavaScriptSerializer().Serialize(manager.GetClassStudentMapViewList(classID, studentID))); }
public string GetClassStudentMapByStudentID(int studentID) { ClassStudentMapManager manager = new ClassStudentMapManager(); return(new JavaScriptSerializer().Serialize(manager.GetClassStudentMapByStudentID(studentID))); }