摘 要
為爭奪逐漸激烈的市場競爭,企業需要更好的了解公司運作,通過有效的管理持續提高管理效率,因此,倉庫管理系統成為一個有效提高生產效率的重要途徑。
本倉庫管理系統是以杭州易利科技有限公司為實例,通過實地考察來對我國倉庫管理體系現狀獲取資料。其開發主要包括后臺數據庫的建立和維護以及前端應用程序的開發兩個方面。對于前者要求建立起數據一致性和完整性強,數據安全性好的庫。而對于后者則要求應用程序功能完備,易使用等特點。在對資料進行整理后,采用PowerBuilder 9.0為前臺開發語言,以SQL Server 2000為后臺數據庫開發的一個面向中小型企業內部的倉庫管理系統。
關鍵詞:庫存管理,庫存分析,MIS,數據庫
Abstract
Because of the gradually vigorous market, the enterprise needs to know company operation well, and improve the management rate. Therefore, warehouse management system becomes an important method that advances the product rate efficiently.
This MIS is designed based on the HangZhou YiLi Sience and Technology Ltd. The data that reflect the current situation of MIS in our country are collected through first-hand investigation. It’s development mostly include the foundation and maintenance of the database and the development of the client application program. For the former we must establish a better database, which has well data consistency and data security. For the latter we must make the program more functional and easy to be use. After the analysis of the data, we use PowerBuilder 9.0 as the foreground Programming Language and SQL Server 2000 as the background database, develop a MIS targeted to the small and medium enterprises.
Key:stockpile manage, stockpile analysis , management information system,database