?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 Manager_borrowregister : System.Web.UI.Page
{
    //全局變量
    private static string connstr = "Server=localhost;Database=Materialsystem;User ID=sa";
    SqlConnection stuinfoconn = new SqlConnection(connstr);
    SqlDataAdapter stuinfoadapter;
    DataSet ds;
    protected void Page_Load(object sender, EventArgs e)
    {
        wellabel.Text = Session["managername"].ToString();
    }
    protected void allborrowbutton_Click(object sender, EventArgs e)
    {
        string stuinfostr = "SELECT Snum as '職工號',Booknum as '貨物編號',Bookname as '貨物名稱', Bookclass as '貨物類別',Registerdate as '出庫時間' FROM Borrowregister";
        try
        {
            if (stuinfoconn.State == ConnectionState.Closed)
            {
                stuinfoconn.Open();
            }
            stuinfoadapter = new SqlDataAdapter(stuinfostr, stuinfoconn);
            ds = new DataSet();
            stuinfoadapter.Fill(ds, "Datatab");
            GridView1.DataSource = ds.Tables["Datatab"].DefaultView;
            GridView1.DataBind();
        }
        catch (Exception ex)
        {
            throw ex;
        }
        finally
        {
            if (stuinfoconn.State == ConnectionState.Open)
            {
                stuinfoconn.Close();
            }
        }
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        string stuinfostr = "SELECT Snum as 職工號',Booknum as '貨物編號',Bookname as '貨物名稱', Bookclass as '貨物類別',Registerdate as '出庫時間' FROM Borrowregister";
        try
        {
            if (stuinfoconn.State == ConnectionState.Closed)
            {
                stuinfoconn.Open();
            }
            stuinfoadapter = new SqlDataAdapter(stuinfostr, stuinfoconn);
            ds = new DataSet();
            stuinfoadapter.Fill(ds, "Datatab");
            GridView1.DataSource = ds.Tables["Datatab"].DefaultView;
            GridView1.DataBind();
        }
        catch (Exception ex)
        {
            throw ex;
        }
        finally
        {
            if (stuinfoconn.State == ConnectionState.Open)
            {
                stuinfoconn.Close();
            }
        }
    }
    protected void showallbutton_Click(object sender, EventArgs e)
    {
        Response.Redirect("../Manager/Management.aspx");
    }
    protected void manageborrowbutton_Click(object sender, EventArgs e)
    {
        Response.Redirect("../Manager/borrowregister.aspx");
    }
    protected void logoutbutton_Click(object sender, EventArgs e)
    {
        Response.Redirect("../Login/Login.aspx");
    }
    protected void okbutton_Click(object sender, EventArgs e)
    {
        SqlDataReader mydata;
        string borrowbookstr = "SELECT Booknum as '貨物編號',Bookname as '貨物名稱',Bookclass as '貨物類別' FROM Bookbaseinfo WHERE Booknum='" + booknumtextbox.Text.ToString().Trim() + "'";
        SqlCommand mycomm=new SqlCommand();
        mycomm.Connection = stuinfoconn;
        mycomm.CommandText = borrowbookstr;
            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();
                            mydata.Close();
                            
                            DateTime nowtime = DateTime.Now;
                           
                            DateTime shouldreturntime = DateTime.Now.AddDays(30);
                           
                            if(bookclass=="1")
                            {
                                bookclass = "12號鋼材";
                            }
                            else if(bookclass=="2")
                            {
                                bookclass = "9#鋼材";
                            }
                            else if(bookclass=="3")
                            {
                                bookclass = "A4紙張";
                            }
                            else if(bookclass=="4")
                            {
                                bookclass = "打印機墨盒";
                            }
               
                    if (stuinfoconn.State == ConnectionState.Closed)
                    {
                        stuinfoconn.Open();
                        string updatestr = "Update Bookbaseinfo SET State=0 WHERE Booknum='" + booknum + "'";
                        SqlCommand updatebookbaseinfo = new SqlCommand(updatestr, stuinfoconn);
                        updatebookbaseinfo.ExecuteNonQuery();
                        stuinfoconn.Close();
                     }
                    
                   
                     if (stuinfoconn.State == ConnectionState.Closed)
                      {
                            stuinfoconn.Open();
                            SqlCommand delcomm=new SqlCommand("DELETE FROM Borrowregister WHERE Snum='"+ snumtextbox.Text.ToString().Trim()+"' AND Booknum='"+booknumtextbox.Text.ToString().Trim()+"'",stuinfoconn);
                            delcomm.ExecuteNonQuery();
                            stuinfoconn.Close();
                       }


                  
                    if (stuinfoconn.State == ConnectionState.Closed)
                    {
                        stuinfoconn.Open();
                        SqlCommand inscomm=new SqlCommand("INSERT INTO Borrowbook VALUES('"+ snumtextbox.Text.ToString().Trim()+"','"+booknumtextbox.Text.ToString().Trim()+"','"+bookname+"','"+bookclass+"','"+nowtime+"','"+shouldreturntime+"')",stuinfoconn);
                        inscomm.ExecuteNonQuery();
                        stuinfoconn.Close();
                        Response.Write("<script>alert('貨物已經出庫！');</script>");
                    }


            }
      
            string stuinfostr = "SELECT Snum as '職工號',Booknum as '貨物編號',Bookname as '貨物名稱', Bookclass as '貨物類別',Registerdate as '出庫時間' FROM Borrowregister";
        try
        {
            if (stuinfoconn.State == ConnectionState.Closed)
            {
                stuinfoconn.Open();
            }
            stuinfoadapter = new SqlDataAdapter(stuinfostr, stuinfoconn);
            ds = new DataSet();
            stuinfoadapter.Fill(ds, "Datatab");
            GridView1.DataSource = ds.Tables["Datatab"].DefaultView;
            GridView1.DataBind();
        }
        catch (Exception ex)
        {
            throw ex;
        }
        finally
        {
            if (stuinfoconn.State == ConnectionState.Open)
            {
                stuinfoconn.Close();
            }
        }
    }

    protected void managereturnbutton_Click1(object sender, EventArgs e)
    {
        Response.Redirect("../Manager/returnregister.aspx");
    }
    protected void addbookbutton_Click(object sender, EventArgs e)
    {
        Response.Redirect("../Manager/addbook.aspx");
    }
}