reply.aspx.cs

用C#+Access写的留言本

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Data.OleDb;
using System.Drawing;
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.IO;

public partial class Reply : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
       // Label2.Visible = true;
        if (Session["Admin"] == null)
        {
            Response.Write("<script> alert('对不起,您没有足够权限进行此操作！')</script>");
            Response.Redirect("Login.aspx");
        }
        else
        {
         //   Label2.Visible = false;
            if (!Page.IsPostBack)
                BindData();
        }

    }
    private void BindData()
    {
        int ID = Convert.ToInt32(Request.QueryString["ID"]);
        string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=";
        strConn += Server.MapPath(".\\Data\\BookData.mdb");
        OleDbConnection myConn = new OleDbConnection(strConn);
        //定义数据适配器
        //OleDbDataAdapter oda = new OleDbDataAdapter();
        OleDbCommand oda = new OleDbCommand("select * from GuestBook where ID = @ID", myConn);
        oda.Parameters.Add("@ID", OleDbType.Integer, 8).Value = ID;
        myConn.Open();

        //创建数据集
        //DataSet ds = new DataSet();
        OleDbDataReader reader = oda.ExecuteReader(CommandBehavior.SingleRow);
        reader.Read();
        UserName.Text = reader["UserName"].ToString();
        IsSex.Text = reader["lstSex"].ToString();
        IsOicq.Text = reader["Oicq"].ToString();
        Email.Text = reader["Email"].ToString();
        Homepage.Text = reader["Homepage"].ToString();
        IsContent.Text = UbbReplace(reader["Content"].ToString());

        //创建所有数集
        //oda.Fill(ds, "GuestBook");
        //Label1.Text = Server.HtmlEncode(ds.Tables["GuestBook"].Rows[0][2].ToString());
        //Label2.Text = Server.HtmlEncode(ds.Tables["GuestBook"].Rows[0][3].ToString());
        //Label3.Text = Server.HtmlEncode(ds.Tables["GuestBook"].Rows[0][4].ToString());
        myConn.Close();
        reader.Close();
    }

    protected void Submit_Click(object sender, EventArgs e)
    {
        //ACCESS数据库的连接字符串
        int ID = Convert.ToInt32(Request.QueryString["ID"]);
        string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=";
        strConn += Server.MapPath(".\\Data\\BookData.mdb");
        string strSql = "update GuestBook set Reply=@RepContent where ID = @ID";
        OleDbConnection myConn=new OleDbConnection(strConn);
        OleDbCommand repConn = new OleDbCommand(strSql,myConn);
        repConn.Parameters.Add("@Reply", OleDbType.Char, 1000).Value = UbbReplace(TexContent.Text);
        repConn.Parameters.Add("@ID", OleDbType.Integer, 8).Value = ID;
        myConn.Open();
        repConn.ExecuteNonQuery();
        myConn.Close();
        Response.Write("<script> alert('回复留言成功！')</script>");
      //  Response.Write("<script>alert(\"回复留言成功!\");</script>");
        Response.Redirect("Default.aspx");

    }

    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;
    }

}