B2C电子商务网站源代码

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

2、diagrams1序号列名数据类型长度小数位标识主键允许空默认值说明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_Leave

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

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

7、svarchar2000否11ReceiverEmailvarchar500否12IsConfirmbit10否013IsSendbit10否014IsEndbit10否015AdminIDint40是16ConfirmTimedatetime83是表名：tb_Reply序号列名数据类型长度小数位标识主键允许空默认值说明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();/绑定市场价格publicstringGetVarMKP(stringstrMarketPrice)(returnccObj.VarStr(strMarketPrice,2);/绑定热卖价格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">/获取或设置可选参数，/该参数与关联的CommandName/一起被传递到Command事件。/</param>publicvoidAddShopCart(DataListComman

14、dEventArgse)(HashtablehashCar;if(Session"ShopCart"=null)(/如果用户没有分配购物车hashCar=newHashtable();新生成一个hashCar.Add(e.CommandArgument,1);/添加一个商品Session"ShopCart"=hashCar;/分配给用户else(/用户已经有购物车hashCar=(Hashtable)Session"ShopCart"得到购物车的hash表if(hashCar.Contains(e.CommandArgument)/购

15、物车中已有此商品，商品数量加1(intcount=Convert.ToInt32(hashCare.CommandArgument.ToString();/得到该商品的数量/商品数hashCare.CommandArgument=(count+1);量加1)elsehashCar.Add(e.CommandArgument,1);如果没有此商品，则新添加一个项)protectedvoidButton1_Click(objectsender,EventArgse)()usingSystem;明日科技中天至圳11年11月乳日审：圣I强主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);/产生验证码protectedvoidbtnLogin_Click(objectsender,EventArgse)/判断用户是否已输入了必要的信息if(this.txtAdminName.Text.Trim

18、()=""|this.txtAdminPwd.Text.Trim()="")(Response.Write(ccObj.MessageBox("登录名和密码不能为空!");else(/判断用户输入的验证码是否正确if(txtAdminCode.Text.Trim()=labCode.Text.Trim()(定义一个字符串，获取用户信息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("验证码输入有误，请重新输入！")；protectedvoidbtnCancel_Click(objectsender,EventAr

21、gse)Response.Write("<script>window.close();location='javascript:history.go(-1)'</script>");里；笔阻I出主0I电中天至隼11月制日fewI黜3I两站田宣.雌曾百|遣出目*萧页I野品上市I福黑推荐1*»耕需品F喃扉4毋已晕中U51Am*一出圜i町”Hi母18:52T博控恃：K¥4说inftn：mtE隼邪更阻勺I宝餐ns/廿：i11SIEW：t1!*SEW：II苒身块口词日玄芸町国书管查会员代号真实姓名电话号码台员Eail详细电址

22、曲羯号吗加入日期数据辨11年数据绑定数据绑定数据绑定数据绑定毅据绑定数语绑定晦数据绑定数据绑定数据螂定数据绑定数据绑定数据绑定数据纲定»数据绑J1数据绑定数据螂定数据绑定数据绑定数据绑定数据排走幅数据绑a,数据绑定数据绑定数据绑定数据绑定数据绑定数据绑定映数引数据绑定数据螂定数据螂定数据绑定苞据螂定融据第定i2明日科技今天星.2011年”月力9F58WI玄MmsaI我的留言lift出登求营费IW品上市I糟品推君!?价品!4套已空量，木(!安出白。位量：页：皿王序号书1会名口Bit©£做I19K5TI箕V堂V也2I7九1讣，舞或按京在1箕V灾VffaJ8疗衣18V8

23、VMi吩注丁一王一一.>1£军”?m要/要*得息il«£6”明日科技今天星.2。11年11月勿9F58W1«1»I玄JBM|2«msaI我的留言lift出登求营费IW品上市I糟品推君!?价品!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