With the continuous development of enterprises and the arrival of the information age, the construction of ERP system for retail chain enterprises is of great and far-reaching significance to supermarket enterprises. The following is what I arranged for you for your reference.

Supermarket Management System Based on C#

abstract

Abstract: This paper first analyzes the problems faced by the retail industry and the current situation of retail informatization. Secondly, combined with the analysis of system requirements, the data flow diagram, E-R model and functional structure diagram of the system are designed, and the functions of the system are described. Finally, a supermarket management system based on C# is designed with C# as the development language, Microsoft Visual Studio 2012 as the development tool and SQL Server 2000 as the background database.

content

Keywords: data flow chart E-R model supermarket management system

1. Development background

At present, the distribution of three levels of retail informatization in China is basically clear: in high-level enterprises, the core structure system of purchasing, selling and storing basically operates normally, and the main problems are the deep excavation and processing of materials, the high integration of financial business systems, the unity and stability of systems and materials according to enterprise mergers and acquisitions; Mid-range enterprises have changed from decentralized management to centralized management, and the core structure system of invoicing is changing from decentralized single-store management and sales accounting to chain management and purchase price accounting; Low-end enterprises have just set foot in and turned to chain retail, and their understanding of informatization is at a superficial level. The construction of business process and information system needs a period of exploration, understanding and step-by-step process. The whole retail industry has gradually reached a consensus on informatization: informatization is a necessary means for enterprises to develop continuously and enhance their core competitiveness.

2. Main technologies

The system uses C# as the development language. The development tool is Microsoft Visual Studio 2012; The database adopts SQL Server 2000.

2. 1 hair language C#

C# is an object-oriented high-level programming language released by Microsoft, which runs on. NET framework. It is a safe, stable, simple and elegant object-oriented programming language from C and C++. Doing a good job in energy-saving management of large public buildings is of great significance to realize the goal of energy-saving and consumption reduction of public buildings in the Twelfth Five-Year Plan. As shown in figure 1, the energy consumption of some public buildings in Shenzhen was investigated, and it was found that the energy consumption of different types of public buildings was quite different, especially supermarket buildings, which were much higher than other types of public buildings. Energy saving and consumption reduction in supermarket buildings is an urgent problem to be solved.

Relevant personnel at home and abroad have conducted in-depth research on the energy-saving problems of large public buildings, and put forward many solutions, which have also received certain results. However, due to some difficulties in obtaining basic data, the human factors of energy consumption analysis are too large or unable to go deep. Experts at home and abroad have taken many measures to solve this problem. For example, in 2000, Facility Power Engineering Company developed the executive management analysis software PACRAT[3], which has the function of remote data transmission, provides real-time analysis and automatic diagnosis, and can diagnose cooling system energy saving, cooling system energy saving and building energy consumption. 200 1 Silicon Energy Company developed the energy consumption management software EEM SuiteTM[4], which is based on a web browser and can receive remote data in real time and display it visually, but it can't define the diagnosis model in advance []. Tsinghua University Building Energy Conservation Research Center [5] has developed the "Sub-metering and Real-time Analysis System for Large Public Buildings", which realizes the stable, continuous and real-time collection, transmission, storage and analysis of sub-data for the analysis and research of energy conservation diagnosis methods.

The existing systems have different functional emphases due to different goals. Some tend to implement and manage energy consumption, some focus on real-time monitoring of energy consumption, and some focus on diagnosis of energy saving potential. In order to continuously obtain accurate energy consumption data of various parts of large public buildings, monitor building energy consumption, build an energy-saving effect evaluation platform and diagnose building energy-saving potential, it is necessary to establish a multifunctional energy management system for supermarket chains. The system can monitor the building energy consumption in real time, clearly understand the energy consumption status of each store, compare the energy consumption of the same type of building horizontally, find the gap and promote improvement; It can also be used as a stalk to quantify the effect of energy-saving transformation; It can also provide statistics of energy consumption data and provide a basis for users to formulate energy rules and regulations.

