CN107369025A - The implementation method that a kind of product is traced and tracked by lot number - Google Patents
The implementation method that a kind of product is traced and tracked by lot number Download PDFInfo
- Publication number
- CN107369025A CN107369025A CN201710585780.4A CN201710585780A CN107369025A CN 107369025 A CN107369025 A CN 107369025A CN 201710585780 A CN201710585780 A CN 201710585780A CN 107369025 A CN107369025 A CN 107369025A
- Authority
- CN
- China
- Prior art keywords
- product
- information
- lot number
- erp
- grade
- 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
- 238000000034 method Methods 0.000 title claims abstract description 30
- 239000000463 material Substances 0.000 claims abstract description 84
- 238000004519 manufacturing process Methods 0.000 claims abstract description 15
- 239000002994 raw material Substances 0.000 claims abstract description 15
- 238000005516 engineering process Methods 0.000 claims abstract description 10
- 239000005022 packaging material Substances 0.000 claims abstract description 10
- 238000004643 material aging Methods 0.000 claims abstract description 9
- 230000001747 exhibiting effect Effects 0.000 claims abstract description 5
- 238000003326 Quality management system Methods 0.000 claims abstract description 4
- 238000012216 screening Methods 0.000 claims abstract description 4
- 238000007689 inspection Methods 0.000 claims description 7
- 238000004458 analytical method Methods 0.000 claims description 3
- 230000003993 interaction Effects 0.000 claims description 3
- 230000007246 mechanism Effects 0.000 claims description 3
- 238000011017 operating method Methods 0.000 abstract 1
- 239000000047 product Substances 0.000 description 37
- 238000012550 audit Methods 0.000 description 2
- 239000011265 semifinished product Substances 0.000 description 2
- 238000012795 verification Methods 0.000 description 2
- 239000011800 void material Substances 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 238000005070 sampling Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/018—Certifying business or products
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/33—Querying
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Strategic Management (AREA)
- Marketing (AREA)
- Economics (AREA)
- Development Economics (AREA)
- General Business, Economics & Management (AREA)
- Finance (AREA)
- Accounting & Taxation (AREA)
- Entrepreneurship & Innovation (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The implementation method for being traced and being tracked by lot number the invention discloses a kind of product, belongs to Computer Applied Technology field, this method establishes the incidence relation of product, lot number and related raw material, auxiliary material and packaging material in ERP material requistion first；Secondly the checking information and production information of record product and lot number in ERP quality management system；Record the checking information and procurement information of raw material, auxiliary material and packaging material；Finally by sale outbound list, material requistion and the whereabouts information of transport unirecord product and middle product in ERP；Relevant information is gone out from substantial amounts of data screening by data grabber function, showed key message respectively by related Tab pages of retrospect, tracking, business by data exhibiting technology.The present invention can improve operating personnel's retrospect, the efficiency of tracking product information, reduce operating personnel's operating procedure towards professional technique terminal operation librarian use.
Description
Technical field
The present invention relates to Computer Applied Technology field, and in particular to the realization side that a kind of product is traced and tracked by lot number
Method.
Background technology
It is GMP and GSP basic demand for the tracking of pharmacy corporation lot number and retrospect.GMP stresses enterprises lot number
Tracking and Business Stream tracking, GSP lay particular emphasis on Business Stream tracking and flow direction tracking.For GMP lot number tracking and retrospect mainly from
Two aspects are carried out, first, tracking, exactly produces which semi-finished product and finished product, and related industry according to the lot number tracking of raw material
Business document, including storage bill, outbound list, ask verification certificate, survey report, production order etc.；Second, retrospect, according to the production of product
Journey, retrospect have used which semi-finished product and supplementary material, and related business paper to include storage bill, outbound list, have produced order, put
Row is single, quality inspection report etc..Traditional tracking and tracing mode relies primarily on personnel's completion, and efficiency is low, accuracy is difficult to ensure that.
The content of the invention
The technical assignment of the present invention is to provide the implementation method that a kind of product is traced and tracked by lot number, using in ERP
The relation of receiving of a kind of product and raw material, auxiliary material and packaging material carries out data pick-up, enters by the characteristic of relevant database
Row data exhibiting.
The technical solution adopted for the present invention to solve the technical problems is：
The implementation method that a kind of product is traced and tracked by lot number, this method establish product, lot number in ERP material requistion first
With the incidence relation of related raw material, auxiliary material and packaging material；Secondly record product and lot number in ERP quality management system
Checking information and production information；Record the checking information and procurement information of raw material, auxiliary material and packaging material；Finally by ERP
Sale outbound list, material requistion and the whereabouts information of transport unirecord product and middle product；By data grabber function from a large amount of
Data screening go out relevant information, by data exhibiting technology by key message by related Tab pages point of retrospect, tracking, business
Do not show；
The specific implementation step of this method is as follows：
1）, the text box information in joint winform forms build a crucial index, product information is expressed as code ID shapes
Formula, a string of characters represent a product product rule, lift index efficiency；Wherein, text box information includes product information frame, lot number is believed
Cease frame and company information；Product information includes title, numbering and specification；
2）, by key index, using Stored Procedure Technology in database, gone out specifically by logic module between the table in database
Business information result set, retrospect result set and tracking result collection；Wherein, business information result set includes type of service, document
Numbering, document date, make one, make single time and client；Trace result set include this grade of stock number, this grade of name of material,
This grade of material lot number, subordinate's stock number, subordinate's name of material, subordinate's material lot number, supplier, the date of manufacture, valid until,
Date, original producton location and inspection report are rechecked, to represent this batch of this product is made up of which raw material；Tracking result Ji Bao
Include this grade of stock number, this grade of name of material, this grade of material lot number, higher level's stock number, higher level's name of material, higher level's material batch
Number, supplier, the date of manufacture, valid until, recheck date, original producton location and inspection report, to represent this batch of use of this product
In which place；
3）, by Webservice service by storing process return result set be transferred to user operate client machine on,
The classification of specific data message is presented to by user by list loading；
4）, by user request utilize .net and Excel interaction mechanisms, the data that user search is gone out, produced from ERP system
It is easy to user to achieve analysis.
Preferably, the code ID of the product information is 20 characters.
Further, the type of service in business information result set includes storage, outbound, production, please test, sample, examining
And clearance.
The core concept and implementation of this method can be summarized as：
Product, material, raw material, auxiliary material archives are built, related lot number information is set；
Build product, lot number and raw material, auxiliary material, the relation of packaging material, the relation can be that multiple documents record build respectively；
It is that core screens related data and in the form of showing by different requirement tissues by lot number；
Export can be encapsulated by result by interacting component with Excel using .net.
The implementation method that a kind of product of the present invention is traced and tracked by lot number compared with prior art, has beneficial below
Effect：
The retrospect of product, tracking, business are related including producing order, asking verification certificate, sampling list, survey report, release permit, storage bill
And outbound single integration shows, solve operating personnel in enterprise and fast check batch number retrospect, tracking and related letter immediately
The demand of breath；The function of once grasping relevant information comprehensively by simple product, lot number clue can be realized；Due to this method
The disposable demand for realizing multistage retrospect, improves recall precision.
Brief description of the drawings
Fig. 1 is the schematic flow sheet for the implementation method that a kind of product of the present invention is traced and tracked by lot number.
Embodiment
With reference to specific embodiment, the invention will be further described.
A kind of product by lot number trace and track implementation method, this method established first in ERP material requistion product,
The incidence relation of lot number and related raw material, auxiliary material and packaging material；Secondly in ERP quality management system record product and batch
Number checking information and production information；Record the checking information and procurement information of raw material, auxiliary material and packaging material；Finally by
Sale outbound list, material requistion and the whereabouts information of transport unirecord product and middle product in ERP；By data grabber function from
Substantial amounts of data screening goes out relevant information, by data exhibiting technology by key message by the related Tab of retrospect, tracking, business
Page shows respectively；
The specific implementation step of this method is as follows：
1）, the text box information in joint winform forms build a crucial index, product information is expressed as code ID shapes
Formula, code ID are 20 characters, and a string of characters represent a product product rule, lift index efficiency；Wherein, text box information includes
Product information frame, lot number information frame and company information；Product information includes title, numbering and specification；
2）, by key index, using Stored Procedure Technology in database, gone out specifically by logic module between the table in database
Business information result set, retrospect result set and tracking result collection；Wherein, business information result set includes type of service, document
Numbering, document date, make one, system single time and client, type of service includes storage, outbound, production, please test, sample, examining
And clearance；Tracing result set includes this grade of stock number, this grade of name of material, this grade of material lot number, subordinate's stock number, subordinate
Name of material, subordinate's material lot number, supplier, the date of manufacture, valid until, recheck date, original producton location and inspection report, use
To represent this batch of this product is made up of which raw material；Tracking result collection includes this grade of stock number, this grade of name of material, sheet
Level material lot number, higher level's stock number, higher level's name of material, higher level's material lot number, supplier, the date of manufacture, valid until, it is multiple
Date, original producton location and inspection report are examined, to represent which place this batch of this product has been used in；
3）, by Webservice service by storing process return result set be transferred to user operate client machine on,
The classification of specific data message is presented to by user by list loading；
4）, by user request utilize .net and Excel interaction mechanisms, the data that user search is gone out, produced from ERP system
It is easy to user to achieve analysis.
It is as follows to retrieve key code：
#region tracks material method
[ControllerMethod]
public void GZWLMethod()
{
The tree of // father node tissue, directly obtain
DataSet ds = GSPPubFunctionClient.ExecuteSQLGetDataSet(@"
SELECT
Materials.MaterialCode higher level's stock number,
Materials.MaterialName higher level's name of material,
Materials.Specs higher level's material specification,
Batches.BatchCode higher level's material lot number,
MaterialSorts.MaterialSortName material categories,
WLZZTmp.MaterialCode stock numbers,
WLZZTmp.MaterialName names of material,
WLZZTmp.Specs material specifications,
WLZZTmp.BatchCode material lot numbers,
WLZZTmp.Factory suppliers,
WLZZTmp.DisabledDate valid until,
WLZZTmp.ReCheckDate rechecks the date,
WLZZTmp.FactoryArea original producton locations,
WLZZTmp.CounterCheckCode audit report odd numbers
FROM
(
SELECT distinct
ParentMaterialID,
ParentBatchID,
Materials.MaterialSortID,
ChildMaterialID,
ChildBatchID,
Materials.MaterialSortID MaterialSortIDtem,
Materials.MaterialCode,
Materials.MaterialName,
Materials.Specs,
Batches.BatchCode,
Batches.Factory,
Batches.DisabledDate,
Batches.ReCheckDate,
Batches.CounterCheckCode,
Batches.FactoryArea,
ZZBOBTmp.note
FROM ZZBOBTmp
LEFT JOIN Batches ON ZZBOBTmp.ChildBatchID=Batches.BatchID
LEFT JOIN Materials ON ZZBOBTmp.ChildMaterialID=Materials.MaterialID
) WLZZTmp
LEFT JOIN Materials ON WLZZTmp.ParentMaterialID=Materials.MaterialID
LEFT JOIN Batches ON WLZZTmp.ParentBatchID=Batches.BatchID
LEFT JOIN MaterialSorts ON WLZZTmp.MaterialSortIDtem=
MaterialSorts.MaterialSortID
order by WLZZTmp.note asc", ClientContext.Current.FramworkState);
GzwlList.VisualComponent.DataSource = ds.Tables[0];
}
#region traces material method
[ControllerMethod]
public void ZSWLMethd()
{
The tree of // father node tissue, directly obtain
DataSet dsgz = GSPPubFunctionClient.ExecuteSQLGetDataSet(@"
SELECT
Materials.MaterialCode higher level's stock number,
Materials.MaterialName higher level's name of material,
Materials.Specs higher level's material specification,
Batches.BatchCode higher level's material lot number,
MaterialSorts.MaterialSortName material categories,
WLZZTmp.MaterialCode stock numbers,
WLZZTmp.MaterialName names of material,
WLZZTmp.Specs material specifications,
WLZZTmp.BatchCode material lot numbers,
WLZZTmp.Factory suppliers,
WLZZTmp.DisabledDate valid until,
WLZZTmp.ReCheckDate rechecks the date,
WLZZTmp.FactoryArea original producton locations,
WLZZTmp.CounterCheckCode audit report odd numbers
FROM
(
SELECT distinct
ParentMaterialID,
ParentBatchID,
Materials.MaterialSortID,
ChildMaterialID,
ChildBatchID,
Materials.MaterialSortID MaterialSortIDtem,
Materials.MaterialCode,
Materials.MaterialName,
Materials.Specs,
Batches.BatchCode,
Batches.Factory,
Batches.DisabledDate,
Batches.ReCheckDate,
Batches.CounterCheckCode,
Batches.FactoryArea,
GZBOBTmp.note
FROM GZBOBTmp
LEFT JOIN Batches ON GZBOBTmp.ChildBatchID=Batches.BatchID
LEFT JOIN Materials ON GZBOBTmp.ChildMaterialID=Materials.MaterialID
) WLZZTmp
LEFT JOIN Materials ON WLZZTmp.ParentMaterialID=Materials.MaterialID
LEFT JOIN Batches ON WLZZTmp.ParentBatchID=Batches.BatchID
LEFT JOIN MaterialSorts ON WLZZTmp.MaterialSortIDtem=
MaterialSorts.MaterialSortID order by WLZZTmp.note asc ",
ClientContext.Current.FramworkState);
ZswlList.VisualComponent.DataSource = dsgz.Tables[0];
}
#endregion
By embodiment above, the those skilled in the art can readily realize the present invention.But it should manage
Solution, the present invention are not limited to above-mentioned embodiment.On the basis of disclosed embodiment, the skill of the technical field
Art personnel can be combined different technical characteristics, so as to realize different technical schemes.
Claims (3)
1. the implementation method that a kind of product is traced and tracked by lot number, it is characterised in that this method is first in ERP material requistion
Establish the incidence relation of product, lot number and related raw material, auxiliary material and packaging material；Secondly remember in ERP quality management system
Record the checking information and production information of product and lot number；Record the checking information and procurement information of raw material, auxiliary material and packaging material；
Finally by sale outbound list, material requistion and the whereabouts information of transport unirecord product and middle product in ERP；Grabbed by data
Function is taken to go out relevant information from substantial amounts of data screening, by data exhibiting technology by key message by retrospect, tracking, business phase
Tab pages of pass shows respectively；
The specific implementation step of this method is as follows：
1）, the text box information in joint winform forms build a crucial index, product information is expressed as code ID shapes
Formula, a string of characters represent a product product rule；Wherein, text box information includes product information frame, lot number information frame and company's letter
Breath；Product information includes title, numbering and specification；
2）, by key index, using Stored Procedure Technology in database, gone out specifically by logic module between the table in database
Business information result set, retrospect result set and tracking result collection；Wherein, business information result set includes type of service, document
Numbering, document date, make one, make single time and client；Trace result set include this grade of stock number, this grade of name of material,
This grade of material lot number, subordinate's stock number, subordinate's name of material, subordinate's material lot number, supplier, the date of manufacture, valid until,
Date, original producton location and inspection report are rechecked, to represent this batch of this product is made up of which raw material；Tracking result Ji Bao
Include this grade of stock number, this grade of name of material, this grade of material lot number, higher level's stock number, higher level's name of material, higher level's material batch
Number, supplier, the date of manufacture, valid until, recheck date, original producton location and inspection report, to represent this batch of use of this product
In which place；
3）, by Webservice service by storing process return result set be transferred to user operate client machine on,
The classification of specific data message is presented to by user by list loading；
4）, by user request utilize .net and Excel interaction mechanisms, the data that user search is gone out, produced from ERP system
It is easy to user to achieve analysis.
2. the implementation method that a kind of product according to claim 1 is traced and tracked by lot number, it is characterised in that product is believed
The code ID of breath is 20 characters.
3. the implementation method that a kind of product according to claim 1 is traced and tracked by lot number, it is characterised in that business is believed
Type of service in breath result set includes storage, outbound, production, please test, samples, examines and let pass.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710585780.4A CN107369025A (en) | 2017-07-18 | 2017-07-18 | The implementation method that a kind of product is traced and tracked by lot number |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710585780.4A CN107369025A (en) | 2017-07-18 | 2017-07-18 | The implementation method that a kind of product is traced and tracked by lot number |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107369025A true CN107369025A (en) | 2017-11-21 |
Family
ID=60308128
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710585780.4A Pending CN107369025A (en) | 2017-07-18 | 2017-07-18 | The implementation method that a kind of product is traced and tracked by lot number |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107369025A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108052402A (en) * | 2017-12-29 | 2018-05-18 | 苏州泽达兴邦医药科技有限公司 | Method for butting MES system and ERP system in traditional Chinese medicine extraction |
| CN109406762A (en) * | 2018-09-11 | 2019-03-01 | 彩虹（合肥）液晶玻璃有限公司 | Glass plate inspection result statistical method and device |
| CN109543849A (en) * | 2018-10-26 | 2019-03-29 | 甘肃省核与辐射安全中心 | A kind of equipment management system based on .netExcel development platform |
| CN111069083A (en) * | 2019-12-12 | 2020-04-28 | 广东和胜工业铝材股份有限公司 | Method for eliminating post-process defects of tail shrinkage and welding of industrial aluminum profile |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103778507A (en) * | 2014-01-16 | 2014-05-07 | 华南理工大学 | Dairy product quality safety full-life-circle intelligent traceability method based on Internet of things |
| CN106651395A (en) * | 2016-12-20 | 2017-05-10 | 泽达易盛（天津）科技股份有限公司 | Chinese patent medicine whole industry chain tracing management system |
-
2017
- 2017-07-18 CN CN201710585780.4A patent/CN107369025A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103778507A (en) * | 2014-01-16 | 2014-05-07 | 华南理工大学 | Dairy product quality safety full-life-circle intelligent traceability method based on Internet of things |
| CN106651395A (en) * | 2016-12-20 | 2017-05-10 | 泽达易盛（天津）科技股份有限公司 | Chinese patent medicine whole industry chain tracing management system |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108052402A (en) * | 2017-12-29 | 2018-05-18 | 苏州泽达兴邦医药科技有限公司 | Method for butting MES system and ERP system in traditional Chinese medicine extraction |
| CN109406762A (en) * | 2018-09-11 | 2019-03-01 | 彩虹（合肥）液晶玻璃有限公司 | Glass plate inspection result statistical method and device |
| CN109543849A (en) * | 2018-10-26 | 2019-03-29 | 甘肃省核与辐射安全中心 | A kind of equipment management system based on .netExcel development platform |
| CN111069083A (en) * | 2019-12-12 | 2020-04-28 | 广东和胜工业铝材股份有限公司 | Method for eliminating post-process defects of tail shrinkage and welding of industrial aluminum profile |
| CN111069083B (en) * | 2019-12-12 | 2021-08-31 | 广东和胜工业铝材股份有限公司 | Method for eliminating post-process defects of tail shrinkage and welding of industrial aluminum profile |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107369025A (en) | The implementation method that a kind of product is traced and tracked by lot number | |
| Wiebe et al. | Carbon and materials embodied in the international trade of emerging economies: a multiregional input‐output assessment of trends between 1995 and 2005 | |
| Vuong et al. | Characteristics of retracted articles based on retraction data from online sources through February 2019 | |
| CN106649223A (en) | Financial report automatic generation method based on natural language processing | |
| Costa et al. | The impact of computer usage on scholarly communication among social scientists | |
| Wang et al. | Knowledge flows from public science to industrial technologies | |
| CN104123422B (en) | Design method before a kind of system of utilization data base management system | |
| CN104035993B (en) | Memory search method, e-book management system, the reading system of e-book | |
| CN103678648A (en) | Classifying and gathering system and method of BOM tables | |
| CN107368765A (en) | A kind of packaging material batch can tracing management method and system | |
| CN111950921A (en) | Multi-person collaborative review method based on offline networking environment | |
| CN113034251A (en) | Online bidding management system | |
| CN110045981A (en) | A method of analytical technology is compared based on source code and establishes demand tracking relationship | |
| CN105808772A (en) | Data defining file generation method and device | |
| CN107526804A (en) | A kind of railway investment project data statistics system and method | |
| CN110717754A (en) | Commodity transaction method, server, user side, laboratory side and system | |
| CN103399848A (en) | Engine test data standardized specific format leading-in processing method | |
| CN109272295A (en) | Project of inviting outside investment audits statistical method and system | |
| CN102456176B (en) | Method and device for engineering change of bill of material | |
| CN101441645A (en) | System and method of technical data analysis | |
| TW200417884A (en) | System and method for automatically classifying bill of material | |
| Tijjani et al. | Research productivity of International Financial Reporting Standards (IFRS) from 2003 to 2020 | |
| CN114881601A (en) | Multi-process route transmission method based on PLM system | |
| CN115908062A (en) | Intellectual property full-period management system | |
| CN108563616A (en) | A kind of ship electronic base map management method |
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 |
Application publication date: 20171121 |
|
| RJ01 | Rejection of invention patent application after publication |