摘要
分析了自适应上报系统的要求,提出了利用微软提供的OWC(office web components)组件中的Spreadsheet控件实现基于B/S架构的自适应上报系统的解决方案。该解决方案通过后台用户对上报报表和表中需前台用户填写的内容进行设置,自动建立与上报报表相对应的数据表来保存数据,并可在此基础上由后台用户设定统计报表的格式与内容,完成数据的统计和汇总工作。此解决方案避免了因用户需求变更而导致二次开发的可能性,并为不同类型的上报系统提供了通用平台。
The demands of the self-adjusting reporting system is analyzed. The solution of a self-adjusting reporting system in B/S model is put forward which is implemented on Spreadsheet ofOWC groupware provided by Microsoft. In the system the tables filled in by end usersare designed by background users. System can automatically produce a new data table to save the data submitted by end users and calculate aggregate functions on the data as specified by the background users. The solution avoids the possibility of the second implementing resulted from the changes of users' demands. The universal platform for the different reporting system is provided.
出处
《计算机工程与设计》
CSCD
北大核心
2007年第19期4810-4812,共3页
Computer Engineering and Design