/** * easyuiAJAX请求数据 * * @param request * @param response * @param dataGrid * @param user */ @RequestMapping(params = "datagrid") public void datagrid( HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) { CriteriaQuery cq = new CriteriaQuery(TSDepart.class, dataGrid); this.systemService.getDataGridReturn(cq, true); TagUtil.datagrid(response, dataGrid); }
/** * easyui AJAX请求数据 * * @param request * @param response * @param dataGrid * @param user */ @RequestMapping(params = "datagrid") public void datagrid( ItemEntity item, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) { CriteriaQuery cq = new CriteriaQuery(ItemEntity.class, dataGrid); // 查询条件组装器 org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql( cq, item, request.getParameterMap()); this.commonItemService.getDataGridReturn(cq, true); TagUtil.datagrid(response, dataGrid); }
/** * easyuiAJAX请求数据 * * @param request * @param response * @param dataGrid */ @RequestMapping(params = "datagrid") public void datagrid( HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) { CriteriaQuery cq = new CriteriaQuery(TSLog.class, dataGrid); String loglevel = request.getParameter("loglevel"); if (loglevel == null || loglevel.equals("0")) { } else { cq.eq("loglevel", oConvertUtils.getShort(loglevel)); cq.add(); } this.systemService.getDataGridReturn(cq, true); TagUtil.datagrid(response, dataGrid); }
/** * easyui AJAX请求数据 * * @param request * @param response * @param dataGrid * @param user * @throws Exception */ @SuppressWarnings("unchecked") @RequestMapping(params = "datagrid") public void datagrid( TerminalInfoEntity terminalInfo, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid, String groupname) throws Exception { CriteriaQuery cq = new CriteriaQuery(TerminalInfoEntity.class, dataGrid); // 查询条件组装器,fuzzy search String name = terminalInfo.getName(); if (StringUtil.isNotEmpty(name)) { terminalInfo.setName("*" + name + "*"); } org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql( cq, terminalInfo, request.getParameterMap()); this.terminalInfoService.getDataGridReturn(cq, true); List<TerminalInfoEntity> terminals = dataGrid.getResults(); List<TerminalInfoPage> results = new ArrayList<TerminalInfoPage>(); // 添加地理位置 for (TerminalInfoEntity t : terminals) { if (StringUtil.isNotEmpty(t.getGroupid())) { TerminalInfoPage page = new TerminalInfoPage(); MyBeanUtils.copyBeanNotNull2Bean(t, page); TSTerritory self = systemService.get(TSTerritory.class, t.getGroupid()); String territoryName = ""; List<TSTerritory> ts = new ArrayList<TSTerritory>(); TSTerritory parent = self.getTSTerritory(); ts.add(self); String pid = parent.getId(); // 当父组织机构不为根机构时,查找父机构 while (!"1".equals(pid)) { parent = systemService.get(TSTerritory.class, pid); ts.add(parent); parent = parent.getTSTerritory(); pid = parent.getId(); } // 按照添加顺序逆序 Collections.reverse(ts); for (TSTerritory te : ts) { territoryName += "-" + te.getTerritoryName(); } page.setGroupname(territoryName.substring(1)); results.add(page); } } dataGrid.setResults(results); TagUtil.datagrid(response, dataGrid); }
/** * easyui AJAX请求数据 * * @param request * @param response * @param dataGrid * @param user */ @SuppressWarnings("unchecked") @RequestMapping(params = "datagrid") public void datagrid( ConfCodecRecordSrvEntity confCodecRecordSrv, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) { CriteriaQuery cq = new CriteriaQuery(ConfCodecRecordSrvEntity.class, dataGrid); // 查询条件组装器 org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql( cq, confCodecRecordSrv, request.getParameterMap()); this.confCodecRecordSrvService.getDataGridReturn(cq, true); TagUtil.datagrid(response, dataGrid); }
/** * easyuiAJAX列表请求数据 * * @param request * @param response * @param dataGrid */ @RequestMapping(params = "datagrid") public void datagrid( ZkZhBanner entity, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) { CriteriaQuery cq = new CriteriaQuery(ZkZhBanner.class, dataGrid); // 查询条件组装器 org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, entity); // Object[] isshow = {Short.parseShort("1"),Short.parseShort("2")};//搜寻显示或是不显示的内容 // cq.in("isshow", isshow); cq.add(); this.systemService.getDataGridReturn(cq, true); TagUtil.datagrid(response, dataGrid); }
/** * easyui AJAX请求数据 * * @param request * @param response * @param dataGrid * @param user */ @RequestMapping(params = "datagrid") public void datagrid( WeixinExpandconfigEntity weixinExpandconfig, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) { CriteriaQuery cq = new CriteriaQuery(WeixinExpandconfigEntity.class, dataGrid); // 查询条件组装器 org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql( cq, weixinExpandconfig, request.getParameterMap()); try { // 自定义追加查询条件 } catch (Exception e) { throw new BusinessException(e.getMessage()); } cq.add(); this.weixinExpandconfigService.getDataGridReturn(cq, true); TagUtil.datagrid(response, dataGrid); }
/** * easyui AJAX请求数据 * * @param request * @param response * @param dataGrid * @param user */ @RequestMapping(params = "datagrid") public void datagrid( TbOrderTrackingEntity tbOrderTracking, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) { CriteriaQuery cq = new CriteriaQuery(TbOrderTrackingEntity.class, dataGrid); // 查询条件组装器 org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, tbOrderTracking); // System.out.println("tbOrderTrackIng:"+tbOrderTracking.getId()); if (null != tbOrderTracking.getOrderId() && !"".equals(tbOrderTracking.getOrderId()) && null != tbOrderTracking.getOrderId().getId()) { cq.createAlias("orderId", "tbOrders"); cq.eq("orderId.id", tbOrderTracking.getOrderId().getId()); cq.add(); } this.tbOrderTrackingService.getDataGridReturn(cq, true); TagUtil.datagrid(response, dataGrid); }
/** * easyuiAJAX请求数据 * * @param request * @param response * @param dataGrid */ @RequestMapping(params = "datagrid") public void datagrid( HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) { CriteriaQuery cq = new CriteriaQuery(TSLog.class, dataGrid); String loglevel = request.getParameter("loglevel"); if (loglevel == null || loglevel.equals("0")) { } else { cq.eq("loglevel", oConvertUtils.getShort(loglevel)); cq.add(); } // add-begin--Author:zhangguoming Date:20140427 for:添加查询条件 操作时间 String operatetime_begin = request.getParameter("operatetime_begin"); if (operatetime_begin != null) { Timestamp beginValue = null; try { beginValue = DataUtils.parseTimestamp(operatetime_begin, "yyyy-MM-dd"); } catch (ParseException e) { e.printStackTrace(); } cq.ge("operatetime", beginValue); } String operatetime_end = request.getParameter("operatetime_end"); if (operatetime_end != null) { if (operatetime_end.length() == 10) { operatetime_end = operatetime_end + " 23:59:59"; } Timestamp endValue = null; try { endValue = DataUtils.parseTimestamp(operatetime_end, "yyyy-MM-dd hh:mm:ss"); } catch (ParseException e) { e.printStackTrace(); } cq.le("operatetime", endValue); } cq.add(); // add-end--Author:zhangguoming Date:20140427 for:添加查询条件 操作时间 this.systemService.getDataGridReturn(cq, true); TagUtil.datagrid(response, dataGrid); }