///视图
GoToPage(1, "pageHtml")
function GoToPage(pageindex, pageHtml) {
$.ajax({
url: "/fenye/index",
type: "post",
data: { pageindex: pageindex },
success: function (data) {
var str = "";
for (var i = 0; i < data.Titemlist.length; i++) {
str += "
";str += "
" + data.Titemlist[i].Id + "";str += "
" + data.Titemlist[i].Name + "";str += "
" + data.Titemlist[i].Leixing + "";str += "
" + data.Titemlist[i].Feiyong + "";str += "
" + data.Titemlist[i].Shoufeiren + "";str += "
" + new Date(parseInt(data.Titemlist[i].shijian.replace(/\D/img, ""))).toLocaleDateString() + "";str += "
";}
$("#tfoot1").html(str);
GetpageHtml(data.totapage, pageindex, pageHtml)
}
})
}
///控制器
public ActionResult Index(int pageindex)
{
var result = new BLL.wuyebll().show(pageindex, 6);
return Json(result);
}
///wcf
///
/// 万能分页
///
///
///
///
public wuyeinfo show(int pageindex,int pagesize)
{
SqlCommand cmd = new SqlCommand("fenye",con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@pagesize",pagesize);
cmd.Parameters.AddWithValue("@pageindex", pageindex);
cmd.Parameters.AddWithValue("@pagecount",SqlDbType.Int);
cmd.Parameters["@pagecount"].Direction = ParameterDirection.Output;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable de = new DataTable();
da.Fill(de);
var totalcount = Convert.ToInt32(cmd.Parameters["@pagecount"].Value);//把存储过程里的count总条数强行转化为int类型
var ds = JsonConvert.SerializeObject(de);
var result = JsonConvert.DeserializeObject>(ds);
wuyeinfo list = new wuyeinfo();
list.Titemlist = result;
list.pagesize = pagesize;
list.pageindex = pageindex;
if(totalcount%pagesize==0)
{
list.totapage = totalcount / pagesize;
}
else
{
list.totapage = totalcount / pagesize + 1;
}
return list;
}
///model类
public class wuyeinfo
{
public int pageindex { get; set; }
public int pagesize { get; set; }
public int totapage { get; set; }
public List Titemlist { get; set; }
}
public class wuyemodel
{
public int Id{get;set;}
public string Name{get;set;}
public string Leixing{get;set;}
public int Feiyong{get;set;}
public string Shoufeiren{get;set;}
public DateTime shijian{get;set;}
}
原文：http://www.cnblogs.com/htbmvc/p/7880818.html