基于.NET的订单驱动进销存管理系统-《计算机技术与发展》

文章信息/Info

Author(s):: CHEN Ran; HUANG Jie; ZENG Li; YANG Yan; Manufacture Science School in Sichuan University

Keywords:: order-driven; inventory management system; multi-condition query; parallel filtration; filtrating condition mutual drive

摘要:: 订单驱动进销存管理系统是基于订单实现计划生产、合理调度、顺畅销售而建立的电子商务应用系统。除了能够根据订单产生相应的库存信息和生产计划之外,它还有按要求查询、分类盘点、打印单据等功能。本系统用Microsoft SQL Server 2000做后台数据库,以VB.NET2005作为前台程序的开发工具,在数据库和VB.NET之间采用ADO控件实现数据库和操作程序的无缝连接,并利用Visual Studio 2005自带的Crystalreports生成打印报表。多条件查询、平行筛选、筛选条件互驱动与数据库结合产生了更灵活的数据组合方式。本系统更好地促进了生产销售的进行,有效地解决当前企业存在的信息化不足、机密性准确性差、工作效率低落、仓库管理很不合理、不能及时根据需要调整库存等一系列的问题

Abstract:: 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