Jquery gridView分页

最新推荐文章于 2021-08-06 03:16:52 发布

xiaoding133

最新推荐文章于 2021-08-06 03:16:52 发布

阅读量1.5k

点赞数

分类专栏： .net C# 类文章标签： jquery function class stylesheet yahoo string

本文链接：https://blog.csdn.net/xiaoding133/article/details/6666646

版权

.net C# 类专栏收录该内容

15 篇文章

订阅专栏

后台程序

<%@ WebHandler Language="C#" Class="handler" %>

using System;
using System.Web;
using System.Data;
using Tools;
using BLL;

public class handler : IHttpHandler {

    BLLCompanyBaseInfo BLL = new BLLCompanyBaseInfo();
    public void ProcessRequest (HttpContext context) {
        //不让浏览器缓存
        context.Response.Buffer = true;
        context.Response.ExpiresAbsolute = DateTime.Now.AddDays(-1);
        context.Response.AddHeader("pragma", "no-cache");
        context.Response.AddHeader("cache-control", "");
        context.Response.CacheControl = "no-cache";
        context.Response.ContentType = "text/plain";

        int pageindex;
        int.TryParse(context.Request["p"], out pageindex);

        string order = "Orgcode desc";
        if (!string.IsNullOrEmpty(context.Request["orderby"]))
        {
            string[] strarr = context.Request["orderby"].ToString().Split('_');
            if (strarr[1] == "0")
                order = strarr[0] + " asc";
            else
                order = strarr[0] + " desc";

        }

        if (pageindex == 0)
            pageindex = 1;

        DataTable dt = BLL.GetCompanyInfo(pageindex, order);

        string jsonData = FormatToJson.ToJson(dt, "Info");
        context.Response.Write(jsonData);  
        
    }
 
    public bool IsReusable {
        get {
            return false;
        }
    }

}

前台程序：

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="test_Default" %>

<!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>
    <link href="jqueryPager/pagination.css" rel="stylesheet" type="text/css" />
    <script src="jqueryPager/jquery-1.2.6.pack.js" type="text/javascript"></script>
    <script src="jqueryPager/jquery.pagination.js" type="text/javascript"></script>
     <script type="text/javascript">
        
      
        var orderby="";
        
        $().ready(function() {
             InitData(0);

            $("#pageTheme").change(function(){
                $("#Pagination").attr('class',$(this).val());
            });
                     
        });
        
        function pageselectCallback(page_id, jq) {
          //  alert(page_id);
            InitData(page_id);
        }
        
        function InitData(pageindx)
        {
            var tbody = "";
           
            $.ajax({
               type: "POST",//用POST方式传输
               dataType:"json",//数据格式:JSON
               url:'handler.ashx',//目标地址
               data:"p="+(pageindx+1)+"&orderby="+orderby,
               beforeSend:function(){$("#divload").show();$("#Pagination").hide();},//发送数据之前
               complete:function(){$("#divload").hide();$("#Pagination").show()},//接收数据完毕
               success:function(json) {
                        $("#productTable tr:gt(0)").remove();
                        var productData = json.Info;
                        $.each(productData, function(i, n) {
                            var trs = "";
                            trs += "<tr><td align=center>"+(pageindx*10+i+1)+"</td><td>" + n.Orgcode + "</td><td>" + n.Entname + "</td><td>" + n.Tel + "</td><td>" + n.Districtcode + "</td></tr>";

                            tbody += trs;
                        });

                        $("#productTable").append(tbody);

                        $("#productTable tr:gt(0):odd").attr("class", "odd");
                        $("#productTable tr:gt(0):even").attr("class", "enen");
                        
                        
                        $("#productTable tr:gt(0)").hover(function(){
                            $(this).addClass('mouseover');
                        },function(){
                            $(this).removeClass('mouseover');
                        });
                }});
            
                $("#Pagination").pagination(<%=pagecount %>, {
                    callback: pageselectCallback,
                    prev_text: '« 上一条',
                    next_text: '下一条 »',
                    items_per_page:10,
		            num_display_entries:6,
		            current_page:pageindx,
		            num_edge_entries:2
                });
            
        }

        function Sort(ordercolumn,ordertipid)
        {
            
            var ordertype="";//1:desc,0:asc
            var $orderimg = $("#"+ordertipid);
            if($orderimg.html()!="")
            {
                var imgsrc = $("img",$orderimg).attr("src");
                
                if(imgsrc.indexOf("asc")>-1){
                 $(".ordertip").empty();
                   $orderimg.html(" <img src=\"images/sort_desc.gif\" align=\"absmiddle\">");
                
                    ordertype = 1;
                }
                else
                { $(".ordertip").empty();
                    $orderimg.html(" <img src=\"images/sort_asc.gif\" align=\"absmiddle\">");
                   
                    ordertype = 0;
                }
            }
            else
            {
             $(".ordertip").empty();
                 $orderimg.html(" <img src=\"images/sort_desc.gif\" align=\"absmiddle\">");
                    ordertype = 1;
            }
            
            orderby = ordercolumn+"_"+ordertype;
            
            InitData(0);
        } 

        
    </script>
    
    
    
    <style type="text/css">
        table{ width:600px; background-color:#ffffff}
      table th{ height:24px; background-color:#037E12; color:White;}
      .odd{ background-color:#5FD66C}
      .enen{ background-color:#BCF5C4}
      .mouseover{ background-color:orange;}
      
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div id="divload" style="top:50%; right:50%;position:absolute; padding:0px; margin:0px; z-index:999">
        <img src="images/spinner3-greenie.gif" /></div>
    <div>
    
        <table cellpadding=5 cellspacing=1 width=620 id="productTable" align="center">
            <tr>
             <th style="width:100px"><a style="cursor:pointer;">序号</a><span id="Span1" class="ordertip"></span></th>
                <th style="width:100px"><a style="cursor:pointer;" οnclick="Sort('Orgcode','productid');return false;">组织机构代码</a><span id="productid" class="ordertip"></span></th>
                <th style="width:200px"><a style="cursor:pointer;" οnclick="Sort('Entname','ProductName');return false;">公司名</a><span id="ProductName" class="ordertip"></span></th>
                <th style="width:200px"><a style="cursor:pointer;" οnclick="Sort('Tel','UnitPrice');return false;">公司电话</a><span id="UnitPrice" class="ordertip"></span></th>
                <th style="width:120px"><a style="cursor:pointer;" οnclick="Sort('Districtcode','Discontinued');return false;">地区</a><span id="Discontinued" class="ordertip"></span></th>
            </tr>
        </table>
    
    </div>
    <div id="Pagination" class="digg" ></div>
    <div style=" text-align:center;">分页样式:
    <select id="pageTheme">
        <option value="digg">digg</option>
        <option value="meneame">meneame</option>
        <option value="flickr">flickr</option>
        <option value="sabrosus">sabrosus</option>
        <option value="scott">scott</option>
        <option value="black">black</option>
        <option value="black2">black2</option>
        <option value="black-red">black-red</option>
        <option value="grayr">grayr</option>
        <option value="yellow">yellow</option>
        <option value="jogger">jogger</option>
        <option value="starcraft2">starcraft2</option>
        <option value="tres">tres</option>
        <option value="megas512">megas512</option>
        <option value="technorati">technorati</option>
        <option value="youtube">youtube</option>
        <option value="msdn">msdn</option>
        <option value="badoo">badoo</option>
        <option value="manu">manu</option>
        <option value="viciao">viciao</option>
        <option value="green-black">green-black</option>
        <option value="yahoo2">yahoo2</option>
   
    </select>
    </div>
    </form>
</body>
</html>