信托投资业务管理系统的设计与实现

1………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………23456789101112131415161718192021222324ZW.MDBg_itemg_itemsg_items00g_items01g_accassg_item25g_itemcitem_id00citem_nameg_items00g_accass12iperiod112ccode261030101citem_class0001g_items00g_items01g_items00g_items0127xcel97Excel97EXCELPublicExAsExcel.ApplicationPublicExBookAsExcel.WorkbookPublicExSheetAsExcel.worksheetSetEx=CreateObject(Excel.Application)SetExBook=Ex.Workbooks().Add()SetExSheet=28ExBook.Worksheets()ExSheet.Cells(,)=ExSheet.PrintOut,,,False,0,False2930313233ABSTRACTPeoplehaveneverstoppedusingthecomputerinmuchmorecomplicatedworksincethecomputerwasborn.Insuchaway,theywouldenjoythemselves.Datebaseprovidesgoodpotentialityforprogramming,andtherefore,applicableprogramsofdatebasehaveavastspace,beingwidelyusedinmanyafieldoffinanceandtaxation,etc.,andrepresentalargescopefortheapplicationofthecomputer.Inviewofwideapplicationofthedatabasesysteminfinanceandtrustinvestment,thispaperprobesanddiscussesfurtherdevelopmentandutilizationofthedatabasesystem.Sincelong,alotoftiresomeroutineworkhavebeencompletedonamanualbasisconcerningthebusinessoftrustinvestment,fromthedeliveryoffinancialplanandinterestscalculationofdepositandloanatthebeginningofayeartothefinancialsettlementattheyearend.Thetechnicaldevelopmentofcomputerhasprovidedthepossibilityforittotreatsuchtiringroutinework.Forbetterperformanceofthecomputerinbusinessmanagementoftrustinvestment,andinordertofreefinancialworkersfromheavyroutineaccountingbusiness,enhanceworkingefficiencyandquality,makefulluseofexistingresourcesofequipment,andacceleratecombineddevelopmentofscience,technologyandeconomy,weneed34tosetuparatherperfectmanagementsystemtosatisfytheneedoftrustinvestment,i.e.,BusinessManagementSystemofTrustInvestment(hereinaftercalledSTTZ),soastoenabletrustinvestmentbusinesstograduallysteponawaytowardmodernization,automationandrealizationofscienceandtechnology.STTZisspeciallydesignedforthesectoroftrustinvestment.Itisapieceofsoftwarewithstrongprofessionalcharacteristics,mainlyincludingfundsplanningmodule;depositandloancontractmanagementmodule;depositandloaninterestscalculationmoduleandaccountsdisposalmodule,altogether,fourmodulesintotal.Thissystemcanfullysatisfythebusinessrequirementsoftheexistingtrustinvestment.DuringthedesignprocessofSTTZ,wehavepaidmuchattentiontotheuniversalpracticalityofthesoftware,friendlyinterfaceandeasiernetworktreatment,etc.Inordertomeettheneedofdifferentusers.Thissystemtreatsaccountingsubjects,evidences,booksandstatementsastheobjectives.Userscandirectlymakecompilationandconsultationaccordingtothedisplayinstructions,andalloftheparametersofstatementsandprintscanbeself-definedaccordingtotherealsituationoftheusersthemselves.Columnsneededcanbefreelysetupforfinancialreportsandstatementssoastorealizedifferentformsofoutput,timelyconsultthe35latestbalanceofeachsubject,andfullymasterthedynamictrendofthebusiness.Itistrue32bitsapplicableforWindows95/98/NT.Userscancompilenewyearplansaccordingtotheplannedorrealfiguresofthepreviousyears,controltheplanflexiblyandconveniently,andchecktheimplementationoftheplanaspermonth,quarterandyear.Theinternalcontrolofthesystemisamainmeasureforensuringthesecurityandreliabilityofthesystem,andduringthedesignprocessofthesystem,identificationofstatusandcontrolofauthorityscopehavebeenbothconsidered.Inordertoimproveworkingefficiencyandrealizecommonaccesstodatatoabigmargin,thissystemhasbeendesignedanddevelopedonnet.AguidingprinciplefirstlystressingtheapplicationofthebusinesshasbeenfollowedfromAtoZduringtheprocessofdesignandrealizationofthesystem,whichhighlightsthepracticalityofthesystem.Thesystemhasbroughtaboutnewchangestothemeasuresandprocedureofthebusinessmanagementoftrustinvestment,increasesthetransparencyofinformationqualityandmanagement,andenhancestheaccuracyofinformationandrealeffectofmanagement.36