日期选择，分页，导出excel，查询

获取清单，后台需要进行分页，时间段查询，部门查询，导出excel

 

aspx

<div class="panel panel-default">
                            <div class="panel-heading">
                       进出登记 
                          
                           <script type="text/javascript" src="../My97DatePicker/WdatePicker.js"></script>

                            <asp:TextBox ID="TextBox1" runat="server" class="Wdate" type="text" onclick="WdatePicker({maxDate:'#F{$dp.$D(\'TextBox2\')||\'2022-02-01\'}'})"></asp:TextBox>
                                 <asp:TextBox ID="TextBox2" runat="server" class="Wdate" type="text" onclick="WdatePicker({minDate:'#F{$dp.$D(\'TextBox1\')}',maxDate:'2022-10-01'})"></asp:TextBox>
                                <asp:DropDownList ID="ddlDType" runat="server" DataValueField="infoID" DataTextField="bmname">
                               
                    </asp:DropDownList>
                                <asp:Button ID="Button6" runat="server" Text="搜索" onclick="Button6_Click" />
                          
                            </div> 
                            <div class="panel-body">
                                <div class="table-responsive">
                                    <asp:GridView ID="GridView2" runat="server" BackColor="White" AutoGenerateColumns="False" 
                                        BorderColor="#3366CC" BorderStyle="None" BorderWidth="1px" CellPadding="4"
                                         class="table table-striped table-bordered table-hover" OnPageIndexChanging="GridView2_PageIndexChanging" >  
                                      

                                        <Columns>
              
 
                <asp:BoundField DataField="infoID" HeaderText="ID" InsertVisible="False" 
                    ReadOnly="True" SortExpression="infoID" />


                <asp:TemplateField HeaderText="时间" SortExpression="Aplei">
                    <ItemTemplate>
                        <asp:Label ID="Label1" runat="server" Text='<%# Bind("addtime") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>


                <asp:TemplateField HeaderText="姓名" SortExpression="Applyjob">
                    <ItemTemplate>
                        <asp:Label ID="Label1" runat="server" Text='<%# Bind("name") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>


                  


                  <asp:TemplateField HeaderText="手机号码" SortExpression="jobarea">
                    <ItemTemplate>
                        <asp:Label ID="Label3" runat="server" Text='<%# Bind("phone") %>'></asp:Label>
                    </ItemTemplate>
                  </asp:TemplateField>


                  <asp:TemplateField HeaderText="身份证号码" SortExpression="age">
                    <ItemTemplate>
                        <asp:Label ID="Label4" runat="server" Text='<%# Bind("sfz") %>'></asp:Label>
                    </ItemTemplate>
                  </asp:TemplateField>

                
                 <asp:TemplateField HeaderText="部门" SortExpression="experience">
                    <ItemTemplate>
                        <asp:Label ID="Label5" runat="server" Text='<%# Bind("bmname") %>'></asp:Label>
                    </ItemTemplate>
                  </asp:TemplateField>

                   
                  

                
              
 
            </Columns>
                                     
                                     <PagerTemplate>
    当前第:

    <asp:Label ID="LabelCurrentPage" runat="server" Text="<%# ((GridView)Container.NamingContainer).PageIndex + 1 %>"></asp:Label>
    页/共:

    <asp:Label ID="LabelPageCount" runat="server" Text="<%# ((GridView)Container.NamingContainer).PageCount %>"></asp:Label>
    页
    </PagerTemplate>

                                    </asp:GridView>


                                    
                                       <asp:Button ID="Button1" runat="server" Text="首页" 
                                        onclick="Button1_Click" />
                                      <asp:Button ID="Button2" runat="server" Text="上一页" 
                                        onclick="Button2_Click" />
                                        <asp:Button ID="Button3" runat="server" Text="下一页" 
                                        onclick="Button3_Click" />
                                          <asp:Button ID="Button4" runat="server" Text="末页" 
                                        onclick="Button4_Click" />



                                        <asp:Button ID="Button5" runat="server" Text="导出" onclick="Button5_Click" />
                                    
                                </div>
                            </div>
                        </div>

　　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;
using System.Data.SqlClient;
using System.IO;

using System.Configuration;
using System.Web.Security;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

