admin_user.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_user 的摘要说明。
	/// </summary>
	public class admin_user : 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.DataGrid MyDataGrid;
		protected System.Web.UI.WebControls.Label myLabel;
		protected System.Web.UI.WebControls.Label lblCurrentIndex;
		protected System.Web.UI.WebControls.LinkButton btnFirst;
		protected System.Web.UI.WebControls.LinkButton LinkButton2;
		protected System.Web.UI.WebControls.LinkButton LinkButton1;
		protected System.Web.UI.WebControls.LinkButton LinkButton3;
		protected System.Web.UI.WebControls.DropDownList UserClass;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;		
		protected System.Web.UI.WebControls.Panel Panel1;
		protected System.Web.UI.WebControls.Button Submit;
		protected System.Web.UI.WebControls.DropDownList UserClass1;
		protected System.Web.UI.WebControls.CompareValidator CompareValidator1;
		protected System.Web.UI.WebControls.RequiredFieldValidator Requiredfieldvalidator5;
		protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator2;
		protected System.Web.UI.WebControls.TextBox Password2;
		protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator1;
		protected System.Web.UI.WebControls.RequiredFieldValidator Requiredfieldvalidator4;
		protected System.Web.UI.WebControls.TextBox Password1;
		protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator;
		protected System.Web.UI.WebControls.TextBox Username1;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator3;
		protected System.Web.UI.WebControls.TextBox Remarks1;
		protected System.Web.UI.WebControls.Label lblPageCount;
		protected static int id;

		private void Page_Load(object sender, System.EventArgs e)
		{	// 在此处放置用户代码以初始化页面
			if(! Page.IsPostBack)
			{
				Panel1.Visible=false;
				string userclass = (string)Session["userclass"];
				if(userclass.Trim()=="系统管理员")
				{
					getAdmin();
				}
				else 
				{
					Page.Visible=false;
				}
			}			
		}

		private void getAdmin()	   //填充DataGrid
		{
			SqlConnection1 = new SqlConnection(ConfigurationSettings.AppSettings["dsn"]);
			SqlDataAdapter1 = new SqlDataAdapter();
			SqlDataAdapter1.SelectCommand=new SqlCommand("sp_selAdminAll",SqlConnection1);
			SqlDataAdapter1.SelectCommand.CommandType=CommandType.StoredProcedure;
			DataSet1=new DataSet();		
			try
			{
				SqlDataAdapter1.Fill(DataSet1,"Admin");
			}
			catch (SqlException e1)
			{
				myLabel.Text ="数据库操作错误："+e1.Message;				
			}
			MyDataGrid.DataSource=DataSet1;
			MyDataGrid.DataBind();			
			lblCurrentIndex.Text="第"+((Int32)MyDataGrid.CurrentPageIndex+1)+"页";
			lblPageCount.Text="/共"+MyDataGrid.PageCount+"页";
		}

		public string show(object a,object b)
		{   string d=a.ToString();
			string c=a+"(<a href=admin_popedom.aspx?username="+b+">修改权限</a></font>)"; 
			if(d.Trim()=="系统管理员")
			{
				return d;
			}
			else 
			{
			  return c;
			}
		}

		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;
			}
			getAdmin();
		}
		#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.MyDataGrid.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.MyDataGrid_ItemCommand);
			this.MyDataGrid.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.MyDataGrid_DeleteCommand);
			this.Submit.Click += new System.EventHandler(this.Submit_Click);
			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_delAdmin",SqlConnection1); 
			SqlCommand1.CommandType=CommandType.StoredProcedure;
			SqlCommand1.Parameters.Add("@id",SqlDbType.BigInt);
			SqlCommand1.Parameters["@id"].Value = MyDataGrid.DataKeys[e.Item.ItemIndex];
			try
			{
				SqlConnection1.Open();
				int i=SqlCommand1.ExecuteNonQuery();
				if(i>0)
				{
					myLabel.Text="删除成功";
					MyDataGrid.EditItemIndex = -1;					
					if(MyDataGrid.CurrentPageIndex>0)
					{
						MyDataGrid.CurrentPageIndex= MyDataGrid.CurrentPageIndex-1;
					}
				}
				else
				{
					myLabel.Text="删除错误！";
					MyDataGrid.EditItemIndex = -1;	
				}
			}
			catch (SqlException e1)
			{
				myLabel.Text ="数据库操作错误："+e1.Message;
			}
			finally
			{
				SqlConnection1.Close();			
			}
			getAdmin();		    
		}

		private void Submit_Click(object sender, System.EventArgs e)
		{	
			if(Page.IsValid)
			{	
				SqlConnection1 = new SqlConnection(ConfigurationSettings.AppSettings["dsn"]);				
				string dr=Username1.Text.Trim();
				string de=(string)Session["oldusername"];
				de=de.Trim();
				if(dr==de)		//如果用户名没有改动											
				{
					SqlCommand1=new SqlCommand("sp_updateAdmin",SqlConnection1); 
					SqlCommand1.CommandType=CommandType.StoredProcedure;
					SqlCommand1.Parameters.Add("@id",SqlDbType.BigInt);
					SqlCommand1.Parameters["@id"].Value = id;
					SqlCommand1.Parameters.Add("@username",SqlDbType.Char,40);
					SqlCommand1.Parameters["@username"].Value = Username1.Text.Trim();
					SqlCommand1.Parameters.Add("@password",SqlDbType.Char,40);
					SqlCommand1.Parameters["@password"].Value = Password1.Text.Trim();
					SqlCommand1.Parameters.Add("@userclass",SqlDbType.Char,40);
					SqlCommand1.Parameters["@userclass"].Value =UserClass1.SelectedItem.Text.Trim();
					SqlCommand1.Parameters.Add("@remark",SqlDbType.Char,200);
					SqlCommand1.Parameters["@remark"].Value = Remarks1.Text.Trim() ;
					try
					{
						SqlConnection1.Open();
						int i=SqlCommand1.ExecuteNonQuery();
						if(i>0)
						{
							myLabel.Text="更新成功";
							MyDataGrid.EditItemIndex = -1;		//回到编辑状态
						}
						else
						{
							myLabel.Text="更新错误！";
						}   
					}
					catch (SqlException e1)
					{
						myLabel.Text ="数据库操作错误："+e1.Message;
					}
					finally
					{
						SqlConnection1.Close();	
					}					
				}
				else
				{
					SqlCommand1=new SqlCommand("sp_addAdminValidate",SqlConnection1); 
					SqlCommand1.CommandType=CommandType.StoredProcedure;
					SqlCommand1.Parameters.Add("@username",SqlDbType.Char,40);
					SqlCommand1.Parameters["@username"].Value =Username1.Text;   
					try
					{
						SqlConnection1.Open();
						SqlDataReader1=SqlCommand1.ExecuteReader();	
						if(SqlDataReader1.Read()==true)   
						{
							myLabel.Text="已有此用户名，请重新输入一个！！";
							SqlDataReader1.Close();
						}						
						else
						{
							SqlDataReader1.Close();
							SqlCommand1=new SqlCommand("sp_updateAdmin",SqlConnection1); 
							SqlCommand1.CommandType=CommandType.StoredProcedure;
							SqlCommand1.Parameters.Add("@id",SqlDbType.BigInt);
							SqlCommand1.Parameters["@id"].Value = id;
							SqlCommand1.Parameters.Add("@username",SqlDbType.Char,40);
							SqlCommand1.Parameters["@username"].Value = Username1.Text.Trim();
							SqlCommand1.Parameters.Add("@password",SqlDbType.Char,40);
							SqlCommand1.Parameters["@password"].Value = Password1.Text.Trim();
							SqlCommand1.Parameters.Add("@userclass",SqlDbType.Char,40);
							SqlCommand1.Parameters["@userclass"].Value =UserClass1.SelectedItem.Text.Trim();
							SqlCommand1.Parameters.Add("@remark",SqlDbType.Char,200);
							SqlCommand1.Parameters["@remark"].Value = Remarks1.Text.Trim() ;							
							int i=SqlCommand1.ExecuteNonQuery();
							if(i>0)
							{
								myLabel.Text="更新成功";
								MyDataGrid.EditItemIndex = -1;		//回到编辑状态
							}
							else
							{
								myLabel.Text="更新错误！";
							} 							
						}				
					}
					catch (SqlException e1)
					{
						myLabel.Text ="数据库操作错误："+e1.Message;
					}
					finally
					{
						SqlDataReader1.Close();
						SqlConnection1.Close();
					}					
				}
				getAdmin();	
			}		
			
		}		

		private void MyDataGrid_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			switch(((LinkButton)e.CommandSource).CommandName)
			{

				case "Select":
					Panel1.Visible = true;
					id =Convert.ToInt16(MyDataGrid.DataKeys[e.Item.ItemIndex]);
					Username1.Text = e.Item.Cells[1].Text.Trim();
					Password1.Text= e.Item.Cells[2].Text.Trim();
					UserClass1.SelectedItem.Text = e.Item.Cells[3].Text.Trim();
					Remarks1.Text = e.Item.Cells[4].Text.Trim();					
					Session["oldusername"]=e.Item.Cells[1].Text.Trim();
					break;	
				default:
					// Do nothing.
					break;
			}		
		}

	}
}