CN110249356A

CN110249356A - A kind of sharing method and system of user-defined ERP function

Info

Publication number: CN110249356A
Application number: CN201780077869.8A
Authority: CN
Inventors: 李康秀
Original assignee: De Zun Bi Zun Co Ltd
Current assignee: De Zun Bi Zun Co Ltd
Priority date: 2016-11-25
Filing date: 2017-02-28
Publication date: 2019-09-17
Anticipated expiration: 2037-02-28
Also published as: KR20180059602A; KR101944973B1; WO2018097407A1; CN110249356B

Abstract

The present invention provides a kind of method and system, receive including user-defined ERP function shared system from multiple sharer's terminals include at least one SQL file and design document, wrap corresponding to the source of scheduled ERP user's defined function, design document is the file at least one the control property information that storage constitutes user-defined ERP functional picture, and constituting is to be mapped to the control including the ad hoc inquiry at least one SQL file at least partially in the control of the picture of user-defined ERP function；User-defined ERP function shared system will be stored in scheduled repository from the received source packet of multiple sharer's terminals；The source the package list of storage in storage is supplied to user terminal by user-defined ERP function shared system；And the request in response to user terminal, user terminal is sent by the target source packet of the user terminal selecting in the source packet of storage in storage.

Description

A kind of sharing method and system of user-defined ERP function

Technical field

The present invention relates to the sharing methods and system of user-defined ERP function.More particularly it relates to a kind of energy User such as enterprise etc. using ERP software is enough allowed, by the independently developed user-defined ERP function of being suitble to oneself operation flow The method and system shared with other people.

Background technique

Enterprise Resources Planning (Enterprise Resource Planning) is one for enterprise operation and business pipe The computer system of reason, or the software package of installation in such systems.There are SAP and Oracle in the representative company for providing ERP service, There is DOUZONE in the representative company of South Korea.Meanwhile in order to make enterprise receive ERP service, the user terminal in enterprise is not only needed Middle installation ERP software, it is necessary to establish the database of the storage various information of relevant enterprise.

By ERP system, enterprise can effectively Management Accounting, occurrences in human life, wage, sale, trade, buying, material, life It produces, outsourcing, service and operation information.In addition, by introducing ERP system, enterprise can by reduce between each administrative department by It is different in information system and caused by poor efficiency, increase productivity to the maximum extent.It is systematically identified in addition, ERP can be provided With the advantage of the various information of management enterprise.

The operation flow that has oneself intrinsic due to each company and there is different enterprise operation strategies, it is therefore desirable to ERP software is customized to adapt to the feature, operation flow and workflow of enterprise, this is different from common software packet.Traditionally, in order to To the ERP system of each enterprise building customization, it is necessary to analyze the requirement and operation flow of each company, and open based on this Hair customization ERP software is taken largely with the customization ERP system for being suitable for each enterprise, therefore establishing to be suitable for each enterprise Time and money.Further, since at high cost, small enterprise is difficult to introduce ERP system.

Summary of the invention

Technical task

The invention solves technical task be to provide a kind of method and system, i.e. offer Integrated Development Environment is to entirety Database Modeling, SQL query and UI for operating the database are developed, the customization ERP discrete function for being suitble to enterprise can be made It can easily produce, and user is allowed easily to share independently developed ERP function with other people.

Technical Solving

According to an aspect of the present invention, user-defined ERP (Enterprise Resource Planning) function (function) sharing method, comprising: user-defined ERP function shared system from multiple sharer's terminals reception include to A few SQL file and design document, corresponding to scheduled ERP user's defined function source packet the step of-the wherein SQL File is that structured query language (SQL:Structured Query Language) of the storage for operating database is inquired File, the design document are at least one control property information that storage constitutes the user-defined ERP functional picture File, wherein constituting in the control of the user-defined ERP functional picture is to be mapped to be included at least one at least partially The control-of ad hoc inquiry in a SQL file；The user-defined ERP function shared system will be from multiple sharer's terminals Wrap the step being stored in scheduled repository in received source；The user-defined ERP function shared system will be stored in institute State the step of source the package list in repository is supplied to user terminal；And the request in response to the user terminal, it will be stored in The step of target source packet of the user terminal selecting in the packet of source in the repository is sent to the user terminal.

According to one embodiment, the user-defined ERP function shared system will connect from the multiple sharer's terminal The step of scheduled repository is arrived in the source packet storage of receipts may include: the user-defined ERP function that judgement corresponds to source packet The step of which of predefined multiple classifications can be belonged to；It is corresponding user-defined with source packet to be referred to Classification belonging to ERP function is simultaneously stored to the step in the repository.

According to one embodiment, the user-defined ERP function that judgement corresponds to source packet belongs to predefined multiple The step of which of classification may include: at least one the SQL file or source packet for including in the analysis source packet The step of design document for including；Judge that user-defined ERP function corresponding with source packet belongs to based on analysis result The step of which of multiple classifications.

According to one embodiment, the user terminal executes source and wraps transmission method and source packet method for down loading, and the source is wrapped Transmission method may include: that offer source is wrapped the step of passing UI, and the source, which is wrapped, to be passed UI and provide from being stored in the user terminal At least one source packet list in select the functions of at least some projects；It will be corresponding to selected with biography UI is wrapped by the source The step of source packet of project is sent to the user-defined ERP function shared system, the source packet method for down loading includes: from institute State the step of user-defined ERP function shared system receives the source the package list being stored in the repository；Under the packet of offer source The step of carrying UI, source packet downloading UI provide from the functions of at least some projects is selected in received source the package list；With it is logical It crosses the source packet downloading UI and receives the step for corresponding to the source of selected item and wrapping from the user-defined ERP function shared system Suddenly.

According to one embodiment, the user terminal receives the mesh from the user-defined ERP function shared system Mark source packet, then executes the generation method of user-defined ERP function corresponding with the target source packet, with the target source The generation method for wrapping corresponding user-defined ERP function may include: container UI packet the step of providing container UI Include UI object corresponding with ERD file, with include that each of at least one SQL file in the target source packet is corresponding UI object and with include the corresponding UI object of design document in the target source packet, wherein the ERD file can To be for storing the attribute about table and the modeling information about relationship between table that modeling information is stored in DB130 File；When selecting UI object corresponding with the ERD file, the ERD file for editing the ERD file is provided and is compiled The step of collecting function；When selection is with a corresponding UI object at least one SQL file, provide for editor and institute The step of selecting the SQL Document Editing function of the corresponding SQL file of UI object；As selection UI corresponding with the design document When object, the step of design document editting function for editing the design document is provided；Be based at least one described SQL File and the design document, the step of user-defined ERP function is provided.

According to another aspect of the present invention, computer program is provided, is mounted in data processing equipment, and is stored in note In recording medium, for executing the method.

According to another aspect of the present invention, user-defined ERP function shared system is provided, it is described user-defined ERP function shared system includes at least one processor；And for storing depositing for the computer program executed by the processor Reservoir, wherein when the computer program is executed by the processor, so that the user-defined ERP function shared system Execute user-defined ERP function sharing method.

