JP3280664B2 - Data processing device - Google Patents

Description

Description: BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data processing apparatus that performs file update and output processing such as display and printing based on data input based on a preset definition.

[Conventional technology]

The duties of companies are diverse, and even in the same industry, the business content differs from company to company, and the business content differs depending on each workplace in the company. Therefore, data generated at each business entity, There are many different types of data.
Therefore, modern enterprises have introduced OA (office automation) equipment and office computers as a means of processing and managing such data at high speed.

[Problems to be solved by the invention]

However, there have been a number of complaints at the conventional computer adoption companies. In other words, in companies that have introduced OA equipment and office computers so far, a large amount of useless book materials are output from the computers, and on the other hand, they have been effectively used while introducing computers with angled corners. Very often, they are not. This is something many computer users have experienced. Such a problem is based on the ability or sensitivity of the SE or programmer responsible for the software of the user, or the inappropriateness of the user's request.

In addition, a great deal of labor, time, and money were required for system design (data processing flow, file system, file contents, code system, etc.) that required user needs.

SUMMARY OF THE INVENTION It is an object of the present invention to make system development simple and to quickly expand and maintain a system.

[Means for solving the problem]

The present invention provides input definition storage means for storing any defined contents in a definition table having a column for defining a plurality of input word names required for input, a file name to be updated, a keyword name, A file definition storage means for storing arbitrary defined contents in a definition table having a column for defining an update word name to be updated, an output word name required for output, and its output format are defined Output definition storage means for storing any defined contents with respect to the definition table, and each data input corresponding to each input word name defined in the definition table stored in the input definition storage means An input means for performing an input processing process on, a data storage means for storing each word data corresponding to each word name input by the input means, and Including the name of the file to be updated defined in the definition table stored in the file definition storage means, each word data corresponding to the keyword name and the updated word name defined in the definition table is read from the data storage means and updated. A record creation unit for creating a record, an update record storage unit for storing the update record created by the record creation unit, and each update stored in the update record storage unit based on a file update instruction. File update means for executing a file update process based on each word data included in the update record for a file corresponding to the update target file name included in the update record; It is activated later and corresponds to the output word name defined in the definition table stored in the output definition storage means. The word data is read out from said data storage means, to an output means for outputting at defined output format in the definition table, and characterized by including the.

〔Example〕

An embodiment will be described below with reference to FIGS. 1 to 6.

FIG. 1 shows a system configuration diagram of a data processing apparatus for performing processing such as issuing a slip. In FIG. 1, an input device 11 includes, for example, a numeric keypad, a function designation key for designating various types of processing, and a function key. Then, the process type designation data and the edit data input from the input device 11 are sent to the edit processing device 12, and the edit processing device 12 accesses the PS file 13. The PS file 13 includes word names to be input and definition data (hereinafter referred to as Table A) for defining the word conditions, and file names, keywords, and update types for updating the master file. , And definition data for defining an update word (hereinafter referred to as Table C), definition data for defining a word name to be displayed and its display format (hereinafter referred to as Table D),
Word data to be printed and definition data for defining the printing format (hereinafter referred to as table E) are set and stored in advance for each processing content of various business processes. Tables A to E defined for each processing content are collectively referred to as a definition document PS, and a plurality of definition documents PS (PS1, PS2,
…) Is set.

Thus, the edit processing device 12 is provided with the input device 11
Create file format based on instructions from PS
The data setting to the file 13 and the reading of the PS are performed. When the PS is read from the PS file 13, the table A is stored in the input word memory 14, and the table C is stored in the file word memory 16.
Next, the table D is loaded into the display word memory 17 and the table E is loaded into the print word memory 18, and then a start command is given to the input processing device 20. The table A loaded into the input word memory 14 is sent to the input processing device 20 and stored in the file word memory 16.
The table C loaded into the display word memory 17 is sent to the display processing device 22, the table C loaded into the display word memory 17 is sent to the file creation device 21, and the table E loaded into the print word memory 18 is sent to the print processing device 23.
Is read to The input processing device 20 is connected to the input device 11 and RAMs such as an index table memory 24, a file format memory 25, and a word memory 26. The index table memory 24 stores the date of the day and a number (slip number) that is automatically updated each time a slip is issued, and stores, in advance, a product code, a product name, and a unit price for various products. I have. In the file format memory 25, a file format is set in advance from the input device 11 via the edit processing device 12. This file format defines the format of each file stored in the master file 29. For example, the record structures of various files such as “sales detail file”, “customer management file”, and “sales management file” are set. In the case of the above file, for example, a “sales statement file”, “date number, product code” is a keyword, and “unit price, quantity, amount” is an update word. Then, the input processing device 20 performs various input arithmetic processes such as calculation and search based on the A table read from the input word memory 14 and the input data from the input device 11 and the like, and processes the processed word data in the A table. The data is stored in the word memory 26 in association with the defined word name, and the file creation device 21, the display processing device 22, and the print processing device 23 are activated according to the data processing. The file creation device 21 is connected with a file format memory 25 and a maintenance file 27. The file creation device 21 starts a processing operation in response to a start command from the input processing device 20,
Based on the C table stored in the file work memory 16, a maintenance record for file update (this record includes a file name to be updated and a code indicating an update type, and is stored in the order corresponding to the record structure of the corresponding file) (Including keyword data and update word data), and sequentially register them in the maintenance file 27. In the maintenance file 27, a plurality of maintenance records are registered, sent to the file update device 28 based on a command from the input device 11 or the input processing device 20, and updated and registered for the corresponding file in the master file 29. You. The master file 29 is connected to the input processing device 20 in a readable manner.

