CN107577749A - A kind of management method of supplier - Google Patents
A kind of management method of supplier Download PDFInfo
- Publication number
- CN107577749A CN107577749A CN201710760385.5A CN201710760385A CN107577749A CN 107577749 A CN107577749 A CN 107577749A CN 201710760385 A CN201710760385 A CN 201710760385A CN 107577749 A CN107577749 A CN 107577749A
- Authority
- CN
- China
- Prior art keywords
- company
- client
- central database
- information
- data
- 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
Links
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of management method of supplier, including two databases and two clients, database includes central database and local data base, client includes company's selection client and register of company's client, and the Business Name to be added in client-side search central database is selected using company；Judge whether to search the Business Name for needing to add, if searching the company of needs in central database, select supplier of the company as current enterprise, and by the data write-in local data base of company information；If not searching the company of needs in central database, operation interface is gone to register of company's client by company's selection client, and the information of company, the data deposit central database of company information are inputted in register of company's client.Company information typing of the present invention is once, simple to operate, saves the time, improves efficiency, and the data of company's essential information unify storage and are easy to safeguard, the uniformity of data can be achieved.
Description
Technical field
The present invention relates to manufacturing technical field, and in particular to a kind of management method to manufacturing supplier.
Background technology
The traditional procurement method of enterprise is emphasized to increase income, and the access of supplier is more relaxed, and enterprise expectations are more by introducing
Supplier evade supply risk, to cause the strong competition between supplier, reduce cost.This mode is due to Supplier Number
Numerous, the energy of buying/supplier management personnel is limited, it is difficult to the supplier management to be become more meticulous.
Many business management softwares on the market be present now, be no lack of the management to supplier or client and rest on unit system
Unite on level, fight separately, the consideration of no systematization and have that data inputting is complicated, repeats situations such as typing.
The content of the invention
For the technical problem that existing supplier management method is inconvenient for operation, data inputting is inconvenient, the present invention provides
A kind of management method of supplier, the shared of information is realized by central database, reduces the typing of data, it is easy to operate to have
Effect.
In order to solve the above-mentioned technical problem, the technical scheme is that：
A kind of management method of supplier, including two databases and two clients, database include central database and this
Ground database, client includes company's selection client and register of company's client, its step are as follows：
Step 1：The Business Name to be added in client-side search central database is selected using company；
Step 2：Judge whether to search the Business Name for needing to add, if searching the public affairs of needs in central database
Department, into step 3；If not searching the company of needs in central database, into step 4；
Step 3：Supplier of the selection company as current enterprise, and by the data write-in local data base of company information；
Step 4：Operation interface is gone to register of company's client by company's selection client；
Step 5：The information of company, the data deposit central database of company information are inputted in register of company's client；
Step 6：Company incorporated's information transmission is successful to central database, then return to step one；Otherwise return to step five.
The data of the company information are stored in central database according to the form of tables of data, and central database is
MySql, Microsoft SQL Server or Oracle relevant databases.
The method of company selection client-side search central database is：Company's selection client is arrived by SQL statement
Matched on central database by Business Name, matching includes fuzzy matching and accurate matching；Fuzzy matching is company's selection
Business Name is splitted into single word by client, is then scanned for using SQL search statements in central database；Accurate matching
Searched for using Business Name and SQL search statements in central database；Company selection visitor is shown to if data are inquired
In List forms on the end of family.
Beneficial effects of the present invention：Only in registration, typing is all to click to repeat to record later once to company information
Enter, it is simple to operate, the time is saved, improves efficiency.Supplier's master data only has portion, change company essential information it
It is the uniformity that data can be achieved not need data syn-chronization afterwards.The data of company's essential information unify storage and are easy to safeguard.To supplying
Evaluation mechanism can be formed by answering business's mass/duration/managing after sale, determine whether supplier is qualified according to evaluation.
Brief description of the drawings
In order to illustrate more clearly about the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
There is the required accompanying drawing used in technology description to be briefly described, it should be apparent that, drawings in the following description are only this
Some embodiments of invention, for those of ordinary skill in the art, on the premise of not paying creative work, can be with
Other accompanying drawings are obtained according to these accompanying drawings.
Fig. 1 is the flow chart of the present invention.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is carried out clear, complete
Site preparation describes, it is clear that described embodiment is only part of the embodiment of the present invention, rather than whole embodiments.It is based on
Embodiment in the present invention, those of ordinary skill in the art are obtained every other under the premise of creative work is not paid
Embodiment, belong to the scope of protection of the invention.
A kind of management method of supplier, including two databases and two clients, database include central database
And local data base, client include company's selection client and register of company's client, it is possible to achieve data are in centre data
Data addition and use between storehouse and Duo Tai local data bases.Select to inquire about Business Name in client in company, if do not had
Company is inquired, then starts register of company's client and new company is registered, visitor is selected by company again after registration
Elect the supplier of current enterprise as in family end.The master data of company is saved on central database, local data base, which saves, works as
The supplier data of preceding enterprise, supplier data are the company ID chosen from centre data.Company's selection client provides
One visualization interface, there is search box, search button and search result to show form.Register of company's client also provides one
Individual visualization interface, there is the function of filling in company's essential information.
As shown in figure 1, being first turned on the visualization interface of company's selection client, the work to be added is inserted in search box
For the Business Name of supplier, click on " it is determined that " search button, now can be to search company's information on central database, if knot
Company is not directly added to home provider database by fruit for sky；If result is sky, start register of company's client registers
Company's master data is to central database, if succeeded in registration, return to company choose client-side search Business Name, repeat more than
Step is until addition supplier success.Its step is as follows：
Step 1：The Business Name to be added in client-side search central database is selected using company.
Central database is connected and accesses using the database access interface of official's offer.The data of company information according to
The form of tables of data is stored in central database, central database MySql, Microsoft SQL Server or Oracle
Relevant database.Company selection client-side search central database method be：Company's selection client is arrived by SQL statement
Matched on central database by Business Name, matching includes fuzzy matching and accurate matching；Fuzzy matching is company's selection
Business Name is splitted into single word by client, is then scanned for using SQL search statements in central database；Accurate matching
Searched for using Business Name and SQL search statements in central database；Company selection visitor is shown to if data are inquired
In List forms on the end of family.
Opening company chooses client, fills in the vendor name of our company to be added to.For example, to search for " in China
Iron ", searching for main thought generally is：It is changed into " % iron % " in % states % in %, performing query SQL sentence after client conversion
Can match afterwards in all names containing " in " either " state " or the company of " iron ".The main thought of precise search is：Completely
Full matching Business Name.
Step 2：Judge whether to search the Business Name for needing to add, if searching needs in central database
Company, into step 3；If not searching the company of needs in central database, into step 4.
If performing returned data non-NULL after SQL query, explanation searches.Otherwise, illustrate not search.Start to look into
Zhao Hou companies choose client can be by pressing Business Name fuzzy matching, if inquiring public affairs on SQL statement to central database
The data of department's information are then shown in the List forms that company is chosen in client.If the data of company information are not inquired
Then go to register of company's client, there is provided a button, turn after clicking on button by way of setting up another process initiation external program
To register of company's client.
Step 3：Supplier of the selection company as current enterprise, and the data of company information are write into local data base
In.
Choose one or more search result and then sentence is inserted by SQL and the company information chosen is saved in local
Database.Sentence is directly inserted by SQL insert and performs insertion sentence, is saved in local data base.
Step 4：Operation interface is gone to register of company's client by company's selection client.
There is " opening registered client " button in company's selection client, by setting up another process, start external program
Mode opens registered client.
Step 5：The information of company, the data deposit central database of company information are inputted in register of company's client.
Keeper opens register of company's client, fills in the real title of company, abbreviation, legal representative, registered capital, tax
The necessary informations such as business registration card number, the Date of Incorporation, registered capital, telephone number, address, opinion rating.After information solicitation
Click on " registration " button and complete registration.The company information filled in will be preserved if succeeded in registration, on central database.Company notes
The information of volume client input directly inserts sentence by SQL insert and performs insertion, is stored in central database.
Register of company's client is acquired to the data of company information, and then each enterprise utilizes company's selection client
Company has been selected in from the central database in chartered company as the supplier of oneself.All companies have the ground of equality
Position, the essential information of company only retain portion in central database, and local data base preserves the company ID after choosing, for side
Just database SQL sentence Syndicating search, the structure of company's table on central database and data can be synchronized to local data base
On.The typing of company information master data（Registration）Can many places reference.The registration of company and using object can be separation
And there is platform property.Such as certain general headquarters of group company is responsible for auditing company incorporated, each subsidiary's can of group trusts
From the central database in the middle database from company to oneself company.
Step 6：Company incorporated's information transmission is successful to central database, then return to step one；Otherwise return to step five.
Unsuccessful to judge to succeed in registration or register according to SQL insert sentences return value, insert sentences return
It is worth and represents to succeed in registration for 1, insert sentences return value is 0 and represents that registration is unsuccessful.
It is that the uniformity that data can be achieved is explained that data syn-chronization is not needed after change company essential information：In local preservation
Be company on central database ID, need to only be taken when needing to obtain some company information ID to inquiry on central database i.e.
Can., need not be synchronous because the master data of company only saves portion on central database.
To each company for having elected supplier as, can according to project performance, complete quality and information is built after sale
A grade form is found, completes evaluation mechanism.The average mark of some supplier is counted with the cycle of setting.If average mark does not reach
Mark, perform and eliminate.
The foregoing is only a preferred embodiment of the present invention, but protection scope of the present invention be not limited thereto,
Any one skilled in the art the invention discloses technical scope in, the change or replacement that can readily occur in,
It should all be included within the scope of the present invention.
Claims (3)
1. a kind of management method of supplier, it is characterised in that including two databases and two clients, during database includes
Heart database and local data base, client includes company's selection client and register of company's client, its step are as follows：
Step 1：The Business Name to be added in client-side search central database is selected using company；
Step 2：Judge whether to search the Business Name for needing to add, if searching the public affairs of needs in central database
Department, into step 3；If not searching the company of needs in central database, into step 4；
Step 3：Supplier of the selection company as current enterprise, and by the data write-in local data base of company information；
Step 4：Operation interface is gone to register of company's client by company's selection client；
Step 5：The information of company, the data deposit central database of company information are inputted in register of company's client；
Step 6：Company incorporated's information transmission is successful to central database, then return to step one；Otherwise return to step five.
2. the management method of supplier according to claim 1, it is characterised in that the data of the company information are according to number
It is stored according to the form of table in central database, central database MySql, Microsoft SQL Server or Oracle are closed
It is type database.
3. the management method of supplier according to claim 1, it is characterised in that in company's selection client-side search
The method of heart database is：Company selects client by being matched on SQL statement to central database by Business Name,
With including fuzzy matching and accurate matching；Fuzzy matching is that Business Name is splitted into single word, Ran Houli by company's selection client
Scanned for SQL search statements in central database；Accurate matching is using Business Name and SQL search statements in middle calculation
According to being searched in storehouse；It is shown to if data are inquired in the List forms in company's selection client.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710760385.5A CN107577749A (en) | 2017-08-30 | 2017-08-30 | A kind of management method of supplier |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710760385.5A CN107577749A (en) | 2017-08-30 | 2017-08-30 | A kind of management method of supplier |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107577749A true CN107577749A (en) | 2018-01-12 |
Family
ID=61029991
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710760385.5A Pending CN107577749A (en) | 2017-08-30 | 2017-08-30 | A kind of management method of supplier |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107577749A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109784624A (en) * | 2018-12-10 | 2019-05-21 | 北京航天智造科技发展有限公司 | A kind of supplier management method and device based on model |
| CN109919474A (en) * | 2019-02-28 | 2019-06-21 | 新奥数能科技有限公司 | It is a kind of based on internet platform comprehensive energy quantization select and purchase optimization method and system |
| CN110232069A (en) * | 2019-05-05 | 2019-09-13 | 毕昀 | A kind of customer information intelligence input method and device based on big data |
| CN110677612A (en) * | 2019-09-03 | 2020-01-10 | 视联动力信息技术股份有限公司 | Conference control method and device |
| CN111949729A (en) * | 2020-07-23 | 2020-11-17 | 广州博鳌纵横网络科技有限公司 | Information association synchronization method and system based on client information |
| CN112364034A (en) * | 2021-01-13 | 2021-02-12 | 北京梦知网科技有限公司 | Trademark monitoring method, trademark monitoring device and electronic equipment |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103617583A (en) * | 2013-12-12 | 2014-03-05 | 惠州Tcl移动通信有限公司 | Method and equipment for processing data of service provider |
| CN104504486A (en) * | 2014-11-21 | 2015-04-08 | 沙洲职业工学院 | Ordering management system of middle and small-sized enterprise on the basis of cloud computing and use method thereof |
-
2017
- 2017-08-30 CN CN201710760385.5A patent/CN107577749A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103617583A (en) * | 2013-12-12 | 2014-03-05 | 惠州Tcl移动通信有限公司 | Method and equipment for processing data of service provider |
| CN104504486A (en) * | 2014-11-21 | 2015-04-08 | 沙洲职业工学院 | Ordering management system of middle and small-sized enterprise on the basis of cloud computing and use method thereof |
Non-Patent Citations (1)
| Title |
|---|
| 孙金磊: "供应商管理系统演示", 《百度文库》 * |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109784624A (en) * | 2018-12-10 | 2019-05-21 | 北京航天智造科技发展有限公司 | A kind of supplier management method and device based on model |
| CN109784624B (en) * | 2018-12-10 | 2023-09-15 | 北京航天智造科技发展有限公司 | Model-based vendor management method and device |
| CN109919474A (en) * | 2019-02-28 | 2019-06-21 | 新奥数能科技有限公司 | It is a kind of based on internet platform comprehensive energy quantization select and purchase optimization method and system |
| CN109919474B (en) * | 2019-02-28 | 2021-08-27 | 新奥数能科技有限公司 | Comprehensive energy quantitative acquisition and purchase optimization method and system based on Internet platform |
| CN110232069A (en) * | 2019-05-05 | 2019-09-13 | 毕昀 | A kind of customer information intelligence input method and device based on big data |
| CN110232069B (en) * | 2019-05-05 | 2021-08-03 | 毕昀 | Customer information intelligent input method and device based on big data |
| CN110677612A (en) * | 2019-09-03 | 2020-01-10 | 视联动力信息技术股份有限公司 | Conference control method and device |
| CN111949729A (en) * | 2020-07-23 | 2020-11-17 | 广州博鳌纵横网络科技有限公司 | Information association synchronization method and system based on client information |
| CN112364034A (en) * | 2021-01-13 | 2021-02-12 | 北京梦知网科技有限公司 | Trademark monitoring method, trademark monitoring device and electronic equipment |
| CN112364034B (en) * | 2021-01-13 | 2022-04-08 | 北京梦知网科技有限公司 | Trademark monitoring method, trademark monitoring device and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107577749A (en) | A kind of management method of supplier | |
| CN108694658A (en) | A kind of merchandise news method for pushing, relevant apparatus and storage medium | |
| CN108197226A (en) | MPTC account status tree and MPTC block chain method for quickly retrieving | |
| JP5410514B2 (en) | Method for mapping an X500 data model to a relational database | |
| US9342812B2 (en) | Taxonomy based database partitioning | |
| CN109308296A (en) | A kind of generation method, device and the computer readable storage medium of business datum table | |
| CN110414259B (en) | Method and equipment for constructing data category and realizing data sharing | |
| CN109902087A (en) | For the data processing method and device of question and answer, server | |
| CN105760380A (en) | Database query method, device and system | |
| CN110263022A (en) | Hotel's data matching method and device | |
| CN106779961A (en) | Sales information statistical method | |
| CN112464204A (en) | Account management method and related product | |
| CN108776678A (en) | Index creation method and device based on mobile terminal NoSQL databases | |
| CN111488614A (en) | Digital identity storage method and device based on service data block chain | |
| CN111737726A (en) | Relation data query method and device based on business data block chain | |
| CN106547646A (en) | A kind of data backup and restoration methods, data backup and recovery device | |
| CN108874950A (en) | A kind of distributed data storage method and device based on ER relationship | |
| US7779022B2 (en) | Efficient retrieval and storage of directory information system knowledge referrals | |
| CN109726295A (en) | Brand knowledge map display methods, device, figure server and storage medium | |
| CN108197187A (en) | Optimization method, device, storage medium and the computer equipment of query statement | |
| CN106170012A (en) | Distributed file system that a kind of facing cloud renders and structure and access method | |
| US7406471B1 (en) | Scalable multi-database event processing system using universal subscriber-specific data and universal global data | |
| CN107220363A (en) | It is a kind of to support the global complicated cross-region querying method retrieved and system | |
| CN106506661A (en) | Method, server and system for dynamically returning data | |
| CN111695136A (en) | Method and system for realizing service data block chain |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180112 |