The effect of invention

According to an embodiment of the invention, providing a kind of method and system, i.e., offer Integrated Development Environment is to whole development Database Modeling, SQL query and UI for operating the database can enable the customization ERP discrete function for being suitble to enterprise It easily produces.

And a kind of method and system are provided, share user easily independently developed ERP function with other people.

Detailed description of the invention

In order to fully understand to schematic diagram cited in the detailed description of the invention, each schematic diagram is provided briefly It is bright.

Fig. 1 a is that the operating environment for the generation method of user-defined ERP function for showing embodiment according to the present invention is shown It is intended to.

Fig. 1 b is the block diagram for schematically showing the user terminal configuration of embodiment according to the present invention.

Fig. 2 is the letter for showing the process according to an embodiment of the present invention that user-defined ERP function is generated by user terminal Slightly schematic diagram.

Fig. 3 is the exemplary of the UI for the Integrated Development Environment provided by user terminal for showing embodiment according to the present invention Figure.

Fig. 4 is the exemplary figure for showing project Window.

Fig. 5 is the exemplary figure for showing database search window.

Fig. 6 is the process for schematically showing generation system according to an embodiment of the present invention and executing ERD Document Editing function Flow chart.

Fig. 7 is the exemplary figure for showing ERD Document Editing UI.

Fig. 8 is the mistake for schematically showing the user terminal execution SQL Document Editing function of embodiment according to the present invention The flow chart of journey.

Fig. 9 is the exemplary figure for showing SQL Document Editing UI.

Figure 10 is the user terminal execution design document editting function for schematically showing embodiment according to the present invention The flow chart of process.

Figure 11 is the exemplary figure for showing design document editor UI.

Figure 12 is the exemplary figure for showing tool box window.

Figure 13 is the exemplary figure for showing property window.

Figure 14 is the exemplary figure for showing script window.

Figure 15 a to 15e is the exemplary figure for showing SQL mapping UI.

Figure 16 is the flow chart for schematically showing the mapping process between SQL and control.

Figure 17 is to show user-defined ERP function shared system according to an embodiment of the present invention and be total to by user terminal Enjoy the exemplary figure of the process of user-defined ERP function.

Figure 18 is that the exemplary figure for passing UI is wrapped in the source that shows.

Figure 19 is the exemplary figure for showing source packet downloading UI.

Specific embodiment

The present invention is able to carry out various modifications and can have various embodiments, by specific embodiment be shown in the accompanying drawings and It is described in detail in detailed description.However the present invention should be understood to be not limited to these specific embodiments, and including falling into the present invention Thought and technical scope in all modifications, equivalents, and substitutions object.In explaining the present invention, for the specific of known technology If illustrating to be judged as that purport of the invention can be made to thicken, correlation is described in detail and will be omitted.

Term first, second etc. can be used for describing various assemblies, but component should not be limited by the term.These terms are only For distinguishing a component and another component.

Term used herein is only used for description specific embodiment, it is no intended to the limitation present invention.Unless context Otherwise expressly specified, otherwise odd number expression includes plural number expression.

In the present specification, term " includes " or " having " etc. refer to the feature, number, step, operation, element, group The presence of part or combinations thereof, but should be understood to be not excluded for other one or more features, number, step, operation, member A possibility that presence or addition of part, component or combinations thereof.

It is described when any one constituent element " transmission " data is to another constituent element in addition, in the present specification The data can be sent directly to another described constituent element by constituent element, or can pass through at least one other structure Another described constituent element is sent from the constituent element by the data at element.On the contrary, when a constituent element is " straight Receive and send " data to another constituent element when, it means that the data, which by the constituent element do not pass through other and constitute, to be wanted Element and be sent to another described constituent element.

Hereinafter, by reference view embodiment according to the present invention the present invention is described in detail.It is identical in schematic diagram Identical element is indicated referring to code.

Fig. 1 a is showing for the operating environment for the user-defined ERP function generation method for showing embodiment according to the present invention It is intended to.With reference to Fig. 1 a, (100-1 to 100-N) and user-defined ERP function shared system 200 are (hereinafter for multiple user terminals Referred to as " shared system ") it is connected by wire/radio network, user-defined ERP according to an embodiment of the present invention can be executed Function generation method.(100-1 to 100-N) can be shared fixed with ERP user by the shared system 200 for multiple user terminals The corresponding source packet of adopted function.

For example, each user terminal (100-1 to 100-N) can create source corresponding with user-defined ERP function Packet, and shared system 200 is uploaded to share with other people.Hereinafter, the user terminal for uploading source packet will be referred to as Sharer's terminal.

The source packet of upload can store in scheduled repository 210.The repository 210 can be storage and upload to altogether The equipment for enjoying the source packet of system 200.The repository 210 can be database or memory devices.Repository 210 can be packet The component in shared system 200 is included, but not limited to this, and can be the physical equipment isolated with shared system 200, such as scheme Shown in 1a.

On the other hand, (each of 100-1 to 100-N) can be downloaded is stored in shared system 200 to user terminal A part of multiple sources packet in repository 210.

The user terminal 100 can be handheld device, such as mobile phone, satellite phone, radio telephone, session setup Agreement (SIP:Session Initiation Protocol), wireless local loop (WLL:Wireless Local Loop) It stands, smart phone, tablet computer, palm PC (PDA:Personal Digital Assistant) etc., is also possible to desk-top Computer or laptop.

The shared system 200 may include hardware resource (resource) necessary to realizing technical idea of the invention And/or software, and it is not necessarily mean that a physical assemblies or individual equipment.That is, the shared system 200 can be with The logical combination of hardware and/or software for indicating technical idea to realize the present invention and providing.If desired, can also be pacified To execute respective function in individual device, so as to be presented as realizing one group of technical idea of the invention Logical combination.In addition, the shared system 200 can be expressed as it is for realizing technical idea of the invention, by each function Or the combination of element that role individually embodies.

The shared system 200 can be realized in the form of multiple modules.For example, the shared system 200 may include Network and various user terminals (at least one communication module that 100-1 to 100-N) is communicated, or execute described shared can be passed through The major function of system 200 and the function and/or resource that the other assemblies for including in the shared system 200 can be controlled Control module, and the memory module of various information can be stored, and can be with the input/output module of user interface etc..Packet Including can be located in different physical equipments in the various modules in the shared system 200, can also be located at same physics and set In standby.

In this specification, module can indicate hardware for executing technical idea of the invention and for driving hardware The functionality of software and structural combination.For example, the module can indicate predetermined code and for executing the hard of predetermined code The logic unit of part resource, and the average expert of the technical field of the invention can be readily concluded that it is not necessarily indicated The code of physical connection or a kind of hardware.

