JP3072440B2 - Slip processing device - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a slip processing apparatus which allows an unspecified number of users to simultaneously access a database for updating.

[0002]

2. Description of the Related Art In a conventional slip processing apparatus, an unspecified number of users often need to update data registered in a database during a certain period of time. When users concentrate on one data, when a certain user updates the data, the slip processing device performs exclusive control, prohibits other users from updating, and waits. Then, the exclusive control is released to allow another user to perform the update processing, and the exclusive control is applied in the same manner as described above.

[0003]

In the conventional slip processing apparatus as described above, when another user performs an update process, it is only known through the input / output device that the current user is performing the update process. There is a problem that the name of the user who is updating is not known.

[0004] Further, there is a problem that the update process takes a long time or that the user of the update process cannot be inquired even if there is any doubt about the content of the update process.

SUMMARY OF THE INVENTION The present invention has been made to solve such a problem, and temporarily stores the name of a user who is currently performing an update process. It is an object of the present invention to obtain a slip processing device capable of displaying a user name and update data on an input / output device.

[0006]

A slip processing device according to the present invention is a device for registering slip data from a plurality of input / output devices in a database on a host computer side and updating the content thereof. Name, ID code,
A user database in which user information including a password and the like is stored, a slip number, update data including a drawing number corresponding to the slip number, an ID code of a previous updater who has been updated last time, and a current update. The slip database in which the ID code of the current renewer is stored and the ID code and password of one user input from one input / output device at the time of updating are checked to see if they are registered in the user database. If there is, the above one user ID
A user check unit for storing a code in a temporary storage unit, and a slip number is input from the one input / output device after the ID code of the one user is stored in the temporary storage unit by the user check unit. Check whether the ID code of the one user is registered in the slip database, and if not, check the ID code of the one user.
A code is registered in the slip database as the ID code of the current renewer, and subsequently, the user information of the previous renewer from the user database based on the ID code of the previous renewer registered in the slip database At the same time, the registration data of the previous updater corresponding to the slip number input from the one input / output device is extracted from the slip database and displayed on the one input / output device, and the desired update data is output from the one input / output device. The slip database is input to update the slip database, and after the update, the ID code of the previous updater in the slip database is rewritten to the ID code of the current updater to erase the ID code of the current updater and temporarily store the ID code. Means for deleting the ID code of the current renewer stored in the means, and updating the same I / O device from another I / O device while updating the data. When there is a request to update the vote number, the ID code of the current renewer is checked in the slip database and stored in the user database corresponding to the ID code of the current renewer if the ID code of the current renewer is registered. Slip data registration and display of the user information of the one user, the update data of the current renewer stored in the slip database, and the message being updated on the other input / output device and waiting for the update process. Update means.

[0007]

According to the present invention, when one user's ID code and password are input from one input / output device at the time of updating,
The user checking means checks whether the input ID code and password are registered in the user database, and if registered, stores the ID code in the temporary storage means. Then, after the ID code is stored in the temporary storage means by the user checking means, and when the slip number is inputted from one of the input / output devices, the slip data registration / update means makes the current updater corresponding to the inputted slip number I
Check whether the D code is registered in the slip database, and if not registered, let the ID code of the one user be registered in the slip database as the ID code of the current updater, and then register in the slip database The user information of the previous updater is retrieved from the user database based on the ID code of the previous updater and the registration data of the previous updater corresponding to the slip number input from the one input / output device is stored in the form. When it is taken out from the database and displayed on the one input / output device and desired update data is input from the input / output device, the slip data registration / update means updates the update data in the slip database, and after the update, Previous updater of slip database I
The D code is rewritten to the ID code of the current updater to erase the ID code of the current updater and the ID code of the current updater stored in the temporary storage means is erased. If another input / output device requests update of the same slip number while updating data in one input / output device, the slip data registration / update means checks the ID code of the current updater in the slip database. If the ID code of the current updater is registered, the user information of the one user stored in the user database corresponding to the ID code of the current updater, the current updater stored in the slip database The update data and the message being updated are displayed on another input / output device, and the update process is made to wait.

[0008]

