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.