CN101582140A - Method for acquiring data, device and server - Google Patents

Method for acquiring data, device and server Download PDF

Info

Publication number
CN101582140A
CN101582140A CNA200910146741XA CN200910146741A CN101582140A CN 101582140 A CN101582140 A CN 101582140A CN A200910146741X A CNA200910146741X A CN A200910146741XA CN 200910146741 A CN200910146741 A CN 200910146741A CN 101582140 A CN101582140 A CN 101582140A
Authority
CN
China
Prior art keywords
data table
operational data
current department
corresponding relation
unit
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.)
Pending
Application number
CNA200910146741XA
Other languages
Chinese (zh)
Inventor
张波
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Kingdee Software China Co Ltd
Original Assignee
Kingdee Software China Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Kingdee Software China Co Ltd filed Critical Kingdee Software China Co Ltd
Priority to CNA200910146741XA priority Critical patent/CN101582140A/en
Publication of CN101582140A publication Critical patent/CN101582140A/en
Pending legal-status Critical Current

Links

Images

Abstract

The invention discloses a method for acquiring data, a device and a server. The method comprises the steps of: establishing corresponding relationship between each department and an operational data sheet required by each department; acquiring the operational data sheet required by the current department according to the characteristic information of the current department and the corresponding relationship; and carrying out MRP operation according to the acquired operational data sheet. The invention saves resource of the group.

Description

