langping86

stay hungry,stay foolish.

  博客园 :: 首页 :: 博问 :: 闪存 :: 新随笔 :: 联系 :: 订阅 订阅 :: 管理 ::

菜单操作                                                                                             

启用系统菜单快捷键:shift+ctrl+alt+K                                                                 
系统菜单导出:geninsert select  * from T_BAS_SysMenuItem  where 1=1                                   
客户化菜单导出:geninsert select * from T_PM_MainMenuItem   where 1=1                                                                                        

系统参数操作

使用管理员账号进入参数设置序时簿                                                                             
在“参数设置”界面按 "F12" 调出新增参数界面新增即可,新增后的记录可以用"geninsert"导出                
                                                                                                     
脚本导出工具                                                                                         
在上面提到的geninsert可用于导出SQL脚本,另提供一个导出脚本的工具,例如:                             
导出编码规则的脚本,进入编码规则设置界面,按 "F11"调出工具界面即可使用。

 

Eclipse EAS客户端启动参数                                                                            
-DEAS_HOME=W:\eas\Client                                                                             
-DEAS_SERVER=tcp://localhost:11034                                                                   
-Dlog4j.configuration=file:W:\eas\Client\client\deploy\client\log4j.properties                       
-Xms512m                                                                                             
-Xmx1024m                                                                                            
说明:最后两行可以根据自己机器的情况进行配置,参数含义请参阅JDK文档。                                
EAS客户端Main Class:com.kingdee.eas.base.uiframe.client.LoginFrame 

 

Oracle数据库错误信息快捷查询                                                                         
http://ora-03113.ora-code.com/                                                                       
红色部分直接替换为Oracle的错误代码,输入网址,即可得到错误的详细信息和解决方案。

 

获取Query执行接口的方法                                                                              
IQueryExecutor                                                                                       
com.kingdee.eas.framework.client.ListUI.getQueryExecutor(IMetaDataPK queryPK, EntityViewInfo viewInfo)
可以在此设置断点,跟踪ListUI查询的条件。                                                              
                                                                                                     
截获SQL语句(在研发环境下可以使用)                                                                                          
KDPreparedStatement 可在此类的构造方法中设置断点,可以截获到SQL,如果要截获本系统的SQL,             
则可以设置条件断点,ksq.indexOf(“T_CSL_”) != -1                                                     
                                                                                                     
查看带参数值的SQL :                                                                                 
String aaa=PsSql.getSqlWithParams(tempBuf,param.toArray(),1,false);                                  
此语句返回的结果,将SQL语句中的问号替换成具体的值,便于跟踪SQL。                                      
                                                                                                     
根据BOSType查询实体                                                                                  
select * from T_PF_BOSObject where fbostype = '559B02FC'                                              
                                                                                                     
后台事务定义表:                                                                                     
t_wfr_procdef  创建的后台事务保存在此表中                                                             
                                                                                                     
常用工具类:                                                                                         
日期处理:              com.kingdee.util.DateTimeUtils                                               
字符串处理:            com.kingdee.util.StringUtils                                                 
时间类型处理成如下格式:{ts'2010-10-10 10:10:10'}  s

posted on 2012-02-09 00:01  masb  阅读(3015)  评论(0编辑  收藏  举报