admin_messageboard.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>
	/// admin_messageboard 的摘要说明。
	/// </summary>
	public class admin_messageboard : System.Web.UI.Page
	{
		protected System.Timers.Timer timer1;
		protected System.Web.UI.WebControls.DataList datalistshow;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if (Session.Count == 0)
				Page.Response.Redirect("admin.aspx");
			else
				if (Session["adminid"].ToString() == "") Page.Response.Redirect("admin.aspx");
			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();
			this.datalistshow.EditCommand += new System.Web.UI.WebControls.DataListCommandEventHandler(this.datalistshow_EditCommand);
			this.datalistshow.DeleteCommand += new System.Web.UI.WebControls.DataListCommandEventHandler(this.datalistshow_DeleteCommand);
			// 
			// timer1
			// 
			this.timer1.Enabled = true;
			this.Load += new System.EventHandler(this.Page_Load);
			((System.ComponentModel.ISupportInitialize)(this.timer1)).EndInit();

		}
		#endregion

		protected void BindDataList()
		{
            datalistshow.DataSource=DbHelper.GetSet("sp_selectallmessage");
			datalistshow.DataBind();

		}

		private void datalistshow_EditCommand(object source, System.Web.UI.WebControls.DataListCommandEventArgs e)
		{
				string adminid=Session["adminid"].ToString();
				string loginip=Request.ServerVariables["REMOTE_HOST"];
				string messageid=datalistshow.DataKeys[e.Item.ItemIndex].ToString();
				/*通过留言*/
				SqlParameter[] para1= {
										  new SqlParameter("@messageid",messageid)
									  };
				DbHelper.GetNonQuery("sp_passmessage",para1);          
				/*记录操作*/
				SqlParameter[] para2= {
										new SqlParameter("@adminid",adminid),
				                        new SqlParameter("@logintime",DateTime.Now.ToString()),
								        new SqlParameter("@loginip",loginip),
				                        new SqlParameter("@operationid","1"),
						                new SqlParameter("@messageid",messageid)
									   };
				DbHelper.GetNonQuery("sp_addpasslog",para2);
				BindDataList();
			}

		private void datalistshow_DeleteCommand(object source, System.Web.UI.WebControls.DataListCommandEventArgs e)
		{
			string adminid=Session["adminid"].ToString();
			string loginip=Request.ServerVariables["REMOTE_HOST"];
			string messageid=datalistshow.DataKeys[e.Item.ItemIndex].ToString();
			/*删除留言*/
			SqlParameter[] para1= {
									  new SqlParameter("@messageid",messageid)
								  };
			DbHelper.GetNonQuery("sp_deletemessage",para1);
            /*记录操作*/
			SqlParameter[] para2= {
									  new SqlParameter("@adminid",adminid),
									  new SqlParameter("@logintime",DateTime.Now.ToString()),
									  new SqlParameter("@loginip",loginip),
									  new SqlParameter("@operationid","2"),
									  new SqlParameter("@messageid",messageid)
								  };
			DbHelper.GetNonQuery("sp_adddeletelog",para2);
			BindDataList();
		}
	  }
}