order.aspx.cs

前台首页：users/index.aspx 后台首页：login.aspx 这是一个有关宠物的电子商务网站 注：后台的“售后服务” 和“数据统计”这两块由于时间原因暂时 没完成。由于技术问

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;
using System.Data.SqlClient;

public partial class order : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            databind();
        }
    }
    protected void btuclick(object sender, EventArgs e)
    {
        string str = ((Button)sender).CommandArgument.ToString(); 
        SqlConnection con = new SqlConnection("data source=localhost;uid=sa;pwd=;database=Ebusiness");
        con.Open();
        SqlCommand comm = new SqlCommand("update orderinfo set orderstatus=1,sender=@sender where orderid=@orderid", con);
        SqlParameter par1 = new SqlParameter("@orderid",SqlDbType.Int);
        par1.Value = Convert.ToInt32(str);
        comm.Parameters.Add(par1);
        SqlParameter par2 = new SqlParameter("@sender", SqlDbType.Char,20);
        par2.Value ="已发货";
        comm.Parameters.Add(par2);
        comm.ExecuteNonQuery();
        con.Close();
        ShowMassage("确认订单成功");
        databind();
           
    }
    void databind()
    {
        SqlConnection con = new SqlConnection("data source=localhost;uid=sa;pwd=;database=Ebusiness");
        con.Open();
        DataSet ds = new DataSet();
        SqlDataAdapter sqld = new SqlDataAdapter("select *from orderinfo",con);
        sqld.Fill(ds,"tab");
        con.Close();
        GridView1.DataSource = ds.Tables[0].DefaultView;
        GridView1.DataBind();
    }
    protected void delclick(object sender, EventArgs e)
    {
        string str = ((Button)sender).CommandArgument.ToString(); 
        SqlConnection con = new SqlConnection("data source=localhost;uid=sa;pwd=;database=Ebusiness");
        con.Open();
        SqlCommand comm = new SqlCommand("delete from orderinfo where orderid=@orderid",con);
        SqlParameter par1 = new SqlParameter("@orderid", SqlDbType.Int);
        par1.Value = Convert.ToInt32(str);
        comm.Parameters.Add(par1);
        comm.ExecuteNonQuery();
        con.Close();
        databind();
    }
    private void ShowMassage(string msg)
    {
        Response.Write("<script>window.alert('" + msg + "')</script>");
    }
}