IFS开发培训文档(Chapter-08)

《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