public ActionResult UnicomProjectTable(BootstraptablePost post) { var ctx = new UnicomDbContext(); var total = ctx.EmsProjects.Count(); var rows = ctx.EmsProjects.OrderBy(p => p.Code).Skip(post.offset).Take(post.limit) .Select(prj => new { prj.Code, prj.RegisterCode, prj.Name, prj.Telephone, prj.Superintendent }).ToList(); return(Json(new { total, rows }, JsonRequestBehavior.AllowGet)); }
public ActionResult UnicomDeviceTable(BootstraptablePost post) { using (var ctx = new UnicomDbContext()) { var total = ctx.EmsDevices.Count(); var rows = ctx.EmsDevices.OrderBy(d => d.Code).Skip(post.offset).Take(post.limit) .Select(dev => new { dev.Code, dev.Name, dev.Version, dev.ProjectCode, dev.IsTransfer }).ToList(); return(Json(new { total, rows }, JsonRequestBehavior.AllowGet)); } }