随着信息技术的发展和城市信息网络建设的日趋完善,城市信息化将成为城市建设和发展的必然趋势。城市一卡通项目正是在此契机下,
顺应时代发展潮流而产生的。城市一卡通系统将采用先进成熟的计算机技术,构城市一卡通应用的信息平台,为城市息化管理提供科学依据。
城市一卡通客运IC卡电子收费系统的目的,是把目前公共汽车的无人售票及其它售票方式以IC卡电子收费作为支付手段,以计算机系统为信息处理方法的现代化管理系统。交易统计及帐务清算子系统负责完成前台联机交易统计、前台脱机交易统计和后台帐务清算的功能。
本系统采用Visual Basic 6.0 作为前台开发工具,SQL Server 2000作为后台数据库,系统具有较完善的安全机制且具有实用、高效、易于操作等特点。
本文以交易统计及帐务清算子系统的开发为背景,介绍了城市一卡通项目的概况,交易统计及帐务清算子系统的概念等。全文共分为概述、系统分析、设计、实施、系统运行等五章,论述了该子系统开发的原理、方法,详细阐述了系统分析和系统设计的技术及其应用,并记述系统的实施和运行过程等内容。
关键词 交易统计;帐务清算;VB 6.0;SQL Server2000
ABSTRACT
Along with the development of the information technique and the constructing of city information network becoming increasingly perfectly, city informationally will become the inevitable trend of city constructing and development .The item of One Card Though A City is exactly the result of acclimating the current of the development of the age. The system of One Card Though A City will adopt the advanced and mature computer technique to build the information field of the application of One Card Though A City and provide science gist to the management of city informationally.
The aim of One Card Though A City passenger transportation electron charges system is to take IC card electron charge as payment method instead of the current charging method of no man selling tickets and other methods of selling tickets, and build modern management system, which take computer system to deal with information. Trade statistic and account liquidation subsystem is to accomplish the function of online trade statistic in the front, offline trade statistic in the front and background account liquidation.
This system adopts Visual Basic 6.0 as exploring tool in the front and SQL Server 2000 as backstage database, so the system has the perfect and safe mechanism and it has the characteristics of practicality, high efficiency, and easily operating etc.
Taking the exploration of the trade statistic and account liquidation subsystem as background, the dissertation interposes the general situation of One Card Though A City item and the conception of trade statistic and account liquidation subsystem etc.. The whole dissertation is separated into five chapters: Summarize, System Analysis, System Design, System Implement and System Function. It discusses the principle and method of the exploration of this subsystem, and expatiates in details the technique and the application of system analysis, system design, and in the end it records and narrates the process of system implement and system function.
Key words trade statistic,ccount liquidation,VB6.0,SQL Server 2000
目 录
在权限管理方面,从实际情况出发,通过前台开发工具对用户登录权限进行严格划分和控制。
(1).使用统计清算系统的用户人员划分成三类:
① 总管理员:对系统拥有最高权限,可以添加和删除用户人员,并拥有对系统的查询、操作等权限。
② 系统管理组:对系统拥有较高权限,可以添加用户人员,并拥有对系统的查询、操作等权限。
③ 操作组:系统的录入员,主要拥有对系统的查询、操作等权限。
(2).在密码存储方面,应采取一定措施使密码不可直辨。
3 系统设计