【導(dǎo)讀】經(jīng)濟(jì)的飛速發(fā)展，企業(yè)規(guī)模的不斷擴(kuò)大，倉庫的信息管理日趨重要。然而，面對龐大的產(chǎn)品。網(wǎng)絡(luò)計(jì)算機(jī)的誕生及多媒體。通訊信息的高速發(fā)展，產(chǎn)品種類的多樣化催生了倉庫管理方式的進(jìn)一步更新?lián)Q代?；瘮?shù)據(jù)等這些優(yōu)勢來輔助單位對倉庫進(jìn)行管理，真正實(shí)現(xiàn)人力的節(jié)省，勞動(dòng)效率的提高。本系統(tǒng)采用面向?qū)ο蟮某绦蛟O(shè)計(jì)思想進(jìn)行編制，通過VisualBasic61></a>.0中的ADO數(shù)據(jù)控。件與數(shù)據(jù)源建立連接，使程序員用最少的代碼快速創(chuàng)建數(shù)據(jù)庫應(yīng)用程序。本系統(tǒng)提供直觀、日志等窗體，更加方便對庫存的信息進(jìn)行管理。整個(gè)系統(tǒng)數(shù)據(jù)存在表格文件中，由數(shù)據(jù)庫文。在設(shè)計(jì)數(shù)據(jù)庫時(shí)使表格文件發(fā)生關(guān)聯(lián)，組成關(guān)系型數(shù)據(jù)庫，以便于對數(shù)據(jù)進(jìn)行。這樣就可以在數(shù)據(jù)的操作上分別針對屬于不同表的數(shù)據(jù)，不必為了某條記錄的一個(gè)字。段來對全部記錄進(jìn)行修改，加快了數(shù)據(jù)的處理速度，增加了數(shù)據(jù)的可管理性。其強(qiáng)大的功能已為人們深刻。方便、可靠性大、存儲量大、保密性好、壽命長、成本低等。這些優(yōu)點(diǎn)能夠極大地提高企業(yè)

　　

