【導(dǎo)讀】在設(shè)計(jì)過程中最大限度滿足用戶的要求，因此，該系統(tǒng)具有較強(qiáng)。的實(shí)用性和針對性。本系統(tǒng)界面友好，操作簡單，可維護(hù)性強(qiáng)，功能完備。計(jì)說明等內(nèi)容；最后給出了系統(tǒng)的使用說明和系統(tǒng)設(shè)計(jì)的心得體會。猛發(fā)展中的企業(yè)，隨著其規(guī)模的不斷擴(kuò)大，公司每天要處理的數(shù)據(jù)量也越來越大，為了幫助企業(yè)建立良好的管理秩序，在信息化時(shí)代充分利用計(jì)算機(jī)作為管理。任何學(xué)科的發(fā)展都與當(dāng)時(shí)的環(huán)境和條件緊密相聯(lián)。性強(qiáng)，功能齊備，旨在通過幫助該企業(yè)管理實(shí)現(xiàn)信息化，以提高企業(yè)管理的效率。庫存管理軟件，在設(shè)計(jì)格方面，適當(dāng)搭配圖形，顯示內(nèi)容可隨時(shí)依條件更新。示信息準(zhǔn)確，信息量大，有直觀形象，給人以美觀大方的感受。品的系統(tǒng)方法和工具。通過本課程的學(xué)習(xí)，將使您迅速識別庫存管理。凍結(jié)的資產(chǎn)變成現(xiàn)金，減少由于庫存淘汰所造成的成本?？s短從接受定單到送達(dá)貨物的時(shí)間，以保證優(yōu)質(zhì)。服務(wù)，同時(shí)又要防止脫銷。保證適當(dāng)?shù)膸齑媪浚?jié)約庫存費(fèi)用。用適當(dāng)?shù)臅r(shí)間間隔補(bǔ)充與需求量

　　

