中國(guó)石油大學(xué)《Access數(shù)據(jù)庫(kù)應(yīng)用》簡(jiǎn)述窗體的功能和創(chuàng)建子窗體的兩種方法一、SQL語(yǔ)句（4小題，每題3分，共12分）1．請(qǐng)寫出以下SQL語(yǔ)句的功能：SELECTCOUNT(編號(hào))FROM職工表WHEREYEAR(NOW())-YEAR(進(jìn)廠日期)>=25答：統(tǒng)計(jì)進(jìn)廠迄今已滿25年或以上的職工人數(shù)。2．寫出相應(yīng)的SQL語(yǔ)句：查詢“sell”表中商品編碼為“A002”且進(jìn)貨時(shí)間為兩天前的記錄，并按進(jìn)貨時(shí)間“datetime”降序排序。答：SELECT*FROMSELLWHERECODE=“A002”ANDORDERBYDATETIMEDESC；3．寫出相應(yīng)的SQL語(yǔ)句：刪除“stock”表中庫(kù)存數(shù)量“amount”為空的記錄。答：DELETEFROMstockWHEREamount=NULL；4．寫出相應(yīng)的SQL語(yǔ)句：已知“借閱”表中有“借閱編號(hào)”、“學(xué)號(hào)”和“借閱圖書編號(hào)”等字段，每名學(xué)生每借閱一本書生成一條記錄，按學(xué)生學(xué)號(hào)統(tǒng)計(jì)出每名學(xué)生的借閱次數(shù)。答：SELECT學(xué)號(hào)，COUNT（學(xué)號(hào)）FROM借閱GROUPBY學(xué)號(hào)；二、簡(jiǎn)答題(每小題3分，共16題，共48分)。創(chuàng)建表的方法有哪些？答：創(chuàng)建表有三種方法：使用向?qū)?、使用通過輸入數(shù)據(jù)創(chuàng)建表和使用表設(shè)計(jì)器。什么是查詢？查詢有哪些類型？答：查詢就是以數(shù)據(jù)庫(kù)中的數(shù)據(jù)作為數(shù)據(jù)源，根據(jù)給定的條件，從指定的數(shù)據(jù)庫(kù)的表或查詢中檢索出用戶要求的記錄數(shù)據(jù)，形成一個(gè)新的數(shù)據(jù)集合。ACCESS提供了5種類型的查詢，包括選擇查詢、參數(shù)查詢、交叉表查詢、操作查詢和SQL查詢。3．簡(jiǎn)述窗體的功能和創(chuàng)建子窗體的兩種方法：答：窗體是主要用于輸入和顯示數(shù)據(jù)的數(shù)據(jù)庫(kù)對(duì)象，也可以將窗體用作切換面板來(lái)打開數(shù)據(jù)庫(kù)中的其他窗體和報(bào)表，或者用作自定義對(duì)話框來(lái)接收輸入及根據(jù)輸入執(zhí)行操作。窗體是一個(gè)組合式的對(duì)象，也就是說(shuō)用戶可以根據(jù)自己的需要在窗體中增加相應(yīng)的控件，并定義其外觀、行為和位置等。一種是同時(shí)創(chuàng)建主窗體和子窗體；另一種方法是將已有的窗體添加到另一個(gè)窗體中，創(chuàng)建帶有子窗體的主窗體4．Access2007數(shù)據(jù)庫(kù)的對(duì)象包括哪些？并描述其中任意2個(gè)對(duì)象的功能。答：表、查詢、窗體、報(bào)表、宏、模塊數(shù)據(jù)表是存放數(shù)據(jù)的地方，是數(shù)據(jù)庫(kù)最基本的組成部分，也是其他對(duì)象的數(shù)據(jù)庫(kù)源。查詢就是根據(jù)一定的查詢條件對(duì)數(shù)據(jù)庫(kù)中的數(shù)據(jù)進(jìn)行查找的一種操作。5．描述下列這段代碼完成的功能DimsNameAsIntegerDimiResponseAsIntegersName=“”DoWhilesName=“” sName=InputBox(“請(qǐng)輸入您的名字：”) IfsName=“”Then iResponse=msgBox(“想退出嗎？”,vbYesNo)IfiResponse=vbYesThen ExitDoEndIfEndIfLoop答：在程序運(yùn)行時(shí)提示輸入名字，直到輸入了名字或選擇退出才結(jié)束執(zhí)行的。6．現(xiàn)有某查詢?cè)O(shè)計(jì)視圖（如下圖所示），請(qǐng)描述該查詢的含義。答：身高在160以上的女性和所有的男性7．?dāng)?shù)據(jù)庫(kù)和數(shù)據(jù)庫(kù)管理系統(tǒng)的區(qū)別。答：數(shù)據(jù)庫(kù)：是實(shí)體，只是一些數(shù)據(jù)的集合數(shù)據(jù)庫(kù)管理系統(tǒng)：主要負(fù)責(zé)對(duì)數(shù)據(jù)庫(kù)進(jìn)行統(tǒng)一的管理和控制。Access2007就是一種數(shù)據(jù)庫(kù)管理系統(tǒng)。8．什么是操作查詢？操作查詢有哪些類型？答：在一次操作中更改許多記錄的查詢稱為操作查詢。操作查詢又可分為4種類型：刪除查詢、更新查詢、追加查詢和生成表查詢。9．什么是SQL查詢？SQL查詢有哪些類型？答：用戶使用SQL語(yǔ)句創(chuàng)建的查詢被稱為SQL查詢。SQL查詢又可分為4種類型：聯(lián)合查詢、傳遞查詢、數(shù)據(jù)定義查詢和SQL子查詢等。10．什么是數(shù)據(jù)表？創(chuàng)建數(shù)據(jù)表的步驟？答：數(shù)據(jù)表是存放數(shù)據(jù)的地方，是數(shù)據(jù)庫(kù)最基本的組成部分，也是其他對(duì)象的數(shù)據(jù)庫(kù)源。創(chuàng)建表的操作步驟如下：創(chuàng)建新表。切換到“創(chuàng)建”標(biāo)簽，單擊“表”按鈕產(chǎn)生空白表；進(jìn)入設(shè)計(jì)視圖，設(shè)置字段的名稱，選擇數(shù)據(jù)類型，設(shè)置字段大小。設(shè)置字段的屬性設(shè)置索引和主鍵單擊“保存”按鈕，存儲(chǔ)表11．窗體、模塊各自的功用？答：窗體是主要用于輸入和顯示數(shù)據(jù)的數(shù)據(jù)庫(kù)對(duì)象，也可以將窗體用作切換面板來(lái)打開數(shù)據(jù)庫(kù)中的其他窗體和報(bào)表，或者用作自定義對(duì)話框來(lái)接收輸入及根據(jù)輸入執(zhí)行操作。模塊作為Access數(shù)據(jù)庫(kù)中的一個(gè)重要對(duì)象，它是將VBA聲明、表達(dá)式和程序作為一個(gè)單元進(jìn)行保存的集合。12．過程與函數(shù)的區(qū)別答：過程和函數(shù)就是指能夠執(zhí)行特定功能的語(yǔ)句塊，都是為編寫程序而服務(wù)的。但是它們之間是有區(qū)別的。過程是VBA代碼的一個(gè)單元，它包括一系列用于執(zhí)行某個(gè)任務(wù)或是進(jìn)行某種計(jì)算的語(yǔ)句。過程只執(zhí)行一個(gè)或多個(gè)操作，沒有返回值。函數(shù)其實(shí)也是過程，不過它是一種特殊的、能夠返回具體值的過程，返回的值通常是計(jì)算的結(jié)果或測(cè)試的結(jié)果，能夠在表達(dá)式中使用。13．簡(jiǎn)述宏和宏組的基本功能。答：宏就是一個(gè)或多個(gè)操作的集合，其中的每個(gè)操作都能夠?qū)崿F(xiàn)特定的功能。宏組是指在一個(gè)宏單中包括多個(gè)宏。其中不同的宏使用不同的宏名。宏組是一個(gè)組織宏的好辦法，通常將一個(gè)窗體或報(bào)表中的所有宏放在一個(gè)宏組中，這樣就可以很容易地找到特定表單中的所有宏。14．Access2007的導(dǎo)入數(shù)據(jù)是指什么？可以導(dǎo)入的文件類型有哪些？答：導(dǎo)入數(shù)據(jù)就是將外部數(shù)據(jù)導(dǎo)入到Access表中。Access2007數(shù)據(jù)庫(kù)中可以加導(dǎo)入的文件類型有很多，如dBASE文件、Excel文件、HTML及XML文件、文本文件、ODBC數(shù)據(jù)庫(kù)文件等。

