WebSite/Admin/AdminTest/OrderMg/OrderDel.aspx.cs

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

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

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Text;
using System.Data;
using Model;
using BLL;

namespace ShopAdmin.OrderMg
{
    public partial class OrderDel : System.Web.UI.Page
    {
        private Int32 adminId;
        protected void Page_Load(object sender, EventArgs e)
        {
            if (SubTool.CheckAdminLogin("0"))
            {
                adminId = WebUtility.CheckInt(MyCookie.getCookiesValue("shop8517Admin", "AdminId"));
                if (!this.IsPostBack)
                {
                    bindDataList();
                }
            }
        }

        private void bindDataList()
        {
            StringBuilder sb = new StringBuilder();

            //select a.[OrderId],a.[UserId],IsNew,OrderState,ISNULL(b.[PriceTotal],0) as PriceTotal,ISNULL(b.[FreightTotal],0) as FreightTotal from orderList as a Left Join (select OrderId,sum(MemberPrice*Discount) as PriceTotal,sum(Freight) as FreightTotal  from orderDetail group by OrderId) as b On b.[OrderId]=a.[OrderId]
            int currPage = WebUtility.CheckInt(Request["p"]);
            if (currPage == 0)
            {
                currPage = 1;
            }

            PageList pl = new PageList();
            pl.CurrPage = currPage;
            pl.PageSize = 16;

            pList8517.CurPage = currPage;

            pl.TableName = "(orderList as a Left Join (select OrderId,sum(MemberPrice*Discount) as PriceTotal,sum(Freight) as FreightTotal  from orderDetail group by OrderId) as b On b.[OrderId]=a.[OrderId])";
            pl.PKey = " a.[OrderId]";
            pl.FieldList = "a.[OrderId],a.[UserId],IsNew,OrderState,OrderTime,ISNULL(b.[PriceTotal],0) as PriceTotal,ISNULL(b.[FreightTotal],0) as FreightTotal";
            pl.Condition = " and OrderState=0";
            pl.OrderBy = " OrderTime Desc";

            D_TableUpDateFields tb = new D_TableUpDateFields();
            DataSet dSet = tb.GetPageList(pl);
            if (dSet.Tables.Count > 0)
            {
                if (dSet.Tables[0].Rows.Count > 0)
                {
                    gvDataList.DataSource = dSet.Tables[0];
                    gvDataList.DataKeyNames = new string[] { "OrderId" };
                    gvDataList.DataBind();