CN101645007A - Interface processing method of general quality inspection management software - Google Patents

Interface processing method of general quality inspection management software Download PDF

Info

Publication number
CN101645007A
CN101645007A CN 200910018626 CN200910018626A CN101645007A CN 101645007 A CN101645007 A CN 101645007A CN 200910018626 CN200910018626 CN 200910018626 CN 200910018626 A CN200910018626 A CN 200910018626A CN 101645007 A CN101645007 A CN 101645007A
Authority
CN
China
Prior art keywords
interface
lnv
result
integer
scqyd
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN 200910018626
Other languages
Chinese (zh)
Other versions
CN101645007B (en
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.)
Inspur Group Shandong General Software Co Ltd
Original Assignee
Inspur Group Shandong General Software 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 Inspur Group Shandong General Software Co Ltd filed Critical Inspur Group Shandong General Software Co Ltd
Priority to CN200910018626.4A priority Critical patent/CN101645007B/en
Publication of CN101645007A publication Critical patent/CN101645007A/en
Application granted granted Critical
Publication of CN101645007B publication Critical patent/CN101645007B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Debugging And Monitoring (AREA)

Abstract

The invention discloses an interface processing method of a service module and a quality inspection module in an ERP system. In the method, various conditions which are possible to be met in the interface process are all encapsulated into independent methods which can be called by external, requested inspection, inspection process tracing, inspection result confirmation and inspection process control functions which are needed by practical operation can be realized by calling the corresponding methods in the service module, and the generation of requested inspection information, the feedback of a sampling process, the feedback of an inspection report, the feedback and control of inspection report approval and the feedback and control of an unqualified product processing suggestion can be realized by calling the corresponding methods in a standard way in the quality inspection process. The invention can realize a quality inspection management module aiming at different industries in thesame ERP system, meet the inspection detail management of various industries and also still keep a uniform edition of a service system.

Description

