GridView 分页

最新推荐文章于 2023-03-10 13:57:09 发布

原创最新推荐文章于 2023-03-10 13:57:09 发布 · 1.6k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#textbox #asp #server #button #作业 #stylesheet

WebForm 专栏收录该内容

78 篇文章

订阅专栏

系统自带的分页代码不太好看。重写现第几页共多少页首页上一页下一页尾页输入第几页 GO的模式

GridView较之DataGrid提供了更加强大、更加完善的功能，而且具备了丰富的可扩展功能，可以使用GridView提供的pagertemplate自定义分页模板：

事实上，GridView默认的几中分页样式，都是将相关按钮的CommandName设为Page，而CommandArgument设为相关参数，可接受的参数包括，first，last，prev，next，<PageIndex>(具体数字），然后按事件回溯，触发顶层的RowCommand，因此我们页可以使用这些默认的可识别的参数自定义自己的分页模板，asp.net会自动设置当前的NewPageIndex，而不需要任何的冗余代码。
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="JobOrderQuery.aspx.cs" Inherits="JobOrderQuery" %>

<!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="../../css/sytel.css" type="text/css" rel="stylesheet" />
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <div class="t" style="width: 100%">
            <table id="TABLE1" align="center" cellpadding="0" cellspacing="0" onclick="return TABLE1_onclick()">
                <tbody>
                    <tr>
                        <td class="h" colspan="3" style="height: 23px">
                            <b>作业单查询            </b>
                        </td>
                    </tr>
                    <tr class="tr3">
                        <th class="tal" colspan="3">
            <asp:Label ID="Label1" runat="server" Height="19px" Text="作业单:" Width="45px"></asp:Label>
                            <asp:TextBox ID="txt_jobfrom" runat="server" Width="100px"></asp:TextBox><asp:Button ID="But_Query" runat="server" OnClick="But_Query_Click" Text="搜索" Height="21px" CssClass="btn1" />
        <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Excle" Width="81px" Height="21px" CssClass="btn1" /></th>
                    </tr>
                </tbody>
            </table>
        </div>
        <div style="Width: 100px; height: 100px">
            <asp:GridView ID="GridView1" runat="server" AllowPaging="True" BackColor="White"
                BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="3" OnPageIndexChanging="GridView1_PageIndexChanging"
                Width="1033px" PageSize="20" AutoGenerateColumns="False" Font-Size="9pt" ShowFooter="True" OnSelectedIndexChanging="GridView1_SelectedIndexChanging" Height="353px" OnSelectedIndexChanged="GridView1_SelectedIndexChanged">
                <FooterStyle BackColor="White" ForeColor="#000066" />
                <RowStyle ForeColor="#000066" />
                <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
                <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
                <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
        <Columns>
                <asp:BoundField DataField="job" HeaderText="作业单号" ReadOnly="True" />
                <asp:BoundField DataField="job_date" HeaderText="作业日期" ReadOnly="True" />
                <asp:BoundField DataField="item" HeaderText="物料编码" ReadOnly="True" />
                <asp:BoundField DataField="qty_released" HeaderText="下达数量" ReadOnly="True" />
                <asp:BoundField DataField="qty_complete" HeaderText="完成数量" ReadOnly="True" />
                <asp:BoundField DataField="qty_scrapped" HeaderText="报废数量" ReadOnly="True" />
                <asp:BoundField DataField="stat" HeaderText="状态" ReadOnly="True" />
                <asp:BoundField DataField="qty_scrapped" HeaderText="报废数量" ReadOnly="True" />
                <asp:BoundField HeaderText="开工日期" ReadOnly="True" />
                <asp:BoundField HeaderText="结束日期" ReadOnly="True" />
                </Columns>
                <PagerTemplate>
                               <table width="100%" style="font-size:12px;">
        <tr>
        <td style="text-align: right">
            第<asp:Label ID="lblPageIndex" runat="server" Text='<%# ((GridView)Container.Parent.Parent).PageIndex + 1 %>'></asp:Label>页
            /共<asp:Label ID="lblPageCount" runat="server" Text='<%# ((GridView)Container.Parent.Parent).PageCount %>'></asp:Label>页  
            <asp:LinkButton ID="btnFirst" runat="server" CausesValidation="False"
                CommandName="Page" Text="首页" CommandArgument="first" OnClick="btnFirst_Click">
            </asp:LinkButton>
            <asp:LinkButton ID="btnPrev" runat="server" CausesValidation="False"
                CommandName="Page" Text="上一页" CommandArgument="prev" onclick="btnFirst_Click">
            </asp:LinkButton>
            <asp:LinkButton ID="btnNext" runat="server" CausesValidation="False"
                CommandName="Page" Text="下一页" CommandArgument="next" OnClick="btnFirst_Click">
            </asp:LinkButton>
            <asp:LinkButton ID="btnLast" runat="server" CausesValidation="False"
                CommandName="Page" Text="尾页" CommandArgument="last" OnClick="btnFirst_Click">
            </asp:LinkButton>
            <asp:TextBox ID="txtNewPageIndex" runat="server" Text='<%# ((GridView)Container.Parent.Parent).PageIndex + 1 %>'
                Width="20px" AutoPostBack="True"
                ontextchanged="txtNewPageIndex_TextChanged"></asp:TextBox>
            <asp:LinkButton ID="btnGo" runat="server" CausesValidation="False" CommandArgument="go"
                CommandName="Page" Text="GO" OnClick="btnFirst_Click"></asp:LinkButton>
        </td>
        </tr>
    </table>
             </PagerTemplate>
                <EmptyDataTemplate>
                    <div>抱歉，暂时没有信息！</div>
                </EmptyDataTemplate>
            </asp:GridView>
        </div>
    </div>
</form>
</body>
</html>
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) //重写分页代码
    {
        //GridView1.PageIndex = e.NewPageIndex;
        GridView   theGrid = sender as GridView;
        int   newPageIndex=   0;
        if (-2   == e.NewPageIndex)
        {
             TextBox   txtNewPageIndex=null;
             GridViewRow pagerRow =theGrid.BottomPagerRow;
                        if   (null!=pagerRow)
                        {
                                txtNewPageIndex=pagerRow.FindControl( "txtNewPageIndex ") as TextBox;
                        }
                        if   (null!=txtNewPageIndex)
                        {
                                newPageIndex=int.Parse(txtNewPageIndex.Text)-1;
                        }
        }
        else
        {
            newPageIndex=e.NewPageIndex;
        }

        newPageIndex =newPageIndex<0? 0: newPageIndex;
        newPageIndex =newPageIndex>= theGrid.PageCount ? theGrid.PageCount-1:newPageIndex;
        theGrid.PageIndex   =   newPageIndex;
        GridView1.AllowPaging = true;
        GVBind(ViewState["sqlstr"].ToString());
    }
