网上书店系统设计

1课程设计说明书题目网上书店系统设计院系信息技术系专业班级08计算机科学与技术学号学生姓名指导教师2010年6月20日2目录1系统概述3111开发背景3112可行性分析4113系统需求分析42设计任务书421研究方案和目标422任务要求和主要内容53本组课题及本人任务54系统总体设计541系统规划542用户行为分析643系统功能设计65系统详细设计751设计目标752构建开发环境753模块的详细设计8创建购物车信息9创建管理员信息表10创建订单信息表106数据库设计与实现187主要数据表结构203网上书店系统设计李荷花指导教师朱瑜A1A0A2A2A3A5A4A6A7A8A9A10A11A12A141系统概述111开发背景INTERNET是目前世界上最大的计算机互联网络，它遍布全球，将世界各地各种规模的网络连接成一个整体。作为INTERNET上一种先进的，易于被人们所接受的信息检索手段，WORLDWIDEWEB简称WWW发展十分迅速，成为目前世界上最大的信息资源宝库。据估计，目前INTERNET上已有上百万个WEB站点，其内容范围跨越了教育科研、文化事业、金融、商业、新闻出版、娱乐、体育等各个领域，其用户群十分庞大，因此，建设一个好的WEB站点对于一个机构的发展十分G4407G3985。G2093G2733G2303，G3387G4482网络用户G3985G3024的G994G1390G3476G1594G1923计算机科G3888的迅速发展，G3467G953是G3316据库G1935G3308G4221INTERNETG4399的G1692G1463G4075用，WEB站点G3775用户G3476G1634的G1531G3680将越G2303越G1502G1558，越G2303越人G3839化。G3649们发G3747G4323G3970一个事G3244，一个用户G4221G1472G3641一个网站G3240一G846G2303G2019G4378对G1566网站的G998分内容G1579G3839G3039，G1431G2991G4323种G3830G3039G1878G1115G3875一段G3240G1975。G4323点G2931发了G3649们，G3106G1716G2719G1620据用户的G3711好为G994G3517的用户G3745G3253其个G3839化的G3994G2635，G1927G4482G4407G3745G3253G1566用户G1579G3830G3039的内容，将为用户G2059G4191大G2408的检索G3240G1975，G1431G2991G4323G3970的网G3994G3745G3062是G1623G2158有G3691G4068G2383的。一G3796站点已G2108G4221G4323G1466G2635作出了一G1351的G1063G3275，G3513G1064G1008用的G1466G1445是，G4221用户G1288G2500G3240为其G3476G1634一G3714G2425的G3882G3771，G3248用户G2719G1652对站点进G3835一G3796G4497G4438的设G4386。G4323G3970G4531G2719G1652G3248站点G1103G3747一G1351G1105G1383的个G3839化，G1260是对用户G2303G2019，G1838是G913G2048G1456G3403，G1431G2991G4221用户了G2067一个站点前G3070其对站点进G3835设G4386，其G2066G1716G3619G2631有G3796G1209G1025。于是G3649们构G3768了G4323G3970一种G1466G803，对用户G1288G2500G1802的G1358作进G3835G1621G4502，分G3685，发G2177用户点G1900的规G2512，G1927用户先G1802点G1900的G1681联规G4245，G4323G3970，G4221用户点G1900一个G4438G3477G271链接）之G1802，G3714统G2719G1652G4497G1358生成一G3994G2635，其G4399包含了G1566G4438G3477下用户G2108G1064G1681注的内容G271若干链接），G4323G3970便G4221无须用户作出任何额外工作的情况下G3244G3747了为用户G2408身订G4531的个G3839化G3994G2635。G3985G3244G3747G4323G3970的功G2719，离G994开G1802台G3316据库的支G1115。用户验证信息，收集到的用户点G1900信息，G4438G3477层次信息，分G3685得出的G1681联规G4245表等大G2408的G3316据都由G3316据库管理G3714统管理。本文G4399G3316据库G1531G3680器端G1008用了MICROSOFTACCESSG3316据库作为ODBCOPENDATABASECONNECTIVITYG3316据源，并以先进的ADOG271ACTIVEXDATAOBJECTS）G1935G3308进G3835G3316据库存取等操作，G3248WEB与G3316据库紧密联G3714起G2303。整个个G3839化G3994G2635生成G3714统G4438G3985由G3248用DREAMWEAVER_MX开发的G1681联规G4245G1008G2177G3714统和利用IISASPG1935G3308G3244G3747的个G3839化WEBG3994G2635生成器两G998分组成。G1681联规G4245G1008G2177G3714统对G3316据库G4399的历史记录进G3835分G3685，产生用户G1681联规G4245表；G3994G2635生成器G4245负责记录4用户G3835为和G1620据G1681联规G4245表G1358态生成用户个G3839化WEBG3994G2635。二者G3513过G3316据库G1531G3680器和WEBG1531G3680器连接。本文作者G4438G3985完成WEBG1531G3680器端的用户管理、图书目录管理、图书信息录入管理、书店G1351单管理、图书的浏览和查找、书店购物G2066帐功G2719模块的设计、G3244G3747与完善以G1923整个G3244验网站的组织建立和测G3275工作。国外的WEB商务系统应用起步较早，所以应用的领域比较广，网络销售已经在人们日常消费中占到一定比例，WEB商务系统也比较成熟。人们可以以网络这个媒体，足不出户就可以搜索、查询到自己需要的信息、购买自己需要的商品。我国电子商务的发展起源于70年代的EDI应用，我国海关是最早引入EDI进行报关，经过几年的完善发展目前企业可以通过上网申请报关。112可行性分析技术可行性该系统是基于WEB的B/S结构的系统，服务器端程序采用ASP脚本G16833G16340，G6980G6466G5223采用SG52G47SEG85G89EG85G2100G27。ASP脚本G16833G16340G2656SG52G47SEG85G89EG85G2100G27的结G2524完G1852可以完成系统的目G7643，G5194G1000系统G5332发人G2604目前已经G6496G6581G1016上G17860G1016个G5049G1867，所以该系统的G5332发在技术上是可行的。G7114G19400可行性G5332发G7114G19400需要G20个G7388G5050G2503，前G210G3837G1039要用于系统G2010G7524、G16786G16757、G4466G10628，G2530G200G3837G1039要用于G4557系统进行G16855G16809G2656G8991G16809。人G2604可行性本系统的G5332发需要G21人，一人G17139G17143系统前G2500G7234通用户G8181G3371的G5332发，G2490一人G17139G17143系统G2530G2500G12661G10714用户G8181G3371的G5332发，G5332发G4579G13464经过G11713G7411G4410G1076G2656G3533G16769是可以G17810到人G2604要G8726的。113系统需求分析G11013于用户的G16757G12651G7438G8712G5191G7389G19492，要G8726G7389G14403G3921的人G7438G1144G8981G11040G19766。G12661G10714系统G1262G2604，G11013于网G12461采用G1114G1262G2604系统，要G8726G7389较G3921的G7447G19492G12661G10714。G6980G6466G16757G12651自G2172完成，G4625G18339G1955G4581人G5049G5190G20056。用户购买完G1082G12833G2530G14033G3827G4445G1852G17876出系统。2设计任务书21研究方案和目标网上G1082G5227系统G4658于BG21G38电子商务网G12461系统，G4439G14033G3827G13481过中G1183G708G3926G6221发商、销售商G6122经销商G709G5326G12447G994G4470户的G11464G6521G13864系，可以G1038用户G6564G1391G1082G12833的G16826G13466信息，用户可以在G13459购买G1082G12833，G12661G10714购G10301G17722，G11842定G16758G2345。本G20076目是G16786G16757一个G17731G1226系统，G6365G10043G17731G1226G5049程的一般方法G2656过程，从G17731G1226需G8726G2010G7524G5332始，经过概要G16786G16757、G16826G13466G16786G16757，最G2530选择相应的G5332发G5191G2500G6122G5049G1867G16786G16757出G44665G10628系统功G14033的G17731G1226系统。本系统架构可采用B/S/SG708BROWSER/WEBSERVER/DBSERVERG709三层结构，即基于WEB的文G1226访问。G4470户端采用通用的浏览器。G2530G2500G6980G6466G12661G10714可采用ACCESS、SQLSERVER等，G16786G16757相应的G6980G6466G5223，G4466G10628G6980G6466的存储。G16786G16757的G1039要内容在WEBSERVER端选择相应的脚本编写技术G6122WEB应用程序G16786G16757G16833G16340G16786G16757G4466G10628系统功G14033的程序。22任务要求和主要内容根G6466G4410院科技处G4557G4410院教师科研G5049作的G12661G10714G8981程的G2010G7524，G5332发出一个B/S结构的系统。本系统功G14033基本要G8726在以下几个方G19766G20系统前G2500，即G7234通用户G8181G3371。G7234通用户G14033G3827注册、修改、自己的用户信息，浏览、查询网G12461图G1082情况，G5194进行图G1082的G16758购。G21系统G2530G2500G12661G10714，即G12661G10714G2604用户G8181G3371。G12661G10714G2604G14033G3827G4557G7234通用户G6564G1144的信息进行审核G5194作出审核G7643记记入G6980G6466G5223中，G14033G3827G4557G7234通G1262G2604的账户进行G12661G10714，G4557图G1082信息进行G12661G10714，G4557G1262G2604的G16758G2345信息进行处G10714。3本组课题及本人任务本G13464课G20076G1038G4466G10628创G5326、运行一个网上G1082G5227，进行网上G1082G5227的运行G708G7389用户G5194产生G16758G2345G709，G5194G4557G1082G5227进行维护，G16855整，G4557用户的操作、网G12461运行、图G1082的G12661G10714、G16758G2345的处G10714。本人的任务是G4557网G12461的G2530G2500系统进行G16786G16757，G8181G3371的G4466G10628G4466G10628G2530G2500的G12661G10714G2604G4557用户信息的G12661G10714，图G1082信息的G12661G10714，G16758G2345处G10714、G4557G6980G6466G5223的G12661G10714，维护刷新等G8181G3371。本人的所G7389G5332发G5049作都要围G13481该G8181G3371的需G8726来做。4系统总体设计41系统规划根G6466网上G1082G5227系统的功G14033需G8726，可以将其G2010G1038前G2500网G12461系统G2656G2530G2500G12661G10714系统G1016大部G2010。前G2500网G12461系统前G2500网G12461系统G1039要包括以下基本功G14033G8181G3371用户注册功G14033G8181G3371用户基本信息G12661G10714功G14033G8181G3371用户登录功G14033G8181G3371G1082G12833信息G19492售股功G14033G8181G3371G1082G12833搜索功G14033G8181G3371用户购G10301G17722G12661G10714G8181G3371用户G16758G2345G12661G10714G8181G3371G2530G2500G12661G10714系统6G2530G2500G12661G10714系统G1039要包括以下基本功G14033G8181G3371G12661G10714G2604G4557用户信息G12661G10714G8181G3371图G1082信息G12661G10714G8181G3371G4557用户G16758G2345处G10714G8181G337142用户行为分析在G4466G10628本网上G1082G5227系统之前，需要从用户的角度进行用户行G1038G2010G7524，进而G11842定系统的目G7643。网络用户在使用网上G1082G5227购图G1082G7114，典型行G1038G3926下图G2043系统功能设计网上G1082城前G2500网G12461系统功G14033结构7网上G1082城G2530G2500网G12461系统功G14033结构5系统详细设计51设计目标本系统是G1038G1114方便用户G4466G10628网上购G1082而G16786G16757的，采用人G7438G4557话的方式，G11040G19766友G3921，浏览查询图G1082准G11842快速。G5194G1000系统采用G1114SQLSEG89EG85G2100G27作G1038G2530G2500G6980G6466G5223，G6980G6466存储G4445G1852可靠。G20G4557于前G2500网G12461用户，G4466G10628G3926下功G14033图G1082查询、浏览功G14033用户购买图G1082功G14033用户购G10301G17722G12661G10714系统运行稳定，G4445G1852可靠G21G4557于G2530G2500网G12461用户，G4466G10628G3926下功G14033G2530G2500G12661G10714人G2604的G12661G10714G1262G2604信息G12661G10714图G1082及图G1082类别G12661G10714G16758G2345的处G10714，G4557用户的G16758G2345G4466G7114的发货52构建开发环境G20G709G5332发环境网G12461G5332发环境MICG85OSOFTVISUALSTUDIOG2100G27SPG20网G12461G5332发G16833G16340ASPNETC网G12461G2530G2500G6980G6466G5223SG52G47SEG89EG85G2100G27G21G709服务器端操作系统WINDOWSG21003SEG89EG85WEB服务器IIS60G6980G6466G5223服务器SG52G47SEG89EG85G2100G27浏览器IE60网G12461服务器运行环境MICG85OSOFTNETFG85AMEWOG85KSDKVG2103G709G4470户端浏览器IE608G2010辨率最佳效果G200G21G23G1376G2753模块的详细设计G6980G6466G5223G8181G3371的创G5326G56SEMASTEG85G42OIFEG91ISTSG11SELECTNAMEFG85OMSG92SDATABASEWG75EG85ENAMEG32NG10WEBSG75OG83G10DG85OG83DATABASEWEBSG75OG83G42OG38G85EATEDATABASEWEBSG75OG83G50NG83G85IMAG85G92G11NAMEG32NG10WEBSG75OG83G66DATAG10G15FILENAMEG32NG10DG63WEBSG75OG83G66DATAMDFG10G15SIG93EG32G24G20G210KB，MAG91SIG93EG32UNLIMITEDG15FILEG74G85OWTG75G32G200G8G47OG74ONG11NAMEG32NG10WBDSG75OG83G66LOG74G10G15FILENAMEG32NG10DG63WEBSG75OG83G66DATALOG74G10G15SIG93EG32G200G21G23KB，MAG91SIG93EG32G210G23G27G42BG15FILEG74G85OWTG75G32G200G21G23KBG42O创G5326图G1082G15932信息G38G85EATETABLEBOOKG708BOOKIDINTIDENTIFG92G11G20G15G20G83G85IMAG85G92KEG92G15G38ATEG74OG85G92G89AG85CG75AG85G11G240G15NAMEG89AG85CG75AG85G11G2000NOTNG56G47G47G15AUTG75OG85G89AG85CG75AG85G1130NOTNG56G47G47G15G83AG85TG89AG85CG75AG85G11G240NOTNG56G47G47G15G83UBLISG75EG85G89AG85CG75AG85G11G2000NOTNG56G47G47G15G83G85ICEDECIMALG11G28NOTNG56G47G47G15DISCOUNTDECIMALG11G28G15PICG89AG85CG75AG85G11G2000NOTNG56G47G47G15DESCG85IG83TIONSTEG91TNOTNULLG15G43ITSINTNULLG15STATUSSBITDEFAULTG11G20G7099图G1082信息类别G15932的创G5326CREATETABLEDBOCATEGORYIDINTIDENTITY1,1NOTNULL,DESNVARCHAR200NULL,PARENTIDINTNULL,ORDERBYINTNULL,REMARKTEXTNULL,CONSTRAINTPK_CATEGORYPRIMARYKEYCLUSTEREDIDASCWITHIGNORE_DUP_KEYOFFONPRIMARYONPRIMARYTEXTIMAGE_ONPRIMARYEND用户的创G5326CREATETABLEDBOUSERINFOUSERIDINTIDENTITY1,1NOTNULL,USERNAMEVARCHAR50NULL,PWDVARCHAR255NULL,ADDRESSVARCHAR200NULL,EMAILVARCHAR30NOTNULL,CONSTRAINTPK_USERPRIMARYKEYCLUSTEREDIDASCWITHIGNORE_DUP_KEYOFFONPRIMARYONPRIMARYTEXTIMAGE_ONPRIMARYEND创建购物车信息CREATETABLEDBOCARTIDINTIDENTITY1,1NOTNULL,ORDERNOVARCHAR50NULL,USERIDINTNULL,TOTALNUMBERINTNULL,TOTALMONEYMONEYNULL,ORDERDATEDATETIMENULL,STATEINTNULL,CONSTRAINTPK_ORDERFORMPRIMARYKEYCLUSTEREDIDASCWITHIGNORE_DUP_KEYOFFONPRIMARYONPRIMARYEND10创建管理员信息表CREATETABLEADMINSADMINIDINTIDENTITY1,1PRIMARYKEY,NAMEVARCHAR30NOTNULL,PWDVARCHAR50NOTNULL,创建订单信息表CREATETABLEORDERSORDERIDINTIDENTITY1,1PRIMARYKEY,USERNAMEVARCHAR50NOTNULL,BOOKNAMEVARCHAR50NOTNULL,AMOUNTINTNOTNULL,ORDERDATEDATETIMEDEFAULTGETDATENOTNULL,STSTUSBITDEFAULT0NOTNULL,书籍类别信息PUBLICPARTIALCLASSCATEGORYVIEWSYSTEMWEBUIPAGEPROTECTEDVOIDPAGE_LOADOBJECTSENDER,EVENTARGSEIFISPOSTBACKSTRINGCONNSTRCONFIGURATIONMANAGERAPPSETTINGS“CONNSTRING“SQLCONNECTIONCONNNEWSQLCONNECTIONCONNSTRSTRINGSQL“SELECTFROMCATEGORY“SQLDATAADAPTERDRNEWSQLDATAADAPTER“SELECTFROMCATEGORY“,CONNDATASETDSNEWDATASETDRFILLDS,“CATEGORY“DATAVIEWDVDSTABLES“CATEGORY“DEFAULTVIEWFOREACHDATAROWVIEWDATAVINDVTREENODETNNEWTREENODETNTEXTDATAV“NAME“TOSTRINGTNVALUEDATAV“CATEGORYID“TOSTRINGTNEXPANDEDFALSETHISTREEVIEW1NODESADDTNCONNCLOSE11STRINGCONNSTR2CONFIGURATIONMANAGERAPPSETTINGS“CONNSTRING“SQLCONNECTIONCONN2NEWSQLCONNECTIONCONNSTR2CONN2OPENSQLDATAADAPTERDR2NEWSQLDATAADAPTER“SELECTFROMBOOKWHERECATEGORYA13A15A16A17“,CONN2DATASETDS2NEWDATASETDR2FILLDS2,“CATEGORY“THISGRIDVIEW1DATASOURCEDS2TABLES“CATEGORY“DEFAULTVIEWTHISGRIDVIEW1DATABINDPROTECTEDVOIDTREEVIEW1_SELECTEDNODECHANGEDOBJECTSENDER,EVENTARGSE/THISLABEL1TEXTTHISTREEVIEW1SELECTEDNODETEXTSTRINGCATEGORYTHISTREEVIEW1SELECTEDNODETEXTSTRINGCONNSTRCONFIGURATIONMANAGERAPPSETTINGS“CONNSTRING“SQLCONNECTIONCONNNEWSQLCONNECTIONCONNSTRCONNOPENSQLDATAADAPTERDRNEWSQLDATAADAPTER“SELECTFROMBOOKWHERECATEGORY“CATEGORY“,CONNDATASETDSNEWDATASETDRFILLDS,“CATEGORY“THISGRIDVIEW1DATASOURCEDSTABLES“CATEGORY“DEFAULTVIEWTHISGRIDVIEW1DATABINDPROTECTEDVOIDGRIDVIEW1_PAGEINDEXCHANGINGOBJECTSENDER,GRIDVIEWPAGEEVENTARGSE书籍的会员打折PUBLICPARTIALCLASSDISCOUNTBOOKSYSTEMWEBUIPAGEPROTECTEDVOIDPAGE_LOADOBJECTSENDER,EVENTARGSESHOWALL12PUBLICVOIDSHOWALLDATABASEDBNEWDATABASESTRINGSQL“SELECTFROMBOOKWHEREPARTA18A19A20A21“DATASETDSDBGETDATASETSQLTHISGRIDVIEW1DATASOURCEDSTHISGRIDVIEW1DATABINDDBCLOSECONN书籍的搜索功能PUBLICPARTIALCLASSSEARCHBOOKSYSTEMWEBUIPAGEPROTECTEDVOIDPAGE_LOADOBJECTSENDER,EVENTARGSESTRINGSEARCHBOOKREQUESTQUERYSTRING“NAME“TOSTRINGDATABASEDBNEWDATABASE/STRINGSQL“SELECTFROMBOOKWHERENAMELIKE“SEARCHBOOK“STRINGSQL“SELECTFROMBOOKWHERENAME“SEARCHBOOKDATASETDSDBGETDATASETSQLIFDSNULLRESPONSEWRITE“ALERTA22A23,A24A25A26A27A28“THISLABEL1TEXT“A22A23,A24A25A26A27A28“ELSETHISGRIDVIEW1DATASOURCEDSTHISGRIDVIEW1DATABIND用户购物车PUBLICPARTIALCLASSUSERCARTSYSTEMWEBUIPAGEPROTECTEDVOIDPAGE_LOADOBJECTSENDER,EVENTARGSE13IFCONVERTTOSTRINGSESSION“USERNAME“RESPONSEWRITE“ALERTA29A30A31A32A33A34A28A35LOCATIONDEFAULTASPX“ELSEIFISPOSTBACKIFREQUESTQUERYSTRING“BOOKID“NULLSTRINGBOOKNAMECONVERTTOSTRINGREQUESTQUERYSTRING“BOOKID“DECIMALPRICECONVERTTODECIMALREQUESTQUERYSTRING“PRICE“STRINGUSERNAMECONVERTTOSTRINGSESSION“USERNAME“CARTCARTNEWCARTCARTADDUSERNAME,BOOKNAME,PRICESHOWALLPUBLICVOIDSHOWALLCARTCARTNEWCARTDATASETDSCARTGETUSERCARTCONVERTTOSTRINGSESSION“USERNAME“THISGRIDVIEW1DATASOURCEDSTHISGRIDVIEW1DATABINDPROTECTEDVOIDGRIDVIEW1_ROWCANCELINGEDITOBJECTSENDER,GRIDVIEWCANCELEDITEVENTARGSEGRIDVIEW1EDITINDEX1SHOWALLPROTECTEDVOIDGRIDVIEW1_ROWDATABOUNDOBJECTSENDER,GRIDVIEWROWEVENTARGSEPROTECTEDVOIDGRIDVIEW1_ROWDELETINGOBJECTSENDER,GRIDVIEWDELETEEVENTARGSE14INTCARTIDCONVERTTOINT32GRIDVIEW1DATAKEYSEROWINDEX“CARTID“TOSTRINGCARTCARTNEWCARTCARTDELCARTIDSHOWALLPROTECTEDVOIDGRIDVIEW1_ROWEDITINGOBJECTSENDER,GRIDVIEWEDITEVENTARGSEGRIDVIEW1EDITINDEXENEWEDITINDEXPROTECTEDVOIDGRIDVIEW1_ROWUPDATINGOBJECTSENDER,GRIDVIEWUPDATEEVENTARGSE/A36A37A38A39INTCARTIDCONVERTTOINT32GRIDVIEW1DATAKEYSEROWINDEXVALUES0INTAMOUNTCONVERTTOINT32TEXTBOXGRIDVIEW1ROWSEROWINDEXFINDCONTROL“TXTAMOUNT“TEXTCARTCARTNEWCARTCARTUPDATEAMOUNT,CARTIDGRIDVIEW1EDITINDEX1SHOWALLPROTECTEDVOIDGRIDVIEW1_ROWDELETING1OBJECTSENDER,GRIDVIEWDELETEEVENTARGSEINTIDCONVERTTOINT32GRIDVIEW1DATAKEYSEROWINDEXVALUES0CARTCARTNEWCARTCARTDELIDGRIDVIEW1EDITINDEX1SHOWALLPROTECTEDVOIDGRIDVIEW1_ROWCANCELINGEDIT1OBJECTSENDER,GRIDVIEWCANCELEDITEVENTARGSEGRIDVIEW1EDITINDEX1SHOWALLPROTECTEDVOIDGRIDVIEW1_ROWEDITING1OBJECTSENDER,GRIDVIEWEDITEVENTARGSEGRIDVIEW1EDITINDEXENEWEDITINDEXSHOWALL/A40A41A42A20A43A44PROTECTEDVOIDGRIDVIEW1_ROWUPDATING1OBJECTSENDER,GRIDVIEWUPDATEEVENTARGSE15INTIDCONVERTTOINT32GRIDVIEW1DATAKEYSEROWINDEXVALUES0INTAMOUNTCONVERTTOINT32TEXTBOXGRIDVIEW1ROWSEROWINDEXFINDCONTROL“TXTAMOUNT“TEXTCARTCARTNEWCARTCARTUPDATEID,AMOUNTGRIDVIEW1EDITINDEX1SHOWALLPROTECTEDVOIDGRIDVIEW1_PAGEINDEXCHANGINGOBJECTSENDER,GRIDVIEWPAGEEVENTARGSEGRIDVIEW1PAGEINDEXENEWPAGEINDEXSHOWALLPROTECTEDVOIDGRIDVIEW1_SELECTEDINDEXCHANGEDOBJECTSENDER,EVENTARGSEPROTECTEDVOIDCKB_ALL_CHECKEDCHANGEDOBJECTSENDER,EVENTARGSECHECKBOXCHKALLCHECKBOXGRIDVIEW1HEADERROWCELLS0FINDCONTROL“CKB_ALL“IFCHKALLCHECKEDFOREACHGRIDVIEWROWGRINGRIDVIEW1ROWSCHECKBOXCHKCHECKBOXGRCELLS0FINDCONTROL“CKB_SELECT“IFCHKCHECKEDCHKCHECKEDTRUEELSEFOREACHGRIDVIEWROWGRINGRIDVIEW1ROWSCHECKBOXCHKCHECKBOXGRCELLS0FINDCONTROL“CKB_SELECT“IFCHKCHECKED16CHKCHECKEDFALSE/A45A46A42A47A48PROTECTEDVOIDIMAGEBUTTON2_CLICKOBJECTSENDER,IMAGECLICKEVENTARGSE/IMAGEBUTTON2ATTRIBUTESADD“ONCLICK“,“JAVASCRIPTRETURNCONFIRMSURE“IMAGEBUTTON2ATTRIBUTES“ONCLICK“JAVASCRIPTRETURNCONFIRMA49A50A45A46A51“CARTCARTNEWCARTSTRINGUSERNAMESESSION“USERNAME“TOSTRINGCARTCLEARUSERNAMESHOWALL/A52A53A54A55A56A20A21A57A58A59A60A61PROTECTEDVOIDIMAGEBUTTON3_CLICKOBJECTSENDER,IMAGECLICKEVENTARGSEFOREACHGRIDVIEWROWGRINGRIDVIEW1ROWSTRYCHECKBOXCHKCHECKBOXGRCELLS0FINDCONTROL“CKB_SELECT“LABELLBLAMOUNTLABELGRCELLS4FINDCONTROL“LBLAMOUNT“STRINGBOOKNAMEGRCELLS2TEXTINTAMOUNTCONVERTTOINT32LBLAMOUNTTEXTINTIDCONVERTTOINT32GRCELLS1TEXTSTRINGUSERNAMESESSION“USERNAME“TOSTRINGIFCHKCHECKEDORDERSORDERNEWORDERSCARTCARTNEWCARTORDERADDORDERUSERNAME,BOOKNAME,AMOUNTCARTDELIDELSERESPONSEWRITE“ALERTA29A56A62A63A64A57A60A61“17CAT