基于C#的电力企业营配数据诊断平台的设计及实现

Design and Implementation of the Distribution Data Diagnosis Platform for Electric Power Enterprises Based on C#

针对电力用户用电信息采集系统中只保存实时采集数据而不具备各种数据分析功能的现状,以C#为开发语言,以SQLite3为数据库后台,结合多线程技术设计并实现了营配数据诊断平台。该平台的各类基础数据来源于电力用户用电信息采集系统,系统主要目标是实现对电压、电流、功率、用户用电量数据的综合分析和汇总。平台主要包括基础数据的管理及批量导入、配变侧生产数据及客户侧采集数据的批量导入、配变侧和客户侧各类异常数据的多种异常分析、供电所配网和台区的诊断报告生成等功能。通过实际应用,该平台能通过用户简单的操作快速查询分析和汇总台区和用户侧的各类数据异常,大大提高了供电所工作人员发现异常和现场处置的效率。

In view of the current situation that the electricity consumption information acquisition system of power consumer only saves real-time acquired data without various data analysis functions,this paper uses C#as the development language,SQLite3 as the database background,and combines with multi-thread technology to design and implement a diagnosis platform for data of marketing and distribution-transmission.All kinds of basic data of the platform come from the electricity consumption information acquisition system of power consumer;the main goal of the system is to realize the comprehensive analysis and summary of voltage,current,power and users’electricity consumption data.The platform mainly includes such functions as basic data management and batch import,batch import of production data on the distribution side and data acquired on the customer side,anomaly analysis of various abnormal data on the distribution side and customer side,generation of diagnostic reports for the distribution network and station area of the power supply,etc.In practical application,through simple operation by the uses,the platform can be used to quickly query,analyze and summarize all kinds of data anomalies in the platform area and user side,which greatly improves the efficiency of the office staff of power station to find anomalies and deal with them on the spot.