【導(dǎo)讀】它已進(jìn)入人類(lèi)社會(huì)的各個(gè)領(lǐng)域并發(fā)揮著越來(lái)越重要的作用。的內(nèi)容不論對(duì)于媒介和商家的管理者，還是對(duì)于用戶(hù)來(lái)說(shuō)都至關(guān)重要。像、客戶(hù)的新增以及相關(guān)數(shù)據(jù)的統(tǒng)計(jì)、查詢(xún)、修改等音像租借管理的全過(guò)程的工作。時(shí)分為會(huì)員租賃與零租以方便管理?？傊撓到y(tǒng)對(duì)音像制品的租賃管理實(shí)現(xiàn)了規(guī)范化，非常適合于中小型音像租賃店的日常工作管理。本系統(tǒng)具有界面清晰、操作簡(jiǎn)易、存儲(chǔ)數(shù)據(jù)安全性高等特點(diǎn)，考慮。款針對(duì)中小音像租賃店設(shè)計(jì)的程序。中競(jìng)爭(zhēng)的力量，這也是和經(jīng)濟(jì)利益掛鉤的。理，具有手工管理所無(wú)法比擬的優(yōu)點(diǎn)，其優(yōu)勢(shì)已非常明顯。況、了解客戶(hù)情況，了解片碟的庫(kù)存情況等，以全面提升商店的競(jìng)爭(zhēng)力。FOXPRO是小型關(guān)系型數(shù)據(jù)庫(kù)的代表,它具有易學(xué)、實(shí)用性強(qiáng)、功能強(qiáng)大等特點(diǎn)，21世紀(jì)人類(lèi)已經(jīng)進(jìn)入信息時(shí)代，走向信息化的社會(huì)。

　　

