password_modif.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 gwpj.DataAccess;

namespace gwpj
{
	/// <summary>
	/// PassWord_Modif 的摘要说明。
	/// </summary>
	public class PassWord_Modif : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.TextBox TextBox1;
		protected System.Web.UI.WebControls.TextBox TextBox2;
		protected System.Web.UI.WebControls.Button Button1;

		MyDB mydb = new MyDB();
		public string staff_code ="";
		public string staff_name = "";
	
		private void Page_Load(object sender, System.EventArgs e)
		{			
			staff_code = Session["staff_code"].ToString();				
			string sqlstr = "select staff_name from role_evaluate..evaluate_staff where staff_code = '"+staff_code+"'";
			staff_name = mydb.GetValue(sqlstr);
			
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.Button1.Click += new System.EventHandler(this.Button1_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void Button1_Click(object sender, System.EventArgs e)
		{
			if(TextBox1.Text.Trim()!="" && TextBox2.Text.Trim()!="")
			{
				if(TextBox1.Text == TextBox2.Text)
				{
					string password = TextBox2.Text;
					string sqlstr = "update role_evaluate..evaluate_staff set password = '"+password+"' where staff_code = '"+staff_code+"'";
					if(mydb.ExecuteSql(sqlstr)=="1")
					{
						Response.Write("<script>alert('密码修改成功！')</script>");
					}
					else
					{
						Response.Write("<script>alert('"+mydb.ExecuteSql(sqlstr).ToString()+"！')</script>");
					}
				}
				else
				{
					Response.Write("<script>alert('两次输入的密码不一致，请检查！')</script>");
				}
			}
			else{
				Response.Write("<script>alert('密码不能为空!')</script>");
				return;
			}
		}
	}
}