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 sms
{
	/// <summary>
	/// grade_manage 的摘要說明。
	/// </summary>
	public partial class grade_manage : System.Web.UI.Page
	{
        private string strsql;
		protected void Page_Load(object sender, System.EventArgs e)
		{
			// 在此處放置用戶代碼以初始化頁面
		}

		#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()
		{    

		}
		#endregion

		
		protected void Link_addgrade_Click(object sender, System.EventArgs e)
		{
			Response.Redirect("addgrade.aspx");
		}

		protected void Btn_search_Click(object sender, System.EventArgs e)
		{
			Bindgrid();

		}
        //public void DataGrid_Page(object sender,DataGridPageChangedEventArgs e)
        //{
        //    Dgd_grade.CurrentPageIndex=e.NewPageIndex;
        //    Bindgrid();
        //}
		public void Bindgrid()
		{
			if(Ddl_way.SelectedItem.Text=="按學號")
			{
				if(Tbx_term.Text=="所有")
				{
					strsql="select student_course.ID,student_course.Student_id,student.Student_name,student.Student_classid,student_course.Course_id,course.Course_name,teacher.Teacher_name,student_course.Student_grade from course,student,teacher,student_course,teacher_course where student_course.Student_id='"+Tbx_name.Text+"' and student_course.Course_id=course.Course_id and student_course.Student_id=student.Student_id and student_course.Course_id=teacher_course.Course_id and teacher_course.Teacher_id=teacher.Teacher_id and teacher_course.Class_id=student.Student_classid"; 
				}
				else
				{
					strsql="select student_course.ID,student_course.Student_id,student.Student_name,student.Student_classid,student_course.Course_id,course.Course_name,teacher.Teacher_name,student_course.Student_grade from course,student,teacher,student_course,teacher_course where student_course.Student_id='"+Tbx_name.Text+"' and student_course.Course_year='"+Tbx_term.Text+"' and student_course.Course_id=course.Course_id and student_course.Student_id=student.Student_id and student_course.Course_id=teacher_course.Course_id and teacher_course.Teacher_id=teacher.Teacher_id and teacher_course.Class_id=student.Student_classid"; 
				}
			}
			else if(Ddl_way.SelectedItem.Text=="按課號")
			{
				if(Tbx_term.Text=="所有")
				{
					strsql="select student_course.ID,student_course.Student_id,student.Student_name,student.Student_classid,student_course.Course_id,course.Course_name,teacher.Teacher_name,student_course.Student_grade from course,student,teacher,student_course,teacher_course where student_course.Course_id='"+Tbx_name.Text+"' and student_course.Course_id=course.Course_id and student_course.Student_id=student.Student_id and student_course.Course_id=teacher_course.Course_id and teacher_course.Teacher_id=teacher.Teacher_id and teacher_course.Class_id=student.Student_classid"; 
				}
				else
				{
					strsql="select student_course.ID,student_course.Student_id,student.Student_name,student.Student_classid,student_course.Course_id,course.Course_name,teacher.Teacher_name,student_course.Student_grade from course,student,teacher,student_course,teacher_course where student_course.Course_id='"+Tbx_name.Text+"' and student_course.Course_year='"+Tbx_term.Text+"' and student_course.Course_id=course.Course_id and student_course.Student_id=student.Student_id and student_course.Course_id=teacher_course.Course_id and teacher_course.Teacher_id=teacher.Teacher_id and teacher_course.Class_id=student.Student_classid"; 
				}
			}
			else if(Ddl_way.SelectedItem.Text=="按課程名")
			{
				if(Tbx_term.Text=="所有")
				{
					strsql="select student_course.ID,student_course.Student_id,student.Student_name,student.Student_classid,student_course.Course_id,course.Course_name,teacher.Teacher_name,student_course.Student_grade from course,student,teacher,student_course,teacher_course where course.Course_name='"+Tbx_name.Text+"' and student_course.Course_id=course.Course_id and student_course.Student_id=student.Student_id and student_course.Course_id=teacher_course.Course_id and teacher_course.Teacher_id=teacher.Teacher_id and teacher_course.Class_id=student.Student_classid"; 
			
				}
				else
				{
					strsql="select student_course.ID,student_course.Student_id,student.Student_name,student.Student_classid,student_course.Course_id,course.Course_name,teacher.Teacher_name,student_course.Student_grade from course,student,teacher,student_course,teacher_course where course.Course_name='"+Tbx_name.Text+"' and student_course.Course_year='"+Tbx_term.Text+"' and student_course.Course_id=course.Course_id and student_course.Student_id=student.Student_id and student_course.Course_id=teacher_course.Course_id and teacher_course.Teacher_id=teacher.Teacher_id and teacher_course.Class_id=student.Student_classid"; 
				}
			}
			else if(Ddl_way.SelectedItem.Text=="按班級")
			{
				if(Tbx_term.Text=="所有")
				{
					strsql="select student_course.ID,student_course.Student_id,student.Student_name,student.Student_classid,student_course.Course_id,course.Course_name,teacher.Teacher_name,student_course.Student_grade from course,student,teacher,student_course,teacher_course where student.Student_classid='"+Tbx_name.Text+"'and student_course.Course_id=course.Course_id and student_course.Student_id=student.Student_id and student_course.Course_id=teacher_course.Course_id and teacher_course.Teacher_id=teacher.Teacher_id and teacher_course.Class_id=student.Student_classid"; 
			
				}
				else
				{
					strsql="select student_course.ID,student_course.Student_id,student.Student_name,student.Student_classid,student_course.Course_id,course.Course_name,teacher.Teacher_name,student_course.Student_grade from course,student,teacher,student_course,teacher_course where student.Student_classid='"+Tbx_name.Text+"' and student_course.Course_year='"+Tbx_term.Text+"' and student_course.Course_id=course.Course_id and student_course.Student_id=student.Student_id and student_course.Course_id=teacher_course.Course_id and teacher_course.Teacher_id=teacher.Teacher_id and teacher_course.Class_id=student.Student_classid"; 
				}
			}
			else if(Ddl_way.SelectedItem.Text=="按教師號")
			{
				if(Tbx_term.Text=="所有")
				{
					strsql="select student_course.ID,student_course.Student_id,student.Student_name,student.Student_classid,student_course.Course_id,course.Course_name,teacher.Teacher_name,student_course.Student_grade from course,student,teacher,student_course,teacher_course where teacher.Teacher_id='"+Tbx_name.Text+"' and student_course.Course_id=course.Course_id and student_course.Student_id=student.Student_id and student_course.Course_id=teacher_course.Course_id and teacher_course.Teacher_id=teacher.Teacher_id and teacher_course.Class_id=student.Student_classid"; 
			
				}
				else
				{
					strsql="select student_course.ID,student_course.Student_id,student.Student_name,student.Student_classid,student_course.Course_id,course.Course_name,teacher.Teacher_name,student_course.Student_grade from course,student,teacher,student_course,teacher_course where teacher.Teacher_id='"+Tbx_name.Text+"' and student_course.Course_year='"+Tbx_term.Text+"' and student_course.Course_id=course.Course_id and student_course.Student_id=student.Student_id and student_course.Course_id=teacher_course.Course_id and teacher_course.Teacher_id=teacher.Teacher_id and teacher_course.Class_id=student.Student_classid"; 
				}
			}
			
			DataAccess DataAs = new DataAccess();
            DataTable DT = DataAs.CreateDatatable(strsql);
			if(DT.Rows.Count>0)
			{
                GridView1.Visible = true;
                GridView1.DataSource = DT;
                GridView1.DataBind();
			}
			else
			{
                GridView1.Visible = false;
				Lbl_note.Text="無紀錄！";
			}
		}
        //public void DataGrid_cancel(object sender,DataGridCommandEventArgs e)
        //{
			
        //    Dgd_grade.EditItemIndex=-1;
        //    Bindgrid();
			
        //}
        //public void DataGrid_edit(object sender,DataGridCommandEventArgs e)
        //{
			
        //    Dgd_grade.EditItemIndex=(int)e.Item.ItemIndex;
        //    Bindgrid();
			
        //}
        //public void DataGrid_update(object sender,DataGridCommandEventArgs e)
        //{
        //    string strsql = "update student_course set Student_grade=" + ((TextBox)e.Item.Cells[7].Controls[0]).Text + "where Student_id='" + e.Item.Cells[1].Text + "'and Course_id='" + e.Item.Cells[1].Text + "'and ID='" + Dgd_grade.DataKeys[(int)e.Item.ItemIndex]+"'";
        //    DataAccess DataAs = new DataAccess();
        //    bool Result = DataAs.ExecSql(strsql);
        //    if (Result)
        //    {
        //        Lbl_note.Text="編輯成功";
        //        Dgd_grade.EditItemIndex=-1;
        //    }
        //    else
        //    {
        //        Lbl_note.Text="編輯失敗";
        //        Lbl_note.Style["color"]="red";
        //    }		
        //    Bindgrid();
			
        //}
		
        //public void DataGrid_delete(object sender,DataGridCommandEventArgs e)
        //{