【正文】 租借次數(shù) +1 FOR 編號(hào)=AA ENDSCAN amp。amp。刷新表格數(shù)據(jù) ENDIF 程序?qū)?dāng)前租賃記錄的“狀態(tài)”字段設(shè)置為“出租”，然后更新音像商品表中當(dāng)前商品的庫(kù)存數(shù)量和租借次數(shù)，最后刷新表格數(shù)據(jù)。 “歸還（ cmdReturn）”按鈕的 CLICK 事 件： nMode = 2 DO FORM [Forms\歸還單錄入 ] WITH NMAX,sDate,sType,nMemNo,nMode 程序?qū)⒋蜷_(kāi)歸還單錄入表單，要求用戶(hù)填寫(xiě)歸還單。 “刪除（ cmdDelect）按鈕”的 CLICK 事件： amp。amp。 只有歸還了商品才可以刪除記錄，包括租賃表和租賃明細(xì)表 IF MessageBox(確認(rèn)要?jiǎng)h除租賃信息？ ,4+32,音像租賃管理系統(tǒng) ) = 6 SELECT 租賃表 amp。amp。刪除租賃表中的數(shù)據(jù) DELETE FOR 編號(hào) =NMAX PACK SELECT 租賃明細(xì)表 amp。amp。刪除租賃明細(xì)表中的數(shù)據(jù) DELETE FOR 租賃編號(hào) =NMAX PACK ENDIF 程序?qū)⒎謩e從租賃表和租賃明細(xì)表中刪除指定的記錄。 “查看明細(xì)（ cmdList）按鈕“的 CLCIK 事件： amp。amp。 查看出租明細(xì) nMode = 2 DO FORM [Forms\查看租賃明細(xì) ] WITH NMAX,sDate,sType,nMemNo,nMode 歸還單錄入表單的主要代碼如下 ： “歸還（ cmdReturn）按鈕”的 CLICK 事件 ： If MessageBox(確認(rèn)要?dú)w還這些音像商品？ ,4+32,音像租賃管理系統(tǒng) ) = 6 amp。amp。 將押金信息存入租賃表 SELECT 租賃表 REPLACE 實(shí)交押金 WITH 實(shí)交押金 . 退還押金 .Value,。 實(shí)交租金 WITH 實(shí)交租金 .Value,。 狀態(tài) WITH 39。歸還 39。,歸還日期 WITH DATE()。 FOR 編號(hào) = 編號(hào) .Value amp。amp。 更改商品庫(kù)存數(shù)量 SELECT 租賃明細(xì)表 Scan For 租賃編號(hào) = 編號(hào) .Value AA = 租賃明細(xì)表 .商品編號(hào) BB = 租賃明細(xì)表 .租賃數(shù)量 SELECT 音像商品表 REPLACE 庫(kù)存數(shù)量 WITH 庫(kù)存數(shù)量 +BB FOR 編號(hào) =AA Endscan amp。amp。 如果為會(huì)員，更新此會(huì)員的租賃數(shù)量 SELECT 會(huì)員表 REPLACE 累計(jì)次數(shù) WITH 累計(jì)次數(shù) +ZLSL ,累計(jì)金額 WITH 累計(jì)金額 +SJZJ FOR 編號(hào) =nMemNo Endif 程序執(zhí)行過(guò)程如下： （ 1） 將押金信息存入租賃表，將“狀態(tài)”字段值設(shè)置為“歸還” （ 2） 在租賃明細(xì)表中更改商品庫(kù)數(shù)量。 （ 3） 更新會(huì)員表中的累計(jì)次數(shù)和累計(jì)金額字段值。 修改用戶(hù)密碼表單的代碼如下 ： “確定（ cmdOK）按鈕”的 CLICK 事件： If 用戶(hù)名 .Value = MessageBox(用戶(hù)名不存在 , 16, 提示 ) return Endif If ALLTRIM() != ALLTRIM( 密碼 .Value) MessageBox(密碼不正確 , 16, 提示 ) return Endif If ALLTRIM() == MessageBox(請(qǐng)輸入新密碼 , 16, 提示 ) return Endif If ALLTRIM() != ALLTRIM() MessageBox(新密碼與確認(rèn)密碼不同 , 16, 提示 ) return Endif amp。amp。設(shè)置用戶(hù)記錄的密碼 密碼 .Value = ALLTRIM() TableUpdate(.F.) amp。amp。保存緩沖區(qū)中的數(shù)據(jù) release thisform amp。amp。關(guān)閉表單 MessageBox(密碼已經(jīng)成功修改，請(qǐng)?jiān)谙麓蔚卿洉r(shí)使用新密碼 ) 程序首先對(duì)輸入數(shù)據(jù)進(jìn)行有效檢查，包括如下內(nèi)容： 用戶(hù)名是否存在。 用戶(hù)輸入的原密碼與真實(shí)密碼是否匹配。 新密碼是否為空。 新密碼和確認(rèn)新密碼是否相同。 第七章 結(jié)束語(yǔ) 經(jīng)過(guò)二個(gè)多月的設(shè)計(jì)和開(kāi)發(fā)，音像租賃管理系統(tǒng)基本開(kāi)發(fā)完畢。其功能基本符合用戶(hù)需求，能夠?qū)崿F(xiàn)存儲(chǔ)數(shù)據(jù)，調(diào)用數(shù)據(jù)和查詢(xún)數(shù)據(jù)等主要功能。 但是由于畢業(yè)設(shè)計(jì)時(shí)間較短，所以該系統(tǒng)還有許多不盡如人意的地方，比如用戶(hù)界面不夠美觀，沒(méi)有添加打印報(bào)表功能，出錯(cuò)處理不夠等多方 面問(wèn)題。這些都有待進(jìn)一步改善 致謝 : 我的畢業(yè)設(shè)計(jì)是在龍老師的指導(dǎo)下進(jìn)行的，龍老師嚴(yán)謹(jǐn)?shù)闹笇?dǎo)態(tài)度與深厚的理論知識(shí)都讓我受益非淺，在我學(xué)習(xí)期間傳授了很多搞學(xué)問(wèn)的秘訣，這些都將使我終生受益。無(wú)論是在理論學(xué)習(xí)階段，還是在論文的資料查詢(xún)、研究和撰寫(xiě)，以至于每個(gè)環(huán)節(jié)，無(wú)不得到導(dǎo)師的悉心指導(dǎo)和幫助。我愿借此機(jī)會(huì)向?qū)煴硎局孕牡母兄x！ 同時(shí)我也感謝那些對(duì)我提供幫助的同學(xué) !他們幫我解決了一些專(zhuān)業(yè)性的問(wèn)題，沒(méi)有他們就不會(huì)使系統(tǒng)更加完善。 總之，在以后的學(xué)習(xí)生活中我會(huì)更加努力，作為給予我?guī)椭娜藗兓貓?bào) . Are you hungry now? No, I am tired and lazy now。 if I pursue you I will not catch you, and if I catch youthrough your own slowness and clumsinessI will not kill you, and if I kill you I will not eat you. Nicholas had begun to back away, and at the last。 words, realizing that they were a signal, he turned and began to run, splashing through the shallow water. Ignacio ran after him, much helped by his longer legs, his hair flying behind his dark young face, his square teetheach white as a bone and as big as Nicholas39。s thumbnailshowing like spectators who lined the railings of his lips. Don39。t run, N icholas, Dr. Island said with the voice of a wave. It only makes him angry that you run. N icholas did not answer, but cut to his left, up the beach and among the trunks of the palms, sprinting all the way because he had no way of knowing Ignacio was not right behind him, about to grab him by the neck. When he stopped it was in the thick jungle, among the boles of the hardwoods, where he leaned,.。 out of breath, the thumping of his own heart the only39。 . sound in an atmosphere silent and unwa ked as Earth39。s long, prehuman day. For a time he listened for any sound Ignacio might m ake searching for him。 there was none. He drew a deep breath then and said, Well, that39。s over, expecting Dr. Island to answer from somewhere。 there was only the green hush. The light was still bright and strong and nearly, shadowless, but some interior sense told him the day, was nearly over, and he noticed that such faint shades as he could see stretched long, hor izontal distortions of their objects. He felt no hunger, but he had fasted be39。 fore and knew on which side of hunger he stood。 he was not as strong as he had been only a day past, and by this time next day he would probably be unable to outrun Ignacio. He should, he now realized, have eaten the monkey he had killed。 but his stomach revolted at the thought of the raw flesh, and he did not know how he might build a fire, although Ignacio seemed to have done so the night before. Raw fish, even if he were able to catch a fish, would be as bad, or worse, than raw monkey。 he remembered his effort to open a coconuthe had failed, but it was surely not impossible. His mind was hazy as to what a coconut might contain, but there had to be an edible core, because they were eaten in books. He decided to make a wide sweep through the jungle that would bring him back to the beach well away from Ignacio。 he had several times seen coconuts lying in the sand under the trees. He moved quietly, still a little afraid, trying to think of ways to open the coconut w hen he found it. He imagined himself standing before a large and raggedly faceted stone, holding the coconut in both hands. He raised it and smashed it dow n, but when it struc k it was no longer a coconut but Maya39。s head。 he heard her nose cartilage break with a distinct, rubbery snap. Her eyes, as blue as the sky above Madhya Pradesh, the sparkling blue sky of the egg, looked up at him, but he could no longer look into them, they retreated fr om his own, and it came to him quite suddenly that Lucifer, in falling, must have fallen up, into the fires and the coldness of space, never again to see the warm blues and browns and greens of Earth: 1 was watching Sa tan fall as lightning from heaven. He had heard that on tape somewhere, but he could not remember where. He had read that on Earth lightning did not e down from the clouds, but leaped up from the plane tary surface toward them, never to return. Nichol