Fig. 1 b is the block diagram for schematically showing the user terminal 100 of embodiment according to the present invention and configuring.With reference to Fig. 1 b, The user terminal 100 includes user-defined ERP function generation module 110 (hereinafter referred to as " generation module "), the user Definition ERP function-driven module 120 (hereinafter referred to as " drive module ") and user-defined ERP function sharing module 140 (with It is known as " sharing module " down).

In some cases, the user terminal 100 can also include DB130, realize technology of the invention for storing The various information of various data needed for thought and company.

It includes the example in the user terminal 100 that Fig. 1 b, which shows DB130,.However, in other embodiments can be with Unlike this, DB130 can be the individual system form with 100 physical separation of user terminal.In this case, institute Stating user terminal 100 and DB130 can be connected to each other to send and receive various data and information via network.In addition, according to Embodiment, the user terminal 100 can with include multiple DB mono- that are in the user terminal 100 or passing through network connection Play operation.

In the present specification, database (DB:DataBase) can be realized by least one table, and also may indicate that into One step include for searching for, storage and management be stored in information in the DB individual data base management system (DBMS: Database Management System).In addition, it can be realized in various ways, such as chained list (linked-list), (Tree), relationship DB etc. are set, and can indicate to include all data that can store the information that be stored in the DB130 Storage medium and data structure.

The user-defined ERP that user-defined ERP function can be generated in the generation module 110 or editor is previously created Function.The drive module 120 can drive the user-defined ERP function of being generated by the generation module 110, with to user The user-defined ERP function is provided.The sharing module 140 can define the user that the generation module 110 generates ERP function upload to the shared system 200 and shared with other users, other people can also be shared user-defined ERP function is downloaded from the shared system 200.

The generation module 110, drive module 120 and sharing module 140 can be designed as physics independently and set It is standby.Alternatively, the module 110,120,140 can be designed as a physical equipment according to embodiment.In latter situation Under, each of three modules 110,120 and 140 can be configured as individually logically separate software, or can be with It is designed to an integrated software.

Hereinafter, understand for convenience, present invention will be described as, technical idea according to the present invention, by the generation Module 110 executes the systematic function of user-defined ERP function, executes user-defined ERP generated by drive module 110 The driving function of function is executed the sharing functionality of user-defined ERP function by sharing module 140, however, according to different implementations Example can be different from Fig. 1 b, and the user terminal 100 can be defined by the comprehensive user for executing technical idea according to the present invention The systematic function of ERP function, user-defined ERP function generated driving function and user-defined ERP function System of sharing functionality realize.

User-defined ERP function is desirably integrated into ERP system, can be the unit function with itself independent meaning Energy.The function that user-defined ERP function can execute management, operate, uses and analyze the company information being stored in DB130 Energy.The user interface (UI:User Interface) for the customization for allowing user to execute these functions can be provided.That is, User can be stored in DB130 by the UI that the ERP function being defined by the user provides to manage, operate, use and analyze Company information.

User defines the input of example documentary, account book management, account increase and decrease management, the credits aging analysis of accounts/pipe of ERP function Reason, settlement management, financial statement, fund/budget management, budget and service condition comparative analysis, fixed capital management, surtax Declare management, financial special management, human resource management, attendance management, salary management, social insurance management, annual closing pipe It manages, settlement management of resigning from office, tax declaration management, different gained voucher processing, Casual Worker Management, home sale plan/pipe Reason, commission/inspection management, outbound/return management, sale Contribution Analysis, delivery/delivery management, is faced at quotation/order processing When outbound/mandatory administration, marketing balance, the calculation processing of electronics duty receipt, gathering/credits management, credits aging analysis of accounts, Export projects Formulation/management, order management, outbound management, marketing balance, shipment management, report view/order handling ships/management of receiving, into Mouth is calculated at present treatment, non-delivery settlement process, import cost distribution, main production plan (MPS), material requested, and application official report view/ It places an order, is put in storage commission/inspection, interim stock management, buys in clearing/accounting, payment/debt management, stock control (LOT), system Determine production plan/management, internal pair production management, mixed processes management, byproduct/disassembly management, foundry production management, go into operation refer to Conduit reason, wrapped steel joint, service reception/processing, service credits management, finance/cost-benefit analysis, the profit and loss/interest analysis, main wealth Business analysis, logistics analysis and summary, the marketing analysis of different characteristics, the attendance of the production of season/season analysis on Achievements, different characteristics Analysis, contract management, field management, subpackage/completion management, is reported, advance payment/account payable pipe operation day wage/bonus simulation Reason, labor service equipment management, settlement management, labor service declare management, outsourcing completion management and cost-effectiveness management etc., but except this it It outside, can also be there are many kinds of function.

As shown in Figure 1 b, the user terminal 100 arrives the shared system 200 by network connection, and can send Various information, data, signal and/or message needed for the technical idea of the invention with realization is received.

The user terminal 100 can send the result created by the systematic function of user-defined ERP function To the shared system 200, and the shared system 200 can be provided (transmission) to other desired user.Also It is to say, the shared system 200 can execute the user-defined ERP function of uploading each user and share to other users Function.

It may include ERP file, at least one SQL file by the systematic function of ERP function result generated and set File is counted, and can also include report file according to embodiment.

The ERD file can be for storing the attribute about table and pass that modeling information is stored in DB130 The file of the modeling information of relationship between table.

Entity relationship model (ERD:Entity Relationship Diagram) is most common data modeling technology. It expresses the structure and relationship of data using simple shape (rectangle, ellipse, brilliant etc.), as will data individual between Relationship and attribute graph tool, use is most universal.User can by using ERD by the relationship of data illustrate from And its relationship is visually more easily to understand.The component of ERD is entity (Entity), relationship (Relationship) and attribute (Attribute).Entity is indicated as the main body that store information in the database or as the corpus separatum of object.In number In modeling according to library, the table stored in the database can be an entity.Relationship indicate two or more entities how phase Mutual correlation.Attribute is the data item for describing the feature of entity or relationship.It can the referred to as crucial category of each entity attributes of unique identification Property.

The SQL file can be the structured query language (SQL:Structured stored for manipulating DB130 Query Language) inquiry file.Each SQL file can store one or more SQL queries.

SQL is the programming language for managing the data of data base management system (DBMS) for special purposes and designing, can For creating the search and management of the data for being stored in database, the creation of database schema and modification and database object The inquiry of access control management etc..Sql command can be divided into three types according to its function: data manipulation (DML), data definition (DDL) and data control (DCL).Data manipulation (DML) is that have for changing data in the database or searching for the order of data INSERT (addition data), UPDATE (more new data), DELETE (deleting data), SELECT (search data) etc..Data are fixed Adopted (DDL) is that have CREATE (generating table etc.), DROP (deleting table etc.) for changing the isostructural order of table comprising data, ALTER (structure etc. of list of modification) etc..Data control (DCL) is a kind of order for authorizing or cancelling access data base authority, is had GRANT (authorizing user right) and REVOKE (revocation user right) etc..

