一个简单的例子 ,项目当中使用过,拼接筛选条件sql。
/**
* 列表
*
* @return
*/
@RequestMapping(params = "doRenLing")
public ModelAndView doRenLing(HttpServletRequest request,BaseChanpinbomEntity baseChanpinbom) {
if (StringUtil.isNotEmpty(baseChanpinbom.getId())) {
baseChanpinbom = baseChanpinbomService.getEntity(BaseChanpinbomEntity.class, baseChanpinbom.getId());
request.setAttribute("BOMID", baseChanpinbom.getId());
}
return new ModelAndView("com/szerp/basechanpinbom/baseChanpinbomRenLing");
}
/**
* easyui AJAX请求数据
*
* @param request
* @param response
* @param dataGrid
* @param user
*/
@RequestMapping(params = "sublistListDatagrid")
@ResponseBody
public void sublistListDatagrid (BaseChanpinbomsublistEntity baseChanpinbomsublist,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
CriteriaQuery cq = new CriteriaQuery(BaseChanpinbomsublistEntity.class, dataGrid);
//查询条件组装器
org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, baseChanpinbomsublist, request.getParameterMap());
try{
//自定义追加查询条件
String parentId = request.getParameter("BOMID");
BaseChanpinbomsublistEntity sublistEntity = baseChanpinbomDao.findBaseChanpinbomsublistEntity(parentId);
parentId = StringUtils.isBlank(parentId) ? "0" : parentId;
cq.eq("baseChanpinbomID", parentId);
if(sublistEntity!=null){
cq.add(Restrictions.sqlRestriction("1=1 and (wuLiaoBianMa <>'"+sublistEntity.getWuLiaoBianMa()+"' OR wuLiaoBianMa IS NULL)"));
}
}catch (Exception e) {
e.printStackTrace();
throw new BusinessException(e.getMessage());
}
cq.add();
this.baseChanpinbomsublistService.getDataGridReturn(cq, true);
TagUtil.datagrid(response, dataGrid);
}