【正文】 inese_PRC_CI_AS NOT NULL , /*藥品編號 */ [_enddate] [smalldatetime] NULL, /*有效期 */ [out_amount] [float] NULL , /*數(shù)量 */ [out_price] [float] NULL , /*單價 */ [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（庫存）表：用于保存藥品的庫存信息，該表包括 7 個字段，分別用來保存 庫存更新日期、編號、倉庫編號、藥品編號、有效期、數(shù)量、金額等信息。 銷 售 單記 賬支 付 方 式金 額折 扣數(shù) 量 有 效 期日 期業(yè) 務(wù) 員倉 庫藥 品單 價客 戶預(yù) 付 比 例備 注 圖 59： 銷售單的 ER 圖 14 數(shù)據(jù)庫結(jié)構(gòu)設(shè)計 本系統(tǒng)共創(chuàng)建了 13 張表：分別是 jxc_type（藥品類別）表、 jxc_CommName（藥品信息）表、 jxc_cust（客戶信息）表、 jxc_supp（供應(yīng)商信息）表、 jxc_SMType（業(yè)務(wù)員類別）表、 jxc_sales（業(yè)務(wù)員信息）表、 jxc_store（倉庫信息）表、jxc_orders（進貨訂單）表、 jxc_SalesOrders（銷售訂單）表、 jxc_in（入庫單）表、 jxc_out（銷售單）表、 jxc_stock（庫存）表、 jxc_move（倉庫調(diào)貨信息）表。 ? 能錄入藥品的入庫單、銷售單。主要有以下缺點。 8 第三章 關(guān)鍵技術(shù) 使用 Tree View 顯示數(shù)據(jù) 使用 Tree View 控件可顯示分層結(jié)構(gòu)的數(shù)據(jù)，其中每個數(shù)據(jù)項為一個 Node對象，每個 Node 對象均由一個標簽和一個可選的位圖組成。 關(guān)鍵詞：藥品，窗體 ,域 ,數(shù)據(jù)庫 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)的開發(fā)背景 ............................................................................. 5 第二章 系統(tǒng)分析 ........................................................................................ 6 需求分析 ....................................................................................... 6 可行性分析 ................................................................................... 6 第三章 關(guān)鍵技術(shù) ........................................................................................ 8 使用 Tree View 顯示數(shù)據(jù) ............................................................... 8 在窗體間傳遞參數(shù) ......................................................................... 8 第四章 系統(tǒng)設(shè)計 ...................................................................................... 10 系統(tǒng)目標 .................................................................................... 10 系統(tǒng)功能結(jié)構(gòu) .............................................................................. 10 第五章 數(shù)據(jù)庫設(shè)計 .................................................................................. 11 數(shù)據(jù)庫分析 ................................................................................. 11 項目 ER 圖 ................................................................................ 11 數(shù)據(jù)庫結(jié)構(gòu)設(shè)計 .......................................................................... 14 創(chuàng)建數(shù)據(jù)庫 ................................................................................. 19 第六章 設(shè)計主窗體 .................................................................................. 20 制作主窗體界面 .......................................................................... 20 添加菜單欄 ................................................................................. 20 編寫主窗體代碼 .......................................................................... 22 編寫通用模塊程序 ....................................................................... 24 第七章 詳細設(shè)計 ...................................................................................... 27 設(shè)計基本數(shù)據(jù)模塊 ....................................................................... 27 藥品類別 ........................................................................... 27 管理藥品信息 —— 藥品列表 ................................................ 32 供應(yīng)商 .............................................................................. 36 客戶 .................................................................................. 37 設(shè)計進貨管理模塊 ....................................................................... 38 進貨訂單 —— 訂單列表 ....................................................... 38 入庫單 .............................................................................. 42 設(shè)計銷售管理模塊 ....................................................................... 43 銷售訂單 ........................................................................... 44 銷售單 .............................................................................. 45 設(shè)計庫存理模塊 .......................................................................... 46 4 庫存信息 ........................................................................... 46 設(shè)計查詢模塊 ......................