【正文】
/ 45摘 要本文通過了解供電公司的管理現(xiàn)狀以及同業(yè)對標(biāo)工作的發(fā)展趨勢。建立先進(jìn)的同業(yè)對標(biāo)指標(biāo)信息管理平臺,快速、準(zhǔn)確地收集各部門同業(yè)對標(biāo)指標(biāo)數(shù)據(jù),將供電公司同業(yè)對標(biāo)工作全面信息化。采用最新的信息技術(shù)和科學(xué)的統(tǒng)計方法進(jìn)行指標(biāo)分析,為供電公司實現(xiàn)對同業(yè)對標(biāo)指標(biāo)的量化分析和指標(biāo)的科學(xué)化管理進(jìn)行新的探索。從而實現(xiàn) “用指標(biāo)評價企業(yè),用業(yè)績考核企業(yè)”的目標(biāo)。系統(tǒng)開發(fā)語言選用 Visual Basic ;數(shù)據(jù)庫選用 SQL sever 2022。以供電公司為主要對象,針對供電企業(yè)的同業(yè)對標(biāo)指標(biāo)管理的具體需求,我們進(jìn)行了系統(tǒng)的分析、研究和實踐工作,使系統(tǒng)主要實現(xiàn)一下功能:實現(xiàn)對供電公司同業(yè)對標(biāo)指標(biāo)的管理,如各指標(biāo)數(shù)據(jù)的錄入、查詢、修改等;設(shè)置指標(biāo)的計算方法。進(jìn)而對指標(biāo)及報表數(shù)據(jù)進(jìn)行計算并用不同的算法展現(xiàn),如展現(xiàn)指標(biāo)的平均值、中位數(shù)、去年同期值、指標(biāo)的增長特征等;對指標(biāo)報表進(jìn)行靈活的查詢分析,如時間序列分析等;設(shè)置指標(biāo)的上下界。對超過界限的指標(biāo)進(jìn)行預(yù)警;進(jìn)行嚴(yán)密的權(quán)限控制機(jī)制。包括實現(xiàn)用戶、角色、權(quán)限、日志等的管理功能。論文從同業(yè)對標(biāo)系統(tǒng)的背景和現(xiàn)狀分析入手,明確了課題的研究意義;文中對系統(tǒng)所設(shè)計的技術(shù)進(jìn)行了簡單介紹,包括 Visual Basic 和 SQL sever 2022。隨后對系統(tǒng)進(jìn)行了需求分析,對需求的獲取模式和分析方法以及系統(tǒng)的功能性和非功能性需求進(jìn)行了描述,并對系統(tǒng)的總體架構(gòu)進(jìn)行了設(shè)計,講解了系統(tǒng)的模塊劃分和各模塊的主要功能、數(shù)據(jù)庫的設(shè)計等;然后逐步描述了各部分的實現(xiàn),詳細(xì)說明了系統(tǒng)表現(xiàn)層和業(yè)務(wù)層實現(xiàn)中的關(guān)鍵問題;最后對項目進(jìn)行了總結(jié)。 該系統(tǒng)的初步的應(yīng)用結(jié)果表明,系統(tǒng)功能較為完善,能夠較好地滿足應(yīng)用需求,對為優(yōu)化企業(yè)管理和工作流程、提升企業(yè)管理水平有一定的促進(jìn)作用。關(guān)鍵詞:供電公司;同業(yè)對標(biāo);管理系統(tǒng);I / 45ABSTRACTIn this paper by understanding the Power pany39。s management status and development trend of the industry standard an advanced benchmarking target information management platform,collect the benchmarking index data of departments fast and accurate,and Supply the pany with a prehensive information technology industry benchmarking the latest IT and scientific statistical methods, were analyzed with quantitative analysis of the industry standard indicators and indicators of scientific management, the power pany to achieve new exploration. So that the evaluation of enterprise indicators, performance evaluation of enterprises.System development language used Visual Basic ,database selected SQL sever 2022. The power pany for power supply enterprises with the industry standard index management needs, we conducted a systematic analysis, research and practice, so that the main achievement of the functions: the power pany with the industry standard indicators management, such as indicators of data entry, query, modify, etc.。 the calculation of the set indicators. Indicators and report data thus show the calculation and use a different algorithm, such as to show the average of the indicators, the median value of the same period last year, indicators of growth characteristics。 indicators statements flexible query and analysis, such as time series analysis。 set the upper and lower bounds of the index. Early warning indicators over the boundaries。 strict access control mechanisms. Including users, roles, permissions, log management functions.The analysis of papers from the same industry background and status of the standard system to clear the significance of research projects。 a brief introduction to system design technologies, including Visual Basic and SQL sever the system needs analysis, demand access mode and methods of analysis and system functional and non functional requirements are described, and overall system architecture has been designed to explain the modular division of the system and each module the main feature, database design, etc.。 and then a stepbystep description of the implementation of the various parts of the detailed description of the key issues in the system, the presentation layer and business layer。 a summary of the project.The system application results show that the system function better, and better able to meet the application requirements, and optimize business management and workflow, and improve enterprise management level role.Key words:Power panies。 Benchmarking。 management system。II / 45目 錄摘要………………………………………………..…….….…………….. .IABSTRACT ………………………………………….……………………..…………….II第一章 前言….……….………...……………………………………….….…………….. 1 系統(tǒng)的開發(fā)背景..........................…… …….………….………..1 國內(nèi)外的研究現(xiàn)狀...........................……….......……… …….………….………..2 本文的主要工作......................…………………………….…....……..………2 本文的組織結(jié)構(gòu)..... .................……………………...……….…....……..………3第二章 開發(fā)環(huán)境和工具...................….………………………….…..….………….4 Visual Basic 簡介 ……………………………… ……………………………..4 Visual Basic 的語言特性…….………… ……………...………………..4 Visual Basic 的配置要求……….…… ………………...………………..4 SQL sever 2022 簡介……………….……… ………...………………..5 SQL sever 2022 數(shù)據(jù)庫特點………………….… ……………………...5 SQL sever 2022 的配置要求………………….… ………………………...6第三章 系統(tǒng)分析..........................……………………...……….....……..……..................7 系統(tǒng)需求分析.................……………………...……….....……..……..................7 系統(tǒng)需求.............……………………...……….....……..….…..................7 需求分析.............……………………...……….....……..……...................7 可行性分析....................……………………...……….....……..……...................7 經(jīng)濟(jì)可行性分析…………..…………...……….....……..……..................7 技術(shù)可行性分析…………..…………...……….....……..……..................8 系統(tǒng)功能流程圖………….............…………...……….....……..……..................8第四章 系統(tǒng)設(shè)計.………….………….……………………..….……...…..….………...9 系統(tǒng)功能分析…….………….……………………..….……...…..….…...……...9 系統(tǒng)實現(xiàn)的功能…….……………………..….……...…..….….....……...9 系統(tǒng)的功能模塊…….……………………..….……...…..….…...…..…...9 數(shù)據(jù)庫設(shè)計…….………….……………………..….…….....…....…..………...10 數(shù)據(jù)庫的創(chuàng)建…….……………………..….…….......…....…..………...10 數(shù)據(jù)表的創(chuàng)建及表的物理結(jié)構(gòu)………..….….….......…....…..………...11III / 45 創(chuàng)建 ODBC 數(shù)據(jù)源………..….…....................….......…....…..………...12第 5 章 系統(tǒng)的實現(xiàn)………..….…....................…................................…....…..………...13 創(chuàng)建工程供電公司同業(yè)對標(biāo)指標(biāo)管理系統(tǒng)………..….…............…..………...13 系統(tǒng)的主體窗口………..….…....................….......…....…..…..................……...13 主體窗口的設(shè)計過程………..….…...................….......…....…..………...13 主體窗口菜單的設(shè)計………..….…....................….......…...…..………...14 公共模塊的創(chuàng)建………..….…....................….......…....…..…..................……...15 系統(tǒng)用戶管理模塊………..….…....................….....................…....…..………...16 用戶登錄窗體的創(chuàng)建………..….…....................….......…....….………...16 用戶注冊窗體的創(chuàng)建………..….…....................….......…....….………...17 用戶密碼修改窗體的創(chuàng)建………..….…....................…............………...17 系統(tǒng)的指標(biāo)管