shopcart.aspx.cs

完成一个网上书店系统

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

public partial class shopcart : System.Web.UI.Page
{
    Class1 db = new Class1();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            DataList2Bind();
            //返回上一页
            if (Request.UrlReferrer != null)
                ViewState["UrlReferrer"] = Request.UrlReferrer.ToString();
        }
        
    }
    protected void DataList2Bind()
    {
        DataList2.DataSource = db.createdataset("select * from ShopCart");
        DataList2.DataKeyField = "BookID";
        DataList2.DataBind();
    }

    protected void Button2_Click(object sender, EventArgs e)
    {
        //返回上一页
        Response.Redirect(ViewState["UrlReferrer"].ToString());
    }
    protected void DataList2_CancelCommand(object source, DataListCommandEventArgs e)
    {
        //取消更新
        DataList2.EditItemIndex = -1;
        DataList2Bind();
    }
    protected void DataList2_DeleteCommand(object source, DataListCommandEventArgs e)
    {
        //删除
        int bookid = Convert.ToInt32(DataList2.DataKeys[e.Item.ItemIndex].ToString());
        string sql = "delete from ShopCart where BookID=" + bookid;
        if (db.ExecSql(sql))
        {
            //Response.Write("<script>return alert('删除成功')<script>");
            Page.ClientScript.RegisterStartupScript(this.GetType(), "MessageBox", "alert('删除成功')", true);
            DataList2.EditItemIndex = -1;
            DataList2Bind();
        }
    }
    protected void DataList2_EditCommand(object source, DataListCommandEventArgs e)
    {
        //编辑
        DataList2.EditItemIndex = e.Item.ItemIndex;
        DataList2Bind();
    }
    protected void DataList2_UpdateCommand(object source, DataListCommandEventArgs e)
    {
        //更新
        int bookid = Convert.ToInt32(DataList2.DataKeys[e.Item.ItemIndex].ToString());
        int count = Convert.ToInt32(((TextBox)e.Item.FindControl("TextBox3")).Text);
        decimal BookPrice = Convert.ToDecimal(((Label)e.Item.FindControl("Label16")).Text);
       // Byte  iscanel = Convert.ToByte(((CheckBox)e.Item.FindControl("CheckBox2")).Text);
        CheckBox remove=((CheckBox)e.Item.FindControl("CheckBox2"));
        decimal moneycount = count * BookPrice;
        string sql = null;
        if (count < 0)
        {
            //Response.Write("<script>return alert('购买数量不能为负数')</script>");
            //throw new Exception("购买数量不能为负数");
            Page.ClientScript.RegisterStartupScript(this.GetType(), "MessageBox", "alert('购买数量不能为负数')", true);
        }
        else
        {

            if (remove.Checked == false)
            {
                sql = "update ShopCart set BookCount=" + count + ",MoneyCount=" + moneycount + "  where  BookID=" + bookid;

            }
            if (remove.Checked == true || count == 0)
            {
                sql = "delete from ShopCart where BookID=" + bookid;
            }
            if (db.ExecSql(sql))
            {
                DataList2.EditItemIndex = -1;
                DataList2Bind();
            }
        }
    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        //结算
        Response.Redirect("Checkout.aspx");
    }
}