admin_remark.aspx.cs

非常完整的新闻发布系统

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;
using System.Configuration;
namespace WebNews.admin
{
	/// <summary>
	/// admin_remark 的摘要说明。
	/// </summary>
	public class admin_remark : System.Web.UI.Page
	{
		protected System.Data.SqlClient.SqlConnection SqlConnection1;		//添加数据库的操作对象
		protected System.Data.SqlClient.SqlDataAdapter SqlDataAdapter1;
		protected System.Data.DataSet DataSet1;
		protected System.Data.SqlClient.SqlCommand SqlCommand1;
		protected System.Data.SqlClient.SqlDataReader SqlDataReader1;		

		protected System.Web.UI.WebControls.Label myLabel;
		protected System.Web.UI.WebControls.TextBox keyword;
		protected System.Web.UI.WebControls.DropDownList search;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.ImageButton ImageButton1;
		protected System.Web.UI.WebControls.LinkButton btnFirst;
		protected System.Web.UI.WebControls.LinkButton LinkButton2;
		protected System.Web.UI.WebControls.LinkButton Linkbutton3;
		protected System.Web.UI.WebControls.LinkButton Linkbutton4;
		protected System.Web.UI.WebControls.Label lblCurrentIndex;
		protected System.Web.UI.WebControls.Label lblPageCount;	
		protected System.Web.UI.WebControls.DataGrid MyDataGrid;
		

		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if(!Page.IsPostBack)
			{
				string dr=(string)Session["userclass"];
				string a= (string)Session["classname"];
				string b=Request["classname"];
				if(dr.Trim()=="系统管理员")
				{
					getRemark();
				}
				else
				{
					if((int)Session["remark"]==1 &&a.Trim()==b.Trim())
					{
						getRemark();
					}  
					else 
					{
						myLabel.Text="你无权管理评论";
					}
				}   			
			}
		}

		private void getRemark()	   //获得评论
		{
			SqlConnection1 = new SqlConnection(ConfigurationSettings.AppSettings["dsn"]);
			SqlDataAdapter1 = new SqlDataAdapter();
			SqlDataAdapter1.SelectCommand=new SqlCommand("sp_selRemarkByArticleId",SqlConnection1);
			SqlDataAdapter1.SelectCommand.CommandType=CommandType.StoredProcedure ;
			SqlDataAdapter1.SelectCommand.Parameters.Add("@articleid",SqlDbType.BigInt);
			SqlDataAdapter1.SelectCommand.Parameters["@articleid"].Value=Request["articleid"];
			DataSet1=new DataSet();		
			try
			{
				SqlDataAdapter1.Fill(DataSet1,"Article");
			}
			catch (SqlException e1)
			{
				myLabel.Text ="数据库操作错误："+e1.Message;				
			}
			MyDataGrid.DataSource=DataSet1;
			MyDataGrid.DataBind();				
			lblCurrentIndex.Text="第"+((Int32)MyDataGrid.CurrentPageIndex+1)+"页";
			lblPageCount.Text="/共"+MyDataGrid.PageCount+"页";
		}
		
		public	void PagerButtonClick(Object sender, EventArgs e)
		{
			//获得LinkButton的参数值
			string arg = ((LinkButton)sender).CommandArgument;
			switch(arg)
			{
				case ("next"):
					if (MyDataGrid.CurrentPageIndex < (MyDataGrid.PageCount - 1))
						MyDataGrid.CurrentPageIndex ++;
					break;
				case ("prev"):
					if (MyDataGrid.CurrentPageIndex > 0)
						MyDataGrid.CurrentPageIndex --;
					break;
				case ("last"):
					MyDataGrid.CurrentPageIndex = (MyDataGrid.PageCount - 1);
					break;
				case("first"):
					MyDataGrid.CurrentPageIndex =0;
					break;
			}
			getRemark();
		}
		#region Web Form Designer generated code
		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.MyDataGrid.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.MyDataGrid_DeleteCommand);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		public void MyDataGrid_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			SqlConnection1 = new SqlConnection(ConfigurationSettings.AppSettings["dsn"]);
			SqlCommand1=new SqlCommand("sp_delRemarkById",SqlConnection1); 
			SqlCommand1.CommandType=CommandType.StoredProcedure;
			SqlCommand1.Parameters.Add(new SqlParameter("@id",SqlDbType.BigInt));
			SqlCommand1.Parameters["@id"].Value = MyDataGrid.DataKeys[e.Item.ItemIndex];	
			try
			{
				SqlConnection1.Open();
				int i=SqlCommand1.ExecuteNonQuery();
				if(i>0)
				{
					myLabel.Text="删除成功";
				}						
			}
			catch (SqlException e1)
			{
				myLabel.Text ="数据库操作错误："+e1.Message;
			}
			finally
			{
				SqlConnection1.Close();			
			}
			if(MyDataGrid.CurrentPageIndex>0)
			{
				MyDataGrid.CurrentPageIndex=MyDataGrid.CurrentPageIndex-1;
			}
			getRemark();
		}

		private void ImageButton1_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			if(Page.IsValid)
			{
				SqlConnection1 = new SqlConnection(ConfigurationSettings.AppSettings["dsn"]);//取连接字符串,建连接
				SqlDataAdapter1 = new SqlDataAdapter();		
				if(search.SelectedIndex==0)	
				{
					SqlDataAdapter1.SelectCommand=new SqlCommand("sp_searchRemarkByBody",SqlConnection1);	 
					SqlDataAdapter1.SelectCommand.CommandType=CommandType.StoredProcedure ;
					SqlDataAdapter1.SelectCommand.Parameters.Add("@body",SqlDbType.NVarChar ,1000);
					SqlDataAdapter1.SelectCommand.Parameters["@body"].Value=keyword.Text.Trim();				
				}
				else 
				{
					SqlDataAdapter1.SelectCommand=new SqlCommand("sp_searchRemarkByAuthor",SqlConnection1);	 
					SqlDataAdapter1.SelectCommand.CommandType=CommandType.StoredProcedure ;
					SqlDataAdapter1.SelectCommand.Parameters.Add("@username",SqlDbType.NVarChar ,1000);
					SqlDataAdapter1.SelectCommand.Parameters["@username"].Value=keyword.Text.Trim(); 
				}
				DataSet1=new DataSet();		
				try
				{
					SqlDataAdapter1.Fill(DataSet1,"Article");
				}
				catch (SqlException e1)
				{
					myLabel.Text ="数据库操作错误："+e1.Message;				
				}
				MyDataGrid.DataSource=DataSet1;
				MyDataGrid.DataBind();				
			}		
		}
	}
}