文档介绍：基于FoxPro的MIS系统中
实现EXCEL报表输出
院系:信息科学与技术系
专业班:通信工程0802班
基于FoxPro的MIS系统中
实现EXCEL报表输出
Excel Report Output
Based on FoxPro MIS System
摘要
随着计算机系统的更新,越来越多的人开始使用win系统。然而,许多企业里的管理信息系统在很早就存在,现在已逐渐暴露出问题。以中原电子集团—总装分厂的MIS系统为例,该集团的工时MIS一直使用这样一个集界面维护、系统开发于一体的工具系统,在过去的几年里,它在MIS的维护和二次开发中起到了极大的作用。该管理系统可以在DOS系统下正常使用,但是在win系统就无法实现数据库表自动生成Excel报表的输出。针对目前正在使用的原系统普遍存在的不同系统的适用性差,实现在win平台下也能正常使用,对原系统进行全面的分析,熟悉该公司的MIS系统界面及开发维护工具程序的设计思想,阐明了系统的设计方法,并对系统功能做了详尽的说明,找出程序中的不完善之处,并进行修改用以实现基于FoxPro的管理信息系统,借助win平台实现数据库表以Excel表形式输出设计思路与实现方法,使更多的win系统用户能够更方便、更快捷地运用该系统资源。
关键词:管理信息系统数据库表 win平台
Abstract
With the update puter systems, more and more people begin using the win system. However,in panies which are existence in many years ago, are gradually exposed problem now. As Zhongyuan Electronic Group-the MIS system of the assembly plants for example, the group's working Management information systems have been using s set of interface maintenance and system development in one of the tool system, in the past few years. It played a significant role in the MIS and secondary development .the management system is used normally under the DOS system, but there is not changed the database tables to Excel report output automatically in the win system.
Against to mon system currently being used in the original system is poor. in order to achieve this system for normal use in the win platform. Making prehensive analysis of the original system, and being familiar with pany's MIS system interface and development to maintain the utility design ideas, clarify system design, and the functionality ,a detailed description ,It finds out the imperfections in the program, and make changes to the FoxPro -based management information system, with the win platform database table to Excel table output in the form design ideas and implementation methods .In order to achieve the win platform for normal use. more win users of the system more convenient, more efficient use of the system resources.
Key words: manageme