admin_change.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_change 的摘要说明。
	/// </summary>
	public class admin_change : 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.TextBox Username;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator;
		protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator;
		protected System.Web.UI.WebControls.TextBox Password;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator1;
		protected System.Web.UI.WebControls.TextBox oldPassword;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator2;
		protected System.Web.UI.WebControls.Button Submit;
		protected System.Web.UI.WebControls.Label myLabel;
		protected System.Web.UI.HtmlControls.HtmlInputHidden oldUsername;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if(!Page.IsPostBack)
			{
				string username = (string)Session["username"];
				if(username.Trim()!="")
				{
					Username.Text=(string)Session["username"];
					oldUsername.Value=(string)Session["username"];
				}
				else
				{
					Page.Visible=false;
				}
			}
		}
		
		#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.Submit.Click += new System.EventHandler(this.Submit_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void Submit_Click(object sender, System.EventArgs e)
		{
			SqlConnection1 = new SqlConnection(ConfigurationSettings.AppSettings["dsn"]);
			string pwd=(string)Session["pwd"];
			string newpwd=Password.Text.Trim();
			string oldpwd=oldPassword.Text.Trim();
			string user=Username.Text.Trim();
			string olduser=oldUsername.Value.Trim();
			pwd=pwd.Trim();
			if(Page.IsValid)
			{
				if(oldpwd==pwd)
				{
					if(user==olduser)
					{	 //修改用户密码	
						SqlCommand1=new SqlCommand("sp_updateAdminPwd",SqlConnection1); 
						SqlCommand1.CommandType=CommandType.StoredProcedure;
						SqlCommand1.Parameters.Add("@password",SqlDbType.Char,200);
						SqlCommand1.Parameters["@password"].Value = newpwd;
						SqlCommand1.Parameters.Add("@id",SqlDbType.BigInt);
						SqlCommand1.Parameters["@id"].Value = (Int64)Session["id"];
						try
						{
							SqlConnection1.Open();
							int i=SqlCommand1.ExecuteNonQuery();
							if(i>0)
							{
								myLabel.Text="修改成功";
							}
							else
							{
								myLabel.Text="修改失败";
							}
						}
						catch (SqlException e1)
						{
							myLabel.Text ="数据库操作错误："+e1.Message;
						}
						finally
						{
							SqlConnection1.Close();			
						}						
					}
					else
					{	//验证是否已有此用户
						SqlCommand1=new SqlCommand("sp_selAdminByUserName",SqlConnection1); 
						SqlCommand1.CommandType=CommandType.StoredProcedure;
						SqlCommand1.Parameters.Add("@username",SqlDbType.Char,200);
						SqlCommand1.Parameters["@username"].Value =Username.Text.Trim();   
						try
						{
							SqlConnection1.Open();
							SqlDataReader1=SqlCommand1.ExecuteReader();	
							if(SqlDataReader1.Read()==true)   
							{
								myLabel.Text="已有此用户";
								SqlDataReader1.Close();
							}
							else
							{
								SqlDataReader1.Close();
								SqlCommand1=new SqlCommand("sp_updateAdminUserPwd",SqlConnection1); 
								SqlCommand1.CommandType=CommandType.StoredProcedure;
								SqlCommand1.Parameters.Add("@password",SqlDbType.Char,200);
								SqlCommand1.Parameters["@password"].Value = newpwd;
								SqlCommand1.Parameters.Add("@username",SqlDbType.Char,200 );
								SqlCommand1.Parameters["@username"].Value = user;
								SqlCommand1.Parameters.Add("@id",SqlDbType.BigInt);
								SqlCommand1.Parameters["@id"].Value = (Int64)Session["id"];
								int i=SqlCommand1.ExecuteNonQuery();
								if(i>0)
								{
									myLabel.Text="修改成功";
								}								
							}
						}
						catch (SqlException e1)
						{
							myLabel.Text ="数据库操作错误："+e1.Message;
						}
						finally
						{
							
							SqlConnection1.Close();
						}
					}
				}
			}
		}

	}
}