modifyforum.aspx.cs

c#网络编程及应用-刘瑞新

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;
using System.Data.SqlClient;

namespace WebApplication
{
	/// <summary>
	/// modifyforum 的摘要说明。
	/// </summary>
	public class modifyforum : System.Web.UI.Page
	{
		private string message;
		private string subid;

		protected System.Web.UI.WebControls.Label LabelMess;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.TextBox TextBoxTitle;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.TextBox TextBoxContent;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		protected System.Web.UI.WebControls.Button ButtonOK;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			message=Request.QueryString["mess"];
			switch(message)
			{
				case "0":   //发布信息
				{
					this.LabelMess.Text="发布信息";
					this.TextBoxTitle.ReadOnly=false;
					break;
				}
				case "1":  //修改论坛主题
				{
					this.LabelMess.Text="修改信息";
					SqlConnection conn=new SqlConnection(MyClass.ConnString);
					SqlCommand command=new SqlCommand("select * from mainforum where id="
						+Session["mainid"].ToString(),conn);
					conn.Open();
					SqlDataReader rd=command.ExecuteReader();
					if(rd.Read())
					{
						if(rd["author"].ToString().Trim()==Session["userName"].ToString())
						{
							this.TextBoxTitle.ReadOnly=false;
							this.TextBoxTitle.BackColor=Color.White;
							if(!Page.IsPostBack)
							{
								this.TextBoxTitle.Text=Session["zhuti"].ToString();
								this.TextBoxContent.Text=rd["content"].ToString();
							}
						}
						else
						{
							rd.Close();
							conn.Close();
							Response.Write("<script>"
								+"window.alert('抱歉，你不是原作者，不能修改！"
								+"');</script>");
							Server.Transfer("subforum.aspx"); 
						}
					}
					else
					{
						Response.Write("<script>window.alert('无此记录！');</script>");
					}
					rd.Close();
					conn.Close();
					break;
				}
				case "2":  //修改论坛回复
				{
					subid=Request.QueryString["subid"];
					this.LabelMess.Text="修改信息";
					SqlConnection conn=new SqlConnection(MyClass.ConnString);
					SqlCommand command=new SqlCommand("select * from subforum where id="
						+subid,conn);
					conn.Open();
					SqlDataReader rd=command.ExecuteReader();
					if(rd.Read())
					{
						if(rd["author"].ToString().Trim()==Session["userName"].ToString())
						{
							this.TextBoxTitle.ReadOnly=true;
							this.TextBoxTitle.BackColor=Color.Gray;
							if(!Page.IsPostBack)
							{
								this.TextBoxTitle.Text=Session["zhuti"].ToString();
								this.TextBoxContent.Text=rd["content"].ToString();
							}
						}
						else
						{
							rd.Close();
							conn.Close();
							Response.Write("<script>"
								+"window.alert('抱歉，你不是原作者，不能修改！');</script>");
							Server.Transfer("subforum.aspx");
						}
					}
					else
					{
						Response.Write("<script>window.alert('无此记录！');</script>");
					}
					rd.Close();
					conn.Close();
					break;
				}
				case "3":
				{
					this.LabelMess.Text="发表见解";
					this.TextBoxTitle.ReadOnly=true;
					this.TextBoxTitle.BackColor=Color.Gray;
					this.TextBoxTitle.Text=Session["zhuti"].ToString();
					break;
				}
			}

		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.ButtonOK.Click += new System.EventHandler(this.ButtonOK_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void ButtonOK_Click(object sender, System.EventArgs e)
		{
			string sss=this.TextBoxContent.Text.Trim();
			if(message=="0")
			{
				if(this.FindZhuTi()==true)
				{
					Response.Write("<script>window.alert('库中已经有要发布的主题，"
						+"无法重复发布！');</script>");
					return;
				}
				else
				{
					string str="insert into mainforum(title,content,author,releasetime) values('"
						+this.TextBoxTitle.Text.Trim()+"','"
						+this.TextBoxContent.Text.Trim()+"','"
						+Session["userName"].ToString()+"','"
						+DateTime.Now.ToString()+"')";
					ExecuteSql(str);
					Response.Redirect("forum.aspx");
				}
			}
			if(message=="1")
			{
				string str="update mainforum set content='"+sss
					+"',releasetime='"+DateTime.Now.ToString()
					+"',title='"+this.TextBoxTitle.Text.Trim()
					+"' where id="+Session["mainid"].ToString();
				ExecuteSql(str);
				Response.Redirect("subforum.aspx");
			}
			if(message=="2")
			{
				string subid=Request.QueryString["subid"];
				string str="update subforum set content='"
					+this.TextBoxContent.Text.Trim()+"',lastmodifytime='"
					+DateTime.Now.ToString()+"' where id="+subid;
				ExecuteSql(str);
				Response.Redirect("subforum.aspx");
			}
			if(message=="3")
			{
				if(this.FindNeiRong()==true)
				{
					Response.Write("<script>window.alert('添加失败："
						+"库中已经有要添加的内容！');</script>");
					return;
				}
				else
				{
					string str="insert into subforum(titleid,content,lastmodifytime,author) values('"
						+Session["mainid"].ToString()+"','"
						+this.TextBoxContent.Text.Trim()+"','"
						+DateTime.Now.ToString()+"','"
						+Session["userName"].ToString()+"')";
					ExecuteSql(str);
					Response.Redirect("subforum.aspx");
				}
			}

		}

		private void ExecuteSql(string sqlstr)
		{
			SqlConnection conn=new SqlConnection(MyClass.ConnString);
			conn.Open();
			SqlCommand command=new SqlCommand(sqlstr,conn);
			command.ExecuteNonQuery();
			conn.Close(); 
		}
		private bool FindZhuTi()
		{
			bool isFind=false;
			SqlConnection conn=new SqlConnection(MyClass.ConnString);
			SqlCommand command=
				new SqlCommand("select id,title from mainforum order by title",conn);
			SqlDataReader rd=null;
			conn.Open();
			rd=command.ExecuteReader();
			while(rd.Read())
			{
				if(rd["title"].ToString().Trim()==this.TextBoxTitle.Text.Trim())
				{
					isFind=true;
					break;
				}
			}
			rd.Close();
			conn.Close();
			return isFind;
		}

		private bool FindNeiRong()
		{
			bool isFind=false;
			SqlConnection conn=new SqlConnection(MyClass.ConnString);
			SqlCommand command=
				new SqlCommand("select id,content from subforum order by content",conn);
			SqlDataReader rd=null;
			conn.Open();
			rd=command.ExecuteReader();
			while(rd.Read())
			{
				if(rd["content"].ToString().Trim()==this.TextBoxContent.Text.Trim())
				{
					isFind=true;
					break;
				}
			}
			rd.Close();
			conn.Close();
			return isFind;
		}

	}
}