基于.NET的订单驱动进销存管理系统  

Order-Driven Inventory Management System Based on .NET

作　　者：陈然[1] 黄劼[1] 曾力[1] 杨艳[1] 

机构地区：[1]四川大学制造学院,四川成都610065

出　　处：《计算机技术与发展》2011年第4期202-205,209,共5页Computer Technology and Development

基　　金：四川省科技计划项目基金(2008SC0024)

摘　　要：订单驱动进销存管理系统是基于订单实现计划生产、合理调度、顺畅销售而建立的电子商务应用系统。除了能够根据订单产生相应的库存信息和生产计划之外,它还有按要求查询、分类盘点、打印单据等功能。本系统用Microsoft SQL Server 2000做后台数据库,以VB.NET2005作为前台程序的开发工具,在数据库和VB.NET之间采用ADO控件实现数据库和操作程序的无缝连接,并利用Visual Studio 2005自带的Crystalreports生成打印报表。多条件查询、平行筛选、筛选条件互驱动与数据库结合产生了更灵活的数据组合方式。本系统更好地促进了生产销售的进行,有效地解决当前企业存在的信息化不足、机密性准确性差、工作效率低落、仓库管理很不合理、不能及时根据需要调整库存等一系列的问题。Order-driven inventory management system is an e-commerce application based on the orders to achieve planned production,rational management and smooth sales.In addition to a corresponding inventory according to the order information and production schemes,it also has the functions of required query,sorting inventory,print invoices and so on.The system uses Microsoft SQL Server 2000 as database,and VB.NET 2005 as program development tools.SQL and VB.NET uses ADO between the database and operating procedures to achieve seamless connectivity,Crystalreports in Visual Studio 2005 is used to generate printed reports.The system promotes the sales and conduct of the production and it solves a range of issues of the short of information,inadequate of the confidentiality and veracity,low work efficiency,unreasonable inventory management and so on.

关 键 词：订单驱动 进销存管理系统 多条件查询 平行筛选 筛选条件互驱动 

分 类 号：TP302.1[自动化与计算机技术—计算机系统结构]