In the first week, I took the 28 bill of accounts in the form of Excel document in the customer, a total of 28 Excel files, designed a database according to their own understanding, and MSSQL-2K-generated MSSQL-2K with Visio, but also completed the database Simple entry interface, complete with Delphi7.0
The database Visio diagram is as follows:
The program is desirable to use interface and business logic, and use DataSetProvider and ClientDataSet two controls, but some problems have been encountered in actual applications.
1. The line style of the high voltage line is a dictionary, that is, the user must select from another table, suppose there are two tables:
High voltage line table (high voltage line number, high voltage line type number, rod base ...) / / indicates a high voltage line
High voltage line type table (number, high voltage line type) / / indicate all high voltage line types,
If DataSetProvider provides a single high voltage line table, the user-seeing the high voltage line type is a number, there is no practical meaning, so it is not convenient to the user.
If DataSetProvider is provided with a table after the high-voltage line type table, the user-seeing the high voltage line type is the specific type of meaning, not the meaningless high voltage line type number, although the user seems to be practical, but this The update to the program is inconvenient, and you can't call DatasetProvider.ApplyUpdate (ClientDataSet.delat, -1, i);
There are many specific places like this type, so the problem is resolved in the third week!