Design And Implementation Of Material Management System For Shanghai Power Cable Engineering Company

Shanghai Power Cable Engineering Company keeps on expanding its business scale and competition advantage, and pays on-going attention to long-term management informationization construction. The company's business character is using project management as basic business running module, and putting projects'highly efficient running as its core target. This material management system development and implementation is an important part of the company's new era business management strategy, and will provide more effective informational tool for the company's project running management.This engineering material management system is a matching software sub-system with the company's engineering project transaction management system, and provides aid support for engineering projects on material and equipment asset management. The system's main business functions include material basic information management function, material plan management function, engineering material design and inspection management function, engineering material check-out and return management function, and equipment/asset information computing management function. Based on the above basic function requirement, this paper discusses the system's demand analysis, design and implementation, from the view of software development. It describes the software's function demand and user case modules, builds software structure design scenario, and then gives detailed discussion to some main modules'design and internal transaction processing units, such as material plan type management module, material operation type management module, and equipment asset type management module, etc. It also gives the system's database design and database chart samples. Finally, it describes programming implementation and testing of all the main modules both on server-end and client-end.This software is programmed by C# and Oracle database. It has been finished test, and is in trial running status using real engineering projects'data. The trial running proves this software's ability in managing the global information of the enterprise's engineering material plan, material inventory and the equipments timely and precisely, well reaching it s development objectives.