updatemastermsg.aspx.cs

网上自动答疑系统(C#)

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.Security;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace dayi
{
	/// <summary>
	/// updateMasterMsg 的摘要说明。
	/// </summary>
	public class updateMasterMsg : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator5;
		protected System.Web.UI.WebControls.Button btnRegiste;
		protected System.Web.UI.WebControls.TextBox txtReason;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator3;
		protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator1;
		protected System.Web.UI.WebControls.TextBox txtEmail;
		protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator2;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator9;
		protected System.Web.UI.WebControls.TextBox txtMobile;
		protected System.Web.UI.WebControls.TextBox txtTel;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator8;
		protected System.Web.UI.WebControls.TextBox txtBoardName;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator7;
		protected System.Web.UI.WebControls.TextBox txtClassName;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator6;
		protected System.Web.UI.WebControls.TextBox txtRealName;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator4;
		protected System.Web.UI.WebControls.CompareValidator CompareValidator1;
		protected System.Web.UI.WebControls.TextBox txtUserPwd2;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		protected System.Web.UI.WebControls.TextBox txtUserPwd;
		protected System.Web.UI.WebControls.Label lblUserName;
		protected System.Web.UI.WebControls.Label lblMsg;
	
		dayi.controlDatabase cd=new controlDatabase();

		private void Page_Load(object sender, System.EventArgs e)
		{
			if(!this.IsPostBack)
			{
				if(Session["userType"].ToString().IndexOf("master")<0)
				{
					//身份验证
					Response.Redirect("err.aspx?err=没有权限，可能没有登录");
				}
				//得到注册资料
				try
				{
					string userName=Session["userName"].ToString();
					if(userName!="" && Session["userType"].ToString().IndexOf("master")>-1)
					{
						string sql="select * from [master] where masterName='"+userName+"'";
						DataTable dt=cd.getDataTable(sql);
						if(dt.Rows.Count>0)
						{
							this.lblUserName.Text=userName;
							this.txtRealName.Text=dt.Rows[0]["realName"].ToString().Trim();
							this.txtBoardName.Text=dt.Rows[0]["boardName"].ToString().Trim();
							this.txtClassName.Text=dt.Rows[0]["className"].ToString().Trim();
							this.txtEmail.Text=dt.Rows[0]["email"].ToString().Trim();
							this.txtMobile.Text=dt.Rows[0]["mobile"].ToString().Trim();
							this.txtTel.Text=dt.Rows[0]["tel"].ToString().Trim();
							this.txtReason.Text=dt.Rows[0]["reason"].ToString();
						}
					}
				}
				catch(Exception ee)
				{
					Response.Redirect("err.aspx?err="+ee.Message);
				}
			}
		}

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

		}
		#endregion

		private void btnRegiste_Click(object sender, System.EventArgs e)
		{
			try
			{
				string userName=Session["userName"].ToString();
				if(userName!="" && Session["userType"].ToString().IndexOf("master")>-1)
				{
					//修改资料
					string masterPwd=this.txtUserPwd.Text.Trim().Replace("'","");
					masterPwd=FormsAuthentication.HashPasswordForStoringInConfigFile(masterPwd,"sha1");//加密
					string realName=this.txtRealName.Text.Trim().Replace("'","");
					string className=this.txtClassName.Text.Trim().Replace("'","");
					string email=this.txtEmail.Text.Trim().Replace("'","");
					string mobile=this.txtMobile.Text.Trim().Replace("'","");
					string tel=this.txtTel.Text.Trim().Replace("'","");
					string boardName=this.txtBoardName.Text.Trim().Replace("'","");
					string reason=this.txtReason.Text.Trim().Replace("'","");

					//修改表master中的数据
					string updateSql="update [master] set masterPwd='"+masterPwd+"',realName='"+realName+"',className='"+className+"',";
					updateSql+="email='"+email+"',mobile='"+mobile+"',tel='"+tel+"',boardName='"+boardName+"',reason='"+reason+"' where masterName='"+userName+"'";

					cd.updateDatabase(updateSql);
					//修改表board中的数据
					updateSql="update [board] set boardName='"+boardName+"' where boardMaster='"+userName+"' and rootID=0";
					cd.updateDatabase(updateSql);

					this.lblMsg.Text="修改成功";
				}
			}
			catch(Exception ee)
			{
				Response.Redirect("err.aspx?err="+ee.Message);
			}
		}
	}
}