开发工具与关键技术:VS开发 MVC
作者:罗中贤
撰写时间:2019-03-27
当数据从‘数据库’里查询出来 显示网页上就时,要封装一个类 输出数据
public ActionResult Luo_Category(LayuiPage bsgridPage){
var list = (from tbStock in myModels.SYS_Stock
select new Luo_Par
{
//表数据。。。
}).ToList();
//重点↓↓↓↓↓
int teacherTotalRows = list.Count;
List<Luo_Par> listnTypeTables = list
.Skip(bsgridPage.GetStartIndex())
.Take(bsgridPage.limit)
.ToList();
Layui<Luo_Par> bsgrid = new Layui<Luo_Par>();
bsgrid.count = teacherTotalRows;//总行数
bsgrid.data = listnTypeTables;//当前页的数据
return Json(bsgrid, JsonRequestBehavior.AllowGet);
}
封装两个类
LayuiPage 、Layui
//LayuiPage
public class LayuiPage
{
/// <summary>
/// 每一页数据的数目
/// </summary>
public int limit { get; set; }
/// <summary>
/// 当前页
/// </summary>
public int page { get; set; }
public string sortName { get; set; }
public string sortOrder { get; set; }
/// <summary>
/// 当前页开始序号
/// </summary>
public int GetStartIndex()
{
return (page - 1) * limit;
}
/// <summary>
/// 当前页结束序号
/// </summary>
public int GetEndIndex()
{
return page * limit - 1;
}
}
//Layui
public class Layui<T>
{
public int code = 0;
public string msg = "";
public int count { get; set; }
public List<T> data { get; set; }
}