The Design And Impelmentation Of Purchasing-selling-stock Management System For Shopping Square

With the rapid development of domestic economy, there are more and more small andmediam sized retail enterprises small, such as department stores, shopping plaza, and soon.Wide variety types of goods are sold by these enterprises, it is difficult to manage, andthe purchasing-selling-stock management system will become the core of enterpriseoperation and management, but also the key to enterprises to obtain benefits. The use ofcomputer management can maximize the accurate, fast, efficient and so on,and alsoprovide strong support for the service management of retail enterprise.This system is based on a certain mainly retail shopping square of integrated services.The background database is SQL Server2008that is a good and excellent database withstrong retractility and usableness, and the database have distributed architectonic. Theexploitation tool of proscenium is PowerBuilder9.0that is strong database exploitationtool, and adopt C/S mode,which can give full play to the client PC processing power, fromthe application layer to ensure the security of the database, reduce the network traffic,improve the running efficiency of the software.This system used for processing various integrated service of shopping plaza,realized commodity enters sells saves the business, supplier information, contractinformation, the management of the basic information of the goods; It provides a varietyof analysis report, has relatively rich data collection and function of comprehensiveanalysis. This system has a strong human-computer interaction function, and provides aflexible and convenient query mode, including the query of inventory goods, inventoryalarm system, and report for the year, month, day’s sales statistics and sales history inquiry,the customer to return the goods, and other functions, and thus more convenient usermanagement of the enterprise, can provide good decision analysis for shopping plaza. Inthe supplier offers two payment settlement aspects: pool and on a commission basis. Atthe same time, this system has good reliability, security, and realize.And this system hasrealized the multi-user operating of different permissions.In a word, the purchasing-selling-stock management system of Shopping Squarerealized the information management of enterprise business, that is the process frompurchase, sales, storage to management, and truly realized paperless office, error freeoperation and high efficiency operation.This system is a assurance for the running ofShopping Square, and can make favorable economy benefits for Shopping Square. So the study of the system has important and practical significance.