edituserinfo.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;

namespace HotelHome.user
{
	/// <summary>
	/// EditUserInfo 的摘要说明。
	/// </summary>
	public class EditUserInfo : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label Header1_Label;
		protected System.Web.UI.WebControls.Label Header2_Label;
		protected System.Web.UI.WebControls.Label Header3_Label;
		protected System.Web.UI.WebControls.Label IDLabel;
		protected System.Web.UI.WebControls.Label NameLabel;
		protected System.Web.UI.WebControls.TextBox NameTextbox;
		protected System.Web.UI.WebControls.Label TelLabel;
		protected System.Web.UI.WebControls.TextBox TelTextbox;
		protected System.Web.UI.WebControls.Label MailLabel;
		protected System.Web.UI.WebControls.TextBox MailTextbox;
		protected System.Web.UI.WebControls.Label AddrLabel;
		protected System.Web.UI.WebControls.TextBox AddrTextbox;
		protected System.Web.UI.WebControls.Label NewPwdLabel;
		protected System.Web.UI.WebControls.Label RePwdLabel;
		protected System.Web.UI.WebControls.Label QuestionLabel;
		protected System.Web.UI.WebControls.TextBox QuestionTextbox;
		protected System.Web.UI.WebControls.Label AnswerLabel;
		protected System.Web.UI.WebControls.TextBox AnswerTextbox;
		protected System.Web.UI.WebControls.Button UpdateButton;
		protected System.Web.UI.HtmlControls.HtmlTable EditUserInfoTable;
		DBService clcon;
		DataRow row;
		protected System.Web.UI.WebControls.RequiredFieldValidator r1;
		protected System.Web.UI.WebControls.TextBox IDTextbox;
		protected System.Web.UI.WebControls.RequiredFieldValidator r2;
		protected System.Web.UI.WebControls.RequiredFieldValidator r3;
		protected System.Web.UI.WebControls.RequiredFieldValidator r4;
		protected System.Web.UI.WebControls.RequiredFieldValidator r5;
		protected System.Web.UI.WebControls.LinkButton LinkButton1;
		protected System.Web.UI.HtmlControls.HtmlInputText NewPwdTextbox;
		protected System.Web.UI.HtmlControls.HtmlInputText RePwdTextbox;
		DataSet myds;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			//Session["memID"] = "xyy";
			clcon = new DBService();

			if(!this.IsPostBack)
			{
				string sqlstring = "select * from member";

				myds = clcon.executeBySQL(sqlstring);
				int num = myds.Tables[0].Rows.Count;
				if(num > 0)
				{
					for(int i=0; i<num; i++)
					{
						row = myds.Tables[0].Rows[i];
						if(((string)row["memID"]).Equals(Session["memID"]))
						{
							IDTextbox.Text = (string)row["memID"];
							NameTextbox.Text = (string)row["Name"];
							TelTextbox.Text = (string)row["TelNumber"];
							MailTextbox.Text = (string)row["Email"];
							AddrTextbox.Text = (string)row["MemAddr"];
							QuestionTextbox.Text = (string)row["question"];
							AnswerTextbox.Text = (string)row["answer"];
						}
					}
				}
			}
		}

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

		}
		#endregion

		public void lnk_click(Object Src,EventArgs E)
		{
			Response.Redirect("../index.aspx");
		}

		private void UpdateButton_Click(object sender, System.EventArgs e)
		{
			
			if(IDTextbox.Text == "")
			{
				Response.Write("<script>alert('必须输入会员名！');</script>");
				return;
			}
			if(NameTextbox.Text == "")
			{
				Response.Write("<script>alert('必须输入真实姓名！');</script>");
				return;
			}
			if(TelTextbox.Text == "")
			{
				Response.Write("<script>alert('必须输入联系电话！');</script>");
				return;
			}
			if(QuestionTextbox.Text == "")
			{
				Response.Write("<script>alert('必须输入密码提示问题！');</script>");
				return;
			}
			if(AnswerTextbox.Text == "")
			{
				Response.Write("<script>alert('必须输入答案');</script>");
				return;
			}
			

			if(NewPwdTextbox.Value == "" && RePwdTextbox.Value == "")
			{																							
				string sqlstring = "update member SET memID = '"+ IDTextbox.Text.Trim() +" ',";
				sqlstring += " Name = '"+ NameTextbox.Text.Trim() +" ',";
				sqlstring += " TelNumber = '"+ TelTextbox.Text.Trim() +" ',";
				sqlstring += " Email = '"+ MailTextbox.Text.Trim() +" ',";
				sqlstring += " MemAddr = '"+ AddrTextbox.Text.Trim() +" ',";
				sqlstring += " question = '"+ QuestionTextbox.Text.Trim() +" ',";
				sqlstring += " answer = '"+ AnswerTextbox.Text.Trim() +" '";
				sqlstring += " where memID = '"+ (string)Session["memID"] +" '";

				clcon.ExecuteNonQuery(sqlstring);

				Response.Write("<script>alert('修改成功！');</script>");
			}
			else
			{
				if(NewPwdTextbox.Value.Equals(RePwdTextbox.Value))
				{
					string sqlstring = "update member SET memID = '"+ IDTextbox.Text.Trim() +" ',";
					sqlstring += " Name = '"+ NameTextbox.Text.Trim() +" ',";
					sqlstring += " TelNumber = '"+ TelTextbox.Text.Trim() +" ',";
					sqlstring += " Email = '"+ MailTextbox.Text.Trim() +" ',";
					sqlstring += " MemAddr = '"+ AddrTextbox.Text.Trim() +" ',";
					sqlstring += " MemPwd = '"+ RePwdTextbox.Value.Trim() +" ',";
					sqlstring += " question = '"+ QuestionTextbox.Text.Trim() +" ',";
					sqlstring += " answer = '"+ AnswerTextbox.Text.Trim() +" '";
					sqlstring += " where memID = '"+ (string)Session["memID"] +" '";

					clcon.ExecuteNonQuery(sqlstring);

					Response.Write("<script>alert('修改成功！');</script>");
				}
				else
				{
					Response.Write("<script>alert('新密码与确认新密码不一致！请重新输入！');</script>");
				}
			}
		}

	}
}