CN110782234B

CN110782234B - Information management method and system based on business logic

Info

Publication number: CN110782234B
Application number: CN201911084076.6A
Authority: CN
Inventors: 殷步九; 梁玢
Original assignee: Individual
Current assignee: Liang Bin
Priority date: 2019-11-07
Filing date: 2019-11-07
Publication date: 2020-10-02
Anticipated expiration: 2039-11-07
Also published as: CN110782234A

Abstract

The invention discloses an information management method and system based on business logic, wherein the method comprises the following steps: receiving a form input by a request user, and searching an association database associated with the form by adopting association logic; triggering an approval process by adopting triggering logic in the associated database; receiving an approval qualified instruction input in the form by an approval user, and triggering a settlement process by adopting trigger logic; and receiving a settlement finishing instruction input on the form by a settlement staff, triggering a backup process by adopting trigger logic, backing up the form, and storing the form in a query database. The method realizes code-free programming and reduces potential safety hazards.

Description

Information management method and system based on business logic

Technical Field

The invention relates to the technical field of computers, in particular to an information management method and system based on business logic.

Background

At present, computer management information systems in various specialized fields still adopt code programming or high-level language programming, or adopt application functions or modules written by the computer languages or codes to realize various applications in the information age. When the applications directly or indirectly adopt the code programs, the system brings about great hidden danger of information insecurity. The current state of the existing code programming technology has the defects of long period, high cost, poor modification and unfavorable development, and because the software code is adopted, the computer virus is easily infected, and the potential safety hazard exists. IBM corporation and microsoft corporation both cannot design a management information system without software codes, and have the problems of difficult computer security, long programming cycle, short service life and low efficiency.

In 1992, the codeless enterprise software build tool appeared in the suite of Office by Microsoft, first attracted a large number of non-technical business-class clients who remembered that database application called Access because they were aware of how specific problems in enterprise management should be solved and are good at using such highly resilient tools. The 'construction tool' is code, and essentially adopts a programming method. The low-code development platform is a configuration type software rapid development tool, core functions need to be developed and realized, and development work of a plurality of enterprise systems such as OA, ERP, CRM and the like can be completed through business parameter configuration and SQL sentences. Obviously, the ' core function needs code development and implementation ' and the ' SQL statement can complete OA, ERP and CRM ', and the ' core function is not code-free and still adopts codes.

Therefore, how to realize code-free programming and reduce the potential safety hazard is an urgent problem to be solved.

Disclosure of Invention

The invention aims to provide an information management method and system based on business logic, so as to realize code-free programming and reduce potential safety hazards.

In order to solve the above technical problem, the present invention provides an information management method based on business logic, which comprises:

receiving a form input by a request user, and searching an association database associated with the form by adopting association logic;

triggering an approval process by adopting triggering logic in the associated database;

receiving an approval qualified instruction input in the form by an approval user, and triggering a settlement process by adopting trigger logic;

and receiving a settlement finishing instruction input on the form by a settlement staff, triggering a backup process by adopting trigger logic, backing up the form, and storing the form in a query database.

Preferably, the method further comprises:

and receiving a query instruction input by a user, and searching a table corresponding to the query instruction in a query database by adopting query logic.

Preferably, the method further comprises:

and establishing the examination and approval authority of the examination and approval user, and grading the examination and approval authority.

Preferably, the method further comprises:

and establishing a link relation between the association database and the query database.

The invention also provides an information management system based on the business logic, which is used for realizing the method and comprises the following steps:

the first searching module is used for receiving a table input by a request user and searching the associated database associated with the table by adopting the associated logic;

the first trigger module is used for triggering the approval process in the associated database by adopting trigger logic;

the second trigger module is used for receiving an approval qualified instruction input by an approval user in the form and triggering a settlement process by adopting trigger logic;

and the third triggering module is used for receiving a settlement finishing instruction input on the form by a settlement staff, triggering a backup process by adopting triggering logic, backing up the form and storing the form in the query database.

