自行车组装车间管理信息系统设计论文[带程序].doc -- 45 元

编号无锡太湖学院毕业设计（论文）题目自行车组装车间管理信息系统信机系机械工程及自动化专业学号学生姓名指导教师（职称教授）（职称）2013年5月25日无锡太湖学院本科毕业设计（论文）诚信承诺书本人郑重声明所呈交的毕业设计（论文）自行车组装车间的管理信息系统是本人在导师的指导下独立进行研究所取得的成果，其内容除了在毕业设计（论文）中特别加以标注引用，表示致谢的内容外，本毕业设计（论文）不包含任何其他个人、集体已发表或撰写的成果作品。班级机械93学号作者姓名2013年5月25日II摘要随着现代工业的发展，计算机信息管理系统越来越受到企业重视，而车间仓库管理信息系统就是一个典型的信息管理系统MIS，库存管理系统能够极大地提高人事劳资管理的效率，也是企业的科学化、正规化管理与世界接轨的重要条件。基于此本人开发了一个库存管理系统，该系统实现了零件基本信息、类别信息、仓库信息等基本信息的管理，实现了零件入库、成品出库、入库管理、出库管理、出入库统计等库存管理，系统还实现了库存查询、用户管理、系统管理等功能。系统的核心是库存管理，企业使用库存管理系统，可以摆脱传统的手动填写单据工作模式，节省了大量的人力、物力和财力，使得管理员从繁琐的工作中解放出来。本系统开发平台是VS2005，开发语言是C,数据库为SQLServer2005。系统采用三层架构模式，三层架构模式可实现代码的分散关注、松散耦合、逻辑复用、标准定义，并使得代码具有高度的可扩展性、安全性、易移植性和易维护性。关键词管理信息系统VS2005SQLServer2005IIIAbstractWiththedevelopmentofmodernindustry,thecomputerinformationmanagementsystemmoreandmoreenterprisestopayattention,workshopandwarehousemanagementinformationsystemisatypicalmanagementinformationsystemMIS,inventorymanagementsystemcangreatlyimprovetheefficiencyofthepersonnel,labormanagement,butalsobusinessscientificandstandardizedmanagementwiththeworld.BasedonthisIdevelopedaninventorymanagementsystem,thesystemparts,category,warehousesandotherbasicinformationmanagement,partsstorage,thefinishedproduct,storagemanagement,adatabasemanagement,warehousingandStatisticsinventoryqueries,usermanagement,systemmanagementfunctionssuchasinventorymanagement,thesystemalso.Thecoreofthesystemisinventorymanagement,inventorymanagementsystem,youcangetridofthethetraditionalmanuallyfillindocumentmodeofoperation,savealotofmanpower,materialandfinancialresources,freeingadministratorsfromthetediouswork.ThesystemdevelopmentplatformisVS2005,developmentlanguageisC,SQLServer2005database.Thesystemusesathreetier,threetiercodeseparationofconcerns,loosecoupling,multiplexinglogic,standarddefinition,andmakesthecodewithahighdegreeofscalability,security,easyportabilityandeaseofmaintenance.KeywordsmanagementinformationsystemsVS2005SQLServer2005V目录摘要............................................................................................................................................IIABSTRACT..................................................................................................................................III目录............................................................................................................................................V1绪论.............................................................................................................................................11.1信息管理系统的概述...........................................................................................................11.1.1管理信息系统的功能与划分........................................................................................11.2管理信息系统的发展...........................................................................................................21.2.1系统理论奠定信息系统理论基石.................................................................................21.2.2信息系统概念和演化....................................................................................................31.3信息管理系统的未来发展...............................................................................................42系统分析.....................................................................................................................................62.1系统需求分析.....................................................................................................................62.1.1系统功能要求..............................................................................................................62.1.2系统性能要求..............................................................................................................62.1.3系统用例描述..............................................................................................................62.1.4系统主要流程图..........................................................................................................63系统设计.....................................................................................................................................83.1功能模块设计.....................................................................................................................83.2数据库设计...........................................................................................................................93.2.1数据库对象....................................................................................................................93.2.2数据表..........................................................................................................................104系统的实现与说明...................................................................................................................144.1用户登录.............................................................................................................................144.2系统主界面.........................................................................................................................144.3库存管理.............................................................................................................................154.3.1零件入库......................................................................................................................154.3.2成品出库......................................................................................................................164.3.3入库零件查询和成品出库查询..................................................................................174.3.4数据备份......................................................................................................................195程序代码...................................................................................................................................205.1主界面代码.........................................................................................................................205.2连接数据库代码.................................................................................................................27