FIG. 1 is an explanatory view showing one embodiment of the present invention, and FIG.
3 is an explanatory diagram of the user database of FIG. 1, and FIG. 4 is an explanatory diagram of the slip database of FIG. In the figure, reference numeral 1 denotes a terminal-side input / output device connected via a communication line, for inputting slip data or the like based on a format screen or data stored in a database (slip data, user data), etc. Is displayed. Reference numeral 2 denotes a communication control device connected to the input / output device 1 via a communication line, and accesses a central processing unit (to be described later) on the host side by an interrupt signal input together with a data input from the input / output device 1. Transfer control), and controls transfer of data stored in the database to the input / output device 1 based on a command from the central processing unit. Reference numeral 3 denotes a host-side central processing unit including a CPU and a storage unit. Based on a database processing program stored in the storage unit, the CPU externally stores data input by the input / output device 1 via the communication control device 2. Disk device (described later)
And the data stored in the magnetic disk device is displayed on the input / output device 1 via the communication control device 2. Reference numeral 4 denotes a magnetic disk device connected to the central processing unit 3, which registers, updates, and deletes data as a database based on instructions from the central processing unit 3. The database in the magnetic disk device 4 includes a user database 4a for storing and storing data such as user names, employee codes and pass codes of the users, a slip number, a product name corresponding to the slip number, a quantity, A slip database 4b for storing and storing data of delivery dates and drawing numbers, and a drawing number database 4c for storing and storing the drawing numbers collectively are provided.

Reference numeral a denotes input / output control means, which is a user check means (described later) which transmits data from the input / output device 1 via the communication control device 2 based on a database processing program stored in a storage unit of the central processing unit 3. ) Or a transfer control by a slip data registration / update means (described later), and a transfer control of data from the user check means or the slip data registration / update means to the input / output device 1 via the communication control device 2.

Reference numeral b denotes user check means for input / output control of user's employee code and pass code data input from the input / output device 1 based on a database processing program stored in the storage unit of the central processing unit 3. It is received from the means a, and it is checked whether the received data is stored in a user database (described later).

Reference numeral c denotes a temporary storage unit which stores the employee code when the data is collated by the user check unit b based on the database processing program stored in the storage unit of the central processing unit 3.

Reference numeral d denotes a slip data registering / updating means, which accesses the slip database 4b or the drawing number database 4c based on a database processing program stored in the storage unit of the central processing unit 3 to perform processing such as registration / update / deletion. In addition, the data stored in the slip database 4b is displayed on the input / output device 1 via the input / output control means a. Further, when the update process is completed, the employee code in the current updater column of the slip database is displayed. Is deleted and the employee code is stored in the temporary storage means c.

Reference numeral e denotes a database input / output means which controls the transfer of data from the slip data registration / update means d to the slip database 4b based on a database processing program stored in the storage unit of the central processing unit 3, and uses the data. User database 4a, chit database 4b or drawing number database 4c based on data access from user check means b or chit data registration / update means d.
Is controlled to be transferred to the user check means b or the slip data registration / update means d.

F is a screen format storage means in which a format screen required for a response with the input / output device 1, the user check means b, or the slip data registration / update means d is stored in the storage unit of the central processing unit 3. ing.

The slip processing apparatus of the present invention is configured as described above. FIG. 5 is a flowchart showing the operation of the present invention, FIG. 6 is an input format screen of the user checking means, and FIG. 8 is an input format screen for inputting a slip number of the update means (1), FIG. 8 is an input format screen for items corresponding to the slip number of the slip data / update means (2), and FIG. 9 is updating the slip data registration / update means. Is displayed, and the operation of the present apparatus will be described based on the flowchart of FIG.

First, in step 1, the input / output device 1
, The input / output control means a calls the screen format stored in the screen format storage means f and causes the input / output device 1 to display the user processing screen shown in FIG. , Proceed to step 2.

In step 2, when the user inputs his / her employee code and password in the employee code field and the pass code field displayed on the input / output device 1, the user check means b enters the input / output control means. The employee code and the password are received through a, and the user database 4a is accessed through the database input / output means e to check whether the employee code and the password are registered, and the process proceeds to step 3. .

In step 3, if the user check means b determines that the employee code and the password are not registered in the user database 4a, the process proceeds to step 4, and if it is determined that they are registered. Goes to step 5.

In step 4, the user check means b causes the input / output device 1 to display a message indicating that there is no corresponding person via the input / output control means a, and returns to step 2.

In step 5, the user check means b writes the employee code registered in the user database 4a into the temporary storage means c and proceeds to step 6.

In step 6, the user checking means b reads out the screen format for slip processing stored in the screen format storage means f and sends it to the input / output device 1 via the input / output control means a as shown in FIG. The displayed slip processing screen is displayed, and the process proceeds to step 7.

In step 7, when the user inputs a slip number to be updated in the slip number field, the slip data registration /
The update means d receives the slip number data input to the input / output device 1 via the input / output control means a, and then accesses the slip database 4b via the database input / output means e to store the slip number data in the slip database 4b. It is checked whether or not the above-mentioned slip number has been registered, and the routine proceeds to step 8.

