B2C电子商务网站源代码

1、综合实训（课程设计）项目ASP.NET专业:计算机应用技术课程名称:ASP.NET系部:计算机与信息工程系班级:091311指导教师:高祖彦完成时间:2011-11-22学生姓名:谈锐号:09131120恩施职业技术学院学生综合实训（课程设计）评分表学生姓名谈锐专业计算机应用班级091311课程名称A综合实训项目（课程设计题目）B2C完成时间2011-11-22实训总结（设计说明）摘要通过这次实验我自己动手用做了一个电子商务网站，在制作的过程中我学到了许多知识，为以后的工作打下良好的基础0指导教师意见指导教师签字：年月日珠合实训（课程设计）成绩数据库名：db_NetStore表名：sysdia

2、grams1序号列名数据类型长度小数位标识主键允许空默认值说明1namesysname2560否2principal_idint40否3diagram_idint40是是否4versionint40是5definitionvarbinaryMAX0是表名：tb_Admin序号列名数据类型长度小数位标识主键允许空默认值说明1AdminIDint40是是否2AdminNamevarchar500否3Passwordvarchar500否4RealNamevarchar500否5Emailvarchar500否6LoadDatedatetime83否getdate表名：tb_BookInfo序号列名

3、数据类型长度小数位标识主键允许空默认值说明1BookIDint40是是否2ClassIDint40否3BookNamevarchar500否4BookIntroducentext160否5Authorvarchar500否6Companyvarchar500否7BookUrlvarchar2000否8MarketPricefloat80否9HotPricefloat80否10Isrefinementbit10否11IsHotbit10否12IsDiscountbit10否13LoadDatedatetime83否getdate表名：tb_Class序号列名数据类型长度小数位标识主键允许空默认值

4、说明1ClassIDint40是是否2ClassNamevarchar500否3CategoryUrlvarchar500否表名：tb_Detail序号列名数据类型长度小数位标识主键允许空默认值说明1DetailIDint40是是否2BookIDint40否3Numint40否4OrderIDint40否5TotailPricefloat80否6Remarkvarchar2000是表名：tb_Image序号列名数据类型长度小数位标识主键允许空默认值说明1ImageIDint40是是否2ImageNamevarchar500否3ImageUrlvarchar2000否表名：tb_LeaveWor

5、d序号列名数据类型长度小数位标识主键允许空默认值说明1IDint40是是否2Uidnvarchar500否3Subjectnvarchar500否4Contentntext160是5DateTimedatetime83否6IPnvarchar200否表名：tb_Member序号列名数据类型长度小数位标识主键允许空默认值说明1MemberIDint40是是否2UserNamevarchar500否3Passwordvarchar500否4RealNamevarchar500否5Sexbit10否6Phonecodevarchar200否7Emailvarchar500否8Addressvarch

6、ar2000否9PostCodechar100否10LoadDatedatetime83否getdate表名：tb_OrderInfo序号列名数据类型长度小数位标识主键允许空默认值说明1OrderIDint40是是否2OrderDatedatetime83否getdate3BooksFeefloat80否4ShipFeefloat80否5TotalPricefloat80否6ShipTypevarchar500否7ReceiverNamevarchar500否8ReceiverPhonevarchar200否9ReceiverPostCodechar100否10ReceiverAddressv

7、archar2000否11ReceiverEmailvarchar500否12IsConfirmbit10否013IsSendbit10否014IsEndbit10否015AdminIDint40是16ConfirmTimedatetime83是表名：tb_Reply序号列名数据类型长度小数位标识主键允许空默认值说明1IDint40是是否2UNamenvarchar500是3Contentntext160是4DateTimedatetime83是5ReplyIDint40是6IPnvarchar200是明日科技m5wtwmvIRH前言llr：S5liSth量Kft.SHtt«tfl?

8、t9有烫I>a±*rf精呈拷节1f希息I*«<£usingSystem;usingSystem.Data;usingSystem.Configuration;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.WebControls.WebParts;usingSystem.Web.UI.HtmlControls;usingSystem.Data.SqlClient;usingSyste

