购物商城实训报告模版

1、那州较工曲曇院实训报告实训名称：网上商城系统开发姓名：高耀威院（系）：软件学院专业班级：计算及应用技术10-01学号：621013520107指导教师：李祖贺、范乃梅成绩：时间：2011年12月19日至 2012年1月 6 02错误!未定义书签。324系统简介 系统设计的思路和整体框架 各功能或者模块实现的思路 实训感想系统简介1）系统设计概述网上商城系统的模块示意图网上商城购物系坑公告管理商品管理订单管理投诉管理系统管理网上商城系统可以分为前台管理和后天管理系统。包括用户管理、商品浏览、商 品管理、管理员信息管理、购物车管理、订单管理、用户资金管理及销售量查询 管理等八个模块。2）功能划分前

2、台功能：商品浏览、购物车管理、用户注册、查询商品、查询管理个人信息、购 物记录等等。后台功能：系统管理、商品管理、订单管理、用户管理、系统维护、销售量查询、 用户资金管理等等。3）数据库需求分析数据库的设计通常是以一个已经存在的数据库管理系统为基础的，常用的数 据库管理系统有sql scrvcto整个系统功能需要以下数据项：商品：商品名称、单价、数量、同类商品管理员：管理名名称、管理员密码、管理员级别。用户：账号、密码。4）系统需求分析此系统基于asp的购物网站分前台功能各后台管理功能：前台部分由用户使用，主要包括用户注册，购买商品，查询商品，浏览商品。后台管理部分由管理员使用，主要包括商品管

3、理，品牌管理，销售统计管理，商 品信息修改管理。各功能或者模块实现的思路丄日字管理动作提作时冋5登录2010-7-21 9:28:175登录2010-7-21 9:28:325登录2010-7-21 9:37:155登录2010-7-21 9:48:235查看菅理员列表2010-7-21 9:48:295查看用尸列表2010-7-21 9:48:325查看当曰销售记录2010-7-21 9:48:335查看商品列表2010-7-21 9:48:345查看商品列表2010-7-21 9:48:435注销2010-7-21 9:48:51/页面初始方法if (!page. ispostback)s

