CN110597491A - Method for quickly establishing different service systems - Google Patents
Method for quickly establishing different service systems Download PDFInfo
- Publication number
- CN110597491A CN110597491A CN201910662526.9A CN201910662526A CN110597491A CN 110597491 A CN110597491 A CN 110597491A CN 201910662526 A CN201910662526 A CN 201910662526A CN 110597491 A CN110597491 A CN 110597491A
- Authority
- CN
- China
- Prior art keywords
- user
- dictionary
- data
- business
- query
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/30—Authentication, i.e. establishing the identity or authorisation of security principals
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/20—Software design
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/33—Intelligent editors
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/35—Creation or generation of source code model driven
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2221/00—Indexing scheme relating to security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F2221/21—Indexing scheme relating to G06F21/00 and subgroups addressing additional information or applications relating to security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F2221/2141—Access rights, e.g. capability lists, access control lists, access tables, access matrices
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Software Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Computer Security & Cryptography (AREA)
- Computer Hardware Design (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a method for quickly establishing different service systems, which comprises the following steps: acquiring a first instruction which is input by a user and indicates a service system required to be used; extracting first key information of a service system required to be used by a user from the first instruction; determining the authority of the user to use the service system according to the first key information; the authority of the user to use the service system is distributed to the user, so that the quick establishment of different service systems is realized. The invention can distribute the use permission of different function modules of different service systems to corresponding users according to the service requirements of different users, can realize the rapid construction of various different service systems and/or function modules without changing codes by the users, and has good application prospect.
Description
Technical Field
The invention relates to the technical field of computer software, in particular to a method for quickly establishing different service systems.
Background
The business system refers to business links required by enterprises for positioning, roles played by all partners, and modes and contents of cooperation and transaction of interest relatives. In the actual production working process, different enterprises can use a plurality of different business systems according to actual demands, and even the same enterprise can change the used business systems at any time according to different demands.
Currently, a set of business systems usually includes a plurality of function modules, each function module corresponds to a fixed set of codes, which results in a set of business systems having a fixed set of codes. When the system is used, a user can realize the establishment of different service systems or the establishment of different functional modules in different service systems by changing codes. However, when a user needs to build a plurality of different service systems and/or function modules, the user needs to change a plurality of codes, which not only brings huge workload to the user, but also reduces the speed of building different service systems and/or function modules.
In order to solve the above technical problems, the present invention provides a method for quickly establishing different service systems.
Disclosure of Invention
The technical problem to be solved by the invention is as follows: at present, when a user needs to build a plurality of different service systems and/or function modules, the user needs to change a plurality of codes, which not only brings huge workload to the user, but also reduces the building speed of the different service systems and/or function modules.
In order to solve the above technical problem, the present invention provides a method for quickly establishing different service systems, which comprises:
acquiring a first instruction which is input by a user and indicates a service system required to be used;
extracting first key information of a service system required to be used by a user from the first instruction;
determining the authority of the user for using the service system according to the first key information;
and distributing the authority of the user for using the service system to the user, thereby realizing the rapid establishment of different service systems.
In a preferred embodiment of the present invention, the service system includes a plurality of functional modules with different functions, and the method further includes:
under the condition that the authority indicates that the user has the right to use the service system, acquiring a second instruction which is input by the user and indicates a functional module required to be used;
extracting second key information of the functional module required to be used by the user from the second instruction;
determining the authority of the user for using each functional module according to the second key information;
and distributing the authority of the user for using each functional module to the user, thereby realizing the rapid establishment of different functional modules of different service systems.
In a preferred embodiment of the present invention, the function modules include a business form modeling module and a business data query module.
In a preferred embodiment of the present invention, the business form modeling module includes a dictionary modeler and a business document modeler;
the dictionary modeler includes:
the dictionary type determining unit is used for determining the dictionary type according to a third instruction of the user;
the dictionary template determining unit is used for determining a dictionary template to be selected according to the dictionary type and selecting the dictionary template to be edited from the dictionary template to be selected according to a fourth instruction of a user;
the dictionary generating unit is used for editing the dictionary template to be edited according to a fifth instruction of a user so as to generate an editable dictionary;
the business document modeler comprises:
the business document type determining unit is used for determining the type of the business document according to a sixth instruction of the user;
the business document template determining unit is used for determining a business document template to be selected according to the business document type and selecting the business document template to be edited from the business document template to be selected according to a seventh instruction of a user;
and the business document generating unit is used for editing the business document template to be edited according to an eighth instruction of the user to generate an editable business document and generate an approval object corresponding to the business document.
In a preferred embodiment of the present invention, the dictionary generating unit is specifically configured to edit the dictionary template to be edited by editing a dictionary base attribute table and a dictionary default data column;
the dictionary generating unit is further used for editing the dictionary by editing the dictionary basic property list and default data columns of the dictionary.
In a preferred embodiment of the present invention, the business document generating unit is specifically configured to edit the selected business document template by editing a business document basic attribute table and a business document default data column;
the business document generating unit is also used for editing the generated business document by editing the basic attribute list of the business document and the default data column of the business document.
In a preferred embodiment of the present invention, the service data query module includes:
the form data set creating unit is used for creating a form data set and enabling the data set to store a plurality of related data objects, a plurality of fields corresponding to each data object and service data corresponding to each field;
the query report creating unit is used for creating a query report based on the data object and the field and enabling the query report to store the field serving as a query item;
the data binding unit is used for binding the business data corresponding to each field in the form data set and the cell of the row or column where the field is located aiming at each field in the query report;
the query statement generating unit is used for acquiring a query instruction which is input by a user and comprises a field to be queried, and automatically generating a query statement corresponding to the query instruction based on a preset query language grammar rule;
and the data query unit is used for querying the business data corresponding to the field to be queried in the query report by using the query statement and outputting a query result.
In a preferred embodiment of the invention, the data objects and the fields are selected from a service database in response to a selection instruction entered by a user.
In a preferred embodiment of the present invention, the service data query module further includes: and the data processing unit is used for processing the data of the query result according to the data processing instruction input by the user.
In a preferred embodiment of the invention, the data processing comprises one or more of sorting, grouping, joint inspection and drilling.
Compared with the prior art, one or more embodiments in the above scheme can have the following advantages or beneficial effects:
by applying the method for rapidly establishing different service systems provided by the embodiment of the invention, the use permission of different functional modules of different service systems can be distributed to corresponding users according to the service requirements of different users, the rapid establishment of various different service systems and/or functional modules can be realized without changing codes by the users, and the method has good application prospect.
Additional features and advantages of the invention will be set forth in the description which follows, and in part will be obvious from the description, or may be learned by the practice of the invention. The objectives and other advantages of the invention will be realized and attained by the structure particularly pointed out in the written description and claims hereof as well as the appended drawings.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the description serve to explain the principles of the invention and not to limit the invention. In the drawings:
fig. 1 is a schematic specific flowchart of a method for quickly establishing different service systems according to an embodiment of the present invention;
FIG. 2 is a framework diagram of a business form modeling module of an embodiment of the invention;
fig. 3 is a schematic structural diagram of a service data query module according to an embodiment of the present invention.
Detailed Description
The following detailed description of the embodiments of the present invention will be provided with reference to the drawings and examples, so that how to apply the technical means to solve the technical problems and achieve the technical effects can be fully understood and implemented. It should be noted that, as long as there is no conflict, the embodiments and the features of the embodiments of the present invention may be combined with each other, and the technical solutions formed are within the scope of the present invention.
At present, when a user needs to build a plurality of different service systems and/or function modules, the user needs to change a plurality of codes, which not only brings huge workload to the user, but also reduces the building speed of the different service systems and/or function modules.
In order to solve the above technical problem, an embodiment of the present invention provides a method for quickly establishing different service systems.
Fig. 1 is a schematic specific flowchart of a method for quickly establishing different service systems according to an embodiment of the present invention.
As shown in fig. 1, the method for quickly establishing different service systems according to the embodiment of the present invention mainly includes the following steps S101 to S104.
In step S101, a first instruction indicating a service system required to be used, which is input by a user, is acquired.
In step S102, first key information of the business system that the user needs to use is extracted from the first instruction.
In step S103, the authority of the user to use the service system is determined according to the first key information.
In step S104, the authority of the user to use the service system is assigned to the user, so as to realize fast establishment of different service systems.
In a preferred embodiment of the invention, the service system comprises a plurality of functional modules with different functions. In this case, the method for quickly establishing different service systems according to the embodiment of the present invention further includes the following steps S105 to S108.
In step S105, in the case that the authority indicates that the user has the authority to use the service system, a second instruction indicating a functional module that needs to be used, which is input by the user, is acquired.
In step S106, second key information of the function module that the user needs to use is extracted from the second instruction.
In step S107, the authority of the user to use each function module is determined according to the second key information.
In step S108, the authority of the user to use each function module is assigned to the user, so as to realize fast establishment of different function modules of different service systems.
Preferably, the functional modules comprise a business form modeling module and a business data query module. The business form modeling module is used for generating a dictionary and business documents, and the business data query module is used for generating a query report.
For ease of understanding, the travel reimbursement system and the vehicle management system are explained below as examples.
The travel reimbursement system has 4 functional modules, and is respectively: the system comprises a travel application module, a travel reimbursement module, a travel inquiry module and a travel statistic module. The functions of the travel application module and the travel reimbursement module are realized based on the business documents generated by the business form modeling module, and the functions of the travel inquiry module and the travel statistic module are realized based on the inquiry reports generated by the business data inquiry module.
The vehicle management system has 4 functional modules, which are respectively: the device comprises a driver information module, a vehicle use application module and a vehicle use condition statistic module. The functions of the driver information module and the vehicle information module are realized based on the dictionary generated by the business form modeling module, the function of the vehicle use application module is realized based on the business document generated by the business form modeling module, and the function of the vehicle use condition counting module is realized based on the query report generated by the business data query module.
Assume that user a wants to use the functions of the travel application module of the travel reimbursement system and the driver information module of the vehicle management system, and user B wants to use the functions of the travel statistics module of the travel reimbursement system and the vehicle use application module of the vehicle management system.
First, step S101 is executed to obtain a first instruction input by the user a indicating that the travel reimbursement system and the vehicle management system need to be used.
Next, step S102 is executed to extract first key information that the user a needs to use the travel reimbursement system and the vehicle management system from the first instruction.
Next, step S103 is performed to determine the authority of the user a to use the travel reimbursement system and the vehicle management system according to the first key information.
Next, step S104 is executed to assign the authority of the user a to use the travel reimbursement system and the vehicle management system, thereby implementing quick configuration of the travel reimbursement system and the vehicle management system.
Next, step S105 is executed to obtain a second instruction, which is input by the user a and indicates that the travel application module and the driver information module are required to be used, in a case where the authority indicates that the user a has the right to use the travel reimbursement system and the vehicle management system.
Next, step S106 is executed to extract second key information that the user a needs to use the travel application module and the driver information module from the second instruction.
Next, step S107 is executed to determine the authority of the user a to use the travel application module and the driver information module according to the second key information.
Finally, step S108 is executed to assign the right of the user a to use the travel application module and the driver information module to the user a, thereby implementing fast construction of the travel application module of the travel reimbursement system and the driver information module of the vehicle management system. At this time, the user a can use only the functions of the travel application module of the travel reimbursement system and the driver information module of the vehicle management system, and cannot use the functions of the remaining function modules of the travel reimbursement system and the vehicle management system.
And similarly executing similar operations to the steps for the requirements of the user B, so that the user B can only use the functions of the travel statistic module of the travel reimbursement system and the vehicle use application module of the vehicle management system, but cannot use the functions of the rest functional modules of the travel reimbursement system and the vehicle management system.
The business form modeling module and the business data query module are respectively described in detail below.
FIG. 2 is a block diagram of a business form modeling module according to an embodiment of the invention.
As shown in fig. 2, the business form modeling module according to the embodiment of the present invention mainly includes: a dictionary modeler 101 and a business document modeler 102.
The dictionary modeler 101 includes: a dictionary type determining unit 1011, a dictionary template determining unit 1012, and a dictionary generating unit 1013.
The dictionary type determination unit 1011 is configured to determine a dictionary type according to a third instruction of the user.
Specifically, the dictionary may be divided into a plurality of types according to a preset rule, the user inputs a third instruction according to a dictionary type to which the dictionary to be built belongs, the dictionary type determining unit 1011 determines the dictionary type according to the third instruction, and the determined dictionary type information is sent to the dictionary template determining unit 1012. Further, the dictionary type determining unit 1011 may classify dictionary types into policy management, index system, business system, public system, and the like according to storage contents. Assuming that the customer needs to establish a department dictionary, since the department dictionary belongs to the category of the common system, the third instruction input by the user to the dictionary type determining unit 1011 is the common system, and the dictionary type determining unit 1011 determines that the common system is selected, and transmits the information that the common system is selected to the dictionary template determining unit 1012.
The dictionary template determining unit 1012 is configured to determine a dictionary template to be selected according to the dictionary type, and select a dictionary template to be edited from the dictionary template to be selected according to a fourth instruction of the user.
Specifically, the dictionary template determining unit 1012 receives the dictionary type information transmitted by the dictionary type determining unit 1011, and determines a corresponding dictionary template to be edited according to the dictionary type information to be created, and meanwhile, the dictionary template determining unit 1012 determines a dictionary template corresponding to the dictionary to be created in the dictionary templates to be edited according to a fourth instruction input by the user. Further, not less than one dictionary template corresponding to each dictionary type is stored in the dictionary template determination unit 1012, respectively. Assuming that the department dictionary needs to be established by the client, the dictionary template determining unit 1012 works in the following specific manner: the dictionary type information sent by the dictionary type determining unit 1011, that is, the selected information of the public system, is received, and the dictionary templates corresponding to the public system are determined to include a non-hierarchical dictionary template, a non-hierarchical dictionary data template (with an inner frame), a hierarchical dictionary template, a hierarchical dictionary data template (with an inner frame), an associated hierarchical dictionary and an associated hierarchical dictionary (tree-shaped, with an inner frame) according to the information. Assuming that the department dictionary to be created is in the form of a hierarchical dictionary template without an inner frame, the dictionary template determination unit 1012 selects a non-hierarchical dictionary template as the template to be edited according to a fourth instruction of the user, i.e., the non-hierarchical template.
The dictionary generating unit 1013 is configured to edit the selected dictionary template to be edited according to a fifth instruction of the user, so as to generate an editable dictionary meeting the user requirement.
Specifically, all dictionary templates include a dictionary base attribute list and a default dictionary data column corresponding thereto. The dictionary generating unit 1013 edits the common attribute in the dictionary base attribute list of the template to be edited according to the fifth instruction of the user, and specifically modifies the common attribute in the dictionary base attribute list into a content meeting the requirement of the dictionary to be established; meanwhile, the dictionary generating unit 1013 further adds a data column in the template to be edited according to a fifth instruction of the user, and stores the template to be edited after the editing is completed to generate the required dictionary. It should be noted that, after the data column is added, the attribute of the added data column needs to be modified, so that the dictionary can better store the data. The dictionary generating unit 1013 may also be configured to edit the generated dictionary by editing the dictionary base property table and the default data columns of the dictionary. Further, assuming that the department dictionary is required to be established by the client and the dictionary template to be edited is the hierarchical dictionary template, the dictionary generating unit 1013 modifies the table names, dictionary titles, function categories, encoding types, and the like in the hierarchical dictionary template into the content corresponding to the department dictionary; and modifying the contents of the added data column, such as column description, column name, attribute name, data type in the input column, column length, selection control type and the like, into corresponding contents. And after the modification is finished, the dictionary to be edited is stored, namely a department dictionary is generated, and the user can store corresponding department information in the department dictionary according to the requirement.
It should be noted that, while the dictionary generation unit 1013 generates a dictionary, a help page corresponding to the dictionary is also generated so that data stored in the dictionary can be referred to. Meanwhile, in order to enable the generated dictionary to better meet the requirements of users, the generated dictionary is an editable dictionary, namely, the dictionary can be edited if the users need the dictionary. In order to better edit the template to be edited, the dictionary generating unit 1013 may further generate a browsing page before saving, so as to browse the format of the template to be edited that is edited before, check whether the editing of the template to be edited meets the user requirement, and further facilitate the user to edit the template to be edited.
The business document modeler 102 comprises: a service document type determining unit 1021, a service document template determining unit 1022 and a service document generating unit 1023.
The service document type determining unit 1021 is configured to determine the service document type according to the sixth instruction of the user.
Specifically, the service document may be divided into a plurality of types according to preset specifications, the user inputs a sixth instruction according to the service document type to which the service document to be created belongs, the service document type determining unit 1021 determines the service document type according to the sixth instruction, and sends the determined service document type information to the service document template determining unit 1022. Further, the service document type determining unit 1021 may classify the service document type into quality standard management, business management, policy management, customer relationship management, and the like according to the management contents. Assuming that the customer needs to establish an reimbursement application service document, since the reimbursement application service document belongs to the customer relationship management category, the sixth instruction input by the user to the service document type determining unit 1021 is for customer relationship management, and the service document type determining unit 1021 determines that the public system is selected and sends the selected information of customer relationship management to the service document template determining unit 1022.
The business document template determining unit 1022 is configured to determine a business document template to be selected according to the type of the business document, and select a business document template to be edited from the business document template to be selected according to a seventh instruction of the user.
Specifically, the business document template determining unit 1022 receives the business document type information transmitted by the business document type determining unit 1021, determines a corresponding business document template to be edited according to the business document type information to be established, and meanwhile, the business document template determining unit 1022 determines a business document template corresponding to the business document to be established in the business document template to be edited according to a seventh instruction input by the user. Furthermore, at least one business document template corresponding to each business document type is stored in the business document template determining unit 1022. Assuming that the customer needs to establish a reimbursement application business document, the business document template determining unit 1022 specifically works as follows: receiving the service document type information sent by the service document type determining unit 1021, that is, the selected information of the customer relationship management, and determining that the service document template corresponding to the customer relationship management includes a document template and a document template without an inner frame according to the information. Assuming that the reimbursement application service document to be created is in the form of an inner frame, the service document template determining unit 1022 selects the document template as the template to be edited according to a seventh instruction of the user, that is, the document template.
The business document generating unit 1023 is configured to edit the selected business document template to be edited according to an eighth instruction of the user, so as to generate an editable business document meeting the user requirement, and generate an approval object corresponding to the business document.
Specifically, all the business document templates include a corresponding business document basic attribute list and a business document default data list. The business document generating unit 1023 edits the public attribute in the business document basic attribute list of the template to be edited according to an eighth instruction of the user, and specifically modifies the public attribute in the business document basic attribute list into the content meeting the requirement of the business document to be established; meanwhile, the business document generating unit 1023 adds a data column in the template to be edited according to an eighth instruction of the user, and stores the template to be edited after the editing is completed to generate the required business document. The business document generating unit 1023 is further configured to edit the generated business document by editing the business document basic attribute table and the business document default data column. It should be noted that, after the data column is added, the attribute of the added data column needs to be modified, so that the business document can better store the data. Furthermore, assuming that the customer needs to establish an reimbursement application service document, and assuming that the to-be-edited service document template is the document template, the service document generating unit 1023 modifies the document title, table name, function type and the like in the document template into the content corresponding to the reimbursement application service document; and simultaneously modifying the contents of the added data column, such as column description, column name, attribute name, data type, column length, selection control type and the like, into corresponding contents. And after the modification is finished, the service document to be edited is stored, that is, the reimbursement application service document is generated, and meanwhile, the service document generation unit 1023 also generates an approval object corresponding to the reimbursement application service document, so that the service document can be circulated in the process.
The business document generating unit 1023 is further configured to generate a red document corresponding to the generated business document, and the red document is used to replace the original business document when an error occurs in the entry of the business document.
Specifically, when an original business document has an entry error in an entry process or a business itself has an error, the original business form needs to be cancelled, and a red form corresponding to the original business document needs to be generated. The red bill is completely the same as the original business bill so as not to influence the data entry.
It should be noted that, while the business document generating unit 1023 generates the business document, it also generates a help page corresponding to the business document, so that the data stored in the business document can be referred to. Meanwhile, in order to enable the generated business document to better meet the requirements of the user, the generated business document is an editable business document, namely the business document can be edited if the user needs the business document. In order to better edit the template to be edited, the business document generating unit 1023 may further generate a browsing page before saving, so as to browse the format of the template to be edited, check whether the editing of the template to be edited meets the user requirements, and facilitate the user to edit the template to be edited.
Fig. 3 is a schematic structural diagram of a service data query module according to an embodiment of the present invention.
As shown in fig. 3, the service data query module according to the embodiment of the present invention mainly includes: a form dataset creating unit 201, a query report creating unit 202, a data binding unit 203, a query statement generating unit 204, a data querying unit 205, a data processing unit 206, and a permission setting unit 207.
Specifically, the form dataset creating unit 201 is configured to create a form dataset, and enable the dataset to hold a plurality of associated data objects, a plurality of fields corresponding to each data object, and business data corresponding to each field. The form dataset serves as a data source for the query report.
Preferably, the data objects and fields are selected from the business database in response to a selection instruction entered by the user.
Specifically, based on the data that the user wants to present, the associated data object and a plurality of fields corresponding to each data object are selected from the business database according to the selection instruction input by the user, wherein each field corresponds to business data. Form datasets are created based on the selected data objects, the fields corresponding to each data object, and the business data corresponding to each field.
Here, for convenience of understanding, the description will be given taking an example of inquiring data of the business trip reimbursement application.
First, based on the business trip reimbursement application data that the user wants to present, three associated data objects are selected from the business database according to a first selection instruction input by the user, wherein the data objects are respectively 'business trip reimbursement', 'accommodation fee' and 'transportation fee'. Next, according to a second selection instruction input by the user, the "document number", "trip location" and "trip event route" fields are selected from the "trip reimbursement" data object, the "accommodation date" and "accommodation amount" fields are selected from the "accommodation fee" data object, and the "traffic date" and "traffic fee" fields are selected from the "traffic fee" data object. Here, it should be noted that each field corresponds to service data. Finally, a form dataset is created for the business return application based on the selected data objects, the fields corresponding to each data object, and the business data corresponding to each field.
The form data set of the embodiment of the invention is created based on the data which the user wants to show, namely, the user wants to show which data in the query report, corresponding data objects and fields are selected from the business database, and each field corresponds to business data. Therefore, the form data set can be created according to the user requirements in a self-defining mode.
And the query report creating unit 202 is configured to create a query report based on the data objects and the fields, and store the query report with the fields as query items.
The query reports are mainly divided into five types: detail report, unit report, floating row report, floating column report and floating row and column report. The detail report is a report in which the header of the report is fixed and the data of the report is displayed in a mode of automatically expanding downwards in a whole line. The unit report is a report in which data is displayed in a cell format, and the header of the report and the displayed data are fixed. The floating row report is a report in which the header of the report is fixed and the data of the report is displayed in a manner of automatically expanding from row to row (similar to the detailed report, but the floating row can set a floating condition, which is a component of the floating row-column report). The floating column report is a report in which the report format shows data in a column-to-right automatic expansion mode. The floating row-column report is a report in which the data is displayed in a report format in a mode of automatically expanding rows downwards and automatically expanding columns rightwards.
When the query report is created, different types of query reports can be created according to different instructions input by a user. In addition, the form style of the query report can be customized according to the instruction input by the user. For example, the table style can be obtained by importing Excel, can be obtained by introducing a template, or can be defined by the user according to requirements.
Specifically, based on the data objects and fields selected by the user, a query report is created, as shown in table 1:
TABLE 1 statement of detailed inquiry of business trip reimbursement application
The query items in the query report are fields of data objects selected by the user, namely, data which the user wants to show in the query report.
And the data binding unit 203 is used for binding the business data corresponding to each field in the table and form data set of the row or column where the field is located aiming at each field in the query report.
Specifically, for the "document number" field in the query report, the cell in the column in which the field is located is bound to the business data corresponding to the "document number" field in the form data set. That is, after data binding, the cell in the column of the "document number" in the query report only displays the business data related to the document number in the form data set. And binding the cells in the column of the field with the business data corresponding to the 'business trip location' field in the form data set aiming at the 'business trip location' field in the query report. That is, after data binding, the cell in the column of the "business trip location" in the query report only displays the business data related to the business trip location in the form data set. And repeating the steps until the cells in the columns where the fields in the query report are located are bound with the business data corresponding to the fields in the form data set.
Here, it should be noted that, according to the created form style, it is determined whether to bind the service data corresponding to the field in the cell and form data set of the row where the field is located, or to bind the service data corresponding to the field in the cell and form data set of the column where the field is located. For example, according to the created form style of table 1 above, it can be determined that the business data corresponding to the field in the cell and form data set of the column where the field is located is bound.
The query statement generating unit 204 is configured to obtain a query instruction including a field to be queried, which is input by a user, and automatically generate a query statement corresponding to the query instruction based on a preset query language grammar rule.
Specifically, when a user wants to query data related to a document number 001, the user inputs a query instruction including "document number 001", and the query expression generating unit 204 automatically generates a query expression corresponding to the query instruction based on a preset query language grammar rule after acquiring the query instruction input by the user.
Here, it should be noted that the query statement of the embodiment of the present invention is not limited to the SQL statement. When a user wants to query business data by using other query languages except SQL sentences, only syntax rules of the query language need to be input into the query sentence generating unit in advance, and after the query sentence generating unit obtains a query instruction which is input by the user and comprises a field to be queried, the query sentence generating unit can automatically generate a query sentence corresponding to the query instruction based on the preset query language syntax rules.
The data query unit 205 is configured to query, in the query report, the service data corresponding to the field to be queried by using the query statement, and output a query result.
Specifically, the query statement generated above is used to query the business data corresponding to the "document number 001" in the query report, and the query result is output, as shown in table 2 below:
TABLE 2 Exit reimbursement application detail query results
Based on this, the query of the service data can be completed.
And the data processing unit 206 is configured to perform data processing on the query result according to the data processing instruction input by the user.
Preferably, the data processing comprises one or more of sorting, grouping, co-searching and drilling.
Here, it should be noted that the packet includes an independent packet and a logical packet. Independent grouping refers to grouping the result data that meets the condition according to the data processing instruction input by the user. For example, when the user inputs a condition that "the traffic cost is greater than 80", data of the rows (i.e., the first row and the third row) where "the traffic cost is 200" and "the traffic cost is 100" in the query report are grouped. Logical grouping refers to grouping the same data in the query results into a group. For example, when the user inputs a condition of "accommodation amount is 200", data of the row (i.e., the first row and the second row) in which "accommodation amount is 200" in the query report is grouped.
By processing the data of the query result, the user can check the data conveniently, and the working efficiency is effectively improved.
And the authority setting unit 207 is used for setting the authority for the query report according to the authority instruction input by the user.
Here, it should be noted that the right setting unit 207 is connected to the data binding unit 203. After each field in the query report is subjected to data binding, setting authority for the query report according to an authority instruction input by a user.
Preferably, the rights include access rights and operation rights. Here, it should be noted that the operation authority is mainly used for controlling the operation of the query report by the user, for example, the operation of modifying, saving, submitting, printing, and the like of the query report by the user may be controlled. Besides, the operation authority can be used for controlling the data of the query report to be operated by the user.
By setting the authority of the query report, the access and operation authority of the user can be flexibly controlled, and the safety of query report data is effectively ensured.
By applying the method for rapidly establishing different service systems provided by the embodiment of the invention, the use permission of different functional modules of different service systems can be distributed to corresponding users according to the service requirements of different users, the rapid establishment of various different service systems and/or functional modules can be realized without changing codes by the users, and the method has good application prospect.
Those skilled in the art will appreciate that the modules or steps of the invention described above can be implemented in a general purpose computing device, centralized on a single computing device or distributed across a network of computing devices, and optionally implemented in program code that is executable by a computing device, such that the modules or steps are stored in a memory device and executed by a computing device, fabricated separately into integrated circuit modules, or fabricated as a single integrated circuit module. Thus, the present invention is not limited to any specific combination of hardware and software.
Although the embodiments of the present invention have been described above, the above description is only for the convenience of understanding the present invention, and is not intended to limit the present invention. It will be understood by those skilled in the art that various changes in form and details may be made therein without departing from the spirit and scope of the invention as defined by the appended claims.
Claims (10)
1. A method for quickly establishing different service systems is characterized by comprising the following steps:
acquiring a first instruction which is input by a user and indicates a service system required to be used;
extracting first key information of a service system required to be used by a user from the first instruction;
determining the authority of the user for using the service system according to the first key information;
and distributing the authority of the user for using the service system to the user, thereby realizing the rapid establishment of different service systems.
2. The method of claim 1, wherein the business system comprises a plurality of functional modules having different functions, the method further comprising:
under the condition that the authority indicates that the user has the right to use the service system, acquiring a second instruction which is input by the user and indicates a functional module required to be used;
extracting second key information of the functional module required to be used by the user from the second instruction;
determining the authority of the user for using each functional module according to the second key information;
and distributing the authority of the user for using each functional module to the user, thereby realizing the rapid establishment of different functional modules of different service systems.
3. The method of claim 2, wherein the functional modules comprise a business form modeling module and a business data query module.
4. The method of claim 3, wherein the business form modeling module comprises a dictionary modeler and a business document modeler;
the dictionary modeler includes:
the dictionary type determining unit is used for determining the dictionary type according to a third instruction of the user;
the dictionary template determining unit is used for determining a dictionary template to be selected according to the dictionary type and selecting the dictionary template to be edited from the dictionary template to be selected according to a fourth instruction of a user;
the dictionary generating unit is used for editing the dictionary template to be edited according to a fifth instruction of a user so as to generate an editable dictionary;
the business document modeler comprises:
the business document type determining unit is used for determining the type of the business document according to a sixth instruction of the user;
the business document template determining unit is used for determining a business document template to be selected according to the business document type and selecting the business document template to be edited from the business document template to be selected according to a seventh instruction of a user;
and the business document generating unit is used for editing the business document template to be edited according to an eighth instruction of the user to generate an editable business document and generate an approval object corresponding to the business document.
5. The method according to claim 4, wherein the dictionary generating unit is specifically configured to edit the dictionary template to be edited by editing a dictionary base attribute table and a dictionary default data column;
the dictionary generating unit is further used for editing the dictionary by editing the dictionary basic property list and default data columns of the dictionary.
6. The method according to claim 4, wherein the business document generating unit is specifically configured to edit the selected business document template by editing a business document basic attribute table and a business document default data column;
the business document generating unit is also used for editing the generated business document by editing the basic attribute list of the business document and the default data column of the business document.
7. The method of claim 3, wherein the service data query module comprises:
the form data set creating unit is used for creating a form data set and enabling the data set to store a plurality of related data objects, a plurality of fields corresponding to each data object and service data corresponding to each field;
the query report creating unit is used for creating a query report based on the data object and the field and enabling the query report to store the field serving as a query item;
the data binding unit is used for binding the business data corresponding to each field in the form data set and the cell of the row or column where the field is located aiming at each field in the query report;
the query statement generating unit is used for acquiring a query instruction which is input by a user and comprises a field to be queried, and automatically generating a query statement corresponding to the query instruction based on a preset query language grammar rule;
and the data query unit is used for querying the business data corresponding to the field to be queried in the query report by using the query statement and outputting a query result.
8. The method of claim 7, wherein the data objects and the fields are selected from a business database in response to a selection instruction entered by a user.
9. The method according to claim 7 or 8, wherein the service data query module further comprises: and the data processing unit is used for processing the data of the query result according to the data processing instruction input by the user.
10. The method of claim 9, wherein the data processing comprises one or more of sorting, grouping, joint inspection, and drilling.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910662526.9A CN110597491B (en) | 2019-07-22 | 2019-07-22 | Method for quickly constructing different service systems |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910662526.9A CN110597491B (en) | 2019-07-22 | 2019-07-22 | Method for quickly constructing different service systems |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110597491A true CN110597491A (en) | 2019-12-20 |
| CN110597491B CN110597491B (en) | 2023-06-13 |
Family
ID=68852872
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910662526.9A Active CN110597491B (en) | 2019-07-22 | 2019-07-22 | Method for quickly constructing different service systems |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110597491B (en) |
Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103186632A (en) * | 2011-12-31 | 2013-07-03 | 成都勤智数码科技股份有限公司 | Method and device for customizing operation and maintenance form |
| CN103995698A (en) * | 2014-05-05 | 2014-08-20 | 重庆斯欧信息技术有限公司 | Application form agile development method and system oriented to business |
| US20150113498A1 (en) * | 2013-10-21 | 2015-04-23 | Microsoft Corporation | Modeling customizations to a computer system without modifying base elements |
| CN104809369A (en) * | 2014-01-26 | 2015-07-29 | 四川长虹电器股份有限公司 | Method, client, server and system for grouping device access permissions |
| CN105260858A (en) * | 2015-11-16 | 2016-01-20 | 苏州天地微易智能科技有限公司 | Oa intelligent office system and management method thereof |
| CN107273122A (en) * | 2017-06-07 | 2017-10-20 | 深圳市卓讯信息技术有限公司 | Based on decoupling mechanism can iteration set up operation system method and its terminal |
| CN107528853A (en) * | 2017-09-12 | 2017-12-29 | 上海艾融软件股份有限公司 | The implementation method of micro services control of authority |
| CN108008940A (en) * | 2017-12-29 | 2018-05-08 | 成都邦永科技有限公司 | A kind of software customized platform of service management and its method for customizing |
| CN108877793A (en) * | 2018-05-30 | 2018-11-23 | Oppo广东移动通信有限公司 | Application control method, apparatus, storage medium and electronic equipment |
| CN109582422A (en) * | 2018-11-30 | 2019-04-05 | 广州净松软件科技有限公司 | Observation system construction method, device, equipment and storage medium component-based |
| CN109862182A (en) * | 2019-01-25 | 2019-06-07 | 努比亚技术有限公司 | A kind of communication traffic processing method and mobile terminal |
-
2019
- 2019-07-22 CN CN201910662526.9A patent/CN110597491B/en active Active
Patent Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103186632A (en) * | 2011-12-31 | 2013-07-03 | 成都勤智数码科技股份有限公司 | Method and device for customizing operation and maintenance form |
| US20150113498A1 (en) * | 2013-10-21 | 2015-04-23 | Microsoft Corporation | Modeling customizations to a computer system without modifying base elements |
| CN104809369A (en) * | 2014-01-26 | 2015-07-29 | 四川长虹电器股份有限公司 | Method, client, server and system for grouping device access permissions |
| CN103995698A (en) * | 2014-05-05 | 2014-08-20 | 重庆斯欧信息技术有限公司 | Application form agile development method and system oriented to business |
| CN105260858A (en) * | 2015-11-16 | 2016-01-20 | 苏州天地微易智能科技有限公司 | Oa intelligent office system and management method thereof |
| CN107273122A (en) * | 2017-06-07 | 2017-10-20 | 深圳市卓讯信息技术有限公司 | Based on decoupling mechanism can iteration set up operation system method and its terminal |
| CN107528853A (en) * | 2017-09-12 | 2017-12-29 | 上海艾融软件股份有限公司 | The implementation method of micro services control of authority |
| CN108008940A (en) * | 2017-12-29 | 2018-05-08 | 成都邦永科技有限公司 | A kind of software customized platform of service management and its method for customizing |
| CN108877793A (en) * | 2018-05-30 | 2018-11-23 | Oppo广东移动通信有限公司 | Application control method, apparatus, storage medium and electronic equipment |
| CN109582422A (en) * | 2018-11-30 | 2019-04-05 | 广州净松软件科技有限公司 | Observation system construction method, device, equipment and storage medium component-based |
| CN109862182A (en) * | 2019-01-25 | 2019-06-07 | 努比亚技术有限公司 | A kind of communication traffic processing method and mobile terminal |
Non-Patent Citations (2)
| Title |
|---|
| NAFTALY H. MINSKY 等: "A mechanism for establishing policies for electronic commerce", 《IEEE》 * |
| 祁凯: "基于面向对象petri网的ERP动态过程建模研究", 《科技与管理》 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110597491B (en) | 2023-06-13 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110543303B (en) | Visual service platform | |
| CN109101652B (en) | Label creating and managing system | |
| CN101308490B (en) | Dynamic report generation method and platform | |
| US6996589B1 (en) | System and method for database conversion | |
| CN104133772A (en) | Automatic test data generation method | |
| CN110597842B (en) | Service data query method and system | |
| CN107145480B (en) | Method for compiling XBRL report based on Word | |
| CN103530407B (en) | Method and device for generating rich text document | |
| US20210049711A1 (en) | Method of automatically transmitting data information and device of automatically transmitting data information | |
| CN101430714B (en) | Content structuring process method and system based on model | |
| CN103246733A (en) | Dynamic form system based on metadata and generation method thereof | |
| CN106407170A (en) | Rapid generation method and system for data report | |
| CN101488086A (en) | Software generation method and apparatus based on field model | |
| CN102214243A (en) | Version management system for x extensible business reporting language (XBRL) classification standard | |
| CN108829651A (en) | A kind of method, apparatus of document treatment, terminal device and storage medium | |
| CN101853163B (en) | Industry application software system construction method based on assembly business modeling | |
| CN115525624A (en) | Method for modeling and processing batch data | |
| CN104573053B (en) | A kind of configuration item template dynamic customization method based on XML | |
| CN105912723A (en) | Storage method of custom field | |
| CN116644728A (en) | Contract generation method and system based on clause digitization | |
| CN111242457A (en) | Construction technology management system and method | |
| CN110597491B (en) | Method for quickly constructing different service systems | |
| CN114004587B (en) | Design system and method for automatic control of whole machine model | |
| CN115713309A (en) | Internal auditing system | |
| CN116450246A (en) | Event stream configurable method based on state machine |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |