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;

namespace examonline
{
	/// <summary>
	/// selectexam 的摘要說明。
	/// </summary>
	public partial class selectexam : System.Web.UI.Page
	{
		protected System.Web.UI.HtmlControls.HtmlForm Form2;
		protected System.Web.UI.HtmlControls.HtmlForm Form3;
	
		protected void Page_Load(object sender, System.EventArgs e)
		{
			if((bool)Session["IsLogined"]==false)
			{
				Response.Redirect("index.aspx");
			}
		}

		#region Web 窗體設計器生成的代碼
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 該調用是 ASP.NET Web 窗體設計器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 設計器支持所需的方法 - 不要使用代碼編輯器修改
		/// 此方法的內容。
		/// </summary>
		private void InitializeComponent()
		{    

		}
		#endregion

		protected void btnSelect_Click(object sender, System.EventArgs e)
		{
			string sql="";
			switch(ddlTarge.SelectedValue)
			{
				case "1":
					sql= "Select * from selectItems where title like '%"+ txtKey.Text +"%' or question like '%"+txtKey.Text+"%'";
					break;
				case "2":
					sql= "Select * from fillblank where title like '%"+ txtKey.Text +"%' or question like '%"+txtKey.Text+"%'";
					break;
				case "3":
					sql= "Select * from essay where title like '%"+ txtKey.Text +"%' or question like '%"+txtKey.Text+"%'";
					break;
				default:
					Session["info"]="出錯了！";
					break;
			}
			SqlConnection cn =new SqlConnection("server=(local);uid=sa;pwd=51aspx;database=examonline");
			SqlDataAdapter da =new SqlDataAdapter(sql, cn);
			DataSet ds=new DataSet();
			try
			{
				cn.Open();
				da.Fill(ds, "selectItems");
			}
			finally
			{
				cn.Close();
			}
			ds.Tables["selectItems"].Columns.Add("examName",GetType());
			DataTable table=ds.Tables["selectItems"];
			foreach(DataRow row in table.Rows)
			{
				sql = "Select exam_title from exam where exam_id="+ row["exam_id"];
				SqlCommand cmd = new SqlCommand(sql,cn);
				SqlDataReader dr;
				cn.Open();
				dr=cmd.ExecuteReader();
				while(dr.Read())
				{
					row["examName"]=dr.GetString(0);
				}
				row["title"]=row["title"].ToString().Replace(txtKey.Text,"<font style='BACKGROUND-COLOR: #87cefa'>"+txtKey.Text+"</font>");
				row["question"]=row["question"].ToString().Replace(txtKey.Text,"<font style='BACKGROUND-COLOR: #87cefa'>"+txtKey.Text+"</font>");
				cn.Close();
			}
			dgResult.DataSource = ds.Tables["selectItems"];
			dgResult.DataBind();
		}
	}
}