基于NET的企业进销存管理系统的设计与实现

本科生毕业设计摘要传统企业的管理模式大部分主要还是采用手工记账的模式，其管理效率比较低。随着社会的发展，人们的消费能力在提高，企业进货、销售和库存的信息量将会非常庞大。如果能对这些数据进行统计分析，对商品的进销存进行全面的管理，将会给企业管理带来很大的帮助。针对企业用手工完成进销存管理存在处理速度慢和容易出错等问题，本系统设计出集进货管理、销售管理、库存管理为一体的，基本上满足中小企业的进销存管理体统。本系统采用C#.NET作为开发环境，选用SQLServer2008数据库为平台，采用三层架构中的隔离驱动模式，充分考虑到实际操作中出现的各种情况，结合计算机容量大、记忆力强和处理速度快等优点，在提高公司管理效率的同时，增加了毛利的计算，也为进销存管理系统的设计与应用提供了借鉴意义。本文所设计的进销存管理系统，界面友好，操作方便、功能完整，使得企业管理合理规范，最大限度的满足了用户的需要。关键词：进销存管理；SQLServer数据库；C#.NET；隔离驱动模式ABSTRACTThetraditionalenterprisemanagementmodeandmostofthemajorortheuseofmanualaccountingmode,themanagementefficiencyisrelativelylow.Withthedevelopmentofsociety,people'sconsumptionabilityinraising,enterprisepurchase,salesandinventoryinformationwillbeverylarge.Iftheenergyofthesedataforstatisticalanalysis,tothecommodityInvoicingcomprehensivemanagement,willbeofgreathelptotheenterprisemanagement.InviewoftheenterprisewithcompletemanuallyInvoicingmanagementexistencetheprocessingspeedisslowandpronetoerrorandotherproblems,thesystemdesignasetofstockmanagement,salesmanagement,inventorymanagementasawhole,basicallysatisfiesthesmallandmedium-sizedenterprisesInvoicingmanagementsystem.ThissystemusesC#.NETasadevelopmentenvironment,usingSQLServer2008databaseasaplatform,thethreelayerarchitectureofisolationdrivenpattern,givefullconsiderationtotheactualoperationoccursinavarietyofsituations,combinedwithcomputercapacity,strongmemoryandprocessingspeed,toimprovemanagementefficiencyatthesametime,increasetheprofitcalculation,alsoforInvoicingmanagementsystemdesignandapplicationtoofferdrawlessonsfromameaning.ThedesignoftheInvoicingmanagementsystem,friendlyinterface,convenientoperation,completefunctions,themanagementofenterpriseshasareasonablestandard,tomaximizethesatisfactionofuserneeds.Keywords：inventorymanagement;SQLServer;C#.NET;isolationdrivenpattern.目录1绪论.................................................................................................................11.1课题的研究背景...................................................................................11.2课题研究意义.......................................................................................11.3本课题主要研究内容...........................................................................21.4本文的结构安排...................................................................................22开发的相关技术.............................................................................................42.1.NET框架..............................................................................................42.1.1.NET框架介绍...........................................................................42.2.2.NET编译技术...........................................................................52.2ADO.NET技术.....................................................................................62.2.1ADO.NET介绍.........................................................................62.2.2ADO.NET中的主要对象..........................................................62.2.3用ADO.NET连接SQLServer数据库...................................72.3隔离驱动模式.......................................................................................82.4开发工具介绍.......................................................................................82.4.1SQLServer2008数据库系统....................................................82.4.2C#编程语言................................................................................92.4.3VisualStudio2010工具软件介绍.............................................93系统功能的架构与设计...............................................................................123.1系统功能描述.....................................................................................123.1.1系统总体功能结构..................................................................123.1.2系统功能实现流程..................................................................143.2数据库设计.........................................................................................153.2.1业务逻辑编码规则..................................................................153.2.2数据库创建..............................................................................163.2.3数据库逻辑结构设计..............................................................163.2.4数据表逻辑关系......................................................................213.3VisualStudio2010的设计..................................................................223.3.1VisualStudio2010项目的创建...............................................223.3.2添加模块..................................................................................233.3.3系统窗体汇总表......................................................................244系统功能模块实现.......................................................................................274.1用户登录模块的实现.........................................................................274.2系统主窗体.........................................................................................284.3进货模块的实现.................................................................................294.3.1进货单与退货单...................................................................