【正文】 理維護(hù) 和 修改密碼（對登陸本系統(tǒng)的操作員密碼進(jìn)行修改） ,本 系統(tǒng)中第 一個(gè)登陸的用戶為最高權(quán)限用戶，具有刪除操作權(quán)限 , 其它用戶沒有此 權(quán)限，刪 除功能不可用。 本系統(tǒng)的所有操作員將顯示在右邊的表格里，雙擊任何一個(gè)操作員可對其進(jìn)行編輯。 3) 操作員入口：用來改變登陸的用戶。 二 .庫存 1)元件登記 :對庫存的元件進(jìn)行登記維護(hù)。 2)產(chǎn)品登記 :對庫存的產(chǎn)品進(jìn)行登記維護(hù)。 3)庫存查詢 :對庫存的元件和產(chǎn)品數(shù)量進(jìn)行查詢。 三 .入庫信息 2) 入庫單 : 生成入庫信息。對入庫單的增 ,改 ,刪 ,查和打印做操作。 首先單擊新增按鈕，激活導(dǎo)入數(shù)據(jù)和導(dǎo)入歷史數(shù)據(jù) 兩個(gè)按鈕，導(dǎo)入數(shù)據(jù)按鈕是對一次的入庫單進(jìn)行的導(dǎo) 入 而導(dǎo)入歷史數(shù)據(jù)是對多個(gè)入庫單進(jìn)行導(dǎo) 入。若沒有導(dǎo)入的數(shù)據(jù)則單擊靠近產(chǎn)品名稱的查找按鈕，會彈出產(chǎn)品信息窗體選擇或添加產(chǎn)品后，單擊確定按 鈕則傳回相應(yīng)的產(chǎn)品信息，然后輸入相應(yīng)的其它信息后，單擊添加按鈕，則一條入庫信息將顯示在表格里，可按此操作重復(fù)添加其它的入庫信息，然后單擊確定按鈕保存后，將激活打印按鈕進(jìn)行打印。 2)入庫查詢：通過對入庫單號，元件名稱，時(shí)間，公司名稱的設(shè)置對入庫單進(jìn)行查詢。 具體操作如下： 首先選擇相應(yīng)的單選框便擊活相應(yīng)選項(xiàng)，輸入或選擇所需的條件，點(diǎn)擊確定按鈕，彈出相應(yīng) 的查詢結(jié)果。 3)統(tǒng)計(jì)：通過對時(shí)間設(shè)置，對入庫元件的數(shù)量和總金額進(jìn)行統(tǒng)計(jì)。 四 .出庫信息 1)出庫單：同入庫類似。 2)出庫查詢：同入庫類似。 3）統(tǒng)計(jì)：同入庫類似。 五 .數(shù)據(jù)維護(hù) 1）數(shù)據(jù)備份：對數(shù)據(jù)庫進(jìn)行定期備份，防止數(shù)據(jù)的丟失。 2）供應(yīng)商信息：對供應(yīng)商的用戶進(jìn)行添加，修改，刪除等維護(hù)。 七 .模擬配貨 1）產(chǎn)品材料組成：對我公司的產(chǎn)品的材料組成進(jìn)行配置。首先選擇配置產(chǎn)品列表框，然后可以 選擇添加配件或者導(dǎo)入材料組成的 excel 表，對我公司的產(chǎn)品進(jìn)行配置。 2）產(chǎn)品模擬配貨：選擇模擬配貨的產(chǎn)品，在模擬量中添入模擬量的數(shù)值，然后選擇模擬配按鈕 ,便自動和庫存做比較，顯示出庫存需求的數(shù)據(jù)。 八．工具管理 工具管理采用了同元件管理相似的做法，操作基本相同。 由于庫存管理涉及到一個(gè)企業(yè)的商業(yè)秘密信息 ,不宜公開 ,否則會給企業(yè)帶來不可估量的損失 .所有我們有必要對本系統(tǒng)的安全與保護(hù)措施進(jìn)行加強(qiáng) . 常用的做法有數(shù)據(jù)庫備份 .合理設(shè)置管理權(quán)限等 . 輸入用戶名與密碼驗(yàn)證 . Private Sub CmdOk_Click() On Error GoTo l Dim rs As Recordset Set rs = New = select * from usertable , , adOpenKeyset, adLockOptimistic = username=39。 amp。 UserNameCmb amp。 39。 If Not Or Not Then Usrpass = Trim(!userpwd) Set rs = Nothing UsrName = If Usrpass = Then Unload Me 39。 Unload frmSplash 39。 39。 Else MsgBox 你所輸入的口令不對，請重新輸入！ , vbOKOnly, 口令錯誤 End If Else MsgBox 請選擇用戶名稱！ , vbInformation + vbOKOnly, 錯誤信息 Exit Sub End If Exit Sub l: MsgBox End Sub 致 謝 本系統(tǒng)在選題、系統(tǒng)分析、資料收集、設(shè)計(jì)調(diào)試過程中得到了系領(lǐng)導(dǎo)、多位老師的親切指導(dǎo) .所以在此向幫助過我們的系領(lǐng)導(dǎo)和付出勞動的所有老師、同學(xué)們表示我們誠摯的謝意 ! 參考文獻(xiàn) 18 張洪林 . Visual Basic 編程實(shí)例 .北京： 人民郵電出版社 ， 1999 19 曾琦 . Visual basic 編程實(shí)例與技巧 .中國水利水電出版社 ， 2020 20 韓潤春 ， 佟志臣，王漢新 .管理信息系統(tǒng) ..河北人民出版社 ， 2020 21 溫賢發(fā) .Visual Basic 6 數(shù)據(jù)庫程序設(shè)計(jì)高手 .北京： 科學(xué)出版社 ， 2020 22 黎連業(yè) .管理信息系統(tǒng)設(shè)計(jì)與實(shí)施 .北京： 清華大學(xué)出版社 ， 1999 23 劉海峰 . Visual Basic 數(shù)據(jù)庫開發(fā)實(shí)例 . 北京： 機(jī)械工業(yè)出版社 .2020 24 安忠，吳洪波 .管理信息系統(tǒng) .第 2 版 .中國鐵道出版社 ， 2020 25 張洪林 . Visual basic 編程實(shí)例 .第 2 版 .北京： 人民郵電出版社 ， 2020 26 陳俊源等 .Visual Basic 程序設(shè)計(jì) 數(shù)據(jù)庫應(yīng)用 .中國鐵道出版社 ,2020 27 張顯庫 .VB 實(shí)用編程技術(shù) 從基礎(chǔ)到開發(fā) .大連理工大學(xué)出版社， 2020 28 鴻志創(chuàng)作組 .VISUAL BASIC 中文版應(yīng)用與開發(fā) .第 2 版 .北京： 科學(xué)技術(shù)出版社 ， 2020 29 知寒工作室 .中文 VISUAL BASIC 簡明案例教程 .機(jī)械工業(yè)出版社 ， 1999 30 [美 ]Wdward Jones amp。 Jarel ACCESS 2020 疑難解析 .北京： 機(jī)械工業(yè)出版社 ， 2020 31 石連栓，張濤，李立宗 .Visual Basic 程序設(shè)計(jì)教程 .清華大學(xué)出版社 ， 2020 32 黃明 ， 梁旭 .Vi sual Basic 信息系統(tǒng)設(shè)計(jì)與開發(fā)實(shí)例 .機(jī)械工業(yè)出版社 ， 2020 33 陳海濤 .Visual Basic 程序設(shè)計(jì)參考手冊 .人民郵電出版社 ， 2020 34 劉萌 .Visual Basic 企業(yè)辦公系統(tǒng)開發(fā)實(shí)例導(dǎo)航 .人民郵電出版社 ， 2020 Chapter I of Volume II MISS Bingley39。s letter arrived, and put an end to doubt. The very first sentence conveyed the assuranc e of their being all settled in London for the winter, and concluded with her brother39。s regret at not having had time to pay his respects to his friends in Hertfordshire before he left the country. Hope was over, entirely over。 and when Jane could attend to the rest of the letter, she found little, except the professed affection of the writer, that could give her any fort. Miss Darcy39。s praise occupied the chief of it. Her many attractions were again dwelt on, and Caroline boasted joyfully of their increa sing intimacy, and ventured to predict the acplishment of the wishes which had been unfolded in her former letter. She wrote also with great pleasure of her brother39。s being an inmate of Mr. Darcy39。s house, and mentioned with r aptures some plans of the latter with regard to new furniture. Elizabeth, to whom Jane very soon municated the chief of all this, heard it in silent indignation. Her heart was divided between concern for her sister, and resentment against all the others. To Caroline39。s assertion of her brother39。s being partial to Miss Darcy she paid no credit. That he was really fond of Jane, she doubted no more than she had e ver done。 and much as she had always been disposed to like him, she could not think w ithout anger, hardly without contempt, on that easiness of temper, that want of proper resolution which now made him the slave of his designing friends, and led him to sacrifice his own happiness to the caprice of their inclinations. Had his own happiness, however, been the only sacrifice, he might have been allowed to sport with it in what ever manner he thought best。 but her sister39。s was involved in it, as, she thought, he must be sensible himself. It was a subject, in short, on which reflection would be long indulged, and must be unavailing. She could think of nothing else, and yet whether Bingley39。s regard had really died away, or were suppressed by his friends39。 interference。 whether he had been aware of Jane39。s attachment, or whe ther it had escaped his observation。 whichever were the case, though her opinion of him must be materially affected by the difference, her sister39。s situation remained the same, her peace equally wounded. A day or two passed before Jane had courage to spea k of her feelings to Elizabeth。 but at last on Mrs. Ben39。s leaving them together, after a longer irritation than usual about Netherfield and its master, she could not help saying, ``Oh! that my dear mother had more mand over herself。 she can have no idea of the pain she gives me by her continual refle ctions on him. But I w ill not repine. I t cannot last long. He will be fot, and we shall all be as we were before.39。39。 Elizabeth looked at her sister with incredulous solicitude, but said nothing.