Research And Development Of Oilfield Materials Price Audit Management System

Auditing on Material price is an important basic work in modern enterprise management, is the core of the enterprise costs of administration, and is an important section of the oilfield enterprise management. In 2007, the sixth oil extraction company of Daqing oilfield set up an office of price administration, responsible for the price to audit and verification. But for price audit work, the oil company and each secondary institution have no mature model or for reference.most of them can only be dealt with by handle, the manual in various documents or search relevant commodity prices on internet, judging by the audit. Such search working wasted a lot of time, the working efficiency is very low, and difficult to improve accuracy by human impact. Hence, we conducted the development of material price audit system.This paper firstly analyzes in material prices of the oilfield and audits the existing problems and the specific business process and data flow in the work, Secondly developments the oilfield in material prices audit system development, finally designs and achieves a set of meet the needs of the business Materials Price Audit Management System.In architecture, the system adopted a DotNet platform based on Web Service three-layer framework system solutions. Combined with the characteristics of the technology and Web Service three-layer framework system itself advantages, this system has clear hierarchical logic, high efficiency in development and maintenance.In function, the system firstly studies and establishes the price reference database, realized inducted the price reference data batch in the database, and solves the reference data change problem, In the database operation, the system applies the ODP.NET database visit component technology, realized the mass data import to the database the demand. Secondly, the establishment material plan database and realizes the planning data preliminary audit, all material plan carries on the price preliminary match according to the classification, makes the earlier period preparation for the later period actual material audit; Next, designs the reference price algorithm, according to certain priority to the principles and the computational method, analyzes screening from the numerous essential data, as the price is based on the use of reference; Finally realizes the price lists processing and audit work of price, the price lists with plans associated, the price audit, the result feedback and so on, completes the entire material prices audit work. In addition, In the modules of Summary report, the system applies ReportViewer development technology, Owc.Chart curve drawing component technology, These techniques in this system development have scored a good application effect.Research and development of oilfield in material price audit system, meet the needs of the project department, reached a remarkable application effect, and changed the current price audit manual search working condition, according to set good price analysis algorithm to help business personnel to be objective, and quick analyzes prices and make the business personnel from the huge amount of trivial data searching work, improves working efficiency and improve the accuracy of price auditing and timeliness rate. It better accomplishes the target of this project development.