广西工学院 计算机科学与技术 2011界毕业论文
广西工学院
毕业设计说明书
课题名称 电脑销售管理系统实现
系 别 计算机工程系 专 业 计算机科学与技术 班 级 学 号 姓 名 指导教师
职 称 教 授
2011年 6 月 2日
广西工学院 计算机科学与技术 2011界毕业论文
目录
摘要................................................................................................................................ I ABSTRACT....................................................................................................................... II 引言................................................................................................................................ 1 1.可行性分析................................................................................................................ 2 1.1技术可行性............................................................................................................. 2 1.2经济可行性............................................................................................................. 2 1.3操作可行性............................................................................................................. 2 2.系统需求分析............................................................................................................ 3 2.1需求分析................................................................................................................. 3 2.1.1系统功能描述....................................................................................................... 3 2.1.2业务流程图........................................................................................................... 4 2.1.3数据流图............................................................................................................... 6 2.1.4系统..................................................................................................................... 11 2.1.5基本信息............................................................................................................. 11 2.1.6客户..................................................................................................................... 12 2.1.7进货管理............................................................................................................. 13 2.1.8销售管理............................................................................................................. 14 2.1.9库存管理............................................................................................................. 15 2.1.10系统页面........................................................................................................... 16 2.2用例图................................................................................................................... 16 2.3性能需求............................................................................................................... 17 2.4环境需求............................................................................................................... 18 3.总体设计.................................................................................................................. 19 3.1设计概要............................................................................................................... 19 3.2系统设计：........................................................................................................... 19 3.4软件结构............................................................................................................... 20 3.5数据库设计........................................................................................................... 21 3.5.1数据库实体关系图............................................................................................. 22 3.5.2数据库逻辑结构设计......................................................................................... 22 4系统实现................................................................................................................... 26 4.1登录模块实现........................................................................................................ 26 4.2系统模块实现........................................................................................................ 27 4.3信息模块实现........................................................................................................ 29 4.4客户模块的实现.................................................................................................... 30 4.5进货管理模块实现................................................................................................ 32 4.6售管理模块的实现................................................................................................ 34 4.7库存管理模块的实现............................................................................................ 35
广西工学院 计算机科学与技术 2011界毕业论文
4.8系统主页面............................................................................................................ 37 5.系统测试.................................................................................................................. 38 5.1测试环境和工具.................................................................................................... 38 5.2测试方法................................................................................................................ 39 5.3测试用例................................................................................................................ 40 6.系统维护.................................................................................................................. 42 7.结论.......................................................................................................................... 43 致谢.............................................................................................................................. 44 参考文献...................................................................................................................... 44
广西工学院 计算机科学与技术 2011界毕业论文
摘要
趋于激烈的市场竞争，销售商不断提高业务处理效率、和信息处理速度，及时、正确的掌握市场需求。由于业务量的不断扩展，传统的手工管理方式已无法满足管理者的需求，造成业务管理混乱、财务账目不请，工作效率低下等问题，从而影响企业发展。
本网站系统是基于C#和SQL Server 2005数据库平台下设计和实现的。整个系统主要是完成了公司的进货和销售这两个环节，系统界面主要有：系统，基本信息，客户，进货管理，销售管理，库存管理，销售报告，库存状况等功能。本系统实现了管理人员对公司进货和销售这两个环节的管理需求，能够快速反映出商品的进、销、存等状况，从而节省了大量的人力、物力，改善了员工的工作条件，减轻了劳动强度。
本系统是以Visual Studio 2008和SQL Server 2005作为开发工具。 关键字：C# SQL Server ADO.net
I
广西工学院 计算机科学与技术 2011界毕业论文
Abstract
Tend to fierce competition in the market, sellers constantly improve business processing efficiency, and information processing speed, timely, accurate grasp the market demand. Due to the expansion of business, the traditional manual management mode has failed to meet the demand, causing business managers financial records management confusion, don't please, low productivity issues, thus influence enterprise development.
This website system is based on c # and SQL Server 2005 database design and implementation of lans. The whole system is mainly completed a company purchase and sales the two link, system interface basically has: system, basic information, customer, purchase management, sales management, inventory management, sales reports, inventory status, and other functions. This system realizes the management personnel of a company purchase and sales the two link management requirements, can quickly reflect commodity import and sales and stock, which saves state such as much manpower and material resources, improve the staff's working condition, reduce labor intensity.
This system based on Visual Studio 2008 and SQL Server 2005 as a development tool.
Keywords: C# SQL Server ADO.net
II