bookdetails.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 admin_Bookdetails : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Session["aname"] == null)
            {
                Response.Write("<script language='javascript'>alert('您还没有注册或登陆');location.href='../admin/AdminLogin.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"]);
            this.HyperLink1.NavigateUrl = Convert.ToString(sdr["Location"]); 

           

        }
        con.Close();

    }
    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        //删除不要的期刊


        SqlConnection con3 = db.ceratcon();
        con3.Open();
        SqlCommand cmd3 = new SqlCommand(" delete Book  where Bookname=@Bookname", con3);
        cmd3.Parameters.Add("@Bookname", SqlDbType.VarChar);
        cmd3.Parameters["@Bookname"].Value = this.lablname.Text;
        cmd3.ExecuteNonQuery();
        con3.Close();
       

        Response.Write("<script language='javascript'>alert('数据删除成功');location.href='../admin/Contral.aspx'</script>");


    }


  
   
    
}