admin_showmasterdetail.aspx.cs

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

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 dayi
{
	/// <summary>
	/// admin_showMasterDetail 的摘要说明。
	/// </summary>
	public class admin_showMasterDetail : 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 RequiredFieldValidator2;
		protected System.Web.UI.WebControls.TextBox txtUserPwd;
		protected System.Web.UI.WebControls.TextBox txtUserName;
		protected System.Web.UI.WebControls.Label lblMsg;
		protected System.Web.UI.WebControls.LinkButton btnBack;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
	
		dayi.controlDatabase cd=new controlDatabase();

		private void Page_Load(object sender, System.EventArgs e)
		{
			if(!this.IsPostBack)
			{
				if(Session["userType"].ToString()!="admin")
				{
					//确认身份
					Response.Redirect("err.aspx?err=没有权限");
				}
				//得到注册资料
				try
				{
					int id=Convert.ToInt32(Request.QueryString["id"]);
					
					if(Session["userType"].ToString()=="admin")
					{
						string sql="select * from [master] where [id]="+id;
						DataTable dt=cd.getDataTable(sql);
						if(dt.Rows.Count>0)
						{
							this.txtUserName.Text=dt.Rows[0]["masterName"].ToString().Trim();;
							//this.txtUserPwd.Text=dt.Rows[0]["masterPwd"].ToString().Trim();
							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.btnBack.Click += new System.EventHandler(this.btnBack_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void btnRegiste_Click(object sender, System.EventArgs e)
		{
			try
			{
				int id=Convert.ToInt32(Request.QueryString["id"]);
				if(Session["userType"].ToString()=="admin")
				{
					//修改资料
					string masterName=this.txtUserName.Text.Trim().Replace("'","");
					string masterPwd=this.txtUserPwd.Text.Trim().Replace("'","");
					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 masterName='"+masterName+"',masterPwd='"+masterPwd+"',realName='"+realName+"',className='"+className+"',";
					updateSql+="email='"+email+"',mobile='"+mobile+"',tel='"+tel+"',boardName='"+boardName+"',reason='"+reason+"' where id="+id;

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

					this.lblMsg.Text="修改成功";
				}
			}
			catch(Exception)
			{
				Response.Redirect("err.aspx?err=出现错误,请联系管理员");
			}
		}

		private void btnBack_Click(object sender, System.EventArgs e)
		{
			Response.Redirect("admin_manageApply.aspx");
		}
	}
}