api添加显示分页查询+删除（批量删除）

1.添加

public int Post(Student student)
{
StudentDbContext context = new StudentDbContext();
student.CreateTime = student.CreateTime.AddHours(8);
context.Students.Add(student);
var i = context.SaveChanges();
return i;
}

 

2.显示分页查询

public JsonResult GetPersonList(string name, int pageIndex = 1, int pageSize = 3)
{
StudentDbContext context = new StudentDbContext();
var tempPersons = context.Persons.Where(m => m.Name.Contains(name));

var totalCount = tempPersons.Count();
var allPage = int.Parse(Math.Ceiling(totalCount / 1.0 / pageSize).ToString());
var personList = tempPersons.OrderBy(m => m.Id).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();

var pageination = new Pageination<Person>
{
AllPage = allPage,
TotalCount = totalCount,
Items = personList
};

return Json(pageination, JsonRequestBehavior.AllowGet);
}

3.批量删除

public int BatchDelete(string ids)
{
StudentDbContext context = new StudentDbContext();
var students = context.Students.Where(m => ids.Contains(m.Id.ToString()));
context.Students.RemoveRange(students);
var i = context.SaveChanges();
return i;
}

 

4.删除

public JsonResult Delete(int id)
{
StudentDbContext context = new StudentDbContext();

var persons = context.Persons.FirstOrDefault(m => m.Id == id);
context.Persons.Remove(persons);
var result = context.SaveChanges();

return Json(result);
}