【正文】 odule, the basic information management module, storage information management module, a library information management module, inventory information management module, the system module to help. System Management module modify passwords, add users and systems from the function. Basic Information Management Module (1) raw materials, the type of management: number of types of raw materials, the type name and a brief description Remarks add, delete, modify, such as the operation. (2) Supply Chain Management: the number of suppliers, name, contact telephone number, responsible person, Email and other related information management operations. (3) storage of information management: the subwarehouses to add, delete, modify, Browse a list of such operations. storage of information management module The pletion of this module the main raw materials of all kinds of new storage systems add, query, delete and other management operations. (1) Information storage materials: Choose or enter the type of ID management of raw materials, raw material name, storage prices, the number of such storage. (2) storage of raw materials suppliers of information: the importation of raw material suppliers to choose the number and name information. (3) warehousing single message: the provision of warehousing number name storage warehouse, storage time and other information. (4) order of information: According to materials related to the use of ordering information to register. To facilitate the management, interface with the framework of information divided into three groups: A group: orders alone, according to information order number, order date。 B group: Materials Information orders orders for material number, name of ordering materials, the number of orders for materials。 C group: order information material suppliers supplier code, supplier name. Library Information Management Module The library materials on information management: Stock Out number, number of library materials, library materials out of the name, the date of the Treasury, the number of the Treasury. Inventory Information Management Module (1) Stock of raw materials inventory: information display in tabular material inventory numbers, material name, material types, suppliers, the total storage volume of material, the existing volume of material. (2) shortage of raw materials as follows: lack of materials listed in the list of information (when the materials inventory at the time of ≤ 5 as a shortage of material), to provide timely orders (orders call module functions), and later settled (do not take any action to return to the main window ) two functions. The system module provides system helps operate a brief description and copyright information. 3 .key code system This procedure is the key to the code module in the standard definition of a public database module. Can be directly in the main program module calls the SQL statement. Public Function ExecuteSQL（ ByVal SQL As String, msgstring As String） As ADODB． Recordset Dim n As ADODB． Connection Dim rst As ADODB． Recordset Dim sTokens（） As String On Error GoTo ExecuteSQL＿ Error sTokens ＝ Split（ SQL） Set n ＝ New ADODB． Connectionn． Open 〃 Provider＝ MSDASQL。DSN＝ Warehouse Management System。UID＝ sa。PWD＝ ?！? If InStr （〃 INSERT,DELECT,UPDATA〃 , UCase （ sTokens （ 0））） Then n． Execute SQL msgstring ＝ sTokens（ 0） ＆ 〃 Query Successful〃 Else Set rst ＝ New ADODB． Recordset rst． Open Trim（ SQL） , n, adOpenKeyset, adLockOptimistic Set ExecuteSQL ＝ rst msgstring ＝ 〃 demand〃 ＆ rst． RecordCount ＆ 〃 Several note〃 End If ExecuteSQL＿ Exit: Set rst ＝ Nothing Set n ＝ Nothing Exit Function ExecuteSQL＿ Error: msgstring ＝ 〃 demand error：〃 ＆ Err． Description Resume ExecuteSQL＿ Exit 4 Concluding remarks In this paper, the demand on a wide range of warehouse management software warehouse management system, a design and realization of this system has good scalability, simple, applicable to all enterprises to carry out scientific and standardized and effective warehouse management. 致 謝 在本系統(tǒng)的開發(fā)過程中，我得到了我的指導(dǎo)教師顧曉東老師的熱心指導(dǎo)和支持，從選題到課題的最終完成 ，老師都給了我很大的幫助，老師對系統(tǒng)操作流程提供了寶貴的意見，對系統(tǒng)的分析及程序編寫中出現(xiàn)的錯(cuò)誤提出了修改意見，給整個(gè)系統(tǒng)的開發(fā)和論文的寫作提供了寶貴意見，使這個(gè)系統(tǒng)得以順利的開發(fā)完畢，并完成最后的論文寫作。老師嚴(yán)謹(jǐn)?shù)闹螌W(xué)態(tài)度，以及對于深厚的知識功底都給了我很深刻的教育，對我以后做人、做事都產(chǎn)生了很大的影響。同時(shí)我也要感謝大連大學(xué)計(jì)算機(jī)教研室全體老師在我四年的大學(xué)學(xué)習(xí)生活里對我的教育和培養(yǎng)，使我在各方面都得到了鍛煉和提高。在此，我表示衷心的感謝。 在論文設(shè)計(jì)過程中，特別感謝我的同學(xué)、朋友給予我的幫助，他們 給我的論文提出了許多建議，為我論文的撰寫創(chuàng)造了一個(gè)良好的環(huán)境，使得我的論文能夠順利的完成。 同時(shí)我也要感謝大連大學(xué)所有教過我的老師對我的教育和培養(yǎng)，在四年的大學(xué)生活里，使我在德智體美各方面的能力都得到了鍛煉和提高，在我以后的人生道路上將產(chǎn)生深遠(yuǎn)的影響。 大連大學(xué)學(xué)位論文版權(quán)使用授權(quán)書 本學(xué)位論文作者及指導(dǎo)教師完全了解“大連大學(xué)學(xué)士論文版權(quán)使用規(guī)定”，同意大連大學(xué)保留并向國家有關(guān)部門或機(jī)構(gòu)送交學(xué)位論文的復(fù)印件和電子版，允許論文被查閱和借閱。本人授權(quán)大連大學(xué)可以將本學(xué)位論文的全部或部 分內(nèi)容編入有關(guān)數(shù)據(jù)庫進(jìn)行檢索，也可采用影印、縮印或掃描等復(fù)制手段保存和匯編學(xué)位論文。 作者簽名： 導(dǎo)師簽名： 年 月 日 PAGE PAGE 20