itemmanage.aspx.cs

投票系统 环境：vs2005 语言：c#

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class ItemManage : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
		if(!Page.IsPostBack)
		{   ///显示主题的数据
			BindTopicData();
			if(TopicList.Items.Count > 0)
			{
				TopicList.SelectedIndex = 0;
				///显示项目的数据
				BindSubjectData(Int32.Parse(TopicList.SelectedValue));
				if(SubjectList.Items.Count > 0)
				{   ///显示选择项数据
					SubjectList.SelectedIndex = 0;
					BindItemData(Int32.Parse(SubjectList.SelectedValue));
				}
			}
		}		
	}

	private void BindTopicData()
	{   ///获取数据
		ITopic topic = new Topic();
		SqlDataReader dr = topic.GetTopics();
		///绑定数据
		TopicList.DataSource = dr;
		///设置Text属性和Value属性的值
		TopicList.DataTextField = "Name";
		TopicList.DataValueField = "TopicID";
		TopicList.DataBind();
		///关闭数据源
		dr.Close();

		AddBtn.Enabled = TopicList.Items.Count > 0 ? true : false;
	}
	private void BindSubjectData(int nTopicID)
	{   ///获取数据
		ISubject subject = new Subject();
		SqlDataReader dr = subject.GetSubjectByTopic(nTopicID);
		///绑定数据
		SubjectList.DataSource = dr;
		///设置Text属性和Value属性的值
		SubjectList.DataTextField = "Name";
		SubjectList.DataValueField = "SubjectID";
		SubjectList.DataBind();
		///关闭数据源
		dr.Close();

		AddBtn.Enabled = SubjectList.Items.Count > 0 ? true : false;
	}
	private void BindItemData(int nSubjectID)
	{   ///获取数据
		IItem item = new Item();
		SqlDataReader dr = item.GetItemBySubject(nSubjectID);
		///绑定数据
		ItemView.DataSource = dr;
		ItemView.DataBind();
		///关闭数据源
		dr.Close();
	}

	protected void SubjectList_SelectedIndexChanged(object sender,EventArgs e)
	{   ///显示选择项数据
		BindItemData(Int32.Parse(SubjectList.SelectedValue));		
	}
	protected void TopicList_SelectedIndexChanged(object sender,EventArgs e)
	{	///显示项目的数据
		BindSubjectData(Int32.Parse(TopicList.SelectedValue));
		if(SubjectList.Items.Count > 0)
		{   ///显示选择项数据
			SubjectList.SelectedIndex = 0;
			BindItemData(Int32.Parse(SubjectList.SelectedValue));
		}
		else
		{
			SubjectList.Items.Clear();
			///绑定空数据源
			ItemView.DataSource = null;
			ItemView.DataBind();
		}		
	}
	protected void AddBtn_Click(object sender,EventArgs e)
	{   ///跳转到添加页面
		Response.Redirect("~/AddItem.aspx?SubjectID=" + SubjectList.SelectedValue);
	}
	protected void ItemView_RowCommand(object sender,GridViewCommandEventArgs e)
	{
		if(e.CommandName == "delete")
		{
			try
			{   ///删除数据
				IItem item = new Item();
				item.DeleteItem(Int32.Parse(e.CommandArgument.ToString()));

				///重新绑定控件的数据
				BindItemData(Int32.Parse(SubjectList.SelectedValue));
				Response.Write("<script>alert('" + "删除数据成功，请妥善保管好你的数据！" + "');</script>");
			}
			catch(Exception ex)
			{   ///跳转到异常错误处理页面
				Response.Redirect("ErrorPage.aspx?ErrorMsg=" + ex.Message.Replace("<br>","").Replace("\n","")
					+ "&ErrorUrl=" + Request.Url.ToString().Replace("<br>","").Replace("\n",""));
			}
		}
	}
	protected void ItemView_RowDeleting(object sender,GridViewDeleteEventArgs e)
	{
		///
	}
	protected void ItemView_RowDataBound(object sender,GridViewRowEventArgs e)
	{
		ImageButton deleteBtn = (ImageButton)e.Row.FindControl("DeleteBtn");
		if(deleteBtn != null)
		{
			deleteBtn.Attributes.Add("onclick","return confirm('你确定要删除所选择的数据项吗？');");
		}
	}
}