Power Supply Enterprise Electricity Charge Centralized Accounting System Based on MVC Architecture

Abstract

The continuous expansion of the scale of power users has brought tremendous pressure to the accounting of electricity charges. Faced with this situation, to ease the workload of electricity accounting, a centralized electricity accounting system for power supply enterprises based on Model View Controller (MVC) architecture is studied. With the help of the MVC architecture pattern, the three-tier framework of the electricity fee accounting system is designed. Sql server 2008 is applied to design the system database, including the establishment of E-R diagram and the design of the data table. There are two core functional units in the system: the power consumption statistics unit and the electricity accounting unit. The former unit obtains the power consumption data of users, and the latter unit completes the centralized accounting of electricity charges combined with the unit price. The results verify that under the designed system, the average absolute error of the user’s electricity charge reaches the relative minimum, which indicates that the accounting quality of the system is higher.