Off-line order-pickingtask processing method based on SQLitedatabase

Abstract

The invention discloses an off-line order-pickingtask processing method based on SQLite database.The off-line order-pickingtask processing method mainly comprises the steps that a local SQLite database of an off-line task is established, network monitoring and data polling are executed, the content four main processes of the off-line task database are updated according to execution results. A real-time request is made into the off-line task in a novel networkrequest mode, all states relevant to the request are related and saved by using the SQLite database, and the off-line task is managed and executed through network state monitoring, so that a user does not perceive the dependency on networks of programs in the operating process, and especially the off-line order-pickingtask processing method has the important significance on shortening of the order performance time and improvement of fluency of order picking operation in the e-commerce process.

Description

technical field [0001] The invention relates to a data processing technology, in particular to an off-line data processing method based on an SQLite database. Background technique [0002] With the rapid development of e-commerce, purchasing fresh food online is getting closer and closer to people's daily life. In cities, due to the increasing time and price costs of transportation and travel, online purchasing fresh food is due to its proximity to supermarkets for picking and delivering. , The feature of delivering to users within a few hours is highly praised by users. A very important link in e-commerce is to quickly and accurately pick up the required goods according to the customer's order, and deliver the picked goods in time. Now logistics There are generally two picking modes in management: [0003] One is to adopt the "human and animal static" method, that is, the picker carries the order information, and picks from the shelf in a way that is constantly moving in t...

AI Technical Summary

Problems solved by technology

[0005] The above two picking methods have their own defects. The second picking method has a complicated process and needs to prepare a special assembly line, occupying the space resources of the warehouse and increasing the cost input. Moreover, the mobile operation method increases the workload of the pickers. Spiritual devotion is prone to wrong picking and missing picking. From the perspective of the long-term development of e-commerce logistics, the market prospect is not optimistic; the first picking method is flexible and simple in process, easy to operate, and can give full play to the subjective initiative of pickers However, due to the current electronic management of picking operations has become a trend, and large-scale freight yards or warehouses have blind areas of network signals due to the obstruction of goods or buildings themselves, often picking personnel arrive at the exact storage point but find that this area There is no network signal or the signal strength is too weak to send the picking information back to the task management terminal in the background in real time, so the picker needs to carry the picked goods to the area with network signal to complete the synchronization of the picking status , order status synchronization and other information required for picking management, the pickers move around to search for network signals, on the one hand, it leads to lower operating efficiency and reduces the enthusiasm of the pickers, and at the same time, if large and fragile items are being dragged The risk of damage will inevitably increase during the process of operation. If the network request becomes a checkpoint in the operation process, the real-time performance of picking and subsequent delivery will be greatly reduced.

Images