private List<UserInfoModel> ShowPage() { //输入参数 PagePut pageput = new PagePut(); string tablename = " Biao a inner join HuXing b on a.HuXingID=b.HuXingID inner join DongHao c on c.DongHao=a.DongHao inner join JianZhu d on d.JianZhuID =a.JID inner join XiaoQu e on e.XiaoQuID=a.XiaoQuID inner join XingZhi f on f.XingZhiID=a.XingZhiID inner join ZhuangTai g on g.ZhuangTaiID=a.ZhuangTaiID"; pageput.tableName = tablename; pageput.indexCol = "a.ID"; pageput.pageSize = size; pageput.pageIndex = index; pageput.orderCol = orderCol; pageput.where = Where; pageput.columns = " * ";
//输出参数 PageOut pageout = bll.DataBind(JsonConvert.SerializeObject(pageput)); count = pageout.tCount;//总条数 page = pageout.tPage;//总页数 ViewBag.count = count; ViewBag.page = page; ViewBag.index = index; List<UserInfoModel> list = JsonConvert.DeserializeObject<List<UserInfoModel>>(JsonConvert.SerializeObject(pageout.tDt)); return list; }
转载于:https://www.cnblogs.com/MenBe/p/9521720.html
相关资源：vue iview的table分页与后台数据交互