AdimiFile/Managerorder.aspx.cs

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

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

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


        if (!IsPostBack)
        { NewMethod(); }



    }

    private void NewMethod()
    {
        string strsql = "SELECT     ShoppingCar.Id as 编号,Users.UserName as 用户名, WenJu.Name as 商品名, WenJu.Price as 单价, ShoppingCar.GoodsCount as 商品数量, ShoppingCar.CarTime as 下单时间 FROM         ShoppingCar INNER JOIN  Users ON ShoppingCar.UserId = Users.UserId INNER JOIN  WenJu ON ShoppingCar.GoodsId = WenJu.Id where ShoppingCar.ShoppingId='002' order by CarTime desc";
        DAL.DataAccess.GridviewBang(strsql, GridView1);
    }

    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {


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

    }

    protected void GridView1_SelectedIndexChanged1(object sender, EventArgs e)
    {

    }


    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        LinkButton link = (LinkButton)sender;
        string Id = link.CommandArgument;
        int shoppingId = int.Parse(Id);
        DAL.DataAccess.ExecuteNo(string.Format("Update ShoppingCar set ShoppingId='003' Where ID='{0}'", shoppingId));
        NewMethod();

    }
}