(Hi, all my friends and teachers. I didn’t paste a root article for a long time
. This one is a practice and also a summary of my recent work. Wish all of you,
my teachers and friends to kindly point out my mistakes. And wish you like it too. )
My recent Work - Progamming
Though many people said they will quit work if they are rich enough someday, yet researchers find that work is one of life’s chief satisfactions for people.
It’s true. I have derived great pleasure out of my work, programming, these months.
I received this task on Sep, last year. That is a Human Resource Management System for my company. It should fit the every needs of Human Resource Department,
include manage the information of staff, record the check on work attendance, manage salary and other allowance every month, statistic social security fee, print relative report forms, and so on. I was told to finish it within two months and put it into use so as to substitute the old system. The old one was written in VFP at 2000, which only can run in DOS operate system and not very convenience
to use nowadays. The main problem in it is there are inconsistent data and reduplicate data in different basic table which will make the wrong result.
Honest speaking, it’s a challenge because it’s the first time for me to write a whole system alone. That means I should face all possible problems by myself
. I should roundly consider the program in my brain. In another word, my ability
surely can be improved a lot through the practice this time. The experience of
programming with my colleagues gave me enough confidence, so, I accepted this task and promised trying my best to do it well.
The programming language I used was PowerBuilder 9.0, support database is SQL
Server 2000. PB9 is a high-level object-oriented language. It can speed the development time of software and reduce the maintenance difficulty too.
I planed to divide this task into five steps.
1. To do some research work. Use the old system. Finding out what request it designate to execute. And, at same time, finding out where should be improved. Collect the necessary information for the next step. (It was planed to take me one
week’s time.)
One week before The National Day, I almost became a member of Human Resource Department. To know their working process and get along with them well till now.
2. To build the basic database structure. Create basic tables and views base on them. Define data type. Adding comments, primary key and foreign key for every
table, every field. (one week’s time)
This step’s work is very important. Database is the place where the data will
be stored in. The structure of database is the key point on whether the program
will be operated quickly and correctly.
3. Programming and import the data. Start to build one project, main window and main menu of this system. Create libraries waiting to hold sub-windows and data-windows. Create window, added control element on it and write the blocks of instructions under every control element so as to reach the request. (one month’s
time to finish the main part.)
After finish doing one window, it can be load on to the main menu and test the
function. From now on, I start to get some joy when one single window passed the test.
Oct. and Nov. were the busiest two months. I usually work with my computer until night and take the last bus to go home. The quiet night can make me work more
efficiently compare with the noisy daytime, for I was interrupt by someone or something and have to think over on one point again. In the same consider, I also prefer to worked on Sunday and Monday in order to follow my schedule.
To import the data is really boring and headache. Most of the data transfer from the old database which lack of identifier field. Sometimes I have to check them one by one to pick out the invalid item.
4. Testing and correcting. Compiler the program into EXE file, install it on the computers of Human Resource Apartment and then test it fully to try to find some problem. Solve these problems immediately. (After main part is ready. No limited time until it’s perfect relatively.)
5 Visage design and adjust. Design the cover and background for my system. Adjust the color and character size for every window. Set the operate distinction.
(one week’s time or more)
The whole program process was getting along very smooth on schedule so far. This system has already been used for two months and now is perfected continuously
. I am glad I can control the whole thing and value every minute I spent on it.
Work that doesn’t engage a person will never seem rewarding, no matter how lucrative it becomes.
At last, I want to say that’s one of the happiest period in my life. It enables me to face the future challenge with more self-confidence.
Sincerely Lin
20050118