@Override public Map<String, Object> queryCopynodeByProcessKey(String processKey) throws Exception { final Map<String, Object> copynodes = new HashMap<String, Object>(); final Object dual = new Object(); executor.queryByNullRowHandler(new NullRowHandler() { @Override public void handleRow(Record record) throws Exception { copynodes.put(record.getString("NODE_KEY"), dual); } }, "querycopynodeByProcessKey", processKey); return copynodes; }
@Override public List<Map<String, String>> getQuestionTitleById(String titleId) throws Exception { final List<Map<String, String>> titleList = new ArrayList<Map<String, String>>(); executor.queryByNullRowHandler(new NullRowHandler() { @Override public void handleRow(Record origine) throws Exception { Map<String, String> tilteMap = new HashMap<String, String>(); String title = (String) origine.getString("TITLE"); String id = (String) origine.getString("ID"); tilteMap.put("TITLE", title); tilteMap.put("ID", id); titleList.add(tilteMap); } }, "getQuestionTitleById", titleId); return titleList; }
@Override public List<Map<String, String>> getSingleSub(String appId, String userId) throws Exception { final List<Map<String, String>> list = new ArrayList<Map<String, String>>(); executor.queryByNullRowHandler(new NullRowHandler() { @Override public void handleRow(Record origine) throws Exception { Map<String,String> map = new HashMap<String,String>(); map.put("userId", origine.getString("USER_ID")); map.put("appId", origine.getString("APP_ID")); map.put("pendingSubscribe", origine.getString("PENDING_SUBSCRIBE")); list.add(map); } }, "getSingleSub", appId,userId); return list; } @Override
@Override public Map<String, String> queryOrgToArea() throws Exception { final Map<String, String> datas = new HashMap<String, String>(); try{ executor.queryByNullRowHandler(new NullRowHandler() { @Override public void handleRow(Record origine) throws Exception { datas.put(origine.getString("orgId"), origine.getString("areaId")); } }, "queryOrgToArea"); }catch(Exception e){ e.printStackTrace(); } return datas; } @Override
@Override public Set<String> querySubOrg(String str) throws Exception { final Set<String> set = new HashSet<String> (); try{ executor.queryByNullRowHandler(new NullRowHandler() { @Override public void handleRow(Record origine) throws Exception { set.add(origine.getString("orgId")); } }, "querySubOrg",str); }catch(Exception e){ e.printStackTrace(); } return set; } @Override
@Override public Map<String, String> getThisAndNextYearArrange(String areaId,String thisYear) throws Exception { final Map<String, String> datas = new HashMap<String, String>(); String nextYear = String.valueOf(Integer.parseInt(thisYear)+1); try{ executor.queryByNullRowHandler(new NullRowHandler() { @Override public void handleRow(Record origine) throws Exception { datas.put(origine.getString("dateOfYear"), origine.getString("type")); } }, "getThisAndNextYearArrange",areaId,thisYear,nextYear); }catch(Exception e){ e.printStackTrace(); } return datas; } @Override
final List<Map<String, Object>> list = new ArrayList<Map<String, Object>>(); executor.queryByNullRowHandler(new NullRowHandler() { @Override public void handleRow(Record origine) throws Exception {
executor.queryByNullRowHandler(new NullRowHandler() { @Override public void handleRow(Record origine) throws Exception { executor.queryByNullRowHandler(new NullRowHandler() { @Override public void handleRow(Record origine) throws Exception {
/** * 获取根据活动任务id获取任务的阅读记录中文名称 * @param actinstid 活动任务id * @return */ public String getCopyTaskReadUserNames(String actinstid) { try { final StringBuffer users = new StringBuffer(); ConfigSQLExecutor executor = this.findProcessEngineConfigurationImpl().getExtendExecutor(); executor.queryByNullRowHandler(new NullRowHandler(){ @Override public void handleRow(Record origine) throws Exception { if(users.length() == 0) users.append(origine.getString("COPERCNName")); else users.append(",").append(origine.getString("COPERCNName")); } }, "getCopyTaskReadUserNames", actinstid); return users.toString(); } catch (Exception e) { throw new ActivitiException("getCopyTaskReadUsers[actinstid="+actinstid +"] failed:",e); } }
executor.queryByNullRowHandler(new NullRowHandler(){