Preferably, the system further comprises:

and the second searching module is used for receiving the query instruction input by the user and searching the table corresponding to the query instruction in the query database by adopting the query logic.

Preferably, the system further comprises:

and the authority creating module is used for creating the examination and approval authority of the examination and approval user and grading the examination and approval authority.

Preferably, the system further comprises:

and the link establishing module is used for establishing a link relation between the association database and the query database.

The invention provides an information management method and system based on business logic, which receives a form input by a request user, and searches an associated database associated with the form by adopting associated logic; triggering an approval process by adopting triggering logic in the associated database; receiving an approval qualified instruction input in the form by an approval user, and triggering a settlement process by adopting trigger logic; and receiving a settlement finishing instruction input on the form by a settlement staff, triggering a backup process by adopting trigger logic, backing up the form, and storing the form in a query database. Therefore, the whole information flow management is completed by adopting the association logic and the trigger logic, code programming is not needed, and potential safety hazards are reduced.

Drawings

In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the provided drawings without creative efforts.

FIG. 1 is a flow chart of a method for information management based on business logic according to the present invention;

FIG. 2 is a schematic diagram of the association between the basic logic;

FIG. 3 is a schematic view of the online transfer process of the travel reimbursement slip;

FIG. 4 is a schematic view of the online wholesale process of the business trip debit note;

FIG. 5 is a schematic diagram of the online wholesale process of a purchase bill of payment;

FIG. 6 is a schematic illustration of a reimbursement slip display for an expense account;

FIG. 7 is a diagram illustrating a hospital department ledger display;

FIG. 8 is a diagram illustrating a hospital charge/withdrawal subject ledger display;

fig. 9 is a schematic structural diagram of an information management system based on business logic according to the present invention.

Detailed Description

The core of the invention is to provide an information management method and system based on business logic, so as to realize code-free programming and reduce potential safety hazard.

In order to make the technical solutions of the present invention better understood, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.

Referring to fig. 1, fig. 1 is a flowchart of an information management method based on business logic according to the present invention, the method includes the following steps:

s11: receiving a form input by a request user, and searching an association database associated with the form by adopting association logic;

s12: triggering an approval process by adopting triggering logic in the associated database;

s13: receiving an approval qualified instruction input in the form by an approval user, and triggering a settlement process by adopting trigger logic;

s14: and receiving a settlement finishing instruction input on the form by a settlement staff, triggering a backup process by adopting trigger logic, backing up the form, and storing the form in a query database.

Therefore, the method adopts the association logic and the trigger logic to complete the whole information flow management, code programming is not needed, and potential safety hazards are reduced.

Based on the method, the method further comprises the following steps:

s21: and receiving a query instruction input by a user, and searching a table corresponding to the query instruction in a query database by adopting query logic.

In detail, the form includes a reimbursement form, a debit form, a payment form, a refund form, or an outpatient registration form.

The method directly adopts the business logic, namely the association logic, the trigger logic and the query logic to directly design and operate the business logic row and the algorithm logic, so that the method has no codes completely and ensures the safety of the system completely. Meanwhile, each process uses a database table or a query table, namely the design habit is directly based on the system logic process and the database table, all functions expressed by the flow chart can be directly executed, and meanwhile, according to the design habit of the system, authorization is respectively designed according to organization, and an operation interface and authorization are designed according to the habit. That is, all that is in line with the traditional system design practice is that no software code programming is required, nor is it necessary to generate unsafe computer instruction code.

In the method, a database table and an algorithm relation are adopted, and the method can be clearly expressed as a mode called a logic flow block diagram and further system description and algorithm description. As long as the explanation of the above requirements can be expressed, the operation purpose of the requirements can be completely and directly realized, and the requirements of the user are met.

