?using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class TestManage_StatInfo : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        try{
            if (Session["USERSTYLE"] == "TEACHER")
            {
                //DrpTestNo.DataSourceID = "SqlDataSource_TestInfo";
                //if (IsPostBack==true)
                //{
                    //DrpTestNo.Items.Insert(0,"---請選擇---");
                //}
            }
            else
            {
                Dialog("對不起，你沒有權限訪問這個頁面！");
                Response.Redirect("~/SystemManage/Login.aspx");
            }
        }
        catch(Exception E)
        {
             Dialog("對不起，你沒有權限訪問這個頁面！");
             Response.Redirect("~/SystemManage/Login.aspx");
        }
    }
    private void Dialog(String Str)
    {
        Response.Write(@"<script type='text/JavaScript'>");
        Response.Write(@"alert('" + Str + "');");
        //Response.Write(@"window.location='./list_logingroup.aspx';");
        Response.Write(@"</script>");
    }
    
    private bool IsGrade(String Str)
    {
        if (Str.Length <= 4)
        {
            char[] charArray = Str.ToCharArray();
            for (int i = 0; i < Str.Length; i++)
            {
                if (charArray[i] <= '0' && charArray[i] >= '9')
                {
                    return false;
                }
            }
            return true;
        }
        else
        {
            return false;
        }
    }
    protected void BtnReturn_Click(object sender, EventArgs e)
    {
        Response.Redirect("~/SystemManage/TeacherMain.aspx");
    }
    protected void BtnQuery_Click(object sender, EventArgs e)
    {
        String StrTestNo;
        String StrSclass;
        String StrGrade;
        if (DrpTestNo.SelectedValue != "---請選擇---")
        {
            //GridView_StatInfo.DataSourceID = "SqlDataSource_Query";
            StrTestNo = DrpTestNo.SelectedItem.Text;
        }
        else
        {
            StrTestNo = "%";
        }
        if (DrpSClass.SelectedValue != "---請選擇---")
        {
            StrSclass = DrpSClass.SelectedItem.Text;
        }
        else
        {
            StrSclass = "%";
        }
        if (DrpSSGrade.SelectedValue != "---請選擇---")
        {
            StrGrade = DrpSSGrade.SelectedItem.Text;
        }
        else
        {
            StrGrade = "%";
        }
        float MinGrade;
        if (TxtMinGrade.Text == "")
        {
            MinGrade = 0.0f;
        }
        else
        {
            MinGrade = float.Parse(TxtMinGrade.Text);
        }
        float MaxGrade;
        if (TxtMaxGrade.Text == "")
        {
            MaxGrade = 1000.0f;
        }
        else
        {
            MaxGrade = float.Parse(TxtMaxGrade.Text);
        }
        String MinDate;
        if (TxtMinTestTime.Text =="")
        {
            MinDate = "1800-01-01";
        }
        else
        {
            MinDate = TxtMinTestTime.Text;
        }
        String MaxDate;
        if (TxtMaxTestTime.Text == "")
        {
            MaxDate = DateTime.Now.Date.ToString("yyyy-MM-dd");
        }
        else
        {
            MaxDate = TxtMaxTestTime.Text;
        }
        String StrTno = Session["USERID"].ToString();
        String QueryString = "SELECT [PERTESTSYNAX], [PERTESTREAD], [PERTESTFULL], [GRADE], "+
            "[SCLASS], [SNAME], [SNO], [TESTNO], [SETTEXTTIME], [DOTEXTTIME], [FULLMARK], "+
            "[AVERAGEGRADE], [TESTSTYLE] FROM [V_TESTSTUENTGRADE] WHERE ([TNO]='" + StrTno + "') AND ([TESTNO] LIKE '" + StrTestNo +
            "')AND ([SCLASS] LIKE '" + StrSclass + "') AND ([AVERAGEGRADE] LIKE '" + StrGrade +
            "') AND (CONVERT(FLOAT,[GRADE])>=" + MinGrade + ") AND (CONVERT(FLOAT,[GRADE])<=" + MaxGrade +
            ") AND datediff(d,[DOTEXTTIME],\'" + MinDate + "\') < 0 AND datediff(d,[DOTEXTTIME],\'" + MaxDate + "\') > 0 ORDER BY [TESTNO], [SNO]";
        //SqlDataSource_Query.
        SqlDataSource_Query.SelectCommand = QueryString;
        //SqlDataSource_Query.
        GridView_StatInfo.DataSourceID = "SqlDataSource_Query";


    }
}