2 chain supermarket energy management system platform

2. 1 basic principle of the system

Fig. 2 energy management system diagram of chain supermarkets

Fig. 2 depicts a schematic diagram of the energy management system of a supermarket chain. The system includes software and hardware. The software mainly includes data acquisition software, data monitoring software and energy-saving diagnosis software. Hardware equipment mainly includes data acquisition instruments, gateways, servers, etc. For supermarket buildings, the main collection parameters are water, electricity, gas, cold and heat, etc. The data acquisition gateway will send commands to the data acquisition instrument regularly. After receiving the command, the data acquisition instrument will send the data to the gateway for storage on a regular basis, and then to the data center, and the data of the data center will be reported to the upper data center on a regular basis until it is reported to the highest data center. Data monitoring software can be based on the framework of web browser, and relevant personnel can access the monitoring system as long as they can access the web page. From the functional requirements, the system based on web browser is easier to realize the combination of manual data collection and automatic data collection, and may also save the trouble of software installation and upgrade.

2.2 Classification and breakdown of building energy consumption of supermarket chains

According to the energy consumption characteristics of supermarket buildings, energy consumption collection is divided into six categories: electricity, water, gas, heat, cold and others. In supermarket buildings, electricity accounts for a considerable part and is used for different types of equipment. In order to clearly understand the energy consumption of each part, according to the energy consumption characteristics of supermarkets, the electricity consumption is divided into six categories: air call electricity, lighting electricity, elevator electricity, cold chain electricity, fresh electricity and other electricity. Through the comparative analysis of these six energy consumption projects, we can initially find the energy-saving potential of supermarket buildings. Through in-depth analysis of each item, we can deepen the diagnosis and analysis of energy consumption and fully tap the potential of energy saving.

3 chain supermarket energy management system function

The energy management system platform of chain supermarkets should include central air conditioning, electric power, lighting, fresh food and cold chain systems, especially the monitoring and implementation of central air conditioning system and energy-saving management. The functional features of the system are as follows:

Realize the energy metering of the headquarters.

The headquarters conducts classified monitoring, energy consumption index inquiry, energy consumption quota management, energy consumption ranking, etc. On-line monitoring and dynamic analysis are carried out in the form of charts, which provides a basis for refined energy management.

Realize the diagnosis and analysis of energy consumption in headquarters.

Based on the sub-metering platform of the headquarters, the energy data are further mined, analyzed, processed and processed. It can realize that headquarters can diagnose and analyze the energy consumption of stores regularly, give diagnosis reports regularly, and correct unreasonable energy consumption in time when it is found.

Realize the overall optimal control of the system.

On the basis of diagnosis and analysis, suit the remedy to the case, through automatic control means, realize the overall optimization control of each system in the store, instead of "energy saving" in regional control, realize centralized supervision by headquarters, decentralized control by individual stores and overall optimization of the system.

Evaluation of energy-saving effect of single store

Based on diagnostic analysis and optimal control, online evaluation of a single store or a single energy-saving measure can be realized, and the objectivity of energy-saving effect can be ensured.

Realize centralized operation and maintenance management at headquarters.

Headquarters will make overall coordination, reduce energy management links, optimize energy management processes, reduce the implementation and management costs of energy systems, and improve labor productivity. At the same time, the use of information technology can speed up the response ability of energy system failures and anomalies.

4 abstract

This paper introduces the energy consumption level of public buildings and the research status of energy saving, probes into the real-time monitoring and management of chain supermarket buildings by using the energy management system, and analyzes the system energy mouse model and system functions. Through a series of functions of the system, dynamic data monitoring, statistical analysis, online diagnosis, energy-saving effect evaluation and so on can be realized, and the real energy consumption problem of chain supermarket buildings can be mined from real-time data. Therefore, the chain supermarket energy management system has important practical significance for energy saving and consumption reduction and management.

Related suggestions: