.NET 纯分页代码实例
更新时间:2021年9月22日 10:13 点击:1680
前台
<div class="mydiv" style="width:100%;height:180px;background-color:#f0f7ff">
<div style="margin-left:10px;">
<div style="background-color:#DAEBFF"><span style=" font-size: normal; font-weight: bolder">即将过期账册提醒>></span></div>
<div style="margin-left:10px;">
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<asp:Repeater ID="repZC" runat="server">
<HeaderTemplate>
<table border="1" cellpadding="0" cellspacing="0" style="color:#0066cc;width:95%;border-collapse:collapse; text-align:center; font-size: normal">
<tr>
<td style="background-color:#cccccc; font-weight:bold;">账册名称</td>
<td style="background-color:#cccccc; font-weight:bold;">经营单位</td>
<td style="background-color:#cccccc; font-weight:bold;color: #FF0000;">距过期天数</td>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td><%# DataBinder.Eval(Container.DataItem, "ems_no")%></td>
<td><%# DataBinder.Eval(Container.DataItem, "TRADE_NAME")%></td>
<td style="color: #FF0000;"><%# DataBinder.Eval(Container.DataItem, "days")%></td>
</tr>
</ItemTemplate>
<%--AlternatingItemTemplate描述交替输出行的另一种外观--%>
<AlternatingItemTemplate>
<tr bgcolor="#e8e8e8">
<td><%# DataBinder.Eval(Container.DataItem, "ems_no")%></td>
<td><%# DataBinder.Eval(Container.DataItem, "TRADE_NAME")%></td>
<td style="color: #FF0000;"><%# DataBinder.Eval(Container.DataItem, "days")%></td>
</tr>
</AlternatingItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater>
<div style="margin-right:10px">
<asp:LinkButton ID="lbFirst" runat="server" style="color:#0066cc;text-decoration:none; font-size: normal" CommandArgument="F" OnCommand="lbPage_Command">首页</asp:LinkButton>
<asp:LinkButton ID="lbPre" runat="server" style="color:#0066cc;text-decoration:none; font-size: normal" CommandArgument="P" OnCommand="lbPage_Command">上页</asp:LinkButton>
<asp:LinkButton ID="lbNext" runat="server" style="color:#0066cc;text-decoration:none; font-size: normal" CommandArgument="N" OnCommand="lbPage_Command">下页</asp:LinkButton>
<asp:LinkButton ID="lbLast" runat="server" style="color:#0066cc;text-decoration:none; font-size: normal" CommandArgument="L" OnCommand="lbPage_Command">末页</asp:LinkButton>
<asp:Label ID="lbTip" style="color:#0066cc;text-decoration:none; font-size: normal" runat="server" Text="Label"></asp:Label>
</div>
</ContentTemplate>
</asp:UpdatePanel>
</div>
</div>
</div>
分页类
[Serializable]
public class Pager
{
public int totalRecords;
public int pageSize;
public int pageIndex;
public int totalPages;
}
后他代码
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using InfoSoftGlobal;
using System.Data;
using DCIS.Persistence;
using DCIS.JDXT.Data;
using System.IO;
public partial class COMMON_FirstPage : System.Web.UI.Page
{
DCIS.Web.WebUserInfo CurrentUser = new DCIS.Web.WebUserInfo();
protected void Page_Load(object sender, EventArgs e)
{
Pager pager = new Pager();
CurrentUser = (DCIS.Web.WebUserInfo)Session["CurrentUser"];
if (!IsPostBack)
{
BindDoc();
object o = DBUtil.ExecuteScalarAt("SQLCOM", "select count(1) from dbo.EMS_PTS_HEAD where DECLARE_CODE='" + CurrentUser.Extends["AGENT_CODE"].ToString() + "' and datediff(day,end_Date,getdate()) between 0 and 7");
pager.totalRecords = o == null ? 0 : Convert.ToInt32(o);//总记录数
pager.pageSize = 5;//页大小
pager.pageIndex = 0;//当前页码
if (pager.totalRecords == 0)
{
pager.totalPages = 0;
}
else
{
pager.totalPages = pager.totalRecords / pager.pageSize + (pager.totalRecords % pager.pageSize == 0 ? 0 : 1)-1;//总页数
}
ViewState["pager"] = pager;
litChart.Text = CreatChart();
bindZC(pager.pageIndex, pager.pageSize);
viewLB(pager);
}
}
private void bindZC(int pageIndex,int pageSize) {
string strSQL = @"select EMS_NO,TRADE_NAME,datediff(day,end_Date,getdate()) DAYS from dbo.EMS_PTS_HEAD where DECLARE_CODE='" + CurrentUser.Extends["AGENT_CODE"].ToString() + "' and datediff(day,end_Date,getdate()) between 0 and 7";
PageSpliter pageSpliter = new PageSpliter(strSQL, ""/*在此配置排序子句*/, "SQLCOM");
pageSpliter.PageSize = pageSize;
strSQL = pageSpliter.GetPageSQL(pageIndex);
strSQL +=" order by days ";
DataTable dt = DBUtil.FillAt("SQLCOM", strSQL);
repZC.DataSource = dt;
repZC.DataBind();
}
public void lbPage_Command(object sender, CommandEventArgs e)
{
Pager pager =ViewState["pager"] as Pager ;
string para = e.CommandArgument.ToString();
//首页
if (para == "F") {
pager.pageIndex = 0;
}
//前一页
if (para == "P")
{
pager.pageIndex = pager.pageIndex-1;
}
//下一页
if (para == "N")
{
pager.pageIndex = pager.pageIndex+1;
}
//尾页
if (para == "L")
{
pager.pageIndex = pager.totalPages;
}
bindZC(pager.pageIndex, pager.pageSize);
viewLB(pager);
ViewState["pager"] = pager;
}
private void viewLB(Pager pager)
{
lbFirst.Enabled = true;
lbLast.Enabled = true;
lbPre.Enabled = true;
lbNext.Enabled = true;
if (pager.totalPages == 0)
{
lbFirst.Enabled = false;
lbLast.Enabled = false;
lbPre.Enabled = false;
lbNext.Enabled = false;
}
if (pager.pageIndex == 0)
{
lbFirst.Enabled = false;
lbPre.Enabled = false;
}
if (pager.totalPages == pager.pageIndex)
{
lbLast.Enabled = false;
lbNext.Enabled = false;
}
lbTip.Text = pager.pageIndex + 1 + "/" + (pager.totalPages + 1) + "页";
}
/// <summary>
/// 绑定文档
/// </summary>
private void BindDoc() {
DataTable dt = DBUtil.FillAt("SQLCOM"," select * from COM_FileUpload WHERE DESCRIBE='Index'");
repMD.DataSource = dt;
repMD.DataBind();
}
public void DownFile_Command(object sender, CommandEventArgs e)
{
string para = e.CommandArgument.ToString();
string serverfilpath=Server.MapPath("../" + para.Split('$')[0]);
if (!File.Exists(serverfilpath))
{
Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('你要下载的文件已经不存在!');</script>");
return;
}
ToDownload(serverfilpath,para.Split('$')[1]);
}
public static void ToDownload(string serverfilpath, string filename)
{
FileStream fileStream = new FileStream(serverfilpath, FileMode.Open);
long fileSize = fileStream.Length;
HttpContext.Current.Response.ContentType = "application/octet-stream";
HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=\"" + UTF_FileName(filename) + "\";");
////attachment --- 作为附件下载
////inline --- 在线打开
HttpContext.Current.Response.AddHeader("Content-Length", fileSize.ToString());
byte[] fileBuffer = new byte[fileSize];
fileStream.Read(fileBuffer, 0, (int)fileSize);
HttpContext.Current.Response.BinaryWrite(fileBuffer);
fileStream.Close();
HttpContext.Current.Response.End();
}
private static string UTF_FileName(string filename)
{
return HttpUtility.UrlEncode(filename, System.Text.Encoding.UTF8);
}
}
复制代码 代码如下:
<div class="mydiv" style="width:100%;height:180px;background-color:#f0f7ff">
<div style="margin-left:10px;">
<div style="background-color:#DAEBFF"><span style=" font-size: normal; font-weight: bolder">即将过期账册提醒>></span></div>
<div style="margin-left:10px;">
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<asp:Repeater ID="repZC" runat="server">
<HeaderTemplate>
<table border="1" cellpadding="0" cellspacing="0" style="color:#0066cc;width:95%;border-collapse:collapse; text-align:center; font-size: normal">
<tr>
<td style="background-color:#cccccc; font-weight:bold;">账册名称</td>
<td style="background-color:#cccccc; font-weight:bold;">经营单位</td>
<td style="background-color:#cccccc; font-weight:bold;color: #FF0000;">距过期天数</td>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td><%# DataBinder.Eval(Container.DataItem, "ems_no")%></td>
<td><%# DataBinder.Eval(Container.DataItem, "TRADE_NAME")%></td>
<td style="color: #FF0000;"><%# DataBinder.Eval(Container.DataItem, "days")%></td>
</tr>
</ItemTemplate>
<%--AlternatingItemTemplate描述交替输出行的另一种外观--%>
<AlternatingItemTemplate>
<tr bgcolor="#e8e8e8">
<td><%# DataBinder.Eval(Container.DataItem, "ems_no")%></td>
<td><%# DataBinder.Eval(Container.DataItem, "TRADE_NAME")%></td>
<td style="color: #FF0000;"><%# DataBinder.Eval(Container.DataItem, "days")%></td>
</tr>
</AlternatingItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater>
<div style="margin-right:10px">
<asp:LinkButton ID="lbFirst" runat="server" style="color:#0066cc;text-decoration:none; font-size: normal" CommandArgument="F" OnCommand="lbPage_Command">首页</asp:LinkButton>
<asp:LinkButton ID="lbPre" runat="server" style="color:#0066cc;text-decoration:none; font-size: normal" CommandArgument="P" OnCommand="lbPage_Command">上页</asp:LinkButton>
<asp:LinkButton ID="lbNext" runat="server" style="color:#0066cc;text-decoration:none; font-size: normal" CommandArgument="N" OnCommand="lbPage_Command">下页</asp:LinkButton>
<asp:LinkButton ID="lbLast" runat="server" style="color:#0066cc;text-decoration:none; font-size: normal" CommandArgument="L" OnCommand="lbPage_Command">末页</asp:LinkButton>
<asp:Label ID="lbTip" style="color:#0066cc;text-decoration:none; font-size: normal" runat="server" Text="Label"></asp:Label>
</div>
</ContentTemplate>
</asp:UpdatePanel>
</div>
</div>
</div>
分页类
复制代码 代码如下:
[Serializable]
public class Pager
{
public int totalRecords;
public int pageSize;
public int pageIndex;
public int totalPages;
}
后他代码
复制代码 代码如下:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using InfoSoftGlobal;
using System.Data;
using DCIS.Persistence;
using DCIS.JDXT.Data;
using System.IO;
public partial class COMMON_FirstPage : System.Web.UI.Page
{
DCIS.Web.WebUserInfo CurrentUser = new DCIS.Web.WebUserInfo();
protected void Page_Load(object sender, EventArgs e)
{
Pager pager = new Pager();
CurrentUser = (DCIS.Web.WebUserInfo)Session["CurrentUser"];
if (!IsPostBack)
{
BindDoc();
object o = DBUtil.ExecuteScalarAt("SQLCOM", "select count(1) from dbo.EMS_PTS_HEAD where DECLARE_CODE='" + CurrentUser.Extends["AGENT_CODE"].ToString() + "' and datediff(day,end_Date,getdate()) between 0 and 7");
pager.totalRecords = o == null ? 0 : Convert.ToInt32(o);//总记录数
pager.pageSize = 5;//页大小
pager.pageIndex = 0;//当前页码
if (pager.totalRecords == 0)
{
pager.totalPages = 0;
}
else
{
pager.totalPages = pager.totalRecords / pager.pageSize + (pager.totalRecords % pager.pageSize == 0 ? 0 : 1)-1;//总页数
}
ViewState["pager"] = pager;
litChart.Text = CreatChart();
bindZC(pager.pageIndex, pager.pageSize);
viewLB(pager);
}
}
private void bindZC(int pageIndex,int pageSize) {
string strSQL = @"select EMS_NO,TRADE_NAME,datediff(day,end_Date,getdate()) DAYS from dbo.EMS_PTS_HEAD where DECLARE_CODE='" + CurrentUser.Extends["AGENT_CODE"].ToString() + "' and datediff(day,end_Date,getdate()) between 0 and 7";
PageSpliter pageSpliter = new PageSpliter(strSQL, ""/*在此配置排序子句*/, "SQLCOM");
pageSpliter.PageSize = pageSize;
strSQL = pageSpliter.GetPageSQL(pageIndex);
strSQL +=" order by days ";
DataTable dt = DBUtil.FillAt("SQLCOM", strSQL);
repZC.DataSource = dt;
repZC.DataBind();
}
public void lbPage_Command(object sender, CommandEventArgs e)
{
Pager pager =ViewState["pager"] as Pager ;
string para = e.CommandArgument.ToString();
//首页
if (para == "F") {
pager.pageIndex = 0;
}
//前一页
if (para == "P")
{
pager.pageIndex = pager.pageIndex-1;
}
//下一页
if (para == "N")
{
pager.pageIndex = pager.pageIndex+1;
}
//尾页
if (para == "L")
{
pager.pageIndex = pager.totalPages;
}
bindZC(pager.pageIndex, pager.pageSize);
viewLB(pager);
ViewState["pager"] = pager;
}
private void viewLB(Pager pager)
{
lbFirst.Enabled = true;
lbLast.Enabled = true;
lbPre.Enabled = true;
lbNext.Enabled = true;
if (pager.totalPages == 0)
{
lbFirst.Enabled = false;
lbLast.Enabled = false;
lbPre.Enabled = false;
lbNext.Enabled = false;
}
if (pager.pageIndex == 0)
{
lbFirst.Enabled = false;
lbPre.Enabled = false;
}
if (pager.totalPages == pager.pageIndex)
{
lbLast.Enabled = false;
lbNext.Enabled = false;
}
lbTip.Text = pager.pageIndex + 1 + "/" + (pager.totalPages + 1) + "页";
}
/// <summary>
/// 绑定文档
/// </summary>
private void BindDoc() {
DataTable dt = DBUtil.FillAt("SQLCOM"," select * from COM_FileUpload WHERE DESCRIBE='Index'");
repMD.DataSource = dt;
repMD.DataBind();
}
public void DownFile_Command(object sender, CommandEventArgs e)
{
string para = e.CommandArgument.ToString();
string serverfilpath=Server.MapPath("../" + para.Split('$')[0]);
if (!File.Exists(serverfilpath))
{
Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('你要下载的文件已经不存在!');</script>");
return;
}
ToDownload(serverfilpath,para.Split('$')[1]);
}
public static void ToDownload(string serverfilpath, string filename)
{
FileStream fileStream = new FileStream(serverfilpath, FileMode.Open);
long fileSize = fileStream.Length;
HttpContext.Current.Response.ContentType = "application/octet-stream";
HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=\"" + UTF_FileName(filename) + "\";");
////attachment --- 作为附件下载
////inline --- 在线打开
HttpContext.Current.Response.AddHeader("Content-Length", fileSize.ToString());
byte[] fileBuffer = new byte[fileSize];
fileStream.Read(fileBuffer, 0, (int)fileSize);
HttpContext.Current.Response.BinaryWrite(fileBuffer);
fileStream.Close();
HttpContext.Current.Response.End();
}
private static string UTF_FileName(string filename)
{
return HttpUtility.UrlEncode(filename, System.Text.Encoding.UTF8);
}
}
上一篇: ASP.NET中使用Ajax的方法
相关文章
- 我们在使用C#做项目的时候,基本上都需要制作登录界面,那么今天我们就来一步步看看,如果简单的实现登录界面呢,本文给出2个例子,由简入难,希望大家能够喜欢。...2020-06-25
- 这篇文章主要介绍了C# 字段和属性的的相关资料,文中示例代码非常详细,供大家参考和学习,感兴趣的朋友可以了解下...2020-11-03
- 这篇文章主要为大家详细介绍了ASP.NET购物车的实现过程,文中示例代码介绍的非常详细,具有一定的参考价值,感兴趣的小伙伴们可以参考一下...2021-09-22
- 我们这里介绍php与KindEditor编辑器使用时如何利用KindEditor编辑器的分页功能实现文章内容分页,KindEditor编辑器在我们点击分页时会插入代码,我们只要以它为分切符,就...2016-11-25
- 这篇文章主要介绍了C#中截取字符串的的基本方法,文中通过示例代码介绍的非常详细,对大家的学习或者工作具有一定的参考学习价值,需要的朋友们下面随着小编来一起学习学习吧...2020-11-03
- 这篇文章主要介绍了C#实现简单的Http请求的方法,以实例形式较为详细的分析了C#实现Http请求的具体方法,需要的朋友可以参考下...2020-06-25
- 本文给大家分享C#连接SQL数据库和查询数据功能的操作技巧,本文通过图文并茂的形式给大家介绍的非常详细,需要的朋友参考下吧...2021-05-17
- 本文主要介绍了C#中new的几种用法,具有很好的参考价值,下面跟着小编一起来看下吧...2020-06-25
使用Visual Studio2019创建C#项目(窗体应用程序、控制台应用程序、Web应用程序)
这篇文章主要介绍了使用Visual Studio2019创建C#项目(窗体应用程序、控制台应用程序、Web应用程序),小编觉得挺不错的,现在分享给大家,也给大家做个参考。一起跟随小编过来看看吧...2020-06-25- 这篇文章主要介绍了C#开发Windows窗体应用程序的简单操作步骤,具有很好的参考价值,希望对大家有所帮助。一起跟随小编过来看看吧...2021-04-12
- 这篇文章主要介绍了C#从数据库读取图片并保存的方法,帮助大家更好的理解和使用c#,感兴趣的朋友可以了解下...2021-01-16
- 最近接了一个项目,其中有需求要用到jquery分页控件,上网也找到了需要分页控件,各种写法各种用法,都是很复杂,最终决定自己动手写一个jquery分页控件,全当是练练手了。写的不好,还请见谅,本分页控件在chrome测试过,其他的兼容性...2015-10-30
- 最近做一个小项目不可避免的需要前端脚本与后台进行交互。由于是在asp.net中实现,故问题演化成asp.net中jiavascript与后台c#如何进行交互。...2020-06-25
- 本文通过例子,讲述了C++调用C#的DLL程序的方法,作出了以下总结,下面就让我们一起来学习吧。...2020-06-25
- 轻松学习C#的基础入门,了解C#最基本的知识点,C#是一种简洁的,类型安全的一种完全面向对象的开发语言,是Microsoft专门基于.NET Framework平台开发的而量身定做的高级程序设计语言,需要的朋友可以参考下...2020-06-25
- 本文主要介绍了C#变量命名规则小结,文中介绍的非常详细,具有一定的参考价值,感兴趣的小伙伴们可以参考一下...2021-09-09
- 这篇文章主要介绍了C#绘制曲线图的方法,以完整实例形式较为详细的分析了C#进行曲线绘制的具体步骤与相关技巧,具有一定参考借鉴价值,需要的朋友可以参考下...2020-06-25
- 本文主要介绍了C# 中取绝对值的函数。具有很好的参考价值。下面跟着小编一起来看下吧...2020-06-25
- 这篇文章主要介绍了c#自带缓存使用方法,包括获取数据缓存、设置数据缓存、移除指定数据缓存等方法,需要的朋友可以参考下...2020-06-25
- 这篇文章主要介绍了c#中(&&,||)与(&,|)的区别详解,文中通过示例代码介绍的非常详细,对大家的学习或者工作具有一定的参考学习价值,需要的朋友们下面随着小编来一起学习学习吧...2020-06-25