EAS_常用代码

1、金额大写函数:

GlUtils.getChineseFormat(amount, true)

 2、获取 datacenters.xml中的密码:

String passwd = com.kingdee.bos.sql.KSqlUtil.decodePassword("ksqle:J8CQQm9M5Q4UaPELUb1V8EXq+ObMhjzN");

3、Client执行SQL：

SQLExecutorFactory.getRemoteInstance(sql.toString()).executeSQL(); 

4、app执行SQL：

DbUtil.execute(ctx, sql, new Object[] { map.get("remain"), map.get("id") });

5、获取当前会计期间:

CompanyOrgUnitInfo currentFIUnit = ContextUtil.getCurrentFIUnit(ctx);
PeriodInfo currentPeriod = SystemStatusCtrolUtils.getCurrentPeriod(ctx, SystemEnum.GENERALLEDGER, currentFIUnit);

6、获取当前期间上一期间

//获取上一期间
PeriodInfo prePeriodInfo = PeriodUtils.getPrePeriodInfo(ctx, new ObjectUuidPK(periodPk));

7、根据bosType获取对应的表:

String tableName = FMIsqlFacadeFactory.getLocalInstance(ctx).getTableNameByBosType(bosType);

8、组织隔离:

FilterInfo otherFilter = com.kingdee.eas.framework.FrameWorkUtils.getF7FilterInfoByAuthorizedOrg(com.kingdee.eas.basedata.org.OrgType.getEnum("Admin"),"OrgUnit.id",true);