ShoppingCar/EditBill.aspx.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Collections;

public partial class ShoppingCar_EditBill : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {


        if (!IsPostBack)
        { NewMethod(); }



    }

    private void NewMethod()
    {
        string strsql = string.Format("SELECT    ShoppingCar.ID as 编号, ShoppingCar.GoodsId as 商品编号, WenJu.Name as 商品名称, WenJu.Price as 价格, ShoppingCar.GoodsCount as 商品件数,ShoppingCar.CarTime as 加入时间  FROM         WenJu INNER JOIN ShoppingCar ON WenJu.Id = ShoppingCar.GoodsId Where UserId='{0}'and ShoppingId='001' order by ShoppingCar.CarTime desc", Session["UserId"]);
        DAL.DataAccess.GridviewBang(strsql, GridView1);
        string strsql1 = string.Format("SELECT   sum(GoodsCount),SUM(Price) FROM    WenJu INNER JOIN ShoppingCar ON WenJu.Id = ShoppingCar.GoodsId where UserId='{0}' and ShoppingId='001' ", Session["UserId"]);
        DataTable dt = DAL.DataAccess.Execute(strsql1);
        Label2.Text = dt.Rows[0][1].ToString();
        Label4.Text = dt.Rows[0][0].ToString();
    }

    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {


    }
    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {

    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        string strsql = string.Format("update ShoppingCar set ShoppingCar.ShoppingId='002' where UserId='{0}' and ShoppingId='001'", Session["UserId"]);
        DAL.DataAccess.ExecuteNo(strsql);
        Page.ClientScript.RegisterClientScriptBlock(GetType(), "Ok", "alert(\"订单提交成功！\")", true);
        NewMethod();
        
    }


    protected void ObjectDataSource1_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
    {

    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        Response.Redirect("~/UI/FristPage.aspx");
    }