The display processing device 22 starts a processing operation in response to a start command from the input processing device 20, reads out data in the work memory 26 based on the D table stored in the display word memory 17, and creates display data. Is displayed on the display device 30.
When a start command is given from the input processing device 20, the print processing device 23 creates chit data in a designated format based on the data read from the work memory 26 based on the E table stored in the print word memory 18, and prints the slip data. The device 31 is driven to print out the slip.

The PS file 13 includes various PSs, for example, a PS1 for performing sales slip processing and a P for performing purchase slip processing as shown in FIG.
S2, PS3 for outputting a customer-specific summary table, PS4 for updating a monthly sales file, and so on are set.

The slip issuing type PS1 that performs the above sales slip processing includes Table A (A11), Table C (C11, C12), Table D (D11), and Table E (E11).
Specifically, it is configured as shown in FIG. 3 (a). That is, in table A (A11) for creating words necessary for file update and slip output from the input data, the heading word name such as “date, slip number” is changed to “product name, amount” or the like. If the word name of the item is
A word name of the last heading such as “total amount” is set. In addition, the C table (C11, C12) for creating a maintenance record for updating the file includes:
The update file name such as “sales total file”, the keyword name such as “product name”, and the code indicating the update type such as “total”, “add”, “correct”, “delete”, etc. are “quantity”, Update word names such as "amount" and "unit price" are set. A table D (D1
1) and E table for creating print format (E11)
Is set to a slip format.

Also, a form output type PS that outputs the above customer-specific summary table
3 includes a table A (A31), a table D (D31), and a table E (E31), and is specifically configured as shown in FIG. 3 (b). That is, “file name”, “record condition”, “total condition 1”, and “total condition 2” are set in table A (A31),
A form format is set in the table (D31) and the E table (E31).

Further, the update setting type PS4 for updating the monthly sales file includes a table A (A41) and a table C (C41), and is specifically set as shown in FIG. 3 (c). That is, A
In the table (A41), “File name”, “Record condition”,
In the C table (C41), "update file name", "keyword name", and "update word name" are set as "total conditions".

FIG. 3 shows an example of setting of PS1, PS3, and PS4. However, similarly, for other PSs, tables A to E are respectively independently set in accordance with each processing content and in accordance with the input / output form of the user. Is set.

Next, the operation of the above embodiment will be described. When performing processing such as setting of a PS, issuance of a slip, and updating of a file, first, the PS is designated and operated from the input device 11. When setting the PS,
After specifying the edit mode of the edit processing device 12 via the input device 11, PS designation is performed. The above input device 11
The PS designation data from is sent to the edit processing device 12,
The processing shown in the flowchart of FIG. 4 is performed by the edit processing device 12. The edit processing device 12
In step A1, the presence or absence of PS designation from the input device 11 is checked. When PS is designated, it is determined whether or not the edit mode is designated in advance by the input device 11 (step A2), and the edit mode is designated. If it has
It is checked whether the corresponding PS file has already been set in the PS file 13 (step A3). PS file
If a PS file corresponding to 13 is set,
The PS file is read into the edit memory 121 in the edit processing device 12 (step A4), and prepares for a table designation input in step A5. If the corresponding file is not set in the PS file 13, the process directly proceeds from step A3 to step A5 to prepare for table designation input. In this state, the operator designates the tables A to E and inputs the data of each table to set the tables A to E. When the operator designates the table A, the edit processing device 12 edits the edit memory 12.
Specify table A area in 1 (step A6) and step A7
To prepare for the input of the data in Table A. In this state, when the data of table A is input, the input data is stored in the table A area, and thereafter, the process returns to step A5 and waits until the next table is specified. Similarly, the table C is set in the edit memory 121 by steps A8 and A9, the table D is set in steps A10 and A11, and the table E is set in steps A12 and A13. When the operator operates the end key after ending the table designation and data input of A to E as described above, the edit processing device 12 writes the contents of the edit memory 121 to the corresponding file of the PS file 13 in step A14. Finish setting PS. Thereafter, the process returns to step A1 to prepare for the next key input.