4、howo ;if (request. querystringeadminld != nul1)admindb. insertact ion (，z査看adminld为"+ request. querystring，zadminid，z + "的日志,system. datetime. now, user. identity. name) ;protected void showoadmindb getaction=new admindbo;gridaction. dtilcisource =getaction. gctaction(convert. tostring(use

5、r idcnlily. name);gridaction. databindo :protected void gridactionpagelndexchanging(object source,system. web. ut. webcontrols. gridviewpageeventargs e)/gridvi ew控件分页事件int rowscont- gridaction. rows .count;if (rowscont = 0)gridaction. vis让le = false;response. write(v<script>alert (' 无暂无记录!

6、')/script")；)elsegridaction. pagelndex = c. newpagelndcx;show() ;l添加管理员管理员密码:确认密码：管理员权限:新増管理员protected voidpageload (object sender, eventargs e)页面初始方法辻(！page. ispostback)listbindo ;protected void listbindolistrole. datasource 二 admindb. getadminrolelist();list role. dcitatextfield 二"ro

7、lename"listrole. datavaluefield = "roleld"li strol e. databind () ;protected void add_click(object sender, system.eventargs e)/添加按钮点击事件admindb addcidmin 二 new admindb();int result= addadmin. addnewadmin(loginname .texttostring(),password text tostringo, int parse(listrole selectedvalu

8、e);switch(result)case -1:myerror. text ="用户名已存在!"break;case 1:/ response. write ("script 1 anguage=javascri pt>alert ('添加成功!')/script"); myerror. text ="添加成功！ ”； break;default : myerror. text ="出现错误！ "；break;a添加商品类别protected void pageload (object sender,

9、 eventargs e) /页面初始方法if (!page. ispostback)listcatbind():protected void ijstcatbindolistcat datasource= product getcategorylist();listcat. datdtoxtfield = categoryname;listcat. datavaluefield = "categorytd"listcat. databind ();protected void add_click(object sender, systemevenlargs e)/添加按钮

10、点击事件bool flag = true ;admi ndb ad = new admindb();for (int i = 0; i < listcat. items. count; i+)if (listcat itemsi text 二二converl. tostring(categoryntime text trimo) flag二false;if (!flag)response. write ("script 1 anguage=javascr i pt> window, alert 该类型己存在!')</script>");els

11、etry(ad addnewcategory(convert. tostri ng(categoryname text);myerror. text ="添加成功!"catchresponse wtite("sctipl language二javascript window.alcn('出错了 !')/script")；myerror. text 二"添加失败！ "admindb. tnsertaction (，z添加新的商品类别"+ categoryname. text. trim(),system. da

12、tetime now, user identity name);listcatbindo:protected void delete_click(object sender, systemevenlargs e)/删除按钮点击事件admindb delcy = new admindb();int a = int. parse(listcat. selectedvalue);int result二dolcy. checkcatcgoryuscd(a);tryswitch (result)case 0:delcy. deletecategory(a);myerror. text ="删除

13、成功！ ”; break;case 1:myerror. text二"此商品类别己被引用，不能删除"；break;default: admindb. tnsertactionc删除商品类别"+ listcat. selectcdttem. text,system. datetime. now， user tdentity name);break;catchmyerror. text ="删除失败！ ”;throw;listcatbindo ；4-添加冏品新增商品商品类型:音响家电v添加protected void page_load(object sen

14、der, eventargs e)/页而初始方法if (!page. ispostback)listceit.datasource 二 product getcategorylist ();listcat datatextfield = ，zcategoryname"listcat dnteivaluofield = ，/categorytd/，:listcat. databindo ：)protected void add_click (object sender, system. eventargs c)/添加按钮点击事件admindb eiddproduct = new adm

15、indbo ;tryaddproduct addnewproduct(productname text tostring(),convert. todecimal (price. text), tntro. text. tostringo, int. parse(listcat. selectedvalue):)catchmyerror.text二"添加失败! "a管理员列表管理员列表eventargs e)/页面初始方法if (!page. tspostback)gridbindo ;admindb. inscrtactionc查看管理员列表"，system.

16、datetime. now,user 1dentity name);)protected void gridbindoadmindb ad = new admindbo ;string admintd = convert. tostring(user tdentityname);/ sqldatareader reader = adgetadminlist(adgetadminrole(adminld); gridadmin. datasource= ad. getadminlist(int parse(ad getadminrole(adminld); gridadmin. databind

17、o ;protected void gridadmin_rowdoleting(object source,system. web. ul. webcontrols. gr i dv i ewdelet eeven t args e)/gr i dv i ew控件行删除事件admindb ad = new admindbo ;for(int i=0;igridadmin. rows. count;i+)if (i = c.rowindex)if(convert. tostring(gridadmin. datakeysi value) !=convert tostring(user ident

18、ity name) ad. deleteadmin(convert. tostring(gridadmin. datakeysi. value);admindb. insertactionc，删除管理员，admintd为"+gridadmi n datakeyse i value tostringo, system datotimc now, use r. i dentil y. name); else response. write(z/<script>alert ('此为当前登录用户不能能删除？')</script>，z);/ad. del

19、cteadmin(convert. tostring(gridadmin. datakeysi. value);gridbindo ;protected void gridadmin_page1ndexchanging(object sender, gridviewpageeventargs e) gridadmin. pagetndex = e. newpagetndex;gridbindo ; l修改密码更改管理员密码确定protected voidsubniit_click (object sender, system eventargs e)/提交按钮点击事件admindb chang

20、epwd = new admindbo ;int rcsult=changcpwdchangopwd(user identityname, oldpassword.text, newpassword text);if (result = 0)message. text ="密码不对！ ”；elseif (result = 1)admindb. insertactionc修改密码",system. datetime. now, user. identity. name);message. text ="修改成功！")elsemessage. text =&

21、quot;修改失败! ”;丄商品列表xeml.uirooo:eu ttt ox:e 1. u u 耳刃j段(牛pg毎新版°20windows xr rrofeesional1800235012-41 pnnn201 2000tol- d i 1 oo (1 2bfv1b三 rzktec1 200t5w：5&/kx/eratec 6200濟尔皿hti3212x女上玉里判：決32 : hn匸ul.pun匸：t m、由上丁里菁主1f»<=nt xt-im 4 m、如：予5? x於主, w? < mm» ) : 2 ooo1 sezj1ooootjen

22、o joybookt>uuun (ccj1oooo| 9900夕上于里钳決32 2 intel f*c rat- x vuro q m、虫.卜承呼 g生如*里却洪h |丄resnt xiaxn 今 m、si上mse主qlprotected void page_load(object sender, eventargs e) /页而初始方法if (!page. ispostback)gridproductvisible = true;gridbindo ;admindb. tnsertaction(/z查看商品列表",system. datetime. now,user. ide

23、ntity. name);protected void gridbindoadmindb ad = new admindb();gridproduct datasource= ad.getal 1 product();gridproduct. databindo ;protected void submit_click(object sender, systemevenlargs e)提交按钮点击事件admindb ad = new admi ndb();for (int i = 0： i < gridproduct. rows. count; i+)int productld = co

24、nvert tolnt32(gridproductdeitakeysivalue tostringo); string productname =(textbox)gridproduct. rowsi, findcontrol ("productname"). text. trim();decimal price =decimal. parse(textbox)gridproduct. rowsi. findcontrol ("price"). text. trim();string intro = (textbox)gridproduct. rowsi

25、. findcontrol c'tntro). text;checkbox remove 二(checkbox)gridproduct. rowsi. findcontrol("remove");tryif (remove. checked)if (ad.checkproductused(producttd) = 0)ad. deleteproduct(producttd);admindb. insertactionc删除商品"+ productnamo,system daletime now, user identity name);message. t

26、ext ="编号为"+ product id. tostringo + "的商品已被删除! elsemessage. text ="编号为"+ producttd. tostringo +"的商品己被选购,不 能被删除！ ”；response. write (/<script>alert (' a该商品已被选购,不能被删除！')</script>");)elsecid al terproduct (productld, productneime, price, intro);admin

27、db. insertaction c 修改商品"+ product name + "的信息",system datetime now, user identity name);catchmessage. text ="出现错误,更新失败! "gridbind 0;protected void gridproduct_pcigelndexchtinging(object source,system web ul webcontrols gridviewpageeventargs e)/g r i dv i ew控件分页事件gridproduclp

28、agolndcx 二 c. ncwpagelndex;gridbind ();)丄销售情况查询销售信息201112三月22三日查询月誚售情况 |查询日誚售情况-protected void page_load(object sender,eventargs e)/初始化页面if (!page. ispostback)gridsailsvisible = true;yearbindo ;monthbindo ;daybindo ;gridbind (year. sclcctcdvalue, month. selectedvalue, day. selectedvalue);adniindb. i

29、nsert act ion (，?查看丁 日销售记录",system. datetime. now,user identity name);)protected void gridbind( string year,string month, string day)adniindb ad=new adniindb ():gridstiilsdatasource 二 ad. getstiils(yetir, month, dtiy);gridsails. databindo ;protected void yearbindo(year. items. clear();int start

30、year = datetime, now. year - 10;int currentyear 二 dtit etime .now. year;for(int i二startyear;i<=currentyear;i+)year. tterns. add (new listttem(i. tostringo) ;year .selectedvalue = curre nt year .tostringo;protected void monthbindomonth items clear ();for (int i=l; i<= 12; i+)month. items. add(i

31、. tostringo) ;protected void daybindoday items clear ();string year = year.selectedvalue;string month =month.selectedvalue;int days = datetime. daystnmonth(int. parse(year), intp8rse(month);for (int i = 1; i <= days; i+)day. items. add(i. tostringo);protected void querymonthclick(object sender, s

32、ystemeventargs e)/查询所选日期的月销售记录gridbind(year. selectedvalue, month. selectedvalue, "0");admindb. insertactionc查看"+ year. selectedvalue + "年"+ month. sclcctcdvaluc + 月"+ "的销售记录"：system. datetime. now, user. identity. name);)protected void queryday click(object s

33、ender, systemeventargs e)/查询所选日期的日销售记录gridbind(year. selectedvalue, month. selectedvalue, day. selectedvalue);admindb. insertaction(*查看"+ year. sclcctcdvaluc + "年"+ month. sclcctcdvaluc + " 月"+ day. selectedvalue + "日的销售记录",system. datetime. now,user tdentity name)

34、;protected void yearselectedlndexchanged(object sender, eventargs e) (daybindo ;)protected void month sclcctcdlndcxchangcd(object sender, eventargs e) daybindo :丄用户列表用户列表用户id用户亘录名真实姓名性别邮编地址email預存裁編辑4che nrui陈睿男100083beihangchenruibuaavip .163 .com900編辑5daviddavid男100083buaadavid1000編辑6worldbill男100

35、042beijingwide0编辑7xiaozhi小指男100083北京magic200106100000編辑8me渚文庆男201824洞川chumailsohu com886524編辑9me28824編辑10xx0protected void page_load(object sender, eventargs e)/页面初始方法if (!page. tspostback)gridbindo ;admindb. insertaction(，/查看用户列表",system. datetime. now,user identity name); protected void gridb

36、ind()admindb ad=new admindb();gridusers datasourcead getuserlist();gridusers databindo ;protected void gridusers_pagetndexchanging(object source,system. web. ui. webcontrols. gridviewpageevontargs e)/grid view控件分页事件griduserspagelndex = e. newpageindex;gridbindo ;protected void gridusers_rowediting(o

37、bject source,system. web. ui. webcontrols. gridvieweditevontargs e)/gridview控件行编辑事件gridusers.edittndcx = e. neweditindex;gridbindo ;)protected void gridusersrowcancelingedit (object source,system web ul webcontrols gr i d v i ewctince 1 edit even t args e)/gri dvi ew控件行编辑取消事件gridusers edi ttndex二t:g

38、ridbindo ;protected void gridusers rowupdating(object source,system. web. ut. webcontrols. gridviewupdateeventargs e)/gridview控件行更新事件admindb ad = new admindbo :textbox money = (textbox)gridusers rowse rowindex findcontrol ("acount"); int userid = converttotnt32(gridusersdqtakcyserowtndcxva

39、luetostringo);ad. updateuseracount(decima 1 parse( money. text trimo), usertd tostringo);admindb. insertactionc*修改用户id为"+ userid. tostringo + "的帐户金额"，system daletime now, user identity name);gridusers editindex = t;gridbindo ;修改密码修改密码提交bll user user = new eshop. bll user ();int result

40、 = userchsngopassword(oldpwd.text,newpwd. text, int. parse( user. identity. name):switch (result)ccise 1: messtige. text 二"修改成功！ “; break;case -1: message. text = 修改失败！ “； break;defaul t: response wri te(，z<script ianguage=javascript>alert ('出现异常!1):</script>，z); ; break;) 确认结算请

41、确认您提交的购物记录是否正确商品氛号商品名琢价格小计34office xp¥ 1,234.001¥ 1,234.00总计：¥1,234.00提交 bll. shoppingcart shopcart = new eshopbllshoppingcsrt();protected void page_load(object sender, evenlargs e)/页面的初始方法if ('page. tspostback)string carttd = shopcartgetshoppingcarttdo;mydatagriddalasourcc 二 shop

42、cartgclitcms(cartld);mydatcigrid. databind ();totallb1text = stringformat("0:cshopcartgettotal(cartld); protected void submitbtn click(object sender, systemeventargs e)/业务方法：提交结算bll. orders order = now eshop. bll. orders ();decimtil totalcost 二 shopecirt gettotal (shopcart getshoppingcartld ();

43、if (shopcartgetshoppingcartld()!= null && user1dentity name!= null)if (order payorder(convert tostring(user identity name), totalcost) = 1) int orderld= order. p1aceorder( converttostring(user. identily. name), converl tostring (shopceirt getshoppingccirtld ();message. text ="您的订单号为&quo

44、t;+0rderld ;submitbtnvisible = false;elseresponse. writec*<script 1 anguage=javascript> window, alert您的预存款不足 ')/script")；/ response redirect ("orderlist aspx，z) ; 修改信息填写用户资料提交int result 二user changeprofile ( conver l tostr ing (user identity n time) , realntime .text, address .te

45、xt, zipcode text, emai1 text, sex text);if (result!= null)response. write ("script languagc=javascript>alcrt c 修改成功！ ')；/script"); message. text 二"修改成功！ “；elseresponse .write ("script language=javascript>alert ('修改失败！ )；/script");message. text ="修改失败！"

46、;； 找回密码找回密码提交protected vo i d submit_click (object sender, system .evenlargs e)/捉交按钮点击事件eshop. blllser user = new eshopblllser();string t=convert. tostring( tel. text):int result= usergetbackpassword(loginname .text , question. text, answer .text , emai 1. text, l);if (result 二二 1)response. write(z/

47、<script language=javascript>alert ('找冋成功！ ') ;</script>)； message. text ="成功!" 购物记录订单号订单时间订单总讓查诲详细信息172010-7-28¥ 12,000.00查询182010-7-29¥ 21,000.00查询192010-7-29¥ 588.00查询202010-7-29¥ 10,000.00查询212010-7-29¥ 588.00查询222010-8-5¥ 13,300.00查询242

48、010-12-2¥ 36,000.00查询252010-12-2¥ 20,000.00查询protected void page_load(object sender, evenlargs e)/页面初始方法if (!tspostback)if (request isauthenticated 二二 true)logoutareavisible = false;i.ogtnarea v isible = true;elselogoutareavisible = true;i.ogtnarea v isible = false;mylist .datasource =bll

49、orders order = new eshop bll orders();mylist datasource = order getorderlist(convert. tostring(user. identity name); mylist. databindo ;if (mylist. rows. count = 0)mylist .visible = false;/ response. write (window, alert (* <script > 您没有订单记录!/script)")； response wri te ("scr i pt 1 a

50、nguage=javascri pt>al ert ('您没仔订 单记录');/script")；myerror. text ="您没有订单记录!"购物详细信息您的订单号是:21订单日期为：2010年7月29日商品緘号商品名称价格数量小计37自行车¥ 588.001¥ 588.00总计：588.0000protected void page load (object sender, eventargs e)/页面初始方法if (!page. ispostback)if (request tsauthcnticated =

51、true)logoutareavisible = false;logtnareavisible = true;elselogoutarea .visible = true;logtnareavisible = false;show ():protected void show()bll orders orders二new eshop bll orders();int order id 二 convert. tolnt32 (request. querystr ingtorderld);bll. orderdetciilsorderdetail=ordersgetorderdetaiis(ord

52、erld, convert.tostringc user identityname); / lblordernumber.text =converttostring(ordertd);if (orderdetai1 != null)gridcontro11. datasource 二 orderdetai1.0rderltems;gridcontro 11. databindo ;iblorderdate text = orderdetai1 ordcrdatc tolongdatestri ng(); lbltotal. text = convert. tostring(orderdetai

53、1. ordertotal); lblordernumber. text =converl tostring(orderld);else/myerror. text ="订单不存在！ ”; dctailstablevisible = false;/ response. write (window, alert (* <script> 订单不存在!/script')")； response write ("script langucige=javascript>alert ('订单不存在!');/script")；

54、 商品信息苹果 ibook(ai9426cha)价格：12000 ¥简介：处理器类型:intel pentium理器主频(mhz):2000 浏鳖h次protected void page load(objectsender, eventargs e)/页而初始方法int productld=int parse (request querystring/productid，j);/ array pd =new array ( bll. product. getproductlnfoo);iblproductname .text =bll product getproductinfo(

55、productid) productname tostringo;iblprice. text = bll.product. getproducttnfo(productid). productprice. tostringo +lbllntro.text 二 bllproduclgotproductlnfo(productld) introtostringo; lblclickcount.text 二bll .product getproduct info (productld ) clickcount tostringo+z/ 次; 商品列表查询结果商品编号商品名称简单描述购买16office2003micro s oft公司cffic e系列软件的最 新版本。017fedora core 3redhat公司于2004年推出的linux 新版本。020windows xpprofessionalmicro s oft公司windows系列操作系 统023金山独霸金山公司杀毒软件0350ffice2