欢迎来到天天文库
浏览记录
ID:40565082
大小:285.50 KB
页数:3页
时间:2019-08-04
《IFS开发培训文档(Chapter-08)》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、Title:Date:Page:Solution-Chapter082005-03-023DocumentRevisionHistoryRevisionDateByRemarksA12005-3-2HenryZhongCreatedList:Usingclassutilities1.1ModelChanges1.2StorageandBusinessLogicSolutions–Chapter08(Usingclassutilities)1、ModelChanges1.1OpentheModelandaddanewclassintheMaindiagram.Changeth
2、eclasstypetoClassUtilityandgivetheclassthenameDemoTrInvoiceUtil.1.2MethodsintheDemoTrInvoiceUtilclasswillusedatabelongingtotheDemoTrInvoiceclass,hencethedependencyrelationshipbetweenthetwoclasseswillneedafriendshipaswell.ThereforethecheckboxFriendshipRequiredinthespecificationoftherelation
3、needtobechecked.CheckBoxmustbechecked1.3NowaddapublicmethodcalledGetTotalUnpaidtotheDemoTrInvoiceUtilclass.Thismethodwillretrievethetotalvalueofunpaidinvoicesforacertaincustomer.Thereforeitneedstwoarguments.InthedetailtabofmethodspecificationsaddtheargumentsforCompanyIdoftypeStringandCusto
4、merIdoftypeNumber.3Title:Date:Page:Solution-Chapter082005-03-0231.1Themodelshouldlooklikethatfollowing.1.2Savethemodel.2StorageandBusinessLogic2.1TheUtilityclassdoesnotcontainanyattributes,butcontainonlymethods.Thereforetherearenostoragechanges.HencecanstartbyopeningthesourcecodeforDemoTrI
5、nvoiceUtilinthebusinesslogic.2.2Thefollowingsegmentofcoding,isonepossiblemethodofimplementingthemethodGet_Total_Unpaid.Note:·Oneoftheconventionsusedistouseacursorwheneveraselectstatementisneeded.AvoidusingPL/SQLproceduresinaselectstatement.Thetableisusedintheplaceoftheviewandthecolumnunpai
6、disuseddirectlyinsteadofusingtheDEMO_TR_INVOICE_API.Get_UnpaidasthesecallstoPL/SQLfromSQLwillcauseperformancedegradation.3Title:Date:Page:Solution-Chapter082005-03-0231.1Selectthefunctionandclickedit.IntheeditdialogboxthatappearsselectthelasttabcalledPRAGMA,andcheckthefirsttwooptions(WNDS-
7、WriteNoDatabaseStateandWNPS-WriteNoPackageState)toassurethesecuritysystemthatthesemethodswillnotbeupdatingthedatabase.1.2ItispossibletotestthefunctionalityofthisfunctioninaselectstatementbyusingthefollowingcodesegmentattheSQLprompt.Note:Thisexercisedoesnotrequ
此文档下载收益归作者所有