贸易管理系统

辽宁科技大学毕业设计（论文）第1页贸易管理系统摘要贸易管理系统是一种管理商业企业中各种数据的软件，利用本系统用户可以很方便地对企业的物流、财务状况、票据等进行有效的管理。本文首先简要介绍了我国商业企业的现状以及进销存数据管理系统的特点、功能和使用对象，使读者对进销存管理系统有了初步的认识。接着详细介绍了数据库和VB的相关知识，在数据库方面，主要介绍了数据库的基本概念、类型，着重介绍了关系数据库的概念和SQL语句（结构化查询语言）；在编程工具方面，主要介绍了VB的特点和怎样用SQL作数据库，着重介绍了VB的ADO控件、DataGrid控件、DataCombo控件和ADO对象在数据库编程方面的应用。最后，笔者给出了所完成的进销存数据管理系统说明书，主要内容包括软件的功能、设计框图、数据库结构和各模块的作用说明。随着人类社会的进步与发展，当今的社会已经进入了信息化的社会，越来越多的信息已无法通过手工记录、人工管理来实现，信息在社会经济中发挥着越来越重要的作用，企业的来往业务也不断增加，这就要求通过一个好的管理软件，本系统是对企业的进货、销售、库存进行管理，开发软件是用的SQLServer2000作为后台数据库。关键词贸易管理系统；数据库编程；SQL辽宁科技大学毕业设计（论文）第II页TradeManagementSystemAbstractThebuy-sale-basemanagementsystemisakindofsoftwarethatmanagesenterprisevariousdata.Usercanconductfinancial,pillsconveniently.First,commerceenterpriseactualityandthecharacteristicofbuy-sale-basemanagementsystemareintroducedinthispaper.Then,thedatabaseandVBareintroduced,intheaspectofdatabase,wemainlyintroducetheconceptandtypeofdatabase,relationaldatabaseandSQLareintroducedaswell;intheaspectofprogramming,wemainlyintroducethecharacteristicofVBandhowtomanipulatedatabase,theusageofADO,DataGrid,DataComboandADOobjectareintroducedaswell.Finally,wecompletethenotebookofbuy-sale-basemanagementsystem,includingthefunction,designchart,databasestructureandmanipulatenotebookofeverypart.Withtheprogressofhumansocietyanddevelopment,today'ssocietyhasenteredtheinformation-basedsociety,moreandmoreinformationhasbeenunabletomanuallyrecord,managedtoachieve,inthesocio-economicinformationplaysanincreasinglyimportantroleinenterprisesfromthegrowingbusiness,whichrequirestheadoptionofagoodmanagementsoftware,thissystemisthestock-to-business,sales,inventorymanagement,thedevelopmentofsoftwareisusedbySQLServer2000databaseasabackground.KeywordsTrademanagementsystem;databaseprogramming;SQL辽宁科技大学毕业设计（论文）第III页目录摘要........................................................................................................................................IAbstract.................................................................................................................................II目录.....................................................................................................................................III第1章绪论.........................................................................................................................11.1开发背景..................................................................................................................11.2开发目的..................................................................................................................11.3开发意义..................................................................................................................21.4系统实现的功能和特点..........................................................................................21.5开发软件简介..........................................................................................................21.5.1SQLServer2000................................................................................................31.5.2VB.net.................................................................................................................4第2章可行性分析.............................................................................................................52.1技术可行性..............................................................................................................52.2经济可行性..............................................................................................................62.3法律可行性..............................................................................................................62.4操作可行性..............................................................................................................62.5可行性研究结论......................................................................................................7第3章需求分析.................................................................................................................83.1系统功能模块划分..................................................................................................83.2系统性能需求..........................................................................................................93.3系统开发及运行环境..............................................................................................93.4数据流图..................................................................................................................93.4.1系统顶层DFD图...........................................................................................103.4.2系统第二层DFD图.......................................................................................103.5数据字典................................................................................................................11第4章系统的总体设计...................................................................................................144.1设计目标................................................................................................................144.2系统功能结构图..........