Electricity power engineering analysis of prices data gathering system and method
Technical field
The present invention relates to a kind of electricity power engineering analysis of prices data gathering system and method.
Background technology
Shandong District analysis of prices work in 2012 relates to 355 of the projects of transmitting and converting electricity of operation altogether, and wherein city net has 245,110 of rural power grids, totally 903 of all types of sample engineering collections, nearly 100,000 data contents.
At present, it is mainly to rely on manually collect and gather calculating that constituent parts carries out analysis of prices basic data collection work, in to analysis of prices basic data collection process, need to a large amount of data collect, the processing such as statistics, computational analysis.
These information data amounts are huge, data structure is complicated, collection arranges and amount of calculation is large, the in the situation that, task short in the time being tight, data statistics work has occupied company's skill through most working time of personnel and energy, hand computation simultaneously easily causes analysis of prices result inaccurate, affect analysis of prices data accuracy, affect fairness and the science of cost horizontal analysis.
Index is that staff needs one of data to be processed, and index is constantly to change, and has brought a lot of inconvenience to the maintenance of data.
Summary of the invention
Object of the present invention is exactly in order to address the above problem, and a kind of electricity power engineering analysis of prices data gathering system and method are provided, and it has advantages of that achievement data table is very firm in follow-up upgrading and adjustment process.
To achieve these goals, the present invention adopts following technical scheme:
Electricity power engineering analysis of prices data gathering system, comprising:
User base data maintenance module, for user, department, role and resource are managed, described user management module receives calling of business data processing module;
Rich micro-file transform engine, for rich micro-file is carried out to dissection process, converts rich micro-file to the file of DataSet form or Xml form; Described rich micro-file comprises 2008 editions engineerings of cost and 2012 editions engineerings of clearing; Described rich micro-file transform engine receives calling of business data processing module;
Excel file imports and exports engine, for the parsing that imports for the Excel of xls form and xlsx form according to configuration file and the parsing of derivation; The parsing of described importing can recognize the multilayer row head of Excel, and the parsing of described derivation can generate the Excel form needing automatically, and described Excel file imports and exports engine and receives calling of business data processing module;
Data storage server, for realizing data entity mapping and data manipulation, described data storage server provides data for business data processing module, and by data information memory to oracle database, simultaneously by file information storage to document storage server;
Business data processing module, for realizing all front end pages, all kinds of configuration, Batch Processing, control skip, data entity and data manipulation, the output terminal of described business data processing module imports and exports engine and is connected with data storage server with user management module, rich micro-file transform engine, Excel file respectively;
Described business data processing module, comprising:
Engineering management module, for creating engineering, and the essential information of typing engineering;
Index is made a report on module, for typing indication information, imports index template and report form template;
Report generation module, for exporting user's form;
Configuration Manager, for managing index template and report form template.
Described engineering management module, comprising:
Create separately engineering module, support user's manual creation engineering, insert and confirm correlation engineering essential information;
Create engineering module in batches, user uses the Excel standard form that system provides to create in batches engineering;
Described index is made a report on module, comprising:
Make a report on by hand module, support user to carry out craft to engineering objective and insert and edit;
Importing standard Excel module, supports that user imports engineering objective data in batches, and import format supports that standard Excel imports index template, self-defining report form template in index template;
Import rich micro-file module, support user to import the rich micro-file of target engineering, support the project file of < 2008 editions > > of < Cost for Electric Power Engineering and the rich mirosoftware product of 2012 editions > > of < < project of transmitting and converting electricity clearing application, two cover and the Excel file that above two software is derived;
Data check module, at user's edit engineering objective, import Excel file, import after rich micro-file, system all can check and point out the manual mark data that insert or import of user, the data of verification comprise type, length, calculated relationship etc.;
Described report generation module, comprising:
Configuration data source module, for supporting user to be configured screening to the project data source of form, supports to add engineering and deletes engineering;
Custom table head module, for supporting user to customize the report heading having created, and can save as report form template;
Derive Reports module, for supporting user to export completing the form achievement that gauge outfit is confirmed and data source configures, support gauge outfit and project data to export as in the lump an Excel file;
Described Configuration Manager, comprising:
Index template management module, supports that user checks existing index template in system by list mode, and can index template be edited and be enabled;
Reports module administration module, supports user to check the report form template under existing report form template classification and each classification in system by list mode.
Oracle database, for storing data information;
Document storage server, for storage file information;
Described index template comprises several Reports modules, index template is used Excel to design preservation, by business personnel, be configured, report form template adopts the data of preserving customization row in the mode of Database corresponding data table, in system according to index template, and in tables of data, preserve corresponding record after being listed as by customization, so an index template comprises a lot of report form templates.
Described index template comprises that the explanation of filling in a form, batch import engineering template, conventional data, each specialty importing template and each speciality information;
Described each speciality information module comprises: essential information, make a report on interface, import information, extend information and check information;
Described essential information, comprises index name and data sheet field;
The described interface of making a report on, comprises index classification, index source, project type, input type, unit and makes a report on explanation; Described index classification comprises project profile, technical parameter, closes the account, budgetary estimate expense, assess a fee;
Described import information, comprises rich microdata table, rich micro-source field, rich elementary item order division and rich micro-aiming field;
Described rich microdata table comprises 2008 editions costing engineering files or derives the data table name of the DataSet forming after 2008 editions cost Excel files, 2012 editions costing engineering files of clearing or 2012 editions cost Excel document analysis of derivation;
Described rich micro-source field comprises 2008 editions costing engineering files or derives 2008 editions cost Excel files, 2012 editions costing engineering files of clearing or derive the field name of searching in the DataSet forming after 2012 editions cost Excel document analysis;
Described rich elementary item order is divided and is comprised 2008 editions costing engineering files or derive 2008 editions cost Excel files, 2012 editions costing engineering files of clearing or derive the title of searching in the DataSet forming after 2012 editions cost Excel document analysis;
Described rich micro-aiming field comprises 2008 editions costing engineering files or derives 2008 editions cost Excel files, 2012 editions costing engineering files of clearing or derive the corresponding field needing in the DataSet forming after 2012 editions cost Excel document analysis;
Described extend information, comprises hiding, read-only and can screen; Described hide refer to and while resolving, do not return to this index, and described read-only referring in index made a report on the page and index is confirmed can not edit in the page, described delete choosing be allow report generation choose engineering in choose;
Described check information, comprises verification required information, verification input type, check length, coding, calculating formula and explanation of error; Described verification input type comprises integer, decimal, character string, sequence and date; Described calculating formula adopts time, >=sum, sum, value and ratio5 kind rule; When described explanation of error shows calculating formula mistake, use, when being empty, get the last character string of index name, when not being empty, get this data.
Electricity power engineering analysis of prices method of data capture, comprises the steps:
User base data maintenance: user, department, role and resource are managed, and described user management module receives calling of business data processing module;
Rich micro-file transform engine: rich micro-file is carried out to dissection process, rich micro-file is converted to the file of DataSet form or Xml form; Described rich micro-file comprises 2008 editions engineerings of cost and 2012 editions engineerings of clearing; Described rich micro-file transform engine receives calling of business data processing module;
Excel file imports and exports engine: the parsing importing for the Excel of xls form and xlsx form according to configuration file and the parsing of derivation; The parsing of described importing can recognize the multilayer row head of Excel, and the parsing of described derivation can generate the Excel form needing automatically, and described Excel file imports and exports engine and receives calling of business data processing module;
Data storage server: realize data entity mapping and data manipulation, described data storage server provides data for business data processing module, and by data information memory to oracle database, simultaneously by file information storage to document storage server;
Business data processing module: realize all front end pages, all kinds of configuration, Batch Processing, control skip, data entity and data manipulation, the output terminal of described business data processing module imports and exports engine and is connected with data storage server with user management module, rich micro-file transform engine, Excel file respectively;
Described business data processing, comprises the steps:
Engineering management: create engineering, and the essential information of typing engineering;
Index is made a report on: typing indication information, imports index template and report form template;
Report generation: output user form;
Configuration management: index template and report form template are managed.
Described engineering management, comprises the steps:
Create separately engineering: support user's manual creation engineering, insert and confirm correlation engineering essential information;
Create engineering in batches: user uses the Excel standard form that system provides to create in batches engineering;
Described index is made a report on, and comprises the steps:
Make a report on by hand: support user to carry out craft to engineering objective and insert and edit;
Importing standard Excel: support that user imports engineering objective data in batches, import format supports that standard Excel imports index template, self-defining report form template in index template;
Import rich micro-file: support user to import the rich micro-file of target engineering, support the project file of the rich mirosoftware product of the rich micro-project of transmitting and converting electricity clearing application software of < 2008 editions > > of < Cost for Electric Power Engineering and < < 2012 editions > >, two cover and the Excel file that above two software is derived;
Data check: at user's edit engineering objective, import Excel file, import after rich micro-file, system all can check and point out the manual mark data that insert or import of user, and the data of verification comprise type, length, calculated relationship.
Described report generation, comprises the steps:
Disposition data source: support that user is configured screening to the project data source of form, support to add engineering and delete engineering;
Customization gauge outfit: support that user customizes the report heading having created, and can save as report form template;
Derive form: support user to export completing the form achievement that gauge outfit is confirmed and data source configures, support gauge outfit and project data to export as in the lump an Excel file.
Described configuration management, comprises the steps:
Index Template Manager: support that user checks existing index template in system by list mode, and can index template be edited and be enabled;
Reports module management: support user to check the report form template under existing report form template classification and each classification in system by list mode.
Oracle database, for storing data information;
Document storage server, for storage file information;
Described index template comprises several Reports modules, index template is used Excel to design preservation, by business personnel, be configured, report form template adopts the data of preserving customization row in the mode of Database corresponding data table, in system according to index template, and in tables of data, preserve corresponding record after being listed as by customization, so an index template comprises a lot of report form templates.
Described index template comprises that the explanation of filling in a form, batch import engineering template, conventional data, each specialty importing template and each speciality information;
Described each speciality information module comprises: essential information, make a report on interface, import information, extend information and check information;
Described essential information, comprises index name and data sheet field;
The described interface of making a report on, comprises index classification, index source, project type, input type, unit and makes a report on explanation; Described index classification comprises project profile, technical parameter, closes the account, budgetary estimate expense, assess a fee;
Described import information, comprises rich microdata table, rich micro-source field, rich elementary item order division and rich micro-aiming field;
Described rich microdata table comprises 2008 editions costing engineering files or derives the data table name of the DataSet forming after 2008 editions cost Excel forms, 2012 editions costing engineering files of clearing or 2012 editions cost Excel document analysis of derivation;
Described rich micro-source field comprises 2008 editions costing engineering files or derives 2008 editions cost Excel forms, 2012 editions costing engineering files of clearing or derive the field name of searching in the DataSet forming after 2012 editions cost Excel document analysis;
Described rich elementary item order is divided and is comprised 2008 editions costing engineering files or derive 2008 editions cost Excel forms, 2012 editions costing engineering files of clearing or derive the title of searching in the DataSet forming after 2012 editions cost Excel document analysis;
Described rich micro-aiming field comprises 2008 editions costing engineering files or derives 2008 editions cost Excel forms, 2012 editions costing engineering files of clearing or derive the corresponding field needing in the DataSet forming after 2012 editions cost Excel document analysis;
Described extend information, comprises hiding, read-only and can screen; Described hide refer to and while resolving, do not return to this index, and described read-only referring in index made a report on the page and index is confirmed can not edit in the page, described delete choosing be allow report generation choose engineering in choose;
Described check information, comprises verification required information, verification input type, check length, coding, calculating formula and explanation of error; Described verification input type comprises integer, decimal, character string, sequence and date; Described calculating formula adopts time, >=sum, sum, value and ratio5 kind rule; When described explanation of error shows calculating formula mistake, use, when being empty, get the last character string of index name, when not being empty, get this data.
Beneficial effect of the present invention:
1) basic database, especially index tables of data, very firm in follow-up upgrading and adjustment process.
2) by configuring flexibly and effectively, essential information and the checking information of all almost constant indexs are saved as to template file, deal with the index variation that the later stage exists.
3) by craft make a report on, Excel imports and exports and upload the modes such as rich micro-file, optimizes analysis of prices index collection mode, alleviates analysis of prices index collection work amount, improves the accuracy that analysis of prices index is collected.
4) by means such as engineering management and controls of authority, analysis of prices index collection work is shared to routine work, alleviate the workload that each electric company and relevant unit's Cost Index are collected.
5) by automatic Check on the page and verification achievement data, improve the accuracy that achievement data is collected, for analysis of prices work provide really, effectively, sample data accurately.
6) stability: native system is not having under the prerequisite of new demand, can, hardly with revising code, by the mode of adjustment index template and report form template, tackle the variation of achievement data.
7) configurability: the configuration of native system almost all adopts the mode of Excel, and which is simple and clear, and little adjustment user can oneself configure completely, alleviated the extensive work of later maintenance.Other business configuration file is all used the mode of registration table to be incorporated in the middle of system, directly covers original file, and can not restart service if the later stage need to modify in many application server cluster.
8) integrality: native system from the craft of data make a report on, the importing of data is, the aspects such as check of the derivation of data, data, guarantee that data are from collecting importings, to the integrality and the reliability that generate, and user operated to the powerful verifying function of support.
Accompanying drawing explanation
9) system adopts the mode of index template, deals with the achievement data of annual variation, by this unique identification of standard index name, realizes the unified management of index.
Accompanying drawing explanation
Fig. 1 is system architecture schematic diagram of the present invention;
Fig. 2 is that index template and report form template are related to schematic diagram;
Fig. 3 is index template schematic diagram;
Fig. 4 is that achievement data table generates process flow diagram.
Embodiment
Below in conjunction with accompanying drawing and embodiment, the invention will be further described.
As shown in Figure 1, 2, 3, electricity power engineering analysis of prices data gathering system, comprising:
User base data maintenance module, for user, department, role and resource are managed, described user management module receives calling of business data processing module;
Rich micro-file transform engine, for rich micro-file is carried out to dissection process, converts rich micro-file to the file of DataSet form or Xml form; Described rich micro-file comprises 2008 editions engineerings of cost and 2012 editions engineerings of clearing; Described rich micro-file transform engine receives calling of business data processing module;
Excel file imports and exports engine, for the parsing that imports for the Excel of xls form and xlsx form according to configuration file and the parsing of derivation; The parsing of described importing can recognize the multilayer row head of Excel, and the parsing of described derivation can generate the Excel form needing automatically, and described Excel file imports and exports engine and receives calling of business data processing module;
Data storage server, for realizing data entity mapping and data manipulation, described data storage server provides data for business data processing module, and by data information memory to oracle database, simultaneously by file information storage to document storage server;
Business data processing module, for realizing all front end pages, all kinds of configuration, Batch Processing, control skip, data entity and data manipulation, the output terminal of described business data processing module imports and exports engine and is connected with data storage server with user management module, rich micro-file transform engine, Excel file respectively;
Described business data processing module, comprising:
Engineering management module, for creating engineering, and the essential information of typing engineering;
Index is made a report on module, for typing indication information, imports index template and report form template;
Report generation module, for exporting user's form;
Configuration Manager, for managing index template and report form template.
Described engineering management module, comprising:
Create separately engineering module, support user's manual creation engineering, insert and confirm correlation engineering essential information;
Create engineering module in batches, user uses the Excel standard form that system provides to create in batches engineering;
Described index is made a report on module, comprising:
Make a report on by hand module, support user to carry out craft to engineering objective and insert and edit;
Importing standard Excel module, supports that user imports engineering objective data in batches, and import format supports that standard Excel imports index template, self-defining report form template in index template;
Import rich micro-file module, support user to import the rich micro-file of target engineering, support the project file of < 2008 editions > > of < Cost for Electric Power Engineering and the rich mirosoftware product of 2012 editions > > of < < project of transmitting and converting electricity clearing application, two cover and the Excel file that above two software is derived;
Data check module, at user's edit engineering objective, import Excel file, import after rich micro-file, system all can check and point out the manual mark data that insert or import of user, the data of verification comprise type, length, calculated relationship etc.;
Described report generation module, comprising:
Configuration data source module, for supporting user to be configured screening to the project data source of form, supports to add engineering and deletes engineering;
Custom table head module, for supporting user to customize the report heading having created, and can save as report form template;
Derive Reports module, for supporting user to export completing the form achievement that gauge outfit is confirmed and data source configures, support gauge outfit and project data to export as in the lump an Excel file;
Described Configuration Manager, comprising:
Index template management module, supports that user checks existing index template in system by list mode, and can index template be edited and be enabled;
Reports module administration module, supports user to check the report form template under existing report form template classification and each classification in system by list mode.
Oracle database, for storing data information;
Document storage server, for storage file information;
Described index template comprises several Reports modules, index template is used Excel to design preservation, by business personnel, be configured, report form template adopts the data of preserving customization row in the mode of Database corresponding data table, in system according to index template, and in tables of data, preserve corresponding record after being listed as by customization, so an index template comprises a lot of report form templates.
Described index template comprises that the explanation of filling in a form, batch import engineering template, conventional data, each specialty importing template and each speciality information;
Described each speciality information module comprises: essential information, make a report on interface, import information, extend information and check information;
Described essential information, comprises index name and data sheet field;
The described interface of making a report on, comprises index classification, index source, project type, input type, unit and makes a report on explanation; Described index classification comprises project profile, technical parameter, closes the account, budgetary estimate expense, assess a fee;
Described import information, comprises rich microdata table, rich micro-source field, rich elementary item order division and rich micro-aiming field;
Described rich microdata table comprises 2008 editions costing engineering files or derives the data table name of the DataSet forming after 2008 editions cost Excel files, 2012 editions costing engineering files of clearing or 2012 editions cost Excel document analysis of derivation;
Described rich micro-source field comprises 2008 editions costing engineering files or derives 2008 editions cost Excel files, 2012 editions costing engineering files of clearing or derive the field name of searching in the DataSet forming after 2012 editions cost Excel document analysis;
Described rich elementary item order is divided and is comprised 2008 editions costing engineering files or derive 2008 editions cost Excel files, 2012 editions costing engineering files of clearing or derive the title of searching in the DataSet forming after 2012 editions cost Excel document analysis;
Described rich micro-aiming field comprises 2008 editions costing engineering files or derives 2008 editions cost Excel files, 2012 editions costing engineering files of clearing or derive the corresponding field needing in the DataSet forming after 2012 editions cost Excel document analysis;
Described extend information, comprises hiding, read-only and can screen; Described hide refer to and while resolving, do not return to this index, and described read-only referring in index made a report on the page and index is confirmed can not edit in the page, described delete choosing be allow report generation choose engineering in choose;
Described check information, comprises verification required information, verification input type, check length, coding, calculating formula and explanation of error; Described verification input type comprises integer, decimal, character string, sequence and date; Described calculating formula adopts time, >=sum, sum, value and ratio5 kind rule; When described explanation of error shows calculating formula mistake, use, when being empty, get the last character string of index name, when not being empty, get this data.
Electricity power engineering analysis of prices method of data capture, comprises the steps:
User base data maintenance: user, department, role and resource are managed, and described user management module receives calling of business data processing module;
Rich micro-file transform engine: rich micro-file is carried out to dissection process, rich micro-file is converted to the file of DataSet form or Xml form; Described rich micro-file comprises 2008 editions engineerings of cost and 2012 editions engineerings of clearing; Described rich micro-file transform engine receives calling of business data processing module;
Excel file imports and exports engine: the parsing importing for the Excel of xls form and xlsx form according to configuration file and the parsing of derivation; The parsing of described importing can recognize the multilayer row head of Excel, and the parsing of described derivation can generate the Excel form needing automatically, and described Excel file imports and exports engine and receives calling of business data processing module;
Data storage server: realize data entity mapping and data manipulation, described data storage server provides data for business data processing module, and by data information memory to oracle database, simultaneously by file information storage to document storage server;
Business data processing module: realize all front end pages, all kinds of configuration, Batch Processing, control skip, data entity and data manipulation, the output terminal of described business data processing module imports and exports engine and is connected with data storage server with user management module, rich micro-file transform engine, Excel file respectively;
Described business data processing, comprises the steps:
Engineering management: create engineering, and the essential information of typing engineering;
Index is made a report on: typing indication information, imports index template and report form template;
Report generation: output user form;
Configuration management: index template and report form template are managed.
Described engineering management, comprises the steps:
Create separately engineering: support user's manual creation engineering, insert and confirm correlation engineering essential information;
Create engineering in batches: user uses the Excel standard form that system provides to create in batches engineering;
Described index is made a report on, and comprises the steps:
Make a report on by hand: support user to carry out craft to engineering objective and insert and edit;
Importing standard Excel: support that user imports engineering objective data in batches, import format supports that standard Excel imports index template, self-defining report form template in index template;
Import rich micro-file: support user to import the rich micro-file of target engineering, support the project file of < 2008 editions > > of < Cost for Electric Power Engineering and the rich mirosoftware product of 2012 editions > > of < < project of transmitting and converting electricity clearing application, two cover and the Excel file that above two software is derived;
Data check: at user's edit engineering objective, import Excel file, import after rich micro-file, system all can check and point out the manual mark data that insert or import of user, and the data of verification comprise type, length, calculated relationship.
Described report generation, comprises the steps:
Disposition data source: support that user is configured screening to the project data source of form, support to add engineering and delete engineering;
Customization gauge outfit: support that user customizes the report heading having created, and can save as report form template;
Derive form: support user to export completing the form achievement that gauge outfit is confirmed and data source configures, support gauge outfit and project data to export as in the lump an Excel file.
Described configuration management, comprises the steps:
Index Template Manager: support that user checks existing index template in system by list mode, and can index template be edited and be enabled;
Reports module management: support user to check the report form template under existing report form template classification and each classification in system by list mode.
Oracle database, for storing data information;
Document storage server, for storage file information;
Described index template comprises several Reports modules, index template is used Excel to design preservation, by business personnel, be configured, report form template adopts the data of preserving customization row in the mode of Database corresponding data table, in system according to index template, and in tables of data, preserve corresponding record after being listed as by customization, so an index template comprises a lot of report form templates.
Described index template comprises that the explanation of filling in a form, batch import engineering template, conventional data, each specialty importing template and each speciality information;
Described each speciality information module comprises: essential information, make a report on interface, import information, extend information and check information;
Described essential information, comprises index name and data sheet field;
The described interface of making a report on, comprises index classification, index source, project type, input type, unit and makes a report on explanation; Described index classification comprises project profile, technical parameter, closes the account, budgetary estimate expense, assess a fee;
Described import information, comprises rich microdata table, rich micro-source field, rich elementary item order division and rich micro-aiming field;
Described rich microdata table comprises 2008 editions costing engineering files or derives the data table name of the DataSet forming after 2008 editions cost Excel forms, 2012 editions costing engineering files of clearing or 2012 editions cost Excel document analysis of derivation;
Described rich micro-source field comprises 2008 editions costing engineering files or derives 2008 cost Excel forms, clearing 2012 costing engineering files or derive the field name of searching in the DataSet forming after 2012 editions cost Excel document analysis;
Described rich elementary item order is divided and is comprised 2008 editions costing engineering files or derive 2008 editions cost Excel forms, 2012 editions costing engineering files of clearing or derive the title of searching in the DataSet forming after 2012 editions cost Excel document analysis;
Described rich micro-aiming field comprises 2008 editions costing engineering files or derives 2008 editions cost Excel forms, 2012 editions costing engineering files of clearing or derive the corresponding field needing in the DataSet forming after 2012 editions cost Excel document analysis;
Described extend information, comprises hiding, read-only and can screen; Described hide refer to and while resolving, do not return to this index, and described read-only referring in index made a report on the page and index is confirmed can not edit in the page, described delete choosing be allow report generation choose engineering in choose;
Described check information, comprises verification required information, verification input type, check length, coding, calculating formula and explanation of error; Described verification input type comprises integer, decimal, character string, sequence and date; Described calculating formula adopts time, >=sum, sum, value and ratio5 kind rule; When described explanation of error shows calculating formula mistake, use, when being empty, get the last character string of index name, when not being empty, get this data.
Described rich micro-file refers to and uses the 2008 editions > > of power industry product < < Cost for Electric Power Engineering of Jiangxi Bowei New Technology Co., Ltd. or the clearing of < < project of transmitting and converting electricity to apply the budgetary estimate of 2012 editions > > software programming electricity power engineerings, settlement data file.
2008 editions engineerings of described cost have referred to use the electricity power engineering budgetary estimate data file of 2008 editions > > software programmings of Jiangxi Bowei New Technology Co., Ltd.'s power industry product < < Cost for Electric Power Engineering.
2012 editions engineerings of described clearing have referred to use the project of transmitting and converting electricity final account for completed project report file of 2012 editions > > software programmings of the power industry product < < of Jiangxi Bowei New Technology Co., Ltd. project of transmitting and converting electricity clearing application.
As shown in Figure 4,
Step (1):
Excel document analysis goes out general DataTable: according to Excel, import and export engine and Excel file can be converted to the general DataTable that has index name;
2008 editions costing engineering files or 2012 editions clearing project files, by resolving, parse interim XML file; Interim XML file further generates general DataSet;
2008 editions cost Excel files or 2012 editions clearing Excel files, by configuration rule, read corresponding tables of data, then, by the read method of Excel, data are temporarily first read out, and parse interim DataSet file; Interim DataSet file, by configuration rule, converts interim DataSet to the discernible generation of system general DataSet;
Step (2):
General DataTable and index template write interim importing table: when importing to temporary table, have how many indexs, just import how many indexs, and classify when representing according to index template;
General DataSet and index template write interim importing table;
Step (3): the interim table that imports generates achievement data table.
Although above-mentioned, by reference to the accompanying drawings the specific embodiment of the present invention is described; but be not limiting the scope of the invention; one of ordinary skill in the art should be understood that; on the basis of technical scheme of the present invention, those skilled in the art do not need to pay various modifications that creative work can make or distortion still in protection scope of the present invention.