B2C电子商务网站源代码

综合实训(课程设计)项目ASP.NET专业：计算机应用技术课程名称：ASP.NET系部：计算机与信息工程系班级：091311指导教师：高祖彦完成时间：2011-11-22学生姓名：谈锐学号：09131120恩施职业技术学院学生综合实训（课程设计）评分表学生姓名谈锐专业计算机应用班级091311课程名称Asp.net综合实训项目(课程设计题目)B2C完成时间2011-11-22实训总结（设计说明）摘要通过这次实验我自己动手用asp.net做了一个电子商务网站，在制作的过程中我学到了许多知识，为以后的工作打下良好的基础。指导教师意见指导教师签字：年月日综合实训（课程设计）成绩数据库名：db_NetStore表名：sysdiagrams1序号列名数据类型长度小数位标识主键允许空默认值说明1namesysname2560否2principal_idint40否3diagram_idint40是是否4versionint40是5definitionvarbinaryMAX0是表名：tb_Admin序号列名数据类型长度小数位标识主键允许空默认值说明1AdminIDint40是是否2AdminNamevarchar500否3Passwordvarchar500否4RealNamevarchar500否5Emailvarchar500否6LoadDatedatetime83否getdate表名：tb_BookInfo序号列名数据类型长度小数位标识主键允许空默认值说明1BookIDint40是是否2ClassIDint40否3BookNamevarchar500否4BookIntroducentext160否5Authorvarchar500否6Companyvarchar500否7BookUrlvarchar2000否8MarketPricefloat80否9HotPricefloat80否10Isrefinementbit10否11IsHotbit10否12IsDiscountbit10否13LoadDatedatetime83否getdate表名：tb_Class序号列名数据类型长度小数位标识主键允许空默认值说明1ClassIDint40是是否2ClassNamevarchar500否3CategoryUrlvarchar500否表名：tb_Detail序号列名数据类型长度小数位标识主键允许空默认值说明1DetailIDint40是是否2BookIDint40否3Numint40否4OrderIDint40否5TotailPricefloat80否6Remarkvarchar2000是表名：tb_Image序号列名数据类型长度小数位标识主键允许空默认值说明1ImageIDint40是是否2ImageNamevarchar500否3ImageUrlvarchar2000否表名：tb_LeaveWord序号列名数据类型长度小数位标识主键允许空默认值说明1IDint40是是否2Uidnvarchar500否3Subjectnvarchar500否4Contentntext160是5DateTimedatetime83否6IPnvarchar200否表名：tb_Member序号列名数据类型长度小数位标识主键允许空默认值说明1MemberIDint40是是否2UserNamevarchar500否3Passwordvarchar500否4RealNamevarchar500否5Sexbit10否6Phonecodevarchar200否7Emailvarchar500否8Addressvarchar2000否9PostCodechar100否10LoadDatedatetime83否getdate表名：tb_OrderInfo序号列名数据类型长度小数位标识主键允许空默认值说明1OrderIDint40是是否2OrderDatedatetime83否getdate3BooksFeefloat80否4ShipFeefloat80否5TotalPricefloat80否6ShipTypevarchar500否7ReceiverNamevarchar500否8ReceiverPhonevarchar200否9ReceiverPostCodechar100否10ReceiverAddressvarchar2000否11ReceiverEmailvarchar500否12IsConfirmbit10否013IsSendbit10否014IsEndbit10否015AdminIDint40是16ConfirmTimedatetime83是表名：tb_Reply序号列名数据类型长度小数位标识主键允许空默认值说明1IDint40是是否2UNamenvarchar500是3Contentntext160是4DateTimedatetime83是5ReplyIDint40是6IPnvarchar200是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;usingSystem.Collections;publicpartialclass_Default:System.Web.UI.Page{CommonClassccObj=newCommonClass();GoodsClassgcObj=newGoodsClass();protectedvoidPage_Load(objectsender,EventArgse){if(!IsPostBack){RefineBind();HotBind();DiscountBind();}}//绑定市场价格publicstringGetVarMKP(stringstrMarketPrice){returnccObj.VarStr(strMarketPrice,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.dlDiscount,Discount);}publicvoidAddressBack(DataListCommandEventArgse){Session[address]=;Session[address]=Default.aspx;Response.Redirect(~/showInfo.aspx?id=+Convert.ToInt32(e.CommandArgument.ToString()));}protectedvoiddLRefine_ItemCommand(objectsource,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==buy){AddShopCart(e);}}protectedvoiddlHot_ItemCommand(objectsource,DataListCommandEventArgse){if(e.CommandName==detailSee){AddressBack(e);}elseif(e.CommandName==buy){AddShopCart(e);}}///summary///向购物车中添加新商品////summary///paramname=e///获取或设置可选参数，///该参数与关联的CommandName///一起被传递到Command事件。////parampublicvoidAddShopCart(DataListCommandEventArgse){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))//购物车中已有此商品，商品数量加1{intcount=Convert.ToInt32(hashCar[e.CommandArgument].ToString());//得到该商品的数量hashCar[e.CommandArgument]=(count+1);//商品数量加1}elsehashCar.Add(e.CommandArgument,1);//如果没有此商品，则新添加一个项}}protectedvoidButton1_Click(objectsender,EventArgse){}}usingSystem;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;publicpartialclassManage_Login:System.Web.UI.Page{CommonClassccObj=newCommonClass();DBClassdbObj=newDBClass();protectedvoidPage_Load(objectsender,EventArgse){if(!IsPostBack){this.labCode.Text=ccObj.RandomNum(4);//产生验证码}}protectedvoidbtnLogin_Click(objectsender,EventArgse){//判断用户是否已输入了必要的信息if(this.txtAdminName.Text.Trim()==||this.txtAdminPwd.Text.Trim()==){Response.Write(ccObj.MessageBox(登录名和密码不能为空！));}else{//判断用户输入的验证码是否正确if(txtAdminCode.Text.Tr