• 企业400电话
  • 微网小程序
  • AI电话机器人
  • 电商代运营
  • 全 部 栏 目

    企业400电话 网络优化推广 AI电话机器人 呼叫中心 网站建设 商标✡知产 微网小程序 电商运营 彩铃•短信 增值拓展业务
    .NET 纯分页代码实例
    前台
    复制代码 代码如下:

    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>
                nbsp;
                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 Repeater分页实例(PageDataSource的使用)
    • asp.net中使用repeater和PageDataSource搭配实现分页代码
    • Asp.net中使用PageDataSource分页实现代码
    • asp.net利用存储过程和div+css实现分页(类似于博客园首页分页)
    • 一个简答的Access下的分页asp.net代码
    • asp.net 使用ObjectDataSource控件在ASP.NET中实现Ajax真分页
    • ASP.NET技巧:access下的分页方案
    上一篇:.net mvc页面UI之Jquery博客日历控件实现代码
    下一篇:C#调用动态unlha32.dll解压Lha后缀的打包文件分享
  • 相关文章
  • 

    © 2016-2020 巨人网络通讯 版权所有

    《增值电信业务经营许可证》 苏ICP备15040257号-8

    .NET 纯分页代码实例 .NET,纯,分页,代码,实例,