📄 reply.aspx.cs
字号:
using System.Data.OleDb;
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
namespace book
{
/// <summary>
/// Reply 的摘要说明。
/// </summary>
public class Reply : System.Web.UI.Page
{
protected OleDbConnection myconn=new OleDbConnection();
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.ImageButton ImageButton1;
protected System.Web.UI.WebControls.TextBox Content;
protected System.Web.UI.WebControls.ImageButton ImageButton2;
private void Page_Load(object sender, System.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(" "," ");
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;
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.ImageButton1.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButton1_Click);
this.ImageButton2.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButton2_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void ImageButton1_Click(object sender, System.Web.UI.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);
}
}
private void ImageButton2_Click(object sender, System.Web.UI.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);
}
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -