1、系統(tǒng)集成方案基于TCP/IP協(xié)議的Zebra與EBS集成開發(fā)指導(dǎo)文檔Author:Creation Date: Last Updated:Fuliang.liuNovember 13, 2012November 13, 2012Ref:Ver:Approvals: November 13, 2012ControlChange RecordReviewersDistributionNote To Holders:If you receive an electronic copy of thisand prit out, please write yourname on the equivalen

2、t of the covage, forcontrol pures.If you receive acover, forof thiscontrol pur, please write your name on the frontes.Companyne tnroall usiei onlyCopy No.NameLocation1234NameitionDateAuthorVerChange Reference13 Nov 12Fuliang.liuDraft 1aNo PreviousNovember 13, 2012ContentsControlii簡介11.開發(fā)準(zhǔn)備22.1.開發(fā)工具2

3、開發(fā)流程32.3.開發(fā)例子(Item Label打印)4Zebra設(shè)計4PL/SQL開發(fā)8并發(fā)定義9打印測試94.5.Open and Closed Ies for this Deliverable10Open IClosed Ies10es10Companyretrrnoal l uisiei only1.簡介本文檔用于指導(dǎo)基于TCP/IP協(xié)議的Zebra集成開發(fā)。首次開發(fā)需要按照” 安裝配置.doc”配置開發(fā)環(huán)境。November 13, 20122.開發(fā)準(zhǔn)備2.1.開發(fā)工具2.1.1.ZebraDesignerurl:htdesigner.html/us/en/products-serv

4、i/software/design-software/zebra-2.1.2.PL/SQL Developer略發(fā)Fo準(zhǔn)rCompanyern2aol fu1s3e onlyNovember 13, 20123.開發(fā)流程發(fā)Fo流rern3aol fu1s3e onlyCompanyZebra與Oracle集成開發(fā)流程November 13, 20124.開發(fā)例子(Item Label打印)4.1.Zebra設(shè)計4.1.1.量取紙的規(guī)格4.1.2.打開Zebra設(shè)計器略4.1.3.設(shè)置Step1Comp開an發(fā)ybeFl打orern4aol fu1s3e only參數(shù)值屬性ZDesigner Z

5、M400 300 dpi (ZPL)規(guī)格值Width10CMHeight5CMNovember 13, 2012Step2Step3Comp開an發(fā)ybeFl打orern5aol fu1s3e only參數(shù)值寬度10高度5November 13, 2012Step4Step54.1.4.設(shè)計1. 使用設(shè)計器的, 設(shè)計樣式Comp開an發(fā)ybeFl打orern6aol fu1s3e onlyNovember 13, 20122. 動態(tài)字段用&FILEDX&預(yù)留起來, 方便后續(xù)進(jìn)行替換打印為ZPL語言4.1.5.Comp開an發(fā)ybeFl打orern7aol fu1s3e onlyNovember

6、 13, 20124.1.6.查看打印結(jié)果將紅框部分的內(nèi)容刪除后備份起來給PL/SQL使用4.2.PL/SQL開發(fā)4.2.1.創(chuàng)建PKG(cux zbr item label prpkg)使用漢得框架程序創(chuàng)建Concurrent Package: cux zbritem label prpkg4.2.2.創(chuàng)建Procedure(creaabel page)able page 過程將所有的動態(tài)數(shù)據(jù)作為參數(shù)輸入crea同時將生成ZPL作為CLOB變量輸出4.2.3.創(chuàng)建Procedure(Prlabel)將CLOB作為參數(shù)調(diào)用本框架提供的API, 將打印內(nèi)容傳遞給Zebraheb tcp pub.

7、send request(p init msg list = fnd api.g false,p commit= fnd api.g false, xx xreturn sus = x return sus,msg count= x msg count,msg data= x msg data,p function code = p function code,p req bod clob = p req bod clob, x resp bod clob = x resp bod clob, x req inst id = x req inst id,x resp inst id = x r

8、esp inst id);heb pub.raise error(x return sus);4.2.4.創(chuàng)建Procedure(Pr2zbr)將待打印的數(shù)據(jù)整理起來, 按業(yè)務(wù)數(shù)據(jù)將每張分別調(diào)用 creaabel page來創(chuàng)建頁Comp開an發(fā)ybeFl打orern8aol fu1s3e onlyNovember 13, 20124.2.5.參考代碼.codeZBR 004 Item Labelpackagecux zbr item label prpkg.pck4.3.并發(fā)定義4.3.1.定義可執(zhí)行將cux zbr item label prpkg.MAIN定義為可執(zhí)行4.3.2.定義程序

9、定義程序, 可執(zhí)行選選擇4.3.1中定義的代碼4.4.打印測試輸入?yún)?shù), 提交請求, 聽到嘟嘟, 查看格式和數(shù)據(jù)是否和預(yù)期一致Comp開an發(fā)ybeFl打orern9aol fu1s3e only最佳實踐November 13, 20125.Open and Closed Ies for this DeliverableAdd open iest you identify while writing or reviewing thisto thees sectionopen ies section. As you resolve ies, move them to the closed ian

10、d keep the ie ID the same. Include an explanation of the resolution.When this deliverable is complete, any open ies should be transferred to theproject- or pros-level Risk and Ie Log (PJM.CR.040) and managed using aproject level Risk and Ie Form (PJM.CR.040). In addition, the open items shouldremainhe open ies section of this deliverable, but flaggedhe resolutioncolumn as being transf