shopcar.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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;

public partial class shopcar : System.Web.UI.Page
{
    String SqlStr;
    DB db = new DB();
    DataSet Ds = new DataSet();

    //绑定数据方法
    public void DataListBind()
    {
        SqlStr = "select * from 购物车视图 where 会员名='" + Session["Username"] + "'";
        Ds = db.GetDataTableBySql(SqlStr);
        try
        {
            this.DataList1.DataSource = Ds.Tables[0].DefaultView;
            this.DataList1.DataBind();
        }
        catch (Exception)
        {
            Response.Write("<script>alert('没有得到数据,请重试！')</script>");
        }
    }

    //计算总金额
    public void total_money()
    {
        SqlStr = "select * from 购物车视图 where 会员名='" + Session["Username"] + "'";
        Ds = db.GetDataTableBySql(SqlStr);
        try
        {
            if (Ds.Tables[0].Rows.Count != 0)
            {
                Double price, sum = 0;
                int count;
                for (int i = 0; i < Ds.Tables[0].Rows.Count; i++)//通过循环得到总金额
                {
                    price = Double.Parse(Ds.Tables[0].Rows[i]["价格"].ToString());
                    count = int.Parse(Ds.Tables[0].Rows[i]["数量"].ToString());
                    sum += price * count;
                }
                this.total_money_txt.Text = sum.ToString();
            }
        }
        catch (Exception)
        {
            Response.Write("<script>alert('没有得到数据,请重试！')</script>");
        }
    }
    protected void Page_Load(object sender, EventArgs e)
    {