PB水費收費系統(tǒng)


頁數(shù)：37 字數(shù)：11770

摘 要

本次設計采用POWERBUILDER 7.0為設計語言 實現(xiàn)自來水公司（集中式）水費收費系統(tǒng)功能。
由于自來水原有收費系統(tǒng)為單機版，不能實時反映收交費情況且只能分地區(qū)收費不能跨地區(qū)收費，數(shù)據(jù)不集中給營業(yè)管理上帶來不必要的麻煩。本系統(tǒng)的應用將改變以往交費必須到指定的水費交費點交費，既讓用戶可就近交費,避免了跑腿之苦,又可降低企業(yè)費用支出。給廣大用戶帶來更多的方便節(jié)約時間。同時由于數(shù)據(jù)的統(tǒng)一集中也將給自來水公司的營業(yè)管理、市場分析及領導的經營決策帶來很大的幫助。
本系統(tǒng)采用客戶/服務器(C/S)體系結構，是目前計算機網絡系統(tǒng)最先進的體系，其特點是把整個系統(tǒng)分成前臺(客戶機)和后臺(主機)兩個部分。前臺客戶機也就是操作員直接操作的微機；后臺是中心機房管理的主機。系統(tǒng)將所有帳務信息全部集中，而應用分布在各水費收費點的業(yè)務處理微機。這種前后臺合理的分工，使在前、后臺的通訊線路上傳輸?shù)臄?shù)據(jù)減到最小限度，不但提高了系統(tǒng)的運行速度，而且充分的發(fā)揮了前后臺兩方的資源效力?？蛻?服務器體系結構的另一個特點是它的開放性，所謂開放性，即是在網絡構成方面，可與多種軟、硬件系統(tǒng)相連接，這就使得在前臺端構成多種類客戶機并存成為現(xiàn)實。這樣，在新舊系統(tǒng)更替時，可充分利用原有系統(tǒng)的軟、硬件資源。

關鍵詞 ：PB(PowerBuilder)、數(shù)據(jù)庫、客戶/服務器


Designs and adopts POWERBUILDER 7 this time. 0 is in order to design languages Realize the water rate of running water company( the concentrating on type ) and charge the function systematically. Because running water former to have and charge system at unit edition, reflect and charge situation of paying dues in real time and divide into area it charges to be can't have been trans-regional to charge, Data concentrate on and give and open managerial to bring the unnecessary trouble. This systematic application change and pay dues and arrive water rate that appoint pay dues and order and pay dues in the past, Let users able to pay dues nearby , the ones that have avoided running errands are bitter, can also reduce enterprise expenses expenditure . Bring more convenience time of practising thrift to the masses of users. At the same time because data unified to give running water company to open , and business decision that lead it brings to be very heavy help market analysis management too while being centralized.
These adopt customer of system /server( C/Ss) system structure,it is for computer network system most advanced system at present, Its characteristic divides the whole system into the proscenium( the client) and two parts of backstage supporter( host computer ). The proscenium client is the computer that the operator operated directly; The backstage supporter is a host computer of management of computer lab of the centre. System at accounts all centralized information, use and distribute. Around these kinds for platform division of labours,it make in before, last minimum limit at data where at the communication lines of backstage supporters transmits, It raises systematic function speed but also from beginning to end platform No. two render a service abundant full play. Customer /servers the another characteristics of systems structures is for the opennings of it, So-called opennings is namely in network form respect, but with many kinds of and soft, the hardware system join , This make at proscenium end form more compatible to become reality client kind. So, while replacing in the new old system, but fully utilize softs, hardware resource of the original system.
The keyword: PB( PowerBuilders), data bases , customers /server


目錄

摘要……………………………………………………………………………………… 1
Brief ……………………………………………………………………………………2
第一章 概述 ……………………………………………………………………………3
1. 客戶/服務器(C/S)體系結構…………………………………………………………… 3
2. PowerBuile7.0的介紹 …………………………………………………………… 3
第二章 系統(tǒng)設計 ………………………………………………………………………4
1. 目標設計 ………………………………………………………………………4
2. 開發(fā)設計………………………………………………………………………4
2.1 開發(fā)設計思想 …………………………………………………………5
2.2 文件結構 …………………………………………………………… 5
2.3 開發(fā)和運行環(huán)境 …………………………………………………… 6
2.4 系統(tǒng)網絡 ……………………………………………………………6
3．設備介紹………………………………………………………………………6

第三章 數(shù)據(jù)庫設計 ……………………………………………………………………10
1. 數(shù)據(jù)庫需求分析 ………………………………………………………………10
第四章 數(shù)據(jù)庫結構的實現(xiàn) ……………………………………………………………16
1. 創(chuàng)建表格的過程 ………………………………………………………………16
1.1 創(chuàng)建項目…………………………………………………………………16
1.2 創(chuàng)建項目的數(shù)據(jù)庫………………………………………………………13
第五章 各個界面的創(chuàng)建………………………………………………………………17
1. 開始界面的設計………………………………………………………………17
2. 登錄界面的設計………………………………………………………………18
3. 收費界面的設計 …………………………………………………………19
4. 票據(jù)領用界面的設計 ………………………………………………………20
5. 票據(jù)作廢界面的設計 ………………………………………………………21
6. 查詢票據(jù) ……………………………………………………………………22
第六章 開發(fā)中的難點與解決技巧……………………………………………………23
1. 注意前臺數(shù)據(jù)庫的路徑 …………………………………………………23
2. 開發(fā)時焦點下移問題………………………………………………………23
3. 數(shù)據(jù)庫寫操作時注意事項…………………………………………………24
4. 菜單的設計…………………………………………………………………25
5. 窗口的設計…………………………………………………………………25
6. Power Script語言…………………………………………………………25
7. 編程…………………………………………………………………………26
第七章 系統(tǒng)的編譯與運行……………………………………………………………27
1. 編譯……………………………………………………………………………27
第八章 運行結果………………………………………………………………………29
1. 開始界面………………………………………………………………………29
2. 登錄界面………………………………………………………………………30
3. 前臺界面……………………………………………………………………31
4. 后臺界面……………………………………………………………………32
第九章 小結……………………………………………………………………………38
致謝 ……………………………………………………………………………………39
參考文獻 ………………………………………………………………………………40