【正文】
字符型 10保質(zhì)期 字符型 3數(shù)量 雙精度型 8 2進(jìn)價(jià) 數(shù)值型 10其中入庫(kù)票號(hào)和消耗品編號(hào)是主碼。這一設(shè)計(jì)階段是在需求分析的基礎(chǔ)上,設(shè)計(jì)出能夠滿(mǎn)足使用者需求的各種實(shí)體,以及它們之間的關(guān)系,為后面的邏輯結(jié)構(gòu)設(shè)計(jì)打下基礎(chǔ)。收集基本數(shù)據(jù)、數(shù)據(jù)結(jié)構(gòu)以及數(shù)據(jù)處理的流程,組成一份詳盡的數(shù)據(jù)字典,為后面的具體設(shè)計(jì)打下基礎(chǔ)。并把其用報(bào)表打印供醫(yī)院使用。(1)收款單可以瀏覽收款信息。(1)庫(kù)存查詢(xún)就是對(duì)庫(kù)存中的消耗品按編號(hào)、名稱(chēng)等多個(gè)字段進(jìn)行模糊或準(zhǔn)確查詢(xún),并把庫(kù)存列表顯示出來(lái)。而且當(dāng)輸入銷(xiāo)售單的起始和結(jié)束時(shí)間后,點(diǎn)查詢(xún)可實(shí)現(xiàn)查詢(xún)銷(xiāo)售的消耗品信息 進(jìn)貨管理:包括入庫(kù)登記、入庫(kù)退貨、入庫(kù)報(bào)表。系統(tǒng)包括自動(dòng)計(jì)算消耗品的入庫(kù)票號(hào)、按各種方式查詢(xún)數(shù)據(jù)、打印報(bào)表和預(yù)覽消耗品各種信息、入庫(kù)消耗品清單、銷(xiāo)售消耗品清單、統(tǒng)計(jì)等功能。而且使用傳統(tǒng)人工的方式管理消耗品存在著許多缺點(diǎn),如:效率低、保密性差,另外時(shí)間一長(zhǎng),將產(chǎn)生大量的文件和數(shù)據(jù),這對(duì)于查找、更新和維護(hù)都帶來(lái)了不少的困難。開(kāi)發(fā)Hospital consumables management systemAbstract:The article mainly introduces the development of the consumable management information system for CaiDa consumables. TCMIS realized puterizing management for some major process. TCMIS consists of consumables management, sales management, replenish stock management, store management ,shipment management, financial management, accounts management, inquiry , forms printing, customers information, system setting, data maintenance, help, quit .etc, TCMIS can pute automatically consumable exchange shop, and pick up the out of date or needful consumables, inquiring according to all kinds of ways, printing and previewing consumable price, list of new consumables, list of out of date consumables, list of needful consumables, etc. TCMIS makes the system simple, standard, reasonable and scientific. TCMIS also is fairly effective, and has friendly interface. TCMIS was designed by means of Microsoft Visual FoxPro under the operation system of Windows.Keywords:TCMIS(the consumables management information system )。醫(yī)院消耗品管理系統(tǒng)目 錄1 引言 ....................................................................................................................................12 系統(tǒng)方案論證 .....................................................................................................................3 系統(tǒng)功能 .....................................................................................................................3 系統(tǒng)模塊結(jié)構(gòu)圖 .........................................................................................................4 業(yè)務(wù)流程圖 .................................................................................................................83 數(shù)據(jù)庫(kù)的設(shè)計(jì) .....................................................................................................................9 數(shù)據(jù)庫(kù)的需求分析 .....................................................................................................9 數(shù)據(jù)庫(kù)概念設(shè)計(jì) .........................................................................................................9 數(shù)據(jù)庫(kù)邏輯結(jié)構(gòu)設(shè)計(jì) ............................................................