企业管理售后系统

合肥师范学院2011届本科生毕业论文（设计）I企业售后管理系统摘要随着经济全球化和信息技术迅猛发展，越来越多的信息技术运用于企业售后的管理，将企业售后管理与计算机技术相结合能够使售后管理更加方便、简单、省时、及时，趋于系统化和自动化，可以避免不必要的花费和错误。根据企业的资金规模的不同，将企业分为大中小型企业。本论文着眼于中小型企业的售后管理系统的开发设计。本系统是利用小型数据库VisualFoxPro6.0软件设计开发。根据需求分析进行设计，利用VFP的工具实现各个功能界面，同时设置了权限：不同的用户通过口令表单验证后进入的是不同的操作界面。值得一提的是在设计代码过程中利用到了结构化查询语言（SQL），使编写代码的过程更加方便简单、易操作。本论文首先概述了该系统开发的背景和开发工具，接着详述了用户的需求分析，明确了系统的功能，最后介绍了系统的总体设计和详细设计，包括系统的总流程、总框架、数据库的设计和其它界面的设计，以及设计中遇到的问题和解决的方案。关键词：售后管理VisualFoxPro6.0结构化查询语言权限合肥师范学院2011届本科生毕业论文（设计）IIABSTRACTWiththerapiddevelopmentofglobalizationofworldeconomyandinformationtechnologies(ITs),moreandmoreITsareusedinenterprisepost-salemanagement.Integratingtheenterprisepost-salemanagementwithcomputertechnologywillmakethepost-salemanagementbecomemoreandmoreconvenient,simple,savingtimeandintimewiththehelpofcomputertechnologymanagement.Ittendstosystematic,automated.Itavoidsunnecessaryexpensesanderrors.Accordingtothesizeofenterprisesfund,companiesweremeasuredintosmall,mediumandlargecorporations.Thisdissertationmainlyfocusesondesigningapost-salemanagementsystemforsmallandmediumenterprises.ThesystemmakesuseofsmalldatabasesystemwhichisVisualFoxPro6.0softwaretodesignanddevelop.Accordingtothemostimportantanalysisofthedesigntask,itcanbeusetheVFPtoolsdesignedtoachievespecificfunctionalinterface.Atthesametime,itsetupthepermissions–everyemployeehavedifferentpassword,sothattheycanlogintodifferentoperationInterface.ItisworthmentioningthatusetheSQLlanguagetodesignthecodeandthecodebecomemucheasierandconveniencetooperate.Atfirst,thedissertationsummarizesthebackgroundofthesystemdevelopmentandtheintroductionofthedevelopmenttools,thenpresentthedetailsofthespecificneedsofusersandthesystemfunction,andfinallyitdescribesthesystem'soveralldesignanddetaileddesign,includingthesystem'stotalflow,thetotalframework,thedatabasedesignandthedetaileddesignoftheinterface,andproblemsandsolutionsintheprocessofdesign.Keywords:post-salemanagementVisualFoxPro6.0SQLlanguagePermissions目录1绪论............................................................................................................11.1背景介绍......................................................................................................11.1.1系统开发背景.....................................................................................11.1.2开发工具介绍.....................................................................................21.1.3系统开发环境.....................................................................................31.2论文组织结构..............................................................................................32需求分析.....................................................................................................42.1设计要求......................................................................................................42.2可行性分析..................................................................................................62.2.1技术上可行性.....................................................................................62.2.2操作上可行性.....................................................................................62.2.3经济上可行性.....................................................................................63系统结构.....................................................................................................73.1系统总流程..................................................................................................73.2系统总框架图..............................................................................................83.2.1系统维护人员设计.............................................................................83.2.2数据录入员设计.................................................................................83.2.3采购员设计.........................................................................................93.2.4销售员设计......................................................................................103.2.5维修人员设计..................................................................................104系统详细设计...........................................................................................114.1数据库设计................................................................................................114.1.1数据库概念设计..............................................................................114.1.2数据库逻辑结构及物理结构设计..................................................144.2系统进入和验证模块设计........................................................................194.2.1开始界面...........................................................................................194.2.2口令界面...........................................................................................204.3系统维护人员界面与功能设计................................................................204.4数据录入员界面与功能设计....................................................................214.4.1数据浏览模块...................................................................................214.4.2数据处理模块................................................................................