The Design And Implementation Of The Purchasing-selling-stock Management System In Small Business

The informatization of SMEs in China is generally not high, still in the start stage; withthe development of computer technology and the popularization of the computer, theenterprise Invoicing and many other areas have become inevitable. For thepurchasing-selling-stock management system not only to solve production problems withinthe enterprise, but also the suppliers, customers and enterprises of the three together, slowlybuild up, supply and marketing, production, human, material, only business step, developmentmode so as to form the integration of management of enterprises.The goal of this research project is to work for a marketing enterprise thepurchasing-selling-stock management practical problems and difficulties, the design andimplementation of a set of scientific, standardized the purchasing-selling-stock managementsystems, in order to achieve an effective business aspects of the entire inventory of conductcomprehensive information management, in order to reflect the enterprise logistics, capitalflow, information flow third-rate one, reflecting the integration of collaborative supply chainmanagement, to enhance the competitiveness of enterprises. In the specific study in this article,follow the steps in this article system analysis, system design, system implementation andsystem testing for. In which the analysis phase, the paper research analysis, thepurchasing-selling-stock management system needs to help these companies to complete thepurchase of goods, warehousing, outbound sales, inventory, library and transfer of goods,inquiries and customers, suppliers by Data Management and many other businesses, but alsothe introduction of systems management, supplier relationship management and agents aswell as the daily financial management. And on the basis of research on the needs of differentuser groups operating use cases were analyzed and described, learn the user’s specificfunctional requirements, and on the basis of functional analysis, the performance of thesystem is analyzed and discussed. In the system design phase, this paper for the overallstructure of the system was designed, and then analyze the resulting demand for the abovefunctional modules are described in detail and design, the use of charts and timing diagram ofthe system for each functional module operation timing case were expressed. Practicalcompletion of the design work system function modules. In database design, system function According to the demand for back-end database systems are described, given the specificdatabase table structure, and the way to take advantage of the situation ER diagram data entitydescribed. In the system implementation stage, the paper the purchasing-selling-stockmanagement system developed for the final development model based on B/S model systemchosen JAVA as the purchasing-selling-stock management system development platform; thecorresponding database management system will use MY SQL database, For sales enterprisethe purchasing-selling-stock management system MY SQL functions are fully applicable tothe target user. User groups can use the system primarily for fast entry and access to data, toprotect data entry efficiency and security of data access while being able to achieveinformation sharing. In the system testing phase, we use white box and black box testingmethod, the functional modules of the system has been tested in detail to verify the functionof each module, and on the overall performance of the system was tested, and effectivelycompleted this article the study.For sales companies, due to its high degree of information does not have the use of alarge ERP system conditions, so in order to solve this kind of small business informationmanagement problems, we realize the set of system solutions such enterprises, sales, depositand other problems in the process, thus improving its efficiency.