asp.net留言板管理源代码

最新推荐文章于 2024-09-04 10:45:34 发布

aimomo

最新推荐文章于 2024-09-04 10:45:34 发布

阅读量4k

点赞数 3

文章标签： asp.net javascript string imagelist border null

本文介绍了一个留言板系统的分页显示实现方法，使用ASP.NET和SQL进行数据处理与展示。该系统能够根据用户请求显示指定页数的留言记录，并提供翻页功能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

页面代码:

---------------------------------------------------------------------------------------------------------------------------------------------------------------

关键代码:

///**************************
/// 创建者:Bonnibell
/// 创建日期:2008-11-20
/// 所属模块:留言板
/// 功　　能:
/// 接受参数:
/// 含数据表:
///**************************
using System;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Text;

public partial class Book_Get : System.Web.UI.Page
{
string strConn = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["connStr"].ConnectionString;

    string s_CurrentPage = string.Empty;
    string s_PageCount = string.Empty;
    string s_RecordCount = string.Empty;

    int i_CurrentPage = 0;
    int i_PageCount = 0;
    int i_RecordCount = 0;

    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.Params["PageIndex"] != null)
        {
            if (!string.IsNullOrEmpty(Request.Params["PageIndex"]))
            {
                s_CurrentPage = Request.Params["PageIndex"].ToString();
                i_CurrentPage = Int32.Parse(s_CurrentPage);
            }
        }
        BindDateList();
    }

    string GetName(string strIN)
    {
        string strTemp = strIN;

        if (strTemp.Length > 10)
        {
            strTemp = strTemp.Substring(0, 10);
        }
        return strTemp;
    }

    void BindDateList()
    {
        string strSql_Count = "Select Count(*) from T_Book";
        s_RecordCount = SqlHelper.ExecuteScalar(strConn, strSql_Count, null).ToString();
        i_RecordCount = Convert.ToInt32(s_RecordCount);

        if (i_RecordCount % 10 > 0)
        {
            i_PageCount = i_RecordCount / 10 + 1;
        }
        else
        {
            i_PageCount = i_RecordCount / 10;
        }

s_PageCount = i_PageCount.ToString();

        string strRecordTemp = string.Empty;
        strRecordTemp = Convert.ToString(i_CurrentPage * 10);
        string strSql = string.Empty;

        if (s_CurrentPage == "0")
        {
            strSql = "select top 10 F_Name,F_Title,F_AddTime,F_Book from T_Book order by F_Code DESC";
        }
        else
        {
            strSql = "select top 10 F_Name,F_Title,F_AddTime,F_Book from T_Book where F_Code not in (select top " + strRecordTemp + " F_Code from T_Book order by F_Code DESC) order by F_Code DESC";
        }
        OleDbDataReader Rdlist = SqlHelper.ExecuteReader(strConn, strSql, null);
        DataTable Dt = new DataTable();
        DataRow dr;
        Dt.Columns.Add("F_Name", typeof(string));
        Dt.Columns.Add("F_Title", typeof(string));
        Dt.Columns.Add("F_AddTime", typeof(string));
        Dt.Columns.Add("F_Book", typeof(string));

        while (Rdlist.Read())
        {
            dr = Dt.NewRow();
            dr[0] = Rdlist[0].ToString();
            dr[1] = Rdlist[1].ToString();
            dr[2] = Rdlist[2].ToString();
            dr[3] = Rdlist[3].ToString();
            Dt.Rows.Add(dr);
        }
        Rdlist.Close();
        this.ImageList.DataSource = new DataView(Dt);
        this.ImageList.DataBind();
    }
    protected override void Render(HtmlTextWriter writer)
    {

        if (i_RecordCount > 0)
        {
            StringBuilder sp = new StringBuilder();
            sp.AppendLine("<table border=/"0/" cellpadding=/"0/" cellspacing=/"0/" width=/"300px/" >");
            sp.AppendLine("<tr>");
            sp.AppendLine(" <td>    共 ");
            sp.Append(s_RecordCount);
            sp.AppendLine(" 条记录");
            sp.AppendLine("   </td>");
            sp.AppendLine(" <td style=/"padding-top:3px;/">");
            if (i_PageCount > 1)
            {
                if (i_CurrentPage == 0)
                {
                    sp.AppendLine("<a href=/"javascript:Paging(" + Convert.ToString(i_CurrentPage + 1) + ")/" style=/"display:inline-block;color:#ffffff;text-decoration:none;height:17px;/">下一页</a>");
                    sp.AppendLine(" ");
                    sp.AppendLine("<a href=/"javascript:Paging(" + Convert.ToString(i_PageCount - 1) + ")/" style=/"display:inline-block;color:#ffffff;text-decoration:none;height:17px;/">末页</a>");
                    sp.AppendLine("  ");
                }
                else
                {
                    if (Convert.ToInt32(i_CurrentPage + 1) == i_PageCount)
                    {
                        sp.AppendLine("<a href=/"javascript:Paging(0)/" style=/"display:inline-block;color:#ffffff;text-decoration:none;height:17px;/">首页</a>");
                        sp.AppendLine(" ");
                        sp.AppendLine("<a href=/"javascript:Paging(" + Convert.ToString(i_CurrentPage - 1) + ")/" style=/"display:inline-block;color:#ffffff;text-decoration:none;height:17px;/">上一页</a>");
                        sp.AppendLine(" ");
                    }
                    else
                    {
                        sp.AppendLine("<a href=/"javascript:Paging(0)/" style=/"display:inline-block;color:#ffffff;text-decoration:none;height:17px;/">首页</a>");
                        sp.AppendLine(" ");
                        sp.AppendLine("<a href=/"javascript:Paging(" + Convert.ToString(i_CurrentPage - 1) + ")/" style=/"display:inline-block;color:#ffffff;text-decoration:none;height:17px;/">上一页</a>");
                        sp.AppendLine(" ");
                        sp.AppendLine("<a href=/"javascript:Paging(" + Convert.ToString(i_CurrentPage + 1) + ")/" style=/"display:inline-block;color:#ffffff;text-decoration:none;height:17px;/">下一页</a>");
                        sp.AppendLine(" ");
                        sp.AppendLine("<a href=/"javascript:Paging(" + Convert.ToString(i_PageCount - 1) + ")/" style=/"display:inline-block;color:#ffffff;text-decoration:none;height:17px;/">末页</a>");
                        sp.AppendLine("  ");
                    }
                }
            }
            sp.AppendLine(" </td>");
            sp.AppendLine(" <td>");
            sp.AppendLine("<span >共" + s_PageCount + "页,当前第" + Convert.ToString(i_CurrentPage + 1) + "页</span>");
            sp.AppendLine(" </td>");
            sp.AppendLine("</tr>");
            sp.AppendLine("</table>");