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