The basic logic includes associative logic, algorithmic logic, trigger logic, and categorical query logic. In detail, referring to fig. 2, the association logic points to the trigger logic, the association relationship between the association logic and the trigger logic points to the triggered process, the trigger relationship between the trigger logic and the triggered process points to the query logic, and the query relationship between the trigger logic and the query logic points. The association logic implements that the flow data of the arrow tail is associated by the corresponding data of the flow pointed to by the association logic. The algorithm logic provides an algorithm for referencing the function. The trigger logic provides a commit for extracting the destination trigger, i.e. the data pointed to by the arrow tail, to be committed to the corresponding field of the flow pointed to by the arrow. The classified query logic provides a query. The association logic, the trigger logic and the query logic are core logics in the transaction application forming a complex management information system, and can fully express any complex transaction logic relationship, and any application can be realized by combining various numbers of algorithm logic functions according to application requirements.

The method is realized easily by obtaining various complex data structures and various complex calculation processing relations through the database table, the query table, the association between the association tables, the data triggering or extraction and various query classification functions. The method is completely realized without software codes and software codes are not required to be generated, so that the system safety is completely ensured. The whole process of the method is completely carried out by means of automatically executing logic, and complicated and unsafe software code programming operation is completely cancelled. Therefore, the safety of the invention is thoroughly ensured. The method realizes the whole functions of a complex management information system by supporting the association logic relation among the flows of various database tables, the trigger logic comprising data submission or data extraction and the classification query logic with definable conditions. Each node is a process supporting data table representation of various databases, which respectively comprise a database table and a query table and an association table for expressing and solving data association relations.

Applying basic logic to reimbursement, borrowing and payment, referring to fig. 3, 4 and 5, wherein fig. 3 is a schematic diagram of an online transfer process of a travel reimbursement sheet, fig. 4 is a schematic diagram of an online transfer process of a business loan sheet, fig. 5 is a schematic diagram of an online transfer process of a purchase payment sheet, a flow diagram of the application and a database table corresponding to each flow diagram and created as required are provided, the database table comprises one or more pages of data tables, and various operation function expressions are directly defined and quoted among table fields according to requirements, so that various applications are realized. Each process in fig. 3 is a table in the reimbursement form as shown in fig. 6. The first set of travel reimbursement documents in FIG. 3 pertains to: the business trip fills in the reimbursement bill → the department responsible person approves → the responsible accountant audits → the financial manager approves → the general manager reviews → the cashier settles accounts → the backup base is entered, thus the business trip bill reimbursement work is completed by a plurality of process approval flows.

The invention is used for directly realizing the calculation of the business form as the actual business process, and directly completing all processes by the approval process and then warehousing and storing all data forms. The complicated and error-prone unsafe old process of the traditional computer code writing program is completely cancelled. The method adopts the business logic to carry out information management, thoroughly subverts the history of compiling the code by the management software, creates a computer management information system which is directly designed by the management logic and has complex design, thoroughly replaces the fussy and traditional old process of compiling the software code which can not ensure the information safety, and creates and develops a new era in the field of design of the management information system. The unification of the design technology of computer software logic and computer hardware logic is really realized.

The invention is composed of a group of logic flow block diagrams expressing management information system, each block diagram is composed of one or a group of data tables. The logic block diagrams are formed by accurate expression association logic, trigger logic and classification query logic. The structure is clear, and the data relation expression is accurate and visual. That is, a set of management information flow diagrams comprising exact links by association logic, trigger logic, and query logic are sufficient to accurately represent an executable management information system.

In detail, each node is provided with a database represented by an accurate database table; and the associated database is linked by a group of parameter table data, and the data with the associated relation is accurately realized by the definition of the associated logic. And the data processing algorithm between the databases is realized through the trigger logic of the databases. The analysis processing results and the classification query results of various data are realized through a group of query logics, and the complex data calculation processing and the data classification calculation result processing are realized. The invention creates a database in the system through the database table on each node, and the database table is defined into a simple table or a main substructure table according to the requirement. If necessary, the table can be defined into a master multi-child table or a multi-master multi-child complex table structure.

