asp.net中實(shí)現(xiàn)Ajax分頁(yè)

在頁(yè)面中指定一個(gè)div容器來接收動(dòng)態(tài)生成的分頁(yè)數(shù)據(jù)：

1 <div id="div_menu">2 </div>

使用jQuery來請(qǐng)求并處理Json格式數(shù)據(jù)：

 1 //定義頁(yè)碼與頁(yè)容量 2         var pageIndex = 1; 3         var pageSize = 15; 4         var pageCount = 0; 5         var recordCount = 0; 6         AjaxGetData(pageIndex, pageSize); 7         //Ajax獲取數(shù)據(jù) 8         function AjaxGetData(index, size) { 9             $.ajax({10                 url: "SEOver='javascrxmlHttpRequest, textStatus, errorThrown) {37                     alert(xmlhttpRequest);38                     alert(textStatus);39                     alert(errorThrown);40                 }41             });42         }43         //前一頁(yè)44         function GoToPrePage() {45             pageIndex -= 1;46             if (pageIndex < 1) {47                 pageIndex = 1;48                 return;49             }50             AjaxGetData(pageIndex, pageSize);51         }52         //后一頁(yè)53         function GoToNextPage() {54             pageIndex += 1;55             if (pageIndex > pageCount) {56                 pageIndex = pageCount;57                 return;58             }59             AjaxGetData(pageIndex, pageSize);60         } 

新建一個(gè)一般處理程序，來處理Ajax的異步請(qǐng)求：

  1 private readonly BLL.D_Accounting_Entry_Exercise bll = new BLL.D_Accounting_Entry_Exercise();  2         private string _action = "0";  3         protected void Page_Load(object sender, EventArgs e)  4         {  5             Int32 pageIndex = Int32.MinValue;  6             Int32 pageSize = Int32.MinValue;  7   8             if (Request["action"] != null)  9                 this._action = Request["action"]; 10  11             JavaScriptSerializer jss = new JavaScriptSerializer(); 12             if (Request["pageindex"] != null) 13             { 14                 pageIndex = Int32.Parse(Request["pageindex"].ToString()); 15                 pageSize = Request["pagesize"] != null ? Int32.Parse(Request["pagesize"].ToString()) : 10; 16  17                 //處理接收到的數(shù)據(jù) 18                 int start = 0; 19                 int end = 0; 20  21                 if (this._action == "0") 22                 { 23                     int recordCount = getAllCount(); 24                     int pageCount = (int)Math.Ceiling(((double)recordCount) / ((double)pageSize)); 25                     if (pageIndex > pageCount) 26                     { 27                         pageIndex = pageCount; 28                     } 29                     else if (pageIndex < 1) 30                         pageIndex = 1; 31                     start = (pageIndex - 1) * pageSize + 1; 32                     end = pageIndex * pageSize; 33  34                     IList<Exercise> exerciseLists = new List<Exercise>(); 35                     Exercise exercise = null; 36                     DataSet set = GetDataFromDB(start, end); 37                     int id = 0; 38                     for (int i = 0; i < set.Tables[0].Rows.Count; i++) 39                     { 40                         //將第一行記錄的ID存入session 41                         Session["first_id"] = set.Tables[0].Rows[0]["question_id"]; 42                         exercise = new Exercise(); 43                         id = Convert.ToInt32(set.Tables[0].Rows[i]["question_id"].ToString()); 44                         exercise._question_id = id; 45                         exercise._question_content = set.Tables[0].Rows[i]["question_content"].ToString(); 46                         exercise._question_answer = set.Tables[0].Rows[i]["question_answer"].ToString(); 47                         exercise._question_analyze = set.Tables[0].Rows[i]["question_analyze"].ToString(); 48                         exercise._question_status = Convert.ToInt32(set.Tables[0].Rows[i]["question_status"].ToString()); 49                         exercise._user_id = Convert.ToInt32(set.Tables[0].Rows[i]["user_id"].ToString()); 50                         exercise._add_time = Convert.ToDateTime(set.Tables[0].Rows[i]["add_time"].ToString()); 51                         exercise._row_number = Convert.ToInt32(set.Tables[0].Rows[i]["Row"].ToString()); 52                         exerciseLists.Add(exercise); 53                     } 54                     if (exerciseLists.Count > 0) 55                     { 56                         Response.Write("{/"Count/":" + recordCount + ",/"Exercise_object/":" + jss.Serialize(exerciseLists) + "}"); 57                     } 58                     else 59                     { 60                         Response.Write("{/"Count/":0,/"Exercise_object/":null}"); 61                     } 62                     Response.End(); 63                 } 64                 else if (this._action == "1") 65                 { 66                     string classID = Request["classid"]; 67                     string opSign = Request["opsign"]; 68                     int recordCount = GetYSPXCount(opSign, classID); 69                     int pageCount = (int)Math.Ceiling(((double)recordCount) / ((double)pageSize)); 70                     if (pageIndex > pageCount) 71                     { 72                         pageIndex = pageCount; 73                     } 74                     else if (pageIndex < 1) 75                         pageIndex = 1; 76                     start = (pageIndex - 1) * pageSize + 1; 77                     end = pageIndex * pageSize; 78  79                     IList<OperationModel> operList = new List<operationModel>(); 80                     operationModel model = null; 81                     DataSet set = GetYSPXRecords(start.ToString(), end.ToString(), classID, opSign); 82                     for (int i = 0; i < set.Tables[0].Rows.Count; i++) 83                     { 84                         model = new operationModel(); 85                         model.OD_ID = int.Parse(set.Tables[0].Rows[i]["od_id"].ToString()); 86                         model.OD_TITLE = set.Tables[0].Rows[i]["od_title"].ToString(); 87                         model._row_number = Convert.ToInt32(set.Tables[0].Rows[i]["Row"].ToString()); 88                         operList.Add(model); 89                     } 90                     if (operList.Count > 0) 91