基于VFP的超市進銷存管理系統【畢業(yè)論文+源代碼】


摘   要
超市進銷存管理系統是目前應用于公司或是企業(yè)進銷存管理系統中的典型代表，涉及到了商品或貨物管理中主要的4個方面，即進貨、銷售、庫存及報損。通過一個型超市進銷存管理系統的例子，介紹了現代企業(yè)進銷存管理信息化的一般解決方案，其重要性不言而喻。但是，目前超市在具體的業(yè)務流程處理過程中仍然使用手工操作的方式來實施，不僅費時、費力，效率低下，而且無法達到理想的效果。
本系統是根據企業(yè)的特點，集進、銷、存、分析于一體，為企業(yè)量身定做的進銷存管理軟件。在設計過程中最大限度滿足用戶的要求，因此，該系統具有較強的實用性和針對性。本系統界面友好，操作簡單，可維護性強，功能完備。本論文介紹了進銷存管理信息系統開發(fā)的全過程，主要從管理思想、系統分析說明、系統設計說明、系統使用說明、技巧與體會等方面對本管理系統加以論述。前言部分指明了選題背景和開題意義；而后又詳細介紹了系統的分析、系統的開發(fā)與設計說明等內容；最后給出了系統的使用說明和系統設計的心得體會。   
關鍵詞：系統設計、系統分析、進銷存、信息管理系統
 
Abstract
The supermarket enters sells saves the management system management system is applies at present in the company perhaps the enterprise enters sells saves in management system management system's typical representative, involved in the commodity or the cargo management the main 4 aspects, namely the inventory, the sale, kept in stock and write off. Enters through a supermarket sells saves management system management system's example, introduced the modern enterprise enters sells saves the management informationization the general solution, its importance is self-evident. But, the supermarket still used the manual operation in the concrete operation flow treating processes the way to implement at present, not only time-consuming, the hard sledding, the efficiency is low, moreover is unable to achieve the ideal effect. this system is according to enterprise's characteristic, the collection enters, sells, saves, the analysis in a body, measures the body for the enterprise to make to order enters sells saves the management software. Maximum limit satisfies the user in the design process the request, therefore, this system has the strong usability and pointed. This system contact surface is friendly, the simplicity of operator, maintainable, the function is complete. The present paper introduced enters sells saves the management information system development the entire process, mainly from aspects and so on management concept, system analysis explanation, system design explanation, system operating instructions, skill and experience elaborates to this management system management system. The foreword part has indicated the selected topic background and opens the topic significance; Was also then detailed introduced system's contents and so on analysis, system's development and design notes; Finally has given system's operating instructions and the system design attainment experience.
 key word：The system design, the system analysis, enter sell save, information management system

目錄
引言……………………………………………………………………………………...1
1、 本課題的研究意義和目的………………………………………………………….1
1.1 開發(fā)背景……………………………………………………………………………2
1.2 研究超市進銷存管理系統的意義…………………………………………………2
2、 系統設計……………………………………………………………………………4
2.1  系統目標設計………………………………………………….. ………………...4
2.2  開發(fā)設計思想……………………………………………………………………..4
2.3 開發(fā)和運行環(huán)境選擇………………………………………………………………5
2.4  系統功能分析……………………………………………………………………..5
2.5 系統功能模塊設計…………………………………………………………………5
3、 數據庫設計…………………………………………………………………………7
3.1 數據庫需求分析……………………………………………………………………7
3.2 數據庫概念結構設計………………………………………………………………8
3.3 數據庫邏輯結構設計………………………………………………………………9
3.4 數據庫結構的實現………………………………………………………………..11
4、 各個功能模塊的創(chuàng)建…………………………………………………………….15
4.1 系統菜單的設計…………………………………………………………………..15
4.2 創(chuàng)建“Splash”表單……………………………………………………………….16
4.3 身份驗證界面的設計……………………………………………………………..18
4.3.1 用戶身份驗證界面……………………………………………………………...18
4.3.2 創(chuàng)建“修改密碼”表單………………………………………………………….21
4.4  信息管理模塊設計………………………………………………………………24
4.4.1 “商品信息管理”表單…………………………………………………………24
4.4.2 “輸入查詢條件”表單…………………………………………………………31
4.5 日常操作模塊設計………………………………………………………………..34
4.5.1 “商品進貨操作”表單…………………………………………………………35
4.5.2 “商品出貨操作”表單…………………………………………………………36
4.6 信息查詢模塊設計………………………………………………………………..42
4.6.1創(chuàng)建“進貨信息查詢”表單……………………………………………………42
4.6.2創(chuàng)建“出貨信息查詢”表單……………………………………………………43
4.6.3創(chuàng)建“庫存信息查詢”表單…………………………………………………….46
5、系統的編譯和發(fā)行…………………………………………………………………48
參考文獻……………………………………………………………………………….49
結束語………………………………………………………………………………….50
致謝…………………………………………………………………………………….51