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