getbookdetails.aspx.cs

完成一个网上书店系统

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

public partial class GetBookDetails : System.Web.UI.Page
{
   // Class db = new Class();
    
    int BookID;
    protected void Page_Load(object sender, EventArgs e)
    {
        
         BookID = Int32.Parse(Request.Params["BookID"]);
        
       
        //获取商品的详细信息
        getBookDetails();
        //动态传值（参数）给AddTOCart页面                重要
        HyperLink2.NavigateUrl = "AddTOCart.aspx?BookID=" + BookID;
    }
    public void getBookDetails()
    {
        //读取数据库连接字符串
        string settings = Convert.ToString(ConfigurationManager.ConnectionStrings["BookShopConnectionString"]);
        //创建数据库连接
        SqlConnection myconn = new SqlConnection(settings);
        //打开数据库连接
        myconn.Open();
        SqlCommand myCommand = new SqlCommand("BookDetail", myconn);
        //设定命令类型为存储过程
        myCommand.CommandType = CommandType.StoredProcedure;

        //给存储过程添加参数
        int BookID = Int32.Parse(Request.Params["BookID"]);
        SqlParameter parameterBookID = new SqlParameter("@BookID", SqlDbType.Int, 4);
        parameterBookID.Value = BookID;
        myCommand.Parameters.Add(parameterBookID);

        SqlParameter parameterBookPrice = new SqlParameter("@BookPrice", SqlDbType.Money, 8);
        //指出该参数是存储过程的OUTPUT参数
        parameterBookPrice.Direction = ParameterDirection.Output;
        myCommand.Parameters.Add(parameterBookPrice);

        SqlParameter parameterBookMarketPrice = new SqlParameter("@BookMarketPrice", SqlDbType.Money, 8);
        parameterBookMarketPrice.Direction = ParameterDirection.Output;
        myCommand.Parameters.Add(parameterBookMarketPrice);

        SqlParameter parameterBookName = new SqlParameter("@BookName", SqlDbType.NVarChar, 50);
        parameterBookName.Direction = ParameterDirection.Output;
        myCommand.Parameters.Add(parameterBookName);

        SqlParameter parameterBookPicture = new SqlParameter("@BookImage", SqlDbType.NVarChar, 50);
        parameterBookPicture.Direction = ParameterDirection.Output;
        myCommand.Parameters.Add(parameterBookPicture);

        

        SqlParameter parameterBookWriter = new SqlParameter("@Writer", SqlDbType.NVarChar, 50);
        parameterBookWriter.Direction = ParameterDirection.Output;
        myCommand.Parameters.Add(parameterBookWriter);

        SqlParameter parameterBookPree = new SqlParameter("@Pree", SqlDbType.NVarChar, 50);
        parameterBookPree.Direction = ParameterDirection.Output;
        myCommand.Parameters.Add(parameterBookPree);

        SqlParameter parameterBookBookInfo = new SqlParameter("@BookInfo", SqlDbType.NVarChar, 50);
        parameterBookBookInfo.Direction = ParameterDirection.Output;
        myCommand.Parameters.Add(parameterBookBookInfo);


        SqlParameter parameterBookPreeTime = new SqlParameter("@PreeTime", SqlDbType.NVarChar, 50);
        parameterBookPreeTime.Direction = ParameterDirection.Output;
        myCommand.Parameters.Add(parameterBookPreeTime);

        SqlParameter parameterBookISBN = new SqlParameter("@ISBN", SqlDbType.NVarChar, 50);
        parameterBookISBN.Direction = ParameterDirection.Output;
        myCommand.Parameters.Add(parameterBookISBN);

       
        //进行数据库操作
        myCommand.ExecuteNonQuery();
        //关闭数据库连接
        myconn.Close();

        
        
        //根据存储过程的输出参数的值对各控件进行赋值
        bookname.Text = (string)parameterBookName.Value;
        writer.Text = (string)parameterBookWriter.Value;
        pree.Text= (string)parameterBookPree.Value;
        preedate.Text = (string)parameterBookPreeTime.Value;
        isbn.Text= (string)parameterBookISBN.Value;

        marketmoney.Text = String.Format("{0:c}", (decimal)parameterBookMarketPrice.Value);
       
       bookimage.ImageUrl = ((string)parameterBookPicture.Value).Trim();
       salemoney.Text = String.Format("{0:c}", (decimal)parameterBookPrice.Value);
        bookinfo.Text = ((string)parameterBookBookInfo.Value).Trim();
        
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
       /*
       
        
        //放入购物车数据库
        int bookid = BookID;
        String bookname = bookname.Text;
        String BookMarketPrice= marketmoney.Text;
        String BookPrice = salemoney.Text;

        //读取数据库连接字符串
        string settings = Convert.ToString(ConfigurationManager.ConnectionStrings["BookShopConnectionString"]);
        //创建数据库连接
        SqlConnection myconn = new SqlConnection(settings);
        //打开数据库连接
        myconn.Open();
        SqlCommand myCommand = new SqlCommand("AddCart", myconn);
        //设定命令类型为存储过程
        myCommand.CommandType = CommandType.StoredProcedure;
        //.......
        */
    }
}