admin/aordershanchu.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 aordershanchu : System.Web.UI.Page
{
    String SqlStr;
    DataSet Ds = new DataSet();
    DB db = new DB();
    String Book_ID;
    public void DataListBind()
    {
        SqlStr = "select 订单编号,会员名,convert(varchar,订单日期,112) as 订单日期,发货方式,付款方式,总金额,是否发货,备注 from 订单表";
        Ds = db.GetDataTableBySql(SqlStr);
        try
        {
            this.DataList1.DataSource = Ds.Tables[0].DefaultView;
            this.DataList1.DataBind();
        }
        catch (Exception)
        {
            Response.Write("<script>alert('没有得到数据,请重试！')</script>");
        }
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Page.IsPostBack == false)
        {
            SqlStr = "select 订单编号,会员名,convert(varchar,订单日期,112) as 订单日期,发货方式,付款方式,总金额,是否发货,备注 from 订单表";
            Ds = db.GetDataTableBySql(SqlStr);
            try
            {
                if (Ds.Tables[0].Rows.Count != 0)
                {
                    this.DataList1.DataSource = Ds.Tables[0].DefaultView;
                    this.DataList1.DataBind();
                }
            }
            catch (Exception)
            {
                Response.Write("<script>alert('没有获得任何数据，请检查！')</script>");
            }
        }
    }
    protected void DataList1_DeleteCommand(object source, DataListCommandEventArgs e)
    {
        String book_id = this.DataList1.DataKeys[e.Item.ItemIndex].ToString();
        SqlStr = "delete from 订单表 where 订单编号='" + book_id + "'";
        Boolean Del_Result;
        Del_Result = db.UpdateDataBySql(SqlStr);
        if (Del_Result == true)
        {
            Response.Write("<script>alert('记录删除成功！')</script>");