A kind of method, device and server that obtains data
Technical field
The present invention relates to the MRP technical field, relate in particular to a kind of method, device and server that obtains data.
Background technology
MRP (MRP, Material Requirement Planning) is a kind of establishment production and the system that carries out control based on computing machine.It is not only a kind of new plan management method, and is a kind of new mode of production of organizing.The main target of MRP system is the inventory level of control enterprise, determines the production priority of product, satisfies the requirement at delivery date, makes the efficient of production run reach the highest.
The MRP system is according to the final product dilivery date of stipulating in total scheduling of production, and regulation must be finished the time of every operation, works out the scheduling of production of all lower level parts.Scheduling of production comprises: the buying hour of various parts and quantity, production division should carry out the T/A of processing.In case operation can not be finished according to plan, the MRP system can be adjusted the T/A of buying and manufacturing schedule, and the priority of every operation is tallied with the actual situation.
The inventor is in research process, find that existing MRP system comprises following shortcoming at least:, need be respectively each department independently MRP system is set if group company comprises a plurality of departments (these departments for example: a plurality of factories, subsidiary company or stock department).But at a group internal, the MRP system of each department needs to use common data inevitably, and therefore, the MRP system has greatly wasted resource for each department is provided with independently respectively.
Summary of the invention
In view of this, the embodiment of the invention provides a kind of method, device and server that obtains data, is used to all departments that unified MRP system is set.
A kind of method of obtaining data, described method are applied to MRP MRP system, and described method comprises:
Set up the corresponding relation of the required operational data table of all departments and described all departments;
According to the characteristic information and the described corresponding relation of current department, obtain the required operational data table of described current department;
Carry out the MRP operation according to the operational data table that obtains.
Alternatively, described obtain the required operational data table of described current department before, described method also comprises:
According to the characteristic information of current department, search described corresponding relation;
Judge whether to find the required operational data table of described current department, if continue to carry out subsequent step.
Alternatively, described method also comprises:
If do not find the required operational data table of described current department, create the required operational data table of described current department, and in described corresponding relation, insert the operational data table of establishment and the corresponding relation of described current department, continue to carry out subsequent step.
Preferably, the characteristic information of described current department comprises the arrangement sequence number of current department.
A kind of device that obtains data, described device runs in the server, is applied to the MRP system, and described device comprises:
Set up the unit, be used to set up the corresponding relation of the required operational data table of all departments and described all departments;
Acquiring unit is used for characteristic information and the described corresponding relation of setting up unit foundation according to current department, obtains the required operational data table of described current department;
Performance element, the operational data table that is used for obtaining according to described acquiring unit is carried out the MRP operation.
Alternatively, described device also comprises:
Search the unit, be used for characteristic information, search described corresponding relation according to current department;
Judging unit is used to judge whether the described unit of searching finds the required operational data table of described current department;
Described acquiring unit is used for after described judgment unit judges goes out to find the required operational data table of described current department, characteristic information and the described corresponding relation of setting up unit foundation according to current department obtain the required operational data table of described current department.
Alternatively, described device also comprises:
Creating unit is used for creating the required operational data table of described current department if described judgment unit judges goes out not find the required operational data table of described current department;
Insert the unit, be used for inserting the operational data table of described creating unit establishment and the corresponding relation of described current department at the described corresponding relation of setting up the unit of setting up;
Described acquiring unit is used for after described insertion unit executes operation, and characteristic information and the described corresponding relation of setting up unit foundation according to current department obtain the required operational data table of described current department.
A kind of server, described server has moved the MRP system, and described server is used to set up the corresponding relation of the required operational data table of all departments and described all departments; According to the characteristic information and the described corresponding relation of current department, obtain the required operational data table of described current department; Carry out the MRP operation according to the operational data table that obtains.
As can be seen, the embodiment of the invention has been set up the corresponding relation of the required operational data table of all departments and all departments in advance, when current department need carry out the MRP operation, according to the characteristic information of current department and the corresponding relation of setting up in advance, obtain the required operational data table of current department, carry out the MRP operation according to the operational data table that obtains.By the embodiment of the invention, the MRP system that all departments use no longer is separate, and all departments can sharing data resources, and the operation of MRP each other do not disturb mutually, has greatly saved resource.
Description of drawings
Fig. 1 is the embodiment of the invention one method flow diagram;
Fig. 2 is the embodiment of the invention two method flow diagrams;
Fig. 3 is the embodiment of the invention three apparatus structure block diagrams;
Fig. 4 is the embodiment of the invention four apparatus structure block diagrams.
Embodiment
For above-mentioned feature of the present invention, advantage are become apparent more, be elaborated below in conjunction with embodiment and accompanying drawing.
The invention provides a kind of MRP system that runs on public servicer, when any department need use the MRP system, the login public servicer can be operated.
Please refer to Fig. 1, be the embodiment of the invention one method flow diagram, can may further comprise the steps:
Step 101: the corresponding relation of setting up the required operational data table of all departments and described all departments;
Step 102:, obtain the required operational data table of described current department according to the characteristic information and the described corresponding relation of current department;
Step 103: carry out the MRP operation according to the operational data table that obtains.
As can be seen, the embodiment of the invention has been set up the corresponding relation of the required operational data table of all departments and all departments in advance, when current department need carry out the MRP operation, according to the characteristic information of current department and the corresponding relation of setting up in advance, obtain the required operational data table of current department, carry out the MRP operation according to the operational data table that obtains.By the embodiment of the invention, the MRP system that all departments use no longer is separate, and all departments can sharing data resources, and the operation of MRP each other do not disturb mutually, has greatly saved resource.
Below in conjunction with one more specific embodiment the present invention will be described.
Please refer to Fig. 2, be the embodiment of the invention two method flow diagrams, can may further comprise the steps:
Step 201: public servicer is set up the corresponding relation of the required operational data table of all departments and all departments according to the match information that gets access to;
Public servicer counts all required operational data tables of all departments in the group in advance, and each department needs an operational data table at least.
Step 202: the staff of current department signs in to public servicer, submits the characteristic information of affiliated function to;
The characteristic information of all departments is used for public servicer to be discerned all departments, can sort to all departments, with the sequence number of all departments as characteristic information.
Step 203: public servicer is searched the corresponding relation of setting up in advance according to the characteristic information of submitting to;
Step 204: judge whether to find the required operational data table of current department, if find the required operational data table of current department, enter step 205, otherwise, create the required operational data table of current department, and in the corresponding relation of setting up in advance, insert the operational data table of establishment and the corresponding relation of current department, use in order to next, and enter step 205;
Step 205: public servicer obtains the required operational data table of current department;
Step 206: public servicer is according to the operational data table that obtains, and the current staff's of department instruction, carries out the MRP operation.
More than the embodiment of the invention two is illustrated, for the ease of understanding, introduce an instantiation below.
Suppose that a group comprises three departments, the numbering of all departments is respectively A001, A002 and B001.Public servicer has been set up the corresponding relation of the required operational data table of the A002 of department, the B001 of department and these two departments, sees also shown in the table 1:
Table 1
Figure A20091014674100081
The staff of the A001 of department signs in to public servicer, carries out the MRP operation in advance.This staff has submitted the numbering A001 of department to according to the information of public servicer.Public servicer is searched the operation relation table according to the numbering A001 of department.Through searching, do not find the required operational data table of the A001 of department, then create the required operational data table of the A001 of department, please refer to shown in the table 2:
Table 2
Figure A20091014674100082
Operational data table that public servicer is required with the A001 of department that creates and the corresponding relation of the A001 of department insert in the operation relation table, in order to using next time, see also shown in the table 3:
Table 3
Figure A20091014674100091
Public servicer obtains the required operational data table of the A001 of department, carries out the MRP operation according to this staff's instruction.
As can be seen, owing to set up the corresponding relation of the required operational data table of all departments and all departments in advance, when current department need carry out the MRP operation, public servicer is according to the characteristic information of current department and the corresponding relation of setting up in advance, obtain the required operational data table of current department, carry out the MRP operation according to the operational data table that obtains.By the embodiment of the invention, the MRP system that all departments use no longer is separate, and all departments can sharing data resources, and the operation of MRP each other do not disturb mutually, has greatly saved resource.
Please refer to Fig. 3, be the embodiment of the invention three apparatus structure block diagrams, can comprise:
Set up unit 301, be used to set up the corresponding relation of the required operational data table of all departments and described all departments;
Acquiring unit 302 is used for characteristic information and the described corresponding relation of setting up unit 301 foundation according to current department, obtains the required operational data table of described current department;
Performance element 303, the operational data table that is used for obtaining according to described acquiring unit 302 is carried out the MRP operation.
As can be seen, the embodiment of the invention has been set up the corresponding relation of the required operational data table of all departments and all departments in advance, when current department need carry out the MRP operation, according to the characteristic information of current department and the corresponding relation of setting up in advance, obtain the required operational data table of current department, carry out the MRP operation according to the operational data table that obtains.By the embodiment of the invention, the MRP system that all departments use no longer is separate, and all departments can sharing data resources, and the operation of MRP each other do not disturb mutually, has greatly saved resource.
Please refer to Fig. 4, be the embodiment of the invention four apparatus structure block diagrams, can comprise:
Set up unit 401, be used to set up the corresponding relation of the required operational data table of all departments and described all departments;
Search unit 402, be used for characteristic information, search described corresponding relation according to current department;
Judging unit 403 is used to judge whether the described unit 402 of searching finds the required operational data table of described current department;
Creating unit 404 is used for creating the required operational data table of described current department if described judging unit 403 is judged and do not found the required operational data table of described current department;
Insert unit 405, be used for inserting the operational data table of described creating unit establishment and the corresponding relation of described current department at the described corresponding relation of setting up unit 401 of setting up;
Acquiring unit 406 is used for after described insertion unit 405 executes operation, and characteristic information and the described corresponding relation of setting up unit 401 foundation according to current department obtain the required operational data table of described current department;
Performance element 407, the operational data table that is used for obtaining according to described acquiring unit 406 is carried out the MRP operation.
Wherein, described creating unit 404 and insertion unit 405 are option, when described judging unit 403 judge find the required operational data table of described current department after, described acquiring unit 406 obtains the required operational data table of described current department according to the characteristic information and the described corresponding relation of setting up unit 401 foundation of current department.
The embodiment of the invention also provides a kind of server, and described server has moved the MRP system, and described server is used to set up the corresponding relation of the required operational data table of all departments and described all departments; According to the characteristic information and the described corresponding relation of current department, obtain the required operational data table of described current department; Carry out the MRP operation according to the operational data table that obtains.
At last, also need to prove, in this article, relational terms such as first and second grades only is used for an entity or operation are made a distinction with another entity or operation, and not necessarily requires or hint and have the relation of any this reality or in proper order between these entities or the operation.And, term " comprises ", " comprising " or its any other variant are intended to contain comprising of nonexcludability, thereby make and comprise that process, method, article or the equipment of a series of key elements not only comprise those key elements, but also comprise other key elements of clearly not listing, or also be included as this process, method, article or equipment intrinsic key element.Do not having under the situation of more restrictions, the key element that limits by statement " comprising ... ", and be not precluded within process, method, article or the equipment that comprises described key element and also have other identical element.
Through the above description of the embodiments, those skilled in the art can be well understood to the present invention and can realize by the mode that software adds essential hardware platform, can certainly all implement, but the former is better embodiment under a lot of situation by hardware.Based on such understanding, all or part of can the embodying that technical scheme of the present invention contributes to background technology with the form of software product, this computer software product can be stored in the storage medium, as ROM/RAM, magnetic disc, CD etc., comprise that some instructions are with so that a computer equipment (can be a personal computer, server, the perhaps network equipment etc.) carry out the described method of some part of each embodiment of the present invention or embodiment.
More than the present invention is described in detail, used specific case herein principle of the present invention and embodiment set forth, the explanation of above embodiment just is used for help understanding method of the present invention and core concept thereof; Simultaneously, for one of ordinary skill in the art, according to thought of the present invention, the part that all can change in specific embodiments and applications, in sum, this description should not be construed as limitation of the present invention.

