default.aspx.cs

前台用户可以在线留言

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
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 messageboardtest.DataAccess;

namespace messageboardtest
{
	/// <summary>
	/// _default 的摘要说明。
	/// </summary>
	public class _default : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.TextBox tbusername;
		protected System.Web.UI.WebControls.TextBox tbusermessage;
		protected System.Web.UI.WebControls.Button tbsubmit;
		protected System.Web.UI.WebControls.Button tbcancel;
		protected System.Timers.Timer timer1;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.DropDownList ddlblock;
		protected System.Web.UI.WebControls.DataList datalistshow;
		
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if(!Page.IsPostBack)
			{
			    BindDataList();
			}
	
		}

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

		}
		#endregion
		protected void BindDataList()
		{
			/*显示留言分类*/
			ddlblock.DataSource=DbHelper.GetSet("sp_selectblocktype");
			ddlblock.DataTextField="blockname";
			ddlblock.DataValueField="blockid";
			ddlblock.DataBind();			
			/*显示已经审核过的留言*/
			SqlParameter[] para= {
									  new SqlParameter("@ischeck",true)
								  };  
			datalistshow.DataSource=DbHelper.GetSet("sp_selectmessage",para);
			datalistshow.DataBind();
		}

		private void tbsubmit_Click(object sender, System.EventArgs e)
		{
			try
			{
				SqlParameter[] para= {
										 new SqlParameter("@username",tbusername.Text),
					                     new SqlParameter("@usermessage",tbusermessage.Text),
					                     new SqlParameter("@postime",DateTime.Now.ToString()),
					                     new SqlParameter("@userip",Request.ServerVariables["REMOTE_HOST"]),
                                         new SqlParameter("@blockid",ddlblock.SelectedValue),
					                     new SqlParameter("@ischeck",false),
									 }; 
				DbHelper.GetNonQuery("sp_insertmessage",para);
				Response.Write("<script language='javascript'>alert('谢谢您的留言，本站实行留言审查制度，审查通过后方可以显示');</script>");
				tbusername.Text="";
				tbusermessage.Text="";
			}
			catch(Exception ee)
			{
                Response.Write("<script language='javascript'>alert('错误："+ee.ToString()+"');</script>");
			}		
	    }

		private void tbcancel_Click(object sender, System.EventArgs e)
		{
			tbusername.Text="";
			tbusermessage.Text="";
		}
}
}