asp.net 购物车例子完整源码下载(含数据库)

【实例简介】C#购物车

【实例截图】

【核心代码】

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;

//51aspx
public partial class ShoppingCart : System.Web.UI.Page
{
    public static string M_str_Count;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            //向购物车中添加商品，如果购物车中已经存在该商品，则商品数量加１，如果是第一次购买，则向购物车中添加一条商品信息
            string P_str_CartID = Session["UserID"].ToString();
            string P_str_GoodsID = Request["GoodsID"];
            DataSet ds = DB.reDs("select count(*) from tb_Cart where CartID="   P_str_CartID   "and GoodsID="   P_str_GoodsID);
            if (ds.Tables[0].Rows[0][0].ToString() == "0")
            {

                DataSet ds1 = DB.reDs("select GoodsName,GoodsPrice from tb_GoodsInfo where GoodsID="   P_str_GoodsID);
                string P_str_GoodsName = ds1.Tables[0].Rows[0][0].ToString();
                string P_str_GoodsPrice = ds1.Tables[0].Rows[0][1].ToString();
                string P_str_Num = "1";
                DB.ExSql("insert into tb_Cart values("   P_str_CartID   ","   P_str_GoodsID   ",'"   P_str_GoodsName   "',"   P_str_GoodsPrice   ","   P_str_Num   ")");
            }
            else
            {
                DB.ExSql("update tb_Cart set Num=Num 1 where CartID="   P_str_CartID   "and GoodsID="   P_str_GoodsID);
            }


            //显示购物车中的商品信息
            Bind();
        }
    }
    //绑定DataList控件
    public void Bind()
    {
        DataSet ds2 = DB.reDs("select *,GoodsPrice*Num As Count from tb_Cart where CartID="   Session ["UserID"]);
        float P_fl_Count = 0;
        foreach (DataRow dr in ds2.Tables[0].Rows)
        {
            P_fl_Count  = Convert.ToSingle(dr[6]);
        }
        M_str_Count = P_fl_Count.ToString();
        dlShoppingCart.DataSource = ds2;
        dlShoppingCart.DataBind();
    }
    //51aspx
    protected void dlShoppingCart_ItemDataBound(object sender, DataListItemEventArgs e)
    {
        //用来实现数量文本框中只能输入数字
        TextBox txtGoodsNum = (TextBox)e.Item.FindControl("txtGoodsNum");
        if (txtGoodsNum != null)
        {
            txtGoodsNum.Attributes["onkeyup"] = "value=value.replace(/[^\\d]/g,'')";
        }

    }
    //清空购物车
    protected void lnkbtnClear_Click(object sender, EventArgs e)
    {
        bool P_bool_reVal=DB.ExSql("Delete from tb_Cart where CartID=" Session["UserID"]);
        if (!P_bool_reVal)
            Response.Write("<script>清空失败，请重试！</script>");
        else
            Bind();
    }
    //清空购物车时的提示信息
    protected void lnkbtnClear_Load(object sender, EventArgs e)
    {
        lnkbtnClear.Attributes["onclick"] = "javascript:return confirm('你确定要清空购物车吗？')";
    }
    //5-1-a-s-p-x
    //继续购物
    protected void lnkbtnContinue_Click(object sender, EventArgs e)
    {
        Response.Redirect("~/Default.aspx");
    }
    //删除购物车中的商品
    protected void dlShoppingCart_DeleteCommand(object source, DataListCommandEventArgs e)
    {
        bool P_bool_reVal = DB.ExSql("Delete from tb_Cart where CartID="   Session["UserID"] " and GoodsID=" e.CommandArgument.ToString ());
        if (!P_bool_reVal)
            Response.Write("<script>删除失败，请重试！</script>");
        else
            Bind();
    }
    //删除购物车中的商品时的提示信息
    protected void lnkbtnDel_Load(object sender, EventArgs e)
    {
        ((LinkButton)sender).Attributes["onclick"] = "javascript:return confirm('你确定要删除该物品吗？')";
    }
    //更新购物车
    protected void dlShoppingCart_ItemCommand(object source, DataListCommandEventArgs e)
    {
        if (e.CommandName == "updateNum")
        {
            string P_str_Num = ((TextBox)e.Item.FindControl("txtGoodsNum")).Text;
            bool P_bool_reVal = DB.ExSql("update tb_Cart set Num="   P_str_Num   "where CartID="   Session["UserID"]   "and GoodsID="   e.CommandArgument.ToString());
            if (P_bool_reVal)
                Bind();
        }
    }
    //-------------------------51aspx-----------------------------------//
    protected void lnkbtnSettleAccounts_Click(object sender, EventArgs e)
    {
        if (M_str_Count == "")
        {
            Response.Write("<script>alert('您的购物车中没有任何物品!');</script>");
        }
        else
        {
            DataSet ds = DB.reDs("select Money from tb_User where UserID="   Session["UserID"].ToString());
            decimal P_str_Money = Convert.ToDecimal (ds.Tables [0].Rows [0][0].ToString ());
            if (P_str_Money < Convert.ToDecimal (M_str_Count))
            {
                Response.Write("<script>alert('您的余额不足，请重新充值后再购买！');</script>");
            }
            else
            {
                bool P_bool_reVal1 = DB.ExSql("Delete from tb_Cart where CartID="   Session["UserID"]);
                bool P_bool_reval2 = DB.ExSql("update tb_User set Money=Money-" M_str_Count " where UserID=" Session["UserID"]);
                if (!P_bool_reVal1 & !P_bool_reval2)
                {
                    Response.Write("<script>结账失败，请重试！</script>");
                }
                else
                {
                    Bind();
                    //Response.Redirect("SuccessShop.aspx");
                    Response.Write("<script>window.open('SuccessShop.aspx','','Width=300px;Height=250px;status=no;help=no;scrollbars=no');</script>");
                }
            }
        }
    }
}