15．在窗體中，組合框與列表框有何主要區(qū)別？答：組合框：有彈出式值列表，可以進(jìn)行添加。列表框：有個(gè)彈出式值列表，但不能進(jìn)行添加。16．報(bào)表與窗體的聯(lián)系和區(qū)別？答：報(bào)表是專門為打印而設(shè)計(jì)的特殊窗體，Access2007中使用報(bào)表對(duì)象來(lái)實(shí)現(xiàn)打印格式數(shù)據(jù)功能，將數(shù)據(jù)庫(kù)中的表、查詢的數(shù)據(jù)進(jìn)行組合，形成報(bào)表，還可以在報(bào)表中添加多級(jí)匯總、統(tǒng)計(jì)比較、圖片和圖表等。窗體最終顯示在屏幕上，而報(bào)表還可以打印出來(lái)；窗體可以與用戶進(jìn)行信息交互，而報(bào)表沒有交互功能。本章將介紹與報(bào)表設(shè)計(jì)相關(guān)的知識(shí)。三、課程設(shè)計(jì)（1題，共40分）請(qǐng)結(jié)合自身工作中涉及的場(chǎng)景，設(shè)計(jì)一個(gè)小型的數(shù)據(jù)庫(kù)管理系統(tǒng)，使用Access2007或其它數(shù)據(jù)庫(kù)管理軟件實(shí)現(xiàn)。三、要求課程設(shè)計(jì)的要求如下：提交的課程設(shè)計(jì)包括2部分：第一部分為設(shè)計(jì)實(shí)現(xiàn)的數(shù)據(jù)庫(kù)文件（20分），第二部分為設(shè)計(jì)文檔說(shuō)明（20分），具體至少包括以下內(nèi)容：給出需求描述；（3分）給出數(shù)據(jù)庫(kù)表表格描述，至少包括2張表，并給出一個(gè)表格的創(chuàng)建步驟；（3分）3．給出創(chuàng)建查詢的功能描述，至少包括2個(gè)查詢，并給出一個(gè)查詢的創(chuàng)建步驟；（3分）4．給出創(chuàng)建窗體的功能描述，窗體上要用到至少3種類型的控件，并給出創(chuàng)建窗體的步驟；（3分）5．創(chuàng)建報(bào)表2-3個(gè)報(bào)表，并給出創(chuàng)建一個(gè)報(bào)表的步驟；（3分）6．使用宏創(chuàng)建窗體，創(chuàng)建宏把前面創(chuàng)建的查詢、窗體和報(bào)表全部整合到一個(gè)主窗體上，單擊該窗體上的某個(gè)命令按鈕時(shí)，宏就可以自動(dòng)執(zhí)行并完成所要做的工作，給出創(chuàng)建一個(gè)宏的步驟。（3分）答：總述：本課程設(shè)計(jì)是設(shè)計(jì)一個(gè)記錄事件提醒類的數(shù)據(jù)庫(kù)。本課程設(shè)計(jì)使用sqlite數(shù)據(jù)庫(kù)，結(jié)合NavicatPremiun輔助查詢；本課程設(shè)計(jì)包含的表：事件列表（t_event）；事件進(jìn)展列表(t_eventprogress)；事件收支類型列表(t_inoutcomemanage)；用戶信息表(t_user)；完成它們需要4個(gè)表（它們作為一個(gè)關(guān)系數(shù)據(jù)庫(kù)設(shè)計(jì)的組成部分緊密關(guān)聯(lián)）。以下給出每個(gè)表的描述。表的描述：t_event（事件列表）t_event表用于存儲(chǔ)事件；每個(gè)事件都有一條記錄與之對(duì)應(yīng)。表1t_event表的列列說(shuō)明event_id事件IDuser_id用戶IDevent_name事件名稱event_purpose事件目的event_classify事件分類event_state事件狀態(tài)event_createtime事件創(chuàng)建時(shí)間event_endtime事件結(jié)束時(shí)間所有表都應(yīng)該有主鍵，這個(gè)表應(yīng)該用event_id作為它的主鍵。2、t_eventprogress（事件進(jìn)展列表）t_eventprogress表用于存儲(chǔ)每一個(gè)事件對(duì)應(yīng)的所有的事件進(jìn)展，每一條事件進(jìn)展都對(duì)應(yīng)一條記錄。表2t_eventprogress表的列列說(shuō)明progress_id事件進(jìn)展IDuser_id用戶IDevent_id事件IDprogress_desc事件進(jìn)展描述is_voice是否是語(yǔ)音描述is_recordMoney是否記錄金額is_remind是否設(shè)置事件進(jìn)展提醒images事件進(jìn)展圖片payment事件進(jìn)展收支come_category事件進(jìn)展收支分類reminding_cycle事件進(jìn)展設(shè)置循環(huán)提醒周期week每周定時(shí)date每月定時(shí)bell響鈴名稱bell_time響鈴時(shí)間pregress_createtime事件進(jìn)展創(chuàng)建時(shí)間所有表都應(yīng)該有主鍵，這個(gè)表應(yīng)該用progress_id作為它的主鍵。3、t_inoutcomemanage(事件收支類型列表)t_inoutcomemanage表用于存儲(chǔ)事件收支類型名稱，每一個(gè)收支類型都對(duì)應(yīng)一條記錄。表3t_inoutcomemanage表的列列說(shuō)明inoutcome_id收支類型IDuser_id用戶IDlogo收支類型圖標(biāo)itemname收支類型條目total_money此收支類型的總錢數(shù)year_money此收支類型的年度總錢數(shù)month_money此收支類型的月度總錢數(shù)flag是否是收入類型所有表都應(yīng)該有主鍵，這個(gè)表應(yīng)該用inoutcome_id作為它的主鍵。4、t_user(用戶信息表)t_user表用于存儲(chǔ)用戶信息，每一個(gè)用戶都對(duì)應(yīng)一條記錄。表4t_user表的列列說(shuō)明user_id用戶IDuser_name用戶昵稱account用戶賬號(hào)password用戶密碼image用戶頭像tel用戶電話mail用戶郵箱所有表都應(yīng)該有主鍵，這個(gè)表應(yīng)該用user_id作為它的主鍵。數(shù)據(jù)的查詢：1、/**獲取事件列表*/+(void)getHomePageEventListWithPostDict:(NSDictionary*)postDictsuccessed:(RequestSuccessed)successedfailed:(RequestFailed)failed;/**獲取事件列表*/+(void)getHomePageEventListWithPostDict:(NSDictionary*)postDictsuccessed:(RequestSuccessed)successedfailed:(RequestFailed)failed{NSString*user_id=postDict[@"user_id"];FMDatabaseQueue*queue=[XMFMDBManagershareDatabaseQueue];__blockBOOLisSuccess=NO;NSMutableArray*eventListArray=[NSMutableArrayarray];[queueinDatabase:^(FMDatabase*_Nonnulldb){[dbexecuteUpdate:@"begintransaction;"];FMResultSet*rs=[dbexecuteQuery:@"selectevent_id,event_name,event_state,event_createtime,event_purpose,event_classifyfromt_eventwhereuser_id=?andevent_statein(1,3)orderbyevent_createtimedesc",user_id];while(rs.next){NSMutableDictionary*dict=[NSMutableDictionarydictionary];[dictsetObject:[XMCommonToolisNullToString:[rsstringForColumn:@"event_id"]]forKey:@"event_id"];[dictsetObject:[XMCommonToolisNullToString:[rsstringForColumn:@"event_name"]]forKey:@"event_name"];[dictsetObject:[XMCommonToolisNullToString:[rsstringForColumn:@"event_state"]]forKey:@"event_state"];[dictsetObject:[XMCommonToolisNullToString:[rsstringForColumn:@"event_createtime"]]forKey:@"event_createtime"];[dictsetObject:[XMCommonToolisNullToString:[rsstringForColumn:@"event_classify"]]forKey:@"event_classify"];[dictsetObject:[XMCommonToolisNullToString:[rsstringForColumn:@"event_purpose"]]forKey:@"event_purpose"];[eventListArrayaddObject:dict];}[rsclose];isSuccess=[dbexecuteUpdate:@"committransaction;"];}];NSMutableArray*resultArray=[NSMutableArrayarray];for(NSDictionary*eventDictineventListArray){NSMutableDictionary*resultDict=[NSMutableDictionarydictionary];NSMutableArray*progressArray=[NSMutableArrayarray];[queueinDatabase:^(FMDatabase*_Nonnulldb){[dbexecuteUpdate:@"begintransaction;"];FMResultSet*rs=[dbexecuteQuery:@"selectis_voice,progress_desc,is_remindfromt_eventprogresswhereuser_id=?andevent_id=?orderbyprogress_createtimedesc",user_id,eventDict[@"event_id"]];while(rs.next){NSMutableDictionary*dict=[NSMutableDictionarydictionary];[dictsetObject:[XMCommonToolisNullToString:[rsstringForColumn:@"is_voice"]]forKey:@"is_voice"];[dictsetObject:[XMCommonToolisNullToString:[rsstringForColumn:@"progress_desc"]]forKey:@"progress_desc"];[dictsetObject:[XMCommonToolisNullToString:[rsstringForColumn:@"is_remind"]]forKey:@"is_remind"];[progressArrayaddObject:dict];}[rsclose];isSuccess=[dbexecuteUpdate:@"committransaction;"];}];[resultDictaddEntriesFromDictionary:eventDict];NSDictionary*progressDict=[progressArrayfirstObject];[resultDictaddEntriesFromDictionary:progressDict];[resultArrayaddObject:resultDict];}if(isSuccess){//errCode=0，成功NSMutableDictionary*successDict=[NSMutableDictionarydictionary];[successDictsetObject:@"0"forKey:@"errCode"];[successDictsetObject:resultArrayforKey:@"data"];successed(successDict);}else{NSMutableDictionary*successDict=[NSMutableDictionarydictionary];[successDictsetObject:@"1"forKey:@"errCode"];successed(successDict);}}2、/**獲取進(jìn)展列表*/+(void)getEventProgressListWithPostDict:(NSDictionary*)postDictsuccessed:(RequestSuccessed)successedfailed:(RequestFailed)failed;/**獲取進(jìn)展列表*/+(void)getEventProgressListWithPostDict:(NSDictionary*)postDictsuccessed:(RequestSuccessed)successedfailed:(RequestFailed)failed{NSString*user_id=postDict[@"user_id"];NSString*event_id=postDict[@"event_id"];FMDatabaseQueue*queue=[XMFMDBManagershareDatabaseQueue];__blockBOOLisSuccess=NO;NSMutableArray*progressListArray=[NSMutableArrayarray];[queueinDatabase:^(FMDatabase*_Nonnulldb){[dbexecuteUpdate:@"begintransaction;"];FMResultSet*rs=[dbexecuteQuery:@"selectprogress_id,progress_createtime,is_remind,progress_desc,payment,is_voice,come_categoryfromt_eventprogresswhereuser_id=?andevent_id=?orderbyprogress_createtimedesc",user_id,event_id];while(rs.next){NSMutableDictionary*dict=[NSMutableDictionarydictionary];[dictsetObject:[XMCommonToolisNullToString:[rsstringForColumn:@"progress_id"]]forKey:@"progress_id"];[dictsetObject:[XMCommonToolisNullToString:[rsstringForColumn:@"progress_createtime"]]forKey:@"progress_createtime"];[dictsetObject:[XMCommonToolisNullToString:[rsstringForColumn:@"is_remind"]]forKey:@"is_remind"];[dictsetObject:[XMCommonToolisNullToString:[rsstringForColumn:@"progress_desc"]]forKey:@"progress_desc"];[dictsetObject:[XMCommonToolisNullToString:[rsstringForColumn:@"payment"]]forKey:@"payment"];[dictsetObject:[XMCommonToolisNullToString:[rsstringForColumn:@"is_voice"]]forKey:@"is_voice"];[dictsetObject:[XMCommonToolisNullToString:[rsstringForColumn:@"come_category"]]forKey:@"come_category"];[progressListArrayaddObject:dict];}[rsclose];isSuccess=[dbexecuteUpdate:@"committransaction;"];}];if(isSuccess){//errCode=0，成功NSMutableDictionary*successDict=[NSMutableDictionarydictionary];[successDictsetObject:@"0"forKey:@"errCode"];[successDictsetObject:progressListArrayforKey:@"data"];successed(successDict);}else{NSMutableDictionary*successDict=[NSMutableDictionarydictionary];[successDictsetObject:@"1"forKey:@"errCode"];successed(successDict);}}3、/**添加事件和進(jìn)展*/+(void)addEventAndEventProgressWithPostDict:(NSDictionary*)postDictsuccessed:(RequestSuccessed)successedfailed:(RequestFailed)failed;/**添加事件和進(jìn)展*/+(void)addEventAndEventProgressWithPostDict:(NSDictionary*)postDictsuccessed:(RequestSuccessed)successedfailed:(RequestFailed)failed{//事件NSString*user_id=postDict[@"user_id"];NSString*event_name=postDict[@"event_name"];NSString*event_purpose=postDict[@"event_purpose"];NSString*event_classify=postDict[@"event_classify"];NSString*event_state=postDict[@"event_state"];//進(jìn)展NSString*progress_desc=postDict[@"progress_desc"];NSString*is_voice=postDict[@"is_voice"];NSString*is_recordMoney=postDict[@"is_recordMoney"];NSString*is_remind=postDict[@"is_remind"];NSString*images=postDict[@"images"];NSString*payment=postDict[@"payment"];NSString*come_category=postDict[@"come_category"];NSString*first_category=postDict[@"first_category"];NSString*reminding_cycle=postDict[@"reminding_cycle"];NSString*week=postDict[@"week"];NSString*date=postDict[@"date"];NSString*bell=postDict[@"bell"];NSString*bell_time=postDict[@"bell_time"];FMDatabaseQueue*queue=[XMFMDBManagershareDatabaseQueue];__blockBOOLisSuccess=NO;NSString*event_id=[XMCommonToolgetUUID];NSString*progress_id=[XMCommonToolgetUUID];[queueinDatabase:^(FMDatabase*_Nonnulldb){[dbexecuteUpdate:@"begintransaction;"];[dbexecuteUpdate:@"insertintot_event(event_id,user_id,event_name,event_purpose,event_classify,event_state,event_createtime)values(?,?,?,?,?,?,datetime('now','localtime'));",event_id,user_id,event_name,event_purpose,event_classify,event_state];[dbexecuteUpdate:@"insertintot_eventprogress(progress_id,user_id,event_id,progress_desc,is_voice,is_recordMoney,is_remind,images,payment,come_category,first_category,reminding_cycle,week,date,bell,bell_time,progress_createtime)values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,datetime('now','localtime'));",progress_id,user_id,event_id,progress_desc,is_voice,is_recordMoney,is_remind,images,payment,come_category,first_category,reminding_cycle,week,date,bell,bell_time];isSuccess=[dbexecuteUpdate:@"committransaction;"];}];if(isSuccess){//errCode=0，成功NSMutableDictionary*successDict=[NSMutableDictionarydictionary];[successDictsetObject:@"0"forKey:@"errCode"];//NSMutableDictionary*notiDict=[NSMutableDictionarydictionary];[notiDictaddEntriesFromDictionary:postDict];[notiDictsetObject:event_idforKey:@"event_id"];[notiDictsetObject:progress_idforKey:@"progress_id"];[selfaddLocalAlarmNotificationWith:notiDict];successed(successDict);}else{NSMutableDictionary*successDict=[NSMutableDictionarydictionary];[successDictsetObject:@"1"forKey:@"errCode"];successed(successDict);}}4、/**獲取事件詳情*/+(void)getEventDetailWithPostDict:(NSDictionary*)postDictsuccessed:(RequestSuccessed)successedfailed:(RequestFailed)failed;/**獲取事件詳情*/+(void)getEventDetailWithPostDict:(NSDictionary*)postDictsuccessed:(RequestSuccessed)successedfailed:(RequestFailed)failed{NSString*user_id=postDict[@"user_id"];NSString*event_id=postDict[@"event_id"];FMDatabaseQueue*queue=[XMFMDBManagershareDatabaseQueue];__blockBOOLisSuccess=NO;NSMutableArray*eventDetailArray=[NSMutableArrayarray];[queueinDatabase:^(FMDatabase*_Nonnulldb){[dbexecuteUpdate:@"begintransaction;"];//FMResultSet*rs=[dbexecuteQuery:@"selectevent_state,event_createtime,event_classify,(selectsum(payment)fromt_eventprogresswhereevent_id=?anduser_id=?)astotal_moneyfromt_eventwhereevent_id=?anduser_id=?",event_id,user_id,event_id,user_id];FMResultSet*rs=[dbexecuteQuery:@"selectevent_state,event_createtime,event_classify,(selectsum(payment)fromt_eventprogresswhereevent_id=?anduser_id=?and(come_category='借入'ORcome_category='收入'))asadd_money,(selectsum(payment)fromt_eventprogresswhereevent_id=?anduser_id=?and(come_category='借出'ORcome_category='支出'))asreduce_moneyfromt_eventwhereevent_id=?anduser_id=?",event_id,user_id,event_id,user_id,event_id,user_id];while(rs.next){NSMutableDictionary*dict=[NSMutableDictionarydictionary];[dictsetObject:[XMCommonToolisNullToString:[rsstringForColumn:@"event_state"]]forKey:@"event_state"];[dictsetObject:[XMCommonToolisNullToString:[rsstringForColumn:@"event_createtime"]]forKey:@"event_createtime"];[dictsetObject:[XMCommonToolisNullToString:[rsstringForColumn:@"event_classify"]]forKey:@"event_classify"];NSString*add_money=[XMCommonToolisNullToString:[rsstringForColumn:@"add_money"]];NSString*reduce_money=[XMCommonToolisNullToString:[rsstringForColumn:@"reduce_money"]];NSIntegertotal=add_egerValue-reduce_egerValue;NSString*total_money=[NSStringstringWithFormat:@"%ld",(long)total];[dictsetObject:total_moneyforKey:@"total_money"];[eventDetailArrayaddObject:dict];}[rsclose];isSuccess=[dbexecuteUpdate:@"committransaction;"];}];if(isSuccess){//errCode=0，成功NSDictionary*returnDict=[eventDetailArrayfirstObject];NSMutableDictionary*successDict=[NSMutableDictionarydictionary];[successDictsetObject:@"0"forKey:@"errCode"];[successDictsetObject:returnDictforKey:@"data"];successed(successDict);}else{NSMutableDictionary*successDict=[NSMutableDictionarydictionary];[successDictsetObject:@"1"forKey:@"errCode"];successed(successDict);}}5、/**添加進(jìn)展*/+(void)addEventProgressWithPostDict:(NSDictionary*)postDictsuccessed:(RequestSuccessed)successedfailed:(RequestFailed)failed;/**添加進(jìn)展*/+(void)addEventProgressWithPostDict:(NSDictionary*)postDictsuccessed:(RequestSuccessed)successedfailed:(RequestFailed)failed{NSString*user_id=postDict[@"user_id"];NSString*event_id=postDict[@"event_id"];NSString*event_name=postDict[@"event_name"];//進(jìn)展NSString*progress_desc=postDict[@"progress_desc"];NSString*is_voice=postDict[@"is_voice"];NSString*is_recordMoney=postDict[@"is_recordMoney"];NSString*is_remind=postDict[@"is_remind"];NSString*images=postDict[@"images"];NSString*payment=postDict[@"payment"];NSString*come_category=postDict[@"come_category"];NSString*first_category=postDict[@"first_category"];NSString*reminding_cycle=postDict[@"reminding_cycle"];NSString*week=postDict[@"week"];NSString*date=postDict[@"date"];NSString*bell=postDict[@"bell"];NSString*bell_time=postDict[@"bell_time"];FMDatabaseQueue*queue=[XMFMDBManagershareDatabaseQueue];__blockBOOLisSuccess=NO;NSString*progress_id=[XMCommonToolgetUUID];[queueinDatabase:^(FMDatabase*_Nonnulldb){[dbexecuteUpdate:@"begintransaction;"];[dbexecuteUpdate:@"insertintot_eventprogress(progress_id,user_id,event_id,progress_desc,is_voice,is_recordMoney,is_remind,images,payment,come_category,first_category,reminding_cycle,week,date,bell,bell_time,progress_createtime)values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,datetime('now','localtime'));",progress_id,user_id,event_id,progress_desc,is_voice,is_recordMoney,is_remind,images,payment,come_category,first_category,reminding_cycle,week,date,bell,bell_time];isSuccess=[dbexecuteUpdate:@"committransaction;"];}];if(isSuccess){//errCode=0，成功NSMutableDictionary*successDict=[NSMutableDictionarydictionary];[successDictsetObject:@"0"forKey:@"errCode"];NSMutableDictionary*notiDict=[NSMutableDictionarydictionary];[notiDictaddEntriesFromDictionary:postDict];[notiDictsetObject:event_idforKey:@"event_id"];[notiDictsetObject:progress_idforKey:@"progress_id"];[notiDictsetObject:event_nameforKey:@"event_name"];[selfaddLocalAlarmNotificationWith:notiDict];successed(successDict);}else{NSMutableDictionary*successDict=[NSMutableDictionarydictionary];[successDictsetObject:@"1"forKey:@"errCode"];successed(successDict);}}6、/**獲取進(jìn)展詳情*/+(void)getEventProgressDetailWithPostDict:(NSDictionary*)postDictsuccessed:(RequestSuccessed)successedfailed:(RequestFailed)failed;/**獲取進(jìn)展詳情*/+(void)getEventProgressDetailWithPostDict:(NSDictionary*)postDictsuccessed:(RequestSuccessed)successedfailed:(RequestFailed)failed{NSString*user_id=postDict[@"user_id"];NSString*event_id=postDict[@"event_id"];NSString*progress_id=postDict[@"progress_id"];FMDatabaseQueue*queue=[XMFMDBManagershareDatabaseQueue];__blockBOOLisSuccess=NO;NSMutableArray*progressArray=[NSMutableArrayarray];[queueinDatabase:^(FMDatabase*_Nonnulldb){[dbexecuteUpdate:@"begintransaction;"];FMResultSet*rs=[dbexecuteQuery:@"selectprogress_desc,is_voice,is_recordMoney,is_remind,images,payment,come_category,first_category,reminding_cycle,week,date,bell,bell_time,progress_createtimefromt_eventprogresswhereevent_id=?anduser_id=?andprogress_id=?",event_id,user_id,progress_id];while(rs.next){NSMutableDictionary*dict=[NSMutableDictionarydictionary];[d