The design document can be storage about at least one control property for constituting user-defined ERP function interface Information file.Here, control can be the UI object for being able to carry out and interacting with user, such as shows information or passes through user Receive information etc..

In addition, at least part for constituting the control of user-defined ERP function interface can be mapped to be included in The control of ad hoc inquiry in a few SQL file.Hereinafter, this control will be referred to as Net Lattice Controls.

Report file may include about the information of the attribute for the multiple controls for constituting report electronic document and about binding To the information of the data of each control.

As shown in Fig. 2, the generation module 110 can provide container UI, the UI container includes corresponding with ERD file The UI object and corresponding UI object of at least one SQL file and UI object S110 corresponding with design document, user can be with Any one the UI object S120 for including in selection container UI.

If having selected UI object corresponding with the ERD file, the generation module 110 can be provided for editing The ERD Document Editing function S130 of the ERD file.

If having selected UI object corresponding with the SQL file, the generation module 110 can be provided for compiling Collect the SQL Document Editing function S140 of the SQL file.

If having selected UI object corresponding with the design document, the generation module 110 can be provided for compiling Collect the ERD Document Editing function S150 of the design document.

Meanwhile the generation module 110 can provide Integrated Development Environment, and user is created and is referred to customized user Fixed ERP function.Using the Integrated Development Environment of offer, user can create or edit the ERP function for driving user to specify ERD file, SQL file needed for energy, design document and report file.

User can generate the ERP function that multiple users specify by creating the module 110, and plurality of user is specified ERP function can be managed respectively as a corresponding project.Each project can be include at least one SQL file With the packet or container of design document.

Even if there is multiple projects, it is also possible to only one ERD file.In this case, it is generated by the multiple project The ERP function specified of multiple users a public ERD file can be used.

Hereinafter, it will be described in the side that user creates/edits the ERP function that user specifies by Integrated Development Environment Method.

Fig. 3 is the exemplary figure for showing the UI of the Integrated Development Environment provided by the generation module 110.

As shown in figure 3, the Integrated Development Environment UI1000 includes menu 1100, project Window 1200, database search Window 1300, editor window 1400, tool box window 1500, property window 1600 and script window 1700.

Menu 1100 may include multiple icons, and each icon can be the function being commonly used for executing user UI object, including creation new projects, open file, save file, duplication and stickup etc..

The project Window 1200 can be container UI, and the container UI includes UI object (example corresponding with ERD file Such as, icon), UI object corresponding at least one SQL file and UI object corresponding with design document.

Fig. 4 is the exemplary figure for showing project Window 1200.

As shown in figure 4, can show UI object 1211 corresponding with ERD file in the project Window 1200, when with Family selects when UI object 1211 corresponding with the ERD file (such as when click, double-click or touch the UI object etc.), the life The ERD Document Editing function for editing the ERD file can be provided at module 110.The generation module 110 can be in institute Display is stated in editor window 1400 for editing the UI of ERD file to provide ERD Document Editing function, and user can be ERD file is edited on the UI shown in editor window 1400.

UI object 1211 corresponding to the ERD file may be displayed on the lower rank of ERD container UI object 1210.With Family can be interacted with ERD container UI object 1210 in a predefined manner to generate new ERD file, and can will with it is newly created The corresponding UI object of ERD file is added to the lower rank of ERD container UI object 1210.At this point, newly created ERD file can To be blank (blank) file not comprising any information.

In the project Window 1200, UI object 1201,1202 corresponding at least one project can be shown With 1203, and each project can correspond to different user-defined ERP functions.

As described above, each project can be including at least one SQL file and design document, at least one report file Container, and the project Window 1200 can show belong to each project (such as 1202) respectively at least one SQL text The corresponding UI object 1221 and 1222 of part, corresponds respectively to the UI object 1231 of at least one report file, corresponds to design The UI object 1241 of file.

The UI object 1221 and 1222 for corresponding respectively at least one SQL file may be displayed on SQL container UI object 1220 lower rank.User can be interacted with SQL container UI object 1220 to generate new SQL file in a predefined manner, and And UI object corresponding with newly-generated SQL file can be added to the lower rank of SQL container UI object 1220.This When, newly created SQL file may be the empty file not comprising any information.

The UI object 1231 corresponded respectively at least one report file may be displayed on report container UI object 1230 Lower rank.User can interact in a predefined manner with report container UI object 1230 to generate new report file, and UI object corresponding with newly-generated report file can be added to the lower rank of report container UI object 1230.This When, newly created report file can be the empty file not comprising any information.

Meanwhile when user selects UI object (for example, 1221) corresponding with any one of at least one SQL file When, the generation module 110 can provide SQL Document Editing function to edit SQL corresponding with selected UI object 1221 File.The generation module 110 can be shown in the editor window 1400 for editing the UI of SQL file to provide SQL Document Editing function, and SQL file is edited on the UI that can show in editor window 1400 of user.

In addition, when user selects UI object (for example, 1231) corresponding with any one of at least one report file When, UI is edited in the report that the generation module 110 can provide for editing report electronic document.The generation module 110 can Shown in the editor window 1400 for editing the UI of report file to provide report file editting function, and use Report file is edited on the UI that family can be shown in the editor window 1400.

In addition, the generation module 110 can provide use when user's selection corresponds to the UI object 1241 of design document In the design document editting function of compilation and design file.The generation module 110 can be shown in the editor window 1400 Show the UI for compilation and design file to provide design document editting function, and user can show in editor window 1400 Compilation and design file on the UI shown.

Meanwhile user can interact in a predefined manner with the UI object (for example, 1202) for corresponding to specific project to generate New design document, and UI object corresponding with newly created design document is added to the UI object corresponding to the project 1202 lower rank.At this point, newly created design document can be the empty file not comprising any information.

Although the foregoing describe the generation modules 110 by including the editing machine window in Integrated Development Environment UI1000 Mouthfuls 1400 provide the example of each Document Editing functions, but according to different embodiments, the generation module 110 can execute with The corresponding single utility program of its each Document Editing function, in this case, user can edit in application program Each file.

Fig. 5 is the exemplary figure for showing database search window 1300.

As shown in figure 5, database search window 1300 may include and be connected to the user terminal 100 or the generation The corresponding UI object 1310 and 1320 of the DB130 of module 110.

The UI object (such as 1310) can have UI object (1311 to the 1313) conduct for showing at least one mode Its lower rank.Mode is as passing through lattice for the relationship between the structure of data, the method for data representation, data in the database The structure of formula language definition or a NameSpace can be the container comprising objects such as table, storing process.Therefore, make For the lower rank of the UI object of display AD HOC, it is each to may be embodied in table included in the mode or storing process etc. The corresponding UI object of object.

Table refers to the data acquisition system being made of the item for storing various data i.e. field, and database can be by Several table compositions.Preservation process or storing process (stored procedure) are to execute a series of inquiries as a function Inquiry set, the process about the sequence of operations on database is stored in data base management system, also referred to as Persistent stored modules (Persistent Storage Module).

In editor window 1400, editor UI corresponding with the type of file of user's selection can be shown.

Fig. 6 is the flow chart for schematically showing the process that the generation module 110 executes ERD Document Editing function.

With reference to Fig. 6, if user selects object corresponding with ERD file, the generation module 110 can be provided ERD Document Editing UI S131.In one embodiment, the generation module 110 can be shown in the editor window 1400 Show ERD Document Editing UI.At this point, the ERD Document Editing UI may include UI pair of table structure of the structure of display database table As the relationship UI object of the relationship between display table.

Then, the generation module 110 can be changed according to input of the user on ERD Document Editing UI table structure and Relationship S132 between table structure.When completing change, the relationship between the table structure and table of change be can reflect in ERD file Middle S133.

Hereinafter, reference Fig. 7 is more fully described to the process of Fig. 6.

The generation module 110 can based on the content of the corresponding ERD file of the ERD file object that is selected with user, ERD Document Editing UI2000 is provided by the editor window 1400.

Fig. 7 is the exemplary figure for showing ERD Document Editing UI2000.

As shown in fig. 7, ERD Document Editing UI2000 includes toolbar UI2100, the toolbar may include for creating Build the button, the button for creating new relation and the button for reflecting the change to DB130 of new table.ERD Document Editing UI2000 further includes between the table structure UI object (such as 2210,2220,2230) for the structure for showing database table and display table Relationship relationship UI object (for example, 2310,2320).

Table structure UI object 2210,2220 and 2230 can show corresponding column information included in table.

Relationship UI object 2310 and 2320 can be the form of the line of two table structure UI objects (2210 and 2220) of connection. Relationship UI object (for example, solid line or dotted line) can indicate that this relationship depended between two tables is to know in different forms Not relationship or non-identifying relationship.

The generation module 110 can change table structure and table knot according to input of the user on ERD Document Editing UI Relationship between structure.

User can create new table UI object on ERD Document Editing UI2000.

User can create UI object corresponding with the table created in DB130.For this purpose, user can choose UI object corresponding with the specific table shown in the database search window 1300, or in the ERD Document Editing The order such as drag and drop is inputted on UI2000, in response, the generation module 110 can be in the ERD Document Editing New table UI object corresponding with the table is created in UI2000.Alternatively, user can choose by the ERD Document Editing The new table that UI2000 is provided generates UI to create UI object corresponding with new table.

On the other hand, user can delete table UI object present on ERD Document Editing UI2000, or by corresponding The structure (for example, addition/deletion/change of column or attribute of change table) of table UI object list of modification.

User can also create new relationship UI object, to show table UI object present on ERD Document Editing UI2000 Between relationship.For example, user can choose by the ERD Document Editing UI2000 provide for create new relation by Button, then by selecting to need two tables being relative to each other to create the new relation UI for showing relationship between selected two tables Object.

On the other hand, user can delete relationship UI object present on the ERD Document Editing UI2000, or pass through Relationship UI object changes relation information.

After changing Database Modeling by the above process, for example, when user presses specified save button, it is described Generation module 110 can reflect the relationship between the table structure and table structure of change into the ERD file.

In addition, the generation module 110 can reflect the relationship between the table structure and table structure of change to relationship In DB130, table structure, the new table of addition or the existing table of deletion of DB130 are changed.

Fig. 8 is the flow chart for schematically showing the process that the generation module 110 executes SQL Document Editing function.

With reference to Fig. 8, if user selects object corresponding with SQL file, the generation module 110 can be provided SQL edits UI S141.In one embodiment, the generation module 110 can be shown in the editor window 1400 SQL edits UI.

Then, the generation module 110 can edit the input on UI in the SQL to change SQL query according to user S142.When completing change, the inquiry of change can reflect the S143 in SQL file.

Hereinafter, reference Fig. 9 is more fully described to the process of Fig. 8.

If user's selection corresponds to the object of SQL file, SQL text can be shown in the editor window 1400 Part editor UI3000.It is compiled that is, the generation module 110 can provide the SQL file by editor window 1400 UI3000 is collected, the SQL Document Editing UI shows the content of SQL file corresponding with the SQL file object of user's selection.

Fig. 9 is the exemplary figure for showing SQL Document Editing UI3000.

As shown in figure 9, the SQL Document Editing UI3000 includes toolbar UI3100, the toolbar UI includes being used for Select the UI for the DB to be connected, the button for executing the button connecting with DB, for releasing connection and for selecting The inquiry of creation is the UI for being inserted into (insert) or updating (update).

In addition, the SQL Document Editing UI3000 may include the editor UI3200 for creating inquiry, and user can To create or edit SQL query on editor UI3200.User can include parametric variable title when creating inquiry.For example, ginseng Number variable title can be the form of "@name variable ".The functional picture editor UI that name variable can be used for and be described below On control and inquiry link.Become for this purpose, at least part control for including in design document may map to the parameter Measure title.On the other hand, it when then executing the SQL query, can will be mapped on the control of the parametric variable title The data inputted are input to the SQL query.It is inputted more precisely, being mapped on the control of the parametric variable title Data can be assigned to the parametric variable title of the SQL query.

The toolbar UI3200 may include the button for executing created inquiry, and the SQL file is compiled Collecting UI3000 may include the UI3300 as the result is shown for showing its implementing result.On UI 3300 as the result is shown, Ke Yixian Show the structure of table and by inquiring searched data.

Meanwhile when changing SQL query by the above process, for example, when user presses specified save button, it is described Generation module 110 can reflect the SQL query of change in SQL file.

Figure 10 is the flow chart for schematically showing the process that the generation module 110 executes design document editting function.

With reference to Figure 10, when user selects object corresponding with design document, the generation module 110 can provide function It can picture editing UI S151.In one embodiment, the generation module 110 can be shown in the editor window 1400 Show functional picture editor UI.

Then, the generation module 110 can change use according to input of the user on the functional picture editor UI In the control for the picture for constituting the user-defined ERP function and the attribute S152 of each control.

Then, the generation module 110 can be by the control of the user-defined ERP functional picture of composition of change, change The attribute of each control and the control of change and inquiry between map information reflect into the design document S153.

Hereinafter, the process for Figure 10 being more fully described by referring to Fig.1 1 to Figure 14.

If user selects object corresponding with design document, it can show and set in the editor window 1400 Count Document Editing UI.That is, the generation module 110 can be based on corresponding with the design file objects that user selects Design document provides design document editor UI by the editor window 1400.

Figure 11 is the exemplary figure for showing design document editor UI4000.

The previous various control (examples defined in design document can be shown in the design document editor UI4000 Such as, 4010 to 4040).

User can delete the control shown in design document editor UI4000, change layout or modification shape element, example Such as size.

New control can also be added to design document editor UI4000 by user.For this purpose, the generation module 110 can mention For for selecting the tool box window 1500 of various controls.Figure 12 is the exemplary view for showing tool box window 1500.

