Shaoxing County Industrial And Commercial Food Safety Management System

The function of this system is to solve the problem of food security fundamentally. It strengthens food security with the help of using information technology.This system is made up of six modules that refers to commodity management, supplier management, customer management, inventory management, purchase management and sales management. The module of commodity management contains these modules, such as: submodule of large class commodity management, submodule of small class commodity management, and submodule of commodity information management is built up. Three modules (customer management, commodity management and supplier management) realize the implementation of fuzzy query. Commodity information can be imported from the Excel and can be exported to the Excel. The core of this system is the module of purchase management and sales management. The module of purchase management can allow users to establish electronic account, print purchase daily report and monthly report, query purchase information and finish the process of statistical purchase information all the time. The module of sales management realizes many functions. Including implementation of the function that is similar to purchase management, the function of retail management module and the function of query and statistics. The module of retail management realize the functions of printing supermarket receipt, controlling the money box to open and shut and showing the price on the customer display screen.This system development is strictly in accordance with the related ideas of software engineering. The procedure is designed strictly accroding to the sequence of a fountain (or iterative) system development. That is to say, firstly, the requirement analysis should be carried on. And then constructional design, design of the detailed process should also be carried on. Secondly the function is realized through the process of programming. At last this system is tested and maintained.It adopts the model of client/server (C/S). 3-layer structure is used for software architecture. The first layer is database, the second layer is the rules of business and the third is expression layer. In the first layer not only tables but also a lot of storage procedures and views are set up. In the second layer various of classes are established. The methods of each class are used to call the corresponding storage procedures. Among these classes, the DataBase class provides amount of methods of connecting database and calling storage procedures. As for the third layer, the relative friendly interface is designed. It can realize its function through using the second layer. Using the second layer realizes the function of accessing data in database instead of using the first layer directly when users access data.After more than one year operating this system, users give good comments on it. Except for some slight changes, it is not changed. It achieved the goal of proving infomational service to customers and helping them set up the libraries of commodities, clients'information and suppliers'information and at the same time set up perfect electronic sales accounts and purchase accounts that is used for the sales and purchase inquiry, statistics and analysis. The accounts can give a warning for those overdue commodities and can realize the purpose of random inspecting enterprises'electronic and sales for the bureau of commerce and industry and the purpose of monitoring the sales activities of enterprises .