?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_returnregister : 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 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 managereturnbutton_Click(object sender, EventArgs e)
    {
        Response.Redirect("../Manager/returnregister.aspx");
    }
    protected void logoutbutton_Click(object sender, EventArgs e)
    {
        Response.Redirect("../Login/Login.aspx");
    }

    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 Returnregister";
        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 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;

         
            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=1 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 Returnregister 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 Returnbook VALUES('" + snumtextbox.Text.ToString().Trim() + "','" + booknumtextbox.Text.ToString().Trim() + "','" + bookname + "','" + bookclass + "','" + nowtime + "')", stuinfoconn);
                inscomm.ExecuteNonQuery();
                stuinfoconn.Close();
                Response.Write("<script>alert('貨物已入庫！');</script>");
            }


        }
 
        string stuinfostr = "SELECT Snum as '職工號',Booknum as '貨物編號',Bookname as '貨物名稱', Bookclass as '貨物類別',Registerdate as '貨物出庫時間' FROM Returnregister";
        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 allborrowbutton_Click(object sender, EventArgs e)
    {
        string stuinfostr = "SELECT Snum as '職工號',Booknum as '貨物編號',Bookname as '貨物名稱', Bookclass as '貨物類別',Registerdate as '貨物出庫時間' FROM Returnregister";
        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 addbookbutton_Click(object sender, EventArgs e)
    {
        Response.Redirect("../Manager/addbook.aspx");
    }
}