addaffiche.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>
	/// addAffiche 的摘要说明。
	/// </summary>
	public class addAffiche : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.TextBox txtSubject;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected FreeTextBoxControls.FreeTextBox FreeTextBox1;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		protected System.Web.UI.WebControls.Button btnAddQuestion;
		protected System.Web.UI.WebControls.Label lblTitle;
	
		dayi.controlDatabase cd=new controlDatabase();
		private void Page_Load(object sender, System.EventArgs e)
		{
			if(!this.IsPostBack)
			{
				if(Session["userType"].ToString().IndexOf("master")<0 && Session["userType"].ToString()!="admin")
				{
					//身份验证
					Response.Redirect("err.aspx?err=没有权限，可能没有登录");
				}
				try
				{
					string type=Request.QueryString["type"].ToString();
					if(type=="add")
					{
						this.btnAddQuestion.Text="添加公告";
						this.lblTitle.Text="添加公告";
					}
					else if(type=="modify")
					{
						this.btnAddQuestion.Text="修改公告";
						this.lblTitle.Text="修改公告";
						//得到内容
						string id=Request.QueryString["id"].ToString();
						string sql="select * from [affiche] where [id]="+id;
						DataTable dt=cd.getDataTable(sql);
						if(dt.Rows.Count>0)
						{
							this.txtSubject.Text=dt.Rows[0]["subject"].ToString().Trim();
							this.FreeTextBox1.Text=dt.Rows[0]["content"].ToString();
						}
					}
				}
				catch(Exception)
				{
					Response.Redirect("err.aspx?err=出现错误,请与管理员联系");
				}
			}
		}

		#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)
		{
			try
			{
				//现在添加或修改公告

				string masterName=Session["userName"].ToString();
				string boardID="0";
				if(Session["userType"]!=null && Session["userType"].ToString().IndexOf("master")>-1)
				{
					boardID=Session["userType"].ToString().Substring(6);
				}
				string subject="";
				string content="";
				string insertSql="";
				string updateSql="";

				if(Session["userType"].ToString()=="admin")//超级管理员管理公告
				{
					boardID="0";
					subject=this.txtSubject.Text.Trim().Replace("'","");
					content=this.FreeTextBox1.Text.Replace("'","‘");
					insertSql="insert into [affiche](subject,content,adder,boardID) values('"+subject+"','"+content+"','超级管理员',"+boardID+")";

					
					if(Request.QueryString["type"].ToString()=="modify")
					{
						updateSql="update [affiche] set subject='"+subject+"',content='"+content+"' where [id]="+Request.QueryString["id"].ToString();
					}

					if(this.btnAddQuestion.Text=="添加公告")
					{
						//添加公告
						cd.updateDatabase(insertSql);
					}
					else
					{
						cd.updateDatabase(updateSql);
					}
					Response.Redirect("admin_manageAffiche.aspx?page=1");
				}
				else if(masterName!="" && Session["userType"].ToString().IndexOf("master")>-1)
				{
					DataTable dt=cd.getDataTable("select * from [affiche] where adder='"+masterName+"'");
					//控制数量，如果达到限定数不允许添加
					if(dt.Rows.Count<Convert.ToInt32(cd.getSystemPara("afficheCount")))
					{
						subject=this.txtSubject.Text.Trim().Replace("'","");
						content=this.FreeTextBox1.Text.Replace("'","‘");
						insertSql="insert into [affiche](subject,content,adder,boardID) values('"+subject+"','"+content+"','";
						insertSql+=masterName+"',"+boardID+")";

						if(Request.QueryString["type"].ToString()=="modify")
						{
							updateSql="update [affiche] set subject='"+subject+"',content='"+content+"' where [id]="+Request.QueryString["id"].ToString();
						}

						if(this.btnAddQuestion.Text=="添加公告")
						{
							//添加公告
							cd.updateDatabase(insertSql);
						}
						else
						{
							cd.updateDatabase(updateSql);
						}
						Response.Redirect("manageAffiche.aspx?page=1");
					}
				}
			}
			catch(Exception ee)
			{
				//Response.Redirect("err.aspx?err=出现错误,你可能非法操作");
				Response.Write(ee.ToString());
			}
		}
	}
}