[go: up one dir, main page]

CN108171484A - Collecting device assets generate system and method - Google Patents

Collecting device assets generate system and method Download PDF

Info

Publication number
CN108171484A
CN108171484A CN201810084051.5A CN201810084051A CN108171484A CN 108171484 A CN108171484 A CN 108171484A CN 201810084051 A CN201810084051 A CN 201810084051A CN 108171484 A CN108171484 A CN 108171484A
Authority
CN
China
Prior art keywords
asset
data
capital increase
equipment
generation
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.)
Pending
Application number
CN201810084051.5A
Other languages
Chinese (zh)
Inventor
邵佳佳
王�琦
金卫圣
王卓欣
吴晨
邓序之
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
State Grid Shanghai Electric Power Co Ltd
Original Assignee
State Grid Shanghai Electric Power Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by State Grid Shanghai Electric Power Co Ltd filed Critical State Grid Shanghai Electric Power Co Ltd
Priority to CN201810084051.5A priority Critical patent/CN108171484A/en
Publication of CN108171484A publication Critical patent/CN108171484A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/10Office automation; Time management
    • G06Q10/103Workflow collaboration or project management
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23Updating
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q50/00Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
    • G06Q50/06Energy or water supply

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Theoretical Computer Science (AREA)
  • Strategic Management (AREA)
  • General Physics & Mathematics (AREA)
  • Human Resources & Organizations (AREA)
  • Physics & Mathematics (AREA)
  • Economics (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Tourism & Hospitality (AREA)
  • Marketing (AREA)
  • General Business, Economics & Management (AREA)
  • Databases & Information Systems (AREA)
  • Health & Medical Sciences (AREA)
  • General Health & Medical Sciences (AREA)
  • Primary Health Care (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Water Supply & Treatment (AREA)
  • Public Health (AREA)
  • Software Systems (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

本发明公开了一种采集设备资产生成系统,其包含:数据存储模块,用于存储已完成资产生成的增资单所对应的台账Excel电子表格、资产卡片Excel电子表格、增资单Excel电子表格;所述的资产卡片Excel电子表格包含资产编号和设备编号信息;数据采集模块,用于采集新的增资单数据;资产生成模块,用于根据数据库规则对新的增资单数据进行资产生成,并将该已完成资产生成的新的增资单数据以及生成的相应资产编号和设备编号更新到数据存储模块中的各Excel电子表格中;所述的资产生成包含资产编号和设备编号的生成。其优点是:自动实现资产卡片生成,代替人工制作方式,实现高效率、高可靠、批量化的制作,有效提升了工作质量。

The invention discloses a collection equipment asset generation system, which comprises: a data storage module, which is used to store the ledger Excel electronic form, the asset card Excel electronic form, and the capital increase form Excel electronic form corresponding to the completed capital increase form; The described asset card Excel electronic form contains asset number and equipment number information; the data collection module is used to collect new capital increase sheet data; the asset generation module is used to generate assets according to database rules for new capital increase sheet data, and The new capital increase form data generated by the completed asset and the generated corresponding asset number and equipment number are updated to each Excel spreadsheet in the data storage module; the asset generation includes the generation of the asset number and the equipment number. Its advantages are: automatically realize the generation of asset cards, replace manual production methods, realize high-efficiency, high-reliability, and batch production, and effectively improve the quality of work.

Description

采集设备资产生成系统及方法Collection equipment asset generation system and method

技术领域technical field

本发明涉及用电信息采集技术领域,具体涉及一种采集设备资产生成系统及方法。The invention relates to the technical field of electricity consumption information collection, in particular to a collection equipment asset generation system and method.

背景技术Background technique

用电信息采集系统是针对电力客户的实时用电信息,集采集、应用、管理功能于一体的综合平台,运用通信技术、计算机技术和自动控制技术,可对电力负荷进行监控、管理的综合系统;其功能包括负荷控制、远方自动抄表、预购电、防窃电、低压集抄等。The power consumption information collection system is a comprehensive platform for real-time power consumption information of power customers, integrating collection, application and management functions. It uses communication technology, computer technology and automatic control technology to monitor and manage power loads. ; Its functions include load control, remote automatic meter reading, pre-purchased electricity, anti-stealing electricity, low-voltage centralized reading, etc.

用电信息采集系统当中的集中器、大用户终端和台区总表属于供电公司的固定资产,需要根据固定资产有关情况的变化,及时更新、完善固定资产卡片相关实物信息。资产卡片上包含了工程名称、工程账号、设备名称、成本中心、单位、数量等等的信息。日常工作中,资产卡片都是以Excel电子表格的形式制作并存放在电脑中。近年,部分公司采用德国SAP公司的ERP系统来开展固定资产卡片管理、资产增减变动、转移等相关工作,及时更新完善相关实物信息,提高资产利用率,然而不论是人工方式还是系统方式,都可能存在各种隐蔽错误,进而导致无法为后续资产管理提供有效的数据源。The concentrators, large user terminals, and general meters in the power consumption information collection system belong to the fixed assets of the power supply company. It is necessary to update and improve the physical information related to the fixed asset card in a timely manner according to changes in the situation of the fixed assets. The asset card contains information such as project name, project account number, equipment name, cost center, unit, quantity, etc. In daily work, asset cards are made in the form of Excel spreadsheets and stored in computers. In recent years, some companies have adopted the ERP system of Germany's SAP company to carry out related work such as fixed asset card management, asset increase and decrease, and transfer, to update and improve relevant physical information in a timely manner, and to improve asset utilization. However, whether it is manual or systematic, There may be various hidden errors, which will lead to the inability to provide effective data sources for subsequent asset management.

发明内容Contents of the invention

本发明的目的在于提供一种采集设备资产生成系统及方法,自动实现资产卡片生成,代替人工制作方式,实现高效率、高可靠、批量化的制作,有效提升了工作质量。The purpose of the present invention is to provide a collection equipment asset generation system and method, which automatically realizes asset card generation, replaces the manual production method, realizes high-efficiency, high-reliability, and batch production, and effectively improves the work quality.

为了达到上述目的,本发明通过以下技术方案实现:In order to achieve the above object, the present invention is achieved through the following technical solutions:

一种采集设备资产生成系统,其特征是,包含:A collection equipment asset generation system is characterized in that it includes:

数据存储模块,用于存储已完成资产生成的增资单所对应的台账Excel电子表格、资产卡片Excel电子表格、增资单Excel电子表格;所述的资产卡片Excel电子表格包含资产编号和设备编号信息;The data storage module is used to store the ledger Excel spreadsheet, the asset card Excel spreadsheet, and the capital increase spreadsheet corresponding to the capital increase sheet generated by the asset; the asset card Excel spreadsheet includes asset number and equipment number information ;

数据采集模块,用于采集新的增资单数据;Data collection module, used to collect new capital increase form data;

资产生成模块,用于根据数据库规则对新的增资单数据进行资产生成,并将该已完成资产生成的新的增资单数据以及生成的相应资产编号和设备编号更新到数据存储模块中的各Excel电子表格中;所述的资产生成包含资产编号和设备编号的生成。The asset generation module is used to generate assets for the new capital increase sheet data according to the database rules, and update the new capital increase sheet data generated by the completed asset and the generated corresponding asset number and equipment number to each Excel in the data storage module In the spreadsheet; the asset generation described includes the generation of asset numbers and equipment numbers.

上述的采集设备资产生成系统,其中,还包含:The above acquisition equipment asset generation system also includes:

使用界面设置模块,用于设置界面模板并根据界面模板对操作界面以及数据存储模块中存储的内容进行显示。The interface setting module is used for setting the interface template and displaying the content stored in the operation interface and the data storage module according to the interface template.

上述的采集设备资产生成系统,其中:The above collection equipment asset generation system, wherein:

所述的数据采集模块从批复和设计图纸中采集新的增资单数据;The data collection module collects new capital increase form data from approval and design drawings;

所述的台账Excel电子表格包含以项目为单位所统计的已完成资产生成的增资单数据、相应的资产编号、设备编号;所述的资产卡片Excel电子表格以及增资单Excel电子表格均以标准格式进行统计。The said ledger Excel spreadsheet contains the data of the capital increase sheet generated by the completed assets, the corresponding asset number and equipment number, which are calculated in units of projects; format for statistics.

上述的采集设备资产生成系统,其中,所述的资产生成模块中:The above acquisition equipment asset generation system, wherein, in the asset generation module:

用于对新的增资单数据进行资产生成的数据库规则为:一次选取多个新的增资单数据,并对新的增资单数据进行批量加载处理以获得资产编号以及设备编号;The database rules for asset generation of new capital increase data are: select multiple new capital increase data at one time, and perform batch loading processing on the new capital increase data to obtain asset numbers and equipment numbers;

所述的批量加载处理方式为运用多个流程的VBA函数,并反复调用VBA函数,以实现多个新的增资单数据批量化生成同一类型的资产编号以及设备编号表格。The batch loading processing method is to use the VBA functions of multiple processes, and repeatedly call the VBA functions, so as to realize the batch generation of multiple new capital increase order data to generate the same type of asset number and equipment number table.

上述的采集设备资产生成系统,其中,还包含:The above acquisition equipment asset generation system also includes:

查询模块,用于向用户提供所有Excel电子表格以项目或时间为单位的查询。The query module is used to provide users with queries of all Excel spreadsheets in units of items or time.

上述的采集设备资产生成系统,其中:The above collection equipment asset generation system, wherein:

所述的界面模板为流程化界面及用户窗体相结合的模板形式。The interface template is in the form of a template combining a process interface and a user form.

上述的采集设备资产生成系统,其中,还包含:The above acquisition equipment asset generation system also includes:

查重模块,用于在资产生成时对生成的资产编号、设备编号与数据存储模块中存储的资产卡片Excel电子表格内的资产编号、设备编号进行查重,并将重复的资产编号或设备编号反馈给资产生成模块由资产生成模块重新进行资产生成。The duplicate checking module is used to check the generated asset number, equipment number and the asset number and equipment number in the Excel spreadsheet of the asset card stored in the data storage module when the asset is generated, and check the repeated asset number or equipment number Feedback to the asset generation module and the asset generation module regenerates the asset.

一种采集设备资产生成方法,其特征是,包含:A method for generating acquisition equipment assets is characterized in that it includes:

采集新的增资单数据;Collect new capital increase form data;

存储已完成资产生成的增资单所对应的台账Excel电子表格、资产卡片Excel电子表格、增资单Excel电子表格;所述的资产卡片Excel电子表格包含资产编号和设备编号信息;Store the ledger Excel spreadsheet, the asset card Excel spreadsheet, and the capital increase spreadsheet corresponding to the capital increase sheet generated by the asset; the asset card Excel spreadsheet contains asset number and equipment number information;

根据数据库规则对新的增资单数据进行资产生成,并将该已完成资产生成的新的增资单数据以及生成的相应资产编号和设备编号更新到各Excel电子表格中。According to the database rules, the asset generation of the new capital increase sheet data is performed, and the new capital increase sheet data generated by the completed asset and the generated corresponding asset number and equipment number are updated to each Excel spreadsheet.

本发明与现有技术相比具有以下优点:自动实现资产卡片生成,代替人工制作方式,实现高效率、高可靠、批量化的制作,有效提升了工作质量。Compared with the prior art, the present invention has the following advantages: automatically realize asset card generation, replace the manual production method, realize high-efficiency, high-reliability, batch production, and effectively improve the work quality.

附图说明Description of drawings

图1为本发明的系统框图;Fig. 1 is a system block diagram of the present invention;

图2为本发明的方法流程图。Fig. 2 is a flow chart of the method of the present invention.

具体实施方式Detailed ways

以下结合附图,通过详细说明一个较佳的具体实施例,对本发明做进一步阐述。The present invention will be further elaborated below by describing a preferred specific embodiment in detail in conjunction with the accompanying drawings.

如图1所示,本发明提出了一种采集设备资产生成系统,其包含:数据存储模块3,用于存储已完成资产生成的增资单所对应的台账Excel电子表格、资产卡片Excel电子表格、增资单Excel电子表格;所述的资产卡片Excel电子表格包含资产编号和设备编号信息;数据采集模块1,用于采集新的增资单数据;资产生成模块2,用于根据数据库规则对新的增资单数据进行资产生成,并将该已完成资产生成的新的增资单数据以及生成的相应资产编号和设备编号更新到数据存储模块中的各Excel电子表格中;所述的资产生成包含资产编号和设备编号的生成。As shown in Figure 1, the present invention proposes a collection equipment asset generation system, which includes: a data storage module 3, which is used to store the ledger Excel spreadsheet and asset card Excel spreadsheet corresponding to the capital increase sheet that has completed asset generation , capital increase sheet Excel spreadsheet; the asset card Excel spreadsheet contains asset number and equipment number information; data acquisition module 1 is used to collect new capital increase sheet data; asset generation module 2 is used to generate new data according to database rules Capital increase sheet data is used to generate assets, and the new capital increase sheet data generated by the completed asset and the generated corresponding asset numbers and equipment numbers are updated to each Excel spreadsheet in the data storage module; the asset generation includes asset numbers and device number generation.

本实施例中,所述的数据采集模块1从批复和设计图纸中采集新的增资单数据;所述的台账Excel电子表格包含以项目为单位所统计的已完成资产生成的增资单数据、相应的资产编号、设备编号;所述的资产卡片Excel电子表格以及增资单Excel电子表格均以标准格式进行统计。In this embodiment, the data collection module 1 collects new capital increase form data from the approval and design drawings; the account Excel electronic form includes the capital increase form data generated by the completed assets calculated in units of projects, The corresponding asset number and equipment number; the Excel spreadsheet of the asset card and the Excel spreadsheet of the capital increase sheet are all counted in a standard format.

所述的采集设备资产生成系统还包含:使用界面设置模块4,用于设置界面模板并根据界面模板对操作界面以及数据存储模块中存储的内容进行显示。优选的,界面模板为流程化界面及用户窗体相结合的模板形式,即图形交互界面,便于用于用户使用和操作。The acquisition device asset generation system further includes: an interface setting module 4 configured to set an interface template and display the operation interface and the content stored in the data storage module according to the interface template. Preferably, the interface template is in the form of a template combining a streamlined interface and a user form, that is, a graphical interactive interface, which is convenient for users to use and operate.

所述的资产生成模块中:用于对新的增资单数据进行资产生成的数据库规则为:一次选取多个新的增资单数据,并对新的增资单数据进行批量加载处理以获得资产编号以及设备编号;所述的批量加载处理方式为运用多个流程的VBA函数,并反复调用VBA函数,以实现多个新的增资单数据批量化生成同一类型的资产编号以及设备编号表格。具体的,资产编号的生成是通过含有生成ZAS01格式的sub过程和函数单元来完成,设备编号的生成是通过含有生成ZIE01N格式的sub过程和函数单元来完成。ZAS01和ZIE01N均为SAP系统命令。In the asset generating module: the database rules for generating assets for the new capital increase form data are: select multiple new capital increase form data at one time, and perform batch loading processing on the new capital increase form data to obtain the asset number and Equipment number; the batch loading processing method is to use the VBA function of multiple processes, and repeatedly call the VBA function, so as to realize the batch generation of the same type of asset number and equipment number form for multiple new capital increase order data. Specifically, the generation of the asset number is completed by including the sub procedure and the function unit that generate the ZAS01 format, and the generation of the equipment number is completed by including the sub procedure and the function unit that generate the ZIE01N format. Both ZAS01 and ZIE01N are SAP system commands.

所述的采集设备资产生成系统还包含:查询模块6,用于向用户提供所有Excel电子表格以项目或时间为单位的查询。The acquisition equipment asset generation system further includes: a query module 6, which is used to provide users with query of all Excel spreadsheets in units of items or time.

所述的采集设备资产生成系统还包含:查重模块5,用于在资产生成时对生成的资产编号、设备编号与数据存储模块1中存储的资产卡片Excel电子表格内的资产编号、设备编号进行查重,并将重复的资产编号或设备编号反馈给资产生成模块2由资产生成模块重新进行资产生成。The acquisition equipment asset generation system also includes: a duplicate checking module 5, which is used to generate asset numbers, equipment numbers, and asset numbers and equipment numbers in the asset card Excel electronic form stored in the data storage module 1 when the assets are generated. Perform duplicate checking, and feed back the repeated asset number or equipment number to the asset generation module 2, and the asset generation module will regenerate the asset.

如图2所示,本发明还提出了一种采集设备资产生成方法,其包含:As shown in Figure 2, the present invention also proposes a method for generating acquisition equipment assets, which includes:

采集新的增资单数据;Collect new capital increase form data;

存储已完成资产生成的增资单所对应的台账Excel电子表格、资产卡片Excel电子表格、增资单Excel电子表格;所述的资产卡片Excel电子表格包含资产编号和设备编号信息;Store the ledger Excel spreadsheet, the asset card Excel spreadsheet, and the capital increase spreadsheet corresponding to the capital increase sheet generated by the asset; the asset card Excel spreadsheet contains asset number and equipment number information;

根据数据库规则对新的增资单数据进行资产生成,并将该已完成资产生成的新的增资单数据以及生成的相应资产编号和设备编号更新到各Excel电子表格中。According to the database rules, the asset generation of the new capital increase sheet data is performed, and the new capital increase sheet data generated by the completed asset and the generated corresponding asset number and equipment number are updated to each Excel spreadsheet.

尽管本发明的内容已经通过上述优选实施例作了详细介绍,但应当认识到上述的描述不应被认为是对本发明的限制。在本领域技术人员阅读了上述内容后,对于本发明的多种修改和替代都将是显而易见的。因此,本发明的保护范围应由所附的权利要求来限定。Although the content of the present invention has been described in detail through the above preferred embodiments, it should be understood that the above description should not be considered as limiting the present invention. Various modifications and alterations to the present invention will become apparent to those skilled in the art upon reading the above disclosure. Therefore, the protection scope of the present invention should be defined by the appended claims.

Claims (8)

1.一种采集设备资产生成系统,其特征在于,包含:1. A collection equipment asset generation system, characterized in that, comprising: 数据存储模块,用于存储已完成资产生成的增资单所对应的台账Excel电子表格、资产卡片Excel电子表格、增资单Excel电子表格;所述的资产卡片Excel电子表格包含资产编号和设备编号信息;The data storage module is used to store the ledger Excel spreadsheet, the asset card Excel spreadsheet, and the capital increase spreadsheet corresponding to the capital increase sheet generated by the asset; the asset card Excel spreadsheet includes asset number and equipment number information ; 数据采集模块,用于采集新的增资单数据;Data collection module, used to collect new capital increase form data; 资产生成模块,用于根据数据库规则对新的增资单数据进行资产生成,并将该已完成资产生成的新的增资单数据以及生成的相应资产编号和设备编号更新到数据存储模块中的各Excel电子表格中;所述的资产生成包含资产编号和设备编号的生成。The asset generation module is used to generate assets for the new capital increase sheet data according to the database rules, and update the new capital increase sheet data generated by the completed asset and the generated corresponding asset number and equipment number to each Excel in the data storage module In the spreadsheet; the asset generation described includes the generation of asset numbers and equipment numbers. 2.如权利要求1所述的采集设备资产生成系统,其特征在于,还包含:2. The acquisition equipment asset generation system according to claim 1, further comprising: 使用界面设置模块,用于设置界面模板并根据界面模板对操作界面以及数据存储模块中存储的内容进行显示。The interface setting module is used for setting the interface template and displaying the content stored in the operation interface and the data storage module according to the interface template. 3.如权利要求1所述的采集设备资产生成系统,其特征在于:3. The acquisition equipment asset generation system according to claim 1, characterized in that: 所述的数据采集模块从批复和设计图纸中采集新的增资单数据;The data collection module collects new capital increase form data from approval and design drawings; 所述的台账Excel电子表格包含以项目为单位所统计的已完成资产生成的增资单数据、相应的资产编号、设备编号;所述的资产卡片Excel电子表格以及增资单Excel电子表格均以标准格式进行统计。The said ledger Excel spreadsheet contains the data of the capital increase sheet generated by the completed assets, the corresponding asset number and equipment number, which are calculated in units of projects; format for statistics. 4.如权利要求1所述的采集设备资产生成系统,其特征在于,所述的资产生成模块中:4. The acquisition equipment asset generation system according to claim 1, wherein in the asset generation module: 用于对新的增资单数据进行资产生成的数据库规则为:一次选取多个新的增资单数据,并对新的增资单数据进行批量加载处理以获得资产编号以及设备编号;The database rules for asset generation of new capital increase data are: select multiple new capital increase data at one time, and perform batch loading processing on the new capital increase data to obtain asset numbers and equipment numbers; 所述的批量加载处理方式为运用多个流程的VBA函数,并反复调用VBA函数,以实现多个新的增资单数据批量化生成同一类型的资产编号以及设备编号表格。The batch loading processing method is to use the VBA functions of multiple processes, and repeatedly call the VBA functions, so as to realize the batch generation of multiple new capital increase order data to generate the same type of asset number and equipment number table. 5.如权利要求1所述的采集设备资产生成系统,其特征在于,还包含:5. The acquisition equipment asset generation system according to claim 1, further comprising: 查询模块,用于向用户提供所有Excel电子表格以项目或时间为单位的查询。The query module is used to provide users with queries of all Excel spreadsheets in units of items or time. 6.如权利要求1所述的采集设备资产生成系统,其特征在于:6. The acquisition equipment asset generation system according to claim 1, characterized in that: 所述的界面模板为流程化界面及用户窗体相结合的模板形式。The interface template is in the form of a template combining a process interface and a user form. 7.如权利要求1所述的采集设备资产生成系统,其特征在于,还包含:7. The acquisition equipment asset generation system according to claim 1, further comprising: 查重模块,用于在资产生成时对生成的资产编号、设备编号与数据存储模块中存储的资产卡片Excel电子表格内的资产编号、设备编号进行查重,并将重复的资产编号或设备编号反馈给资产生成模块由资产生成模块重新进行资产生成。The duplicate checking module is used to check the generated asset number, equipment number and the asset number and equipment number in the Excel spreadsheet of the asset card stored in the data storage module when the asset is generated, and check the repeated asset number or equipment number Feedback to the asset generation module and the asset generation module regenerates the asset. 8.一种采集设备资产生成方法,其特征在于,包含:8. A method for generating acquisition equipment assets, characterized in that, comprising: 采集新的增资单数据;Collect new capital increase form data; 存储已完成资产生成的增资单所对应的台账Excel电子表格、资产卡片Excel电子表格、增资单Excel电子表格;所述的资产卡片Excel电子表格包含资产编号和设备编号信息;Store the ledger Excel spreadsheet, the asset card Excel spreadsheet, and the capital increase spreadsheet corresponding to the capital increase sheet generated by the asset; the asset card Excel spreadsheet contains asset number and equipment number information; 根据数据库规则对新的增资单数据进行资产生成,并将该已完成资产生成的新的增资单数据以及生成的相应资产编号和设备编号更新到各Excel电子表格中。According to the database rules, the asset generation of the new capital increase sheet data is performed, and the new capital increase sheet data generated by the completed asset and the generated corresponding asset number and equipment number are updated to each Excel spreadsheet.
CN201810084051.5A 2018-01-29 2018-01-29 Collecting device assets generate system and method Pending CN108171484A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201810084051.5A CN108171484A (en) 2018-01-29 2018-01-29 Collecting device assets generate system and method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201810084051.5A CN108171484A (en) 2018-01-29 2018-01-29 Collecting device assets generate system and method

Publications (1)

Publication Number Publication Date
CN108171484A true CN108171484A (en) 2018-06-15

Family

ID=62515905

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201810084051.5A Pending CN108171484A (en) 2018-01-29 2018-01-29 Collecting device assets generate system and method

Country Status (1)

Country Link
CN (1) CN108171484A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109669419A (en) * 2018-12-25 2019-04-23 国电大渡河大岗山水电开发有限公司 A kind of mobilism Hydropower Equipment handbook

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104850940A (en) * 2015-04-29 2015-08-19 国网辽宁省电力有限公司鞍山供电公司 Completion settlement making method and completion settlement making system based on project whole-process management
CN105404974A (en) * 2015-12-01 2016-03-16 国网江西省电力公司信息通信分公司 Data capitalization method and apparatus and management platform
US20160132472A1 (en) * 2014-11-06 2016-05-12 Tulkita Technologies Inc. Process intelligence system
CN107194573A (en) * 2017-05-18 2017-09-22 郝继英 Asset source manages method concentratedly
CN107632973A (en) * 2017-09-26 2018-01-26 郑州云海信息技术有限公司 The input method and device of assets

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20160132472A1 (en) * 2014-11-06 2016-05-12 Tulkita Technologies Inc. Process intelligence system
CN104850940A (en) * 2015-04-29 2015-08-19 国网辽宁省电力有限公司鞍山供电公司 Completion settlement making method and completion settlement making system based on project whole-process management
CN105404974A (en) * 2015-12-01 2016-03-16 国网江西省电力公司信息通信分公司 Data capitalization method and apparatus and management platform
CN107194573A (en) * 2017-05-18 2017-09-22 郝继英 Asset source manages method concentratedly
CN107632973A (en) * 2017-09-26 2018-01-26 郑州云海信息技术有限公司 The input method and device of assets

Non-Patent Citations (3)

* Cited by examiner, † Cited by third party
Title
周洋: "电力智能化IT运维管理的建立及应用研究", 《贵州电力技术》 *
李刚: "铁路信息技术装备资产管理系统的设计与实现", 《铁路计算机应用》 *
顾克荣等: "利用条码技术 加强资产管理基础工作", 《中国石化》 *

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109669419A (en) * 2018-12-25 2019-04-23 国电大渡河大岗山水电开发有限公司 A kind of mobilism Hydropower Equipment handbook

Similar Documents

Publication Publication Date Title
CN109614409A (en) Business data processing method, device and server
CN102999820B (en) A kind of assets management method for electric system and system
CN110046337B (en) Financial data acquisition method and system
CN102496083B (en) Credit rating report manuscript manufacturing method
CN103942184B (en) Collocation method, generation method and system with addition Item consolidated statement
CN101364284A (en) Production management system for electrical power system
CN106327100A (en) Change list generation method and device
CN109767277A (en) A kind of electricity power enterprise clearing invoice generates, billing method and system
CN103559594A (en) Management system and method for having control over procurement plan according to inventory level of spare parts
CN106326243A (en) Data processing method and apparatus
CN112749846A (en) Big data platform-based financial cloud picture construction analysis method for electric power system
CN112990886B (en) Aviation industry data management display system based on mobile phone terminal
CN108171484A (en) Collecting device assets generate system and method
CN105643937B (en) Integral type service management system derived from a kind of 3D printing technique
CN104699471A (en) Technical publication content distribution system and method
CN107194471A (en) A kind of equipment management system based on information technology
CN114004542B (en) Enterprise task management method, system, computer equipment and storage medium
CN116796950A (en) Online review system and method for power distribution network project capable of being researched
CN114881684A (en) Electricity charge compensation method and device, electronic equipment and storage medium
CN108132997A (en) A kind of electric network data management sums up structure and its resolution principle
CN116681198A (en) Die release scheme generation method, electronic equipment and storage medium
CN110597899B (en) Project fund management method and system
CN114328616A (en) Statistical method and device for power line loss detailed information combining RPA and AI
CN103559595A (en) Management system and method for having control over procurement plan according to monthly average consumption of spare parts
CN206193904U (en) Cloud calculates long -range accuse system of taking

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
RJ01 Rejection of invention patent application after publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20180615