allbookdetails.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 Allbookdetails : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Session["uname"] == null)
            {
                Response.Write("<script language='javascript'>alert('您还没有注册或登陆');location.href='Login.aspx'</script>");

            }
            list();

        }

    }
    private void list()//显示详细信息
    {
        string Bookid;//定义一个变量接收传过来的变量
        Bookid = Request["Bookid"].ToString();//给他副传过来的变量值
        SqlConnection con = db.ceratcon();
        con.Open();
        SqlCommand cmd = new SqlCommand("select *  from Book  where Bookid='" + Bookid + "'", con);//wher条件取出相应的内容
        cmd.Parameters.Add("@Bookid", SqlDbType.VarChar);
        cmd.Parameters["@Bookid"].Value = Request.QueryString["Bookid"].ToString();
        SqlDataReader sdr = cmd.ExecuteReader();

        if (sdr.Read())
        {
            this.lablname.Text = Convert.ToString(sdr["Bookname"]);
            Labkeywords.Text = Convert.ToString(sdr["Keywords"]);
            Labtime.Text = Convert.ToString(sdr["Pubtime"]);
            Labzhaiyao.Text = Convert.ToString(sdr["Abstract"]);
            Laqikanming.Text = Convert.ToString(sdr["Qkname"]);
            Labaurhor.Text = Convert.ToString(sdr["Author"]);
            Label1.Text = Convert.ToString(sdr["Xzcount"]);


            Session["download"] = Convert.ToString("admin" + "/" + sdr["Location"]); 

        }
        con.Close();

    }

    private void updata()//更新数据函数
    {
        SqlConnection con2 = db.ceratcon();
        con2.Open();
        SqlCommand cmd = new SqlCommand("update  Book  set  Xzcount=Xzcount+1 where  Bookname=@Bookname", con2);
        cmd.Connection = (SqlConnection)con2;



        cmd.Parameters.Add("@Bookname", SqlDbType.VarChar);



        cmd.Parameters["@Bookname"].Value = this.lablname.Text.ToString();


        cmd.ExecuteNonQuery();
        con2.Close();//关闭连接
        //Response.Write("<script language='javascript'>alert('更新成功！')</script>");
    }

    protected void ImageButton1_Click1(object sender, ImageClickEventArgs e)
    {

        updata();
        Response.Redirect("download.aspx");


    }
}