【正文】 inese_PRC_CI_AS NOT NULL , /*藥品編號(hào) */ [_enddate] [smalldatetime] NULL, /*有效期 */ [out_amount] [float] NULL , /*數(shù)量 */ [out_price] [float] NULL , /*單價(jià) */ [out_discount] [float] NULL , /*折扣 */ [out_total] [float] NULL , /*金額 */ [out_cash] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , /*支付方式 */ [out_arr] [char] (2) COLLATE Chinese_PRC_CI_AS NULL , /*是否記賬 */ [out_rate] [float] NULL , /*預(yù)付比例 */ [out_memo] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL, /*備注 */ ) ON [PRIMARY] （ 12） jxc_stock（庫(kù)存）表：用于保存藥品的庫(kù)存信息，該表包括 7 個(gè)字段，分別用來(lái)保存 庫(kù)存更新日期、編號(hào)、倉(cāng)庫(kù)編號(hào)、藥品編號(hào)、有效期、數(shù)量、金額等信息。 銷(xiāo) 售 單記 賬支 付 方 式金 額折 扣數(shù) 量 有 效 期日 期業(yè) 務(wù) 員倉(cāng) 庫(kù)藥 品單 價(jià)客 戶(hù)預(yù) 付 比 例備 注 圖 59： 銷(xiāo)售單的 ER 圖 14 數(shù)據(jù)庫(kù)結(jié)構(gòu)設(shè)計(jì) 本系統(tǒng)共創(chuàng)建了 13 張表：分別是 jxc_type（藥品類(lèi)別）表、 jxc_CommName（藥品信息）表、 jxc_cust（客戶(hù)信息）表、 jxc_supp（供應(yīng)商信息）表、 jxc_SMType（業(yè)務(wù)員類(lèi)別）表、 jxc_sales（業(yè)務(wù)員信息）表、 jxc_store（倉(cāng)庫(kù)信息）表、jxc_orders（進(jìn)貨訂單）表、 jxc_SalesOrders（銷(xiāo)售訂單）表、 jxc_in（入庫(kù)單）表、 jxc_out（銷(xiāo)售單）表、 jxc_stock（庫(kù)存）表、 jxc_move（倉(cāng)庫(kù)調(diào)貨信息）表。 ? 能錄入藥品的入庫(kù)單、銷(xiāo)售單。主要有以下缺點(diǎn)。 8 第三章 關(guān)鍵技術(shù) 使用 Tree View 顯示數(shù)據(jù) 使用 Tree View 控件可顯示分層結(jié)構(gòu)的數(shù)據(jù)，其中每個(gè)數(shù)據(jù)項(xiàng)為一個(gè) Node對(duì)象，每個(gè) Node 對(duì)象均由一個(gè)標(biāo)簽和一個(gè)可選的位圖組成。 關(guān)鍵詞：藥品，窗體 ,域 ,數(shù)據(jù)庫(kù) Abstract： The calculator management information system is a system engineering, synthesizing the calculator, work, database, the munication technique, also including the business enterprise management science and numerous abundant empirical summary of is the example that the advanced science technique bines with the modern business enterprise management. Its creation and movement is the business enterprise management management develops the certain stage, inevitable request of certain scale and particular and economic environmentses are. Currently, the global drugs` market petition is increasingly vigorous, the panies medicine enterprise wants to be keep on the win the benefit to be decided by whether it can win and keep the satisfaction of the equal customers or analysis, we use the VISUAL BASIC development tool of the pany of MICROSOFT, making use of various development tool that faces to the object of what it provide, particularly is this ability of the data window way is convenient and simple and direct to manipulate the database of intelligence turn the object, build up the system application prototype in the in a short time first, then, start the prototype system to carry on the need generation to the beginning, revise and improve continuously, until formation the customer is satisfied and can go the system. Key words: materia medica,form,field, thewages management. 3 目 錄 第一章 緒論 .............................................................................................. 5 系統(tǒng)的開(kāi)發(fā)背景 ............................................................................. 5 第二章 系統(tǒng)分析 ........................................................................................ 6 需求分析 ....................................................................................... 6 可行性分析 ................................................................................... 6 第三章 關(guān)鍵技術(shù) ........................................................................................ 8 使用 Tree View 顯示數(shù)據(jù) ............................................................... 8 在窗體間傳遞參數(shù) ......................................................................... 8 第四章 系統(tǒng)設(shè)計(jì) ...................................................................................... 10 系統(tǒng)目標(biāo) .................................................................................... 10 系統(tǒng)功能結(jié)構(gòu) .............................................................................. 10 第五章 數(shù)據(jù)庫(kù)設(shè)計(jì) .................................................................................. 11 數(shù)據(jù)庫(kù)分析 ................................................................................. 11 項(xiàng)目 ER 圖 ................................................................................ 11 數(shù)據(jù)庫(kù)結(jié)構(gòu)設(shè)計(jì) .......................................................................... 14 創(chuàng)建數(shù)據(jù)庫(kù) ................................................................................. 19 第六章 設(shè)計(jì)主窗體 .................................................................................. 20 制作主窗體界面 .......................................................................... 20 添加菜單欄 ................................................................................. 20 編寫(xiě)主窗體代碼 .......................................................................... 22 編寫(xiě)通用模塊程序 ....................................................................... 24 第七章 詳細(xì)設(shè)計(jì) ...................................................................................... 27 設(shè)計(jì)基本數(shù)據(jù)模塊 ....................................................................... 27 藥品類(lèi)別 ........................................................................... 27 管理藥品信息 —— 藥品列表 ................................................ 32 供應(yīng)商 .............................................................................. 36 客戶(hù) .................................................................................. 37 設(shè)計(jì)進(jìn)貨管理模塊 ....................................................................... 38 進(jìn)貨訂單 —— 訂單列表 ....................................................... 38 入庫(kù)單 .............................................................................. 42 設(shè)計(jì)銷(xiāo)售管理模塊 ....................................................................... 43 銷(xiāo)售訂單 ........................................................................... 44 銷(xiāo)售單 .............................................................................. 45 設(shè)計(jì)庫(kù)存理模塊 .......................................................................... 46 4 庫(kù)存信息 ........................................................................... 46 設(shè)計(jì)查詢(xún)模塊 ......................