网上服装销售系统----后台管理系统模块说明书

详细设计说明书（后台管理系统模块）陆轶（计0210）1引言11编写目的经过前期的需求分析与概要设计,为了能够进一步的描述本模块的具体功能实现以及为以后的软件再设计提供依据，故编写本模块的详细设计说明书。它主要依据于概要设计书和详细设计书。它预期的读者是委托设计双方的组织评审人员以及本模块的参与设计编程人员。12定义及说明本模块在整个服装销售系统中占有举足轻重的作用，它是系统的核心，是对销售做处理以及库存做统计的直接媒介。我在此模块中又设计了以下几个子模块，分别为用户管理，商品维护，销售处理以及数据库管理。13本模块中的各主要参数说明ADMIN表中ADMINNAME用户名称ADMINPASS密码FZHTABLE表中FZHID服装编号FZHNAME服装名称SHUOLIANG数量JIAGE价格LEIXING类型TUPIAN图片JIANJIE简介CLICK点击率TIANJIARQ添加日期TJ特价ZHUCE表中USERID会员名称PASSWORD密码SEX性别BIRTHDAY生日TEL电话ADDRESS地址QUESTION提问问题RESPONSE回答ORDER1表中ORDEREID订单号USERID会员号SONGHUOFANGSHI送货方式SONGHUOQIXIAN送货期限HUIKUANFANGSHI汇款方式DIDIAN地点SHOUHUOREN收货人YOUBIAN邮编DHRQ定货日期YAOQOU要求FUKUAN付款YIWAICHULI意外处理ORDERDETAIL表中ORDERDETAILID订单详情号SHULIANG数量ZXSL表中ZXSL总销售量14参考资料概要设计详细设计软件工程导论张海藩编著2本模块的主要功能用户管理主要是用来管理后台操作人员，包括用户增添和删除以及密码的修改；在商品维护子模块中，主要实现了商品的入库，修改，删除和库存查看；销售处理模块主要用来对公司的订单进行处理以及销售情况进行统计分析，还有销售额的汇总，注册会员的管理等；而数据库管理模块则主要是对数据库进行维护，包括备份和还原，保证了数据库的安全可靠。3本模块的开发流程31根据分析本模块的功能及与现实的联系抽象出其中的ER图入库ER图1N管理ER图管理员服装入库管理员服装商品信息添加维护统计汇总32本模块所用到的表如下ADMIN用户表列名数据列类型长度允许空ADMINIDINT4NADMINPASSNVARCHAR50YADMINNAMENVARCHAR50YFZHTABLE服装基本表列名数据列类型长度允许空IDINT4NFZHIDNVARCHAR8NFZHNAMENVARCHAR64YSHUOLIANGINT4YJIAGEINT4YLEIXINGNVARCHAR50YTUPIANNVARCHAR128YJIANJIECHAR256YCLICKINT4YTIANJIARQDATETIME8YTJINT4YZHUCE会员表列名数据列类型长度允许空IDINT4NUSERIDVARCHAR50YPASSWORDVARCHAR15YSEXCHAR2YBIRTHDAYDATETIME8YTELCHAR20YEMAILNVARCHAR50YADRESSCHAR50YQUESTIONNVARSHAR50YRESPONSENVARSHAR50YORDER1订单表列名数据列类型长度允许空ORDEREIDINT4NUSERIDNVARCHAR16NSONGHUOFANGSHICHAR32YSONGHUOQIXIANCHAR10YHUIKUANFANGSHICHAR10YDIDIANNVARCHAR64YSHOUHUORENNVARCHAR16YEMAILCHAR20YPHONENVARCHAR11YYOUBIANCHARYYDHRQSMALLDATETIME4YYAOQOUNVARCHAR512YFUKUANNVARCHAR50NYIWAICHULICHAR64YORDERDETAIL订单详情表列名数据列类型长度允许空ORDERDETAILIDINT4NORDERIDNVARCHAR50NFZHIDNVARCHAR8NSHULIANGINT4NFKJL付款记录表列名数据列类型长度允许空FZHIDNVARCHAR8NSHULIANGINT4YORDEREIDINT4NJIAGEINT4YZXSL总销售表列名数据列类型长度允许空FZHIDNVARCHAR8NZXSLINT4Y33根据所抽象出的ER图及所要实现的功能设计本模块的编程设计主界面核心代码如下PROCEDURETFORM1FORMCREATESENDERTOBJECTBEGINSTATUSBAR1PANELS1TEXT日期DATETIMETOSTRDATESTATUSBAR1PANELS2TEXT时间TIMETOSTRTIMEFORM1N19ENABLEDFALSEFORM1N20ENABLEDFALSEFORM1N1ENABLEDFALSEFORM1N4ENABLEDFALSEFORM1N12ENABLEDFALSEFORM1N7ENABLEDFALSEFORM1N9ENABLEDFALSEFORM1N21ENABLEDFALSEENDPROCEDURETFORM1N15CLICKSENDERTOBJECTBEGINIFFORM8NILTHENFORM8TFORM8CREATENILFORM8SHOWMODALEND登陆核心代码如下PROCEDURETFORM9FORMCREATESENDERTOBJECTBEGINADOQUERY1CLOSEADOQUERY1SQLCLEARADOQUERY1SQLTEXTSELECTADMINNAMEFROMADMINADOQUERY1OPENCOMBOBOX1ITEMSCLEARWHILENOTADOQUERY1EOFDOBEGINCOMBOBOX1ITEMSADDADOQUERY1FIELDSFIELDS0VALUEADOQUERY1NEXTENDCOMBOBOX1ITEMINDEX0ENDPROCEDURETFORM9BUTTON1CLICKSENDERTOBJECTBEGINADOQUERY1CLOSEADOQUERY1SQLCLEARADOQUERY1SQLADDSELECTFROMADMINWHEREADMINNAMENAMEANDADMINPASSPWADOQUERY1PARAMETERSPARAMBYNAMENAMEVALUECOMBOBOX1TEXTADOQUERY1PARAMETERSPARAMBYNAMEPWVALUEEDIT1TEXTADOQUERY1OPENIFADOQUERY1RECORDCOUNT0THENBEGINAPPLICATIONMESSAGEBOX你输入的密码不正确,系统信息,MB_OKMB_ICONINFORMATIONEDIT1CLEARENDELSEBEGINFORM9CLOSEEDIT1CLEARFORM1STATUSBAR1PANELS0TEXT用户COMBOBOX1TEXTFORM1N21ENABLEDTRUEFORM1N19ENABLEDTRUEFORM1N1ENABLEDTRUEFORM1N4ENABLEDTRUEFORM1N12ENABLEDTRUEFORM1N7ENABLEDTRUEFORM1N9ENABLEDTRUEFORM1N18ENABLEDFALSEIFCOMBOBOX1TEXTADMINTHENFORM1N20ENABLEDTRUEENDEND用户管理核心代码如下PROCEDURETFORM13BUTTON1CLICKSENDERTOBJECTBEGINADOQUERY1CLOSEADOQUERY1SQLCLEARADOQUERY1SQLTEXTSELECT1FROMADMINWHEREADMINNAMECHR39EDIT1TEXTCHR39ADOQUERY1OPENIFADOQUERY1RECORDCOUNT0THENBEGINMESSAGEBOXHANDLE,你输入的用户名已经存在,用户名重复,MB_OKORMB_ICONERROREDIT1TEXTEDIT2TEXTEXITENDIFEDIT2TEXTTHENBEGINMESSAGEBOXHANDLE,密码不能为空,密码有误,MB_OKORMB_ICONERROREXITENDADOQUERY1CLOSEADOQUERY1SQLCLEARADOQUERY1SQLADDINSERTINTOADMINADMINPASS,ADMINNAMEADOQUERY1SQLADDVALUESCHR39EDIT2TEXTCHR39,CHR39EDIT1TEXTCHR39ADOQUERY1EXECSQLMESSAGEDLG添加成功,MTINFORMATION,MBOK,0EDIT1TEXTEDIT2TEXTENDPROCEDURETFORM13BUTTON3CLICKSENDERTOBJECTBEGINIFADOQUERY2FIELDBYNAMEADMINNAMEASSTRINGADMINTHENMESSAGEBOXHANDLE,超级管理员不能被删除,注意,MB_OKORMB_ICONERRORELSEIFMESSAGEDLG确认在删除吗,MTWARNING,MBOKCANCEL,0MROKTHENBEGINADOQUERY2DELETEDBGRID1REFRESHENDEND入库核心代码如下PROCEDURETFORM3BUTTON1CLICKSENDERTOBJECTBEGINIFCHECKERRORTHENEXITADOQUERY1CLOSEADOQUERY1SQLCLEARADOQUERY1SQLADDINSERTINTOFZHTABLEFZHID,FZHNAME,SHUOLIANG,JIAGE,LEIXING,TUPIAN,TIANJIARQ,JIANJIEADOQUERY1SQLADDVALUESCHR39EDIT1TEXTCHR39,CHR39EDIT2TEXTCHR39ADOQUERY1SQLADD,CHR39EDIT3TEXTCHR39,CHR39EDIT4TEXTCHR39,CHR39COMBOBOX1TEXTCHR39,CHR39EDIT6TEXTCHR39,CHR39EDIT8TEXTCHR39,CHR39EDIT7TEXTCHR39ADOQUERY1EXECSQLMESSAGEDLG入库成功,MTINFORMATION,MBOK,0EDIT1TEXTEDIT2TEXTEDIT3TEXTEDIT4TEXTCOMBOBOX1TEXTEDIT7TEXTEDIT6TEXTEDIT8TEXTIMAGE1PICTUREGRAPHICNILLABEL10CAPTIONEND维护核心代码如下PROCEDURETFORM4FORMCREATESENDERTOBJECTBEGINBUTTON3ENABLEDFALSEADOQUERY1CLOSEADOQUERY1SQLCLEARADOQUERY1SQLTEXTSELECTDISTINCTLEIXINGFROMFZHTABLEADOQUERY1OPENCOMBOBOX1ITEMSCLEARWHILENOTADOQUERY1EOFDOBEGINCOMBOBOX1ITEMSADDADOQUERY1FIELDSFIELDS0VALUEADOQUERY1NEXTENDCOMBOBOX1ITEMINDEX0ENDPROCEDURETFORM4BUTTON2CLICKSENDERTOBJECTBEGINADOQUERY1CLOSEADOQUERY1SQLCLEARADOQUERY1SQLTEXTSELECTFROMFZHTABLEWHEREFZHIDCHR39EDIT1TEXTCHR39ADOQUERY1OPENIFADOQUERY1RECORDCOUNT0THENBEGINEDIT2TEXTADOQUERY1FIELDBYNAMEFZHIDASSTRINGEDIT3TEXTADOQUERY1FIELDBYNAMEFZHNAMEASSTRINGEDIT4TEXTADOQUERY1FIELDBYNAMESHUOLIANGASSTRINGEDIT5TEXTADOQUERY1FIELDBYNAMEJIAGEASSTRINGEDIT6TEXTADOQUERY1FIELDBYNAMEJIANJIEASSTRINGEDIT7TEXTADOQUERY1FIELDBYNAMETUPIANASSTRINGEDIT8TEXTADOQUERY1FIELDBYNAMETIANJIARQASSTRINGEDIT9TEXTADOQUERY1FIELDBYNAMETJASSTRINGTRYCOMBOBOX1TEXTADOQUERY1FIELDBYNAMELEIXINGASSTRINGEXCEPTENDBUTTON3ENABLEDTRUERADIOBUTTON1CHECKEDTRUEEDIT2ENABLEDFALSEENDELSEMESSAGEBOXHANDLE,服装编号有误或输入不正确,错误,MB_OKORMB_ICONERRORENDPROCEDURETFORM4BUTTON3CLICKSENDERTOBJECTVARDEL_FLAGINTEGERBEGINIFRADIOBUTTON1CHECKEDTHENBEGINIFCHECKERRORTHENEXITADOQUERY1EDITADOQUERY1FIELDBYNAMEFZHIDASSTRINGTRIMEDIT2TEXTADOQUERY1FIELDBYNAMEFZHNAMEASSTRINGTRIMEDIT3TEXTADOQUERY1FIELDBYNAMESHUOLIANGASSTRINGTRIMEDIT4TEXTADOQUERY1FIELDBYNAMEJIAGEASSTRINGTRIMEDIT5TEXTADOQUERY1FIELDBYNAMEJIANJIEASSTRINGTRIMEDIT6TEXTADOQUERY1FIELDBYNAMELEIXINGASSTRINGTRIMCOMBOBOX1TEXTADOQUERY1FIELDBYNAMETJASSTRINGTRIMEDIT9TEXTADOQUERY1POSTMESSAGEBOXHANDLE,记录已成功修改,修改成功,MB_OKORMB_ICONINFORMATIONENDELSEBEGINDEL_FLAGMESSAGEBOXHANDLE,警告删除是永久的不可恢复的确认删除吗,删除确认,MB_OKCANCELORMB_ICONWARNINGIFDEL_FLAGIDCANCELTHENEXITADOQUERY1DELETEMESSAGEBOXHANDLE,记录已成功删除,删除成功,MB_OKORMB_ICONINFORMATIONEDIT1TEXTEDIT2TEXTEDIT3TEXTEDIT4TEXTEDIT5TEXTEDIT6TEXTEDIT7TEXTEDIT6TEXTEDIT8TEXTCOMBOBOX1ITEMINDEX0BUTTON3ENABLEDFALSEENDEND库存显示核心代码如下PROCEDURETFORM16FORMCREATESENDERTOBJECTBEGINADOQUERY1CLOSEADOQUERY1SQLCLEARADOQUERY1SQLADDSELECTZXSLFZHID,ZXSLZXSL,FZHTABLESHUOLIANG,FZHTABLESHUOLIANGZXSLZXSLAS库存量FROMZXSL,FZHTABLEWHEREFZHTABLEFZHIDZXSLFZHIDADOQUERY1OPENIFADOQUERY1RECORDCOUNT0THENBEGINIFADOQUERY1FIELDVALUES库存量0THENADOQUERY1CLOSEADOQUERY1SQLCLEARADOQUERY1SQLTEXTSELECTFROMORDER1WHEREORDERIDYADOQUERY1PARAMETERSPARAMBYNAMEYVALUESTRTOINTEDIT1TEXTADOQUERY1OPENADOQUERY1EDITADOQUERY1FIELDBYNAMEFUKUANASSTRING已付ADOQUERY1POSTLABEL2CAPTION订单已处理成功,您可以在下次进入系统时在库存显示页面中查到EDIT1TEXTADOQUERY7CLOSEADOQUERY7SQLCLEARADOQUERY7SQLTEXTSELECTFROMORDERDETAIL,FZHTABLEWHEREFZHTABLEFZHIDORDERDETAILFZHIDANDORDERIDYADOQUERY7PARAMETERSPARAMBYNAMEYVALUEHADOQUERY7OPENWITHADOTABLE1DOBEGINFORI1TOADOQUERY7RECORDCOUNTDOBEGINAPPENDFIELDVALUESFZHIDADOQUERY7FIELDVALUESFZHIDFIELDVALUESSHULIANGADOQUERY7FIELDVALUESSHULIANGFIELDVALUESORDERIDADOQUERY7FIELDVALUESORDERIDFIELDVALUESJIAGEADOQUERY7FIELDVALUESJIAGEPOSTADOQUERY7NEXTENDENDADOQUERY2CLOSEADOQUERY2SQLCLEARADOQUERY2SQLTEXTSELECTFROMORDER1WHEREORDER1FUKUANPADOQUERY2PARAMETERSPARAMBYNAMEPVALUETRIMSADOQUERY2OPENADOQUERY1CLOSEADOQUERY1SQLCLEARADOQUERY1SQLTEXTSELECTORDERDETAIL,FZHTABLEJIAGEFROMORDERDETAIL,FZHTABLEWHEREORDERIDYANDFZHTABLEFZHIDORDERDETAILFZHIDADOQUERY1PARAMETERSPARAMBYNAMEYVALUEADOQUERY2FIELDBYNAMEORDERIDASSTRINGADOQUERY1OPENADOQUERY5CLOSEADOQUERY5SQLCLEARADOQUERY5SQLADDSELECTFZHID,SUMSHULIANGASZXLFROMFKJLGROUPBYFZHIDADOQUERY5OPENADOQUERY6CLOSEADOQUERY6SQLCLEARADOQUERY6SQLADDDELETEFROMZXSLADOQUERY6EXECSQLADOQUERY6CLOSEADOTABLE2ACTIVETRUEWITHADOTABLE2DOBEGINFORI1TOADOQUERY5RECORDCOUNTDOBEGINAPPENDFIELDVALUESFZHIDADOQUERY5FIELDVALUESFZHIDFIELDVALUESZXSLADOQUERY5FIELDVALUESZXLPOSTADOQUERY5NEXTENDENDENDEND销售额汇总核心代码如下PROCEDURETFORM7BUTTON2CLICKSENDERTOBJECTBEGINADOQUERY1CLOSEADOQUERY1SQLCLEARADOQUERY1SQLADDSELECTFZHTABLEFZHID,FZHTABLEFZHNAME,FKJLJIAGE,FKJLSHULIANG,SHULIANGFKJLJIAGEAS销售额FROMFZHTABLE,FKJLWHEREFZHTABLEFZHIDFKJLFZHIDADOQUERY1OPENADOQUERY2CLOSEADOQUERY2SQLCLEARADOQUERY2SQLADDSELECTSUMFKJLSHULIANGFKJLJIAGEASXSEFROMFZHTABLE,FKJLWHEREFZHTABLEFZHIDFKJLFZHIDADOQUERY2OPENLABEL1CAPTION总销售额为ADOQUERY2FIELDBYNAMEXSEASSTRING元END会员管理核心代码如下PROCEDURETFORM8BUTTON2CLICKSENDERTOBJECTBEGINIFEDIT1TEXTTHENBEGINADOQUERY1CLOSEADOQUERY1SQLCLEARADOQUERY1SQLTEXTSELECTFROMZHUCEWHEREUSERIDYADOQUERY1PARAMETERSPARAMBYNAMEYVALUETRIMEDIT1TEXTADOQUERY1OPENIFADOQUERY1RECORDCOUNT0THENMESSAGEBOXHANDLE,定位成功,成功,MB