reply.aspx.cs

留言板 dreamweaver 完整程序 access数据库 有文档

using System;
using System.Data;
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.Data.OleDb;
using System.Drawing;
using System.Web.SessionState;

public partial class Reply : System.Web.UI.Page
{
    protected OleDbConnection myconn = new OleDbConnection();

    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session.Count == 0)
        {
            Response.Redirect("login.aspx");
        }
        myconn.ConnectionString = "Provider=Microsoft.Jet.OleDb.4.0;" + "Data Source=" + Server.MapPath("book/book.mdb");
        if (!Page.IsPostBack)
            BindData();

    }

    private void BindData()
    {

        string sql2 = "select * from guestbook where id=" + Request["id"];
        OleDbDataAdapter da2 = new OleDbDataAdapter(sql2, myconn);
        DataSet ds2 = new DataSet();
        da2.Fill(ds2, "host");
        Label1.Text = UbbReplace(Server.HtmlEncode(ds2.Tables["host"].Rows[0][7].ToString()));
        Content.Text = ds2.Tables["host"].Rows[0][9].ToString();
        myconn.Close();
    }

    public string UbbReplace(string content)
    {
        content = content.Replace("\n", "<BR>");
        content = content.Replace("\t", "   ");
        content = content.Replace(" ", "&nbsp;");
        for (int i = 1; i < 43; i++)
            content = content.Replace("[em" + i + "]", "<IMG SRC=\"ubb/face/em" + i + ".gif\">");
        content = System.Text.RegularExpressions.Regex.Replace(content, @"\[url=(?<x>[^\]]*)\](?<y>[^\]]*)\[/url\]", @"<a href=$1 target=_blank>$2</a>", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        content = System.Text.RegularExpressions.Regex.Replace(content, @"\[email=(?<x>[^\]]*)\](?<y>[^\]]*)\[/email\]", @"<a href=mailto:$1>$2</a>", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        content = System.Text.RegularExpressions.Regex.Replace(content, @"\[flash](?<x>[^\]]*)\[/flash]", @"<OBJECT codeBase=http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0 classid=clsid:D27CDB6E-AE6D-11cf-96B8-444553540000 width=500 height=400><PARAM NAME=movie VALUE=""$1""><PARAM NAME=quality VALUE=high><embed src=""$1"" quality=high pluginspage='http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash' type='application/x-shockwave-flash' width=500 height=400>$1</embed></OBJECT>", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        content = System.Text.RegularExpressions.Regex.Replace(content, @"\[img](?<x>[^\]]*)\[/img]", @"<IMG SRC=""$1"" border=0>", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        content = System.Text.RegularExpressions.Regex.Replace(content, @"\[color=(?<x>[^\]]*)\](?<y>[^\]]*)\[/color\]", @"<font color=$1>$2</font>", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        content = System.Text.RegularExpressions.Regex.Replace(content, @"\[face=(?<x>[^\]]*)\](?<y>[^\]]*)\[/face\]", @"<font face=$1>$2</font>", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        content = System.Text.RegularExpressions.Regex.Replace(content, @"\[size=(?<x>[^\]]*)\](?<y>[^\]]*)\[/size\]", @"<font size=$1>$2</font>", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        content = System.Text.RegularExpressions.Regex.Replace(content, @"\[align=(?<x>[^\]]*)\](?<y>[^\]]*)\[/align\]", @"<div align=$1>$2</div>", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        content = System.Text.RegularExpressions.Regex.Replace(content, @"\[fly](?<x>[^\]]*)\[/fly]", @"<marquee width=90% behavior=alternate scrollamount=3>$1</marquee>", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        content = System.Text.RegularExpressions.Regex.Replace(content, @"\[move](?<x>[^\]]*)\[/move]", @"<marquee scrollamount=3>$1</marquee>", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        content = System.Text.RegularExpressions.Regex.Replace(content, @"\[glow=(?<x>[^\]]*),(?<y>[^\]]*),(?<z>[^\]]*)\](?<w>[^\]]*)\[/glow\]", @"<table width=$1 style=""filter:glow(color=$2, strength=$3)"">$4</table>", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        content = System.Text.RegularExpressions.Regex.Replace(content, @"\[shadow=(?<x>[^\]]*),(?<y>[^\]]*),(?<z>[^\]]*)\](?<w>[^\]]*)\[/shadow\]", @"<table width=$1 style=""filter:shadow(color=$2, strength=$3)"">$4</table>", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        content = System.Text.RegularExpressions.Regex.Replace(content, @"\[b\](?<x>[^\]]*)\[/b\]", @"<b>$1</b>", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        content = System.Text.RegularExpressions.Regex.Replace(content, @"\[i\](?<x>[^\]]*)\[/i\]", @"<i>$1</i>", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        content = System.Text.RegularExpressions.Regex.Replace(content, @"\[u\](?<x>[^\]]*)\[/u\]", @"<u>$1</u>", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        content = System.Text.RegularExpressions.Regex.Replace(content, @"\[h1\](?<x>[^\]]*)\[/h1\]", @"<h1>$1</h1>", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        content = System.Text.RegularExpressions.Regex.Replace(content, @"\[h2\](?<x>[^\]]*)\[/h2\]", @"<h2>$1</h2>", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        content = System.Text.RegularExpressions.Regex.Replace(content, @"\[h3\](?<x>[^\]]*)\[/h3\]", @"<h3>$1</h3>", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        content = System.Text.RegularExpressions.Regex.Replace(content, @"\[h4\](?<x>[^\]]*)\[/h4\]", @"<h4>$1</h4>", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        content = System.Text.RegularExpressions.Regex.Replace(content, @"\[h5\](?<x>[^\]]*)\[/h5\]", @"<h5>$1</h5>", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        content = System.Text.RegularExpressions.Regex.Replace(content, @"\[h6\](?<x>[^\]]*)\[/h6\]", @"<h6>$1</h6>", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        content = System.Text.RegularExpressions.Regex.Replace(content, @"\[small\](?<x>[^\]]*)\[/small\]", @"<small>$1</small>", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        content = System.Text.RegularExpressions.Regex.Replace(content, @"\[big\](?<x>[^\]]*)\[/big\]", @"<big>$1</big>", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        content = System.Text.RegularExpressions.Regex.Replace(content, @"\[del\](?<x>[^\]]*)\[/del\]", @"<del>$1</del>", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        content = System.Text.RegularExpressions.Regex.Replace(content, @"\[blink\](?<x>[^\]]*)\[/blink\]", @"<blink>$1</blink>", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        content = System.Text.RegularExpressions.Regex.Replace(content, @"\[sub\](?<x>[^\]]*)\[/sub\]", @"<sub>$1</sub>", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        content = System.Text.RegularExpressions.Regex.Replace(content, @"\[sup\](?<x>[^\]]*)\[/sup\]", @"<sup>$1</sup>", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        content = System.Text.RegularExpressions.Regex.Replace(content, @"\[list\](?<x>[^\]]*)\[/list\]", @"<li>$1</li>", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        content = System.Text.RegularExpressions.Regex.Replace(content, @"\[indent\](?<x>[^\]]*)\[/indent\]", @"<blockquote><p>$1</p></blockquote>", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        content = System.Text.RegularExpressions.Regex.Replace(content, @"\[quote\](?<x>[^\]]*)\[/quote\]", @"以下内容为引用：<table border=0 width=95% cellpadding=10 cellspacing=1 bgcolor=#000000><tr><td bgcolor=#FFFFFF>$1</td></tr></table>", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
        return content;
    }

    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    {
        try
        {
            string riji, sql;
            riji = DateTime.Now.ToString();
            sql = "update guestbook set hf='" + Content.Text + "',hf_date='回复时间：" + riji + "' where id=" + Request["id"];
            OleDbCommand da = new OleDbCommand(sql, myconn);
            da.Connection.Open();
            da.ExecuteNonQuery();
            da.Connection.Close();
            Response.Redirect("index.aspx");
        }
        catch (Exception e3)
        {
            Response.Write(e3.Message);
        }

    }
    protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
    {
        try
        {
            string sql3 = "delete from guestbook where id=" + Request["id"];
            OleDbCommand da8 = new OleDbCommand(sql3, myconn);
            da8.Connection.Open();
            da8.ExecuteNonQuery();
            da8.Connection.Close();
            Response.Redirect("index.aspx");
        }
        catch (Exception e2)
        {
            Response.Write(e2.Message);
        }

    }
}