Help! ! ! The supermarket management system c# compiles the main modules: sales management, member management and employee management.

Design of supermarket management information system

I. Purpose and significance of supermarket management system design

In order to manage the supermarket better and more conveniently, I designed the management system. This system is a set of small supermarket management system developed by using SQL SERVER 2111 database. The system mainly includes a login module and five sub-modules (administrator management module, customer management module, buyer management module, manager management module and salesman management module). Let different users enter different interfaces through different user permissions, including system administrator, customer, manager, buyer and salesman. The system administrator has the functions of viewing purchase information, sales information and user information, and adding, modifying and deleting user information. Customers can browse all the commodity information or browse a certain commodity information according to the trade name or commodity ID, and can buy a certain commodity. After the successful purchase of the commodity, the number of commodities in the commodity information table will be reduced relatively, and the records of the sold commodities will be increased in the sales table. Managers can view the information of purchasing and selling goods; The buyer can view all orders, add orders, modify orders, delete orders and other functions; Salespeople can view sales information.

2. Design of supermarket management system

1. Definition of the problem

In view of the current development trend of rural grocery stores to small and medium-sized supermarkets and the backward management technology of rural supermarkets, it is increasingly necessary to develop a management system suitable for rural small and medium-sized supermarkets. The purpose of developing supermarket management system is to facilitate administrators and consumers, and we have to solve the following problems:

a) commodity information management in supermarkets;

b) warehouse management in supermarkets;

c) supermarket staff management;

d) commodity sales management;

e) management of supermarket members;

f) statistics of daily data;

2. Feasibility study

From the technical point of view, it is not difficult to realize commodity information management, warehouse management, employee management, sales management, membership management and daily data statistics in supermarkets, and these functions are all frequently encountered; Economically, because they belong to people without capital, they can only invest in simple development equipment.

3. demand analysis

3.1 system overview

background: with the development of information technology and economy in China, computers have been widely used in various fields. Computers bring convenience to people's lives, but also need to develop corresponding management systems. According to the current rural situation, the development trend of many grocery stores to small and medium-sized supermarkets is becoming more and more obvious, but in reality, the management of many supermarkets in rural areas relies on the original human management, and there is no corresponding management system, which brings a lot of unnecessary troubles to the daily supermarket management.

3.2 Objective

By implementing the supermarket management system, supermarket managers can manage the goods in the supermarket conveniently, and at the same time, consumers can enjoy the convenience of shopping.

3.3 System functional requirements

a) Supermarket employees can add, delete, update and query the information of commodities and supermarket members, and can query the information of commodities according to different types;

b) the manager of the supermarket can query the information of various commodities in the supermarket warehouse and know the inventory information of various commodities in the warehouse in time;

c) the manager of the supermarket realizes the management of the employees in the supermarket through the supermarket management system, and can query, add, delete and update the employee information;

d) the administrator can simply query the department information of the supermarket;

e) The supermarket management system can classify the employees in the supermarket, and give different permissions to different types of employees to manage the supermarket;

3.4 System operating environment requirements

Hardware: more than 256MB of memory and more than 61GB of hard disk;

software: windows operating system, mysql database, myeclipse.

4. analyze and synthesize

external entities: goods, customers

data flow: goods information, bills

a) establish the concrete model of the current system, as shown in the following figure

b) abstract the logical model of the current system, as shown in the following figure

c) establish the logical model of the target system, as shown in the following figure

DFD diagram. Supermarket employees can get the price of the goods by sorting out the commodity numbers of the goods purchased by customers in the database, and at the same time, they can get the shopping quantity of a certain commodity by sorting out, and then adopt different checkout algorithms by judging the identity of customers, give the bills to customers, and customers can take the goods away after paying.

5. Overall design

1. Through the conversion of DFD diagram, the software structure diagram of the supermarket management system is obtained, as shown in the following figure

2. Through the further analysis of the software structure diagram, the framework diagram of the supermarket management system is obtained, as shown in the following figure

6. Detailed design

1. Module design and function description

a) Login module: Through the login module, different types of employees can log in to different interfaces, which makes it easier for different types of employees to have different operating rights in the supermarket management system.

b) employee management module: the employee management module is mainly for the convenience of supermarket administrators to manage supermarket employees. Through the employee management module, it is mainly to add, delete, modify and check the employee information.

c) warehouse management module: the warehouse management module is mainly used to query commodity inventory information and commodity warehousing and warehousing. Through the warehouse management module, the administrator of the supermarket management system can query the inventory information, the information of goods warehousing and outbound.

d) sales management module: the sales management module is mainly used to calculate the closing of goods. The sales management module can facilitate the checkout of goods.

e) department management module: the department management module is mainly used for department management. The department management module mainly realizes the increase, deletion and update of department information.

f) member management module: the member management module is mainly used for managing members. Through the member management module, members can be added, deleted, changed and searched.

2. database design

database E-R diagram

7. data structure design:

(1) Structure of user table

field name field type field size description

userid int 4 user id

username varchar 51 user name

p>userPassword Varchar 51 user password

p>userAddress Varchar 51 user address.

user authority varchar51 user type (permission)

user gender varchar11 user gender

p>userAge Int 4 user age