当前位置: 代码迷 >> ASP.NET >> 还是购物车有关问题,怎样删除购物车中的某一项
  详细解决方案

还是购物车有关问题,怎样删除购物车中的某一项

热度:8781   发布时间:2013-02-25 00:00:00.0
还是购物车问题,怎样删除购物车中的某一项?
C# code
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"]);            }            if (Session["myCartTable"] == null)            {                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);                    }                }            }            else            {                ds = (DataSet)Session["myCartTable"];                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 = ds.Tables["CartTable"].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;                        ds.Tables["CartTable"].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();            }        }    }}
  相关解决方案