Common EAS Development

Menu operations

Enable System Menu shortcut: Shift + CTRL + ALT + k
Export System Menu: geninsert select * From t_bas_sysmenuitem where 1 = 1
Custom menu export: geninsert select * From t_pm_mainmenuitem where 1 = 1

System parameter operations
On the "parameter settings" Page, press "F12" to bring up the new parameter interface. The newly added records can be exported using "geninsert ".

Script export tool
The geninsert mentioned above can be used to export SQL scripts. It also provides a tool for exporting scripts, such:
Export the script of the encoding rule to go To the encoding rule setting interface. Press "F11" to call up the tool interface.

 

Eclipse EAS client startup parameters
-Deas_home = W: \ EAS \ Client
-Deas_server = TCP: // localhost: 11034
-Dlog4j. Configuration = file: W: \ EAS \ Client \ deploy \ Client \ log4j. Properties
-Xms512m
-Xmx1024m
Note: The last two lines can be configured based on your own machine. For parameter meanings, see the JDK documentation.
EAS client main class: COM. Kingdee. EAS. Base. uiframe. Client. loginframe

 

Quick query of Oracle Database Error Information
Http://ora-03113.ora-code.com/
Replace the red part with the error code of Oracle. Enter the URL to obtain the error details and solutions.

 

Obtain the query execution Interface
Iqueryexecutor
Com. Kingdee. EAS. Framework. Client. listui. getqueryexecutor (imetadatapk querypk, entityviewinfo viewinfo)
You can set breakpoints to track the conditions of listui queries.

Intercepting SQL statements (available in R & D environments)
Kdpreparedstatement can be used to set breakpoints in such constructor methods. It can intercept SQL statements. If you want to intercept the SQL statements of the system,
You can set the condition breakpoint, ksq. indexof ("t_csl _")! =-1

View SQL statements with parameter values:
String AAA = pssql. getsqlwithparams (tempbuf, Param. toarray (), 1, false );
The result returned by this statement replaces the question mark in the SQL statement with a specific value to facilitate SQL tracking.

Query entities based on bostype
Select * From t_pf_bosobject where fbostype = '559b02fc'

Background transaction definition table:
The background transaction created by t_wfr_procdef is saved in this table.

Common tools:
Date Processing: COM. Kingdee. util. datetimeutils
String processing: COM. Kingdee. util. stringutils
The time type is processed in the following format: {ts '2017-10-10 10:10:10 '} s

Reprinted Note: http://www.cnblogs.com/masb/archive/2012/02/09/2320241.html