The invention can realize complex data classification processing function through classification triggering logic, namely active submission and target triggering extraction. The data association result can be accurately realized through the association logic. The step-by-step and multi-stage classification query processing results of the data are easily realized through the classification query logic, and the accurate and complex function processing effect is obtained through a clear processing method. In summary, complex data processing effects are achieved through the above-described triggering, querying and association logic. Especially, the query logic is very convenient and fast in data classification, data analysis and data processing.

Further, the method comprises the following steps:

s31: and establishing a link relation between the association database and the query database.

The table can be quickly designed into a complex table with quite complex one-main multi-sub and multi-main multi-sub structures by defining. As shown in fig. 7, the department ledger table of "clinic registration" in chang g-g hospital in fig. 7 can realize the sub-table accounts of 2019 or 2020 under the main code of "clinic registration", and can also create ledger pages of different departments, such as "clinic charge" in 2019 or 2020; can be designed into a combined account book of multiple subjects and multiple business classifications. And, if necessary, the command can be used to create a link in the summary column of the account page table to link to the processing result of the complex process related to another process or to inquire the more complex structure of the link. The multi-link structure can be processed into a simple page link structure and can also be linked into a plurality of groups of complex classified account group structures pointed by the main codes, and the use is very convenient and accurate.

Further, the method comprises the following steps:

s41: and establishing the examination and approval authority of the examination and approval user, and grading the examination and approval authority.

The method can process the database table with a complex structure and the multi-stage classification structure of complex field combination through classification query, can realize the clear data structure of the multi-stage classification structure, and is very required to be applied to the actual complex business. The method adopts the service management and the authority management of a plurality of user groups and a user group and a plurality of users for the manager of the complex service processing besides the management of the complex service. And respectively and accurately authorizing the corresponding system operation service details and accurately managing the authority of the user group members. Group authorization and member authorization may be performed separately. And performing ordered authority authentication and accurate function management of services in the authority under the condition of step-by-step authority management according to the necessity. And driving the operation right and the processing right of the role on the premise of step-by-step authority authentication according to the requirement.

In addition, the project file and the role authorization file are authorized step by step. And publishing the engineering file and the role authorization file on the network to generate a webpage. And the user end logging in the webpage executes the operation of the online system of the system under the authorization of the user end. And after the system flow and the role change, the system flow and the role need to be changed correspondingly and then are published on the network again, and then the network operation is carried out. The invention is characterized by no code programming, only the operation of flow and table, including web page language code, and only the simple guide instruction introduced into the system logic operation.

The method supports operator authorization and an interface design module supporting operator login, and accurately executes system operation in the authority according to the specified authority for the operator participating in the operation through authorization design. The method supports the function of issuing to the Internet, realizes the online operation of directly executing the authorized flow in the logic flow without writing the instruction code program and generating the instruction code program. And the system safety is fully ensured.

The method expresses an intuitive database form into three basic logics, namely triggering logic, association logic and classification query logic among transaction flows based on transaction logic and algorithm logic, and accurately describes the function and algorithm of a target system. The whole process is completely free of codes, and the safety of the system is ensured. Referring to fig. 8, fig. 8 shows the database form overall management flow of the hospital from the flow of billing-price checking-charging receipt-accounting-backup-inquiry, price name association logic of billing, trigger logic to complete price checking-billing-accounting, to backup, to patient account inquiry. The automatic association of the drug names listed in the outpatient clinic price check table to the parameters of the drug, such as the price, the metering unit, the price and the like is realized through association logic. And submitting the payment voucher after the automatic calculation of the function definition is completed, submitting the payment voucher to a subject ledger form after the verification of the signature of the payment voucher, and submitting the payment voucher to a backup library for backuping and backup after the payment is confirmed. And also provides for querying the patient's relevant account in the patient role.

