admin_change.aspx.cs

这个是用vc编写的新闻管理系统

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.Web.UI.WebControls.Label Label1;
		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.HtmlControls.HtmlInputHidden oldUsername;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if(!Page.IsPostBack)
			{
				string username;
				username=(string)Session["username"];
				if(username.Trim()!="")
				{
					Username.Text=(string)Session["username"];
					oldUsername.Value=(string)Session["username"];
				}
				else Page.Visible=false;
			}
		}
		private bool validateUser()		   //验证是否已有此用户
		{
			try
			{
				string con=ConfigurationSettings.AppSettings["dsn"];	//取得DSN字符
				SqlConnection  conn= new SqlConnection(con);//连接字符串
				conn.Open();

				SqlCommand val=new SqlCommand("sp_selAdminByUserName",conn);   //通过存储过程查看用户
				val.CommandType=CommandType.StoredProcedure;
			SqlParameter user=val.Parameters.Add("@username",SqlDbType.Char,200);			   //参数设定
			user.Value=Username.Text.Trim();
				SqlDataReader rd;
				rd=val.ExecuteReader();
				
				if(rd.Read()==true)
				{
					Label1.Text="已有此用户";
					return false;
				}
				else 
					return true;
			}
			catch(SqlException e)									  //出错处理
			{
			  Response.Write("SqlException in Main: " + e.Message);
				return false;
			}

		}		
		private void updatepwd(string d)									 //修改用户密码
				  {
					  try
					  {
						  string con=ConfigurationSettings.AppSettings["dsn"];	//取得DSN字符
						  SqlConnection  conn= new SqlConnection(con);//连接字符串
						  conn.Open();
						  
						// SqlCommand val=new SqlCommand("sp_1",conn); 
						SqlCommand val=new SqlCommand("sp_updateAdminPwd",conn);   //通过存储过程查看用户
						  val.CommandType=CommandType.StoredProcedure;
						SqlParameter pwd=val.Parameters.Add("@password",SqlDbType.Char,200 );			   //参数设定
						pwd.Value=d;
						 SqlParameter id=val.Parameters.Add("@id",SqlDbType.BigInt );			   //参数设定
						id.Value=(Int64)Session["id"];
					//	  Response.Write(  (Int64)Session["id"]);
						  int i=val.ExecuteNonQuery();
						  if(i>0)
						  {
							  Label1.Text="修改成功!";
						  }
					  }
					  catch(SqlException e)
					  {
						Response.Write("SqlException in Main: " + e.Message);
					  }

				  }

		private void upPwdAndUser(string d,string f)						 //修改用户姓名与密码
		{
			try
			{
				string con=ConfigurationSettings.AppSettings["dsn"];	//取得DSN字符
				SqlConnection  conn= new SqlConnection(con);//连接字符串
				conn.Open();

		
			SqlCommand val=new SqlCommand("sp_updateAdminUserPwd",conn);   //通过存储过程查看用户
			val.CommandType=CommandType.StoredProcedure;
			SqlParameter pwd=val.Parameters.Add("@password",SqlDbType.Char,200 );			   //参数设定
			pwd.Value=d;
			SqlParameter ur=val.Parameters.Add("@username",SqlDbType.Char,200 );			   //参数设定
		    ur.Value=f;
		SqlParameter id=val.Parameters.Add("@id",SqlDbType.BigInt );			   //参数设定
		id.Value=(Int64)Session["id"];

			
				int i=val.ExecuteNonQuery();								 //修改用户名与密码
				
				if(i>0)
				{
					Label1.Text="修改成功";
			
				}
				else  Label1.Text="修改失败";

			}
			catch(SqlException e)
			{
				Response.Write("SqlException in Main: " + e.Message);
			}

		}

		#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)
		{	 
			  string pwd=(string)Session["pwd"];
			  string newpwd=Password.Text;
			  string oldpwd=oldPassword.Text;
			  string user=Username.Text;
			  string olduser=oldUsername.Value;
			   pwd=pwd.Trim();
			oldpwd=oldpwd.Trim();
			newpwd=newpwd.Trim();
			user=user.Trim();
			olduser=olduser.Trim();
			if(Page.IsValid)
			{
				if(oldpwd==pwd)
				{
					if(user==olduser)
					{
						
						updatepwd(newpwd);
					}
					else
					{
						if(validateUser())
						{
							
							upPwdAndUser(newpwd,user);

						}

					}

				}
				else
				{
					Label1.Text="密码错误！";
			
				}
			}
		}
	}
}