PB网上考勤系统设计.doc

摘 要 随着社会发展，各种国家行政部门、企事业性单位不断壮大与完善，其分机机构、分子公司分布不同地区和城市，单位或公司的员工不断增加。为了方便单位管理部门实时、准确对所有员工进行考勤管理，许多新型信息化考勤系统应运而生。本文研究了一种基于INTERNET广域网络的考勤方案，此方案与现今己使用的考勤方案相比，具有用户使用更简单、节约成本、实时、高效等优点。 本文中所做的主要工作如下： 1、介绍了INTERNET考勤的背景。 2、阐述整个INTERNET考勤系统的系统结构及需求；分析了系统实现中的特殊性、难点和重点。 3、实现了数据库设计，实现机构设置、职务设置、人员管理、派工、请假、加班及相应查询统计等模块；实现窗口25个、数据窗口56个。 4、分析并解决实现中的重点技术问题，如INTERNET网点对点的拨号联接技术、VPN架设技术、PowerBulder数据窗口设计、SqlServer远程数据复制等。 5、对软件进行验证与确认。 关键字： VPN PowerBulder数据窗口 SQL Server复制 ABSTRACT Along with the development of the society, the number of the administrative departments, enterprises and corporations becomes larger and larger. The system is getting healthy. Branches and subsidiary companies are distributed in different areas and cities, while the staff becomes constantly large. In order to accurately provide more convenient management to check on work attendance in real time, many new patterns of such info system come forth. This article provides one solution which is bases on WAN. Compared with the actual solution, it can be more simply used and the cost will be decreased, while real time and high efficiency can be also achieved. The followings are the main points of the paper: 1.it will introduce the background of Internet-based attendance check system; 2.it will expound the whole architecture and requirements of the Internet-based attendance check system and has analyzed the particularities, difficulties and the key points in the course of system realization; 3.the design of database has accomplished, and modules include department installment, function installment, staff management, task distribution, leave application, work overtime management and relevant inquiry statistics etc. Including 25 forms,and 56 data forms. 4.the key technical problems have been analyzed and solved, for example, dial-up P2P connection in Internet, VPN framework, windows design with PowerBuilder data,remote replication in SQL server etc. 5.we have carried out software authentication and confirmation. K