orderlist.aspx.cs

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

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

using System;
using System.Collections.Generic;

using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;

public partial class Admin_orderlist : System.Web.UI.Page
{
    private static string sql;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            sql = "select * from View_3 where AddUser='" + Session["MemberID"].ToString() + "'";
            BindData(sql);
        } 
    } 
    private void BindData(string sql)
    {
        SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["connstr"]);
        SqlDataAdapter sda = new SqlDataAdapter(sql, conn);
        DataSet ds = new DataSet();
        sda.Fill(ds);
        this.gvOrderList.DataSource = ds.Tables[0].DefaultView;
        gvOrderList.DataBind();
    } 

 



    protected void gvOrderList_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        /*
      * 删除前的判定是否确认删除_客户端js完成
      * 从表中删除指定编号的订单信息——订单明细会被自动删除——关系图中设置了层叠
      * 删除后重新绑定
      * 
      */
        int orderid = Convert.ToInt32(this.gvOrderList.DataKeys[e.RowIndex].Value.ToString());

        //删除数据库中该编号的的信息记录
        SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["connstr"]);
        conn.Open();
        string sql0 = string.Format("delete from tb_Order where OrderID ={0} ", orderid);
        SqlCommand cmd = new SqlCommand(sql0, conn);
        cmd.ExecuteNonQuery();
        sql = "select * from View_3 where AddUser='" + Session["MemberID"].ToString() + "'";
        BindData(sql);

        //释放空间
        cmd.Dispose();
        conn.Close();

        Response.Write("<script language='javascript'>alert(' 删除成功！');document.location=document.location;</script>");