adminclass.aspx.cs

来自「中国海洋大学211工程网站的全部源码」· CS 代码 · 共 206 行

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;
//5	1	a	s	p	x.com

namespace _211
{
	/// <summary>
	/// AdminClass 的摘要说明。
	/// </summary>
	public partial class AdminClass : System.Web.UI.Page
	{
	
		protected void Page_Load(object sender, System.EventArgs e)
		{
			if(Session["name"]==null)
			{
				Response.Write("<script>top.location='AdminLogin.aspx'</script>");
				return;
			}

			if(!Page.IsPostBack)
			{
				BindAll();
				Button1.Attributes["onclick"]="return confirm('确定要删除么？')";
			}
		}

		private void ReadClass()
		{
			c.DataSource=TableQuery.ClassQuery();
			c.DataTextField="ClassName";
			c.DataValueField="ClassId";
			c.DataBind();
		}

		private void ReadItem()
		{
			if(c.SelectedItem==null)return;

			i.DataSource=TableQuery.ItemQuery(c.SelectedValue);
			i.DataTextField="ItemName";
			i.DataValueField="ItemId";
			i.DataBind();
		}

		private void ClassList2Text()
		{
			if(c.SelectedItem!=null)
			{
				c_modify.Text=c.SelectedItem.Text;
			}
		}

		private void ItemList2Text()
		{
			if(i.SelectedItem!=null)
			{
				i_modify.Text=i.SelectedItem.Text;
			}
		}

		private void BindClass()
		{
			ReadClass();
			ClassList2Text();
		}

		private void BindItem()
		{
			ReadItem();
			ItemList2Text();
		}

		private void BindAll()
		{
			BindClass();
			BindItem();
		}

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

		}
		#endregion


		protected void Button1_Click(object sender, System.EventArgs e)
		{
			if(i.SelectedItem!=null)
			{
				try
				{
					DBQuery.ExceuteNonQuery("delete from [Item] where ItemId="+i.SelectedValue);
					Response.Write("<script>alert('删除成功');</script>");
				}
				catch(Exception ex)
				{
					Response.Write("<script>alert('"+ex.Message.ToString()+"');</script>");
				}

				BindItem();
			}
		}

		protected void Button4_Click(object sender, System.EventArgs e)
		{
			if(i_add.Text==""||c.SelectedItem==null)return;

			using(Item it=new Item(i_add.Text,false))
			{
				try
				{
					it.setClassId(Convert.ToUInt32(c.SelectedValue));
					it.Add();
					
					i_add.Text="";
					Response.Write("<script>alert('添加成功');</script>");
				}
				catch(Exception ex)
				{
					Response.Write("<script>alert('"+ex.Message.ToString()+"');</script>");
				}
			}

			BindItem();
		}

		protected void Button5_Click(object sender, System.EventArgs e)
		{
			if(c_modify.Text=="")return;

			using(Class cl=new Class(Convert.ToUInt32(c.SelectedValue)))
			{
				cl.setClassName(c_modify.Text);
				try
				{
					cl.Update();
					
					Response.Write("<script>alert('修改成功');</script>");
				}
				catch(Exception ex)
				{
					Response.Write("<script>alert('"+ex.Message.ToString()+"');</script>");
				}
			}

			BindAll();
		}

		protected void Button6_Click(object sender, System.EventArgs e)
		{
			if(i_modify.Text=="")return;

			using(Item it=new Item(Convert.ToUInt32(i.SelectedValue)))
			{
				it.setItemName(i_modify.Text);
				try
				{
					it.Update();
					
					Response.Write("<script>alert('修改成功');</script>");
				}
				catch(Exception ex)
				{
					Response.Write("<script>alert('"+ex.Message.ToString()+"');</script>");
				}
			}

			BindItem();
		}

		protected void c_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			ClassList2Text();
			BindItem();
		}

		protected void i_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			ItemList2Text();
		}
	}
}