CN104077665B - Electricity power engineering analysis of prices data gathering system and method - Google Patents
Electricity power engineering analysis of prices data gathering system and method Download PDFInfo
- Publication number
- CN104077665B CN104077665B CN201410327839.6A CN201410327839A CN104077665B CN 104077665 B CN104077665 B CN 104077665B CN 201410327839 A CN201410327839 A CN 201410327839A CN 104077665 B CN104077665 B CN 104077665B
- Authority
- CN
- China
- Prior art keywords
- file
- data
- engineering
- excel
- editions
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 230000005611 electricity Effects 0.000 title claims abstract description 23
- 238000000034 method Methods 0.000 title claims abstract description 23
- 238000004458 analytical method Methods 0.000 title claims abstract description 22
- 230000008676 import Effects 0.000 claims abstract description 81
- 238000012545 processing Methods 0.000 claims abstract description 50
- 238000009795 derivation Methods 0.000 claims abstract description 29
- 238000006243 chemical reaction Methods 0.000 claims abstract description 17
- 230000008569 process Effects 0.000 claims abstract description 13
- 238000012423 maintenance Methods 0.000 claims abstract description 12
- 238000002224 dissection Methods 0.000 claims abstract description 7
- 238000007726 management method Methods 0.000 claims description 28
- 238000012795 verification Methods 0.000 claims description 22
- 238000013500 data storage Methods 0.000 claims description 15
- 238000012216 screening Methods 0.000 claims description 6
- 238000013461 design Methods 0.000 claims description 5
- 230000008859 change Effects 0.000 description 4
- 238000010586 diagram Methods 0.000 description 3
- 238000013481 data capture Methods 0.000 description 2
- 238000013480 data collection Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000008901 benefit Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 238000010205 computational analysis Methods 0.000 description 1
- 239000000470 constituent Substances 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 238000007689 inspection Methods 0.000 description 1
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses electricity power engineering analysis of prices data gathering system and method; Comprise user base data maintenance module, for managing user, department, role and resource, described user management module receives calling of business data processing module; Rich micro-file conversion engine, for carrying out dissection process to rich micro-file, becomes the file of DataSet form or Xml form by rich micro-file transform; Described rich micro-file comprises cost 2008 editions engineerings and clearing 2012 editions engineerings; Described rich micro-file conversion engine receives calling of business data processing module; Excel file imports and exports engine, for carrying out the parsing of parsing and the derivation imported for the Excel of xls form and xlsx form according to configuration file; The parsing of described importing can recognize the multilayer row head of Excel, and the parsing of described derivation can generate the Excel form of needs automatically, and described Excel file imports and exports calling of engine accepts business data processing module; Achievement data table of the present invention is very firm in follow-up upgrading and adjustment process.
Description
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 the project of transmitting and converting electricity 355 of operation altogether, and wherein city net has 245, rural power grids 110, all types of sample engineering collection totally 903, nearly 100,000 data contents.
At present, constituent parts carries out analysis of prices basic data collection work and mainly relies on manual collection and gather calculating, needs in analysis of prices basic data collection process to collect a large amount of data, adds up, the process such as computational analysis.
These information data amounts are huge, data structure is complicated, collection arranges and amount of calculation is large,, task short in the time is tight, data statistics work occupies company's skill through personnel's most working time 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 moment change, brings a lot of inconvenience to the maintenance of data.
Summary of the invention
Object of the present invention is exactly that provide a kind of electricity power engineering analysis of prices data gathering system and method, it has achievement data table advantage very firm in follow-up upgrading and adjustment process in order to solve the problem.
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 managing user, department, role and resource, described user management module receives calling of business data processing module;
Rich micro-file conversion engine, for carrying out dissection process to rich micro-file, becomes the file of DataSet form or Xml form by rich micro-file transform; Described rich micro-file comprises cost 2008 editions engineerings and clearing 2012 editions engineerings; Described rich micro-file conversion engine receives calling of business data processing module;
Excel file imports and exports engine, for carrying out the parsing of parsing and the derivation imported for the Excel of xls form and xlsx form according to configuration file; The parsing of described importing can recognize the multilayer row head of Excel, and the parsing of described derivation can generate the Excel form of needs automatically, and described Excel file imports and exports calling of engine accepts business data processing module;
Data storage server, map and data manipulation for realizing data entity, 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 page, all kinds of configuration, Batch Processing, control skip, data entity and data manipulation, the output terminal of described business data processing module is respectively with user management module, rich micro-file conversion engine, Excel file imports and exports engine and data storage server is connected;
Described business data processing module, comprising:
Engineering management module, for creating engineering, and the essential information of typing engineering;
Index makes a report on module, for typing indication information, imports indicator template and report form template;
Report generation module, for exporting user's form;
Configuration Manager, for managing indicator template and report form template.
Described engineering management module, comprising:
Independent establishment engineering module, supports user's manual creation engineering, inserts and confirm correlation engineering essential information;
Batch creates engineering module, and the Excel standard form batch that user uses system to provide creates engineering;
Described index makes a report on module, comprising:
Make a report on module by hand, support that user carries out craft to engineering objective and inserts and edit;
Importing standard Excel module, supports that user's batch imports engineering objective data, and import format supports standard Excel importing indicator template, self-defining report form template in indicator template;
Import rich micro-file module, support that user imports purpose project and wins micro-file, support the Excel file that the project file of " Cost for Electric Power Engineering 2008 editions " and the rich mirosoftware product of " project of transmitting and converting electricity clearing application 2012 editions " two cover and above two software are derived;
Data check module, after user's edit engineering objective, importing Excel file, the rich micro-file of importing, system all can check the manual mark data inserted or import of user and point out, and the data of verification comprise type, length, calculated relationship etc.;
Described report generation module, comprising:
Configuration data source module, for supporting that the project data source of user to form is configured screening, supports add engineering and delete engineering;
Custom table head module, for supporting that user customizes the report heading created, and can save as report form template;
Deriving Reports module, for supporting that user exports completing the form achievement that gauge outfit confirms and data source configures, supporting gauge outfit and project data to export as an Excel file in the lump;
Described Configuration Manager, comprising:
Indicator template administration module, supports that user checks existing indicator template in system by list mode, and can edit indicator template and enable;
Reports module administration module, supports that user checks existing report form template classification and the report form template under respectively classifying in system by list mode.
Oracle database, for storing data information;
Document storage server, for storage file information;
Described indicator template comprises several Reports modules, indicator template uses Excel to carry out design and preserves, be configured by business personnel, report form template adopts the data of preserving customization row in the mode of Database corresponding data table, in systems in which according to indicator template, and by preserving corresponding record after customization row in tables of data, so an indicator template comprises a lot of report form templates.
Described indicator template comprises explanation of filling in a form, batch imports engineering template, conventional data, each specialty import 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;
Describedly make a report on interface, comprise index classification, index source, project type, input type, unit and make 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 micro-item dividing and rich micro-aiming field;
Described rich microdata table comprises 2008 editions costing engineering files or derives 2008 editions cost Excel file, clearing 2012 editions costing engineering files or derive the data table name that 2012 editions cost Excel file resolve the rear DataSet formed;
The field name searched in the DataSet that described rich micro-source field is formed after comprising 2008 editions costing engineering files or deriving 2008 editions cost Excel file, clearing 2012 editions costing engineering files or derivation 2012 editions cost Excel file parsings;
The title of searching in the DataSet that described rich micro-item dividing is formed after comprising 2008 editions costing engineering files or deriving 2008 editions cost Excel file, clearing 2012 editions costing engineering files or derivation 2012 editions cost Excel file parsings;
The corresponding field needed in the DataSet that described rich micro-aiming field is formed after comprising 2008 editions costing engineering files or deriving 2008 editions cost Excel file, clearing 2012 editions costing engineering files or derivation 2012 editions cost Excel file parsings;
Described extend information, comprises hiding, read-only and can screen; Described hiding when referring to parsing does not return this index, and described read-only referring to makes a report on the page and index confirms can not edit in the page in index, and described to delete choosing be allow to choose choosing in engineering of report generation;
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; Use during described explanation of error display calculating formula mistake, when for time empty, get the last character string of index name, in time 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, described user management module receives calling of business data processing module;
Rich micro-file conversion engine: carry out dissection process to rich micro-file, becomes the file of DataSet form or Xml form by rich micro-file transform; Described rich micro-file comprises cost 2008 editions engineerings and clearing 2012 editions engineerings; Described rich micro-file conversion engine receives calling of business data processing module;
Excel file imports and exports engine: the parsing carrying out parsing and the derivation imported according to configuration file for the Excel of xls form and xlsx form; The parsing of described importing can recognize the multilayer row head of Excel, and the parsing of described derivation can generate the Excel form of needs automatically, and described Excel file imports and exports calling of engine accepts business data processing module;
Data storage server: realize data entity and map 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 page, all kinds of configuration, Batch Processing, control skip, data entity and data manipulation, the output terminal of described business data processing module is respectively with user management module, rich micro-file conversion engine, Excel file imports and exports engine and data storage server is connected;
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 indicator template and report form template;
Report generation: export user's form;
Configuration management: indicator template and report form template are managed.
Described engineering management, comprises the steps:
Independent establishment engineering: support user's manual creation engineering, insert and confirm correlation engineering essential information;
Batch creates engineering: the Excel standard form batch that user uses system to provide creates engineering;
Described index is made a report on, and comprises the steps:
Make a report on by hand: support that user carries out craft to engineering objective and inserts and edit;
Importing standard Excel: support that user's batch imports engineering objective data, import format supports standard Excel importing indicator template, self-defining report form template in indicator template;
Import rich micro-file: support that user imports purpose project and wins micro-file, support the Excel file that the project file of " Cost for Electric Power Engineering 2008 editions " and " rich micro-project of transmitting and converting electricity clearing application software 2012 editions " rich mirosoftware product of two covers and above two software are derived;
Data check: after user's edit engineering objective, importing Excel file, the rich micro-file of importing, system all can check the manual mark data inserted or import of user and point out, and the data of verification comprise type, length, calculated relationship.
Described report generation, comprises the steps:
Disposition data source: support that the project data source of user to form is configured screening, supports add engineering and delete engineering;
Customization gauge outfit: support that user customizes the report heading created, and can report form template be saved as;
Derive form: supporting that user exports completing the form achievement that gauge outfit confirms and data source configures, supporting gauge outfit and project data to export as an Excel file in the lump.
Described configuration management, comprises the steps:
Indicator template manages: support that user checks existing indicator template in system by list mode, and can edit indicator template and enable;
Reports module manages: support that user checks existing report form template classification and the report form template under respectively classifying in system by list mode.
Oracle database, for storing data information;
Document storage server, for storage file information;
Described indicator template comprises several Reports modules, indicator template uses Excel to carry out design and preserves, be configured by business personnel, report form template adopts the data of preserving customization row in the mode of Database corresponding data table, in systems in which according to indicator template, and by preserving corresponding record after customization row in tables of data, so an indicator template comprises a lot of report form templates.
Described indicator template comprises explanation of filling in a form, batch imports engineering template, conventional data, each specialty import 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;
Describedly make a report on interface, comprise index classification, index source, project type, input type, unit and make 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 micro-item dividing and rich micro-aiming field;
Described rich microdata table comprises 2008 editions costing engineering files or derives 2008 editions cost Excel forms, clearing 2012 editions costing engineering files or derive the data table name that 2012 editions cost Excel file resolve the rear DataSet formed;
The field name searched in the DataSet that described rich micro-source field is formed after comprising 2008 editions costing engineering files or deriving 2008 editions cost Excel forms, clearing 2012 editions costing engineering files or derivation 2012 editions cost Excel file parsings;
The title of searching in the DataSet that described rich micro-item dividing is formed after comprising 2008 editions costing engineering files or deriving 2008 editions cost Excel forms, clearing 2012 editions costing engineering files or derivation 2012 editions cost Excel file parsings;
The corresponding field needed in the DataSet that described rich micro-aiming field is formed after comprising 2008 editions costing engineering files or deriving 2008 editions cost Excel forms, clearing 2012 editions costing engineering files or derivation 2012 editions cost Excel file parsings;
Described extend information, comprises hiding, read-only and can screen; Described hiding when referring to parsing does not return this index, and described read-only referring to makes a report on the page and index confirms can not edit in the page in index, and described to delete choosing be allow to choose choosing in engineering of report generation;
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; Use during described explanation of error display calculating formula mistake, when for time empty, get the last character string of index name, in time 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, the essential information of all almost constant indexs and checking information being saved as template file, dealing with the index change of later stage existence.
3) by manual to make a report on, Excel imports and exports and uploads the modes such as rich micro-file, optimize analysis of prices index collection mode, alleviate analysis of prices index collection work amount, improve the accuracy that analysis of prices index is collected.
4) by the means such as engineering management and control of authority, analysis of prices index collection work is shared in routine work, alleviate the workload of each electric company and relevant unit's Cost Index collection.
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, can hardly with amendment code under the prerequisite not having new demand, by the mode of adjustment index template and report form template, the change of reply 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, alleviates the extensive work of later maintenance.Other business configuration file all uses the mode of registration table to be incorporated in the middle of system, if the later stage needs to modify directly cover original file, and can not restart service when many application server cluster.
8) integrality: the aspects such as native system is made a report on from the craft of data, the importing of data, the derivation of data, the inspection of data, ensures that data are from collecting importings, to the integrality of generation and reliability, and supporting powerful verifying function to user operation.
Accompanying drawing explanation
9) system adopts the mode of indicator template, deals with the achievement data of annual change, by this unique identification of specification 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 indicator template and report form template relation schematic diagram;
Fig. 3 is indicator template schematic diagram;
Fig. 4 is achievement data table product process figure.
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 managing user, department, role and resource, described user management module receives calling of business data processing module;
Rich micro-file conversion engine, for carrying out dissection process to rich micro-file, becomes the file of DataSet form or Xml form by rich micro-file transform; Described rich micro-file comprises cost 2008 editions engineerings and clearing 2012 editions engineerings; Described rich micro-file conversion engine receives calling of business data processing module;
Excel file imports and exports engine, for carrying out the parsing of parsing and the derivation imported for the Excel of xls form and xlsx form according to configuration file; The parsing of described importing can recognize the multilayer row head of Excel, and the parsing of described derivation can generate the Excel form of needs automatically, and described Excel file imports and exports calling of engine accepts business data processing module;
Data storage server, map and data manipulation for realizing data entity, 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 page, all kinds of configuration, Batch Processing, control skip, data entity and data manipulation, the output terminal of described business data processing module is respectively with user management module, rich micro-file conversion engine, Excel file imports and exports engine and data storage server is connected;
Described business data processing module, comprising:
Engineering management module, for creating engineering, and the essential information of typing engineering;
Index makes a report on module, for typing indication information, imports indicator template and report form template;
Report generation module, for exporting user's form;
Configuration Manager, for managing indicator template and report form template.
Described engineering management module, comprising:
Independent establishment engineering module, supports user's manual creation engineering, inserts and confirm correlation engineering essential information;
Batch creates engineering module, and the Excel standard form batch that user uses system to provide creates engineering;
Described index makes a report on module, comprising:
Make a report on module by hand, support that user carries out craft to engineering objective and inserts and edit;
Importing standard Excel module, supports that user's batch imports engineering objective data, and import format supports standard Excel importing indicator template, self-defining report form template in indicator template;
Import rich micro-file module, support that user imports purpose project and wins micro-file, support the Excel file that the project file of " Cost for Electric Power Engineering 2008 editions " and the rich mirosoftware product of " project of transmitting and converting electricity clearing application 2012 editions " two cover and above two software are derived;
Data check module, after user's edit engineering objective, importing Excel file, the rich micro-file of importing, system all can check the manual mark data inserted or import of user and point out, and the data of verification comprise type, length, calculated relationship etc.;
Described report generation module, comprising:
Configuration data source module, for supporting that the project data source of user to form is configured screening, supports add engineering and delete engineering;
Custom table head module, for supporting that user customizes the report heading created, and can save as report form template;
Deriving Reports module, for supporting that user exports completing the form achievement that gauge outfit confirms and data source configures, supporting gauge outfit and project data to export as an Excel file in the lump;
Described Configuration Manager, comprising:
Indicator template administration module, supports that user checks existing indicator template in system by list mode, and can edit indicator template and enable;
Reports module administration module, supports that user checks existing report form template classification and the report form template under respectively classifying in system by list mode.
Oracle database, for storing data information;
Document storage server, for storage file information;
Described indicator template comprises several Reports modules, indicator template uses Excel to carry out design and preserves, be configured by business personnel, report form template adopts the data of preserving customization row in the mode of Database corresponding data table, in systems in which according to indicator template, and by preserving corresponding record after customization row in tables of data, so an indicator template comprises a lot of report form templates.
Described indicator template comprises explanation of filling in a form, batch imports engineering template, conventional data, each specialty import 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;
Describedly make a report on interface, comprise index classification, index source, project type, input type, unit and make 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 micro-item dividing and rich micro-aiming field;
Described rich microdata table comprises 2008 editions costing engineering files or derives 2008 editions cost Excel file, clearing 2012 editions costing engineering files or derive the data table name that 2012 editions cost Excel file resolve the rear DataSet formed;
The field name searched in the DataSet that described rich micro-source field is formed after comprising 2008 editions costing engineering files or deriving 2008 editions cost Excel file, clearing 2012 editions costing engineering files or derivation 2012 editions cost Excel file parsings;
The title of searching in the DataSet that described rich micro-item dividing is formed after comprising 2008 editions costing engineering files or deriving 2008 editions cost Excel file, clearing 2012 editions costing engineering files or derivation 2012 editions cost Excel file parsings;
The corresponding field needed in the DataSet that described rich micro-aiming field is formed after comprising 2008 editions costing engineering files or deriving 2008 editions cost Excel file, clearing 2012 editions costing engineering files or derivation 2012 editions cost Excel file parsings;
Described extend information, comprises hiding, read-only and can screen; Described hiding when referring to parsing does not return this index, and described read-only referring to makes a report on the page and index confirms can not edit in the page in index, and described to delete choosing be allow to choose choosing in engineering of report generation;
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; Use during described explanation of error display calculating formula mistake, when for time empty, get the last character string of index name, in time 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, described user management module receives calling of business data processing module;
Rich micro-file conversion engine: carry out dissection process to rich micro-file, becomes the file of DataSet form or Xml form by rich micro-file transform; Described rich micro-file comprises cost 2008 editions engineerings and clearing 2012 editions engineerings; Described rich micro-file conversion engine receives calling of business data processing module;
Excel file imports and exports engine: the parsing carrying out parsing and the derivation imported according to configuration file for the Excel of xls form and xlsx form; The parsing of described importing can recognize the multilayer row head of Excel, and the parsing of described derivation can generate the Excel form of needs automatically, and described Excel file imports and exports calling of engine accepts business data processing module;
Data storage server: realize data entity and map 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 page, all kinds of configuration, Batch Processing, control skip, data entity and data manipulation, the output terminal of described business data processing module is respectively with user management module, rich micro-file conversion engine, Excel file imports and exports engine and data storage server is connected;
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 indicator template and report form template;
Report generation: export user's form;
Configuration management: indicator template and report form template are managed.
Described engineering management, comprises the steps:
Independent establishment engineering: support user's manual creation engineering, insert and confirm correlation engineering essential information;
Batch creates engineering: the Excel standard form batch that user uses system to provide creates engineering;
Described index is made a report on, and comprises the steps:
Make a report on by hand: support that user carries out craft to engineering objective and inserts and edit;
Importing standard Excel: support that user's batch imports engineering objective data, import format supports standard Excel importing indicator template, self-defining report form template in indicator template;
Import rich micro-file: support that user imports purpose project and wins micro-file, support the Excel file that the project file of " Cost for Electric Power Engineering 2008 editions " and the rich mirosoftware product of " project of transmitting and converting electricity clearing application 2012 editions " two cover and above two software are derived;
Data check: after user's edit engineering objective, importing Excel file, the rich micro-file of importing, system all can check the manual mark data inserted or import of user and point out, and the data of verification comprise type, length, calculated relationship.
Described report generation, comprises the steps:
Disposition data source: support that the project data source of user to form is configured screening, supports add engineering and delete engineering;
Customization gauge outfit: support that user customizes the report heading created, and can report form template be saved as;
Derive form: supporting that user exports completing the form achievement that gauge outfit confirms and data source configures, supporting gauge outfit and project data to export as an Excel file in the lump.
Described configuration management, comprises the steps:
Indicator template manages: support that user checks existing indicator template in system by list mode, and can edit indicator template and enable;
Reports module manages: support that user checks existing report form template classification and the report form template under respectively classifying in system by list mode.
Oracle database, for storing data information;
Document storage server, for storage file information;
Described indicator template comprises several Reports modules, indicator template uses Excel to carry out design and preserves, be configured by business personnel, report form template adopts the data of preserving customization row in the mode of Database corresponding data table, in systems in which according to indicator template, and by preserving corresponding record after customization row in tables of data, so an indicator template comprises a lot of report form templates.
Described indicator template comprises explanation of filling in a form, batch imports engineering template, conventional data, each specialty import 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;
Describedly make a report on interface, comprise index classification, index source, project type, input type, unit and make 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 micro-item dividing and rich micro-aiming field;
Described rich microdata table comprises 2008 editions costing engineering files or derives 2008 editions cost Excel forms, clearing 2012 editions costing engineering files or derive the data table name that 2012 editions cost Excel file resolve the rear DataSet formed;
Described rich micro-source field comprises 2008 editions costing engineering files or derives 2008 cost Excel forms, settles accounts 2012 costing engineering files or derive 2012 editions cost Excel file resolves the field name searched in the rear DataSet formed;
The title of searching in the DataSet that described rich micro-item dividing is formed after comprising 2008 editions costing engineering files or deriving 2008 editions cost Excel forms, clearing 2012 editions costing engineering files or derivation 2012 editions cost Excel file parsings;
The corresponding field needed in the DataSet that described rich micro-aiming field is formed after comprising 2008 editions costing engineering files or deriving 2008 editions cost Excel forms, clearing 2012 editions costing engineering files or derivation 2012 editions cost Excel file parsings;
Described extend information, comprises hiding, read-only and can screen; Described hiding when referring to parsing does not return this index, and described read-only referring to makes a report on the page and index confirms can not edit in the page in index, and described to delete choosing be allow to choose choosing in engineering of report generation;
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; Use during described explanation of error display calculating formula mistake, when for time empty, get the last character string of index name, in time not being empty, get this data.
Described rich micro-file refers to and uses Jiangxi Bowei New Technology Co., Ltd.'s power industry product " Cost for Electric Power Engineering 2008 editions " or " project of transmitting and converting electricity clearing application 2012 editions " software programming electricity power engineering budgetary estimate, settlement data file.
Described cost 2008 editions engineerings refer to the electricity power engineering budgetary estimate data file employing Jiangxi Bowei New Technology Co., Ltd.'s power industry product " Cost for Electric Power Engineering 2008 editions " software programming.
Described clearing 2012 editions engineerings refer to the project of transmitting and converting electricity final account for completed project report file employing Jiangxi Bowei New Technology Co., Ltd.'s power industry product " project of transmitting and converting electricity clearing application 2012 editions " software programming.
As shown in Figure 4,
Step (1):
Excel file parses general DataTable: import and export engine according to Excel and Excel file can be converted to the general DataTable that there is index name;
2008 editions costing engineering files or 2012 editions clearing project files, by resolving, parse interim XML file; Interim XML file generates general DataSet further;
2008 editions cost Excel file or 2012 editions clearing Excel file, by configuration rule, read corresponding tables of data, then by the read method of Excel, data are temporarily first read out, parse interim DataSet file; Interim DataSet, by configuration rule, is converted to the DataSet that the discernible generation of system is general by interim DataSet file;
Step (2):
General DataTable and indicator template write and import table temporarily: when importing to temporary table, there are how many indexs, just import how many indexs, and classify when representing according to indicator template;
General DataSet and indicator template write and import table temporarily;
Step (3): the interim table that imports generates achievement data table.
By reference to the accompanying drawings the specific embodiment of the present invention is described although above-mentioned; but 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 amendment or distortion that creative work can make still within protection scope of the present invention.
Claims (4)
1. electricity power engineering analysis of prices data gathering system, is characterized in that, comprising:
User base data maintenance module, for managing user, department, role and resource, described user base data maintenance module receives calling of business data processing module;
Rich micro-file conversion engine, for carrying out dissection process to rich micro-file, becomes the file of DataSet form or Xml form by rich micro-file transform; Described rich micro-file comprises cost 2008 editions engineerings and clearing 2012 editions engineerings; Described rich micro-file conversion engine receives calling of business data processing module;
Excel file imports and exports engine, for carrying out the parsing of parsing and the derivation imported for the Excel of xls form and xlsx form according to configuration file; The parsing of described importing can recognize the multilayer row head of Excel, and the parsing of described derivation can generate the Excel form of needs automatically, and described Excel file imports and exports calling of engine accepts business data processing module;
Data storage server, map and data manipulation for realizing data entity, 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 page, all kinds of configuration, Batch Processing, control skip, data entity and data manipulation, the output terminal of described business data processing module is respectively with user base data maintenance module, rich micro-file conversion engine, Excel file imports and exports engine and data storage server is connected;
Described business data processing module, comprising:
Engineering management module, for creating engineering, and the essential information of typing engineering;
Index makes a report on module, for typing indication information, imports indicator template and report form template;
Report generation module, for exporting user's form;
Configuration Manager, for managing indicator template and report form template;
Described report generation module, comprising:
Configuration data source module, for supporting that the project data source of user to form is configured screening, supports add engineering and delete engineering;
Custom table head module, for supporting that user customizes the report heading created, and saves as report form template;
Derive Reports module, for supporting that user exports completing the form achievement that gauge outfit confirms and data source configures,
Gauge outfit and project data is supported to export as an Excel file in the lump;
Described Configuration Manager, comprising:
Indicator template administration module, supports that user checks existing indicator template in system by list mode, and edits indicator template and enable;
Reports module administration module, supports that user checks existing report form template classification and the report form template under respectively classifying in system by list mode;
Described indicator template comprises several Reports modules, indicator template uses Excel to carry out design and preserves, be configured by business personnel, report form template adopts the data of preserving customization row in the mode of Database corresponding data table, in systems in which according to indicator template, and by preserving corresponding record after customization row in tables of data;
Described indicator template comprises explanation of filling in a form, batch imports engineering template, conventional data, each specialty import 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;
Describedly make a report on interface, comprise index classification, index source, project type, input type, unit and make 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 micro-item dividing and rich micro-aiming field;
Described rich microdata table comprises 2008 editions costing engineering files or derives 2008 editions cost Excel file, clearing 2012 editions costing engineering files or derive the data table name that 2012 editions cost Excel file resolve the rear DataSet formed;
The field name searched in the DataSet that described rich micro-source field is formed after comprising 2008 editions costing engineering files or deriving 2008 editions cost Excel file, clearing 2012 editions costing engineering files or derivation 2012 editions cost Excel file parsings;
The title of searching in the DataSet that described rich micro-item dividing is formed after comprising 2008 editions costing engineering files or deriving 2008 editions cost Excel file, clearing 2012 editions costing engineering files or derivation 2012 editions cost Excel file parsings;
The corresponding field needed in the DataSet that described rich micro-aiming field is formed after comprising 2008 editions costing engineering files or deriving 2008 editions cost Excel file, clearing 2012 editions costing engineering files or derivation 2012 editions cost Excel file parsings;
Described extend information, comprises hiding, read-only and can screen; Described hiding when referring to parsing does not return this index, and described read-only referring to makes a report on the page and index confirms can not edit in the page in index, and described to delete choosing be allow to choose choosing in engineering of report generation;
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; Use during described explanation of error display calculating formula mistake, when for time empty, get the last character string of index name, in time not being empty, get this data.
2. electricity power engineering analysis of prices data gathering system as claimed in claim 1, it is characterized in that, described engineering management module, comprising:
Independent establishment engineering module, supports user's manual creation engineering, inserts and confirm correlation engineering essential information;
Batch creates engineering module, and the Excel standard form batch that user uses system to provide creates engineering;
Described index makes a report on module, comprising:
Make a report on module by hand, support that user carries out craft to engineering objective and inserts and edit;
Importing standard Excel module, supports that user's batch imports engineering objective data, and import format supports standard Excel importing indicator template, self-defining report form template in indicator template;
Import rich micro-file module, support that user imports purpose project and wins micro-file, support the Excel file that the project file of " Cost for Electric Power Engineering 2008 editions " and the rich mirosoftware product of " project of transmitting and converting electricity clearing application 2012 editions " two cover and above two software are derived;
Data check module, after user's edit engineering objective, importing Excel file, the rich micro-file of importing, system all can check the manual mark data inserted or import of user and point out, and the data of verification comprise type, length, calculated relationship.
3. the system as described in above-mentioned arbitrary claim the method applied, it is characterized in that, comprise the steps:
User base data maintenance: user, department, role and resource are managed, user base data maintenance step receives calling of business data processing step;
Rich micro-file transform: carry out dissection process to rich micro-file, becomes the file of DataSet form or Xml form by rich micro-file transform; Described rich micro-file comprises cost 2008 editions engineerings and clearing 2012 editions engineerings; Rich micro-file transform step receives calling of business data processing step;
Excel file imports and exports: the parsing carrying out parsing and the derivation imported according to configuration file for the Excel of xls form and xlsx form; The parsing of described importing can recognize the multilayer row head of Excel, and the parsing of described derivation can generate the Excel form of needs automatically, and Excel file imports and exports step and receives calling of business data processing step;
Data store: realize data entity map and data manipulation, for business data processing module provides data, and by data information memory to oracle database, simultaneously by file information storage to document storage server;
Business data processing: realize all front end page, all kinds of configuration, Batch Processing, control skip, data entity and data manipulation;
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 indicator template and report form template;
Report generation: export user's form;
Configuration management: indicator template and report form template are managed;
Described report generation, comprises the steps:
Disposition data source: support that the project data source of user to form is configured screening, supports add engineering and delete engineering;
Customization gauge outfit: support that user customizes the report heading created, and save as report form template;
Derive form: supporting that user exports completing the form achievement that gauge outfit confirms and data source configures, supporting gauge outfit and project data to export as an Excel file in the lump;
Described configuration management, comprises the steps:
Indicator template manages: support that user checks existing indicator template in system by list mode, and edit indicator template and enable;
Reports module manages: support that user checks existing report form template classification and the report form template under respectively classifying in system by list mode.
4. method as claimed in claim 3, it is characterized in that, described engineering management, comprises the steps:
Independent establishment engineering: support user's manual creation engineering, insert and confirm correlation engineering essential information;
Batch creates engineering: the Excel standard form batch that user uses system to provide creates engineering;
Described index is made a report on, and comprises the steps:
Make a report on by hand: support that user carries out craft to engineering objective and inserts and edit;
Importing standard Excel: support that user's batch imports engineering objective data, import format supports standard Excel importing indicator template, self-defining report form template in indicator template;
Import rich micro-file: support that user imports purpose project and wins micro-file, support the Excel file that the project file of " Cost for Electric Power Engineering 2008 editions " and the rich mirosoftware product of " project of transmitting and converting electricity clearing application 2012 editions " two cover and above two software are derived;
Data check: after user's edit engineering objective, importing Excel file, the rich micro-file of importing, system all can check the manual mark data inserted or import of user and point out, and the data of verification comprise type, length, calculated relationship.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410327839.6A CN104077665B (en) | 2014-07-10 | 2014-07-10 | Electricity power engineering analysis of prices data gathering system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410327839.6A CN104077665B (en) | 2014-07-10 | 2014-07-10 | Electricity power engineering analysis of prices data gathering system and method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104077665A CN104077665A (en) | 2014-10-01 |
| CN104077665B true CN104077665B (en) | 2016-04-06 |
Family
ID=51598910
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410327839.6A Active CN104077665B (en) | 2014-07-10 | 2014-07-10 | Electricity power engineering analysis of prices data gathering system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104077665B (en) |
Families Citing this family (30)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105225076B (en) * | 2015-11-12 | 2020-10-23 | 国网宁夏电力公司经济技术研究院 | Cost analysis data acquisition and processing system |
| CN105446945B (en) * | 2015-12-01 | 2017-12-01 | 广东电网有限责任公司电网规划研究中心 | Word marks report-generating method |
| CN105373864A (en) * | 2015-12-09 | 2016-03-02 | 国网四川省电力公司遂宁供电公司 | Rural power grid design method |
| CN105975473A (en) * | 2016-01-19 | 2016-09-28 | 北京匡恩网络科技有限责任公司 | Customized trend analysis subsystem |
| CN107480111B (en) * | 2016-06-07 | 2019-11-22 | 福建福昕软件开发股份有限公司 | A kind of interconnection document makes a report on method automatically |
| CN106648763A (en) * | 2016-12-06 | 2017-05-10 | 明博教育科技股份有限公司 | Batch data importing component and importing method thereof |
| CN106845930B (en) * | 2016-12-30 | 2020-04-24 | 宁波贤晟信息技术有限公司 | Customs declaration data processing system |
| CN106709671A (en) * | 2017-02-16 | 2017-05-24 | 广东华联软件科技有限公司 | Construction cost index dynamization establishment method and dynamic index system |
| CN106933791A (en) * | 2017-03-10 | 2017-07-07 | 山东浪潮云服务信息科技有限公司 | One kind generation license method and device |
| CN106940839B (en) * | 2017-03-13 | 2020-11-24 | 中国南方电网有限责任公司超高压输电公司 | Power transmission and transformation project quality data management and control system and method |
| CN107240011B (en) * | 2017-04-19 | 2021-07-06 | 中国建设银行股份有限公司 | Index configuration processing method and system |
| CN107122473A (en) * | 2017-05-02 | 2017-09-01 | 山东浪潮通软信息科技有限公司 | A kind of lead-in and lead-out method and device of Excel data |
| CN107436928B (en) * | 2017-07-12 | 2021-05-18 | 国网山东省电力公司经济技术研究院 | Measuring price through-flow method of transformer substation engineering |
| CN107527185B (en) * | 2017-08-04 | 2020-11-20 | 昆明理工大学 | Parallel implementation method for compiling and examining construction project cost file |
| CN107871004A (en) * | 2017-11-14 | 2018-04-03 | 国家电网公司 | A kind of power distribution network analysis of prices management system |
| CN108121691A (en) * | 2017-11-23 | 2018-06-05 | 国家电网公司 | Manage the method and system of project of transmitting and converting electricity bill of quantities |
| CN107944731A (en) * | 2017-12-04 | 2018-04-20 | 国网河北省电力公司经济技术研究院 | The method for building up and device of typical project cost template |
| CN108694512A (en) * | 2018-05-30 | 2018-10-23 | 国网山东省电力公司经济技术研究院 | A kind of power grid analysis of prices data in-depth processing system and method |
| CN109086970A (en) * | 2018-07-06 | 2018-12-25 | 武汉瑞莱保能源技术有限公司 | A kind of field operation regulation electronization solution |
| CN109086403B (en) * | 2018-08-01 | 2022-03-15 | 徐工集团工程机械有限公司 | Classified user-oriented dynamic creating method for three-dimensional electronic random file |
| CN109241501A (en) * | 2018-08-15 | 2019-01-18 | 北京北信源信息安全技术有限公司 | Document analysis method and apparatus |
| CN109472481A (en) * | 2018-10-31 | 2019-03-15 | 广东电网有限责任公司 | A kind of mesolow distribution engineering overall process stream compression method and device |
| CN109634964B (en) * | 2018-12-13 | 2022-06-14 | 深圳市航建工程造价咨询有限公司 | Cost index database management system |
| CN109784689B (en) * | 2018-12-28 | 2022-03-15 | 远光软件股份有限公司 | Power grid infrastructure project report data processing method |
| CN109857799A (en) * | 2019-01-29 | 2019-06-07 | 国网物资有限公司 | The automatic auditing system of tender price and method |
| CN111159993B (en) * | 2019-12-25 | 2023-09-01 | 江苏方天电力技术有限公司 | Automatic analysis and report generation system platform for power transformation mobile operation card |
| CN111242505B (en) * | 2020-01-23 | 2023-07-25 | 厦门海迈科技股份有限公司 | Configurable and grouping comparison type engineering cost index analysis method and system |
| CN111401014A (en) * | 2020-03-12 | 2020-07-10 | 山东浪潮通软信息科技有限公司 | Multi-index multi-dimensional analysis method, system and construction method based on report |
| CN111221454A (en) * | 2020-04-21 | 2020-06-02 | 广东电网有限责任公司东莞供电局 | Power grid service data processing method, device, equipment and storage medium |
| CN111898356B (en) * | 2020-07-20 | 2021-07-16 | 昆明海巍科技有限公司 | Engineering cost analysis method and system for reducing repeated workload |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101221564A (en) * | 2007-08-03 | 2008-07-16 | 哈尔滨工程大学 | Universal independent data acquisition method |
| CN103699966A (en) * | 2013-04-12 | 2014-04-02 | 国家电网公司 | Multidimensional overall-process data control system and control method based on user requirement |
| CN103838740A (en) * | 2012-11-21 | 2014-06-04 | 方欣科技有限公司 | Report engine method |
-
2014
- 2014-07-10 CN CN201410327839.6A patent/CN104077665B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101221564A (en) * | 2007-08-03 | 2008-07-16 | 哈尔滨工程大学 | Universal independent data acquisition method |
| CN103838740A (en) * | 2012-11-21 | 2014-06-04 | 方欣科技有限公司 | Report engine method |
| CN103699966A (en) * | 2013-04-12 | 2014-04-02 | 国家电网公司 | Multidimensional overall-process data control system and control method based on user requirement |
Non-Patent Citations (1)
| Title |
|---|
| 《电建行业工程量清单报价软件的应用》;张琦等;《电网技术》;20070630;第31卷;第176-178页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104077665A (en) | 2014-10-01 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104077665B (en) | Electricity power engineering analysis of prices data gathering system and method | |
| CN106815340B (en) | Storage archives electronization batch processing method and system in power marketing business | |
| US9390391B2 (en) | System and method for benchmarking environmental data | |
| CN105225076B (en) | Cost analysis data acquisition and processing system | |
| CN101719119A (en) | Report management system and method | |
| CN104899143A (en) | Software peer review system realizing device for providing DM (Data Mining) | |
| CN105590165A (en) | Implementation method for converting business data into electronic file | |
| CN111143282A (en) | Accounting data archiving processing method, device and controller | |
| CN107122961A (en) | Excel nested report data processing methods based on SAP system | |
| US10963423B2 (en) | Generating and identifying distinct portions of a merged file | |
| CN104679736A (en) | Translation system allowing statistics of simple mistakes | |
| CN116303641B (en) | Laboratory report management method supporting multi-data source visual configuration | |
| CN111178026A (en) | Method for realizing operation analysis report of special line for collecting passenger | |
| CN204087467U (en) | A kind of monitoring system based on engineering survey | |
| CN115587098A (en) | Method and system for intelligently identifying chart data | |
| CN110597899B (en) | Project expense management method and system | |
| CN115310944A (en) | Online ledger management method, system, device and medium | |
| CN114818642A (en) | Dynamic filling method for data report | |
| CN114372104A (en) | Electronic file metadata acquisition tool and method with good compatibility | |
| CN108596555A (en) | A kind of information directly reports management system | |
| CN105095225A (en) | Method and apparatus for obtaining file data | |
| CN102310950B (en) | Experiment intelligent interpretation system and method | |
| CN114003774A (en) | A big data information collection system of electric power for wisdom city | |
| CN110515955A (en) | Storage, querying method, system, electronic equipment and the storage medium of data | |
| CN110990636A (en) | Intelligent data module acquisition and conversion method for diesel engine interactive electronic technical manual |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB03 | Change of inventor or designer information |
Inventor after: Liu Hongzhi Inventor after: Jin Shudong Inventor after: Li Yan Inventor after: Wang Wei Inventor after: Wei Xuelin Inventor after: Liu Xiang Inventor after: Jia Shanjie Inventor after: Fan Hairong Inventor after: Li Hong Inventor after: Tu Qingbo Inventor after: Gao Huawei Inventor after: Li Yimei Inventor after: Li Jingwen Inventor after: Han Yanfeng Inventor after: Wang Xiaoyan Inventor before: Tu Qingbo Inventor before: Liu Xiang Inventor before: Fan Hairong Inventor before: Li Hong Inventor before: Gao Huawei Inventor before: Liu Hongzhi Inventor before: Han Yanfeng Inventor before: Jin Shudong Inventor before: Li Yan Inventor before: Wei Xuelin |
|
| COR | Change of bibliographic data | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |