日期:2014-05-17  浏览次数:20326 次

我的购物车代码里面只能加一件商品,急!
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.Text;
using System.Data.SqlClient;

public partial class ShoppingCart : System.Web.UI.Page
{
  public int goods_id = 0;
  public int ProdCount = 0;

  public int sum = 0;
  DataSet ds = new DataSet();
  DataTable newDT = new DataTable("CartTable");
  DataColumn newDC;
  protected void Page_Load(object sender, EventArgs e)
  {
  if (!IsPostBack)
  {
  HttpCookie cookie = Request.Cookies["UserInfo"];
  if (null == cookie)
  {
  Response.Write("<script>location.href='login.aspx'</script>");
  Response.End();
  }

  if (Request.QueryString["goods_id"] != null || Request.QueryString["goods_id"] != "")
  {
  goods_id = Convert.ToInt32(Request.QueryString["goods_id"]);
  }
  if (Request.QueryString["ProdCount"] != null || Request.QueryString["ProdCount"] != "")
  {
  ProdCount = Convert.ToInt32(Request.QueryString["ProdCount"]);
  }


   
  ds.Tables.Add(newDT);
   
  newDC = new DataColumn("ProdID", System.Type.GetType("System.Int32"));
  ds.Tables["CartTable"].Columns.Add(newDC);
  newDC = new DataColumn("ProdCount", System.Type.GetType("System.Int32"));
  newDC.DefaultValue = 1;
  ds.Tables["CartTable"].Columns.Add(newDC);
  newDC = new DataColumn("ProName", System.Type.GetType("System.String"));
  ds.Tables["CartTable"].Columns.Add(newDC);
  newDC = new DataColumn("SalePrice", System.Type.GetType("System.Double"));
  ds.Tables["CartTable"].Columns.Add(newDC);
  newDC = new DataColumn("MarketPrice", System.Type.GetType("System.Double"));
  ds.Tables["CartTable"].Columns.Add(newDC);
  Session["myCartTable"] = ds;
  StringBuilder strSqlString = new StringBuilder();
  strSqlString.Append("select ");
  strSqlString.Append("pro_name, ");
  strSqlString.Append("pro_sale_price, ");
  strSqlString.Append("pro_market_price ");
  strSqlString.Append("from ");
  strSqlString.Append("tb_products ");
  strSqlString.Append("where ");
  strSqlString.Append("pro_id = " + goods_id);
  DataSet dss = SqlHelper.GetDataSet(SqlHelper.ConnectionString, CommandType.Text, strSqlString.ToString(), null);
  if (goods_id > 0)
  {
  if (dss.Tables[0].Rows.Count > 0)
  {
  DataRow dr = newDT.NewRow();
  dr[