<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ArticalManage.aspx.cs" Inherits="wzjr.admin.ArticalManage" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title></title>
<script language=javascript src="../js/jquery-1.7.1.min.js"></script>
<script language=javascript src="../js/jquery.pagination.js"></script>
<script language=javascript src="../js/tablecloth.js"></script>
<link href="../css/tablecloth.css" rel="stylesheet" type="text/css" />
<link href="../css/pagination.css" rel="stylesheet" type="text/css" />
<link href="../css/Manage.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" language="javascript">
$(function() {
var pageIndex = 0; //页面索引初始值
var pageSize = 10; //每页显示条数初始化,修改显示条数,修改这里即可
InitTable(0); //Load事件,初始化表格数据,页面索引为0(第一页)
//分页,PageCount是总条目数,这是必选参数,其它参数都是可选
$("#Pagination").pagination(<%=pageCount %>, {
callback: PageCallback,
prev_text: '上一页', //上一页按钮里text
next_text: '下一页', //下一页按钮里text
items_per_page: pageSize, //显示条数
num_display_entries: 6, //连续分页主体部分分页条目数
current_page: pageIndex, //当前页索引
num_edge_entries: 2 //两侧首尾分页条目数
});
//翻页调用
function PageCallback(index, jq) {
InitTable(index);
}
//请求数据
function InitTable(pageIndex) {
$.ajax({
type: "POST",
dataType: "json",
url: '../Handler/PagerHandler.ashx', //提交到一般处理程序请求数据
data: "pageIndex=" + (pageIndex + 1) + "&pageSize=" + pageSize, //提交两个参数:pageIndex(页面索引),pageSize(显示条数)
success: function(data) {
$("#Result tr:gt(0)").remove(); //移除Id为Result的表格里的行,从第二行开始(这里根据页面布局不同页变)
for (var i = 0; i < data.Artical.length; i++) {
// $("#Result").append("<tr><td>" + json.Artical[i].ID + "</td><td>" + json.Artical[i].标题 + "</td><td>" + json.Artical[i].栏目名称) + "</td><td>" + json.Artical[i].发布时间 + "</td></tr>");
var auditStatus = "已审核"; // 审核状态
var id = data.Artical[i].ID; // 文章ID
if (data.Artical[i].审核状态 != "True")
{
auditStatus = "未审核";
}
var html = "<tr><td style='width:300px'>" + data.Artical[i].标题 + "</td><td style='width:80px;text-aline:center'>" + data.Artical[i].栏目名称 + "</td><td style='width:200px;text-aline:center'>" + data.Artical[i].发布时间 + "</td><td style='width:60px;text-aline:center'>" + auditStatus + "</td><td style='width:50px;text-aline:center'><a href='" + id + "'>编辑</a></td><td style='width:50px;text-aline:center'><a href='" + id + "'>删除</a></td><td style='width:50px;text-aline:center'><a href='" + id + "'>审核</a></td></tr>";
$("#Result").append(html);
}
}
});
}
});
</script>
</head>
<body>
<form id="form1" runat="server">
<div style="text-align:center" >
<div class="Body_Title"><%=topicName%> >> <%=action%></div>
<div class="kuang">
<table id="Result" cellspacing="0" cellpadding="0">
<tr>
<th style="width:200px; text-align:center">标题</th>
<th style="width:80px; text-align:center">栏目</th>
<th style="width:100px; text-align:center">发布时间</th>
<th style="width:50px; text-align:center">审核状态</th>
<th style="width:40px; text-align:center">编辑</th>
<th style="width:40px; text-align:center">删除</th>
<th style="width:40px; text-align:center">审核</th>
</tr>
</table>
<div id="Pagination"></div>
</div>
</div>
</form>
<p>
</body>
</html>
.cs文件
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
namespace wzjr.admin
{
public partial class ArticalManage : System.Web.UI.Page
{
public string topicName = string.Empty;
public string action = string.Empty;
public int pageCount;
protected void Page_Load(object sender, EventArgs e)
{
BLL.BLL_Artical bllArtical = new BLL.BLL_Artical();
pageCount = bllArtical.GetArticalNumber(2, true);
DataTable dt = bllArtical.GetArticalList(0, 10);
string json = Common.GetInfo.DataTable2Json(dt, "Artical");
}
}
}
.ashx文件
<%@ WebHandler Language="C#" Class="PagerHandler" %>
using System;
using System.Web;
using System.Collections.Generic;
using System.Text;
using System.Data;
public class PagerHandler : IHttpHandler {
public void ProcessRequest (HttpContext context) {
context.Response.ContentType = "text/plain";
string str = string.Empty;
//具体的页面数
int pageIndex;
int.TryParse(context.Request["pageIndex"], out pageIndex);
//页面显示条数
int size = Convert.ToInt32(context.Request["pageSize"]);
BLL.BLL_Artical bllArtical = new BLL.BLL_Artical();
DataTable dt = bllArtical.GetArticalList(pageIndex, size);
string json = Common.GetInfo.DataTable2Json(dt, "Artical"); // datatable转换成json
context.Response.Write(json);
}
public bool IsReusable {
get {
return false;
}
}
}