B2C電子商務(wù)網(wǎng)站源代碼

1、綜合實(shí)訓(xùn)(課程設(shè)計(jì))項(xiàng)目 ASP.NET 專 業(yè)： 計(jì)算機(jī)應(yīng)用技術(shù) 課程名稱： ASP.NET 系 部： 計(jì)算機(jī)與信息工程系 班 級(jí)： 091311 指導(dǎo)教師： 高 祖 彥 完成時(shí)間： 2011-11-22 學(xué)生姓名： 談銳 學(xué) 號(hào)： 09131120 恩施職業(yè)技術(shù)學(xué)院學(xué)生綜合實(shí)訓(xùn)（課程設(shè)計(jì)）評(píng)分表學(xué)生姓名談銳專業(yè)計(jì)算機(jī)應(yīng)用班級(jí)091311課程名稱A綜合實(shí)訓(xùn)項(xiàng)目(課程設(shè)計(jì)題目)B2C完成時(shí)間2011-11-22實(shí)訓(xùn)總結(jié)（設(shè)計(jì)說(shuō)明）摘要通過這次實(shí)驗(yàn)我自己動(dòng)手用做了一個(gè)電子商務(wù)網(wǎng)站，在制作的過程中我學(xué)到了許多知識(shí)，為以后的工作打下良好的基礎(chǔ)。指導(dǎo)教師意見 指導(dǎo)教師簽字： 年 月 日 綜合實(shí)訓(xùn)（課程

2、設(shè)計(jì)）成績(jī)數(shù)據(jù)庫(kù)名：db_NetStore表名：sysdiagrams1序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵允許空默認(rèn)值說(shuō)明1namesysname2560否2principal_idint40否3diagram_idint40是是否4versionint40是5definitionvarbinaryMAX0是表名：tb_Admin序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵允許空默認(rèn)值說(shuō)明1AdminIDint40是是否2AdminNamevarchar500否3Passwordvarchar500否4RealNamevarchar500否5Emailvarchar500否6LoadDatedateti

3、me83否getdate表名：tb_BookInfo序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵允許空默認(rèn)值說(shuō)明1BookIDint40是是否2ClassIDint40否3BookNamevarchar500否4BookIntroducentext160否5Authorvarchar500否6Companyvarchar500否7BookUrlvarchar2000否8MarketPricefloat80否9HotPricefloat80否10Isrefinementbit10否11IsHotbit10否12IsDiscountbit10否13LoadDatedatetime83否getdate表名：t

4、b_Class序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵允許空默認(rèn)值說(shuō)明1ClassIDint40是是否2ClassNamevarchar500否3CategoryUrlvarchar500否表名：tb_Detail序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵允許空默認(rèn)值說(shuō)明1DetailIDint40是是否2BookIDint40否3Numint40否4OrderIDint40否5TotailPricefloat80否6Remarkvarchar2000是表名：tb_Image序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵允許空默認(rèn)值說(shuō)明1ImageIDint40是是否2ImageNamevarchar500否3Imag

5、eUrlvarchar2000否表名：tb_LeaveWord序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵允許空默認(rèn)值說(shuō)明1IDint40是是否2Uidnvarchar500否3Subjectnvarchar500否4Contentntext160是5DateTimedatetime83否6IPnvarchar200否表名：tb_Member序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵允許空默認(rèn)值說(shuō)明1MemberIDint40是是否2UserNamevarchar500否3Passwordvarchar500否4RealNamevarchar500否5Sexbit10否6Phonecodevarchar200否

6、7Emailvarchar500否8Addressvarchar2000否9PostCodechar100否10LoadDatedatetime83否getdate表名：tb_OrderInfo序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵允許空默認(rèn)值說(shuō)明1OrderIDint40是是否2OrderDatedatetime83否getdate3BooksFeefloat80否4ShipFeefloat80否5TotalPricefloat80否6ShipTypevarchar500否7ReceiverNamevarchar500否8ReceiverPhonevarchar200否9ReceiverPost

7、Codechar100否10ReceiverAddressvarchar2000否11ReceiverEmailvarchar500否12IsConfirmbit10否013IsSendbit10否014IsEndbit10否015AdminIDint40是16ConfirmTimedatetime83是表名：tb_Reply序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵允許空默認(rèn)值說(shuō)明1IDint40是是否2UNamenvarchar500是3Contentntext160是4DateTimedatetime83是5ReplyIDint40是6IPnvarchar200是using System;usi

8、ng System.Data;using System.Configuration;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;using System.Collections;public partial class _Default : Syst

9、em.Web.UI.Page CommonClass ccObj = new CommonClass(); GoodsClass gcObj = new GoodsClass(); protected void Page_Load(object sender, EventArgs e) if (!IsPostBack) RefineBind(); HotBind(); DiscountBind(); /綁定市場(chǎng)價(jià)格 public string GetVarMKP(string strMarketPrice) return ccObj.VarStr(strMarketPrice, 2); /綁定