As shown in figure 12, tool box window 1500 may include various types of controls, and user can pass through selection The mode that control is dragged and dropped into design document editor UI4000 is placed it into design document editor UI4000 by desired control In.

Meanwhile in the tool box window 1500, various controls can be classified as by spy according to scheduled classification standard Determine classification.For example, as shown in figure 12, the common controls 1510 that usually use in the gui, in the field ERP exclusively with industry Business control 1520, data control 1530,1550 and of layout control for constituting picture layout and the container as other controls Pop up control 1570 etc..

Particularly, the control (hereinafter, referred to " data control ") for belonging to data control class 1530 can execute display By the function for the data that SQL query searches.Data control have by SQL query search with data sheet form shown in flexibility The chart grid shown in pivot grid (Pivot Grid), diagrammatic form shown in grid (Flex Grid), pivot sheet form (Chart Grid).In addition, there are also various types of data controls.The data control 4040 of Figure 11 is that one of flexible mesh shows Example.

On the other hand, when user selects (such as click) to be placed on the control in design document editor UI4000 in a predefined manner When part, the attribute value of institute's selected control can be shown in property window 1600, user can change the institute in property window 1600 The attribute value of the control shown.Figure 13 is the exemplary figure for showing property window 1600.

In addition, when user selects (such as double-click) that the control in design document editor UI4000 is arranged in a predefined manner When, script window 1700 can show the method script for the movement that particular event need to execute, and user can create/edit foot The method script shown in this window 1700.Figure 14 is the exemplary figure for showing script window 1700.

As shown in figure 14, script window 1700 includes for selecting in the control arranged in design document editor UI4000 Any one UI1710, the UI1720 for selecting the event that can occur in control, in institute's selected control occur selected by For creating the UI1730 for the method script to be executed when event.

In addition, if by the above process, the control of the user-defined ERP functional picture, each control are constituted Attribute and/or method script change, for example, the generation module 110 will more when user presses specified save button Change in item reflection to the design document.

Meanwhile the generation module 110 can execute mapping processing, so that being shown on user-defined ERP functional picture The content shown is associated with SQL query.That is, the generation module 110, which provides SQL, maps UI, it is used for the design At least part (such as 4040) of the data control shown in Document Editing UI4000 is mapped at least one and is included in SQL text Ad hoc inquiry in part.And according to input of the user on SQL mapping UI, the control that will be shown in the control editor UI It includes the ad hoc inquiry in SQL file that at least part of part, which is mapped at least one,.Figure 15 a to 15e is to show SQL mapping The exemplary figure of UI.

Figure 15 a is the figure for showing current SQL mapping status.SQL shown in Figure 15 a maps UI5000 UI5010, the UI are shown in defined inquiry column at least one SQL file corresponding to user-defined ERP function Table.In the example of Figure 15 a, tentation data control can be mapped to the inquiry of entitled SQL.UI5000 is mapped by SQL, is used Input control (control that data can be received from user) can be mapped to parameter described in SQL query by family, and can be with The data control for being used to show the query result is mapped to SQL query.In addition, being shown when user changes on data controls When value or addition/deletion column, execution individually inquiry can be set, this will be described in greater detail below.

In fig. 15 a, it when selecting " the inquiry setting 5020 " of SQL query, can show shown in Figure 15 b UI5100.On UI5100 as illustrated in fig. 15b, user can be included within specific in the design document editor UI4000 Control (for example, 4010 and/or 4030) is mapped to including each parametric variable title in SQL statement.It is mapped to parameter change The control of amount title can be the control (input control) for executing the function that data are received from user.As illustrated in fig. 15b, described UI5100 may include list include each parametric variable title in SQL statement list 5110, can also include being used for Choose for user to parameters name variable control UI (for example, 5101 to 5103).

In the example of Figure 15 b, bpComboBox1 (4010) is mapped to@multiModule and textBoxExt1 (4030) it is mapped to@keyword.As described above, when include that particular control in design document editor UI 4000 is mapped to When parametric variable title in SQL query, inputted on the control that is mapped to parametric variable title when then executing SQL query Data can be input into SQL query.

When selection " control setting 5030 " in fig. 15 a, UI5200 shown in Figure 15 c can be shown.UI 5200 can Data control to include UI5210, for selecting to show on the design document editor UI4000.This allows user to select It is mapped to the data control (such as 4040) of SQL query.

UI5200 further includes the UI5220 for executing customization, such as to include in the DB table searched for by SQL query Column in select use/output column, adjustment display order, display format of each field of setting etc..

When selecting " the binding setting 5040 " in Figure 15 a, UI5300 shown in Figure 15 d can also be shown.Such as scheming On UI5300 shown in 15d, user, which can use including the particular control in the design document editor UI4000, to be mapped The column for including in the DB table to be searched for by SQL query.

In the case where selecting " saving setting 5050 " in Figure 15 a, UI 5400 shown in Figure 15 e can also be shown. UI5400 shown in Figure 15 e includes for selecting the SQL that the record being inserted by data control can be made to be inserted into database to look into The UI 5410 of inquiry, the UI5420 of the inquiry for selecting may be updated the data changed on data control, and for selecting to execute The UI5430 of the inquiry of deletion record.

Figure 16 is the flow chart for schematically showing above-mentioned mapping processing.

In one embodiment, the generation module 110 can be shown including in each of at least one SQL file SQL query S210.

When the shown SQL query of user's selection a period of time, it can analyze selected SQL query to obtain and be included in institute The parametric variable title S220 in SQL query is stated, and can show parametric variable title S230 obtained.

Then, according to the input of user, the generation module 110 can will be shown in the design document editor UI4000 Control (for example, 4010 or 4030) be mapped to the parameter name variable S240 of each display.

In addition, any data control that the generation module 110 can will be shown in the design document editor UI4000 (for example, 4040) are mapped to the SQL query (S240, S250) by user input selection.

Referring again to Fig. 1 b, the drive module 120 can drive generated by the generation module 110 it is user-defined ERP function, to provide a user user-defined ERP function.

As described above, at least one SQL corresponding with user-defined ERP function can be generated in the generation module 110 File and design document, and the drive module 120 can explain it to drive user-defined ERP function.Institute It states drive module 120 and can be and a kind of receive a kind of metadata or script and the engine for executing corresponding operating.

For example, the drive module 120 can be used about the information for including various controls in the design document It configures the picture of user-defined ERP function, and shows the picture.In addition, when specific command or data are input to by user When control, the drive module 120 can execute corresponding method, script or build-in function.The drive module 120 can be held The capable SQL query with the mapping of data control, and implementing result is reflected to data control or the DB130.In addition, the driving Module 120 can execute various instructions so that user-defined ERP function can be operated correctly.

The sharing module 140 can execute user-defined ERP sharing functionality, this will be described below.

