+ -
当前位置:首页 → 问答吧 → 用asp.net写购物车,要怎么写?刚接触asp求思路啊。。。。。。

用asp.net写购物车,要怎么写?刚接触asp求思路啊。。。。。。

时间:2011-09-09

来源:互联网

刚学asp。net2个礼拜,做项目要写购物车,大家给点写购物车的思路吧,要用到asp的什么控件?大概的思路说说,当然具体的最好啦。求思路,代码。

作者: tmacdream   发布时间: 2011-09-09

前台代码
HTML code
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="shopCart.aspx.cs" Inherits="shopCart" MasterPageFile ="~/MasterPage.master" Title ="购物车" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<table style=" font-size: 9pt; font-family: 宋体; width:574px; height :806px; background-repeat :no-repeat; background-image: url(images/显示页面当前位置.jpg);">
            <tr>
            <td style ="height :20px" valign="middle" align="left">
                <br /><br />&nbsp;
              目前位置:首页 &gt; 购物车
            </td>
            </tr>
            <tr>
            <td valign =top style ="height :786px" >
                        <table cellSpacing="0" cellPadding="0" width="95%" align="center" border="0" style="FONT-SIZE: 9pt">
                             <tr>
                             <td align="center">
                                <asp:Label ID="labMessage" runat="server" Visible="False"></asp:Label></td>
                            </tr>
                            <tr>
                             <td align="left" style="height: 30px">
                                <asp:Label ID="labTotalPrice" runat="server" Text="0.00 " ></asp:Label></td>
                            </tr>
                            <tr style =" font :9pt; font-family :宋体;"  valign =top >
                            <td align="left" style="height: 135px">
                            
                             <asp:GridView ID="gvShopCart" DataKeyNames ="BookID"   runat="server"  AutoGenerateColumns="False"  AllowPaging="True" OnPageIndexChanging="gvShopCart_PageIndexChanging" BackColor="LightGoldenrodYellow" BorderColor="Tan" BorderWidth="1px" CellPadding="2" ForeColor="Black" GridLines="None" >
                                 <Columns>
                                     <asp:BoundField DataField="No" HeaderText="序号" ReadOnly="True">
                                         <ItemStyle HorizontalAlign="Center" />
                                         <HeaderStyle HorizontalAlign="Center" />
                                     </asp:BoundField>  
                                      <asp:BoundField DataField="BookID" HeaderText="商品ID" ReadOnly="True">
                                         <ItemStyle HorizontalAlign="Center" />
                                         <HeaderStyle HorizontalAlign="Center" />
                                     </asp:BoundField>                                    
                                     <asp:BoundField DataField="BookName" HeaderText="商品名称" ReadOnly="True">
                                      <ItemStyle HorizontalAlign="Center" />
                                      <HeaderStyle HorizontalAlign="Center" />
                                     </asp:BoundField>  
                                     <asp:TemplateField HeaderText="数量">
                                    <ItemTemplate >
                                       <asp:TextBox ID="txtNum" runat="server" Text =<%#Eval("Num") %> Width =60px  OnTextChanged="txtNum_TextChanged"></asp:TextBox>
                                       <asp:RegularExpressionValidator
                                ID="RegularExpressionValidator1" runat="server" ControlToValidate="txtNum"
                                ErrorMessage="×" ValidationExpression="^\+?[1-9][0-9]*$"></asp:RegularExpressionValidator>
                                </ItemTemplate>
                                </asp:TemplateField>
                                   
                                     <asp:TemplateField HeaderText =单价>
                                         <HeaderStyle HorizontalAlign=Center />
                                         <ItemStyle HorizontalAlign =Center />
                                         <ItemTemplate >
                                            <%#Eval("price")%></ItemTemplate>    
                                     </asp:TemplateField>
                                    <asp:TemplateField HeaderText =总价>
                                         <HeaderStyle HorizontalAlign=Center />
                                         <ItemStyle HorizontalAlign =Center />
                                         <ItemTemplate >
                                            <%#Eval("totalPrice")%></ItemTemplate>    
                                     </asp:TemplateField>
                                     <asp:TemplateField>
                                         <HeaderStyle HorizontalAlign=Center />
                                         <ItemStyle HorizontalAlign =Center />
                                         <ItemTemplate >
                                             <asp:LinkButton ID="lnkbtnDelete" runat="server" CommandArgument ='<%#Eval("BookID") %>' OnCommand ="lnkbtnDelete_Command">删除</asp:LinkButton>
                                         </ItemTemplate>    
                                     </asp:TemplateField>
                                     
                                 </Columns>
                                 <FooterStyle BackColor="Tan" />
                                 <SelectedRowStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" />
                                 <PagerStyle BackColor="PaleGoldenrod" ForeColor="DarkSlateBlue" HorizontalAlign="Center" />
                                 <HeaderStyle BackColor="Tan" Font-Bold="True" />
                                 <AlternatingRowStyle BackColor="PaleGoldenrod" />
                                </asp:GridView>
                            </td>
                            </tr>
                            <tr align =left valign =top  >
                                <td align="center"  >
                                    <asp:LinkButton ID="lnkbtnUpdate" runat="server" OnClick="lnkbtnUpdate_Click">更新购物车</asp:LinkButton>
                                    &nbsp;<asp:LinkButton ID="lnkbtnClear" runat="server" OnClick="lnkbtnClear_Click" >清空购物车</asp:LinkButton>
                                    <asp:LinkButton ID="lnkbtnContinue" runat="server" OnClick="lnkbtnContinue_Click" >继续购物</asp:LinkButton>  
                                    <asp:LinkButton ID="lnkbtnCheck" runat="server" OnClick="lnkbtnCheck_Click" >前往服务台</asp:LinkButton>
                                    </td>
                            </tr>
                            <tr>
                            <td align="left"  >
                                <br />
                                &nbsp;<li>如果要修改商品数量,请单击“更新购物车”按钮 &nbsp;&nbsp;&nbsp;</li>&nbsp;<li>如果要取消某个商品,请直接单击表格控件中的“删除”
                            <br />
                            </li>
                            </td>
                            </tr>
                        </table>
            </td>
            </tr>
            </table>
