CN103064854A - Automatic detection inventory system based on extensible markup language (XML) technology - Google Patents

Abstract

The invention relates to automatic detection inventory systems, in particular to an automatic detection inventory system based on the extensible markup language (XML) technology. The automatic detection inventory system based on the XML technology is characterized by comprising the following key modules: a merchandise management module which is used for achieving a merchandise inventory information management function; a creation module which is used for creating an XML inventory record file in a system initialization process; a retrieval module which is used for realizing detection of inventory data through an automatic retrieval adapter; a comparison module which is used for comparing the inventory data read through the adapter with an early warning threshold value so as to realize automatic early warning of the inventory data; and a login authentication module which is used for retrieving and comparing the modules in a login process of a user, generating a user interface (UI) for the user to read and manage, finishing adding, deleting, altering and inquiring of a database by the system user, and recording information about the user and an inventory threshold value. The automatic detection inventory system based on the XML technology solves the problems that in an inventory detection process in the prior art, operation is quite cumbersome, the inventory data is not high in portability, and the like.

Description

A kind of automatic detection inventory system of XML-based technology

Technical field

The present invention relates to automatically detect inventory system, especially a kind of automatic detection inventory system of XML-based technology.

Background technology

Development along with computer technology, the main business of present vast medium-sized and small enterprises is processed all to concentrate in the software systems and is carried out, in the software systems of the present application of process, purchase, sales and inventory management system has obtained application in numerous enterprises, become the most important thing in its informatization, and in purchase, sales and inventory management system, a kind of important application is exactly detection and the management for the stock, only has the automatic detection that has realized the stock, in daily business procession, could grasp more timely the stockpile number of relative article, make the larger effect of purchase, sales and inventory management system performance.

Detect for the stock who realizes in the JXC System at present, generally be based on data base querying and finish, by the corresponding querying condition of input in operation system, such as Item Title, inquire the stock who changes article by database index.

But there is following drawback in above-mentioned technology: the one, and the ease for use of data is not high, method by data base querying needs artificial input inquiry condition, can't realize that by the mode of customization real-time stock detects and inquiry, the 2nd, the transplantability of data is not enough, data communication device in the operation system is crossed to be stored in the database and is realized, so that business datum can't smoothly be transplanted, especially carry out between different manufacturers in the data transmission procedure, the difference of data layout is so that need secondary development just can finish.

The present invention is by the application of XML-based technology, in the process that the stock detects, use the XML file to replace the mode of existing data-base recording, so that data memory format is comparatively open, by the realization of XML automatic reading function, can realize stock's automatic detection simultaneously, make the automated inventory detection in the JXC System be more prone to realize, and inventory data has good portability, is convenient to mutual between system.

Summary of the invention

The object of the invention is to: for the deficiencies in the prior art, automated inventory by the XML-based technology detects, make the stock's testing process in the operation system easier, make data possess good portability, be convenient to the level and smooth movement of data between operation system not of the same race.

For achieving the above object, the present invention includes following functional module:

Kinds of goods management: the functions such as the increase of realization stock, deletion, modification, inquiry;

---described kinds of goods management function has mainly been finished increasing, delete, changing of operation system kinds of goods, record simultaneously the base attribute of kinds of goods, in the data essential record that produces and the table of the goods in the database, main key assignments is gid (unique ID values of expression kinds of goods), gname (kinds of goods name).

Creation module: in the process of system initialization, create the XML inventory records file;

---described creation module function is mainly finished in the operation system initialization procedure, creates the XML file that is used for the record stock, and the form of its essential record is:

<Goods?id＝″0001″>

<Number>300</Number>

</Goods>

Retrieval module: by automatic retrieval adapter, read the data in the XML file, realize the detection of inventory data;

---described detection module function mainly finish by adapter read commodity in the XML file＜id and＜Number value, and the information of obtaining passed to comparing module;

Comparing module: compare by the inventory data and the early warning threshold values that read in the adapter, realize stock's automatic early-warning;

---described comparing module function mainly finish with retrieval module transmit＜id and＜Number the kinds of goods early warning threshold values of access compares in value and the database, and after contrast is finished, provides corresponding early warning information according to comparison rules, returns the UI interface;