Figure 17 be user terminal 100 is shown and shared system 200 share user-defined ERP function process it is exemplary Figure.Figure 17 shows the examples for sharing a user-defined ERP function between two terminals for ease of description, but need not Doubt, multiple user-defined ERP functions can also be shared between the plurality of terminals.

With reference to Figure 17, the process that user-defined ERP function is shared between two terminals 100-1 and 100-2 substantially may be used To be divided into source packet upload procedure (S310 to S340) and source packet downloading process (S350 to S370).

Firstly, illustrating source packet upload procedure, it is desirable to share sharer's terminal of user-defined ERP function with another person 100-1 can provide source and wrap biography UI (S310).Biography UI is wrapped in the source can provide selection function, be sent to institute with selection State the user-defined ERP function of shared system 200.Project corresponding to multiple user-defined ERP functions can store In sharer's terminal 100-1, and user can wrap biography UI selection by the source and wherein think project to be sharing.

The some or all of projects being stored in sharer's terminal 100-1 can be by described user-defined ERP generating process and it is pre-generated.Alternatively, some or all of projects being stored in sharer's terminal 100-1 can also Being downloaded on sharer's terminal 100-1 by the source packet download function being described later on.

Source packet can correspond to user-defined ERP function, and may include and the user-defined ERP function phase At least one corresponding SQL file and and design document.According to specific embodiment, the source packet can also include ERD file.

The source packet can also include the additional information about corresponding user-defined ERP function.Additional information can be with Including any information relevant to user-defined ERP function, such as title, the description information of user-defined ERP function (description), author, sharer and/or screenshot capture, classification information etc..

Figure 18 is that the exemplary figure for passing UI6000 is wrapped in the source that shows.

It may include the user-defined ERP being stored in sharer's terminal 100-1 that the source, which wraps and passes UI6000, The list 6100 of functional item.Each list includes for choosing whether the UI object (such as 6010) of upload, for display items The UI object (such as 6020) of mesh title (or title of user-defined ERP function), the UI for recording detailed description information Object (such as 6030), for selecting open whether UI object (such as 6040), the UI object (example for specifying screenshot capture Such as 6050).In addition, the source wrap pass UI can also include for input/specify may include source wrap in it is various attached Add the UI object of information.

User can choose some projects (Project1 and Project2 in the example of Figure 18) in seven projects, such as Shown in Figure 18.After selecting project to be sharing, user be can choose for executing described in the button 6200 uploaded and instruction Sharer's terminal 100-1 executes upload.

Referring again to Figure 17, the user-defined ERP function with user's selection is can be generated in sharer's terminal 100-1 S320 is wrapped in corresponding source, and source can be wrapped and be sent to shared system 200 (S330).

Then, received source can be wrapped and be stored in S340 in predetermined repository 210 by the shared system 200.

Meanwhile according to embodiment, the shared system 200 can be ranked up the source packet received according to specific criteria And storage.For this purpose, shared system 200 may determine that corresponding to received source packet user-defined ERP function belong to it is predefined Which of multiple classifications, and source packet is referred to classification belonging to corresponding user-defined ERP function And it stores them in the repository 210.Predefined multiple classifications may include common classification in the field ERP.Example Such as, these classifications may include accounting, occurrences in human life, sale, buying/material, outsourcing, trade, service, building, production, standard, at Sheet, acquisition accounting etc..

It can the classification as belonging to the ERP function that sharer designated user defines.

Alternatively, classification belonging to user-defined ERP function can be determined by the shared system 200.The shared system System 200 can analyze the design document for including at least one the SQL file or source packet for including in the source packet, so as to true Which classification is fixed user-defined ERP function belong to, based on analysis as a result, judgement corresponds to the user-defined of source packet ERP function belongs to which of multiple classifications.For example, the shared system 200 can analyze the SQL for including in the source packet The title or other information of database described in the inquiry of file, the title of table or field or other information, and/or parameter Title or other information etc..The shared system 200 can analyze various described in the design document for including in the source packet Information (for example, control title or attribute etc.).

Source packet downloading process is described below.If user terminal 100-2 accesses the shared system 200 or request provides column For table to download the various user-defined ERP functions of being shared by other people, the shared system 200 can will be stored in repository Source the package list in 210 is sent to the user terminal 100-2 (S350).

Then, the user terminal 200 can provide source packet downloading UI (S360).The source packet downloading UI can show institute The list of received source packet, and can provide selection at least some projects of received source the package list function.

Figure 19 is the exemplary figure for showing source packet downloading UI7000.With reference to Figure 19, the source packet downloading UI7000 be can wrap List UI7100 is included, to show the list wrapped from the received source of the shared system 200.Each project of the list UI7100 It may include title, the information such as corresponding title, representative icon, the registration date of user-defined ERP function of source packet. In addition, the source packet downloading UI7000 can also include that details show UI7200, to show source packet selected by user Details.The details show that UI7200 may include wrapping corresponding user-defined ERP function with corresponding source The title for the application program (for example, described drive module 120) being applicable in, the title of registrant, user corresponding thereto are fixed Title, the detailed description of ERP function etc. of justice.In addition, the details show that UI7200 can show user-defined ERP The screenshot capture 7210 of function.Screenshot capture can be the image that the sharer of shared source packet specifies.

Or screenshot capture 7210 can be the image generated by the shared system 200.For example, the shared system 200 can execute the function of above-mentioned drive module 200.Using include source wrap in SQL file and design document execute use After the ERP function that family defines, take pictures.

Meanwhile the source packet downloading UI7000 can also include classification UI7300, for showing user-defined ERP function The list of categories that may belong to.When user selects any one classification for including in classification UI7300, list UI7100 can be with It only shows and belongs to selected classification, the corresponding source the package list of user-defined ERP function.

The source packet downloading UI 7000 can also include upload button 7400.When selecting upload button 7400, the use Family terminal 100-2 provides the source and wraps biography UI6000, the ERP for allowing user terminal 100-2 and other people shared users to specify Function.

In addition, the source packet downloading UI can also include for requesting to download the button UI wrapped in source selected by user 7410.As user select button UI7410, user terminal 100-2 can request loading source packet to the shared system 200.

Referring again to Figure 17, the downloading in response to the user terminal 100-2 is requested, and the shared system 200 is from storage The target source packet by the user terminal selecting is sent to the user terminal 100-2 (S370) in the source packet stored in library 210.

Meanwhile according to embodiment, the user-defined ERP function shared system may include at least one processor and For storing the memory of the program executed by the processor.The processor may include monokaryon CPU or multi-core CPU.Institute Stating memory may include high-speed random access memory, and may include nonvolatile memory, such as one or more Disk storage equipment, flash memory device or other non-volatile solid-state memory devices etc..Storage control can control processor and Access of the other assemblies to memory.Here, when said program is executed by a processor, described program can make according to this implementation The user-defined ERP function shared system of example executes the user-defined ERP function sharing method.

