如果您无法下载资料，请参考说明：
1、部分资料下载需要金币，请确保您的账户上有足够的金币
2、已购买过的文档，再次下载不重复扣费
3、资料包下载后请先用软件解压，在使用对应软件打开
CAPITALDATAWorksCCAQSDataRetrievalModuleTechnicalDocumentLastUpdated-WednesdaySAVEDATE\@"dddd,MMMMdd,yyyy"\*MERGEFORMATWednesday,June09,20043[RevisionNumber3.0]DocumentInformationFilename:CCAQSDataRetrievalTechnicalDocumentCreated:Wednesday,November21,2001LastModified:Wednesday,February12,2003Rev#DateByDescription1.011/21/2001SeshuKavuriInitialrelease.2.002/12/2003SeshuKavuri3.006/09/2003SeshuKavuriPurposeAssiststhepeopleinunderstandtheimplementationdetailsoftheDataRetrievalapplication.Helpinmakingchanges,enhancementstotheexistingapplicationanddebugginganyerrorsinthecourseofmaintainingthesame.Thisdocumentwillnotcontainanyinformationondesignoftheapplication.Thisdocumentisratheraimedindescribingtheimplementationdetailsoftheapplication.DescriptionThemainfunctionalityofthe“DataRetrieval”moduleistoCollectthedatafilteringconditionsfromtheuserPrepareavalidsqlquerybasedonthefilteringconditionsExecutethesqlqueryandgeneratethefileintheuserspecifiedformat.(Atpresentthesupportedfileformatsarecsv,textandexcel)Storethequeryrequestandthedatafile.Informtheuserwhentheuserrequesteddatafileisready.Tocollectthefilteringconditions,userinterfaceisprovided.Theselectionboxesvaluesarepopulatedfromthe“Stat_Data_Retrieval”table.FormoreinformationoncreationofthistablereferHYPERLINK\l"Database"Databasesectionofthisdocument.Basedonuserselectionsintheselectionboxesandentriesinthetextboxes,the“GenerateQuery”methodofthequerycomponentwillcreatetheSQLquery.“ExecuteQuery”methodofhequerycomponentwillExecutethequery,generatesthefilefromthequeryresult,Updatesthecatalogtableafterthefileisgenerated,sendsrequeststatusinformationviaemail.Thismethodalsoemailstheerrorinformationtoadministratorifanyerroroccursintheprocess.FilesUsedDescriptionThefollowingfilesareusedintheDataRetrievalModule.HYPERLINK\l"DefaultAsp"Default.Asp–HomepagefortheapplicationHYPERLINK\l"Asppage1Asp"TopTable.htm–IncludepagethatcontainsMenu,andtopdesignspecifications.HYPERLINK
立即下载