Claims (8)

1, a kind of method of obtaining data is characterized in that, described method is applied to MRP MRP system, and described method comprises:
Set up the corresponding relation of the required operational data table of all departments and described all departments;
According to the characteristic information and the described corresponding relation of current department, obtain the required operational data table of described current department;
Carry out the MRP operation according to the operational data table that obtains.
2, method according to claim 1 is characterized in that, described obtain the required operational data table of described current department before, described method also comprises:
According to the characteristic information of current department, search described corresponding relation;
Judge whether to find the required operational data table of described current department, if continue to carry out subsequent step.
3, method according to claim 2 is characterized in that, described method also comprises:
If do not find the required operational data table of described current department, create the required operational data table of described current department, and in described corresponding relation, insert the operational data table of establishment and the corresponding relation of described current department, continue to carry out subsequent step.
4, according to any described method of claim 1 to 3, it is characterized in that the characteristic information of described current department comprises the arrangement sequence number of current department.
5, a kind of device that obtains data is characterized in that, described device runs in the server, is applied to the MRP system, and described device comprises:
Set up the unit, be used to set up the corresponding relation of the required operational data table of all departments and described all departments;
Acquiring unit is used for characteristic information and the described corresponding relation of setting up unit foundation according to current department, obtains the required operational data table of described current department;
Performance element, the operational data table that is used for obtaining according to described acquiring unit is carried out the MRP operation.
6, device according to claim 5 is characterized in that, described device also comprises:
Search the unit, be used for characteristic information, search described corresponding relation according to current department;
Judging unit is used to judge whether the described unit of searching finds the required operational data table of described current department;
Described acquiring unit is used for after described judgment unit judges goes out to find the required operational data table of described current department, characteristic information and the described corresponding relation of setting up unit foundation according to current department obtain the required operational data table of described current department.
7, device according to claim 6 is characterized in that, described device also comprises:
Creating unit is used for creating the required operational data table of described current department if described judgment unit judges goes out not find the required operational data table of described current department;
Insert the unit, be used for inserting the operational data table of described creating unit establishment and the corresponding relation of described current department at the described corresponding relation of setting up the unit of setting up;
Described acquiring unit is used for after described insertion unit executes operation, and characteristic information and the described corresponding relation of setting up unit foundation according to current department obtain the required operational data table of described current department.
8, a kind of server is characterized in that, described server has moved the MRP system, and described server is used to set up the corresponding relation of the required operational data table of all departments and described all departments; According to the characteristic information and the described corresponding relation of current department, obtain the required operational data table of described current department; Carry out the MRP operation according to the operational data table that obtains.
CNA200910146741XA 2009-06-22 2009-06-22 Method for acquiring data, device and server Pending CN101582140A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CNA200910146741XA CN101582140A (en) 2009-06-22 2009-06-22 Method for acquiring data, device and server

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CNA200910146741XA CN101582140A (en) 2009-06-22 2009-06-22 Method for acquiring data, device and server

