通过xmb关联sspq

  @RequestMapping(value = "getAreaByTypeName.html", method = RequestMethod.GET) @ResponseBody public Map<String, Object> getAreaByTypeName(HttpServletRequest request) { 
   
        Map<String, Object> map = new HashMap<>();
        String name = request.getParameter("name");
        String xmb = request.getParameter("xmb");
        List<TAreaEntity> entityList = tAreaService.queryAllAreaByPCodeApp(name,xmb);
        map.put("code",0);
        map.put("msg","查询成功");
        map.put("data",entityList);
        return map;
    }

 @Transactional(readOnly = true) public List<TAreaEntity> queryAllAreaByPCodeApp(String name,String xmb) { 
   
       /* String pcode = ""; switch (name) { case "车行道": case "人行道（广场）": case "人行道": pcode = "B01"; break; case "桥梁": pcode = "B02"; break; case "泵站": pcode = "B09"; break; case "路灯": pcode = "B03"; break; case "排水": pcode = "B04"; break; case "绿化": case "园林绿化": pcode = "B07"; break; default: pcode = ""; break; } if (!StringFacs.isEmpty(pcode)) { return tAreaDao.queryAllAreaByPcode(pcode); }*/
        return tAreaDao.queryAllAreaByPcodeApp(xmb);
    }

相关sql

 public List<TAreaEntity> queryAllAreaByPcodeApp(String xmb) { 
   
        String hql = "from login.bean.TAreaEntity where isDelete='0' and operationStatue=0 ";
        if (!StringFacs.isEmpty(xmb)) { 
   
            hql+="and ProDepartment='"+xmb+"'";        }
        hql+="order by sortnot";
        return jdbcTemplate.getCurrentSession().createQuery(hql).list();
    }

今天的文章通过xmb关联sspq分享到此就结束了，感谢您的阅读。