borrowhistory.aspx.cs

具有仓库管理信息系统的基本功能。。入库

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");
    }
}