//獲取準(zhǔn)備刪除的投票ID
			HtmlInputHidden hih = (HtmlInputHidden)(e.Item.Cells[0].FindControl("vote_id"));
			if (hih == null)
				return;

			//執(zhí)行存儲過程，刪除投票
			int vote_id = Convert.ToInt32(hih.Value);
			string strConn = ConfigurationSettings.AppSettings["ConnectionString"];
			SqlConnection conn = new SqlConnection(strConn);
			SqlCommand cmd = conn.CreateCommand();
			cmd.CommandText = "DeleteVote";
			cmd.CommandType = CommandType.StoredProcedure;
			cmd.Parameters.Add("@id", vote_id);

			try
			{
				conn.Open();
				cmd.ExecuteNonQuery();
			}
			catch (SqlException ex)
			{
				Response.Write(ex.Message + vote_id.ToString());
			}
			finally
			{
				conn.Close();
			}
			
			dgVotes.CurrentPageIndex = 0;
			BindGrid();		
		}

		private void dgVotes_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			if (e.CommandName == "EditOption") //單擊“修改選項(xiàng)”按鈕
			{
				//若單擊另一條投票信息，則切換到單擊的這條投票信息
				//若單擊當(dāng)前選中的投票信息，則退出編輯選項(xiàng)的狀態(tài)
				if (dgVotes.SelectedIndex != e.Item.ItemIndex)
					dgVotes.SelectedIndex = e.Item.ItemIndex;
				else
					dgVotes.SelectedIndex = -1;
				BindGrid();

				if (dgVotes.SelectedIndex != -1)
				{
					//求得當(dāng)前選中的投票ID，注意區(qū)分顯示和編輯兩種狀態(tài) 
					HtmlInputHidden hih = null;
					if (dgVotes.EditItemIndex != e.Item.ItemIndex)
					{
						hih = (HtmlInputHidden)(e.Item.Cells[0].FindControl("vote_id"));
					}
					else
					{
						hih = (HtmlInputHidden)(e.Item.Cells[0].FindControl("vote_id_Edit"));
					}
					int vote_id = Convert.ToInt32(hih.Value);
					SelectedVoteID = vote_id;

					//顯示修改選項(xiàng)的panel
					panelOption.Visible = true;
					//隱藏增加選項(xiàng)的panel
					panelAddVote.Visible = false;
					//顯示選中投票項(xiàng)目的選項(xiàng)列表
					BindOptionGrid();
				}
				else
				{
					//更新SelectedVoteID
					SelectedVoteID = -1;
					//隱藏修改選項(xiàng)的panel
					panelOption.Visible = false;
				}
			}
		}


		#endregion

		#region dgOptions

		private void dgOptions_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			//單擊刪除選項(xiàng)按鈕時(shí)彈出確認(rèn)提示
			if (e.Item.ItemType	== ListItemType.Item ||
				e.Item.ItemType	== ListItemType.AlternatingItem ||
				e.Item.ItemType == ListItemType.EditItem ||
				e.Item.ItemType == ListItemType.SelectedItem)
			{
				LinkButton lb = (LinkButton)(e.Item.Cells[2].Controls[0]);
				lb.Attributes.Add("onclick", "return confirm('您確定要?jiǎng)h除該選項(xiàng)嗎？');");;
			}
		}

		private void dgOptions_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			//求得將要?jiǎng)h除的選項(xiàng)ID
			int index = e.Item.ItemIndex;
			DataGridItem item = dgOptions.Items[index];
			HtmlInputHidden hih = null;
			if (dgOptions.EditItemIndex != e.Item.ItemIndex)
			{
				hih = (HtmlInputHidden)item.Cells[0].FindControl("option_id");
			}
			else
			{
				hih = (HtmlInputHidden)item.Cells[0].FindControl("option_id_Edit");
			}
			int option_id = Convert.ToInt32(hih.Value);

			//刪除選項(xiàng)，刷新選項(xiàng)列表
			string strConn = ConfigurationSettings.AppSettings["ConnectionString"];
			SqlConnection conn = new SqlConnection(strConn);
			SqlCommand cmd = conn.CreateCommand();
			cmd.CommandText = "DeleteOption";
			cmd.CommandType = CommandType.StoredProcedure;
			cmd.Parameters.Add("@id", option_id);

			try
			{
				conn.Open();
				cmd.ExecuteNonQuery();
				BindOptionGrid();
			}
			catch (SqlException ex)
			{
				Response.Write(ex.Message);
			}
			finally
			{
				conn.Close();
			}
		}

		private void dgOptions_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			//編輯條目在DataGrid中的序號
			int index = e.Item.ItemIndex;

			//求編輯的選項(xiàng)ID
			HtmlInputHidden hih = (HtmlInputHidden)dgOptions.Items[index].Cells[0].FindControl("option_id");
			EditOptionID = Convert.ToInt32(hih.Value);

			//進(jìn)入編輯狀態(tài)
			dgOptions.EditItemIndex = index;
			BindOptionGrid();			
		}

		private void dgOptions_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			//退出編輯狀態(tài)
			dgOptions.EditItemIndex = -1;
			BindOptionGrid();
		}

		private void dgOptions_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			//更新選項(xiàng)內(nèi)容，刷新選項(xiàng)列表
			TextBox tb = (TextBox)e.Item.Cells[0].FindControl("tbContentEdit");			

			string strConn = ConfigurationSettings.AppSettings["ConnectionString"];
			SqlConnection conn = new SqlConnection(strConn);
			SqlCommand cmd = conn.CreateCommand();
			cmd.CommandText = "UpdateOption";
			cmd.CommandType = CommandType.StoredProcedure;
			cmd.Parameters.Add("@id", EditOptionID);
			cmd.Parameters.Add("@content", tb.Text);

			try
			{
				conn.Open();
				cmd.ExecuteNonQuery();

				dgOptions.EditItemIndex = -1;
				BindOptionGrid();
			}
			catch (SqlException ex)
			{
				Response.Write(ex.Message);
			}
			finally
			{
				conn.Close();
			}
		}


		#endregion

		#region button clicks

		protected void lbAddVote_Click(object sender, System.EventArgs e)
		{
			//顯示添加新投票panel
			panelAddVote.Visible = true;
			//隱藏編輯選項(xiàng)panel
			panelOption.Visible = false;
			//取消當(dāng)前的選擇狀態(tài)
			dgVotes.SelectedIndex = -1;
			BindGrid();
		}

		protected void lbAdd_Click(object sender, System.EventArgs e)
		{
			//添加新投票項(xiàng)目
			string strConn = ConfigurationSettings.AppSettings["ConnectionString"];
			SqlConnection conn = new SqlConnection(strConn);
			SqlCommand cmd = conn.CreateCommand();
			cmd.CommandText = "AddVote";
			cmd.CommandType = CommandType.StoredProcedure;
			cmd.Parameters.Add("@question", tbQuestionAdd.Text);
			cmd.Parameters.Add("@start_date", tbStartdateAdd.Text);
			cmd.Parameters.Add("@end_date", tbEnddateAdd.Text);
			cmd.Parameters.Add("@type", cbMultiAdd.Checked);
			cmd.Parameters.Add("@active", cbActiveAdd.Checked);

			try
			{
				conn.Open();
				cmd.ExecuteNonQuery();
				BindGrid();
				panelAddVote.Visible = false;
			}
			catch (SqlException ex)
			{
				Response.Write(ex.Message);
			}
			finally
			{
				conn.Close();
			}
		}

		protected void lbCancel_Click(object sender, System.EventArgs e)
		{
			//隱藏添加新投票的panel
			panelAddVote.Visible = false;
		}

		protected void lbAddOption_Click(object sender, System.EventArgs e)
		{
			//執(zhí)行存儲過程，添加投票的選項(xiàng)，并刷新數(shù)據(jù)顯示
			string strConn = ConfigurationSettings.AppSettings["ConnectionString"];
			SqlConnection conn = new SqlConnection(strConn);
			SqlCommand cmd = conn.CreateCommand();
			cmd.CommandText = "AddOption";
			cmd.CommandType = CommandType.StoredProcedure;
			cmd.Parameters.Add("@vote_id", SelectedVoteID);
			cmd.Parameters.Add("@content", tbNewOption.Text);

			try
			{
				conn.Open();
				cmd.ExecuteNonQuery();
				BindOptionGrid();
			}
			catch (SqlException ex)
			{
				Response.Write(ex.Message);
			}
			finally
			{
				conn.Close();
			}
		}

		protected void lbReturn_Click(object sender, System.EventArgs e)
		{
			//跳轉(zhuǎn)到投票顯示頁
			Response.Redirect("~/ShowVote.aspx");
		}


		#endregion

	}
}