CN114490652A - A method, system, device and storage medium for offline processing of mobile assets - Google Patents
A method, system, device and storage medium for offline processing of mobile assetsDownload PDFInfo
- Publication number
- CN114490652A CN114490652ACN202210072576.3ACN202210072576ACN114490652ACN 114490652 ACN114490652 ACN 114490652ACN 202210072576 ACN202210072576 ACN 202210072576ACN 114490652 ACN114490652 ACN 114490652A
- Authority
- CN
- China
- Prior art keywords
- asset
- data file
- handheld device
- client
- offline database
- 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
Links
Images
Classifications
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2372—Updates performed during offline database operations
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/174—Form filling; Merging
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06Q—INFORMATION 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
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/06—Asset management; Financial planning or analysis
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Development Economics (AREA)
- Finance (AREA)
- Data Mining & Analysis (AREA)
- General Business, Economics & Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Strategic Management (AREA)
- Marketing (AREA)
- Economics (AREA)
- Operations Research (AREA)
- Software Systems (AREA)
- Human Resources & Organizations (AREA)
- Game Theory and Decision Science (AREA)
- Technology Law (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Translated fromChinese技术领域technical field
本发明涉及资产管理领域，更具体地，特别是指一种移动资产离线处理的方法、系统、设备和存储介质。The present invention relates to the field of asset management, and more particularly, to a method, system, device and storage medium for offline processing of mobile assets.
背景技术Background technique
资产管理(Asset management)业务是指资产管理人根据资产管理合同约定的方式、条件、要求及限制，对客户的资产进行经营运作，为客户提供证券、基金及其他金融产品，并收取管理费用的行为。Asset management business means that the asset manager operates the client's assets according to the methods, conditions, requirements and restrictions agreed in the asset management contract, provides securities, funds and other financial products for the client, and collects management fees. Behavior.
移动资产管理是企业管理中的一个重要组成部分，移动资产具有数量大、种类多、价值高、使用周期长、使用地点分散等特点，管理难度大。依赖手工记账的管理方式，由于管理单据众多、盘点工作繁重，需占用大量的人力物力，而且固定资产的历史操作和资产统计工作异常困难，导致资产流失和资产重复购置。近些年出现了一些固定资产管理的软件，虽然在很大程度上解决了手工记账方式的问题，但多数系统采用手工方式录入数据，不仅速度慢、易产生错误，而且存在资产管理中资产实物与帐务信息脱节的严重问题，难于满足现代企业管理的需要。Mobile asset management is an important part of enterprise management. Mobile assets have the characteristics of large quantity, variety, high value, long life cycle and scattered use locations, which are difficult to manage. Relying on manual bookkeeping management requires a lot of manpower and material resources due to numerous management documents and heavy inventory work, and the historical operation of fixed assets and asset statistics are extremely difficult, resulting in asset loss and repeated asset purchases. In recent years, some fixed asset management software has appeared. Although the problem of manual bookkeeping has been solved to a large extent, most systems use manual data entry, which is not only slow and prone to errors, but also has assets in asset management. The serious problem of disconnection between physical objects and accounting information is difficult to meet the needs of modern enterprise management.
随着经济的快速发展，企事业单位的各类资产急剧增加，再加上现代企业的经营、管理不再局限于本地，许多的企业的分支机构遍布各地，并且存在无网络环境，地理上的分散和无网络环境致使资产管理工作的难度加大。With the rapid development of the economy, various assets of enterprises and institutions have increased sharply. In addition, the operation and management of modern enterprises are no longer limited to local areas. Many enterprises have branches all over the place, and there is no network environment. Decentralized and networkless environments make asset management more difficult.
发明内容SUMMARY OF THE INVENTION
有鉴于此，本发明实施例的目的在于提出一种移动资产离线处理的方法、系统、计算机设备及计算机可读存储介质，本发明通过在手持设备客户端设置了离线数据库，能够在无网络环境下方便、快捷的实现资产盘点、变动、点检、润滑等日常管理业务，提高工作效率和资产管理的准确度。In view of this, the purpose of the embodiments of the present invention is to provide a method, system, computer device and computer-readable storage medium for offline processing of mobile assets. It can conveniently and quickly realize daily management business such as asset inventory, change, spot inspection, lubrication, etc., and improve work efficiency and accuracy of asset management.
基于上述目的，本发明实施例的一方面提供了一种移动资产离线处理的方法，包括如下步骤：将资产数据从系统服务器导出到Excel数据文件保存至电脑客户端，并将所述Excel数据文件从所述电脑客户端导出到手持设备客户端；在所述手持设备客户端建立资产离线数据库，并将所述Excel数据文件导入所述离线数据库；基于所述手持设备客户端获取资产信息，并根据所述资产信息与所述离线数据库中的资产信息进行资产处理；以及将资产处理的数据导出到新的Excel数据文件中保存到所述手持设备客户端，并将所述新的Excel数据文件通过所述电脑客户端传输到所述系统服务器中。Based on the above purpose, one aspect of the embodiments of the present invention provides a method for offline processing of mobile assets, including the following steps: exporting asset data from a system server to an Excel data file and saving it to a computer client, and converting the Excel data file to a computer client. Export from the computer client to the handheld device client; establish an asset offline database on the handheld device client, and import the Excel data file into the offline database; obtain asset information based on the handheld device client, and Perform asset processing according to the asset information and the asset information in the offline database; and export the asset processing data to a new Excel data file and save it to the handheld device client, and store the new Excel data file It is transmitted to the system server through the computer client.
在一些实施方式中，所述将所述Excel数据文件导入所述离线数据库包括：读取所述Excel数据文件获得二进制数据对象，再将获取的所述二进制数据对象转化为二维数组；以及通过遍历所述二维数组将所述二维数组进行重新封装，并将重新封装后的数据根据属性插入到所述手持设备客户端的离线数据库中。In some embodiments, the importing the Excel data file into the offline database comprises: reading the Excel data file to obtain a binary data object, and then converting the obtained binary data object into a two-dimensional array; and Traverse the two-dimensional array to repackage the two-dimensional array, and insert the repackaged data into the offline database of the handheld device client according to the attribute.
在一些实施方式中，所述将资产处理的数据导出到新的Excel数据文件中保存到所述手持设备客户端包括：获取所述资产处理的数据以得到第二二维数组，对所述第二二维数组进行重新封装，并将所述重新封装后的第二二维数组转换为Excel文件。In some implementation manners, the exporting the asset processing data to a new Excel data file and saving it to the handheld device client comprises: acquiring the asset processing data to obtain a second two-dimensional array, The two-dimensional array is repackaged, and the repackaged second two-dimensional array is converted into an Excel file.
在一些实施方式中，所述根据所述资产信息与所述离线数据库中的资产信息进行资产处理包括：将所述资产信息与所述离线数据库中的资产信息进行比对；以及响应于所述资产信息与所述离线数据库中的资产信息不一致，将所述离线数据库中的资产信息进行更新。In some embodiments, the performing asset processing according to the asset information and the asset information in the offline database includes: comparing the asset information with the asset information in the offline database; and responding to the If the asset information is inconsistent with the asset information in the offline database, the asset information in the offline database is updated.
本发明实施例的另一方面，提供了一种移动资产离线处理的系统，包括：导出模块，配置用于将资产数据从系统服务器导出到Excel数据文件保存至电脑客户端，并将所述Excel数据文件从所述电脑客户端导出到手持设备客户端；导入模块，配置用于在所述手持设备客户端建立资产离线数据库，并将所述Excel数据文件导入所述离线数据库；执行模块，配置用于基于所述手持设备客户端获取资产信息，并根据所述资产信息与所述离线数据库中的资产信息进行资产处理；以及传输模块，配置用于将资产处理的数据导出到新的Excel数据文件中保存到所述手持设备客户端，并将所述新的Excel数据文件通过所述电脑客户端传输到所述系统服务器中。Another aspect of the embodiments of the present invention provides a system for offline processing of mobile assets, including: an export module configured to export asset data from a system server to an Excel data file and save it to a computer client, and export the Excel data to a computer client. The data file is exported from the computer client to the handheld device client; the import module is configured to establish an asset offline database on the handheld device client, and the Excel data file is imported into the offline database; the execution module, configured for acquiring asset information based on the handheld device client, and performing asset processing according to the asset information and the asset information in the offline database; and a transmission module, configured to export the asset processing data to new Excel data The file is saved to the handheld device client, and the new Excel data file is transmitted to the system server through the computer client.
在一些实施方式中，所述导入模块配置用于：读取所述Excel数据文件获得二进制数据对象，再将获取的所述二进制数据对象转化为二维数组；以及通过遍历所述二维数组将所述二维数组进行重新封装，并将重新封装后的数据根据属性插入到所述手持设备客户端的离线数据库中。In some embodiments, the import module is configured to: read the Excel data file to obtain a binary data object, and then convert the obtained binary data object into a two-dimensional array; The two-dimensional array is repackaged, and the repackaged data is inserted into the offline database of the handheld device client according to the attributes.
在一些实施方式中，所述传输模块配置用于：获取所述资产处理的数据以得到第二二维数组，对所述第二二维数组进行重新封装，并将所述重新封装后的第二二维数组转换为Excel文件。In some embodiments, the transmission module is configured to: obtain the data processed by the asset to obtain a second two-dimensional array, repackage the second two-dimensional array, and repackage the repackaged first two-dimensional array. Convert two-dimensional arrays to Excel files.
在一些实施方式中，所述执行模块配置用于：将所述资产信息与所述离线数据库中的资产信息进行比对；以及响应于所述资产信息与所述离线数据库中的资产信息不一致，将所述离线数据库中的资产信息进行更新。In some embodiments, the execution module is configured to: compare the asset information with asset information in the offline database; and in response to the asset information being inconsistent with the asset information in the offline database, The asset information in the offline database is updated.
本发明实施例的又一方面，还提供了一种计算机设备，包括：至少一个处理器；以及存储器，所述存储器存储有可在所述处理器上运行的计算机指令，所述指令由所述处理器执行时实现如上方法的步骤。In yet another aspect of the embodiments of the present invention, there is also provided a computer device, comprising: at least one processor; and a memory, where the memory stores computer instructions that can be executed on the processor, and the instructions are executed by the processor. The processor implements the steps of the above method when executed.
本发明实施例的再一方面，还提供了一种计算机可读存储介质，计算机可读存储介质存储有被处理器执行时实现如上方法步骤的计算机程序。In yet another aspect of the embodiments of the present invention, a computer-readable storage medium is also provided, where the computer-readable storage medium stores a computer program that implements the above method steps when executed by a processor.
本发明具有以下有益技术效果：通过在手持设备客户端设置了离线数据库，能够在无网络环境下方便、快捷的实现资产盘点、变动、点检、润滑等日常管理业务，提高工作效率和资产管理的准确度。The invention has the following beneficial technical effects: by setting an offline database on the client of the handheld device, daily management services such as asset inventory, change, spot check, lubrication can be conveniently and quickly realized in a network-free environment, and work efficiency and asset management can be improved. accuracy.
附图说明Description of drawings
为了更清楚地说明本发明实施例或现有技术中的技术方案，下面将对实施例或现有技术描述中所需要使用的附图作简单地介绍，显而易见地，下面描述中的附图仅仅是本发明的一些实施例，对于本领域普通技术人员来讲，在不付出创造性劳动的前提下，还可以根据这些附图获得其他的实施例。In order to explain the embodiments of the present invention or the technical solutions in the prior art more clearly, the following briefly introduces the accompanying drawings that need to be used in the description of the embodiments or the prior art. Obviously, the accompanying drawings in the following description are only These are some embodiments of the present invention. For those of ordinary skill in the art, other embodiments can also be obtained according to these drawings without creative efforts.
图1为本发明提供的移动资产离线处理的方法的实施例的示意图；1 is a schematic diagram of an embodiment of a method for offline processing of mobile assets provided by the present invention;
图2为本发明提供的移动资产离线处理的系统的实施例的示意图；2 is a schematic diagram of an embodiment of a system for offline processing of mobile assets provided by the present invention;
图3为本发明提供的移动资产离线处理的计算机设备的实施例的硬件结构示意图；3 is a schematic diagram of the hardware structure of an embodiment of a computer device for offline processing of mobile assets provided by the present invention;
图4为本发明提供的移动资产离线处理的计算机存储介质的实施例的示意图。FIG. 4 is a schematic diagram of an embodiment of a computer storage medium for offline processing of mobile assets provided by the present invention.
具体实施方式Detailed ways
为使本发明的目的、技术方案和优点更加清楚明白，以下结合具体实施例，并参照附图，对本发明实施例进一步详细说明。In order to make the objectives, technical solutions and advantages of the present invention more clearly understood, the embodiments of the present invention will be further described in detail below with reference to the specific embodiments and the accompanying drawings.
需要说明的是，本发明实施例中所有使用“第一”和“第二”的表述均是为了区分两个相同名称非相同的实体或者非相同的参量，可见“第一”“第二”仅为了表述的方便，不应理解为对本发明实施例的限定，后续实施例对此不再一一说明。It should be noted that all expressions using "first" and "second" in the embodiments of the present invention are for the purpose of distinguishing two entities with the same name but not the same or non-identical parameters. It can be seen that "first" and "second" It is only for the convenience of expression and should not be construed as a limitation to the embodiments of the present invention, and subsequent embodiments will not describe them one by one.
本发明实施例的第一个方面，提出了一种移动资产离线处理的方法的实施例。图1示出的是本发明提供的移动资产离线处理的方法的实施例的示意图。如图1所示，本发明实施例包括如下步骤：In a first aspect of the embodiments of the present invention, an embodiment of a method for offline processing of mobile assets is provided. FIG. 1 shows a schematic diagram of an embodiment of a method for offline processing of mobile assets provided by the present invention. As shown in Figure 1, the embodiment of the present invention includes the following steps:
S1、将资产数据从系统服务器导出到Excel数据文件保存至电脑客户端，并将所述Excel数据文件从所述电脑客户端导出到手持设备客户端；S1, export the asset data from the system server to the Excel data file and save it to the computer client, and export the Excel data file from the computer client to the handheld device client;
S2、在所述手持设备客户端建立资产离线数据库，并将所述Excel数据文件导入所述离线数据库；S2, establishing an asset offline database on the handheld device client, and importing the Excel data file into the offline database;
S3、基于所述手持设备客户端获取资产信息，并根据所述资产信息与所述离线数据库中的资产信息进行资产处理；以及S3. Acquire asset information based on the handheld device client, and perform asset processing according to the asset information and the asset information in the offline database; and
S4、将资产处理的数据导出到新的Excel数据文件中保存到所述手持设备客户端，并将所述新的Excel数据文件通过所述电脑客户端传输到所述系统服务器中。S4. Export the data of asset processing to a new Excel data file and save it to the handheld device client, and transmit the new Excel data file to the system server through the computer client.
本发明实施例运行在资产管理系统上，资产管理系统主要包括电脑客户端、手持设备客户端、离线数据库和系统服务器，电脑客户端与系统服务器连接，手持设备客户端与离线数据库连接，手持设备客户端可以通过USB数据线与电脑客户端连接，也可以通过无线连接。The embodiment of the present invention runs on an asset management system. The asset management system mainly includes a computer client, a handheld device client, an offline database and a system server. The computer client is connected to the system server, the handheld device client is connected to the offline database, and the handheld device is connected to the offline database. The client can be connected to the computer client through a USB data cable, or through a wireless connection.
将资产数据从系统服务器导出到Excel数据文件保存至电脑客户端，并将所述Excel数据文件从所述电脑客户端导出到手持设备客户端。本发明实施例中可以将Excel数据文件通过数据线或无线发送到手持设备客户端中。The asset data is exported from the system server to an Excel data file and saved to the computer client, and the Excel data file is exported from the computer client to the handheld device client. In this embodiment of the present invention, the Excel data file may be sent to the client of the handheld device through a data cable or wirelessly.
在所述手持设备客户端建立资产离线数据库，并将所述Excel数据文件导入所述离线数据库。手持设备客户端将Excel数据文件导入到离线数据库中，后续资产业务将在手持设备客户端进行，即通过手持设备导入工具实现手持设备端的数据持久化。An asset offline database is established on the handheld device client, and the Excel data file is imported into the offline database. The handheld device client imports the Excel data file into the offline database, and the subsequent asset business will be carried out on the handheld device client, that is, the data persistence on the handheld device side is realized through the handheld device import tool.
在一些实施方式中，所述将所述Excel数据文件导入所述离线数据库包括：读取所述Excel数据文件获得二进制数据对象，再将获取的所述二进制数据对象转化为二维数组；以及通过遍历所述二维数组将所述二维数组进行重新封装，并将重新封装后的数据根据属性插入到所述手持设备客户端的离线数据库中。通过读取数据文件获得二进制数据对象，再将获取的二进制数据对象转化为JSON二维数组A，通过遍历二维数组A，将其重新封装为[{属性：属性值}，···]的结构，最后将封装后的数据根据其属性将数据插入到手持设备客户端的离线数据库中，实现手持设备客户端的数据持久化存储，为无网络环境做准备。In some embodiments, the importing the Excel data file into the offline database comprises: reading the Excel data file to obtain a binary data object, and then converting the obtained binary data object into a two-dimensional array; and Traverse the two-dimensional array to repackage the two-dimensional array, and insert the repackaged data into the offline database of the handheld device client according to the attribute. The binary data object is obtained by reading the data file, and then the obtained binary data object is converted into a JSON two-dimensional array A. By traversing the two-dimensional array A, it is repackaged as [{attribute:attribute value},...] Finally, the encapsulated data is inserted into the offline database of the handheld device client according to its properties, so as to realize the persistent storage of the data of the handheld device client and prepare for the network-free environment.
基于所述手持设备客户端获取资产信息，并根据所述资产信息与所述离线数据库中的资产信息进行资产处理。Asset information is acquired based on the handheld device client, and asset processing is performed according to the asset information and the asset information in the offline database.
在一些实施方式中，所述根据所述资产信息与所述离线数据库中的资产信息进行资产处理包括：将所述资产信息与所述离线数据库中的资产信息进行比对；以及响应于所述资产信息与所述离线数据库中的资产信息不一致，将所述离线数据库中的资产信息进行更新。In some embodiments, the performing asset processing according to the asset information and the asset information in the offline database includes: comparing the asset information with the asset information in the offline database; and responding to the If the asset information is inconsistent with the asset information in the offline database, the asset information in the offline database is updated.
资产处理包括资产盘点、资产变动和资产点检，具体的：Asset processing includes asset inventory, asset changes and asset inspection, specifically:
一、资产盘点：操作人员使用所述手持设备客户端通过扫描电子标签或者二维码获取信息，以获取到的信息为条件从所述离线数据库中检索资产盘点信息，核对当前信息与实物资产信息无误后进行盘点确认操作；1. Asset inventory: The operator uses the handheld device client to obtain information by scanning the electronic label or QR code, retrieves the asset inventory information from the offline database on the condition of the obtained information, and checks the current information and physical asset information. Check and confirm after checking;
二、资产变动：操作人员使用所述手持设备客户端通过扫描电子标签或者二维码获取信息，以获取到的信息为条件从所述离线数据库中检索资产变动信息，核对当前实物资产信息后，在所述手持设备客户端对资产使用部门和使用状态进行变动操作。2. Asset change: The operator uses the handheld device client to obtain information by scanning the electronic label or QR code, retrieves the asset change information from the offline database on the condition of the obtained information, and checks the current physical asset information. A change operation is performed on the asset use department and the use state on the handheld device client.
三、资产点检：操作人员使用所述手持设备客户端通过扫描电子标签或者二维码获取信息，以获取到的信息为条件从所述离线数据库中检索资产点检信息，核对当前实物资产状态后，在所述手持设备客户端填写点检信息和点检结果。3. Asset inspection: The operator uses the handheld device client to obtain information by scanning the electronic label or QR code, retrieves the asset inspection information from the offline database on the condition of the obtained information, and checks the current physical asset status Then, fill in the check information and check result on the handheld device client.
将资产处理的数据导出到新的Excel数据文件中保存到所述手持设备客户端，并将所述新的Excel数据文件通过所述电脑客户端传输到所述系统服务器中。所述的手持设备客户端完成相应的资产业务后，将数据导出到Excel文件。Export the asset processing data to a new Excel data file and save it to the handheld device client, and transmit the new Excel data file to the system server through the computer client. After the handheld device client completes the corresponding asset business, the data is exported to an Excel file.
在一些实施方式中，所述将资产处理的数据导出到新的Excel数据文件中保存到所述手持设备客户端包括：获取所述资产处理的数据以得到第二二维数组，对所述第二二维数组进行重新封装，并将所述重新封装后的第二二维数组转换为Excel文件。通过SQL语句获取业务数据——数组B，通过遍历数组B，将其重新组装为二维数组的结构，通过XLSX工具将二维数组转换为Excel文件，并保存到手持设备中。In some implementation manners, the exporting the asset processing data to a new Excel data file and saving it to the handheld device client comprises: acquiring the asset processing data to obtain a second two-dimensional array, The two-dimensional array is repackaged, and the repackaged second two-dimensional array is converted into an Excel file. Obtain business data-array B through SQL statements, reassemble it into a two-dimensional array structure by traversing array B, convert the two-dimensional array into an Excel file through the XLSX tool, and save it to the handheld device.
电脑客户端通过USB数据线或无线与所述的手持设备连接，将导出的Excel数据文件传输到所述的电脑客户端，后续电脑客户端将Excel数据文件导入到所属系统服务器中，进而更新资产业务数据。The computer client is connected to the handheld device through a USB data cable or wirelessly, and transmits the exported Excel data file to the computer client, and the subsequent computer client imports the Excel data file into the system server to which it belongs, and then updates the assets. business data.
需要特别指出的是，上述移动资产离线处理的方法的各个实施例中的各个步骤均可以相互交叉、替换、增加、删减，因此，这些合理的排列组合变换之于移动资产离线处理的方法也应当属于本发明的保护范围，并且不应将本发明的保护范围局限在实施例之上。It should be particularly pointed out that the steps in the various embodiments of the above-mentioned methods for offline processing of mobile assets can be intersected, replaced, added, and deleted. It should belong to the protection scope of the present invention, and should not limit the protection scope of the present invention to the embodiments.
基于上述目的，本发明实施例的第二个方面，提出了一种移动资产离线处理的系统。如图2所示，系统200包括如下模块：导出模块，配置用于将资产数据从系统服务器导出到Excel数据文件保存至电脑客户端，并将所述Excel数据文件从所述电脑客户端导出到手持设备客户端；导入模块，配置用于在所述手持设备客户端建立资产离线数据库，并将所述Excel数据文件导入所述离线数据库；执行模块，配置用于基于所述手持设备客户端获取资产信息，并根据所述资产信息与所述离线数据库中的资产信息进行资产处理；以及传输模块，配置用于将资产处理的数据导出到新的Excel数据文件中保存到所述手持设备客户端，并将所述新的Excel数据文件通过所述电脑客户端传输到所述系统服务器中。Based on the above objective, in a second aspect of the embodiments of the present invention, a system for offline processing of mobile assets is proposed. As shown in Figure 2, the
在一些实施方式中，所述导入模块配置用于：读取所述Excel数据文件获得二进制数据对象，再将获取的所述二进制数据对象转化为二维数组；以及通过遍历所述二维数组将所述二维数组进行重新封装，并将重新封装后的数据根据属性插入到所述手持设备客户端的离线数据库中。In some embodiments, the import module is configured to: read the Excel data file to obtain a binary data object, and then convert the obtained binary data object into a two-dimensional array; The two-dimensional array is repackaged, and the repackaged data is inserted into the offline database of the handheld device client according to the attributes.
在一些实施方式中，所述传输模块配置用于：获取所述资产处理的数据以得到第二二维数组，对所述第二二维数组进行重新封装，并将所述重新封装后的第二二维数组转换为Excel文件。In some embodiments, the transmission module is configured to: obtain the data processed by the asset to obtain a second two-dimensional array, repackage the second two-dimensional array, and repackage the repackaged first two-dimensional array. Convert two-dimensional arrays to Excel files.
在一些实施方式中，所述执行模块配置用于：将所述资产信息与所述离线数据库中的资产信息进行比对；以及响应于所述资产信息与所述离线数据库中的资产信息不一致，将所述离线数据库中的资产信息进行更新。In some embodiments, the execution module is configured to: compare the asset information with asset information in the offline database; and in response to the asset information being inconsistent with the asset information in the offline database, The asset information in the offline database is updated.
基于上述目的，本发明实施例的第三个方面，提出了一种计算机设备，包括：至少一个处理器；以及存储器，存储器存储有可在处理器上运行的计算机指令，指令由处理器执行以实现如下步骤：S1、将资产数据从系统服务器导出到Excel数据文件保存至电脑客户端，并将所述Excel数据文件从所述电脑客户端导出到手持设备客户端；S2、在所述手持设备客户端建立资产离线数据库，并将所述Excel数据文件导入所述离线数据库；S3、基于所述手持设备客户端获取资产信息，并根据所述资产信息与所述离线数据库中的资产信息进行资产处理；以及S4、将资产处理的数据导出到新的Excel数据文件中保存到所述手持设备客户端，并将所述新的Excel数据文件通过所述电脑客户端传输到所述系统服务器中。Based on the above objective, in a third aspect of the embodiments of the present invention, a computer device is provided, including: at least one processor; and a memory, where the memory stores computer instructions that can be executed on the processor, and the instructions are executed by the processor to Implement the following steps: S1, export asset data from the system server to an Excel data file and save it to a computer client, and export the Excel data file from the computer client to a handheld device client; S2, in the handheld device The client establishes an asset offline database, and imports the Excel data file into the offline database; S3, acquires asset information based on the handheld device client, and performs asset management based on the asset information and the asset information in the offline database. processing; and S4, exporting the asset processing data to a new Excel data file and saving it to the handheld device client, and transmitting the new Excel data file to the system server through the computer client.
在一些实施方式中，所述将所述Excel数据文件导入所述离线数据库包括：读取所述Excel数据文件获得二进制数据对象，再将获取的所述二进制数据对象转化为二维数组；以及通过遍历所述二维数组将所述二维数组进行重新封装，并将重新封装后的数据根据属性插入到所述手持设备客户端的离线数据库中。In some embodiments, the importing the Excel data file into the offline database comprises: reading the Excel data file to obtain a binary data object, and then converting the obtained binary data object into a two-dimensional array; and Traverse the two-dimensional array to repackage the two-dimensional array, and insert the repackaged data into the offline database of the handheld device client according to the attribute.
在一些实施方式中，所述将资产处理的数据导出到新的Excel数据文件中保存到所述手持设备客户端包括：获取所述资产处理的数据以得到第二二维数组，对所述第二二维数组进行重新封装，并将所述重新封装后的第二二维数组转换为Excel文件。In some implementation manners, the exporting the asset processing data to a new Excel data file and saving it to the handheld device client comprises: acquiring the asset processing data to obtain a second two-dimensional array, The two-dimensional array is repackaged, and the repackaged second two-dimensional array is converted into an Excel file.
在一些实施方式中，所述根据所述资产信息与所述离线数据库中的资产信息进行资产处理包括：将所述资产信息与所述离线数据库中的资产信息进行比对；以及响应于所述资产信息与所述离线数据库中的资产信息不一致，将所述离线数据库中的资产信息进行更新。In some embodiments, the performing asset processing according to the asset information and the asset information in the offline database includes: comparing the asset information with the asset information in the offline database; and responding to the If the asset information is inconsistent with the asset information in the offline database, the asset information in the offline database is updated.
如图3所示，为本发明提供的上述移动资产离线处理的计算机设备的一个实施例的硬件结构示意图。As shown in FIG. 3 , it is a schematic diagram of the hardware structure of an embodiment of the computer device for offline processing of mobile assets provided by the present invention.
以如图3所示的装置为例，在该装置中包括一个处理器301以及一个存储器302。Taking the device shown in FIG. 3 as an example, the device includes a
处理器301和存储器302可以通过总线或者其他方式连接，图3中以通过总线连接为例。The
存储器302作为一种非易失性计算机可读存储介质，可用于存储非易失性软件程序、非易失性计算机可执行程序以及模块，如本申请实施例中的移动资产离线处理的方法对应的程序指令/模块。处理器301通过运行存储在存储器302中的非易失性软件程序、指令以及模块，从而执行服务器的各种功能应用以及数据处理，即实现移动资产离线处理的方法。As a non-volatile computer-readable storage medium, the
存储器302可以包括存储程序区和存储数据区，其中，存储程序区可存储操作系统、至少一个功能所需要的应用程序；存储数据区可存储根据移动资产离线处理的方法的使用所创建的数据等。此外，存储器302可以包括高速随机存取存储器，还可以包括非易失性存储器，例如至少一个磁盘存储器件、闪存器件、或其他非易失性固态存储器件。在一些实施例中，存储器302可选包括相对于处理器301远程设置的存储器，这些远程存储器可以通过网络连接至本地模块。上述网络的实例包括但不限于互联网、企业内部网、局域网、移动通信网及其组合。The
一个或者多个移动资产离线处理的方法对应的计算机指令303存储在存储器302中，当被处理器301执行时，执行上述任意方法实施例中的移动资产离线处理的方法。The
执行上述移动资产离线处理的方法的计算机设备的任何一个实施例，可以达到与之对应的前述任意方法实施例相同或者相类似的效果。Any one of the embodiments of the computer device for executing the above-mentioned method for offline processing of mobile assets can achieve the same or similar effects as any of the foregoing method embodiments corresponding to it.
本发明还提供了一种计算机可读存储介质，计算机可读存储介质存储有被处理器执行时执行移动资产离线处理的方法的计算机程序。The present invention also provides a computer-readable storage medium, where the computer-readable storage medium stores a computer program for executing a method for offline processing of mobile assets when executed by a processor.
如图4所示，为本发明提供的上述移动资产离线处理的计算机存储介质的一个实施例的示意图。以如图4所示的计算机存储介质为例，计算机可读存储介质401存储有被处理器执行时执行如上方法的计算机程序402。As shown in FIG. 4 , it is a schematic diagram of an embodiment of the computer storage medium for offline processing of the mobile asset provided by the present invention. Taking the computer storage medium shown in FIG. 4 as an example, the computer
最后需要说明的是，本领域普通技术人员可以理解实现上述实施例方法中的全部或部分流程，可以通过计算机程序来指令相关硬件来完成，移动资产离线处理的方法的程序可存储于一计算机可读取存储介质中，该程序在执行时，可包括如上述各方法的实施例的流程。其中，程序的存储介质可为磁碟、光盘、只读存储记忆体(ROM)或随机存储记忆体(RAM)等。上述计算机程序的实施例，可以达到与之对应的前述任意方法实施例相同或者相类似的效果。Finally, it should be noted that those of ordinary skill in the art can understand that all or part of the processes in the methods of the above embodiments can be implemented by instructing relevant hardware through a computer program, and the program of the method for offline processing of mobile assets can be stored in a computer. In reading the storage medium, when the program is executed, it may include the flow of the embodiments of the above-mentioned methods. Wherein, the storage medium of the program may be a magnetic disk, an optical disk, a read only memory (ROM) or a random access memory (RAM) or the like. The above computer program embodiments can achieve the same or similar effects as any of the foregoing method embodiments corresponding thereto.
以上是本发明公开的示例性实施例，但是应当注意，在不背离权利要求限定的本发明实施例公开的范围的前提下，可以进行多种改变和修改。根据这里描述的公开实施例的方法权利要求的功能、步骤和/或动作不需以任何特定顺序执行。此外，尽管本发明实施例公开的元素可以以个体形式描述或要求，但除非明确限制为单数，也可以理解为多个。The above are exemplary embodiments of the present disclosure, but it should be noted that various changes and modifications may be made without departing from the scope of the disclosure of the embodiments of the present invention as defined in the claims. The functions, steps and/or actions of the method claims in accordance with the disclosed embodiments described herein need not be performed in any particular order. Furthermore, although elements disclosed in the embodiments of the present invention may be described or claimed in the singular, unless explicitly limited to the singular, the plural may also be construed.
应当理解的是，在本文中使用的，除非上下文清楚地支持例外情况，单数形式“一个”旨在也包括复数形式。还应当理解的是，在本文中使用的“和/或”是指包括一个或者一个以上相关联地列出的项目的任意和所有可能组合。It should be understood that, as used herein, the singular form "a" is intended to include the plural form as well, unless the context clearly supports an exception. It will also be understood that "and/or" as used herein is meant to include any and all possible combinations of one or more of the associated listed items.
上述本发明实施例公开实施例序号仅仅为了描述，不代表实施例的优劣。The above-mentioned embodiments of the present invention disclose the serial numbers of the embodiments only for description, and do not represent the advantages and disadvantages of the embodiments.
本领域普通技术人员可以理解实现上述实施例的全部或部分步骤可以通过硬件来完成，也可以通过程序来指令相关的硬件完成，程序可以存储于一种计算机可读存储介质中，上述提到的存储介质可以是只读存储器，磁盘或光盘等。Those of ordinary skill in the art can understand that all or part of the steps of implementing the above embodiments can be completed by hardware, or can be completed by instructing relevant hardware through a program, and the program can be stored in a computer-readable storage medium. The storage medium can be a read-only memory, a magnetic disk or an optical disk, and the like.
所属领域的普通技术人员应当理解：以上任何实施例的讨论仅为示例性的，并非旨在暗示本发明实施例公开的范围(包括权利要求)被限于这些例子；在本发明实施例的思路下，以上实施例或者不同实施例中的技术特征之间也可以进行组合，并存在如上的本发明实施例的不同方面的许多其它变化，为了简明它们没有在细节中提供。因此，凡在本发明实施例的精神和原则之内，所做的任何省略、修改、等同替换、改进等，均应包含在本发明实施例的保护范围之内。Those of ordinary skill in the art should understand that the discussion of any of the above embodiments is only exemplary, and is not intended to imply that the scope (including the claims) disclosed by the embodiments of the present invention is limited to these examples; under the idea of the embodiments of the present invention , the technical features in the above embodiments or different embodiments can also be combined, and there are many other changes in different aspects of the above embodiments of the present invention, which are not provided in detail for the sake of brevity. Therefore, any omission, modification, equivalent replacement, improvement, etc. made within the spirit and principle of the embodiments of the present invention should be included within the protection scope of the embodiments of the present invention.
Claims (10)
Translated fromChinesePriority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210072576.3ACN114490652A (en) | 2022-01-21 | 2022-01-21 | A method, system, device and storage medium for offline processing of mobile assets |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210072576.3ACN114490652A (en) | 2022-01-21 | 2022-01-21 | A method, system, device and storage medium for offline processing of mobile assets |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114490652Atrue CN114490652A (en) | 2022-05-13 |
Family
ID=81472077
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210072576.3APendingCN114490652A (en) | 2022-01-21 | 2022-01-21 | A method, system, device and storage medium for offline processing of mobile assets |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114490652A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117093652A (en)* | 2023-10-17 | 2023-11-21 | 杭银消费金融股份有限公司 | Offline data synchronization method and system |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1862543A (en)* | 2006-06-21 | 2006-11-15 | 千乡万才科技(中国)有限公司 | Method for leading-in and deriving data in browser/servicer system |
| US20090177717A1 (en)* | 2008-01-03 | 2009-07-09 | Patrick Carson Meehan | System and method for providing recognized offline modification of a virtual asset |
| US8745684B1 (en)* | 2006-08-08 | 2014-06-03 | CastTV Inc. | Facilitating video search |
| CN104680319A (en)* | 2015-02-13 | 2015-06-03 | 中国人民解放军防化学院 | Fixed asset checking system |
| US20190096099A1 (en)* | 2017-09-27 | 2019-03-28 | International Business Machines Corporation | Visualizing linear assets using client-side processing |
| CN111581210A (en)* | 2020-04-30 | 2020-08-25 | 深圳壹账通智能科技有限公司 | Data importing method and system |
| CN111881150A (en)* | 2020-09-24 | 2020-11-03 | 深圳市互联工场科技有限公司 | Web application program offline data processing method and device |
- 2022
- 2022-01-21CNCN202210072576.3Apatent/CN114490652A/enactivePending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1862543A (en)* | 2006-06-21 | 2006-11-15 | 千乡万才科技(中国)有限公司 | Method for leading-in and deriving data in browser/servicer system |
| US8745684B1 (en)* | 2006-08-08 | 2014-06-03 | CastTV Inc. | Facilitating video search |
| US20090177717A1 (en)* | 2008-01-03 | 2009-07-09 | Patrick Carson Meehan | System and method for providing recognized offline modification of a virtual asset |
| CN104680319A (en)* | 2015-02-13 | 2015-06-03 | 中国人民解放军防化学院 | Fixed asset checking system |
| US20190096099A1 (en)* | 2017-09-27 | 2019-03-28 | International Business Machines Corporation | Visualizing linear assets using client-side processing |
| CN111581210A (en)* | 2020-04-30 | 2020-08-25 | 深圳壹账通智能科技有限公司 | Data importing method and system |
| CN111881150A (en)* | 2020-09-24 | 2020-11-03 | 深圳市互联工场科技有限公司 | Web application program offline data processing method and device |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117093652A (en)* | 2023-10-17 | 2023-11-21 | 杭银消费金融股份有限公司 | Offline data synchronization method and system |
| CN117093652B (en)* | 2023-10-17 | 2024-01-16 | 杭银消费金融股份有限公司 | Offline data synchronization method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107798038A (en) | Data response method and data response apparatus | |
| CN109462590A (en) | A kind of unknown protocol conversed analysis method based on fuzz testing | |
| CN113806332B (en) | Heterogeneous system integrated data processing method and device and computer equipment | |
| CN109241384A (en) | Scientific research information visualization method and device | |
| CN112035542A (en) | Information query method and device, electronic equipment and readable storage medium | |
| CN114201511A (en) | Project management and control method and device, computer equipment and storage medium | |
| CN114581210A (en) | Digital management method and system for enterprise finance based on RPA | |
| CN114490652A (en) | A method, system, device and storage medium for offline processing of mobile assets | |
| CN114968739A (en) | Operation and maintenance task management method, operation and maintenance method, device, equipment and medium | |
| CN112990937B (en) | Resource data acquisition method and device, computer equipment and storage medium | |
| CN114116908A (en) | Data management method and device and electronic equipment | |
| CN109636360A (en) | Automate the method and system of generation contract | |
| US20230418842A1 (en) | Data processing independent of storage, format or schema | |
| CN113641742B (en) | Data extraction method, device, equipment and storage medium | |
| CN117057922A (en) | Financial asset management method, device, equipment and medium based on page display | |
| CN114840187A (en) | Software architecture optimization method and device | |
| CN110399534A (en) | Method, device, device and storage medium for generating terminal performance report | |
| CN116955709A (en) | User data fusion processing method and system | |
| CN114240284A (en) | Material data transmission method and equipment and computer readable storage medium | |
| CN114860199A (en) | Software architecture optimization method, device and storage medium | |
| CN107169630B (en) | Purchasing risk internal control system | |
| CN112235363A (en) | Data processing method, device, electronic equipment, storage medium and system | |
| CN113010117B (en) | Storage capacity determination method, device and equipment | |
| CN114900511B (en) | Device and method for synchronously acquiring and loading middleware by industrial robot | |
| CN117459592B (en) | Service settlement method and device based on blockchain trusted monitoring data |
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 |