搜索
I企业采购系统的设计与实现摘要企业采购系统利用计算机的数据库技术，避免和克服了人工管理信息时，劳动量大，计算和统计的不准确等种种缺陷和弊端。实现对采购业务的多层级、多角度集中管理，确保需求与采购分离，采购与决策分离。实现采购需求可追溯，采购过程可复审的全方位控制和管理。从而使采购业务全程电子化、透明化，提高采购效率、降低采购成本、提升采购品质、加强采购监督，提供强有力的支撑。因为对结构化的程序设计技术，关系型数据库建模、分析技术和对.NET开发技术有一定的了解，所以本系统采用B/S架构，基于.NET平台，采用ASP.NET和ADO.NET技术，以C#为开发语言，数据库采用MicrosoftSQLServer2005。页面设计上，采用基于WEB2.0技术的层叠样式表单技术CSS，规范HTML语言的书写，使程序界面简单美观，可维护性强，同时各浏览器的兼容性也好。解决方案：采用模块化的程序设计方法，对分模块进行功能划分，然后层层汇总整合，既便于系统功能的各种组合和修改，又便于技术维护人员补充和修改；采用关系型数据库，通过详细的需求分析和数据分析，建立正确的实体关系模型，然后创建数据库，维护数据库的稳定性和高性能。关键词：采购管理系统；B/S架构；.NET技术IIDesignandImplementationoftheenterpriseprocurementSystemAbstractEnterpriseprocurementsystemusingcomputerdatabasetechnology,avoidandovercomeartificialmanagementinformation,largeamountoflabor,calculationandstatisticalinaccuracysuchasmanydefectsandshortcomings.Toahchievetheprocurementoperationsofthemulti-level,mutil-anglecentralizedmanegement,ensurethedemandandpurchasing,procurementanddecisionofseparation.Toachievetraceabilityoftheprocurementrequirements,afullrangeofcontrolandmanegementoftheprocurementprocess.Sothattheprocurementoperationsthroughtouttheelectronic,transparency,improveprocurementefficiency,reducepurchasecost,improvequality,strengthenprocurementsupervision,providestrongsupport.Becauseofthestructuredprogramdesigntechnology,arelationaldatabasemodeling,analysistechnologyandthe.NETtechnologyhascertainknowledge,sothesystemadoptstheB/Sstructure,basedonthe.netplatform,usingASP.NETandADO.NETtechnology,C#developmentlanguage,databaseusingMicrosoftSQLServer2005.Pagedesign,WEB2.0technologybasedonthecascadingstyleformtechnologyCSS,standardHTMLlanguagewriting,maketheprograminterfaceissimpleandbeautiful,strongmaintainability,andmeanwhileeachbrowsercompatibilityofit.Solution:themodularprogrammingmethod,functionmoduletopointsregion,andthencollectlayeruponlayerintegration,convenientforvariouscombinationsofsystemfunctionandmodification,facilitateagaintechnologymaintenancepersonnelandmodifyadded;Therelationaldatabase,throughdetailedanalysisofthedemandanddataanalysis,establishingthecorrectentityrelationshipmodel,andthencreatedatabase,maintainthestabilityofthedatabaseandhighperformance.Keywords:enterpriseprocurementmanagementsystem;B/Sstructure;.NETtechnologyIII目录1前言.................................................................................11.1论文研究主要内容..................................................................11.2国内外现状........................................................................12关键技术介绍.........................................................................22.1关键性开发技术的介绍..............................................................22.1.1.NET三层架构.................................................................22.1.2.B/S体系.....................................................................33系统分析.............................................................................53.1构架概述..........................................................................53.1.1功能构架......................................................................53.1.2模块需求描述..................................................................53.1.3系统用例图....................................................................63.2系统开发环境......................................................................63.3系统任务的可行性分析..............................................................73.3.1技术可行性....................................................................74系统设计.............................................................................84.1数据库概念结构设计................................................................84.1.1实体属性描述..................................................................84.1.2企业采购管理系统E-R图.......................................................104.2数据库表设计.....................................................................114.3数据库连接.......................................................................145系统实现............................................................................165.1主要界面实现.....................................................................165.1.1登录模块界面.................................................................165.1.2修改密码界面.................................................................165.1.3用户管理界面.................................................................175.1.4单据管理界面.................................................................175.2系统代码实现.....................................................................186系统测试............................................................................206.1系统测试理论.....................................................................206.1.1测试目的.....................................................................206.1.2测试步骤.....................................................................206.1.3测试原则.....................................................................216.2企业采购系统的测试...............................................................217结论...........................................................................