【導(dǎo)讀】它已進(jìn)入人類社會(huì)的各個(gè)領(lǐng)域并發(fā)揮著越來越重要的作用。的內(nèi)容不論對(duì)于媒介和商家的管理者，還是對(duì)于用戶來說都至關(guān)重要。像、客戶的新增以及相關(guān)數(shù)據(jù)的統(tǒng)計(jì)、查詢、修改等音像租借管理的全過程的工作。時(shí)分為會(huì)員租賃與零租以方便管理?？傊?，該系統(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ì)利益掛鉤的。理，具有手工管理所無法比擬的優(yōu)點(diǎn)，其優(yōu)勢(shì)已非常明顯。況、了解客戶情況，了解片碟的庫存情況等，以全面提升商店的競(jìng)爭(zhēng)力。FOXPRO是小型關(guān)系型數(shù)據(jù)庫的代表,它具有易學(xué)、實(shí)用性強(qiáng)、功能強(qiáng)大等特點(diǎn)，21世紀(jì)人類已經(jīng)進(jìn)入信息時(shí)代，走向信息化的社會(huì)。

　　

【正文】 編號(hào)=AA ENDSCAN amp。amp。刷新表格數(shù)據(jù) ENDIF 程序?qū)?dāng)前租賃記錄的“狀態(tài)”字段設(shè)置為“出租”，然后更新音像商品表中當(dāng)前商品的庫存數(shù)量和租借次數(shù)，最后刷新表格數(shù)據(jù)。 “歸還（ cmdReturn）”按鈕的 CLICK 事 件： nMode = 2 DO FORM [Forms\歸還單錄入 ] WITH NMAX,sDate,sType,nMemNo,nMode 程序?qū)⒋蜷_歸還單錄入表單，要求用戶填寫歸還單。 “刪除（ 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。 更改商品庫存數(shù)量 SELECT 租賃明細(xì)表 Scan For 租賃編號(hào) = 編號(hào) .Value AA = 租賃明細(xì)表 .商品編號(hào) BB = 租賃明細(xì)表 .租賃數(shù)量 SELECT 音像商品表 REPLACE 庫存數(shù)量 WITH 庫存數(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í)行過程如下： （ 1） 將押金信息存入租賃表，將“狀態(tài)”字段值設(shè)置為“歸還” （ 2） 在租賃明細(xì)表中更改商品庫數(shù)量。 （ 3） 更新會(huì)員表中的累計(jì)次數(shù)和累計(jì)金額字段值。 修改用戶密碼表單的代碼如下 ： “確定（ cmdOK）按鈕”的 CLICK 事 件： If 用戶名 .Value = MessageBox(用戶名不存在 , 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è)置用戶記錄的密碼 密碼 .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)容： 用戶名是否存在。 用戶輸入的原密碼與真實(shí)密碼是否匹配。 新密碼是否為空。 新密碼和確認(rèn)新密碼是否相同。 第七章 結(jié)束語 經(jīng)過二個(gè)多月的設(shè)計(jì)和開發(fā)，音像租賃管理系統(tǒng)基本開發(fā)完畢。其功能基本符合用戶需求，能夠?qū)崿F(xiàn)存儲(chǔ)數(shù)據(jù)，調(diào)用數(shù)據(jù)和查詢數(shù)據(jù)等主要功能。 但是由于畢業(yè)設(shè)計(jì)時(shí)間較短，所以該系統(tǒng)還有許多不盡如人意的地方，比如用戶界面不夠美觀，沒有添加打 印報(bào)表功能，出錯(cuò)處理不夠等多方面問題。這些都有待進(jìn)一步改善 致謝 : 我的畢業(yè)設(shè)計(jì)是在龍老師的指導(dǎo)下進(jìn)行的，龍老師嚴(yán)謹(jǐn)?shù)闹笇?dǎo)態(tài)度與深厚的理論知識(shí)都讓我受益非淺，在我學(xué)習(xí)期間傳授了很多搞學(xué)問的秘訣，這些都將使我終生受益。無論是在理論學(xué)習(xí)階段，還是在論文的資料查詢、研究和撰寫，以至于每個(gè)環(huán)節(jié)，無不得到導(dǎo)師的悉心指導(dǎo)和幫助。我愿借此機(jī)會(huì)向?qū)煴硎局孕牡母兄x！ 同時(shí)我也感謝那些對(duì)我提供幫助的同學(xué) !他們幫我解決了一些專業(yè)性的問題，沒有他們就不會(huì)使系統(tǒng)更加完善。 總之，在以后的學(xué)習(xí)生活中我會(huì)更加努力，作為給予我?guī)椭?人們回報(bào) . lists. Really? I said, trying not to sound jubilant. I found out they wear this red scarf thing on their arm. It covers up Sitting Bull39。s horse. That is a problem, I said. Well, that39。s not all. My docent told me about your lunch. Did Grandma Karen really tell you you were right? Yes. Gosh! I didn39。t believe that part. Well, anyway, my docent said you wouldn39。t listen to her about how great menstruating is, that you all kept talking about the negative aspects of it, like bloating and cramps and crabbiness, and I said, 39。What are cramps?39。 and she said, 39。Menstrual bleeding frequently causes headaches and depression,39。 and I said, 39。Bleeding! ? Nobody ever said anything about bleeding!39。 Why didn39。t you tell me there was blood involved, Mother? I had, but I felt it wiser to keep silent. And you didn39。t say a word about its being painful. An uget. It was impossible to keep secrets when seven people lived in such a confined space. She knew for a fact, for instance, that what the Polo sisters did behind the closed doors of their adjoining rooms was still illegal in Alabama. They had all bounced around a lot, especially in the early months of the voyage. Gene was the only married crew member, and h e had taken care to announce quite early that he and his wife had an arrangement about such matters. Still, he had slept alone for a long time because the Polos had each other, Gaby didn39。t seem to care about sex at all, and Cirocco had been irresistibly drawn to Calvin Greene. Her persistence was such that Calvin eventually went to bed with her, not just once, but three times. It didn39。t get any better, so before he could sense her disappointment she had cooled the relationship and let him pursue Gaby, the woman he had been drawn to from the first. Calvin was a general surgeon trained by NASA to be petent as ship39。s biologist and ecologist as well. He was blac k, but atta ched little importance to it, having been born and raised in O39。Neil One. He was also the only crew member who was taller than siroc co. She didn39。t think that had much to do with his appeal。 she had learned early to be indifferent to a man39。s height, since she like a big, soft asteroid. The analogy pleased her. Extending it, she watched the te rminator line crawl around her to bring the hills and valleys of her front into sunlight. Cirocco liked space, reading, and sex, not necessarily in that order. She had never been able to satisfactorily bine all three, but two was not bad. New games were possible in freefall, like the one they had been playing, no hands. T hey could use feet, mouths, knees, or shoulders to position each other. One had to be gentle and careful, but with slow bites and nips anything could be done, and in such an interesting way. All of them came to the hydroponics room from time to time. Ringmaster had seven private rooms, and they were as necessary as oxygen. But even Cirocco39。s cabin was crowded when two people were in it, and it *as at the bottom of the carousel. It took one act of love in freefall to make a bed seem as limiting as the back scat of a Chevrolet. 39。Why don39。t you turn this way a little? Bill asked. Can you give me a good reason? He showed her one, and she gave him a little more than he had asked for. Then she found herself with a little more than she had .asked for, but as usual, he kne would be easy to move it. Cirocco frowned. Just how big is it, then? The PoloAugust, she was almost sure it was August looked at her with that calm, strangely unsettling face. I should say about tw