Also, if the PS designation is performed while the edit mode is canceled by the input device 11, the corresponding PS file is read from the PS file 13 (step A15),
In step A16, the table A is stored in the input word memory 14,
The table is loaded into the file word memory 16, the D table is loaded into the display word memory 17, and the E table is loaded into the print word memory 18 (step A16), and a start command is given to the input processing device 20 (step A17). As a result, the input processing device 20 is activated, and data input processing relating to file updating and the like is started.

The above data input processing is performed according to the flowchart of FIG. 5 under the control of the input processing device 20. The input processing device 20 checks the presence or absence of a start command from the edit processing device 12 in step B1 of FIG. 5. When the start command is given, the process proceeds to step B2 and the A table loaded into the input word memory 14 is read. It is determined whether or not a file name is specified. If the file name is specified in table A, for example, as in the form output type PS3 shown in FIG. 3 (b), the record is read from the specified file in the master file 29 (step B3). Data matching the definition is searched based on Table A in which a condition expression indicating a name and a word condition, for example, "date number" as the word name and the same four digits as the word condition is defined (step B4). ), A totaling process is performed based on the conditions defined in Table A (step B5). The result of this aggregation is
It is written to the work file 26 at B6.

Hereinafter, steps B2 to B6 are repeated until it is determined in step B7 that the processing based on the designation of the table A has been completed,
The result of counting the data of the specified file is stored in the work memory 26. When it is determined that the processing based on the designation of the A table has been completed, it is checked whether or not there is another A table in the input word memory 14 (step B8). The table definition data is read (step B9), and thereafter, the process returns to step B2 to repeat the above processing. If it is determined in step B8 that the processing for all tables A has been completed, the process proceeds to step B14, where the file creation device 28
Then, the print processing device is started, and the process returns to step B1 to prepare for the next input start.

Also, like the slip type PS1 shown in FIG.
When the file name is not specified in the table A, the process proceeds from the step B2 to the step B10 to start the display processing device 22. When a start command is given from the input processing device 20, the display processing device 22 displays the slip format on the display device 30 in accordance with the D table loaded in the display word memory 17, displays a cursor on the screen, and displays the data format. Specify input. The operator inputs data from the input device 11 according to the input instruction on the screen (step B11). The input processing device 20 writes the input data from the input device 11 into the work memory 26 (step B12). Thereafter, the input processing device 20 determines whether an end key indicating the end of data input for one slip has been designated (step B13), and if not, returns to step B11 and repeats the same processing. Do it. Then, when the end key is operated and it is considered that the input processing of one slip data has been completed, the process proceeds to step B14, where the file creation device 21 and the print processing device 23 are activated, and the process returns to step B1, Prepare for next input activation.

By activating the file creation device 21 in step B14, the maintenance record creation process based on the table C is performed according to the flowchart of FIG.

The file creation device 21 checks in step C1 whether there is a start command from the input processing device 20, and when a start command is given, a file name and a keyword when updating the master file in the file word memory 16 are set. It is checked whether the C table defining the update type and the update word has been loaded (step C2). If there is no C table, the process returns to step C1. However, if there is a table C, the record stored in the work memory 26 is read by the processing shown in FIG. 5, and the word data included in this record is stored and held as keyword data and update word data based on the table C. A maintenance record is created (step C4). When the maintenance record creation process is completed, it is determined in step C5 whether another C table has been loaded into the file word memory 16. If there is another C table, the process returns to step C4 and returns to that C table. Create a maintenance record based on it. If it is determined in step C5 that there is no other C table, it is further determined in step C6 whether or not the processing for all records in the work memory 26 has been completed. And returns to step C4 to continue the maintenance record creation process. When the processing for all records is completed, the process returns from step C6 to step C1 to prepare for the next start command.

When the print processing device 23 is started in step B14 in FIG. 5, the printing process based on the table E is performed according to the flowchart in FIG. The print processing device 23 is operated by the input processing device 20 in step D1 of FIG.
If the start command is given, the flow advances to step D2 to check whether or not the E table is loaded in the print word memory 18. If there is no E table, the process directly proceeds to step D1. Return. However, if there is an E table, the word data corresponding to the word name defined in the E table is read from the work memory 26 (step D3), and the print processing is performed in the print format defined in the E table (step D4). Then, in step D5, print word memory
It is determined whether there is another E table in 18, and if there is another E table, that E table is read and the process returns to step D3. Hereinafter, the same processing is repeated, and the word data of the word name specified in the E table is printed in the print format specified in the E table. If it is determined in step D5 that there is no other E table, step
Return to D1 to prepare for the next start command.

