Summary of the invention
The object of this invention is to provide a kind of general quality inspection management software interface method.The present invention completes the configuration in inspection source by the foundation document allocation list of originating, set up the intermediate information exchange of quality inspection result middle table finishing service system homogenous quantities checking information, process the inside of corresponding middle table data and access interface realizes by unified routine processes assembly, thereby realizing assembly is all transparent operations to operation system and Quality Inspection System, can complete fast and in any business procedure, incorporate quality inspection processing procedure, change the mode of in the past by code layer, business module homogenous quantities inspection module being carried out to interface processing, also avoided having brought because code layer realizes interface the difficulty of software upgrading maintenance work.
The object of the invention is to realize in the following manner,
For in ERP, quality inspection being unified to software processing mode, complete all kinds of quality of service checkout procedures by the configuration of interface and carry out software processing, in interface, originate no more than three identification parameters for basis by setting business, set up inspection interface table, and realize unified interface routine assembly, interface provides the definition of unified test stage and processes, the seamless connection with many service link disposal systems of ERP to the inspection management software of different industries by interface finished surface, and interface configuration step is as follows:
1) set up inspection bill source table, in table, record every kind of inspection and come the business paper configuration information of Source Type, comprise the whether parameter of strict service control of inspection, check and in each process, business information is returned to sql or the storing process stepped on and configure;
2) set up inspection interface middle table, data interaction basis as operation system with checking system, in interface table, indicate business source-information, source mark one, source mark two, source mark three, according to different business sources, adopt one to three mark, meet the business processing that runs into various needs inspections in ERP;
3), by receiving the call parameters of operation system, demonstration please be tested interface and carry out the manual confirmation of partial information, please test the information that successfully forms afterwards inspection interface middle table, repeatedly please test finally please test and be as the criterion;
4) be provided in checkout procedure, inspection content being carried out the interface processing of write-back, form and unifiedly checks timely progress chasing information table, facilitate calling service place to obtain in time inspection progress msg;
5) inspected, come SQL that Source Type configures or storing process by inspection, realized unified assay feedback processing, in processing, passed to the corresponding object information parameter of SQL, source document identification parameter by interface module;
6) provide and show that assay assembly, a kind of situation carry out checking without subsequent treatment, another situation has the results verification of subsequent treatment;
Interface specifically uses step as follows:
1) carry out initial configuration
A. initialization document types table: ZJDJLX, sets up a registration data relevant to quality inspection by this table, configures corresponding sql simultaneously;
B. initialization condition judgement table: ZJTJ, this table also can be set up in the time 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
Ls_qydh=dw_master.getitemstring (1, ' zjqyd1_sjdh ') // take out the document numbering that need to transmit, may have multiple;
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 to assignment
Lnv_scqyd.is_qybm=dw_master.getitemstring (1, ' zjqyd1_bmbh1 ') // Qing Yan 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 ') // 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 ') // 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) show call by result 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) 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) be corresponding object function below;
// initialization function must call initialization function before calling other function;
//Returns: (INTEGER) 1 success ,-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
//Returns:(INTEGER) 1 success ,-1 failure, 0 without quality inspection, and 9 are cancelled;
integer of_gen_qyd(n_zj_gen_qyd_stru anv_data)
// obtain assay, for program;
//Returns:(INTEGER)-1 failure, 0 does not also have quality inspection result available, and 1 successfully returns results, and 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, user may modify to result;
integer of_show_result()
// carry out further processing according to assay;
//Returns:(INTEGER) 1 be updated successfully ,-1 upgrades unsuccessfully;
integer of_use_result(boolean ab_use)
// in the process of further processing, carry out write-back for the situation that goes out warehouse-in;
//Returns:(INTEGER) 1 success ,-1 failure;
integer of_write_kc(decimal aa_hgsl,decimal ad_bhgsl)
// whether need quality inspection, call in program circuit;
//Returns:(INTEGER) the 1st,, 0 is no, and-1 makes mistakes
integer of_need_zj()
Main program assembly:
Main object: n_cst zj_interface
Realization please be tested processing, comprises parametric test, repeatedly the content such as please test;
Realizing assay checks;
Realization has inspected subsequent treatment;
Realize the cura generalis work to quality inspection interface table (ZJJGB), comprise the same operation system of insertion, renewal and data of data, same to checking system;
Please test interface: w_zj_resp_interface_scqyd
Demonstration please be tested interface;
Realize the operation to amendment part side information;
Assay display interface: w_zj_resp_interface_zjjg
According to parameter display assay.
Of the present invention have function and a beneficial effect
1. realize the software implementation management interface of different service link inspections.
2. can complete and please test processing, assay processing by interface.
3. can realize in ERP and research and develop different inspection management software towards different industries, and carry out seamless integrated with operation system by interface.
4. by using this interfacing can realize the software systems that possess good work compound effect, realize organically blending of material flow swivel link and test stage, when work compound is raised the efficiency, realize in the lump the control that business procedure is subject to checkout procedure, effectively realized the specification of operation flow.
5. the program structure that can effectively simplify ERP software by this technology, is conducive to software maintenance and upgrading.
Embodiment
With reference to Figure of description, interface method of the present invention is described in detail below.
A kind of general quality inspection management software interface method of the present invention, specifically uses step as follows:
1.) carry out initial configuration.
A. initialization document types table: ZJDJLX, sets up a registration data relevant to quality inspection by this table, configures corresponding sql simultaneously.
B. initialization condition judgement table: ZJTJ, this table also can be set up in the time 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.
Is_qydh=dw_master.getitemstring (1, ' zjqyd1_sjdh ') // taking-up needs the document numbering of transmitting, and may have multiple.
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 to assignment.
Lnv_scqyd.is_qybm=dw_master.getitemstring (1, ' zjqyd1_bmbh1 ') // Qing Yan 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 ') // 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 ') // 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.) show call by result 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.) 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.) be corresponding object function below.(rreturn value of all functions as for-1 represent make mistakes)
// initialization function.Before calling other function, must call initialization function.
//Returns: (INTEGER) 1 success ,-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
//Returns:(INTEGER) 1 success ,-1 failure, 0 without quality inspection, and 9 are cancelled
integer of_gen_qyd(n_zj_gen_qyd_stru anv_data)
// obtain assay.For program.
//Returns:(INTEGER)-1 failure, 0 does not also have quality inspection result available, and 1 successfully returns results, and 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, user may modify to result.
integer of_show_result()
// carry out further processing according to assay.
//Returns: (INTEGER) 1 be updated successfully ,-1 upgrades unsuccessfully
integer of_use_result(boolean ab_use)
// in the process of further processing, carry out write-back for the situation that goes out warehouse-in.
//Returns: (INTEGER) 1 success ,-1 failure
integer of_write_kc(decimal ad_hgsl,decimal ad_bhgsl)
// whether need quality inspection, call in program circuit.
//Returns: (INTEGER) 1 is, 0 is no, and-1 makes mistakes.
integer of_need_zj()
Main program assembly:
Main object: n_cst_zj_interface
Realization please be tested processing, comprises parametric test, repeatedly the content such as please test.
Realizing assay checks.
Realization has inspected subsequent treatment.
Realize the cura generalis work to quality inspection interface table (ZJJGB), comprise the same operation system of insertion, renewal and data of data, same to checking system.
Please test interface: w_zj_resp_interface_scqyd
Demonstration please be tested interface.
Realize the operation to amendment part side information.
Assay display interface: w_zj_resp_interface_zjjg
According to parameter display assay.