基于VBA和ASP.NET的科技项目申报系统的设计与实现

针对目前常用的科技项目申报系统存在网上录入工作繁琐,不能直观编辑申报书,容易出错等缺点,使用VBA技术和ASP.NET技术设计一个科技项目申报系统。系统分为申报书模块和项目管理模块两部分。申报书模板使用word文档,使用microsoft office里面内嵌的VBA语言对文档进行编程,实现申报书基本数据规范、准确录入,并使得申报书中的内容可以方便地提取并存入数据库。项目管理模块使用ASP.NET技术和C#语言进行编程,实现申报书的上传,申报书信息的读取、申报书信息录入数据库,以及网上评审和系统管理等功能。

Design and Realization of Project Application System Based on VBA and ASP.NET

There are several problems in current science and technology application system such as complex recoding, indirect edition of the project application reports and easily making mistakes. Based on VBA and ASP. NET technology, a science and technology application system is designed. The system consists of two parts, which are application and management module. In application module, the template of application is stored as word documents. By using the VBA language in microsoft office, the word documents are programmed to realize the basic data standardization of the application reports and accurate recording, and facilitate the extraction and store of reports. In management module, the ASP. NET technology and C~ program are used to realize the upload, access and database input of reports, online evaluation, system management and other relevant functions.