public CityTrl[] getCityCityList(String value, String countryId, String provinceId) { // System.out.println("bgn"); if (!DwrPrivilegeFilter.isView(this.getClass().getName())) { return null; } if (value == null) value = ""; Map param = new HashMap(); WebContext webContext = WebContextFactory.get(); HttpServletRequest request = webContext.getHttpServletRequest(); UserResource ur = (UserResource) request.getSession().getAttribute("resource"); StringBuilder sb = new StringBuilder(""); if (StringUtil.isNotEmpty(provinceId)) { sb.append("and parent_id=").append(provinceId); } else if (StringUtil.isNotEmpty(countryId)) { sb.append("and parent_id in (select id from base_city where parent_id=") .append(countryId) .append(")"); } param.put( "accessString", "language='" + ur.getLocale().toString() + "' and ((name like '%" + value.trim() + "%') or (remark like '%" + value.trim() + "%')) and city_id in( select id from base_city where levelint=3 " + sb.toString() + ")"); List<CityTrl> list = cityTrlService.selectByExample(param); if (list != null) { if (list.size() > 10) { list = list.subList(0, 10); } CityTrl[] cityTrlArray = new CityTrl[list.size()]; list.toArray(cityTrlArray); // System.out.println("comp"); return cityTrlArray; } return null; }
public void writeLog(CoreModel model, String operateType) { String name = model.getClass().getName(); Map<String, Object> param = new HashMap<String, Object>(); param.put("className", name); param.put("outLog", "Y"); List<Table> tableList = sqlSessionTemplate.selectList( "com.delmar.core.mybatis.sql.TableMapper.selectByExample", param); Table table = null; if (tableList != null && tableList.size() > 0) { table = tableList.get(0); } try { if (table != null) { param = new HashMap<String, Object>(); param.put("tableId", table.getId()); List<TableColumn> tableColumnList = sqlSessionTemplate.selectList( "com.delmar.core.mybatis.sql.TableColumnMapper.selectByExample", param); Map<String, Object> obj = new HashMap<String, Object>(); if (tableColumnList != null) { for (TableColumn column : tableColumnList) { obj.put( column.getAttributeName(), PropertyUtils.getProperty(model, column.getAttributeName())); } } Changelog log = new Changelog(); log.setOperateType(operateType); log.setCreated(new Date()); log.setContext(gson.toJson(obj)); if (request != null) { UserInterface user = (UserInterface) request.getSession().getAttribute("loginUser"); if (user != null) { log.setUserId(user.getId()); log.setUsername(user.getUsername()); } else { String userName = SessionContent.getUserId(Thread.currentThread().getId()); log.setUsername(userName); } } else { String userName = SessionContent.getUserId(Thread.currentThread().getId()); log.setUsername(userName); } Object pk = PropertyUtils.getProperty(model, "id"); if (pk != null) log.setPk((Integer) pk); if (StringUtil.isNotEmpty(table.getBuPk())) { Object buPk = PropertyUtils.getProperty(model, table.getBuPk()); if (buPk != null) log.setBuPk(buPk.toString()); } log.setTableId(table.getId()); sqlSessionTemplate.insert("com.delmar.core.mybatis.sql.ChangelogMapper.insert", log); } } catch (Exception e) { logger.error("插入操作日志异常", e); } }