7月18日1、远程桌面连接命令：mstsc岭南账户（远程服务器）：administrator密码;qwe123--2、新开发报表各页面排列方式左边中间右边上固、不、固、比固、不、比、比固、不、比、固中（分录）固、比、固、固下不、固、固、比3、登录客户端后有些功能点开后直接报错（环境错误）解决方法：停掉服务器->生成子系统树->同步权限项->同步日志项4、学习HashMap三种遍历方式HashMap的三种遍历方式*HashMap是不可重复集*方法一:*遍历HashMap中所有的key，通过keySet方法将所有的key取到然后在通过key遍历所有的value*方法二：*通过Map.Entry进行遍历，entrySet()方法，将每一个map对象都可以取到，然后分别输出他们的值*方法三：*通过values方法取到所有的value但不能取到key5、学习StringBuffer与StringBiluder、String的区别1、首先说运行速度，或者说是执行速度，在这方面运行速度快慢为：StringBuilder>StringBuffer>String*2、在线程安全上，StringBuilder是线程不安全的，而StringBuffer是线程安全的6、学习数据库表与表的左连接、右连接、内连接总结：ORACLE数据库中的表连接关系1.内连接内连接是只显示满足条件的！2.外连接2.1左外连接显示左边全部的和右边与左边相同的！2.2右外连接显示右边全部的和左边与右边相同的！1.内连接Select*fromAJOINBONA.Aid=B.Bnameid；分析：Aid（1,2,3,4,5,6,7,8,9）；Bnameid（2,3,6,7,8,11）；结果：A.Aid=B.Bnameid（2,3,6,7,8,）；见c表。2.外连接2.1左外连接select*fromALeftJOINBONA.Aid=B.Bnameid；分析：Aid（1,2,3,4,5,6,7,8,9）；Bnameid（2,3,6,7,8,11）；结果：Aid（1,2,3,4,5,6,7,8,9）；没有的数据是空。见D表。2.2右外连接select*fromARightJOINBONA.Aid=B.Bnameid；分析：Aid（1,2,3,4,5,6,7,8,9）；Bnameid（2,3,6,7,8,11）；结果：Bnameid（2,3,6,7,8,11）；没有的数据是空。Administrator7.冻结所开发报表的列tblMain.getViewManager().setFreezeView(0,3);8.备份表注：备份前检查，确保一个单据号对应一个idselectFNumber,count(FId)fromCT_PAR_PCSettlegroupbyFNumberhavingcount(FId)>1select*intoCT_PAR_PCSettle_20180814fromCT_PAR_PCSettle9.给选中列设置颜色row.getStyleAttributes().setBackground(Color.yellow);tblSettle.getColumn("number").getStyleAttributes().setFontColor(Color.blue);10.增加报表底行LnTableUtils.apendFootRow(tblSettleData,getNodeSumCols());protectedString[]getSumCols(){returnnewString[]{"initSettleAmt","thisPeriodSettleAmt","thisYearSettleAmt","totalSettleAmt","beginTermNodeApAmt","thisTermNodeApAmt","thisYearAddNodeApAmt","totalNodeApAmt","beginTermTotalPaidAmt","thisTermTotalPaidAmt","thisYearTotalPaidAmt","totalPaidAmt","nodeUnpaidAmt","unReachPayNodeAmt"};}10.执行sql返回结果集（1）岭南代码rs=LnSqlFacadeFactory.getRemoteInstance().executeSQL(sql.toString());（2）原生BOS1、ISQLExecutorexecutor=SQLExecutorFactory.getRemoteInstance(sql);IRowSetrs=executor.executeSQL();//获取结果集2、IRowSetrs=DbUtil.executeQuery(ctx,sql.toString(),params);11.实现报表合并显示@Overrideprotectedvoidquery(){tblMain.removeRows();tblMain.checkParsed();try{searchAndFillData();LnTableUtils.mergeRow(tblMain,getMergeCols());//设置表格锁定行tblMain.getViewManager().setFreezeView(0,3);}catch(EASBizExceptione){handleException(e);e.printStackTrace();}catch(BOSExceptione){handleException(e);e.printStackTrace();}}protectedString[]getMergeCols(){returnnewString[]{"cname","bookedDate","period","creatorName","voucherType","number"};}12.调节表格内容字体显示//row.getStyleAttributes().setVerticalAlign(vAlign)//row.getStyleAttributes().setAlignment(ssa)13.获取当前组织admin=AdminOrgUnitFactory.getRemoteInstance().getAdminOrgUnitCollection("selectarea.*whereid='"+SysContext.getSysContext().getCurrentFIUnit().getId().toString()+"'").get(0);14：快捷键15：获取当前组织的idBOSUuidcompanyId=SysContext.getSysContext().getCurrentFIUnit().getId();16：根据点击的某个单元格获取当前的行17：判断表格存不存在该列kdtEntries.getColumn("pcContract")!=null18：修改凭证创建时间updateT_GL_VouchersetFCREATETIME={ts'2018-08-2900:00:00'}wherefid='YYcxh8d7QsGOgg879SvVUSZS4B4='19：套打连接函数concat(concat(#0,':'),#1)20：利用关联关系进行删除凭证selectbill.FNumber,bill.FCREATORID,bill.FAUDITORID,V.FNumbervNumberfromt_bot_relationtinnerjoinT_GL_Vouchervont.FDESTOBJECTID=v.FIdinnerjoinCT_TM_AvtTransOutbillonbill.FId=t.FSRCOBJECTIDwhere(bill.FFivouchered=0orbill.FFivoucheredisnull21：新建快速查询代码QuickFilteringSupportItemsqfsi=newQuickFilteringSupportItems(true,true);protectedQuickFilteringSupportItemsgetQuickFilteringSupport(){returnthis.qfsi;}22：部署说明1,将eas_sp.jar包分别放在:服务器安装路径\eas\server\lib\sp下和服D:\Kingdee\eas\server\deploy\fileserver.ear\easWebClient务器安装路径\eas\server\deploy\fileserverear\easWebClient\lib\sp下2,将sp-bimmetas.jar包分别放在:服务器安装路径\eas\server\metas\sp下和服务器安装路径\eas\serverldeploy\fileserver.ear\easWebClient\metas\sp,卸载就是把相应路径下的这俩个包撤掉就可以了4，客户端或者服务器sql平台执行脚本5，请将eas.jar在动态扩展平台导入，导入后启动6，如果以上说的三个包只有一个或者两个，只部署有的就可以23：按控制单元（CU）隔离protectedbooleanisIgnoreCUFilter(){try{if(SysContext.getSysContext().getCurrentCtrlUnit().getId().toString().equals(LzsUtil.getTopCU().getId().toString())){returntrue;}}catch(EASBizExceptione){e.printStackTrace();}catch(BOSExceptione){e.printStackTrace();}returnfalse;}24：合并过滤方式protectedFilterInfogetDefaultFilterForQuery(){FilterInfofiler=super.getDefaultFilterForQuery();try{FilterInfofilterCust=getCustFilter();if(FilterUtility.hasFilterItem(filterCust)){filer.mergeFilter(filterCust,"AND");}}catch(BOSExceptione){e.printStackTrace();}catch(EASBizExceptione){e.printStackTrace();}returnfiler;}25：按财务组织过滤protectedFilterInfogetCustFilter()throwsEASBizException,BOSException{/*if(custFilter==null){custFilter=LzsUtil.getAreaDataFilter();}*/custFilter=newFilterInfo();if(!SysContext.getSysContext().getCurrentCtrlUnit().getId().toString().equals(LzsUtil.getTopCU().getId().toString())){if(SysContext.getSysContext().getCurrentFIUnit()!=null){custFilter.getFilterItems().add(newFilterItemInfo("company.id",SysContext.getSysContext().getCurrentFIUnit().getId().toString()));}}returncustFilter;}26：修改编码配置UPDATET_BAS_MaxSerialSETFSERIALNUMBER='20'WHEREFID='m2Of1JfgS16OriY6RV4KHsWDDZs=';SELECT*FROMT_BAS_whereFSORTITEMVALUE='201809';27：去除反编译后的行号注释的正则表达式.*/\\*(.*)\\*/28：回收编码ICodingRuleManageriCodingRuleManager=CodingRuleManagerFactory.getLocalInstance(ctx);StringorgId=ContextUtil.getCurrentOrgUnit(ctx).getId().toString();if(info.get("company")!=null){CompanyOrgUnitInfocom=(CompanyOrgUnitInfo)info.get("company");orgId=com.getId().toString();}if((iCodingRuleManager.isExist(info,orgId))&&(iCodingRuleManager.isUseIntermitNumber(info,orgId))){iCodingRuleManager.recycleNumber(info,orgId,info.getNumber());}29：刷新当前页publicvoidrefreshCurPage(Stringid)throwsEASBizException,BOSException,Exception{if(this.editData.getId()!=null||id!=null){IObjectPKiObjectPk=newObjectUuidPK(id!=null?id:editData.getId().toString());IObjectValueiObjectValue=getValue(iObjectPk);setDataObject(iObjectValue);loadFields();setSave(true);}if(!editData.getBillStatus().equals(billStatusEnum.audit)){actionAudit.setEnabled(true);}else{actionAudit.setEnabled(false);}}30：GUI数据库执行函数（1）返回参数IRowSetrs=LnSqlFacadeFactory.getRemoteInstance().executeSQL(sql.toString());（2）不返回参数LnSqlFacadeFactory.getRemoteInstance().execute(sql);31：报表增加列（1）代码：tblMain.addColumn().setKey("reMarks");tblMain.addColumn().setKey("vouchNumber");headRow.getCell("reMarks").setValue("备注");headRow.getCell("vouchNumber").setValue("凭证号");（2）遍历头行privatevoidprintHeaer(){IRowheadRow=tblMain.getHeadRow(0);for(inti=0;i0){Iteratoriterat=idList.iterator();listId=newString[idList.size()];intindex=0;while(iterat.hasNext()){listId[index]=(String)iterat.next();index++;}}returnlistId;}37：根据用户维护组织权限进行ListUI数据过滤protectedFilterInfogetDefaultFilterForQuery(){FilterInfofiler=super.getDefaultFilterForQuery();try{FilterInfofilterCust=getCustFilter();if(FilterUtility.hasFilterItem(filterCust)){filer.mergeFilter(filterCust,"AND");}}catch(BOSExceptione){e.printStackTrace();}catch(EASBizExceptione){e.printStackTrace();}returnfiler;}protectedFilterInfogetCustFilter()throwsEASBizException,BOSException{if(custFilter==null){custFilter=newFilterInfo();FilterItemInfoitem=null;CompanyOrgUnitInfocompanyFI=SysContext.getSysContext().getCurrentFIUnit();if(companyFI==null){MsgBox.showInfo("当前组织不是财务组织,无法进行相关操作!");SysUtil.abort();}if(!companyFI.isIsBizUnit()){returncustFilter;}Stringid=companyFI.getId().toString();item=newFilterItemInfo("company.id",id,CompareType.EQUALS);custFilter.getFilterItems().add(item);}returncustFilter;38：获取用户所维护的业务组织selectu.FNAME_L2,b.FNAME_L2,b.fidfromt_pm_useruleftjoinT_PM_OrgRangeoono.fuserid=u.fidleftjoint_org_baseunitbonb.fid=o.forgidwhereu.ftype='20'ando.ftype='10'andu.FNUMBER='user02'andb.fidisnotnullorderbyu.fid,b.fid;39：打印表格列与行privatevoidprintHeaer(){IRowheadRow=tblMain.getHeadRow(0);for(inti=0;i