Publications (1)

Publication Number Publication Date
CN101582140A true CN101582140A (en) 2009-11-18

Family

ID=41364276

Family Applications (1)

Application Number Title Priority Date Filing Date
CNA200910146741XA Pending CN101582140A (en) 2009-06-22 2009-06-22 Method for acquiring data, device and server

Country Status (1)

Country Link
CN (1) CN101582140A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109857759A (en) * 2018-11-06 2019-06-07 金蝶软件(中国)有限公司 Processing method, device, computer equipment and the storage medium of concurrent data

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109857759A (en) * 2018-11-06 2019-06-07 金蝶软件(中国)有限公司 Processing method, device, computer equipment and the storage medium of concurrent data
CN109857759B (en) * 2018-11-06 2021-06-15 金蝶软件(中国)有限公司 Concurrent data processing method and device, computer equipment and storage medium

Similar Documents

Publication Publication Date Title
US10698891B2 (en) MxN dispatching in large scale distributed system
CN111459985B (en) Identification information processing method and device
CN102446303B (en) Distribution method and device of process route assembly
CN102270225A (en) Data change log monitoring method and device
CA2493269A1 (en) Method and system of unifying data
CN109815254B (en) Cross-region task scheduling method and system based on big data
CN1303061A (en) System and method of sequencing and classifying attributes for better visible of multidimentional data
CN107291745B (en) Data index management method and device
CN104216893A (en) Partitioned management method for multi-tenant shared data table, server and system
CN105812175B (en) Resource management method and resource management equipment
CN105096174A (en) Transaction matching method and transaction matching system
CN110399368A (en) A kind of data manipulation method and device
CN104871153A (en) System and method for flexible distributed massively parallel processing (mpp) database
CN110427775A (en) Data query authority control method and device
CN102158533B (en) Distributed web service selection method based on QoS (Quality of Service)
CN104794130B (en) Relation query method and device between a kind of table
CN104462429A (en) Method and device for generating database query sentences
CN109409848A (en) Node intelligent recommended method, terminal device and the storage medium of open process
CN112860744A (en) Business process processing method and device
CN107066522B (en) Database access method and device
CN102722560A (en) Automatic identification method and system on basis of master data in telecom industry
CN110134511A (en) A kind of shared storage optimization method of OpenTSDB
CN110378033B (en) Nonstandard design method and device for physical part, storage medium and computer equipment
CN101582140A (en) Method for acquiring data, device and server
CN103064862B (en) A kind of multi objective sorting data disposal route and equipment

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C12 Rejection of a patent application after its publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20091118