As described above, the setting of the PS in the PS file 13 is performed, and processing such as issuance of a slip, totalization and update of a detailed file is performed based on the PS set in the PS file 13.

In the above embodiment, the file creation device 21 and the print processing device 23 are input processing devices for the work memory 26.
Although the activation is performed after all the word data writing processes of 20 are completed, the activation may be performed after the word data for one record is written in the work memory 26. And the print processing device 23 need not be started at the same time. In short, the input processing device 20, the file creation device 21, the print processing device 23, and the display processing device 22
It is only necessary to perform independent processing for each device, and it is sufficient if independent definition settings can be made for each of the above devices.

Further, in the above embodiment, the file name to be updated and the update type name are also stored in the maintenance record. However, this is not always necessary.
May be updated on the basis of the file name and the update type name defined in the table C in the file word memory 16 during the update process. At this time, the file update processing device 28 may be configured to execute the update process every time the above-mentioned maintenance record is created.

In the above embodiment, in the definition of each table such as Table A,
Although the word name is indicated by characters, it may be indicated by a numerical value associated with the word order in a record. Further, the file format memory 25 is not always necessary. In this case, in the definition of the C table in the file word memory 16,
What is necessary is just to define the word name to be allocated to each word in the order corresponding to the word order of the record configuration of the file.

[Effects of the Invention] According to the present invention, input processing of a plurality of data, file update processing based on each of the input processed data,
Since the output process based on each of the data processed by the input processing can be defined by the word name definition in each definition table prepared for simply defining the definition corresponding to each process, Individual definition settings corresponding to the individual processes can be made relatively easily. Each word data input and processed corresponding to the word name in the above definition table is used for file update processing. Are referred to by the various word names defined by the definition table and the definition table for output processing, respectively, so that word data can be delivered. Data input processing, file update processing, and output processing can be performed.

[Brief description of the drawings]

FIG. 1 shows an embodiment of the present invention. FIG. 1 is a system configuration diagram of a slip processing device, FIGS. 2 and 3 are diagrams showing examples of setting various files in a PS file, and FIG. 4 is an edit diagram. FIG. 5 is a flowchart showing an input processing operation, FIG. 6 is a flowchart showing a file creation processing operation, and FIG. 7 is a flowchart showing a printing processing operation. 11 Input device, 12 Edit processing device, 13 PS
File, 14 input word memory, 16 file word memory, 17 display word memory, 18 print word memory, 20 input processing device, 21 file creation device, 22 display processing device , 23 …… Print processing device, 24 ……
Index table memory, 25: File format memory, 26: Work memory, 27: Maintenance file, 28: File updating device, 29: Master file,
30 ... display device, 31 ... printing device.

──────────────────────────────────────────────────続 き Continuation of the front page (56) References JP-A-58-52742 (JP, A) JP-A-62-24364 (JP, A) JP-A-63-273161 (JP, A) JP-A-62-273161 290970 (JP, A) JP-A-2-24763 (JP, A) JP-A-2-24767 (JP, A) JP-A-62-289051 (JP, U) (58) Fields investigated (Int. Cl. ⁷ , DB name) G06F 12 / 00,19 / 00

Claims (1)

(57) [Claims] 1. An input definition storage means for storing arbitrary defined contents in a definition table having a column for defining a plurality of input word names required for input, a file name to be updated, and a keyword name File definition storage means for storing any defined contents in a definition table having a column for defining the update word name to be updated and the output word name required for output and its output format Output definition storage means for storing any defined contents with respect to the definition table for performing, and each input word corresponding to each input word name defined in the definition table stored in the input definition storage means Input means for performing input processing on data; data storage means for storing each word data corresponding to each word name input by the input means; and input processing after input processing by the input means. Including the file name to be updated defined in the definition table stored in the file definition storage means, and reading the word data corresponding to the keyword names and update word names defined in the definition table from the data storage means. Record creation means for creating an update record; update record storage means for storing the update record created by the record creation means; and an update record storage means based on a file update instruction. File update means for executing a file update process based on each word data included in the update record for a file corresponding to the update target file name included in each update record, and input processing by the input means It is started after the processing, and the output word name defined in the definition table stored in the output definition storage means is An output unit for reading out corresponding word data from the data storage unit and outputting the read word data in an output format defined by a definition table thereof.