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 class_selcet
{
	/// <summary>
	/// index 的摘要說明。
	/// </summary>
	public class student : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.TextBox c_no;
		protected System.Web.UI.WebControls.TextBox c_pas;
		protected System.Web.UI.WebControls.Button c_ent;
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.Button cgpas;
        	protected System.Web.UI.WebControls.DataGrid bixiu;
		protected System.Web.UI.WebControls.DataGrid xuanxiu;
		protected System.Web.UI.WebControls.DataGrid kua;
		public string getpas;
		protected System.Web.UI.WebControls.Button bx;
		protected System.Web.UI.WebControls.Button xx;
		protected System.Web.UI.WebControls.Button k;
		protected System.Web.UI.WebControls.HyperLink  checls;
		static public string getsno;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			Session.Timeout=60;
		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN：該調用是 ASP.NET Web 窗體設計器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 設計器支持所需的方法 - 不要使用代碼編輯器修改
		/// 此方法的內容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.c_ent.Click += new System.EventHandler(this.c_ent_Click);
			this.cgpas.Click += new System.EventHandler(this.cgpas_Click);
			this.bx.Click += new System.EventHandler(this.bx_Click);
			this.xx.Click += new System.EventHandler(this.xx_Click);
			this.k.Click += new System.EventHandler(this.k_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void c_ent_Click(object sender, System.EventArgs e)
		{  	DataSet ds;
			SqlDataAdapter Cmd;
			if (c_no.Text==""||c_pas.Text=="")
			 {
					 Label1.Text="請輸入完整資料！";
				 return;
			 }
				 //SqlConnection Con = new SqlConnection("Data Source='DZG\VSdotNET';Initial Catalog=class;User ID=sa;Pwd=;");  
				 //SqlConnection Con = new SqlConnection("data source=DZG\VSdotNET;initial catalog=class;persist security info=False;user id=sa;workstation id=DZG;packet size=4096");  
				 SqlConnection Con = new SqlConnection("server=localhost;database=class;User ID=sa;PWD=;connect timeout=120");  
				 //SqlConnection Con = new SqlConnection("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=class;Data Source=DZG\VSdotNET");  
				 
           string  sel="select * from stu where sno=" + c_no.Text ; 
			SqlCommand addCommand =new SqlCommand(sel,Con);
			addCommand.Connection.Open();
			SqlDataReader selreader ;
			selreader=addCommand.ExecuteReader();
			if (selreader.Read() == false) 
			{
				Label1.Text="該學號不存在！";
					return;
			}
			else 
			{   getpas=selreader.GetString(5);
				addCommand.Connection.Close();
					if (getpas.CompareTo(c_pas.Text.PadRight(20))==0)
					{
						Session["c_no"]="hasin";
						Label1.Text="登錄成功,開始選課!";		
						checls.Visible=true;
					        c_ent.Visible=false;
						getsno=c_no.Text ;
						checls.NavigateUrl ="seecls.aspx?sno="+getsno;
						Session["s_no"]=getsno;
                                                cgpas.Visible=true ;
						sel="select * from csee where ckind='必修' and cdept=(select sdept from stu where sno="+getsno+")";
						Cmd=new SqlDataAdapter(sel,Con);
						ds=new DataSet();
						Cmd.Fill(ds,"csee");
						bixiu.DataSource=ds.Tables["csee"].DefaultView;
						bixiu.DataBind();
						sel="select * from csee where ckind='系選修' and cdept=(select sdept from stu where sno="+getsno+")";
						Cmd=new SqlDataAdapter(sel,Con);
						ds=new DataSet();
						Cmd.Fill(ds,"xxsee");
						xuanxiu.DataSource=ds.Tables["xxsee"].DefaultView;
					xuanxiu.DataBind();
						sel="select * from csee where  cdept<>(select sdept from stu where sno="+getsno+")";
						Cmd=new SqlDataAdapter(sel,Con);
						ds=new DataSet();
						Cmd.Fill(ds,"ksee");
						kua.DataSource=ds.Tables["ksee"].DefaultView;
						kua.DataBind();
					}
				
					else
					
			     			Label1.Text="密碼錯誤！";
				
			
			}
				
	
		}

		private void cgpas_Click(object sender, System.EventArgs e)
		{
			if (c_pas.Text=="")
			{
				Label1.Text="你必須輸入一個密碼！";
				return;
			}
			else
			{
			SqlConnection Con = new SqlConnection("server=localhost;database=class;User ID=sa;PWD=;connect timeout=120");  
			string sel="update stu set spas=" + c_pas.Text + "where sno="+getsno;
			SqlCommand delCommand =new SqlCommand(sel,Con);
			delCommand.Connection.Open();
			delCommand.ExecuteNonQuery();
			delCommand.Connection.Close();
			Label1.Text="密碼修改成功!";
			}
		
		}

		private void bx_Click(object sender, System.EventArgs e)
		{disobj(bixiu,bx);
			
		}
		public void disobj(DataGrid datacla,Button disp)
		{
				if (disp.Text=="隱藏該欄")
		 {
			 disp.Text="顯示該欄";
			 datacla.Visible=false;
		 }
		 else
		 {
				 disp.Text="隱藏該欄";
			 datacla.Visible=true;

		 }

		}

		private void xx_Click(object sender, System.EventArgs e)
		{disobj(xuanxiu,xx);
		
		}
		
		private void k_Click(object sender, System.EventArgs e)
		{
			disobj(kua,k);
		}
	}
}