在线等,我的购物车只能有一条记录,急!!!!
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(); 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"]); } DataTable newDT = new DataTable("CartTable"); ds.Tables.Add(newDT); DataColumn newDC; 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 = 2; 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["ProdID"] = goods_id; dr["ProdCount"] = ProdCount; dr["ProName"] = dss.Tables[0].Rows[0]["pro_name"]; dr["SalePrice"] = dss.Tables[0].Rows[0]["pro_sale_price"]; dr["MarketPrice"] = Convert.ToDouble(dss.Tables[0].Rows[0]["pro_sale_price"]) * ProdCount; newDT.Rows.Add(dr); } } if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { sum += Convert.ToInt32(ds.Tables[0].Rows[i]["MarketPrice"]); } RepM.DataSource = ds; RepM.DataBind(); } } }}