日期:2014-05-16 浏览次数:20699 次
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title></title>
<script src="js/jquery-1.4.2-vsdoc.js" type="text/javascript"></script>
<script src="js/jquery-1.4.2.js" type="text/javascript"></script>
<script type="text/javascript">
$(function () {
$.post("WSXFY.ashx", {"action":"getpagecount" }, function (data, status) {
for (var i = 1; i <= data; i++) {
var td = $("<td><a href=''>" + i + "</a></td>");
$("#trPage").append(td);
}
});
});
$("#trPage td").click(function (e) {
e.preventDefault();
$.post("WSXFY.ashx", { "action": "getpagedata", "pagenum": $(this).text() },
function (data, staus) {
var comments = $.parseJSON(data);
$("#ulComment").empty();
for (var i = 0; i < comments.length; i++) {
var comment = comments[i];
var li = "<li>" + comment.id + comment.name + comment.Development + comment.Note + comment.Datetime + "</li>";
$("#ulComment").append(li);
}
});
});
</script>
</head>
<body>
<div >
<ul id="ulComment">
</ul>
<table>
<tr ></tr>
</table>
</div>
</body>
</html>
<%@ WebHandler Language="C#" Class="Handler" %>
using System;
using System.Web;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Configuration;
using System.Web.Script.Serialization;
using System.Collections.Generic;
public class Handler : IHttpHandler {
public void ProcessRequest (HttpContext context) {
context.Response.ContentType = "text/plain";
// string action=context.Request["action"];//无法获取action的值
//string action=context.Request.Form["action"];
// string action=context.Request.QueryString["action"];
string action = context.Request.Params["action"];
// string action = "getpagedata";
string pagenum = context.Request["pagenum"];//无法获取pagenum的值
//string pagenum = "1";
int pagecount;//总页数
if (action == "getpagecount")
{
string cmdString = @"select count(*) from Table1";
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
{
using(SqlCommand cmd = new SqlCommand(cmdString, conn))
{
conn.Open();
int count =Convert.ToInt32(cmd.ExecuteScalar());
pagecount = count/10;
}
}
if (pagecount % 10 == 0)
{
pagecount++;
}
context.Response.Write(pagecount);
}
else if (action == "getpagedata")
{
string cmdString = @"select * from (select id ,name,Development,Note,Datetime,Row_Number()over(order by id) as rownum from table1)t where t.rownum>=@pagenum*10-9 and t.rownum<=@pagenum*10";
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand(cmdString, conn))
{
conn.Open();
cmd.Parameters.Add("@pagenum",pagenum);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
List<comment> list = new List<c