bookDet.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial  class bookDet : System.Web.UI.Page
{
    SqlData da = new SqlData();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            bindToComment();
        }
    }
    private void bindToComment()
    {
        string sql = @"SELECT a.*,b.typename FROM Book a
                        INNER JOIN dbo.Booktype  b ON a.booktypeid=b.typeid  where a.barcode=" + Request.QueryString["id"];
        DataTable dt = da.datesetExecute(sql, "tbBook").Tables[0];

        foreach (DataRow item in dt.Rows)
        {
            imgph.ImageUrl = "Admin/"+item["photo"] + "";
            typename.Text = item["typename"] + "";
            bookname.Text = item["typename"] + "";
            price.Text = item["price"] + ""; 
            jies.Text = item["remarks"] + "";
        }
    }

    protected void btUpdate_Click(object sender, EventArgs e)
    {
        if (Session["uname"] == null)
        {
            Response.Redirect("Default.aspx");
            return;
        }
        var sql = @"insert into userbook values('" + Session["uname"] + "','" + Request.QueryString["id"] + "',getdate())";
        da.ExecuteSQL(sql);
        Common.ShowMessage.Show(Page, "Error", "购买成功..");
    }
}