Friday, May 25, 2012

Database Programming



It just so happened that after graduation I got a job at the hospital. Hospital - it is such a large hospital. And each quarter in the hospital records do. each branch of. In general, the hospital. Annual report for the entire hospital - it is 700 pages of tables and analyzes. And all this must be someone to consider. Some might say - why all these reports, let them not. E- no in any office may be named a doctor, but in a large hospital there. Supplies of medicine in the central thing, again, the number of beds, number of doctors. Why in the hospital, 700 beds, and not a thousand? . Statistics gives rise to conclusions. So it is useful, though disliked by those who depend on it.

When I started working, there was a database in FoxPro. Interesting that language - especially for database. But something we have not grown together with. In addition, the previous programmer made ​​all the sources. That she tried to retain copyright on their work within the organization. That is unethical behavior, and FIG her. Another year I promuchalsya this database, and then slowly began to write his. The breakthrough came when connected to the work of the second programmer, and we did our little miracle.

At present, our program allows you to keep track of all incoming patients, print, sea current market, quickly and make timely reports. Moreover, all the forces are not particularly skilled - in the receiver - recorders aunties know and can only include a computer and use the program. Of course, a painful stage of implementation, but now no one thinks of his work without the program.

The second program was written for road operating company. The program calculates an estimate of. Its main feature even today is a free price, which allows the company to work for their prices without looking at the road department. And while, as far as I know, even after a forcible entry operation RIC (this program is estimated ), the company has done everything in my estimate of the commercial development.

The most powerful complex was built for the company for the production of shutters, windows and awnings. It was written four years for about a week update. During this time he rose from the cash consideration to all of the company: account balances, logistics, salary calculation, calculation of efficiency. Then I frankly tired of this work and persistent problems with payment and we parted amicably. Later on the skeleton of my program complex was re-established already at 1C and was his final merger with the accounting.

A couple of programs I wrote for myself. Just to take into account the orders, print bills, acts, etc. Dr.. It's damn convenient.

The latest development - a program for the maritime agency personnel. Taking full account of the sea, experience, printing, mass counts, simplifying the search and send sailors. Actually, the whole activity is a small company is now in the program.

It never was for me the business - rather a hobby. Just like the slender ranks of the reduced numbers. And it gives customers?.

Let's take the example of. One of the orders - a program for the Institute of Architecture. The problem was as follows: monthly rent of 22 reports on the development of. According to the report handed charged Salary. That's just to give up the program records in paper form and were reduced in the two reports within 20-25 days, mostly accountants. After implementing the program delivery of the report is complete in 3-5 days, 3-5 days and all - this time to fill the allotted departments reporting forms on their computers. The very same report is printed with one click. Giant savings in time and effort.

The main problem in this area is only the introduction of. If we exclude krivorukost vnedritelya course. Sometimes, it is not vnedritel as a pest. But for a long time I have come to the conclusion that can be implemented only if the leadership wants to. Otherwise, staff will simply sabotage the program. The same crewing program implemented in one agency, but not used. Just officials said it was uncomfortable and suffer from Excel. And when I put a clone of hospital programs in the sanatorium, the curve was to the skies. Personnel on average for 50 years and nobody wanted to learn. But it was a tough order to guide: nachmed just selected paper journal every day, and ordered to print an alphabet book - do not write, and print. And now if the program does not work, then screams more.

That such an interesting job. If you are interested, as I usually take for the application, then a little bit, from 600 to 2 thousand. in. e. for the turnkey. Just to recapture the time spent, and only. Yes, and sometimes the interest is extinguished and there is just a financial incentives to the next flurry of interest.

No comments:

Post a Comment