namespace _5amcn.admincqtx
{
    public partial class index : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                bindb();
                getDataLeiC();
            }
        }

        public void getDataLeiC()
        {

            string sql = "select * from xqybumeng_info where infotype='2'";
            SqlConnection conn = BaseClass.DBCon();
            SqlDataAdapter sda = new SqlDataAdapter(sql, conn);
            DataSet ds = new DataSet();
            sda.Fill(ds);
            this.ddlDType.DataSource = ds.Tables[0].DefaultView;
            this.ddlDType.DataBind();
            //ddlDType.Items.Insert(0, "请选择");
            this.ddlDType.Items.Insert(0, new ListItem("请选择", "0"));


        }
        public void bindb()
        {

            string sql = " select * from xqydengji_info,xqybumeng_info WHERE xqybumeng_info.infoID=xqydengji_info.bumeng and xqydengji_info.infotype='2' and xqydengji_info.fenlei='1' order by xqydengji_info.addtime desc";
            SqlConnection conn = BaseClass.DBCon();
            SqlDataAdapter sda = new SqlDataAdapter(sql, conn);
            DataSet ds = new DataSet();
            sda.Fill(ds);
            GridView2.DataSource = ds;
            GridView2.AllowPaging = true;
            GridView2.PageSize = 20;
            GridView2.DataBind();
            if (GridView2.PageIndex == 0)
            {
                Button1.Enabled = false;
                Button2.Enabled = false;
            }
            else
            {
                Button1.Enabled = true;
                Button2.Enabled = true;
            }
            if (GridView2.PageIndex == GridView2.PageCount - 1)
            {
                Button3.Enabled = false;
                Button4.Enabled = false;
            }
            else
            {
                Button3.Enabled = true;
                Button4.Enabled = true;
            }
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            GridView2.PageIndex = 0;
            bindb();
        }

        protected void Button3_Click(object sender, EventArgs e)
        {
            GridView2.PageIndex = GridView2.PageIndex + 1;
            bindb();
        }
        protected void Button4_Click(object sender, EventArgs e)
        {
            GridView2.PageIndex = GridView2.PageCount - 1;
            bindb();
        }
        protected void Button2_Click(object sender, EventArgs e)
        {
            GridView2.PageIndex = GridView2.PageIndex - 1;
            bindb();
        }
        protected void GridView2_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
            GridView2.PageIndex = e.NewPageIndex;
            // GridView2.DataBind();
            bindb();


        }
        public static void ToExcel(System.Web.UI.Control ctl)
        {

            string filename = DateTime.Now.ToString("yyyyMMddHHmmssff") + ".xls";


            //HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=Excel.xls");
            HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + filename);
            HttpContext.Current.Response.Charset = "UTF-8";
            HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.Default;
            HttpContext.Current.Response.ContentType = "application/ms-excel";//image/JPEG;text/HTML;image/GIF;vnd.ms-excel/msword 
            ctl.Page.EnableViewState = false;
            System.IO.StringWriter tw = new System.IO.StringWriter();
            System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
            ctl.RenderControl(hw);
            HttpContext.Current.Response.Write(tw.ToString());
            HttpContext.Current.Response.End();
        }
        public override void VerifyRenderingInServerForm(Control control)
        {
            // Confirms that an HtmlForm control is rendered for
        }
        protected void Button5_Click(object sender, EventArgs e)
        {
            ToExcel(GridView2);
        }

        protected void Button6_Click(object sender, EventArgs e)
        {
            Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script language=javascript> alert('" + TextBox1.Text + "+++" + TextBox2.Text + "+++" + ddlDType.SelectedItem.Value + "') ;</script>");
           bindc();
           GridView2.Visible = true;
          
        }
        public void bindc()
        {
            string sql = " select * from xqydengji_info,xqybumeng_info WHERE xqybumeng_info.infoID=xqydengji_info.bumeng and xqydengji_info.infotype='2' and xqydengji_info.fenlei='1' ";

            if (TextBox1.Text != "")
            {
               DateTime time1=Convert.ToDateTime(TextBox1.Text.Trim());
               sql += " And xqydengji_info.addtime >= '"+ time1+"'";
            }

            if (TextBox2.Text != "")
            {
                DateTime time2 = Convert.ToDateTime(TextBox2.Text.Trim());
                sql += " And xqydengji_info.addtime <= '"+ time2+"'";
            }
            if (ddlDType.SelectedItem.Value != "0")
            {
                sql += " And bumeng= '" + ddlDType.SelectedItem.Value + "'";
            }
            sql+="order by xqydengji_info.addtime desc";
            SqlConnection conn = BaseClass.DBCon();
            SqlDataAdapter sda = new SqlDataAdapter(sql, conn);
            DataSet ds = new DataSet();
            sda.Fill(ds);
            GridView2.DataSource = ds;
            
            GridView2.DataBind();
            

        }



    }
}