- Influence of Huawang Table Control on Issue Development History
About the Author:
Zhang Yang: born in Chengdu, Sichuan July 1964. Director, senior engineer, senior engineer; Chengdu Jianlong Software Co., Ltd. Technology Director; Graduated from the Industrial and Civil Construction Major of Sichuan Province and the Ministry of Economic Management in Sichuan Construction Vocational and Technical College. It has been engaged in engineering electronic mechanical testing, engineering structure, equipment type design, engineering software development, etc. Programming languages used in commercial development: Basic, compilation, QuickBasic, FoxPro, Delphi. Good at electronic technology, art; hobby Taiji push hands, won the national martial arts segment 6 paragraphs.
Last year, we went to the research of China Construction Science Research Institute. Wang Tiecheng's experience in introducing them, there is a deep impression on me: "Enterprises should seek development, first recognize themselves, know Who am I, who I have, who I am now, who I am in the future. WHO AM I? What should I do? What is I want? What is my advantage? what should I do? ...
A commercial control - UF Hua Cell made me truly realize the charm of social division of labor, which enables people to give their own specialty and have more benefits with a smaller price. Let me know what I should do, what should I do. A application-level development team should put energy in the combination of professional technology, rather than doing basic development, so that people who are best at best! We are just those those who are good at pushing buildings with computers. I have I met China's Cell, a control that let me know!
First, end building and computer
Due to the small hobby radio, I remember that the 81-year college entrance examination is volunteer, most of the volunteers are related to electronic or postalization. Probably a more independent, it seems that the parents did not participate in what opinions, and the last volunteer column did not have selected. My neighboring classmates fill in many architectures under his parents, and think of my father and I suggest that I report to architecture. He said that the construction industry is relaxed, fun, life, how is it, there is no need to make yourself too tired (he originally made a plane, working in Chengdu aircraft company, 57 years After being transferred to the right, it was dried into the construction site. In the 78r, the government said that he can return to the original unit to restore his position. He has not returned to his building), and I also took a school. My secondary school is a famous school in Sichuan. The whole school is very bad. The usual exam usually is in the class. I am still in the end, the only architecture volunteer will be taken away. I really don't want to go, but Considering the economic situation of the family and if the refusal must be reported for one year (the rules required to obey the organization's distribution), I started the edge of architecture, and later found that there was a good classmate to be recognized.
84 years of graduation is distributed to the center of the Sichuan Institute of Architecture Science, engaged in stress strain testing. After each test is completed, you must handle a lot of data processing, although the unit already has a desktop computer, but because we often work in the field, The test results processing report is required in time, which is assigned to a PC1500 computer produced by Japan Sharp. This 8-bit of small things, basic memory is only 8K, and there is a printer. What fans is fascinated in addition to the Basic language, you can use the LH-5801 machine code to drive hardware and underlying development, which means that I can use assembly language to develop my own language. In addition to easily deal with work, I often use its interface to drive and control some equipment and signals. It is a toy to me, but this experience has laid the foundation of my computers. In 86, I got a chance of training and left my original position. After returning to the unit, I was engaged in engineering design. There is basically five years without touching computer. Second, set foot on the development of this ship
Later, it was arranged to engage in building structural design, often requiring a computing station, and pays hundreds or even tens of thousands of yuan. Once you go to your classmates, you can use the PC1500 computer to accompany a program module box to complete the vast majority of computing tasks, but the program is addressed, can only calculate the original procedure. I used the basis for playing PC1500 before, I will decrypt it in less than a minute. So I applied for a PC1500A to the leader, remember to spend 2400 yuan, then its memory can be expanded to 28k, saving a lot of boarding. Later, the most important application - the framework structure calculation program, the operation is too slow, the calculation scale is too small, so it starts to rewrite the most time-consuming solving equation group with assembly language, and it will take 45 minutes in the past. The calculation is increased to only 15 seconds, and then the additional memory is expanded through the computer interface (up to 512K, and add more than 60 expansion BASIC instructions, the additional memory can be run, and the variables are stored to the additional memory). It will only calculate the size of 3 across 6 layers to increase the size of 6 across 15 layers. Many friends began to ask me and purchase procedures, but also let me find the business value between them. Later, this module sold in China to fifteen provinces and cities.
To write linear equations in assembly language, I am definitely unwilling to do this. But I didn't feel anything at that time, I didn't leave me a hard and bitter impression, and it contrast it in the efficiency, but I remembered. Now we have some programmers, when the program is slow, it is not willing to spend time or thinking that it is unlikely to improve the performance efficiency of the program. "When I think about Apollo Month, the memory of the human computer is only 8K, we have no Can't do it! Just look at the investment and output, "Different programming often makes efficiency improves much. In practice, just use your heart! Can always make slow things! (You don't need to use assembly).
486 was born, the PC1500 began to quit from my world. PKPM launched large structural calculations and drawing software, developed Chinese own vector graphics systems under the technical conditions at the time, making me very admire. However, the entire software requires more than ten thousand. For the enthusiasts of only a few income of income, only the old way to get my beloved - decryption. Since the key to all genuine software cannot be obtained, the method of cloning the key cannot be used, and only the imitation key is analyzed after the decryption is decrypted. It is very easy to easily, every time it will, and later the other party continues to upgrade the replacement key, it is increasingly difficult, and it is increasingly challenging. Since our unit has purchased a genuine software, the purpose of decryption is no longer the need for the software itself, but is like playing chess, might, and a friend who has not met is doing intelligence games. I remember the last decryption, from the beginning to success, spent more than half a year (since I have begun to write my own construction engineering management software, I didn't put the decryption in my heart, but I didn't finish it, I feel uncomfortable), to my Software 1.0 When you need to do encryption, I started to design my encryption system ... I finally got a plan to be the most perfect. Suddenly I thought that the other party didn't use a similar program, so I sat next to the computer, success ! The family is only alone, the night is deep, and I didn't dare to yell. I excitedly ran a large circle in the court. This is probably a class! I finally realized why "For science and technology, the most complete solution, the different people should be the same." Later, software encryption entered the era of encryption lock, I also officially put into construction engineering software development, The unit is transferred to the calculation center of our hospital, writing my source code from zero, hoping to use the experience of two technology integration of construction and computer to provide a comprehensive and independent intellectual property rights. Software products of the construction site microcomputer assistance management system, no longer play the decryption game, but it is necessary to study the achievements of encryption to protect their own results. Life is often such a strange circle.
The Windows era is coming again. It has become a feature that has been flipped with the wind. DOS interruption is flooded by Windows API. The characteristics of the interpretable language execution efficiency and more easily decrypted are abandoned, Delphi V1.0 is full of bugs People feel not learning language, but in studying language, constantly playing patch, tired! At this time, I first realized that my father suggested that I was in the meaning of architecture, there was no way, I have already got this thief boat. It is good to launch in Delphi V4.0, although many friends still say this is a bug's constant product, but with the bottom of 1.0, we have already felt very good, use it we have developed its own vector graphics system, develop "Engineering Budgetary Valuation System", "Engineering Network Plan Management", "Construction Planning System", "Board and Construction Organization Design", etc., began to gradually construct various modules of "Engineering Construction Field Microcomputer Assist Management System". Because some of the experiences mentioned earlier, the worst plan is "big unexpectedly" when they encounter difficulties. In order to make everyone share some results, we also write some DLL or common units, each module is developed by our own, although the effect is good, but everyone feels tired. Especially the upgrade, there are almost all programmers. What is the negative impact of every development method of yourself is more and more obvious, we start trying to do ways to subcontracting modules, not ideal! It is difficult to find a decent partner locally. I have considered using Excel to embed development, but I think that users need to pay many additional additional fees, soon I will give up. In a team lacking outstanding programmers, I began to confuse and start asking yourself to complete a project of "Engineering Construction Field Microcomputer Assistance Management System". Until one day, I saw a software, a small executive program under an interface, can call a different format report like Excel, which is what we prepared to do. So I let our programmers go to study, he tells me that this software has used a "cell32.ocx" control, we started testing, understanding this control, a Chinese who developed by the Chinese, a distribution fee only a few thousand yuan Control. We started to use it to do business development, starting with him to do various reports. As the work continues to deepen, it is increasingly understanding, and constantly feels its benefits, and it has begun to discover its shortcomings, start to patch, and began to help developers. Through the channel of the Internet, two development teams who have never met, a cooperation in Chengdu in Beijing, and our demand will soon be resolved. However, let me surprise, we found that the charm of this control is not only doing a statement ... Third, China Table opened the door
"Lu's Spring and Autumn, Inspector": Song Zhin's home without a well, and it is raising, often one person. And his home wear well, the doctrine: "I wore a well." Sneaky to pass the people: "Ding's wore a well." The national people said, heard the Song Jun. Song Jun is asking for Dingshi, Ding's pair: "Make a person, it is not a well."
This is a classical translation test question I think in junior high school. There is no extra-class reading at the time, and now you only need to search for keywords on the Internet, you can know that this is a famous fable. I don't remember it specifically to translate it. Anyway, I am a mess. But this story has never forgotten.
As a professional application software development, professional technicians, programmers, and internal testers are needed. In the past development, a software project is carried out, the pressing of programmers is the largest, and coordination work will cost some unnecessary time, which takes up a lot of programmers, which greatly limits our R & D capabilities. However, when we use the Chinese Table, we successfully liberate the programmer from the transactional work. The programmer only needs to make it in accordance with the plan. Professional and technical personnel and artists use our "Reporting Star" software improved according to the Chinese "Super Report" software and can share their part of their work by typing and internal testers. For our unique unit of professional and technical talent resources, outstanding programmers, there is no doubt that it is expanding the programmer team. Our programmers can develop most of the development efforts to develop with professional technical related parts, not the various corners of the software. "Ding's dilute is one person." And I have more people in China! Due to the emergence of the Chinese table, we also have more experience to OOP. It is not only for Program. Many of the work and project implementation can be inherited and overloaded. We try to define the organization of organizations into different classes to divide and arrange, and the efficiency is further improved.
Due to the emergence of the Chinese table, we have begun to pay attention to business components and controls. Later, we introduced commercial software development kits such as graphics controls and interface controls. In the past, we spent nearly a year to develop its own vector graphics system, and we used a new graphic control for only three months, most of the functions have exceeded the original effect. It is the Chinese watch to help open the fan to the correct road gate, calling back to my long-lost feelings!
Fourth, my Cell application
It is like a restaurant chef, the same ingredient, and different chefs will make different tastes. Cell is like a ingredient launched by Hua Tu, how to do it is to play. It's better to play with the building blocks when I have just given you, and there is a drawing, you can build a thing with the drawings, you can get a happiness, but the bigger charm of building blocks is still available. The world other than the drawings. There are a variety of evaluations on CELL on the Internet, some say good, some are not good. I don't know other fields, in the field of construction engineering, Cell has a very good application effect in engineering management and engineering testing and scientific reports. Below is our application example:
1. Check and reference data
Some input boxes in technology chart software requires some fixed selection data, which may be parameters in some tables, or may be a piece of text, and may even be an operation result of other data in the table. In the usual software development practice, one window may be used, but the functions and functions provided by Cell can be done by simple settings. But do some special effects, still need to move some brains, if you use Cell, try to make the following effects, you will find that it is a kind of creation, you can do different Cells. Interpretation.
Figure 4-1 is a simple second-level reference window that can be done with a unit attribute. Figure 4-2 is a drop-down window with a merged cell format, which is characterized by a reference window that maintains the original printing style, I don't know if you have this skill. Figure 4-3 The number inside the drop-down window is calculated by the data of other cells above, and the above cell data changes, and the number and text judgment conclusions in the drop-down window will also change. This naturally makes people think that we can use Cell to do program input or work interface. The biggest advantage is that completing these work does not need to occupy programmers.
2. Processing of formulas and graphics
Using computer processing technology reports, in addition to the need to join some special professional computing functions, another feature is to display, print formulas and graphics, the original Cell is difficult to handle this problem, it can only handle the raster graphics, so It is difficult to take into account the contradictions of printing and display, showing no problem, it is difficult to print, printing can be displayed and difficult to accept, can not achieve the effect of seeing. China Table and we solve this problem, this is the benefits of using the Chinese to develop products. I have purchased two intermediate products abroad, one of which prices have similar to those mentioned above, we have clearly removed the problem, and told the solution to each other if it is handled by the other party. And, it is very advantageous to improve the inner quality of this product, the other party answers "Must Be a Raster Image", if this feature is required to estimate the additional fee "Would Be a betWeen $ 2,000 and $ 5,000"! Later, we used this problem to make a patch.
Cell has a convenient place to join a custom function, when you need the function of Cell, you don't have enough perfect, you can do it, it is very easy! Figure 4-4 is a report for engineering statistics. Programmakers only complement the project's special employment variance calculation function, and other work is completed by the general technicians. The user said that this table helped them, and the past needs a 2 weeks. Now half a day, the formula typography style is exactly the same as the form of the print, and can also fill in the Chinese conclusion! Figure 4-5 is an example of embedded an AutoCAD graphic. Figure 4-6 is an example of an example embedded in Word Typography Format Text and a special formula. Later, we also develop a secondary auxiliary tool that will be embedded in graphics and Word typography format text.
3. Reports for automatic collection, data, graphics, documentation
Cell5.0 has a relatively powerful chart feature, but special graphics analysis for technology reports still cannot meet the requirements. The programmer can easily add a chart function using a custom function; plus an auto-acquisition interface, implement the original data automatically; can also utilize the data perspective of the Cell itself, implement data repetition reference, automatic completion of computing and report conclusions . The test data analysis report (text and chart) can be completed while the test is completed.
Single pile vertical static load test results and Q-S and S-LGQ curve custom functions, automatic calculation of statistical drawing curves, modify arbitrary data, graphics, and conclusions
Single pile vertical static load test results and Q-S and S-LGQ curves
4. Controls across the network
Huawang Cell has a plugin for the Internet platform, but we don't use it. In our current application, few need to open a separate Cell file online. Our application is usually used to interface, do input, output, print interface, it is the advantage that you can get the results you have obtained, if you still don't have beautiful enough, you can add a background image. The most common application is to enter or output different content on the same style sheet (interface), that is, the actual requirements are related to a database, not a certain unit provided in the Cell formation or plugin. A database associated with a database. It takes a little effort to make a helper control to meet this demand. After all, Cell has given us too much thing!
Applicants working on the most familiar statements, no special training
In addition, the application Cell can also make a lot of dynamic control effects, such as dynamic expansion table content (ie, at the same table, the user can take the button set by the Cell, change the form and content of the partial cell, and become another one Sype, rather than choosing another table). Limited only a read-only area cannot be taken out (the interface is very useful, otherwise the user will point some blank cells in the unpryngeable place), use the return to the car to enter the text in the unit (users are very common) Enter to implement the issuance of this. Many requirements can be done using the function provided by Cell. It is not listed here. Five, conclude
Before the Spring Festival, I used the short-lived gap to visit the friends of the use of friends, and they talked about Cell to our help and influence. They have suggested that I wrote this feeling to everyone. After returning, I will always have other things. Wrapped without time and calm down. It has been a year, and this year we still feel the charm of this impact. With the holidays of the Spring Festival, I specially arranged time to write this story. Is there a wish!
Maybe there may be a friend will ask: Why don't you use a control! I have also hoped that the time can cross. History is this, when we need it, a good control is still in the mother, maybe the version of 1.0, 2.0 does not have enough attractive or fate. We have experienced it, paying. That's why I am from 81, it is a history, it is a process. We didn't have a classmate who just came out today. They don't need to know what is interrupted. What is a track, or even understand the API function, you can develop a lot of software, and you don't need to know what LH5801 is. I hope someone can get something from my story, just like I use Cell.
Maybe some people will say, have you not seen a better control? For example, who can directly format text editing and insert vector graphics, etc. I believe there will be a lot of good controls, but "you can only go through a river at the same time", just like someone asking: Is it VC or Delphi, is VB good C # good? It's all good things, each has its own advantages and deficiencies, you can make a good thing, suitable for you is the best! I am doing business development, I use Huawang Cell, practice prove, the user is reflected! I recommend it to you! I realized the benefits of the control, waiting for me to have something, I will make it control, I feel valuable, I will take it out to let everyone share! Last year, we had an intern that I always like to ask me: "Can you use the function to solve this problem," I said, "If there is, you can get a few projects for a month." I want to have such a day, when you need a function, you can go to the Down to go to a control or call other stuff. Now we can DIY's own computer, natural us can also DIY's own software, and even don't even need to finely PROGRAM. The "Star" we currently developed is working in this direction, hoping to make the general scientific and technological personnel can DIY's software, and even make business software.
I have to go to work immediately, I will continue to build my building blocks. Maybe I will be very busy, but my mood is very pleasant, it is very easy. Because I know, we can easily complete the "Engineering Construction Live Microcomputer Assist Management System", even if I move to other places, my brother who has just went out of the school will help me get it, but their goals can be more than me. Great. Because we have found a shortcut to the correct goal, there is an old saying during the Cultural Revolution "as long as the route is right, step by step"! Thank God! Thank God! Thank you for your friends who have gone! I wish Hua Huatai is getting better and better! I wish our country's local software prosperous!
2004. Spring Festival grass in Chengdu
