How to write .NET Pure pagination Code
This article focuses on "how to write .NET Pure pagination Code". Interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "how to write .NET pure paging code".
Front Desk
The copy code is as follows:
Reminder that account books are about to expire > >
Name of account book
Operating unit
Days from expiration
Home page
Previous page
Next page
Last page
Paging class
The copy code is as follows:
[Serializable]
Public class Pager
{
Public int totalRecords
Public int pageSize
Public int pageIndex
Public int totalPages
}
After his code
The copy code is as follows:
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); / / Total number of records
Pager.pageSize = 5umbnail / page size
Pager.pageIndex = 0 position / current page number
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, "/" / * configure the sort clause here * /, "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 ()
/ / Home page
If (para = = "F") {
Pager.pageIndex = 0
}
/ / previous page
If (para = = "P")
{
Pager.pageIndex = pager.pageIndex-1
}
/ / next page
If (para = = "N")
{
Pager.pageIndex = pager.pageIndex+1
}
/ / the last page
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) + "Page"
}
/ / /
/ / bind document
/ / /
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 (), "", "alert ('the file you want to download no longer exists!')
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-download as an attachment
/ inline-Open online
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)
}
}
At this point, I believe you have a deeper understanding of "how to write .NET pure paging code". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!
