contentmanage.aspx.cs

计算机学院网站及管理系统

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.IO;
using System.Configuration;

namespace ComputerWeb
{
	/// <summary>
	/// Summary description for MangageContent.
	/// </summary>
	public class ManageContent : System.Web.UI.Page
	{		
		protected System.Web.UI.WebControls.DropDownList TabList;
		protected System.Web.UI.WebControls.DropDownList ModuleList;
		protected System.Web.UI.WebControls.DropDownList ColumnList;
		protected System.Web.UI.WebControls.Button AddContent;
		protected System.Web.UI.WebControls.Button UpdateContent;
		protected System.Web.UI.WebControls.Button DeleteContent;
		protected System.Web.UI.WebControls.ListBox ContentList;
		
		public static int[] allId = new int[3];

		private void Page_Load(object sender, System.EventArgs e)
		{	
			if(!Page.IsPostBack)
			{
				BindTabData();
                 
				if(TabList.SelectedIndex > -1)
				{
					BindModuleData(Int32.Parse(TabList.SelectedValue));		
					if(ModuleList.SelectedIndex > -1)
					{
						BindColumnData(Int32.Parse(ModuleList.SelectedValue));
						if(ColumnList.SelectedIndex > -1)
						{
							BindContentByColumn(Int32.Parse(ColumnList.SelectedValue));
						}
						else
						{
							BindContentByModule(Int32.Parse(ModuleList.SelectedValue));
						}
					}
					else
					{
						BindContentByTab(Int32.Parse(TabList.SelectedValue));
					}
				}
			}			
		}

		private void BindTabData()
		{
			TabList.Items.Clear();

			TabDB tab = new TabDB();
			SqlDataReader rect = tab.GetTabs();

			TabList.DataSource = rect;
			TabList.DataTextField = "TabName";
			TabList.DataValueField = "TabID";
			TabList.DataBind();

			rect.Close();
		}

		private void BindModuleData(int nTabID)
		{
			ModuleList.Items.Clear();

			ModuleDB module = new ModuleDB();
			SqlDataReader recm = module.GetModules(nTabID);

			ModuleList.DataSource = recm;
			ModuleList.DataTextField = "ModuleName";
			ModuleList.DataValueField = "ModuleID";
			ModuleList.DataBind();

			recm.Close();
		}

		private void BindColumnData(int nModuleID)
		{
			ColumnList.Items.Clear();

			ColumnDB column = new ColumnDB();
			SqlDataReader recc = column.GetColumns(nModuleID);

			ColumnList.DataSource = recc;
			ColumnList.DataTextField = "ColumnName";
			ColumnList.DataValueField = "ColumnID";
			ColumnList.DataBind();

			recc.Close();
		}

		private void BindContentByColumn(int nColumnID)
		{
			ContentList.Items.Clear();

			ContentDB content = new ContentDB();
			SqlDataReader recc = content.GetContentByColumn(nColumnID);

			ContentList.DataSource = recc;
			ContentList.DataTextField = "Title";
			ContentList.DataValueField = "ContentID";
			ContentList.DataBind();

			recc.Close();
		}

		private void BindContentByModule(int nModuleID)
		{
			ContentList.Items.Clear();

			ContentDB content = new ContentDB();
			SqlDataReader recc = content.GetContentByModule(nModuleID);

			ContentList.DataSource = recc;
			ContentList.DataTextField = "Title";
			ContentList.DataValueField = "ContentID";
			ContentList.DataBind();

			recc.Close();
		}

		private void BindContentByTab(int nTabID)
		{
			ContentList.Items.Clear();

			ContentDB content = new ContentDB();
			SqlDataReader recc = content.GetContentByTab(nTabID);

			ContentList.DataSource = recc;
			ContentList.DataTextField = "Title";
			ContentList.DataValueField = "ContentID";
			ContentList.DataBind();

			recc.Close();
		}

		private int[] GetAllID(String sArea)
		{
			int[] allID = new int[3];
			switch(sArea)
			{
				case "Channel":
				{
					allID[0] = Int32.Parse(TabList.SelectedValue);
					allID[1] = allID[2] = 0;
					break;
				}
				case "Topic":
				{
					allID[1] = Int32.Parse(ModuleList.SelectedValue);
					allID[0] = allID[2] = 0;
					break;
				}
				case "SubTopic":
				{
					allID[2] = Int32.Parse(ColumnList.SelectedValue);
					allID[0] = allID[1] = 0;
					break;
				}
				default:
				{
					allID[0] = allID[1] = allID[2] = 0;
					break;
				}
			}
			return(allID);
		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{    
			this.TabList.SelectedIndexChanged += new System.EventHandler(this.TabList_SelectedIndexChanged);
			this.ModuleList.SelectedIndexChanged += new System.EventHandler(this.ModuleList_SelectedIndexChanged);
			this.ColumnList.SelectedIndexChanged += new System.EventHandler(this.ColumnList_SelectedIndexChanged);
			this.AddContent.Click += new System.EventHandler(this.AddContent_Click);
			this.UpdateContent.Click += new System.EventHandler(this.UpdateContent_Click);
			this.DeleteContent.Click += new System.EventHandler(this.DeleteContent_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void TabList_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			if(TabList.SelectedIndex > -1)
			{
				BindModuleData(Int32.Parse(TabList.SelectedValue));		
				if(ModuleList.SelectedIndex > -1)
				{
					BindColumnData(Int32.Parse(ModuleList.SelectedValue));
					if(ColumnList.SelectedIndex > -1)
					{
						BindContentByColumn(Int32.Parse(ColumnList.SelectedValue));
					}
					else
					{
						BindContentByModule(Int32.Parse(ModuleList.SelectedValue));
					}
				}
				else
				{
					BindContentByTab(Int32.Parse(TabList.SelectedValue));
				}
			}		
		}

		private void ModuleList_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			if(ModuleList.SelectedIndex > -1)
			{
				BindColumnData(Int32.Parse(ModuleList.SelectedValue));
				if(ColumnList.SelectedIndex > -1)
				{
					BindContentByColumn(Int32.Parse(ColumnList.SelectedValue));
				}
				else
				{
					BindContentByModule(Int32.Parse(ModuleList.SelectedValue));
				}
			}
		}

		private void ColumnList_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			if(ColumnList.SelectedIndex > -1)
			{
				BindContentByColumn(Int32.Parse(ColumnList.SelectedValue));
			}
			else
			{
				BindContentByModule(Int32.Parse(ModuleList.SelectedValue));
			}
		}

		private void AddContent_Click(object sender, System.EventArgs e)
		{
			Response.Redirect("~/Admin/AddOrEditContent.aspx");
		}

		private void UpdateContent_Click(object sender, System.EventArgs e)
		{
			if(ContentList.SelectedIndex > -1)
			{
				Response.Redirect("~/Admin/AddOrEditContent.aspx?ContentID=" + ContentList.SelectedValue
					+ "Operation=" + UpdateContent.CommandName);
			}
			else
			{
				Response.Write("<script>alert(\"请选择你的数据项！\")</script>");
			}
		}

		private void DeleteContent_Click(object sender, System.EventArgs e)
		{
			if(ContentList.SelectedIndex > -1)
			{
				Response.Redirect("~/Admin/AddOrEditContent.aspx?ContentID=" + ContentList.SelectedValue 
					+ "Operation=" + DeleteContent.CommandName);
			}
			else
			{
				Response.Write("<script>alert(\"请选择你的数据项！\")</script>");
			}
		}

	}
}