In step 8, if the slip data registering / updating means d determines that the slip number data is not registered in the slip database 4b, it proceeds to step 9; if it determines that it is registered, Goes to step 10.

In step 9, the slip data registration / updating means d causes the input / output device 1 to display a message indicating that there is no corresponding data via the input / output control means a, and returns to step 7.

In step 10, registration of slip data
Updating means d receives all data (slip number, employee code in previous updater column, employee code in current updater column, product name, drawing, etc.) corresponding to the slip number in slip database 4b via database input / output means e. (No., quantity, delivery date) is read (see FIG. 4), and it is checked whether or not the employee code in the current renewer column is written in the data. If the employee code is written in the current updater column, the process proceeds to step 11 because the other input / output device is currently updating, and if the employee code is not written in the current updater column. Is not being updated, the process proceeds to step 13.

In step 11, the slip data registration and
The updating means d accesses the user database 4a via the database input / output means e on the basis of the employee code written in the current updater field in the slip database 4b, and inputs the name, affiliation name and telephone number. Read, step 12
Proceed to.

In step 12, registration of slip data
The update means d reads the data of the name, affiliation name and telephone number read from the user database and all the data corresponding to the slip number previously read from the slip database 4b (the slip number, the employee in the previous updater column). The input / output control means a displays the processing screen during the update shown in FIG. 9 on the input / output device 1 and the user code, the employee code in the current updater column, the employee code, the product name, the drawing number, the quantity, and the delivery date. The process returns to step 7 after notifying that updating is in progress. From this display screen, the user can easily understand at a glance that the update processing is being performed by another input / output device with the same slip number. Can be urged to end the task as soon as possible. If there is any doubt about the updated content, an inquiry can be made.

In step 13, if the employee code is not written in the current updater field of the slip database 4b, the slip data registration / update means d is a temporary storage means in which the employee code of the user is written. Then, the employee code is taken out from c, and the employee code is written into the current renewer column corresponding to the slip number in the slip database 4b via the database input / output means e, and the process proceeds to step 14.

In step 14, slip data registration and
The updating means d retrieves the employee code in the previous updater column corresponding to the slip number in the slip database 4b via the database input / output means e, and, based on the employee code, via the database input / output means e. The name, affiliation name and telephone number in the user database 4a are read out, and the process proceeds to step 15.

In step 15, registration of slip data
The update means d displays the form processing screen in FIG. 8 on the input / output device 1 in FIG. 8 via the input / output control means a, including the contents of all the form data corresponding to the form number and the name, affiliation name and telephone number. Proceed to 16. At this time, if there is any doubt about the displayed update content, the previous updater can be contacted by telephone to inquire about the update content.

In step 16, when the user inputs a drawing number from the input / output device 1, the slip data registration / update means d receives the drawing number via the input / output control means a, and the drawing number is It is checked via the database input / output means e whether or not it is registered in the number database 4c, and the process proceeds to step 17.

At step 17, registration of slip data
The updating means d determines that the drawing number is the drawing number database 4c.
If it is determined that the drawing number is not registered in the drawing number database 4c, the process proceeds to step 18.

At step 18, registration of slip data
The updating means d makes a message to the effect that the drawing number is erroneously input through the input / output control means a, causes the input / output device 1 to display the message, and returns to step 16.

In step 19, slip data registration and
The updating means d writes the updated data into the slip database 4b via the database input / output means e in correspondence with the slip number in the slip database 4b, and step 20
Proceed to.

In step 20, when the user finishes the updating process, the slip data registering / updating means d updates the employee code in the previous updater column in the slip database 4b through the database input / output means e. The employee code of the current updater is rewritten with the employee code of the current updater, the employee code of the current updater column is deleted, and the employee code of the current updater written in the temporary storage means c is also deleted.

As described above, even if another user has previously updated the data of the same slip number, the update status and the name of the user are displayed on the input / output device, and the progress status is displayed. We can respond accordingly.

[0037]

As described above, according to the present invention, when data is updated based on a voucher number, even if data of the same voucher number is updated, use of the user who is currently updating The update status of user information and data is displayed on the input / output device and made to wait, so that when the progress of the user who is currently updating is slow, the user is inquired with the user information to facilitate the work. In addition, even if there is any doubt about the data at the time of updating, it is possible to inquire the user and correct the data at the time of updating.

When updating data, the user information of the previous updater is also displayed in correspondence with the data updated by the previous updater. With the information, it is possible to make an inquiry to the previous updater.

[Brief description of the drawings]

FIG. 1 is an explanatory diagram showing one embodiment of the present invention.

