?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.SqlClient;

public partial class 鏈接頁面_BorrowHistory : System.Web.UI.Page
{
    //全局變量
    //private static string connstr = "Server=localhost;Database=Materialsystem;User ID=DB";
    //SqlConnection bookinfoconn = new SqlConnection(connstr);

    protected void Page_Load(object sender, EventArgs e)
    {
        //string stunum = Session["studentnumber"].ToString().Trim();
        ////string returnedstr = "SELECT Returnnum as '入庫序號',Booknum as '貨物編號',Bookname as '貨物名稱',Bookclass as '貨物類別',Returnbookdate as '入庫日期' FROM Returnbook WHERE Snum='"+ stunum +"'";
        //string notreturnstr = "SELECT Borrownum as '出庫序號',Booknum as '貨物編號',Bookname as '貨物名稱',Bookclass as '貨物類別',Borrowbookdate as '出庫日期',Shouldreturnbookdate as '應還日期' FROM Borrowbook WHERE Snum='" + stunum + "'";

        //try
        //{
        //    //打開數據庫連接,測試數據庫是否打開成功
        //    if (bookinfoconn.State == ConnectionState.Closed)
        //    {
        //        bookinfoconn.Open();

        //    }
        //    SqlCommand textcom = new SqlCommand(notreturnstr, bookinfoconn);
        //    SqlDataReader test = textcom.ExecuteReader();
        //    if(test.Read())
        //    {
        //        Response.Write("<script>alert('讀到了數據！');</script>");
        //    }
        //    else
        //    {
        //        Response.Write("<script>alert('沒有讀到數據！');</script>");
        //    }
        //    //SqlDataAdapter returnedadapter = new SqlDataAdapter(returnedstr,bookinfoconn);
        //    //DataSet ds1 = new DataSet();
        //    //returnedadapter.Fill(ds1,"reurnedtable");
        //    //ReturnedGridview.DataSource = ds1.Tables["returnedtable"].DefaultView;
        //    //ReturnedGridview.DataBind();

        //    SqlDataAdapter notreturndadapter = new SqlDataAdapter(notreturnstr, bookinfoconn);
        //    DataSet ds2 = new DataSet();
        //    notreturndadapter.Fill(ds2, "notreturntable");
        //    NotReturnGridview.DataSource = ds2.Tables["notreturntable"].DefaultView;
        //    NotReturnGridview.DataBind();
        //}
        //catch
        //{
         
        //}
        //finally
        //{
        //    //關閉數據庫連接
        //    if (bookinfoconn.State == ConnectionState.Open)
        //    {
        //        bookinfoconn.Close();
        //    }
        //}
    }
    protected void mainpage_Click(object sender, EventArgs e)
    {
        Response.Redirect("../Mainbody/BorrowReturn.aspx");
    }
    protected void personinfo_Click(object sender, EventArgs e)
    {
        Response.Redirect("../Link/Myinfo.aspx");
    }
    protected void borrowbook_Click(object sender, EventArgs e)
    {
        Response.Redirect("../Link/Borrow.aspx");
    }
    protected void returnbook_Click(object sender, EventArgs e)
    {
        Response.Redirect("../Link/Return.aspx");
    }
    protected void history_Click(object sender, EventArgs e)
    {
        Response.Redirect("../Link/BorrowHistory.aspx");
    }
    protected void changepwd_Click(object sender, EventArgs e)
    {
        Response.Redirect("../Link/ChangePwd.aspx");
    }
    protected void logout_Click(object sender, EventArgs e)
    {
        Session.Contents.Remove("studentname");
        Session.Contents.Remove("studentnum");
        Response.Redirect("../Login/Login.aspx");
    }
}