?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;
using System.Data.Sql;
using System.Data.SqlClient;

public partial class Student_Check_Grade_CheckGrade : System.Web.UI.Page
{
    string Sno;
    string ConnectionString =
   ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
    SqlConnection myConnection = null;
    SqlDataAdapter myAdapter = null;
    DataSet myDateSet = null;

    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["USERSTYLE"] == "STUDENT")
        {
        }
        else
        {
            Dialog("對不起，你沒有權限訪問這個頁面！");
            Response.Redirect("~/SystemManage/Login.aspx");
        }
        Sno = Session["USERNAME"].ToString();
    }
    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 BtnQuery_Click(object sender, EventArgs e)
    {
        String StrTestNo;//試卷編號
        String StrSclass;//班級
        String StrGrade;//分數
        if (DrpTestNo.SelectedValue != "---請選擇---")
        {
            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 = DateTime.MinValue.Date;
            MinDate = "1800-01-01";
            //日期差距太大的話，datediff函數會出現這種錯誤：從 char 數據類型到 datetime 數據類型的轉換導致 datetime 值越界。
        }
        else
        {
            //String StrTemp = TxtMinTestTime.Text + " 00:00:00";
            MinDate = TxtMinTestTime.Text;
        }
        String MaxDate;
        if (TxtMaxTestTime.Text == "")
        {
            MaxDate = DateTime.Now.Date.ToString("yyyy-MM-dd");
        }
        else
        {
            MaxDate = TxtMaxTestTime.Text;
        }
         String StrSno =Session["USERID"].ToString();// "3103003343";
        String QueryString = "SELECT [PERTESTSYNAX], [PERTESTREAD], [PERTESTFULL], [GRADE], " +
            "[SCLASS], [SNAME], [SNO], [TESTNO], [SETTEXTTIME], [DOTEXTTIME], [FULLMARK], " +
            "[AVERAGEGRADE], [TESTSTYLE] FROM [V_TESTSTUENTGRADE] WHERE ([SNO]='" + StrSno + "') 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";
    }
    protected void BtnReturn_Click(object sender, EventArgs e)
    {
        Response.Redirect("~/SystemManage/Main.aspx");
    }
}