Meanwhile user-defined ERP function sharing method according to an embodiment of the present invention can be with computer-readable program The form of instruction is realized and is stored in computer readable recording medium.Computer readable recording medium includes that can store by calculating The various recording devices for the data that machine system is read.

The program instruction that the program instruction of record on the recording medium can be as special design and construction of the invention, or Can be software field technical staff is known and available program instruction.

The example of computer readable recording medium includes the magnetic medium (magnetic of such as hard disk, floppy disk and tape Media), optical medium (optical media), the light of such as CD-ROM (CD-ROM) and Digital video disc (DVD) The magnet-optical mediums such as disk (floptical disk) (magneto-optical media) and read-only memory (ROM), random storage Device (RAM), flash memory etc. store and execute program instruction and the hardware device that is especially arranged.

Computer readable recording medium can also be distributed in the computer system of networking, so that computer-readable code can To store and execute in a distributed fashion.

The example of program instruction not only includes the machine language code such as generated by compiler, further includes by using solution It releases device etc. and electronically handles the higher-level language code that the equipment such as computer of information executes.

The hardware device, which can be configured as, to be operated as one or more software modules to execute operation of the invention, Vice versa.

It will be understood by those skilled in the art that foregoing description of the invention is merely to illustrate, and ordinary skill people Member is it can be readily appreciated that can carry out various changes in the case where not departing from technical idea or essential characteristic of the invention And modification.It will be understood, therefore, that above-described embodiment is all exemplary and not limiting in all respects.For example, can disperse It realizes each component for being described as single type, and can also realize the component for being described as dispersion in combination.

The scope of the present invention depends on following entitlement requests range rather than above-mentioned detailed description, entitlement requests range The form of all changes derived from meaning and range and its impartial concept and deformation should be understood the model for being included in invention In enclosing.

Industry utilizes possibility

The present invention can be used in the sharing method and system of user-defined ERP function.

Claims

1. a kind of shared side of user-defined ERP (Enterprise Resource Planning) function (function) Method, comprising:

It includes at least one SQL file and design text that user-defined ERP function shared system is received from multiple sharer's terminals Part, corresponding to scheduled ERP user's defined function source packet the step of-wherein the SQL file be storage for operand According to the file that the structured query language (SQL:Structured Query Language) in library is inquired, the design document is Storage constitutes the file of at least one control property information of the user-defined ERP functional picture, wherein constituting the use It is to be mapped to including specific at least one SQL file at least partially in the control of the picture for the ERP function that family defines The control-of inquiry；

The user-defined ERP function shared system will be stored in scheduled storage from the received source packet of multiple sharer's terminals Step in library；

The source the package list being stored in the repository is supplied to user terminal by the user-defined ERP function shared system The step of；And

In response to the request of the user terminal, by the user terminal selecting in the packet of the source being stored in the repository The step of target source packet is sent to the user terminal.

2. the sharing method of the user-defined ERP function according to claim 1, which is characterized in that

The user-defined ERP function shared system will be stored from the received source packet of the multiple sharer's terminal to scheduled The step of repository, comprising:

The user-defined ERP function that judgement corresponds to source packet belongs to the step of which of predefined multiple classifications Suddenly；With

Source packet is referred to classification belonging to corresponding user-defined ERP function and is stored into the repository The step of.

3. the sharing method of the user-defined ERP function according to claim 2, which is characterized in that

The user-defined ERP function that judgement corresponds to source packet belongs to the step of which of predefined multiple classifications Suddenly, comprising:

The step of analyzing the design document for including at least one the SQL file or source packet for including in the source packet；With

Corresponding user-defined ERP function, which is wrapped, with the source based on analysis result judgement belongs to which of multiple classifications Step.

4. the sharing method of the user-defined ERP function according to claim 1, which is characterized in that

The user terminal executes source and wraps transmission method and source packet method for down loading,

Wherein the source wraps transmission method and includes:

Offer source is wrapped the step of passing UI, and the source, which is wrapped, passes UI offer from least one source being stored in the user terminal The function of at least some projects is selected in the list of packet；With

It wraps to pass UI and send the source packet for corresponding to selected item to the user-defined ERP function and share by the source and is The step of system,

Wherein the source packet method for down loading includes:

The step of receiving the source the package list being stored in the repository from the user-defined ERP function shared system；

The step of offer source packet downloading UI, the source packet downloading UI, which is provided, selects at least some items from the received source the package list of institute Purpose function；With

Downloading UI is wrapped by the source to wrap from the source that the user-defined ERP function shared system reception corresponds to selected item The step of.

5. the sharing method of the user-defined ERP function according to claim 1, which is characterized in that

The user terminal receives the target source packet from the user-defined ERP function shared system, then execution and institute The corresponding user-defined ERP function generation method of target source packet is stated,

The generation method of user-defined ERP function corresponding with the target source packet, comprising:

There is provided container UI the step of, the container UI include UI object corresponding with ERD file, be included in the target source packet In the corresponding UI object of each of at least one SQL file and with include design text in the target source packet The corresponding UI object of part, wherein the ERD file be for store modeling information be stored in DB130 about table Attribute and file about the modeling information of relationship between table；

When selecting UI object corresponding with the ERD file, the ERD Document Editing for editing the ERD file is provided The step of function；

When selection is with a corresponding UI object at least one SQL file, provide for editing and selected UI object The step of SQL Document Editing function of corresponding SQL file；

When selecting UI object corresponding with the design document, the design document for editing the design document is provided and is compiled The step of collecting function；With

Based on SQL file described at least one and the design document, the step of user-defined ERP function is provided.

6. a kind of computer program, is mounted in data processing equipment, and stores in the recording medium, for perform claim requirement Documented method in any one in 1 to 5.

7. a kind of user-defined ERP function shared system, which is characterized in that

As user-defined ERP function shared system,

Including at least one processor；

For storing the memory of the computer program executed by the processor,

Wherein, when the computer program is executed by processor, so that the user-defined ERP function shared system executes use The ERP function sharing method that family defines,

Wherein, the user-defined ERP function sharing method includes:

The user-defined ERP function shared system is received including at least one SQL file and is set from multiple sharer's terminals Meter file, corresponding to scheduled ERP user's defined function source packet the step of-wherein the SQL file be storage for grasping Make the file of the SQL query of database, the design document is that storage constitutes the user-defined ERP functional picture at least The file of one control property information, wherein constituting at least part in the control of the picture of the user-defined ERP function It is to be mapped to the control-including the ad hoc inquiry at least one SQL file；

8. the shared system of the user-defined ERP function according to claim 7, which is characterized in that

9. the shared system of the user-defined ERP function according to claim 8, which is characterized in that

10. the shared system of the user-defined ERP function according to claim 7, which is characterized in that

Wherein the source wraps transmission method and includes:

Wherein the source packet method for down loading includes:

11. the shared system of the user-defined ERP function according to claim 7, which is characterized in that

The user terminal receives the target source packet from the user-defined ERP function shared system, then execution and institute The generation method of the corresponding user-defined ERP function of target source packet is stated,