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

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

2、diagrams1序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵允許空默認(rèn)值說明1namesysname2560否2principal_idint40否3diagram_idint40是是否4versionint40是5definitionvarbinaryMAX0是表名：tb_Admin序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵允許空默認(rèn)值說明1AdminIDint40是是否2AdminNamevarchar500否3Passwordvarchar500否4RealNamevarchar500否5Emailvarchar500否6LoadDatedatetime83否getdate表名：tb_BookInfo序

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

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

5、Word序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵允許空默認(rèn)值說明1IDint40是是否2Uidnvarchar500否3Subjectnvarchar500否4Contentntext160是5DateTimedatetime83否6IPnvarchar200否表名：tb_Member序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵允許空默認(rèn)值說明1MemberIDint40是是否2UserNamevarchar500否3Passwordvarchar500否4RealNamevarchar500否5Sexbit10否6Phonecodevarchar200否7Emailvarchar500否8Addressva

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

7、svarchar2000否11ReceiverEmailvarchar500否12IsConfirmbit10否013IsSendbit10否014IsEndbit10否015AdminIDint40是16ConfirmTimedatetime83是表名：tb_Reply序號列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識主鍵允許空默認(rèn)值說明1IDint40是是否2UNamenvarchar500是3Contentntext160是4DateTimedatetime83是5ReplyIDint40是6IPnvarchar200是usingSystem;usingSystem.Data;usingSystem.Con

8、figuration;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.WebControls.WebParts;usingSystem.Web.UI.HtmlControls;usingSystem.Data.SqlClient;usingSystem.Collections;publicpartialclass_Default:System.Web.UI.PageCommonClassccObj=newCommonClas

9、s();GoodsClassgcObj=newGoodsClass();protectedvoidPage_Load(objectsender,EventArgse)(if(!IsPostBack)(RefineBind();HotBind();DiscountBind();/綁定市場價(jià)格publicstringGetVarMKP(stringstrMarketPrice)(returnccObj.VarStr(strMarketPrice,2);/綁定熱賣價(jià)格publicstringGetVarHot(stringstrHotPrice)(returnccObj.VarStr(strHotP

10、rice,2);protectedvoidRefineBind()gcObj.DLDeplayGI(1,this.dLRefine,"Refine");)protectedvoidHotBind()(gcObj.DLDeplayGI(3,this.dlHot,"Hot");)protectedvoidDiscountBind()(gcObj.DLDeplayGI(2,this.dlDiscount,"Discount");)e)publicvoidAddressBack(DataListCommandEventArgs(Session

11、"address"=""Session"address"="Default.aspx"Response.Redirect("/showInfo.aspx?id="+Convert.ToInt32(e.CommandArgument.ToString();)protectedvoiddLRefine_ItemCommand(objectsource,DataListCommandEventArgse)(if(e.CommandName="detailSee")(AddressB

12、ack(e);)elseif(e.CommandName="buy")(AddShopCart(e);)protectedvoiddlDiscount_ItemCommand(objectsource,DataListCommandEventArgse)(if(e.CommandName="detailSee")(AddressBack(e);)elseif(e.CommandName="buy")(AddShopCart(e);)protectedvoiddlHot_ItemCommand(objectsource,DataList

13、CommandEventArgse)if(e.CommandName="detailSee")AddressBack(e);)elseif(e.CommandName="buy")AddShopCart(e);)/<summary>/向購物車中添加新商品/</summary>/<paramname="e">/獲取或設(shè)置可選參數(shù)，/該參數(shù)與關(guān)聯(lián)的CommandName/一起被傳遞到Command事件。/</param>publicvoidAddShopCart(DataListComman

14、dEventArgse)(HashtablehashCar;if(Session"ShopCart"=null)(/如果用戶沒有分配購物車hashCar=newHashtable();新生成一個(gè)hashCar.Add(e.CommandArgument,1);/添加一個(gè)商品Session"ShopCart"=hashCar;/分配給用戶else(/用戶已經(jīng)有購物車hashCar=(Hashtable)Session"ShopCart"得到購物車的hash表if(hashCar.Contains(e.CommandArgument)/購

15、物車中已有此商品，商品數(shù)量加1(intcount=Convert.ToInt32(hashCare.CommandArgument.ToString();/得到該商品的數(shù)量/商品數(shù)hashCare.CommandArgument=(count+1);量加1)elsehashCar.Add(e.CommandArgument,1);如果沒有此商品，則新添加一個(gè)項(xiàng))protectedvoidButton1_Click(objectsender,EventArgse)()usingSystem;明日科技中天至圳11年11月乳日審：圣I強(qiáng)主HI如W2阿aI兩站田富一觸曾言1謖出息*苜頁I爵品上市I精懸

16、推尊1峙僑用品F糊fl需盡玄蕓町的粗IHMA超的麻品l.ni-usingSystem.Data;usingSystem.Configuration;usingSystem.Collections;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.WebControls.WebParts;usingSystem.Web.UI.HtmlControls;usingSystem.Data.SqlClient;publicpartia

17、lclassManage_Login:System.Web.UI.PageCommonClassccObj=newCommonClass();DBClassdbObj=newDBClass();protectedvoidPage_Load(objectsender,EventArgse)if(!IsPostBack)this.labCode.Text=ccObj.RandomNum(4);/產(chǎn)生驗(yàn)證碼protectedvoidbtnLogin_Click(objectsender,EventArgse)/判斷用戶是否已輸入了必要的信息if(this.txtAdminName.Text.Trim

18、()=""|this.txtAdminPwd.Text.Trim()="")(Response.Write(ccObj.MessageBox("登錄名和密碼不能為空!");else(/判斷用戶輸入的驗(yàn)證碼是否正確if(txtAdminCode.Text.Trim()=labCode.Text.Trim()(定義一個(gè)字符串，獲取用戶信息stringstrSql="select*fromtb_AdminwhereAdminName='"+this.txtAdminName.Text.Trim()+"&

19、#39;andPassword"+this.txtAdminPwd.Text.Trim()+""'DataTabledsTable=dbObj.GetDataSetStr(strSql,"tbAdmin");if(dsTable.Rows.Count>0)Session"AID"=Convert.ToInt32(dsTable.Rows00.ToString();/保存用戶IDSession"AName"=dsTable.Rows01.ToString();/保存用戶名Response.Wr

20、ite("<scriptlanguage=javascript>window.open('AdminIndex.aspx');window.close();</script");else(Response.Write(ccObj.MessageBox("您輸入的用戶名或密碼錯誤，請重新輸入！");else(Response.Write(ccObj.MessageBox("驗(yàn)證碼輸入有誤，請重新輸入！")；protectedvoidbtnCancel_Click(objectsender,EventAr

21、gse)Response.Write("<script>window.close();location='javascript:history.go(-1)'</script>");里；筆阻I出主0I電中天至隼11月制日fewI黜3I兩站田宣.雌曾百|(zhì)遣出目*蕭頁I野品上市I福黑推薦1*»耕需品F喃扉4毋已暈中U51Am*一出圜i町”Hi母18:52T博控恃：K¥4說inftn：mtE隼邪更阻勺I寶餐ns/廿：i11SIEW：t1!*SEW：II苒身塊口詞日玄蕓町國書管查會員代號真實(shí)姓名電話號碼臺員Eail詳細(xì)電址

22、曲羯號嗎加入日期數(shù)據(jù)辨11年數(shù)據(jù)綁定數(shù)據(jù)綁定數(shù)據(jù)綁定數(shù)據(jù)綁定毅據(jù)綁定數(shù)語綁定晦數(shù)據(jù)綁定數(shù)據(jù)綁定數(shù)據(jù)螂定數(shù)據(jù)綁定數(shù)據(jù)綁定數(shù)據(jù)綁定數(shù)據(jù)綱定»數(shù)據(jù)綁J1數(shù)據(jù)綁定數(shù)據(jù)螂定數(shù)據(jù)綁定數(shù)據(jù)綁定數(shù)據(jù)綁定數(shù)據(jù)排走幅數(shù)據(jù)綁a,數(shù)據(jù)綁定數(shù)據(jù)綁定數(shù)據(jù)綁定數(shù)據(jù)綁定數(shù)據(jù)綁定數(shù)據(jù)綁定映數(shù)引數(shù)據(jù)綁定數(shù)據(jù)螂定數(shù)據(jù)螂定數(shù)據(jù)綁定苞據(jù)螂定融據(jù)第定i2明日科技今天星.2011年”月力9F58WI玄MmsaI我的留言lift出登求營費(fèi)IW品上市I糟品推君!?價(jià)品!4套已空量，木(!安出白。位量：頁：皿王序號書1會名口Bit©£做I19K5TI箕V堂V也2I7九1訃，舞或按京在1箕V災(zāi)VffaJ8療衣18V8

23、VMi吩注丁一王一一.>1£軍”?m要/要*得息il«£6”明日科技今天星.2。11年11月勿9F58W1«1»I玄JBM|2«msaI我的留言lift出登求營費(fèi)IW品上市I糟品推君!?價(jià)品!4套已空量，Hare“>ewwri：布工的“T打.癖假貨人貨0M法基gftRCW?在磔fgf球H-W牝砂的物明usingSystem;usingSystem.Data;usingSystem.Configuration;usingSystem.Collections;usingSystem.Web;usingSystem.Web.Se

24、curity;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.WebControls.WebParts;usingSystem.Web.UI.HtmlControls;usingSystem.Data.SqlClient;publicpartialclassfeedback:System.Web.UI.PageCommonClassccObj=newCommonClass();DBClassdbObj=newDBClass();protectedvoidPage_Load(objectsender,EventArgse)(if(!IsPostBack)(if(Session"UserName"=null)(Response.Redirect("Default.aspx");protectedvoi