A kind of general quality inspection management software interface method
Technical field
The present invention relates to a kind of Computer Applied Technology, relate in particular to a kind of general quality inspection management software interface method.
Background technology
Service links very many in business administration need be tested, and determine professional disposal route according to the result of check, and when carrying out business administration by ERP, inspection management need carry out interaction process with each service link.The software processes process difference of each service link, the fineness of check is also inequality, and is also inequality to the mode of checking the back data processing, and it is very necessary therefore to set up unified interface disposal route, and this also is a core difficult problem to be solved by this invention.
In addition ERP towards different industries, processing requirements to check is also inequality, therefore quality inspection management software towards different industries has appearred, management software interface standard by unified each industry, realize the interface of ERP with the quality inspection management of various industries, can effectively reduce complexity and diversity that software is realized, the present invention forms on this basis, has effectively to evade by the tradition coding to realize the variety of problems that interface brings respectively.
Summary of the invention
The purpose of this invention is to provide a kind of general quality inspection management software interface method.The present invention finishes the configuration in check source by setting up source document allocation list, set up quality inspection as a result middle table finish the intermediate information exchange of operation system homogenous quantities checking information, handle the inside of corresponding middle table data and access interface realizes by unified routine processes assembly, thereby realize that assembly all is transparent operations to operation system and quality inspection system, can finish fast and in any business procedure, incorporate the quality inspection processing procedure, changed and by code layer business module homogenous quantities inspection module had been carried out the mode that interface is handled in the past, also avoided having brought the difficulty of software upgrading maintenance work because code layer realizes interface.
The objective of the invention is to realize in the following manner,
1) set up inspection bill source table, every kind of check of record comes the business paper configuration information of Source Type in table, comprises whether professional parameter is controlled in strictness in check, checks in each process business information is returned the sql or the storing process configuration of stepping on.
2) set up check interface middle table, as the data interaction basis of operation system with checking system, in the interface table, indicate professional source-information, source sign one, source sign two, source sign three, according to different business sources, adopt one to three sign, can satisfy the business processing that runs into various needs checks among the ERP.
3) by receiving the call parameters of operation system, demonstration please be tested the artificial affirmation that partial information is carried out at the interface, please test the successfully information of back formation check interface middle table, repeatedly please test finally please test to be as the criterion.
4) realize being used for checkout procedure the interface that inspection content carries out write-back is handled, form unification and check the progress chasing information table timely, make things convenient for the calling service place in time to obtain the check progress msg.
5) inspected, come SQL that Source Type disposes or storing process, realized unified assay feedback processing by check.In processing, pass to SQL corresponding results information parameter, source document identification parameter by interface module.
6) provide demonstration assay assembly, a kind of situation can not have follow-up processing and checks that another situation can have the results verification of subsequent treatment.
Of the present invention have function and a beneficial effect
1. realize the software implementation management interface of different service link checks.
2. can finish by interface and please test processing, assay processing.
3. can realize among the ERP towards the different different inspection management software of industry research and development, and carry out seamless integrated with professional system by interface.
4. by using this interfacing can realize possessing the software systems of good work compound effect, realize organically blending of material flow swivel link and test stage, when work compound is raised the efficiency, realized that in the lump business procedure is subjected to the control of checkout procedure, has effectively realized the standard of operation flow.
By this technology can the effective simplification ERP software program structure, help software maintenance and upgrading.
Description of drawings
Fig. 1 realizes principle schematic for interface;
Fig. 2 is an assay interface table.
Embodiment
Explain below with reference to Figure of description interface method of the present invention being done.
A kind of general quality inspection management software interface method of the present invention, specifically use step as follows:
1.) carry out initial configuration.
A. initialization document types table: ZJDJLX sets up a registration data relevant with quality inspection by this table, disposes corresponding sql simultaneously.
B. initialization condition is judged table: ZJTJ, and this table also can be set up when implementing.General as long as set up the condition that whether needs quality inspection.
2.) generating please verification certificate code routine.
long ll_ret
string ls_qydh
n_zj_gen_qyd_stru lnv_scqyd
n_cst_zj_interface lnv_face
// initialization interface object.
The document that ls_qydh=dw_master.getitemstring (1, ' zjqyd1_sjdh ') // taking-up needs to transmit is numbered, and has a plurality of.
lnv_face=create n_cst_zj_interface
If lnv_face.of_initial (' qyd ', ls_qydh)=-1 then // object initialization, ' qyd ' is predefined document types.
F_msg (' initialization failure! ', 0)
destroy?lnv_face
return
end?if
// information of needs is carried out assignment.
Lnv_scqyd.is_qybm=dw_master.getitemstring (1, ' zjqyd1_bmbh1 ') // please test department
Lnv_scqyd.is_dw=dw_master.getitemstring (1, ' zjqyd1_dwbh ') // unit
Lnv_scqyd.is_wlbh=dw_master.getitemstring (1, ' zjqyd1_wlbh ') // stock number
Lnv_scqyd.is_pch=dw_master.getitemstring (1, ' zjqyd1_pch ') // batch number
Lnv_scqyd.is_nkpch=dw_master.getitemstring (1, ' zjqyd1_nkpch ') // the internal control batch number
Lnv_scqyd.is_scrq=dw_master.getitemstring (1, ' zjqyd1_scrq ') // date of manufacture
Lnv_scqyd.is_sxrq=dw_master.getitemstring (1, ' zjqyd1_sxrq ') // Expiration Date
Lnv_scqyd.is_ckbh=dw_master.getitemstring (1, ' zjqyd1_ckbh ') // warehouse number
Lnv_scqyd.is_hwbh=dw_master.getitemstring (1, ' zjqyd1_hwbh ') // the goods yard numbering
Lnv scqyd.is_note=' asdkfajshd ' // remarks
Lnv_scqyd.id_djsl=dw_master.getitemnumber (1, ' zjqyd1_zjsl ') // quantity to be checked
// call generating function.
Ll_ret=lnv_face.of_gen_qyd (lnv_scqyd) // rreturn value: 1 success ,-1 failure, 0 without quality inspection, 9 are cancelled '
destroy?lnv_face
3.) display result calling routine
lnv_face.of_show_result()
4.) program inquiring quality inspection result.(can obtain a result object.)
n_zj_result lnv_result
ll_ret =lnv_face.of_get_result(lnv_result)
5.) the quality inspection result data uses write-back
lnv_face.of_use_result(true/false)
6.) stock's action data write-back
Lnv_face.of_write_kc (qualified quantity, defective quantity)
7.) corresponding object function.(rreturn value of all functions as for-1 the expression make mistakes)
// initialization function.Before calling other function, must call the initialization function.
1 success of //Returns:(INTEGER) ,-1 failure.
integer?of_initial(string?as_doctype,string?as_id1)
integer?of_initial(string?as_doctype,string?as_id1,string?as_id2)
integer?of_initial(string?as_doctype,string?as_id1,string?as_id2,string?as_id3)
// generate and ask verification certificate
1 success of //Returns:(INTEGER) ,-1 failure, 0 without quality inspection, and 9 are cancelled
integer?of_gen_qyd(n_zj_gen_qyd_stru?anv_data)
// obtain assay.Use for program.
//Returns:(INTEGER)-1 failure, 0 does not also have the quality inspection result available, 1 successful return results, 2 is inspection-free
integer?of_get_result(ref?n_zj_result?anv_result)
// show the information of quality inspection, offer display interface of user, simultaneously according to configuration, the user may make amendment to the result.
integer?of_show_result()
// carried out further processing according to assay.
//Returns:(INTEGER) 1 upgraded successfully, and-1 upgrades failure
integer?of_use_result(boolean?ab_use)
// in the process of further handling, carry out write-back at the situation that goes out warehouse-in.
1 success of //Returns:(INTEGER) ,-1 failure
integer?of_write_kc(decimal?ad_hgsl,decimal?ad_bhgsl)
// whether need quality inspection, call in the program circuit.
//Returns:(INTEGER) 1 be, 0 is not, and-1 makes mistakes.
integer?of_need_zj()
The main program assembly:
Main object: n_cst_zj_interface
Realization please be tested processing, comprises parametric test, repeatedly content such as please test.
The realization assay is checked.
Realization has inspected subsequent treatment.
Realization is to the cura generalis work of quality inspection interface table (ZJJGB), and the insertion, renewal and the data that comprise data are with professional system, same checking system.
Please test interface: w_zj_resp_interface_scqyd
Demonstration please be tested the interface.
Realization is to revising the operation of part side information.
Assay display interface: w_zj_resp_interface_zjjg
Show assay according to parameter.
Embodiment:
The successful tide ERP-PS8.0 of the present invention, 8.5,9.0,9.1,10.0 products have been obtained good effect.
By the utilization of present technique, can be implemented in a certain service link homogenous quantities checking system among the ERP fast and engage, by the use of software, collaborative business event that can be good is handled multidisciplinary cooperation of handling with check.
This technology can generally be applied in the pharmaceutical industry strict to quality, the user of service finish by software systems formerly expect factory, produce roll off the production line, intermediate, sale shipment, in the checkout procedure of service links such as storehouse reinspection.At first sent in operation system by the user of service and ask verification certificate, quality personnel please verification certificate take a sample, check, provide report, provide the unacceptable product handling suggestion according to what receive, and send to business department by software and carry out the subsequent job processing.By this technology synergy multiple person cooperational, improved work efficiency, by the mutual restriction relation between software systems, also effectively assist enterprise to improve the task management controlling unit simultaneously, further advanced the pharmaceutical industry process of IT application.
Application by present technique, the program structure of operation system among the ERP and quality inspection system has been realized optimization, the mode that mutual lotus root is closed by configuration the corresponding interface parameter rule just can realize, effectively subtract the transparent access that has kept between system, the upgrading of each system can not influence related system with maintenance, this technology can continue to be applied in the professional software processes links that merge with check that need to carry out more, is a kind of reliably software processing technology efficiently.