注意到，上面的示例中，由于增加了一个跳转按钮GO，但是asp。net不支持相关的CommandArgument值，虽然可以将Go Button的Commandname设为Page，还需要手动的在PageIndexChanging增加部分处理逻辑。
protected void btnFirst_Click(object sender, EventArgs e)
    {

        switch (((LinkButton)sender).CommandArgument.ToString())
        {

            case "first":
                GridView1.PageIndex = 0;
                break;
            case "last":
                GridView1.PageIndex = GridView1.PageCount - 1;
                break;
            case "prev":
                if (GridView1.PageIndex != 0)
                {
                    GridView1.PageIndex = GridView1.PageIndex - 1;
                }
                break;
            case "next":
                GridView1.PageIndex = GridView1.PageIndex + 1;
                break;
            case "go":
                {
                    GridViewRow gvr = GridView1.BottomPagerRow;
                    TextBox temp = (TextBox)gvr.FindControl("txtNewPageIndex");
                    int res = Convert.ToInt32(temp.Text.ToString());
                    GridView1.PageIndex = res - 1;
                }
                break;
        }

        GVBind(ViewState["sqlstr"].ToString());//根据需要重新绑定数据源至GridView控件。
    }
    protected void txtNewPageIndex_TextChanged(object sender, EventArgs e) //改变字段
    {

       GridViewRow gvr = GridView1.BottomPagerRow;
       TextBox temp = (TextBox)gvr.FindControl("txtNewPageIndex");
       int res = Convert.ToInt32(temp.Text.ToString());
       GridView1.PageIndex = res - 1;
       GVBind(ViewState["sqlstr"].ToString());//根据需要重新绑定数据源至GridView控件。
    }