modifyquestion.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>
	/// modifyQuestion 的摘要说明。
	/// </summary>
	public class modifyQuestion : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.TextBox txtSubject;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.TextBox txtKeyWord;
		protected System.Web.UI.WebControls.DropDownList listType;
		protected FreeTextBoxControls.FreeTextBox FreeTextBox1;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		protected System.Web.UI.WebControls.Button btnAddQuestion;
		protected System.Web.UI.WebControls.Label lblMsg;
	
		dayi.controlDatabase cd=new controlDatabase();

		private void Page_Load(object sender, System.EventArgs e)
		{
			if(!this.IsPostBack)
			{

				//显示已知内容
				try
				{
					string sql="select * from [questions] where [id]="+Request.QueryString["questionid"].ToString();
					DataTable dt=cd.getDataTable(sql);
					if(dt.Rows.Count>0)
					{
						this.txtSubject.Text=dt.Rows[0]["subject"].ToString().Trim();
						this.txtKeyWord.Text=dt.Rows[0]["keyword"].ToString().Trim();
						this.FreeTextBox1.Text=dt.Rows[0]["content"].ToString();
						
						string parentID=dt.Rows[0]["parentID"].ToString().Trim();
						string rootID=dt.Rows[0]["rootID"].ToString().Trim();
						string boardPath=dt.Rows[0]["boardPath"].ToString().Trim();

						string listValue=parentID+"#"+rootID+"#"+boardPath;
						if(parentID==rootID)
						{
							listValue=parentID+"#0#"+boardPath;
						}
						cd.bindToDropDownList(0,this.listType);
						this.listType.SelectedValue=listValue;
					}
				}
				catch(Exception ee)
				{
					Response.Redirect("err.aspx?err="+ee.Message);
					//Response.Write(ee.ToString());
				}
			}
		}

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

		}
		#endregion

		private void btnAddQuestion_Click(object sender, System.EventArgs e)
		{
			//修改问题
			string subject=this.txtSubject.Text.Trim();
			string keyword=this.txtKeyWord.Text.Trim();
			keyword=keyword.Replace("，",",");
			string content=this.FreeTextBox1.Text;
			string path=this.listType.SelectedValue;
			
			try
			{
				int questionid=0;
				if(Request.QueryString["questionID"]!=null)
				{
					questionid=Convert.ToInt32(Request.QueryString["questionID"]);
				}
				//更新数据库
				cd.modifyQuestion(questionid,subject,keyword,path,content,"question");
				this.lblMsg.Text="修改成功";
				if(Request.QueryString["from"].ToString()=="master")
				{
					Response.Redirect("manageQuestion.aspx");
				}
				else
				{
					Response.Redirect("userQuestion.aspx");
				}
			}
			catch(Exception)
			{
				//Response.Redirect("err.aspx?err="+ee.Message);
			}
		}
	}
}