Claims (1)

1, a kind of general quality inspection management software interface method, it is characterized in that, at among the ERP software processing mode being unified in quality inspection, finish all kinds of quality of service checkout procedures by the configuration of interface and carry out software processes, passing through to set no more than three identification parameters in professional source in the interface is the basis, set up check interface table, and realize unified interface routine assembly, interface provides unified test stage definition and processing, to the seamless connection with many service link disposal systems of ERP of the inspection management software of different industries, the interface configuration step is as follows by the interface finished surface:
1) set up inspection bill source table, every kind of check of record comes the business paper configuration information of Source Type in table, comprises whether professional parameter is controlled in strictness in check, checks in each process business information is returned the sql or the storing process configuration of stepping on;
2) set up check interface middle table, as the data interaction basis of operation system with checking system, in the interface table, indicate professional source-information, source sign one, source sign two, source sign three, according to different business sources, adopt one to three sign, satisfy the business processing that runs into various needs checks among the ERP;
3) by receiving the call parameters of operation system, demonstration please be tested the artificial affirmation that partial information is carried out at the interface, please test the successfully information of back formation check interface middle table, repeatedly please test finally please test to be as the criterion;
4) interface that is provided in the checkout procedure inspection content is carried out write-back is handled, and forms unifiedly to check the progress chasing information table timely, makes things convenient for the calling service place in time to obtain the check progress msg;
5) inspected, come SQL that Source Type disposes or storing process, realized unified assay feedback processing, in processing, passed to SQL corresponding results information parameter, source document identification parameter by interface module by check;
6) provide demonstration assay assembly, a kind of situation does not have follow-up processing and checks that another situation has the results verification of subsequent treatment;
Interface specifically uses step as follows:
1) carries out initial configuration
A. initialization document types table: ZJDJLX sets up a registration data relevant with quality inspection by this table, disposes corresponding sql simultaneously;
B. initialization condition is judged table: ZJTJ, and this table also can be set up when implementing, and is general as long as set up the condition that whether needs quality inspection;
2) generating please verification certificate code routine
long ll_ret
string ls_qydh
n_zj_gen_qyd_stru lnv_scqyd
n_cst_zj_interface?lnv_face
// initialization interface object
Ls_qydh=dw_master.getitemstring (1, ' zjqyd1_sjdh ') // and take out the document that needs to transmit to number, have a plurality of;
lnv_face=create n_cst_zj_interface
if?lnv_face.of_initial(’qyd’,ls_qydh)=-1?then
The initialization of // object, ' qyd ' is predefined document types;
F_msg (' initialization failure! ', 0)
destroy?lnv_face
return
end?if
// information of needs is carried out assignment
Lnv_scqyd.is_qybm=dw_master.getitemstring (1, ' zjqyd1_bmbh1 ') // please test department
Lnv_scqyd.is_dw=dw_master.getitemstring (1, ' zjqyd1_dwbh ') // unit
Lnv_scqyd.is_wlbh=dw_master.getitemstring (1, ' zjqyd1_wlbh ') // stock number
Lnv_scqyd.is_pch=dw_master.getitemstring (1, ' zjqyd1_pch ') // batch number
Lnv_scqyd.is_nkpch=dw_master.getitemstring (1, ' zjqyd1_nkpch ') // the internal control batch number
Lnv_scqyd.is_scrq=dw_master.getitemstring (1, ' zjqyd1_scrq ') // date of manufacture
Lnv_scqyd.is_sxrq=dw_master.getitemstring (1, ' zjqyd1_sxrq ') // Expiration Date
Lnv_scqyd.is_ckbh=dw_master.getitemstring (1, ' zjqyd1_ckbh ') // warehouse number
Lnv_scqyd.is_hwbh=dw_master.getitemstring (1, ' zjqyd1_hwbh ') // the goods yard numbering
Lnv_scqyd.is_note=' asdkfajshd ' // remarks
Lnv_scqyd.id_djsl=dw_master.getitemnumber (1, ' zjqyd1_zjsl ') // quantity to be checked // call generating function
Ll_ret=lnv_face.of_gen_qyd (lnv_scqyd) // rreturn value: 1 success ,-1 failure, 0 without quality inspection, 9 are cancelled '
destroy?lnv_face
3) display result calling routine
lnv_face.of_show_result()
4) program inquiring quality inspection result obtains a result object;
n_zj_result lnv_result
ll_ret =lnv_face.of_get_result(lnv_result)
5) the quality inspection result data uses write-back
lnv_face.of_use_result(true/false)
6) stock's action data write-back
The qualified quantity of lnv_face.of_write_kc, defective quantity;
7) below corresponding object function;
// initialization function must call the initialization function before calling other function;
1 success of //Returns:(INTEGER) ,-1 failure;
integer?of_initial(string?as_doctype,string?as_id1)
integer?of_initial(string?as_doctype,string?as_id1,string?as_id2)
integer?of_initial(string?as_doctype,string?as_id1,string?as_id2,string?as?id3)
// generate and ask verification certificate
1 success of //Returns:(INTEGER) ,-1 failure, 0 without quality inspection, and 9 are cancelled;
integer?of_gen_qyd(n_zj_gen_qyd_stru?anv_data)
// obtain assay, use for program;
//Returns:(INTEGER)-1 failure, 0 does not also have the quality inspection result available, 1 successful return results, 2 is inspection-free;
integer?of_get_result(ref?n_zj_result?anv_result)
// show the information of quality inspection, offer display interface of user, simultaneously according to configuration, the user may make amendment to the result;
integer?of_show_result()
// carried out further processing according to assay;
//Returns:(INTEGER) 1 upgraded successfully, and-1 upgrades failure;
integer?of_use_result(boolean?ab_use)
// in the process of further handling, carry out write-back at the situation that goes out warehouse-in;
1 success of //Returns:(INTEGER) ,-1 failure;
integer?of_write?kc(decimal?ad_hgsl,decimal?ad_bhgsl)
// whether need quality inspection, call in the program circuit;
//Returns:(INTEGER) 1 be, 0 is not, and-1 makes mistakes
integer?of_need_zj()
The main program assembly:
Main object: n_cst_zj_interface
Realization please be tested processing, comprises parametric test, repeatedly content such as please test;
The realization assay is checked;
Realization has inspected subsequent treatment;
Realization is to the cura generalis work of quality inspection interface table (ZJJGB), and the insertion, renewal and the data that comprise data are with professional system, same checking system;
Please test interface: w_zj_resp_interface_scqyd
Demonstration please be tested the interface;
Realization is to revising the operation of part side information;
Assay display interface: w_zj_resp_interface_zjjg
Show assay according to parameter.
CN200910018626.4A 2009-09-07 2009-09-07 Interface processing method of general quality inspection management software Active CN101645007B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN200910018626.4A CN101645007B (en) 2009-09-07 2009-09-07 Interface processing method of general quality inspection management software

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN200910018626.4A CN101645007B (en) 2009-09-07 2009-09-07 Interface processing method of general quality inspection management software

