?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 Return : System.Web.UI.Page
{
    //全局變量
    private static string connstr = "Server=localhost;Database=Materialsystem;User ID=sa";
    SqlConnection stuinfoconn = new SqlConnection(connstr);
    SqlCommand mycomm = new SqlCommand();
    protected void Page_Load(object sender, EventArgs e)
    {
        welcomelable.Text = Session["studentname"].ToString();
        string stunum = Session["studentnumber"].ToString();
        string connstr = "Server=localhost;Database=Materialsystem;User ID=sa";
        string returnstr = "SELECT Borrownum as '出庫序號',Booknum as '貨物編號',Bookname as '貨物名稱',Bookclass as '貨物類別',Borrowbookdate as '出庫日期',Shouldreturnbookdate as '入庫日期' FROM Borrowbook WHERE Snum='" + stunum + "'";
        SqlConnection returnconn = new SqlConnection(connstr);
        SqlDataAdapter returnadapter=new SqlDataAdapter(returnstr,returnconn);
        DataSet ds=new DataSet();
        returnadapter.Fill(ds,"returntable");
        bookview.DataSource=ds.Tables["returntable"].DefaultView;
        bookview.DataBind();
    }
    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");
    }
    protected void IsbnButton_Click(object sender, EventArgs e)
    {
        SqlDataReader mydata;
        string borrowbookstr = "SELECT Booknum as '貨物編號',Bookname as '貨物名稱',Bookclass as '貨物類別',State as '出入庫清單' FROM Bookbaseinfo WHERE Booknum='" + IsbnTextBox.Text.ToString().Trim() + "'";
        mycomm.Connection = stuinfoconn;
        mycomm.CommandText = borrowbookstr;
        try
        {
            if (stuinfoconn.State == ConnectionState.Closed)
            {
                stuinfoconn.Open();
            }
            mydata = mycomm.ExecuteReader(CommandBehavior.CloseConnection);
            if (mydata.Read())
            {
                string booknum = mydata[0].ToString();
                string bookname = mydata[1].ToString();
                string bookclass = mydata[2].ToString();
                int state = Convert.ToInt16(mydata[3]);
                mydata.Close();
                //判斷貨物類別
                if (bookclass == "1")
                {
                    bookclass = "12號鋼材";
                }
                else if (bookclass == "2")
                {
                    bookclass = "9#鋼材";
                }
                else if (bookclass == "3")
                {
                    bookclass = "A4紙張";
                }
                else if (bookclass == "4")
                {
                    bookclass = "打印機墨盒";
                }

                if (state == 0)
                {
                    DateTime nowtime = DateTime.Now;
                    //發送入庫申請，等候答復                
                    string stunum = Session["studentnumber"].ToString().Trim();
                    string addstr = "INSERT INTO Returnregister VALUES('" + stunum + "','" + booknum + "','" + bookname + "','" + bookclass + "','" + nowtime + "')";
                    SqlCommand insertbookinfo = new SqlCommand(addstr, stuinfoconn);
                    if (stuinfoconn.State == ConnectionState.Closed)
                    {
                        stuinfoconn.Open();
                    }
                    insertbookinfo.ExecuteNonQuery();
                    stuinfoconn.Close();
                    Response.Write("<script>alert('入庫申請已發送，請等候管理員的答復！')</script>");
                }
            }
            else
            {
                Response.Write("<script>alert('您輸錯了貨物編號，請對照右邊的貨物列表檢查您的輸入！');</script>");
            }
        }
        catch (Exception ex)
        {
            throw ex;
        }
        finally
        {
            if (stuinfoconn.State == ConnectionState.Open)
            {
                stuinfoconn.Close();
            }
        }
    }
    protected void bookview_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        bookview.PageIndex = e.NewPageIndex;
        welcomelable.Text = Session["studentname"].ToString();
        string stunum = Session["studentnumber"].ToString();
        string connstr = "Server=localhost;Database=Materialsystem;User ID=sa";
        string returnstr = "SELECT Borrownum as '入庫序號',Booknum as '貨物編號',Bookname as '貨物名稱',Bookclass as '貨物類別',Borrowbookdate as '出庫日期',Shouldreturnbookdate as '入庫日期' FROM Borrowbook WHERE Snum='" + stunum + "'";
        SqlConnection returnconn = new SqlConnection(connstr);
        SqlDataAdapter returnadapter = new SqlDataAdapter(returnstr, returnconn);
        DataSet ds = new DataSet();
        returnadapter.Fill(ds, "returntable");
        bookview.DataSource = ds.Tables["returntable"].DefaultView;
        bookview.DataBind();
    }
}