This design specification mainly describes the basic functions and design methods of VISAUL BASIC6.0, system database design, object-oriented design ideas, form design, application development methods, etc.
The system has the functions of data input, data storage, file query and report input. The man-machine dialogue interface of the system is friendly.
Keywords: database; Wage; Salary management; Salary management system; object-oriented programming
Salary management information system is a database management system developed by object-oriented technology. Object-oriented programming is the most popular programming technology and has great influence. Through system overall design, function analysis and program design, a relatively perfect wage management information system is established.
This paper expounds the basic functions of Visual Basic6.0, the choice of design language, the design of system database, the object-oriented design strategy, the design method of report setting and screen setting, and the development of application programs.
The management information system has the functions of data input, data saving, record query, report printing and so on, and the dialog box system is very perfect. Using screen builder to generate a good functional interface is a major feature of this design.
Keywords: database; Wage; Salary management; Salary management information system; Object Oriented Programming (OOP)
It is said that the world we live in is both a material world and an information world. This has two characteristics: first, the existence of matter is accompanied by the existence of information, which is the basis of information and the abstract reflection of matter. For example, the information of students' grades, the goods in the store and the information of various characteristics of these goods (name, specification, color, quantity, unit price, etc.). ) reflect the students' learning situation. The second is the change of materials (the change of expression, the increase or decrease of quantity, the change of region, etc.). ) will cause corresponding changes in information (modification or elimination of old information, generation and dissemination of new information, etc.). ). Information depends on data, and data combination constitutes and vividly expresses information.
With the popularization of computers, computers are no longer only used to deal with numerical calculation problems, but are widely used in various fields of non-numerical applications such as transaction data processing. Such as enterprise management, intelligent inspection, medical record analysis, planning statistics, image processing, text translation, Chinese character processing, etc.
Processing data by computer means handing over the original data and processing algorithm to the computer, and the computer processes the data according to the given algorithm, and finally produces the result data. For a specific subject, the processing algorithm is relatively stable for a period of time. But with the passage of time, the original data are different, and most of them are relatively large. From data input, data storage and processing in computer to data output, there is a problem of data organization, especially in the process of data storage, database method provides a perfect and advanced data management method. Its idea is to manage all data uniformly, centrally and independently, so that the storage of data does not depend on the application that uses the data, thus greatly improving the productivity of the application.
With the continuous development of computer technology, computer, as the product of knowledge economy era, has been widely used in various industries and fields of society. With the deepening of the reform of state-owned enterprises in China and the growing prosperity of the socialist market economy, the competition among enterprises is becoming increasingly fierce, forcing enterprises to adopt advanced computer hardware equipment and high-quality auxiliary software to manage their operations in order to improve labor productivity and personnel efficiency.
The first chapter is the introduction 1. 1.
An enterprise has more than 400 cadres and workers, mainly leading cadres, technicians, salesmen and operators. The company consists of organs, sales companies, finished product workshops and reconciliation workshops. In order to manage employees' salary conveniently, a personnel salary management system is also set up, which can calculate each employee's salary according to each employee's working years, medical insurance, housing allowance and post salary, and it is also convenient to query employees' salary.
With the company's development year by year, the company's personnel and salary affairs are becoming more and more complicated, but generally these affairs can include the following aspects: personnel basic information management, employee business file management, employee job evaluation management, employee attendance management, employee salary management and so on. Each part of the above-mentioned project has management details in this respect. Take employee basic information management as an example, including employee number, name, gender, department, nationality, date of birth, political outlook, home address, contact telephone number, graduation school, highest education and other detailed information. If these data are managed manually, it will not only waste manpower, material resources and financial resources, but also be difficult to make statistics and analysis because of the large amount of information to be processed. Relying on traditional manual management has been unable to keep up with the company's development needs. In order to streamline personnel, improve work efficiency and save the company's operating costs, it is particularly necessary to change the previous mode of relying solely on manual management.
With the development of economic level, the era of knowledge economy puts forward higher requirements for wage information management of enterprises and institutions. In addition to the salary that can be managed by computer software excel before, the company hopes to manage all kinds of personnel information, attendance information, job evaluation information and salary information in a unified way. Efficient and accurate personnel compensation management can not only promote employees to continuously improve their own quality and work enthusiasm. Thereby improve that work quality and efficiency of employees. The correctness and security of data and the efficiency and reliability of operation in personnel and salary management all affect the construction and management of staff.
1.2 Research significance of this topic
At present, there are many popular wage payment software on the market. However, enterprises and institutions do not need a large database system for wage payment. It only needs a system with convenient operation and practical functions, which can meet the data management and demand of the financial department, other relevant departments and organs of the unit. Our goal is to develop a powerful payroll software that is easy for users (finance department, other relevant departments and banks) to operate.
Feasibility analysis of 1.3
The purpose of feasibility study is to determine whether the problem can be solved in the shortest time with the least cost. Of course, we should not rely on subjective speculation, but on objective analysis. It is necessary to analyze the advantages and disadvantages of several main possible schemes, so as to judge whether the original system objectives and scale are realistic and whether the benefits brought by the system after completion are large enough to be worth investing in and developing this system. Therefore, the feasibility study is essentially a process of system analysis and design that is greatly reduced and simplified in turn, that is, a process of system analysis and design at a higher level in an abstract way. The feasibility study is mainly carried out from the following five aspects.
1.3 technical feasibility 1 whether the system can be realized by using the existing technology. Because the object of the management system is single, it only manages the company's personnel information, and the calculation process basically does not involve the increase, decrease, modification, deletion and statistical operation of personnel information. Therefore, the management system is more suitable for database design. Today, with the rapid development of computer software and hardware, computer software and hardware have far met the requirements of this management system. In the aspect of database programming tools, the appearance of various visual programming methods has changed the previous concepts and methods of programming. Users can create applications quickly and simply with the mouse, which greatly improves the programming efficiency. In the database system I know, because I have studied VisualBasic 6.0 and am familiar with ACCESS database, I decided to use Visual Basic 6.0 and ACCESS to complete the design of personnel and salary management system. Both VisualBasic 6.0 and ACCESS*** have completed the personnel and salary management system, providing object-oriented programming technology, which can quickly create powerful visual applications with little or no programming code, simplify database management, and make the hard work of developing applications as simple and convenient as a heap of trees. In addition, the application developed with ACCESS database can run independently on windows platform, and the database (table) generated by ACCESS has a wide range of applications.
1.3.2 economic feasibility can the economic benefits of this system exceed its development cost? Personal salary management system is a small database application developed on the basis of VisualBasic 6.0 and ACCESS, which can be designed without too much manpower and material resources. But once the system is put into use, it will greatly reduce the workload of personnel and salary managers and improve work efficiency, and its economic benefits are obvious.
1.3.3 Operational feasibility
Whether the running mode of the system can work in this user organization. In the demand analysis, the user organization is investigated, and the man-machine interface suitable for this user organization is designed according to their situation, so that the operation mode is simple and clear.
1.3.4 the feasibility of personnel personal salary management system is a small database application program designed with VisualBasic 6.0 and ACCESS, which can be successfully designed without a lot of personnel. Through the feasibility analysis of personnel salary management system, the proposed function is suitable for personnel salary management and can be realized completely.