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;
using System.Configuration;
namespace class_selcet
{
	/// <summary>
	/// stuinfo 的摘要說明。
	/// </summary>
	public class stuinfo : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.TextBox pas;
		protected System.Web.UI.WebControls.Label info;
		protected System.Web.UI.WebControls.Button find;
		protected System.Web.UI.WebControls.Button add;
		protected System.Web.UI.WebControls.Button del;
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
		protected System.Web.UI.WebControls.TextBox manager;
		protected System.Web.UI.WebControls.Button enter;
		protected System.Web.UI.WebControls.TextBox dept;
		protected System.Web.UI.WebControls.TextBox stuname;
		protected System.Web.UI.WebControls.TextBox stuno;
		protected System.Web.UI.WebControls.TextBox stusex;
		protected System.Web.UI.WebControls.TextBox stubirth;
		public string getdept;
		public string getstuname;
		public string getstusex;
		public string getstuno;
		protected System.Web.UI.WebControls.Label change;
		protected System.Web.UI.WebControls.Button condel;
		public string getstubirth;
	
		private void Page_Load(object sender, System.EventArgs e)
		{   Session.Timeout=30; 
			getdept=dept.Text;
			getstuname=stuname.Text ;
			getstusex=stusex.Text;
			getstubirth=stubirth.Text;
			getstuno=stuno.Text;
			  DataGrid1.PagerStyle.Visible=true;
			
		}
		public void manaenter(object sender, System.EventArgs e)
		{
				if (manager.Text==ConfigurationSettings.AppSettings["managername"]&&pas.Text==ConfigurationSettings.AppSettings["password"])
		 {
				 Session["ifenter"]="hasenter";
			 info.Text="歡迎管理員登錄！";
		 }
		 else
			 info.Text="請確認輸入！";
		}
		public void find_Click(object sender, System.EventArgs e)
		{   SqlConnection Con = new SqlConnection("Data Source=localhost;Initial Catalog=class;User ID=sa;Pwd=;");  
			string sel;
				
						SqlDataAdapter Cmd ;
				
					sel="select * from stu where "+checkstr(getdept,"sdept")+checkstr(getstuname,"sname")+checkstr(getstusex,"ssex")+checkstr(getstubirth,"sdate")+checkstr(getstuno,"sno");
                     if(sel.EndsWith("and")==true)
                     sel=sel.Remove(sel.Length-3,3);  
					
					Cmd=new SqlDataAdapter(sel,Con);
					DataSet ds=new DataSet();
					Cmd.Fill(ds,"stu");
				    DataGrid1.DataSource=ds.Tables["stu"].DefaultView;
					DataGrid1.DataBind();
				
		 }
		public void addstu(object sender, System.EventArgs e)
		{
			try
			{
				if (Session["ifenter"]=="hasenter")
				{
					if ((getdept=="")||(getstuname=="")||(getstuno==""))
			 
						change.Text="必須項沒有填寫！";
					else 
				 
					{
						change.Text="正在操作";
						SqlConnection Con = new SqlConnection("Data Source=localhost;Initial Catalog=class;User ID=sa;Pwd=;");
						string sql = "insert into stu (sno,sname,sdate,ssex,sdept,spas) values ('" + getstuno + "','"+getstuname + "','" + getstubirth + "','" +getstusex  +"','"+getdept+ "','"+getstuno+"')";
						SqlCommand addCommand =new SqlCommand(sql,Con);
						addCommand.Connection.Open();
						addCommand.ExecuteNonQuery();
						addCommand.Connection.Close();
						change.Text="操作成功";
						stuno.Text="";
						stuname.Text="";
						stusex.Text="";
						dept.Text="";
						stubirth.Text="";
					}
				}
				else
					change.Text="你還沒登錄！";
			}
			catch
			{change.Text="處理數據時出錯";}
		}
		public void delstu(object sender, System.EventArgs e)
		{
				string delsql;
			if (Session["ifenter"]=="hasenter")
			{
					SqlConnection Con = new SqlConnection("Data Source=localhost;Initial Catalog=class;User ID=sa;Pwd=;");
				delsql  = "DELETE FROM stu WHERE "+checkstr(getdept,"sdept")+checkstr(getstuname,"sname")+checkstr(getstusex,"ssex")+checkstr(getstubirth,"sdate")+checkstr(getstuno,"sno");
				if(delsql.EndsWith("and")==true)
					delsql=delsql.Remove(delsql.Length-3,3);  
				SqlCommand delCommand =new SqlCommand(delsql,Con);
				delCommand.Connection.Open();
				delCommand.ExecuteNonQuery();
				delCommand.Connection.Close();
				change.Text="操作成功";
				condel.Visible=false;
			}
			else
				change.Text="你還沒登錄！";
		}
		public string checkstr(string a,string b)
		{if (a!="")
			 a=" "+b+"='"+a+"' and";
			return a;
		}
		public void showdel(object sender, System.EventArgs e)
		{find_Click(sender,e);
			condel.Visible=true;
			change.Text="將要刪除以下記錄！";
		}
				#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.find.Click += new System.EventHandler(this.find_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

	
	}
}