?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 Borrow : System.Web.UI.Page
{
    //全局變量
    private static string connstr = "Server=localhost;Database=Materialsystem;User ID=sa";
    SqlConnection stuinfoconn = new SqlConnection(connstr);
    SqlDataAdapter stuinfoadapter;
    DataSet ds;
    SqlCommand mycomm = new SqlCommand();
    //加載頁面時綁定Bookbaseinfo到GridView控件
    protected void Page_Load(object sender, EventArgs e)
    {
        welcomelable.Text=Session["studentname"].ToString();
        string stuinfostr = "SELECT Bookseque as '序號',Booknum as '貨物編號',Bookname as '貨物名稱',Bookclass as '貨物類別',State as '出入庫狀態' FROM Bookbaseinfo";
        try
        {
            if (stuinfoconn.State == ConnectionState.Closed)
            {
                stuinfoconn.Open();
            }
            stuinfoadapter = new SqlDataAdapter(stuinfostr,stuinfoconn);
            ds = new DataSet();
            stuinfoadapter.Fill(ds, "Datatab");
            bookview.DataSource = ds.Tables["Datatab"].DefaultView;
            bookview.DataBind();
        }
        catch (Exception ex)
        {
            throw ex;
        }
        finally
        {
            if (stuinfoconn.State == ConnectionState.Open)
            {
                stuinfoconn.Close();
            }
        }

    }
    //GridView分頁
    protected void bookview_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        bookview.PageIndex = e.NewPageIndex;
        string stuinfostr = "SELECT Bookseque as '序號',Booknum as '貨物編號',Bookname as '貨物名稱',Bookclass as '貨物類別',State as '出入庫狀態' FROM Bookbaseinfo";
        try
        {
            if (stuinfoconn.State == ConnectionState.Closed)
            {
                stuinfoconn.Open();
            }
            stuinfoadapter = new SqlDataAdapter(stuinfostr, stuinfoconn);
            ds = new DataSet();
            stuinfoadapter.Fill(ds, "Datatab");
            bookview.DataSource = ds.Tables["Datatab"].DefaultView;
            bookview.DataBind();
        }
        catch (Exception ex)
        {
            throw ex;
        }
        finally
        {
            if (stuinfoconn.State == ConnectionState.Open)
            {
                stuinfoconn.Close();
            }
        }
    }
    //借書按鈕相應事件
    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)
                {
                    Response.Write("<script>alert('該貨物已全部出庫！');</script>");
                }
                else
                {
                    DateTime nowtime = DateTime.Now;
                    //發送出庫申請，等候答復                
                    string stunum = Session["studentnumber"].ToString().Trim();
                    string addstr = "INSERT INTO Borrowregister 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 CancelButton_Click(object sender, EventArgs e)
    {
        
    }
    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");
    }
}