public ActionResult Index()
{ int nows = db.Companys.ToList().Count;//共有多少条数据 int page = Convert.ToInt32(Request.QueryString["page"]);//当前第几页 int pageSize = 1; getPage(page, pageSize, nows); page = ViewBag.page;//把getPage方法里的page赋值给当前的page //计算数量偏移 int offset = pageSize * (page - 1); //var company = db.Companys.OrderBy(p => p.ID).Skip(offset).Take(pageSize).ToList(); // var company =new List<Company>(); var company = (from p in db.Companys select new { p.ID, city = from cy in db.Notices where cy.CompanyId == p.ID select new { cy.ID, school = from sl in db.Schools where sl.Nid == cy.ID select sl } }).OrderBy(p => p.ID).Skip(offset).Take(pageSize).ToList(); ViewData["company"] = company; return View(); } |
|