</asp:Content>




作者: ezero8385   发布时间: 2011-09-09

后台代码
C# code

public partial class shopCart : System.Web.UI.Page
{
    CommonClass ccObj = new CommonClass();
    DBClass dbObj = new DBClass();
    string strSql;
    DataTable dtTable;
    Hashtable hashCar;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            /*判断是否登录*/
            ST_check_Login();
            if (Session["ShopCart"] == null)
            {
                //如果没有购物,则给出相应信息,并隐藏按钮
                this.labMessage.Text = "您还没有购物!";
                this.labMessage.Visible = true;        //显示提示信息
                this.lnkbtnCheck.Visible = false;      //隐藏“前往服务台”按钮
                this.lnkbtnClear.Visible = false;      //隐藏“清空购物车”按钮
                this.lnkbtnContinue.Visible = false;   //隐藏“继续购物”按钮

            }
            else
            {
                hashCar = (Hashtable)Session["ShopCart"]; //获取其购物车
                if (hashCar.Count == 0)
                {
                    //如果没有购物,则给出相应信息,并隐藏按钮
                    this.labMessage.Text = "您购物车中没有商品!";
                    this.labMessage.Visible = true;        //显示提示信息
                    this.lnkbtnCheck.Visible = false;      //隐藏“前往服务台”按钮
                    this.lnkbtnClear.Visible = false;      //隐藏“清空购物车”按钮
                    this.lnkbtnContinue.Visible = false;   //隐藏“继续购物”按钮

                }
                else
                {
                    //设置购物车内容的数据源
                    dtTable = new DataTable();
                    DataColumn column1 = new DataColumn("No");        //序号列
                    DataColumn column2 = new DataColumn("BookID");    //商品ID代号
                    DataColumn column3 = new DataColumn("BookName");  //商品名称
                    DataColumn column4 = new DataColumn("Num");       //数量
                    DataColumn column5 = new DataColumn("price");     //单价
                    DataColumn column6 = new DataColumn("totalPrice");//总价
                    dtTable.Columns.Add(column1);  //添加新列            
                    dtTable.Columns.Add(column2);
                    dtTable.Columns.Add(column3);
                    dtTable.Columns.Add(column4);
                    dtTable.Columns.Add(column5);
                    dtTable.Columns.Add(column6);
                    DataRow row;
                    //对数据表中每一行进行遍历,给每一行的新列赋值
                    foreach (object key in hashCar.Keys)
                    {
                        row = dtTable.NewRow();
                        row["BookID"] = key.ToString();
                        row["Num"] = hashCar[key].ToString();
                        dtTable.Rows.Add(row);
                    }
                    //计算价格
                    DataTable dstable;
                    int i = 1;
                    float price;//商品单价
                    int count;  //商品数量
                    float totalPrice = 0; //商品总价格
                    foreach (DataRow drRow in dtTable.Rows)
                    {
                        strSql = "select BookName,HotPrice from tb_GoodsInfo where BookID=" + Convert.ToInt32(drRow["BookID"].ToString());
                        dstable = dbObj.GetDataSetStr(strSql, "tbGI");
                        drRow["No"] = i;//序号
                        drRow["BookName"] = dstable.Rows[0][0].ToString();//商品名称
                        drRow["price"] = (dstable.Rows[0][1].ToString());//单价
                        price = float.Parse(dstable.Rows[0][1].ToString());//单价
                        count = Int32.Parse(drRow["Num"].ToString());
                        drRow["totalPrice"] = price * count; //总价
                        totalPrice += price * count; //计算合价
                        i++;
                    }
                    this.labTotalPrice.Text = "总价:" + totalPrice.ToString();  //显示所有商品的价格
                    this.gvShopCart.DataSource = dtTable.DefaultView;   //绑定GridView控件
                    this.gvShopCart.DataKeyNames = new string[] { "BookID" };
                    this.gvShopCart.DataBind();
                }
            }
        
        }
       
    }
    public void bind()
    {
        if (Session["ShopCart"] == null)
        {
            //如果没有购物,则给出相应信息,并隐藏按钮
            this.labMessage.Text = "您还没有购物!";
            this.labMessage.Visible = true;        //显示提示信息
            this.lnkbtnCheck.Visible = false;      //隐藏“前往服务台”按钮
            this.lnkbtnClear.Visible = false;      //隐藏“清空购物车”按钮
            this.lnkbtnContinue.Visible = false;   //隐藏“继续购物”按钮
            
        }
        else
        {
            hashCar = (Hashtable)Session["ShopCart"]; //获取其购物车
            if (hashCar.Count == 0)
            {
                //如果没有购物,则给出相应信息,并隐藏按钮
                this.labMessage.Text = "您购物车中没有商品!";
                this.labMessage.Visible = true;        //显示提示信息
                this.lnkbtnCheck.Visible = false;      //隐藏“前往服务台”按钮
                this.lnkbtnClear.Visible = false;      //隐藏“清空购物车”按钮
                this.lnkbtnContinue.Visible = false;   //隐藏“继续购物”按钮
               
            }
            else
            {
                //设置购物车内容的数据源
                dtTable = new DataTable();
                DataColumn column1 = new DataColumn("No");        //序号列
                DataColumn column2 = new DataColumn("BookID");    //商品ID代号
                DataColumn column3 = new DataColumn("BookName");  //商品名称
                DataColumn column4 = new DataColumn("Num");       //数量
                DataColumn column5 = new DataColumn("price");     //单价
                DataColumn column6 = new DataColumn("totalPrice");//总价
                dtTable.Columns.Add(column1);  //添加新列            
                dtTable.Columns.Add(column2);
                dtTable.Columns.Add(column3);
                dtTable.Columns.Add(column4);
                dtTable.Columns.Add(column5);
                dtTable.Columns.Add(column6);
                DataRow row;
                //对数据表中每一行进行遍历,给每一行的新列赋值
                foreach (object key in hashCar.Keys)
                {
                    row = dtTable.NewRow();
                    row["BookID"] = key.ToString();
                    row["Num"] = hashCar[key].ToString();
                    dtTable.Rows.Add(row);
                }
                //计算价格
                DataTable dstable;
                int i = 1;
                float price;//商品单价
                int count;  //商品数量
                float totalPrice = 0; //商品总价格
                foreach (DataRow drRow in dtTable.Rows)
                {
                    strSql = "select BookName,HotPrice from tb_GoodsInfo where BookID=" + Convert.ToInt32(drRow["BookID"].ToString());
                    dstable = dbObj.GetDataSetStr(strSql, "tbGI");
                    drRow["No"] = i;//序号
                    drRow["BookName"] = dstable.Rows[0][0].ToString();//商品名称
                    drRow["price"] = (dstable.Rows[0][1].ToString());//单价
                    price = float.Parse(dstable.Rows[0][1].ToString());//单价
                    count = Int32.Parse(drRow["Num"].ToString());
                    drRow["totalPrice"] = price * count; //总价
                    totalPrice += price * count; //计算合价
                    i++;
                }
                this.labTotalPrice.Text = "总价:" + totalPrice.ToString();  //显示所有商品的价格
                this.gvShopCart.DataSource = dtTable.DefaultView;   //绑定GridView控件
                this.gvShopCart.DataKeyNames=new string[] {"BookID"};
                this.gvShopCart.DataBind();
            }
        }
            
    
    
    }
    protected void lnkbtnUpdate_Click(object sender, EventArgs e)
    {
        hashCar = (Hashtable)Session["ShopCart"];  //获取其购物车
        //使用foreach语句,遍历更新购物车中的商品数量
        foreach (GridViewRow gvr in this.gvShopCart.Rows)
        {
            TextBox otb = (TextBox)gvr.FindControl("txtNum"); //找到用来输入数量的TextBox控件 
            int count = Int32.Parse(otb.Text);//获得用户输入的数量值
            string BookID = gvr.Cells[1].Text;//得到该商品的ID代
            hashCar[BookID] = count;//更新hashTable表
        }
        Session["ShopCart"] = hashCar;//更新购物车
        Response.Redirect("shopCart.aspx");
    }
    protected void lnkbtnDelete_Command(object sender, CommandEventArgs e)
    {
        hashCar = (Hashtable)Session["ShopCart"];//获取其购物车
        //从Hashtable表中,将指定的商品从购物车中移除,其中,删除按钮(lnkbtnDelete)的CommandArgument参数值为商品ID代号
        hashCar.Remove(e.CommandArgument);
        Session["ShopCart"] = hashCar; //更新购物车
        Response.Redirect("shopCart.aspx");
    }
    protected void lnkbtnClear_Click(object sender, EventArgs e)
    {
        Session["ShopCart"] =null;
        Response.Redirect("shopCart.aspx");
    }
    protected void lnkbtnContinue_Click(object sender, EventArgs e)
    {
        Response.Redirect("Default.aspx");
    }
    protected void lnkbtnCheck_Click(object sender, EventArgs e)
    {
        Response.Redirect("checkOut.aspx");
    }
    protected void gvShopCart_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        gvShopCart.PageIndex = e.NewPageIndex;
        bind();

    }
    protected void txtNum_TextChanged(object sender, EventArgs e)
    {
        hashCar = (Hashtable)Session["ShopCart"];  //获取其购物车
        foreach (GridViewRow gvr in this.gvShopCart.Rows)
        {

            TextBox otb = (TextBox)gvr.FindControl("txtNum"); //找到用来输入数量的TextBox控件 
            int count = Int32.Parse(otb.Text);//获得用户输入的数量值
            string BookID = gvr.Cells[1].Text;//得到该商品的ID代
            hashCar[BookID] = count;//更新hashTable表

        }
        Session["ShopCart"] = hashCar;//更新购物车
        bind();

    }
}

作者: ezero8385   发布时间: 2011-09-09

后台代码using
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.Data.SqlClient;
using System.Text.RegularExpressions;


作者: ezero8385   发布时间: 2011-09-09