Book distribution method and system

Abstract

The invention relates to a book distribution method and system. The book distribution method includes the following steps: step S1, clearing all records, of which numbers are zero, in a warehouse inventory database; step S2, obtaining the total number N of records in the warehouse inventory database by counting; step S3, setting a variable I of which an initial value is 1; step S4, judging whether I is greater than or equal to N, if yes, executing step S9, and otherwise, executing step S5; step S5, reading a book number and a warehouse inventory of an I-th record in the warehouse inventory database; step S6, using the book number to query a retail-store inventory in a book retail-store inventory database; step S7, judging whether a retail-store inventory number is equal to 0, if yes, executing step S8, and otherwise, executing a step that I is equal to I plus 1, and then executing the step S4; step S8, storing the book number of and the warehouse inventory number into a distribution database, executing the step that I is equal to I plus 1, and then executing the step S4; and step S9, displaying distribution data. The method automatically carries out distribution, improves the efficiency, and expands sales.

Description

technical field [0001] The invention relates to the field of databases, in particular to a book distribution method and system. Background technique [0002] Book management is a special industry operation. Bookstores of the same size operate far more varieties than department store supermarkets. Therefore, the management of varieties in book management is a difficult problem that often plagues bookstore operators. For example, if a certain type of books is still in stock in the warehouse, It has been sold out in the store, but because it cannot be distributed in time, it is often easy to cause economic losses, so a method and system for book distribution are needed. Contents of the invention [0003] The technical problem to be solved by the present invention is to provide a book distribution method and system for the deficiencies of the prior art. [0004] The technical solution of the present invention to solve the above-mentioned technical problems is as follows: a bo...

AI Technical Summary

Problems solved by technology

[0002] Book management is a special industry operation. Bookstores of the same size operate far more varieties than department store supermarkets. Therefore, the management of varieties in book management is a difficult problem that often plagues bookstore operators. For example, if a certain type of books is still in stock in the warehouse, It has been sold out in the store, but because it cannot be distributed in time, it is often easy to cause economic losses, so a method and system for book distribution are needed

Images