vs2008+microsoft sql server进销存系统设计文档.doc

PAGE PAGE 3 目录 摘要········································································1 目录········································································1 引言········································································1 系统分析·································································2 需求分析·····························································2 可行性分析····························································2 总体设计··································································2 项目规划······························································2 系统功能结构··························································3 详细设计·································································4 系统登录设计··························································4 进货单································································4 月销售状况····························································5 库存状况······························································5 库存盘点······························································6 参考文献··································································6 系统业务流程图···························································7 0 引言 中小企业在我国经济发展中具有重要地位，目前我国的中小企业数量较多、地区分布广泛、行业分布跨度大，随着全球经济一体化的发展及中国加入WTO，中小企业将面临外资企业和国外产品与服务的严峻挑战，比较而言，外资企业具有更为雄厚的资金实力、丰富的管理经验和先进的技术手段，因此，如果我国的中小企业不借助先进的管理思想转变经营观念、使用信息化提高企业的管理水平和工作效率，将很难在今后的国际竞争中取胜。然而企业管理在很多方面、很大程度上都必须借助信息化来完成，而我国中小企业的信息化水平还很低，与外资企业相比，还处于起步阶段。 随着技术发展，电脑操作及管理日趋简化，电脑知识日趋普及，同时市场经济快速多变，竞争激烈，因此企业采用电脑管理进货、库存、销售等诸多环节也成为趋势及必然。  1 系统分析 需求分析 根据企业对进销存管理的要求，制定进销存管理系统目标如下： 由于操作人员的计算机知识有限，因此要求系统具有良好的人机交互界面 如果系统的使用对象较多，则要求有较好的权限管理 方便的数据查询，支持多条件查询 批量填写进货单及销售单 与代理商和供应商往来账目明细，绝不存在假账、漏帐、差帐等情况 图表分析月销售状况 当外界环境(停电、网络病毒)干扰时，系统可以自动保护原始数据的安全 在相应的权限下，删除数据方便简单、数据稳定性强 数据计算自动完成，尽量减少人工干预 可行性分析 本系统后台数据库采用目前比较流行的Microsoft SQL Server，该数据库系统在安全性、准确性、运行速度方面有绝对的优势并且处理数据库量大，效率高；前台采用Microsoft公司的Visual Studio 2008 作为主要的开发工具，其可与SQL Server数据库无缝链接。  总体设计 项目规划 进销存管理系统具体规划如下： 进货管理模块 该模块主要负责商品的进货数据录入、进货退