10、熱賣價(jià)格 public string GetVarHot(string strHotPrice) return ccObj.VarStr(strHotPrice, 2); protected void RefineBind() gcObj.DLDeplayGI(1, this.dLRefine, "Refine"); protected void HotBind() gcObj.DLDeplayGI(3, this.dlHot, "Hot"); protected void DiscountBind() gcObj.DLDeplayGI(2, this.

11、dlDiscount, "Discount"); public void AddressBack(DataListCommandEventArgs e) Session"address" = "" Session"address" = "Default.aspx" Response.Redirect("/showInfo.aspx?id=" + Convert.ToInt32(e.CommandArgument.ToString(); protected void dLRef

12、ine_ItemCommand(object source, DataListCommandEventArgs e) if (e.CommandName = "detailSee") AddressBack(e); else if (e.CommandName = "buy") AddShopCart(e); protected void dlDiscount_ItemCommand(object source, DataListCommandEventArgs e) if (e.CommandName = "detailSee")

13、AddressBack(e); else if (e.CommandName = "buy") AddShopCart(e); protected void dlHot_ItemCommand(object source, DataListCommandEventArgs e) if (e.CommandName = "detailSee") AddressBack(e); else if (e.CommandName = "buy") AddShopCart(e); / <summary> / 向購(gòu)物車中添加新商品 /

14、</summary> / <param name="e"> / 獲取或設(shè)置可選參數(shù)， / 該參數(shù)與關(guān)聯(lián)的 CommandName / 一起被傳遞到 Command 事件。 / </param> public void AddShopCart(DataListCommandEventArgs e) Hashtable hashCar; if (Session"ShopCart" = null) /如果用戶沒有分配購(gòu)物車 hashCar = new Hashtable(); /新生成一個(gè) hashCar.Add(e.Com

15、mandArgument, 1); /添加一個(gè)商品 Session"ShopCart" = hashCar; /分配給用戶 else /用戶已經(jīng)有購(gòu)物車 hashCar = (Hashtable)Session"ShopCart"/得到購(gòu)物車的hash表 if (hashCar.Contains(e.CommandArgument)/購(gòu)物車中已有此商品，商品數(shù)量加1 int count = Convert.ToInt32(hashCare.CommandArgument.ToString();/得到該商品的數(shù)量 hashCare.CommandArgum

16、ent = (count + 1);/商品數(shù)量加1 else hashCar.Add(e.CommandArgument, 1);/如果沒有此商品，則新添加一個(gè)項(xiàng) protected void Button1_Click(object sender, EventArgs e) using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.We

17、b.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;public partial class Manage_Login : System.Web.UI.Page CommonClass ccObj = new CommonClass(); DBClass dbObj = new DBClass(); protected void Page_Load(object sender, EventArgs e) if

18、(!IsPostBack) this.labCode.Text =ccObj.RandomNum(4);/產(chǎn)生驗(yàn)證碼 protected void btnLogin_Click(object sender, EventArgs e) /判斷用戶是否已輸入了必要的信息 if (this.txtAdminName.Text.Trim() = "" | this.txtAdminPwd.Text.Trim() = "") Response.Write(ccObj.MessageBox("登錄名和密碼不能為空！"); else /判斷用戶輸入

19、的驗(yàn)證碼是否正確 if (txtAdminCode.Text.Trim() = labCode.Text.Trim() /定義一個(gè)字符串，獲取用戶信息 string strSql = "select * from tb_Admin where AdminName='"+this.txtAdminName.Text.Trim()+"' and Password='"+this.txtAdminPwd.Text.Trim()+"'" DataTable dsTable=dbObj.GetDataSetStr

20、(strSql, "tbAdmin"); if (dsTable.Rows.Count > 0) Session"AID" = Convert.ToInt32(dsTable.Rows00.ToString();/保存用戶ID Session"AName" = dsTable.Rows01.ToString();/保存用戶名 Response.Write("<script language=javascript>window.open('AdminIndex.aspx');window.cl

21、ose();</script>"); else Response.Write(ccObj.MessageBox("您輸入的用戶名或密碼錯(cuò)誤，請(qǐng)重新輸入！"); else Response.Write(ccObj.MessageBox("驗(yàn)證碼輸入有誤，請(qǐng)重新輸入！"); protected void btnCancel_Click(object sender, EventArgs e) Response.Write("<script>window.close();location='javascript

22、:history.go(-1)'</script>"); 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;usin

23、g System.Data.SqlClient;public partial class feedback : System.Web.UI.Page CommonClass ccObj = new CommonClass(); DBClass dbObj = new DBClass(); protected void Page_Load(object sender, EventArgs e) if (!IsPostBack) if (Session"UserName" = null) Response.Redirect("Default.aspx"); protected void btnOK_Click(object sender, EventArgs e) if (Session"UserName" = null) Response.Redirect("Default.aspx"); e