Publications (2)

Publication Number Publication Date
CN101645007A true CN101645007A (en) 2010-02-10
CN101645007B CN101645007B (en) 2014-08-20

Family

ID=41656904

Family Applications (1)

Application Number Title Priority Date Filing Date
CN200910018626.4A Active CN101645007B (en) 2009-09-07 2009-09-07 Interface processing method of general quality inspection management software

Country Status (1)

Country Link
CN (1) CN101645007B (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106408235A (en) * 2016-09-12 2017-02-15 济南浪潮高新科技投资发展有限公司 Method for realizing material unit composite metering in supply chain system
CN108256597A (en) * 2017-12-18 2018-07-06 广东精迅里亚特种线材有限公司 A kind of quality control system of electromagnetic wire production

Family Cites Families (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1734488A (en) * 2004-08-13 2006-02-15 鸿富锦精密工业(深圳)有限公司 Production control bill is carried out the system and method for fool proof
CN101452450A (en) * 2007-11-30 2009-06-10 上海市电力公司 Multiple source data conversion service method and apparatus thereof

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106408235A (en) * 2016-09-12 2017-02-15 济南浪潮高新科技投资发展有限公司 Method for realizing material unit composite metering in supply chain system
CN108256597A (en) * 2017-12-18 2018-07-06 广东精迅里亚特种线材有限公司 A kind of quality control system of electromagnetic wire production

Also Published As

Publication number Publication date
CN101645007B (en) 2014-08-20

Similar Documents

Publication Publication Date Title
US9864960B2 (en) Manufacturing collaboration hub data exchange interface
CN101937463A (en) Method for automatically generating form for workflow model
McLaughlin et al. Cellular manufacturing applications in MRO operations
EP2151790A1 (en) A process model lean notation
US8566780B2 (en) Object model based mapping
Blumöhr et al. Variant configuration with SAP
CN109901872A (en) A kind of IT application in enterprises series of products version pipe control method
Vještica et al. Multi-level production process modeling language
CN101645007B (en) Interface processing method of general quality inspection management software
CN101339506B (en) Device for implementing software products resource and version management
Balcerak et al. Engineering change administration: the key issues
CN117434893A (en) Data and flow driven real object technical state control system and method
CN114239246B (en) Production method of complex scene-oriented PBOM (private branch exchange) process assembly
Xu et al. Research on construction and application for the model of multistage job shop scheduling problem
Louis et al. Flexible Production Control. A Framework to Integrate ERP with Manufacturing Execution Systems
CN110610305A (en) Data center full life cycle integrated service dispatching master control system
Brandao et al. Product Lifecycle Management Systems and Business Process Improvement–A Report on Case Study Research
JP2009517780A (en) Business transaction representation
Kurfess et al. The role of the digital thread for security, resilience, and adaptability in manufacturing
CN104933616A (en) Financial server, data processing method thereof and system
Potdar et al. Design and development of a framework for effective engineering change management in manufacturing industries
CN115907360A (en) Differential material inspection method and system aiming at material quality demands of multiple users
Mahapatra et al. Team-based collaboration in model-based design
KR101348608B1 (en) Apparatus for interfacing project management tool and systems engineering tool
English IQ and Muda; Information quality eliminates waste

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C53 Correction of patent for invention or patent application
CB02 Change of applicant information

Address after: 250101 No. 1036 wave road, Shandong, Ji'nan

Applicant after: Langchao General Software Co., Ltd

Address before: 250014 No. 224 mountain road, Lixia District, Shandong, Ji'nan

Applicant before: Shandong Universal Software Co., Ltd., Langchao Group Corp.

CB03 Change of inventor or designer information

Inventor after: Wei Daisen

Inventor after: Wang Xiaoyan

Inventor before: Liu Qinghua

Inventor before: Wang Xiaoyan

COR Change of bibliographic data

Free format text: CORRECT: INVENTOR; FROM: LIU QINGHUA WANG XIAOYAN TO: WEI DAISEN WANG XIAOYAN

Free format text: CORRECT: APPLICANT; FROM: SHANDONG UNIVERSAL SOFTWARE CO., LTD., LANGCHAO GROUP CORP. TO: INSPUR GENERAL SOFTWARE CO., LTD.

C14 Grant of patent or utility model
GR01 Patent grant