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?buy?:?System.Web.UI.Page
{
????protected?void?Page_Load（object?sender?EventArgs?e）
????{
????????if?（Session.Count?==?0）
????????{
????????????Response.Write（“ript>alert（‘你尚未登錄，請先登錄‘）ript>“）;
????????????Response.Write（“ript>history.go（-1）ript>“）;
????????????Response.End（）;

????????}
????????else
????????????if?（!IsPostBack）
????????????{
????????????????int?num?=?Convert.ToInt32（Request.QueryString[“num“]）;
????????????????int?id?=?Convert.ToInt32（Request.QueryString[“id“]）;
????????????????//判斷該用戶是否已經(jīng)將該商品放置到購物車中
????????????????string?sql?=?“select?*?from?購物表?where?用戶名=‘“?+?Session[“name“].ToString（）?+?“‘?AND?商品id=“?+?id;
????????????????//如果查詢結(jié)果>0，則是已經(jīng)購買過，只需修改購買數(shù)量即可
????????????????if?（DbManager.ExecuteQuery（sql）.Rows.Count?>?0）
????????????????{
????????????????????sql?=?“update?購物表?set?購買數(shù)量=購買數(shù)量+“?+?num?+?“?where?商品id=“?+?id;
????????????????????DbManager.ExecuteNonQuery（sql）;
????????????????}
????????????????else
????????????????{
????????????????????if?（id?!=?0）
????????????????????{
????????????????????????sql?=?“insert?into?購物表（用戶名購買數(shù)量商品id）?VALUES（‘“?+?Session[“name“].ToString（）?+?“‘‘“?+?num?+?“‘‘“?+?id?+?“‘）“;
????????????????????????DbManager.ExecuteNonQuery（sql）;
????????????????????}
????????????????}
????????????????//顯示購物表中自己的購物信息
????????????????string?sql2?=?“SELECT?product.productName購物表.購買數(shù)量購物表.商品idproduct.price?FROM?購物表product?where?product.bh=購物表.商品id?AND?用戶名=‘“?+?Session[“name“].ToString（）?+?“‘“;
????????????????Repeater1.DataSource?=?DbManager.ExecuteQuery（sql2）;
????????????????Repeater1.DataBind（）;

????????????????int?inum?iproid;
????????????????double?iprice?dblalltotal?=?0;
????????????????string?sql5?=?““;
????????????????for?（int?i?=?0;?i?????????????????{
????????????????????//使用FindContent找到Repeater空間中相應(yīng)的控件，并轉(zhuǎn)換成相應(yīng)類型
????????????????????inum?=?Convert.ToInt32（（（TextBox）this.Repeater1.Items[i].FindControl（“txtnum“））.Text）;
????????????????????iproid?=?Convert.ToInt32（（（Label）this.Repeater1.Items[i].FindControl（“l(fā)blid“））.Text）;
????????????????????iprice?=?Convert.ToDouble（（（Label）this.Repeater1.Items[i].FindControl（“l(fā)blprice“））.Text）;
????????????????????dblalltotal?=?dblalltotal?+?inum?*?iprice;?//計算總價錢
????????????????????（（Label）this.Repeater1.Items[i].FindControl（“l(fā)bltotal“））.Text?=?（inum?*?iprice）.ToString（）;

????????????????????sql5?=?“UPDATE?購物表?SET?購買數(shù)量=“?+?inum?+?“?WHERE?商品id=“?+?iproid;

????????????????????DbManager.ExecuteNonQuery（sql5）;
????????????????}
????????????????lblalltotal.Text?=?“總計：“?+?dblalltotal.ToString（）?+?“元“;

????????????}
????}


????protected?void?btnedit_Click（object?sende

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

????.......??????3266??2011-12-06?10:58??51aspx_OnlineShoppingCart887aabd4-5182-4a79-a87a-46d021e2142d\App_Code\DbManager.cs

????.......????688128??2011-12-06?10:58??51aspx_OnlineShoppingCart887aabd4-5182-4a79-a87a-46d021e2142d\App_Data\shop.mdb

????.......????229376??2011-12-06?10:58??51aspx_OnlineShoppingCart887aabd4-5182-4a79-a87a-46d021e2142d\bin\ActiproSoftware.CodeHighlighter.Net20.dll

????.......????229376??2011-12-06?10:58??51aspx_OnlineShoppingCart887aabd4-5182-4a79-a87a-46d021e2142d\bin\ActiproSoftware.Shared.Net20.dll

????.......?????17408??2011-12-06?10:58??51aspx_OnlineShoppingCart887aabd4-5182-4a79-a87a-46d021e2142d\bin\CodeHighlighterTest.dll

????.......????237568??2011-12-06?10:58??51aspx_OnlineShoppingCart887aabd4-5182-4a79-a87a-46d021e2142d\bin\DotNetTextBox.dll

????.......???????260??2011-12-06?10:58??51aspx_OnlineShoppingCart887aabd4-5182-4a79-a87a-46d021e2142d\bin\DotNetTextBox.dll.refresh

????.......????245760??2011-12-06?10:58??51aspx_OnlineShoppingCart887aabd4-5182-4a79-a87a-46d021e2142d\bin\EnvDTE.dll

????.......????655360??2011-12-06?10:58??51aspx_OnlineShoppingCart887aabd4-5182-4a79-a87a-46d021e2142d\bin\Interop.Word.dll

????.......?????64088??2011-12-06?10:58??51aspx_OnlineShoppingCart887aabd4-5182-4a79-a87a-46d021e2142d\bin\Microsoft.Vbe.Interop.dll

????.......????223800??2011-12-06?10:58??51aspx_OnlineShoppingCart887aabd4-5182-4a79-a87a-46d021e2142d\bin\Office.dll

????.......?????20480??2011-12-06?10:58??51aspx_OnlineShoppingCart887aabd4-5182-4a79-a87a-46d021e2142d\bin\Word_dntb.dll

????.......??????2826??2011-12-06?10:58??51aspx_OnlineShoppingCart887aabd4-5182-4a79-a87a-46d021e2142d\buy.aspx

????.......??????6563??2011-12-06?10:58??51aspx_OnlineShoppingCart887aabd4-5182-4a79-a87a-46d021e2142d\buy.aspx.cs

????.......???????447??2011-12-06?10:58??51aspx_OnlineShoppingCart887aabd4-5182-4a79-a87a-46d021e2142d\CheckCode.aspx

????.......??????3086??2011-12-06?10:58??51aspx_OnlineShoppingCart887aabd4-5182-4a79-a87a-46d021e2142d\CheckCode.aspx.cs

????.......????????14??2011-12-06?10:58??51aspx_OnlineShoppingCart887aabd4-5182-4a79-a87a-46d021e2142d\css.css

????.......??????4337??2011-12-06?10:58??51aspx_OnlineShoppingCart887aabd4-5182-4a79-a87a-46d021e2142d\Default.aspx

????.......???????614??2011-12-06?10:58??51aspx_OnlineShoppingCart887aabd4-5182-4a79-a87a-46d021e2142d\Default.aspx.cs

????.......???????449??2011-12-06?10:58??51aspx_OnlineShoppingCart887aabd4-5182-4a79-a87a-46d021e2142d\delproduct.aspx

????.......??????1139??2011-12-06?10:58??51aspx_OnlineShoppingCart887aabd4-5182-4a79-a87a-46d021e2142d\delproduct.aspx.cs

????.......??????4459??2011-12-06?10:58??51aspx_OnlineShoppingCart887aabd4-5182-4a79-a87a-46d021e2142d\editproduct.aspx

????.......??????3333??2011-12-06?10:58??51aspx_OnlineShoppingCart887aabd4-5182-4a79-a87a-46d021e2142d\editproduct.aspx.cs

????.......??????1552??2011-12-06?10:58??51aspx_OnlineShoppingCart887aabd4-5182-4a79-a87a-46d021e2142d\fenye.ascx

????.......??????3010??2011-12-06?10:58??51aspx_OnlineShoppingCart887aabd4-5182-4a79-a87a-46d021e2142d\fenye.ascx.cs

????.......??????1804??2011-12-06?10:58??51aspx_OnlineShoppingCart887aabd4-5182-4a79-a87a-46d021e2142d\fenye2.ascx

????.......??????3023??2011-12-06?10:58??51aspx_OnlineShoppingCart887aabd4-5182-4a79-a87a-46d021e2142d\fenye2.ascx.cs

????.......??????2013??2011-12-06?10:58??51aspx_OnlineShoppingCart887aabd4-5182-4a79-a87a-46d021e2142d\fenye3.ascx

????.......??????3023??2011-12-06?10:58??51aspx_OnlineShoppingCart887aabd4-5182-4a79-a87a-46d021e2142d\fenye3.ascx.cs

????.......???????732??2011-12-06?10:58??51aspx_OnlineShoppingCart887aabd4-5182-4a79-a87a-46d021e2142d\guanyu.aspx

............此處省略763個文件信息