基于MVC+MSSQL+EF的软件平台接口管理系统的设计与实现

摘要

当前在不少软件平台系统的开发中,开发、调试、测试和交付都是以接口为基础进行交互,同时以接口为单位划分责任人、代码审查、考核员工绩效,因此接口数据的统计、呈现和管理尤为重要.大多企业的软件平台接口管理的现状:不同平台、版本和部门接口数据不能及时同步因而数据不完整,接口设计、实现、审查、测试和交付比较独立因而数据不一致、不可靠,多个系统接口数据零散且前台不可配置,因而后期统计整理和维护量大.针对这一需求和现状,基于MVC+MSSQL+ EF架构采用敏捷开发方式,结合SVN、Phabricator、Robocopy和Jenkins机制跟踪审查代码、自动同步数据和实时发布新版本.本文对系统的整体框架、实体类模型设计、可动态配置的前台、MVC+ MSSQL+ EF架构在系统中的应用和关键技术进行重点描述.本系统目前已应用于上海某通信公司RRU、BBU等部门,实际应用证明本系统具有跨部门、跨平台、可配置、高效、安全和可靠的特点.%At present,the interactions between development,debugging and testing in many developments of software platform system are based on interface data.Meanwhile,the interface is divided into the responsible person,code review and employee performance evaluation.Therefore,statistics,presentation and management of the interface data are particularly important.This paper analyzes the present situation of software platform interface management system in most enterprises.First,different platforms,versions,and departmental interface data are not synchronized in time,and thus data is incomplete.Second,interface design,implementation,review,testing,and delivery are relatively independent,resulting in inconsistent and unreliable data.Third,many system interface data are relatively fragmented and the user interfaces of most system cannot be configured so that the latter statistics and maintain the load is heavy.In view of this demand and current situation,we adopted the agile development methods based on architecture of MVC + MSSQL + EF,and combined with the mechanism of SVN,Phabricator,Robocopy and Jenkins for automatic data synchronization and real-time new versions release.This paper focuses on the overall framework of the system,the design of the entity class model,the dynamic configuration of the foreground,the application of the MVC + MSSQL + EF architecture in the system and its key technologies.The system has been applied to RRU/BBU and other departments of a communication company of Shanghai.The actual operation proves that the system has the characteristics of cross department,cross platform,confignrable,efficient,safe and reliable.