public string GetAll(string order, string sort, string searchKey, int offset, int pageSize) { int total = 0; ClassInfoManager manager = new ClassInfoManager(); List <ClassInfoEntity> list = manager.GetSearch(searchKey, sort, order, offset, pageSize, out total); //给分页实体赋值 PageModels <ClassInfoEntity> model = new PageModels <ClassInfoEntity>(); model.total = total; if (total % pageSize == 0) { model.page = total / pageSize; } else { model.page = (total / pageSize) + 1; } model.rows = list; //将查询结果返回 return(new JavaScriptSerializer().Serialize(model)); }
public void GetClasses() { //用于序列化实体类的对象 JavaScriptSerializer jss = new JavaScriptSerializer(); //请求中携带的条件 string order = HttpContext.Request.Params["order"]; string sort = HttpContext.Request.Params["sort"]; string searchKey = HttpContext.Request.Params["search"]; int offset = Convert.ToInt32(HttpContext.Request.Params["offset"]); int pageSize = Convert.ToInt32(HttpContext.Request.Params["limit"]); int total = 0; ClassInfoManager manager = new ClassInfoManager(); List <ClassInfoEntity> list = manager.GetSearch(searchKey, sort, order, offset, pageSize, out total); var teacherList = new UserInfoManager().GetUserByType("Teacher"); List <ClassViewModel> listView = new List <ClassViewModel>(); foreach (var item in list) { ClassViewModel viewModel = new ClassViewModel(); viewModel.ClassID = item.ClassID; viewModel.Code = item.Code; viewModel.Name = item.Name; viewModel.Type = item.Type; viewModel.StartTime = item.StartTime; viewModel.EndTime = item.EndTime; viewModel.Company = item.Company; viewModel.Department = item.Department; viewModel.Remark = item.Remark; viewModel.UpdateTime = item.UpdateTime; var teacherEntity = teacherList.Where(r => r.ID == item.TeacherID).FirstOrDefault(); if (teacherEntity != null) { viewModel.TeacherID = teacherEntity.ID; viewModel.TeacherCode = teacherEntity.Code; viewModel.TeacherName = teacherEntity.Name; } listView.Add(viewModel); } //给分页实体赋值 PageModels <ClassViewModel> model = new PageModels <ClassViewModel>(); 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)); }