manageboard.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>
	/// manageBoard 的摘要说明。
	/// </summary>
	public class manageBoard : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.TextBox txtBoardName;
		protected System.Web.UI.WebControls.DropDownList listBoard;
		protected System.Web.UI.WebControls.Button btnAddBoard;
		protected System.Web.UI.WebControls.Panel panAddBoard;
		protected System.Web.UI.WebControls.Panel panModifyBoard;
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.TextBox txtRename;
		protected System.Web.UI.WebControls.DropDownList listRenameChild;
		protected System.Web.UI.WebControls.Button btnDeleteBoard;
		protected System.Web.UI.WebControls.Label lblMsg;
		protected System.Web.UI.WebControls.Label lblAddMsg;
	
		dayi.controlDatabase cd=new controlDatabase();

		private void getMainBoard(string boardID)
		{
			try
			{
				//得到栏目名
				DataTable dt=cd.getDataTable("select * from [board] where boardID="+boardID);
				if(dt.Rows.Count>0)
				{
					string boardName=dt.Rows[0]["boardName"].ToString().Trim();
					string boardPath="0,"+boardID;
					string listvalue=boardID+"#"+boardID+"#"+boardPath;
					//在列表中增加主栏目
					this.listBoard.Items.Add(new ListItem(boardName,listvalue));
				}
			}
			catch(Exception ee)
			{
				Response.Redirect("err.aspx?err="+ee.Message);
			}
		}

		private void bindToList()
		{

			try
			{
				//清空
				this.listBoard.Items.Clear();
				this.listRenameChild.Items.Clear();

				int boardID=Convert.ToInt32(Session["userType"].ToString().Substring(6));

				this.getMainBoard(boardID.ToString());


				//填充所有列表
				cd.bindToDropDownList(boardID,this.listBoard);
						
				cd.bindToDropDownList(boardID,this.listRenameChild);

				if(this.listRenameChild.Items.Count<1)
				{
					this.btnDeleteBoard.Enabled=false;
					this.Button1.Enabled=false;//"修改"按钮
				}
				else
				{
					this.btnDeleteBoard.Enabled=true;
					this.Button1.Enabled=true;//"修改"按钮
				}
			}
			catch(Exception ee)
			{
				Response.Redirect("err.aspx?err="+ee.Message);
			}
		}
		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 userType=Session["userType"].ToString();
					if(Session["userName"].ToString()!="" && userType.IndexOf("master")>-1)
					{
						string boardID=userType.Substring(6);
						
						//控制显示
						this.panAddBoard.Visible=false;
						this.panModifyBoard.Visible=false;

						if(Request.QueryString["type"].ToString()=="add")
							this.panAddBoard.Visible=true;
						else if(Request.QueryString["type"].ToString()=="modify")
							this.panModifyBoard.Visible=true;

						this.getMainBoard(boardID);
						//填充列表
						this.bindToList();
						
					}
				}
				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.btnAddBoard.Click += new System.EventHandler(this.btnAddBoard_Click);
			this.Button1.Click += new System.EventHandler(this.Button1_Click);
			this.btnDeleteBoard.Click += new System.EventHandler(this.btnDeleteBoard_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void btnAddBoard_Click(object sender, System.EventArgs e)
		{
			try
			{
				//添加栏目
				string idpath=this.listBoard.SelectedValue.Trim();
				string boardname=this.txtBoardName.Text.Trim();
				string boardmaster=Session["userName"].ToString();

				if(boardname!="")
				{
					cd.addBoard(boardname,boardmaster,idpath);
					this.txtBoardName.Text="";
					this.bindToList();
				}
				else
				{
					this.lblAddMsg.Text="<b>请输入栏目名</b>";
				}
			}
			catch(Exception ee)
			{
				Response.Redirect("err.aspx?err="+ee.Message);
			}
		}

		private void Button1_Click(object sender, System.EventArgs e)
		{
			//修改栏目名
			string boardName=this.txtRename.Text.Trim().Replace("'","");
			if(boardName!="")
			{
				string boardID=this.listRenameChild.SelectedValue.Split(new char[]{'#'})[0].ToString();
				string sql="update [board] set [boardName]='"+boardName+"' where [boardID]="+boardID;

				try
				{
					cd.updateDatabase(sql);
				
					this.bindToList();
				}
				catch(Exception ee)
				{
					Response.Redirect("err.aspx?err="+ee.Message);
				}
			}
			else
			{
				this.lblMsg.Text="<b>请输入栏目名</b>";
			}
		}


		private void btnDeleteBoard_Click(object sender, System.EventArgs e)
		{
			//删除栏目
			try
			{
				int boardID=Convert.ToInt32(this.listRenameChild.SelectedValue.Split(new char[]{'#'})[0].ToString());
				cd.deleteBoard(boardID);
				this.bindToList();
			}
			catch(Exception ee)
			{
				Response.Redirect("err.aspx?err="+ee.Message);
			}
		}
	}
}