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 BookNav : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        int BookID = Int32.Parse(Request.Params["BookID"]);
        //获取商品的详细信息
        GetBookDetails();
        addToCart.NavigateUrl = "AddToCart.aspx?BookID=" + BookID;
    }
    //获取商品详细信息
    public void GetBookDetails()
    {
        //读取数据库连接字符串
        string settings = Convert.ToString(ConfigurationManager.ConnectionStrings["SqlServices"]);
        //创建数据库连接
        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("@BookImages", SqlDbType.NVarChar, 50);
        parameterBookPicture.Direction = ParameterDirection.Output;
        myCommand.Parameters.Add(parameterBookPicture);

        SqlParameter parameterDescription = new SqlParameter("@BookIntro", SqlDbType.NVarChar, 4000);
        parameterDescription.Direction = ParameterDirection.Output;
        myCommand.Parameters.Add(parameterDescription);


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

        //根据存储过程的输出参数的值对各控件进行赋值
        MarketPrice.Text = String.Format("{0:c}", (decimal)parameterBookMarketPrice.Value);
        BookName.Text = (string)parameterBookName.Value;
        BookImage.ImageUrl =  ((string)parameterBookPicture.Value).Trim();
        BookPrice.Text = String.Format("{0:c}", (decimal)parameterBookPrice.Value);
        Dec.Text = ((string)parameterDescription.Value).Trim();

    }
}