Design And Implentation Of Material Purchasing Information Query System For Daqing Oilfield

Material purchasing is an important part in production management work, improve the quality of Material purchasing, lower procurement cost, is the smoothly safeguard for the production management and project construction of oilfield. The annual cost of the Material purchasing expanding gradually and have now reached 200 million yuan. If the purchase cost reduced by one percentage point, every year can save 2 million yuan, in order to further reduce procurement cost and operation cost, excavating the materials purchase management potential deeply, executing the "sunshine purchase" in Daqing oilfield, strengthening the transparency of material purchasing price, it is very necessary to establish a set of material purchasing information platform.This system is not only meets various needs of the business department, but also provide a control and decision-making tools to the enterprise's management layer and the decision-making layer. Using the advanced information technology and network technology for the development of unified network platform, the system may divide the groups of inquiring permission to the end user, thus giving full play to functions of information collection, processing and analysis, then provide convenient and accurate materials information service for customers by the Web platform.This system use ASP.NET for developing the client System, Oracle10g for the server-side database, and B/S (Browser/Server) three layers of technical architecture as the architecture of the system. The system includes two parts. The first part is daqing oilfield material purchasing decision support system, which consist of six function module: material supply price inquire, dept public price inquire, purchasing contract information inquire, supplier information inquire, material prices statistical analysis, system management and maintenance. The second part is the not shortlisted supplier management website, which consist of free login, release manufacturer supplier qualification, related product price, attribute and other information.Because of using modular idea and a unified programming model, the system has a unified user interface and easy to maintain and manage, which will help promote the applicability of it. The System is subordinate to the main domain of Petro China, so the Daqing Oilfield could manage and unify that easily, it will be facilely to consolidated it to the Petro China system, and the user's authority can be assigned and managed. The system achieved complete data sharing and data automatic updates.Based on the existing material information system platform, the system is created to build decision support system module, analysis the price trend of material procurement and optimize management of materials procurement. So that can assist management to supervise the procurement of goods and materials better, to further improve the quality and cost-effective of material procurement.The successful implementing of the system in the enterprise, reduces procurement costs, improves operational efficiency and management performance. It lay a foundation for the enterprises to enhance their market competitiveness and the capability to meet rapid response of market, according the system the enterprise's data query, real-time monitoring and scientific decision-making are come true, it also promote the modernization of management of the enterprise.