Repeater 分页实例

最新推荐文章于 2022-09-01 09:30:39 发布

Melody_Liu_01

最新推荐文章于 2022-09-01 09:30:39 发布

阅读量295

点赞数

文章标签： server textbox asp string object dataset

本文链接：https://blog.csdn.net/Melody_Liu_01/article/details/5876332

版权

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data.SqlClient;
using System.Text;
using System.IO;

public partial class JCD : System.Web.UI.Page
{

    protected void Page_Load(object sender, EventArgs e)
    {

            labpage.Text = "1";

    }

    protected void select_Click(object sender, EventArgs e)
    {
        PageRepeater();
    }

    private void PageRepeater()
    {
        string querysql = "";
        string sqlInfoCount = "";
        string timeone = Request.Form["optionDate"].ToString();
        string timetwo = Request.Form["ToDate"].ToString();

        if (timeone != "" && timetwo == "")
        {
            string onetime = timeone + " 00:00:00";
            string twotime = timeone + " 23:59:59";
            querysql = @"select * from JCD_VIEW where sSignDateTime>='" + onetime + "' and sSignDateTime<='" + twotime + "'";
            sqlInfoCount = @"select count(*) from JCD_VIEW where sSignDateTime>='" + onetime + "' and sSignDateTime<='" + twotime + "'";
        }
        if (timeone == "" && timetwo != "")
        {
            string onetime = timetwo + " 00:00:00";
            string twotime = timetwo + " 23:59:59";
            querysql = @"select * from JCD_VIEW where sSignDateTime>='" + onetime + "' and sSignDateTime<='" + twotime + "'";
            sqlInfoCount = @"select count(*) from JCD_VIEW where sSignDateTime>='" + onetime + "' and sSignDateTime<='" + twotime + "'";
        }
        if (timeone != "" && timetwo != "")
        {
            string onetime = timeone + " 00:00:00";
            string twotime = timetwo + " 23:59:59";
            querysql = @"select * from JCD_VIEW where sSignDateTime>='" + onetime + "' and sSignDateTime<='" + twotime + "'";
            sqlInfoCount = @"select count(*) from JCD_VIEW where sSignDateTime>='" + onetime + "' and sSignDateTime<='" + twotime + "'";
        }
        if (timeone == "" && timetwo == "")
        {
            querysql = @"select * from JCD_VIEW where 1=1";
            sqlInfoCount = @"select count(*) from JCD_VIEW where 1=1";
        }
        if (sequenceid.Text != "")
        {
            querysql += @"and sequenceid like '%" + sequenceid.Text.Trim() + "%'";
            sqlInfoCount += @"and sequenceid like '%" + sequenceid.Text.Trim() + "%'";
        }
        if (sname.Text != "")
        {
            querysql += @"and sname like '%" + sname.Text.Trim() + "%'";
            sqlInfoCount += @"and sname like '%" + sname.Text.Trim() + "%'";
        }
        if (gonghao.Text != "")
        {
            querysql += @"and gonghao like '%" + gonghao.Text.Trim() + "%'";
            sqlInfoCount += @"and gonghao like '%" + gonghao.Text.Trim() + "%'";
        }

//sqlHelper自定义的数据库连接类
        sqlHelper help = new sqlHelper();
        DataSet myset = help.ExecuteDataSetSql(querysql);
        Repeater1.DataSource = myset;
        Repeater1.DataBind();

DataSet ds = help.ExecuteDataSetSql(sqlInfoCount);
zhong.Text = ds.Tables[0].Rows[0][0].ToString();

        PagedDataSource pds = new PagedDataSource();
        pds.DataSource = myset.Tables[0].DefaultView;
        pds.AllowPaging = true;
        pds.PageSize = 10;
        pds.CurrentPageIndex = Convert.ToInt32(this.labpage.Text) - 1;
        Repeater2.DataSource = pds;
        countpage.Text = pds.PageCount.ToString();
        labpage.Text = (pds.CurrentPageIndex + 1).ToString();
        this.firstpage.Enabled = true;
        this.pritpage.Enabled = true;
        this.nextpage.Enabled = true;
        this.lastpage.Enabled = true;

        if (pds.CurrentPageIndex < 1)
        {
            this.firstpage.Enabled = false;
            this.pritpage.Enabled = false;
        }

        if (pds.CurrentPageIndex == pds.PageCount - 1)
        {
            this.nextpage.Enabled = false;
            this.lastpage.Enabled = false;
        }

Repeater2.DataBind();
}

    protected void firstpage_Click(object sender, EventArgs e)
    {
        this.labpage.Text = "1";
        this.PageRepeater();
    }
    protected void pritpage_Click(object sender, EventArgs e)
    {
        this.labpage.Text = Convert.ToString(Convert.ToInt32(labpage.Text) - 1);
        this.PageRepeater();
    }
    protected void nextpage_Click(object sender, EventArgs e)
    {
        this.labpage.Text = Convert.ToString(Convert.ToInt32(labpage.Text) + 1);
        this.PageRepeater();
    }
    protected void lastpage_Click(object sender, EventArgs e)
    {
        this.labpage.Text = this.countpage.Text;
        this.PageRepeater();
    }

}

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

<!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/birthday.css" rel="stylesheet" type="text/css" />

</div>
</form>
</body>
</html>

Melody_Liu_01

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
Repeater 分页实例

<br />using System;<br />using System.Collections;<br />using System.Configuration;<br />using System.Data;<br />using System.Web;<br />using System.Web.Security;<br />using System.Web.UI;<br />using System.Web.UI.HtmlControls;<br />using System.Web.UI.Web
复制链接

扫一扫