Referring to fig. 9, fig. 9 is a schematic structural diagram of an information management system based on business logic according to the present invention, the system is used for implementing the above method, and includes:

the first searching module 101 is configured to receive a table input by a user, and search an association database associated with the table by using association logic;

the first triggering module 102 is configured to trigger an approval process in the associated database by using a triggering logic;

the second trigger module 103 is used for receiving an approval qualified instruction input by an approval user in the form and triggering a settlement process by adopting trigger logic;

and the third triggering module 104 is configured to receive a settlement completion instruction input by a settlement staff on the form, trigger a backup process by using a triggering logic, backup the form, and store the backed-up form in the query database.

Therefore, the system adopts the association logic and the trigger logic to complete the whole information flow management, code programming is not needed, and potential safety hazards are reduced.

Based on the above system, further, still include:

Further, the system further comprises:

The embodiments are described in a progressive manner, each embodiment focuses on differences from other embodiments, and the same or similar parts among the embodiments are referred to each other. For the system disclosed by the embodiment, the description is relatively simple because the system corresponds to the method disclosed by the embodiment, and the relevant points can be referred to the method part for description.

The information management method and system based on the business logic provided by the invention are described in detail above. The principles and embodiments of the present invention are explained herein using specific examples, which are presented only to assist in understanding the method and its core concepts. It should be noted that, for those skilled in the art, it is possible to make various improvements and modifications to the present invention without departing from the principle of the present invention, and those improvements and modifications also fall within the scope of the claims of the present invention.

Claims

1. An information management method based on business logic is characterized by comprising the following steps:

in a management system, receiving a form input by a request user, and searching association data associated with the form by adopting association logic;

triggering an approval process by adopting triggering logic, associating relevant data by adopting associated logic, and expressing various functions to be expressed by all system requirements by adopting classified query logic; no code is required to be written, and no code is generated;

receiving a settlement completion instruction input on a form by a settlement staff, triggering a backup process by adopting trigger logic, backing up the form, storing the form into a query database without compiling any code or generating a code;

receiving a query instruction input by a user, and searching a table corresponding to the query instruction in a query database by adopting query logic, wherein the table corresponding to the query instruction comprises a reimbursement table, a borrowing table, a payment table, a refund table or an outpatient registration table;

the query logic is adopted to search the required result in the query database without compiling any code or generating a code;

establishing a link relation between the association database and the query database;

the association logic points to the flow of the trigger logic, the association relationship is between the flow of the association logic and the flow of the trigger logic, the trigger logic points to the triggered flow, the trigger relationship is between the trigger logic and the triggered flow, the trigger logic points to the flow of the query logic, and the query relationship is between the flow of the trigger logic and the flow of the query logic.

2. The method of claim 1, further comprising:

3. An information management system based on business logic, characterized in that, for implementing the method of any one of claims 1 to 2, it comprises:

the first searching module is used for receiving a table input by a request user in the management system and searching the associated data associated with the table by adopting the associated logic;

the first trigger module is used for triggering the approval process by adopting trigger logic, associating relevant data by adopting associated logic, expressing various functions to be expressed by all system requirements by adopting classified query logic, and generating no code without compiling any code;

the third trigger module is used for receiving a settlement finishing instruction input on the form by a settlement staff, triggering a backup process by adopting trigger logic, backing up the form, storing the backed-up form into a query database, and generating no code without compiling any code;

the second searching module is used for receiving a query instruction input by a user, searching a table corresponding to the query instruction in a query database by adopting query logic, wherein the table corresponding to the query instruction comprises a reimbursement table, a debit table, a payment table, a refund table or an outpatient registration table, searching a required result in the query database by adopting the query logic, and no code needs to be written or generated;

the link establishing module is used for establishing a link relation between the association database and the query database;

4. The system of claim 3, further comprising: