ERP framework sequence design and development diary (II)

1. Various examples of Crystal Reports should be made. For example, capacity report.

2. If there is a bug in ListBox, the newly added item will not be displayed. Entity control also has bugs

3. directly execute a report service function, instead of searching for it through the report manager.

Add a "trial version" to the report generated in licensetype = trial.

4 Data archine is saved as an Excel file, and the Gantt chart control is also

5. Use infragistics. Excel to read and write all Excel-related content. The width of the exported Columns cannot be set.

An error occurred while adding the grid content.

6. Check whether the report service exists and the environment. K3 dector.

XML file rules and verification.

7. Report writing specifications.

SQL _lating1_general_cp1_ci_as

8. add context menu to the map on the hot zone icon.

Servicehost host = new servicehost (typeof (ireportmanager ));

Host. open ();

9 build library generation ObfuscationProgramSet. After the BAT file is generated, the file is automatically deleted after running.

10. Password protection and hash value added.

Accept qualification count reject nonconforming count

11 Efficiency Improvement

Do not use string AX = "" to determine whether ax is null. The efficiency of ax. Length = 0 is higher than that of AX = string. emptyu, which is generally used as. isnullorempty

Replace unchanged variables with constants.

Use LINQ to replace a large number of foreach queries

Mytype t = (mytype) T and T as mytype Efficiency Comparison

Array instead of list <t>

Haset <t>, Dictionary <K, V> instead of hashtable

12 Parameter Design Basics parameterbase, purchaseparameter, financeparameter

13. The button of infragistics adds images and optionset horizontal layout. the crystal report closeview does not work.

Rdlc report with Parameters

14. Keep the connection with the server. Disable User input after disconnection.

15. Create a Kingdee query program to read its data.

16 The value passed by drilldown is null. The loadblankrecord should be returned without an error. Layer-3 grid is not supported.

17 you can adjust the image size of the main material file to a certain size.

18 to Unicode program. Convert SQL _latin1_cp1_ci_as Program

19 text comparison tools, diffcontrol, ndiffcontrol, nlinediff

20 types of ERPAlgorithm: Rough capacity calculation, main production plan calculation, batch rule calculation, bottom layer code calculation, capability demand calculation, fixed asset depreciation, standard cost calculation, wage calculator, and material demand Calculation

For support of more than 21 currencies, you must add currencies and exchange rates to each journal.

22. Report Format: balance sheet and income statement. And their layout design

23. The Mao demand is to run the material list. Net demand = gross demand/(1-Loss Rate)

Planned order volume = Batch rule (net demand)-existing inventory + safety stock-estimated warehouse receiving volume + allocated volume

40*(1 + 10/100) and 40/(1-10/100) are two ways to calculate the loss.

Nr = gL + Al-(SC + OH)

24 production line, workshop, process PAB/folder, main line, packing Line

25. Remove the dependency on the Microsoft enterprise database. In An ORM project, there should be no too many SQL statements unless you have.

26 message box, the message center is made into the outlook style.

27 Data Tables + Data + solution + report Tianbao, great helper, blue soft, Leather Industry

28 scheduletasktrigger scheduled execution

29 available stock = existing stock-estimated warehouse receiving volume-allocated volume-reserved volume-Safety Stock

Cost computing workshop tasks, completed warehouse receiving computing cost, activity-based costing, allocation of management fees and manufacturing costs