FIG. 2 is a hardware configuration diagram of FIG. 1;

FIG. 3 is an explanatory diagram of a user database of FIG. 1;

FIG. 4 is an explanatory diagram of a slip database of FIG. 1;

FIG. 5 is a flowchart showing the operation of the present invention.

FIG. 6 is an input format screen of a user check unit.

FIG. 7 is an input format screen of a slip number of a slip data registration / update means.

FIG. 8 is an input format screen for items corresponding to the slip number of the slip data registration / update means.

FIG. 9 is a message screen for notifying that the slip data registration / update unit is updating.

[Description of Signs] 1 input / output device 2 communication control device 3 central processing unit 4 magnetic disk device a input / output control means b user check means c temporary storage means d slip data registration / update means e database input / output means f screen fore Mat storage means 4a User database 4b Slip database 4c Drawing number database

Claims (3)

(57) [Claims] An apparatus for registering slip data from a plurality of input / output devices in a database of a host computer and updating the contents thereof, wherein at least user information including a user name, an ID code, a password, etc. The user database to be stored, the slip number, the updated registration data including the drawing number corresponding to the slip number, the ID code of the previous updater who has been updated last time, and the current update that is currently being updated Person's ID
Checks whether the slip database in which the codes are stored and the ID code and password of one user input from one input / output device at the time of updating are registered in the user database. User check means for storing the user's ID code in the temporary storage means, and the slip number is input from the one input / output device after the one user's ID code is stored in the temporary storage means by the user check means Then, it is checked whether the ID code of the one user is registered in the slip database, and if not, the ID code of the one user is registered in the slip database as the ID code of the current updater. Then, based on the ID code of the previous updater registered in the slip database, the user database The user information of the previous updater is taken out from the database and the registered data of the previous updater corresponding to the slip number input from the one input / output device is taken out from the slip database and displayed on the one input / output device. The desired update data is input from the input / output device to update the slip database, and after the update, the ID code of the previous updater of the slip database is rewritten to the ID code of the current updater to update the ID code of the current updater. A slip data registering / updating means for deleting an ID code and deleting an ID code of a current renewer stored in the temporary storage means. 2. An apparatus for registering slip data from a plurality of input / output devices in a database of a host computer and updating the contents thereof, wherein at least user information including a user name, an ID code and a password is stored. The user database to be stored, the slip number, the updated registration data including the drawing number corresponding to the slip number, the ID code of the previous updater who has been updated last time, and the current update that is currently being updated Person's ID
Checks whether the slip database in which the codes are stored and the ID code and password of one user input from one input / output device at the time of updating are registered in the user database. User check means for storing the ID code of the user in the temporary storage means; and when there is a request for updating the same slip number from another input / output device while updating the data in the one input / output device, Check the ID code of the updater and check the I
When the D code is registered, the user information of the one user stored in the user database corresponding to the ID code of the current updater, the update data of the current updater stored in the slip database, and the update A slip data registering / updating means for displaying a middle message on the other input / output device and waiting for an update process. 3. An apparatus for registering slip data from a plurality of input / output devices in a database of a host computer and updating the contents thereof, wherein at least user information including a user name, an ID code, a password, etc. The user database to be stored, the slip number, the updated registration data including the drawing number corresponding to the slip number, the ID code of the previous updater who has been updated last time, and the current update that is currently being updated Person's ID
Checks whether the slip database in which the codes are stored and the ID code and password of one user input from one input / output device at the time of updating are registered in the user database. User check means for storing the user's ID code in the temporary storage means, and the slip number is input from the one input / output device after the one user's ID code is stored in the temporary storage means by the user check means Then, it is checked whether the ID code of the one user is registered in the slip database, and if not, the ID code of the one user is registered in the slip database as the ID code of the current updater. Then, based on the ID code of the previous updater registered in the slip database, the user database The user information of the previous updater is taken out from the database and the registered data of the previous updater corresponding to the slip number input from the one input / output device is taken out from the slip database and displayed on the one input / output device. The desired update data is input from the input / output device to update the slip database, and after the update, the ID code of the previous updater of the slip database is rewritten to the ID code of the current updater to update the ID code of the current updater. Deleting the ID code of the current renewer stored in the temporary storage means,
In addition, when the same input / output device requests updating of the same slip number from another input / output device while updating the data, the ID code of the current updater is checked in the slip database and the ID code of the current updater is checked. When registered, the user information of the one user stored in the user database corresponding to the ID code of the current renewer, the update data of the current renewer stored in the slip database, and being updated. A slip data registering / updating means for displaying a message on the other input / output device and waiting for an update process;