9、m.Collections;publicpartialclass_Default:System.Web.UI.PageCommonClassccObj=newCommonClass();GoodsClassgcObj=newGoodsClass();protectedvoidPage_Load(objectsender,EventArgse)if(!IsPostBack)RefineBind();HotBind();DiscountBind();/绑定市场价格publicstringGetVarMKP(stringstrMarketPrice)(returnccObj.VarStr(strMa

10、rketPrice,2);/绑定热卖价格publicstringGetVarHot(stringstrHotPrice)(returnccObj.VarStr(strHotPrice,2);protectedvoidRefineBind()(gcObj.DLDeplayGI(1,this.dLRefine,"Refine");protectedvoidHotBind()(gcObj.DLDeplayGI(3,this.dlHot,"Hot");protectedvoidDiscountBind()(gcObj.DLDeplayGI(2,this.dlDi

11、scount,"Discount");publicvoidAddressBack(DataListCommandEventArgse)(Session"address"=""Session"address"="Default.aspx"Response.Redirect("/showInfo.aspx?id="+Convert.ToInt32(e.CommandArgument.ToString();protectedvoiddLRefine_ItemCommand(obje

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

13、;buy")(AddShopCart(e);protectedvoiddlHot_ItemCommand(objectsource,DataListCommandEventArgse)(if(e.CommandName="detailSee")(AddressBack(e);elseif(e.CommandName="buy")(AddShopCart(e);/<summary>/向购物车中添加新商品/</summary>/<paramname="e">/获取或设置可选参数，/该参数与关联

14、的CommandName/一起被传递到Command事件。/</param>publicvoidAddShopCart(DataListCommandEventArgse)(HashtablehashCar;if(Session"ShopCart"=null)(/如果用户没有分配购物车hashCar=newHashtable();/新生成一个hashCar.Add(e.CommandArgument,1);/添加一个商品Session"ShopCart"=hashCar;/分配给用户else(/用户已经有购物车hashCar=(Hashtab

15、le)Session"ShopCart"/hash表if(hashCar.Contains(e.CommandArgument)/商品，商品数量加1intcount=Convert.ToInt32(hashCare.CommandArgument.ToString();/数量得到购物车的购物车中已有此得到该冏品的hashCare.CommandArgument=(count+1);/elsehashCar.Add(e.CommandArgument,新添加一个项protectedvoidButton1_Click(objectsender,EventArgse)商品数量加1

16、1);/如果没有此商品，则明日科技币*i：5砌竹：%if!5injkin:附IMtn?w的nip吵胸j同盹鬟lit如mir&lHl；5MMIW)MYHt5'.RjrusingSystem;usingSystem.Data;usingSystem.Configuration;usingSystem.Collections;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.Ul.WebControls;usingSystem.Web.Ul.WebControls.WebParts;

17、usingSystem.Web.UI.HtmlControls;usingSystem.Data.SqlClient;publicpartialclassManage_Login:System.Web.UI.PageCommonClassccObj=newCommonClass();DBClassdbObj=newDBClass();protectedvoidPage_Load(objectsender,EventArgse)if(!IsPostBack)this.labCode.Text=ccObj.RandomNum(4);/产生验证码protectedvoidbtnLogin_Click

18、(objectsender,EventArgse)/判断用户是否已输入了必要的信息if(this.txtAdminName.Text.Trim()=""|this.txtAdminPwd.Text.Trim()="")Response.Write(ccObj.MessageBox("登录名和密码不能为空!");else/判断用户输入的验证码是否正确if(txtAdminCode.Text.Trim()=labCode.Text.Trim()/定义一个字符申，获取用户信息stringstrSql="select*fromtb_

19、AdminwhereAdminName="'+this.txtAdminName.Text.Trim()+"'andPassword='"+this.txtAdminPwd.Text.Trim()+""'DataTabledsTable=dbObj.GetDataSetStr(strSql,"tbAdmin");if(dsTable.Rows.Count>0)Session"AID"=Convert.ToInt32(dsTable.Rows00.ToString();

20、/保存用户IDSession"AName"=dsTable.Rows01.ToString();/保存用户名Response.Write("<scriptlanguage=javascript>window.open('AdminIndex.aspx');window.close();</script>");else(Response.Write(ccObj.MessageBox("您输入的用户名或密码错误，请重新输入！");else(Response.Write(ccObj.MessageBo

21、x("验证码输入有误，请重新输入！")；protectedvoidbtnCancel_Click(objectsender,EventArgse)Response.Write("<script>window.close();location='javascript:history.go(-1)'</script>");*j祢富言国瞬言曜出金蒙号天电5俸n句堂目首史!上市fiwaw1wrwfi1热m配|fiKMA-|管理合暴代号真实始8WS号玛瓮员版或1详蝴培虻JUA0M定葡麾携定教蹇燃定期矜弟定W'数霓甥定

22、散搏蚱章振蜩定数帼绷定徼融定笋括靖Mtm数真崩定割据晌熟指蜩云数序辑宕数基察定前塞绡迫业数鹭1却帷殊福却炳正w教融警耗哦宏翠梏瞄j：'豹推镯市桐括电导删原上考EH|>物旬明日藕技卷壬*,夺心1网？（白ft衅MMttJIWWS匝出量霁甘夏I新身上啊F精!W*B1弗g是口*-篇*|5anes；t?、触好flF<+Wra>书何tt#曾JfeiRI阳<MF£FrA3EJHZ*1心Em£iiitziqUf.>CD仙1«TSTUr,j&WW»A13W,*aawiBtfliJtBMPSJ,az!fr*r>u±

23、;-Tw*m£a%c»fc-R»i»riUie，<,r/.nwizJ!林史拈*=耕标魄回玷宙芝I快廿与言圈出量:菜为声I新身上*rF精Sff节!WflB1誓Z呈EgfflMWW乎乓云E坦affaiisr,W4S-今毛息¥11琴1网7!白»&»¥H*VlbW1"三吏Xt括推林a!*宙莒1熟扣朝吉I匹出旦弟首宴|新呈上啊!精皇1S节!f宣用I炯嘛臣usingSystem;usingSystem.Data;usingSystem.Configuration;usingSystem.Collecti

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