The login authentication module: in the process of user's login, retrieval module and comparing module generate the UI interface for users and read;

---described login authentication functions of modules is finished in process of user login, the legitimacy of checking login user, and show that corresponding kinds of goods data are to the user;

User management: completion system user's increase, deletion, modification, inquiry;

---described user management module has mainly been finished increasing, delete, change, looking into of operation system user, record simultaneously the role who has, the data owner that produces will be recorded in the User table in the data, and main key assignments is userid (unique ID value of identifying user information), username (user name), password (user cipher);

Database: be used for record inventory information, user profile and stock's threshold values information.

---described database mainly comprises User table, goods table, boundary table.

The user uses step to be:

Step 1: be the system creation validated user by user management;

Step 2: after the validated user login, use the kinds of goods administration module, for operation system is added inventory information, and create the XML file that is used for record kinds of goods stock;

Step 3: the Back ground Information of kinds of goods is recorded in the database, quantity information and the ID of kinds of goods is recorded in the XML file;

Step 4: in the process that the user logins, legitimacy by login authentication module verification login user, call retrieval module and comparing module, the inventory information that automatically detects is passed through the UI showing interface to legal login user, realize automatically detecting the stock.

Embodiment

The feature that the present invention announces and use step all can be carried out the equivalence replacement by similar function, and unless specifically stated otherwise, the arbitrary steps in this embodiment are an example of a series of equivalences or similar characteristics.

Embodiment one

Use Microsoft VisualStudio.Net developing instrument exploitation client operating software, use database management tools SqlServer2005 special-purpose on the market to set up the needed database of system, the user uses step to be:

Step 1: by user management module, for operation system creates validated user, and this user profile is recorded in the user table of database, is user assignment userid and record username and password;

Step 2: use the kinds of goods administration module by the user, in operation system, add inventory information, the title of kinds of goods is added in the goods table among the gname, and the gid that distributes id to be recorded in the goods table for kinds of goods is listed as, simultaneously in the Background scheduling creation module, for operation system creates initialized XML file, and be kinds of goods setting early warning threshold values, during the threshold values storage is shown with boundary;

Step 3: in the user carries out process that inventory information safeguards, the gid of these kinds of goods is added in the XML file, add the quantity of these kinds of goods to XML file＜Number〉in;

Step 4: in the process of user login of operation system, call the login authentication module, the legitimacy of authentication of users, after the user passes through legitimate verification, the Automatically invoked retrieval module, the adapter by retrieval module reads gid and the number in the XML file, and the threshold values information exchange in its number value and the boundary table is crossed comparing module compare, comparison result is turned back to the UI interface for users read, realize stock's automatic detection.

In addition to the implementation, the present invention can also have other embodiments.All employings are equal to the technical scheme of replacement or equivalent transformation formation, all drop on the protection domain of requirement of the present invention.

Claims (2)

1. the automatic detection inventory system of an XML-based technology is characterized in that: stock's automatic detection needs such as lower module:

Kinds of goods management: the functions such as the increase of realization stock, deletion, modification, inquiry;

Creation module: in the process of system initialization, create the XML inventory records file;

Retrieval module: by automatic retrieval adapter, read the data in the XML file, realize the detection of inventory data;

Comparing module: compare by the inventory data and the early warning threshold values that read in the adapter, realize stock's automatic early-warning;

The login authentication module: in the process of user's login, retrieval module and comparing module generate the UI interface for users and read;

User management: completion system user's increase, deletion, modification, inquiry;

Database: be used for recording user information and stock's threshold values information.

2. the automatic detection inventory system of described a kind of XML-based technology according to claim 1, be further characterized in that: the automatic detection of finishing the stock needs following steps:

Step 1: be the system creation validated user by user management;

Step 2: after the validated user login, use the kinds of goods administration module, for operation system is added inventory information, and create the XML file that is used for record kinds of goods stock;

Step 3: the Back ground Information of kinds of goods is recorded in the database, quantity information and the ID of kinds of goods is recorded in the XML file;

Step 4: in the process that the user logins, legitimacy by login authentication module verification login user, call retrieval module and comparing module, the inventory information that automatically detects is passed through the UI showing interface to legal login user, realize automatically detecting the stock.