org.jeecgframework.core.common.hibernate.qbc.CriteriaQuery.add() - java examples

Here are the examples of the java api org.jeecgframework.core.common.hibernate.qbc.CriteriaQuery.add() taken from open source projects. By voting up you can indicate which examples are most useful and appropriate.

151 Examples 7

19 View Complete Implementation : TSSmsTemplateController.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * easyui AJAX请求数据
 *
 * @param request
 * @param response
 * @param dataGrid
 * @param user
 */
@RequestMapping(params = "datagrid")
public void datagrid(TSSmsTemplateEnreplacedy tSSmsTemplate, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(TSSmsTemplateEnreplacedy.clreplaced, dataGrid);
    // 查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, tSSmsTemplate, request.getParameterMap());
    try {
    // 自定义追加查询条件
    } catch (Exception e) {
        throw new BusinessException(e.getMessage());
    }
    cq.add();
    this.tSSmsTemplateService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
}

19 View Complete Implementation : HqlGenerateUtil.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * 自动生成查询条件HQL 模糊查询 不带有日期组合
 *
 * @param cq
 * @param searchObj
 * @throws Exception
 */
public static void installHql(CriteriaQuery cq, Object searchObj) {
    installHqlJoinAlias(cq, searchObj, null, "");
    cq.add();
}

19 View Complete Implementation : NoticeAuthorityRoleController.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * easyui AJAX请求数据
 *
 * @param request
 * @param response
 * @param dataGrid
 * @param user
 */
@RequestMapping(params = "datagrid")
public void datagrid(TSNoticeAuthorityRole noticeAuthorityRole, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(TSNoticeAuthorityRole.clreplaced, dataGrid);
    // 查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, noticeAuthorityRole, request.getParameterMap());
    try {
    // 自定义追加查询条件
    } catch (Exception e) {
        throw new BusinessException(e.getMessage());
    }
    cq.add();
    this.noticeAuthorityRoleService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
}

19 View Complete Implementation : HuodongController.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * easyui AJAX请求数据
 *
 * @param request
 * @param response
 * @param dataGrid
 * @param user
 */
@RequestMapping(params = "datagrid")
public void datagrid(HuodongEnreplacedy huodong, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    String type = request.getParameter("type");
    CriteriaQuery cq = new CriteriaQuery(HuodongEnreplacedy.clreplaced, dataGrid);
    cq.eq("type", type);
    cq.eq(ACCOUNTID, ResourceUtil.getWeiXinAccountId());
    cq.add();
    org.jeecgframework.core.util.LogUtil.info(".....type....." + type);
    // 查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, huodong, request.getParameterMap());
    this.huodongService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
}

19 View Complete Implementation : SystemServiceImpl.java
Copyright Apache License 2.0
Author : zhangdaiscott
public Set<String> getOperationCodesByRoleIdAndFunctionId(String roleId, String functionId) {
    Set<String> operationCodes = new HashSet<String>();
    TSRole role = commonDao.get(TSRole.clreplaced, roleId);
    CriteriaQuery cq1 = new CriteriaQuery(TSRoleFunction.clreplaced);
    cq1.eq("TSRole.id", role.getId());
    cq1.eq("TSFunction.id", functionId);
    cq1.add();
    List<TSRoleFunction> rFunctions = getListByCriteriaQuery(cq1, false);
    if (null != rFunctions && rFunctions.size() > 0) {
        TSRoleFunction tsRoleFunction = rFunctions.get(0);
        if (null != tsRoleFunction.getOperation()) {
            String[] operationArry = tsRoleFunction.getOperation().split(",");
            for (int i = 0; i < operationArry.length; i++) {
                operationCodes.add(operationArry[i]);
            }
        }
    }
    return operationCodes;
}

19 View Complete Implementation : CgreportConfigHeadController.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * easyui AJAX请求数据
 *
 * @param request
 * @param response
 * @param dataGrid
 * @param user
 */
@RequestMapping(params = "datagrid")
public void datagrid(CgreportConfigHeadEnreplacedy cgreportConfigHead, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(CgreportConfigHeadEnreplacedy.clreplaced, dataGrid);
    // 查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, cgreportConfigHead);
    try {
    // 自定义追加查询条件
    } catch (Exception e) {
        throw new BusinessException(e.getMessage());
    }
    cq.add();
    this.cgreportConfigHeadService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
}

19 View Complete Implementation : TSSmsTemplateSqlController.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * easyui AJAX请求数据
 *
 * @param request
 * @param response
 * @param dataGrid
 * @param user
 */
@RequestMapping(params = "datagrid")
public void datagrid(TSSmsTemplateSqlEnreplacedy tSSmsTemplateSql, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(TSSmsTemplateSqlEnreplacedy.clreplaced, dataGrid);
    // 查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, tSSmsTemplateSql, request.getParameterMap());
    try {
    // 自定义追加查询条件
    } catch (Exception e) {
        throw new BusinessException(e.getMessage());
    }
    cq.add();
    this.tSSmsTemplateSqlService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
}

19 View Complete Implementation : CgDynamGraphConfigHeadController.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * easyui AJAX请求数据
 *
 * @param request
 * @param response
 * @param dataGrid
 * @param user
 */
@RequestMapping(params = "datagrid")
public void datagrid(CgDynamGraphConfigHeadEnreplacedy cgDynamGraphConfigHead, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(CgDynamGraphConfigHeadEnreplacedy.clreplaced, dataGrid);
    // 查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, cgDynamGraphConfigHead);
    try {
    // 自定义追加查询条件
    } catch (Exception e) {
        throw new BusinessException(e.getMessage());
    }
    cq.add();
    this.cgDynamGraphConfigHeadService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
}

19 View Complete Implementation : HqlGenerateUtil.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * 自动生成查询条件HQL(扩展区间查询功能)
 *
 * @param cq
 * @param searchObj
 * @param parameterMap
 *            request参数集合,封装了所有查询信息
 */
public static void installHql(CriteriaQuery cq, Object searchObj, Map<String, String[]> parameterMap) {
    installHqlJoinAlias(cq, searchObj, parameterMap, "");
    cq.add();
}

19 View Complete Implementation : JfromOrderController.java
Copyright Apache License 2.0
Author : zhangdaiscott
@RequestMapping(params = "jfromOrderLineDatagrid")
public void jfromOrderLineDatagrid(JfromOrderLineEnreplacedy jfromOrderLineEnreplacedy, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(JfromOrderLineEnreplacedy.clreplaced, dataGrid);
    // 查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, jfromOrderLineEnreplacedy);
    cq.add();
    this.jfromOrderService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
}

19 View Complete Implementation : HdRecordController.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * easyui AJAX请求数据
 *
 * @param request
 * @param response
 * @param dataGrid
 * @param user
 */
@RequestMapping(params = "datagrid")
public void datagrid(HdRecordEnreplacedy hdRecord, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    String hdId = request.getParameter("hdId");
    CriteriaQuery cq = new CriteriaQuery(HdRecordEnreplacedy.clreplaced, dataGrid);
    cq.eq("hdid", hdId);
    cq.eq(ACCOUNTID, ResourceUtil.getWeiXinAccountId());
    cq.add();
    // 查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, hdRecord, request.getParameterMap());
    this.hdRecordService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
}

19 View Complete Implementation : SystemServiceImpl.java
Copyright Apache License 2.0
Author : zhangdaiscott
public Set<String> getOperationCodesByUserIdAndFunctionId(String userId, String functionId) {
    Set<String> operationCodes = new HashSet<String>();
    List<TSRoleUser> rUsers = findByProperty(TSRoleUser.clreplaced, "TSUser.id", userId);
    for (TSRoleUser ru : rUsers) {
        TSRole role = ru.getTSRole();
        CriteriaQuery cq1 = new CriteriaQuery(TSRoleFunction.clreplaced);
        cq1.eq("TSRole.id", role.getId());
        cq1.eq("TSFunction.id", functionId);
        cq1.add();
        List<TSRoleFunction> rFunctions = getListByCriteriaQuery(cq1, false);
        if (null != rFunctions && rFunctions.size() > 0) {
            TSRoleFunction tsRoleFunction = rFunctions.get(0);
            if (null != tsRoleFunction.getOperation()) {
                String[] operationArry = tsRoleFunction.getOperation().split(",");
                for (int i = 0; i < operationArry.length; i++) {
                    operationCodes.add(operationArry[i]);
                }
            }
        }
    }
    return operationCodes;
}

19 View Complete Implementation : TSSmsSqlController.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * easyui AJAX请求数据
 *
 * @param request
 * @param response
 * @param dataGrid
 * @param user
 */
@RequestMapping(params = "datagrid")
public void datagrid(TSSmsSqlEnreplacedy tSSmsSql, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(TSSmsSqlEnreplacedy.clreplaced, dataGrid);
    // 查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, tSSmsSql, request.getParameterMap());
    try {
    // 自定义追加查询条件
    } catch (Exception e) {
        throw new BusinessException(e.getMessage());
    }
    cq.add();
    this.systemService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
}

19 View Complete Implementation : PrizeRecordController.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * easyui AJAX请求数据
 *
 * @param request
 * @param response
 * @param dataGrid
 * @param user
 */
@RequestMapping(params = "datagrid")
public void datagrid(PrizeRecordEnreplacedy prizeRecord, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    String hdid = request.getParameter("hdid");
    org.jeecgframework.core.util.LogUtil.info(".....openwin...." + hdid);
    CriteriaQuery cq = new CriteriaQuery(PrizeRecordEnreplacedy.clreplaced, dataGrid);
    cq.eq("hdid", hdid);
    cq.eq(ACCOUNTID, ResourceUtil.getWeiXinAccountId());
    cq.add();
    // 查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, prizeRecord, request.getParameterMap());
    this.prizeRecordService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
}

19 View Complete Implementation : NoticeAuthorityUserController.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * easyui AJAX请求数据
 *
 * @param request
 * @param response
 * @param dataGrid
 * @param user
 */
@RequestMapping(params = "datagrid")
public void datagrid(TSNoticeAuthorityUser noticeAuthorityUser, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(TSNoticeAuthorityUser.clreplaced, dataGrid);
    // 查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, noticeAuthorityUser, request.getParameterMap());
    try {
    // 自定义追加查询条件
    } catch (Exception e) {
        throw new BusinessException(e.getMessage());
    }
    cq.add();
    this.noticeAuthorityUserService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
}

19 View Complete Implementation : CgformEnhanceJavaController.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * easyui AJAX请求数据
 *
 * @param request
 * @param response
 * @param dataGrid
 * @param user
 */
@RequestMapping(params = "datagrid")
public void datagrid(CgformEnhanceJavaEnreplacedy cgformEnhanceJava, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(CgformEnhanceJavaEnreplacedy.clreplaced, dataGrid);
    // 查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, cgformEnhanceJava, request.getParameterMap());
    try {
    // 自定义追加查询条件
    } catch (Exception e) {
        throw new BusinessException(e.getMessage());
    }
    cq.add();
    this.cgformEnhanceJavaService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
}

19 View Complete Implementation : NoticeAuthorityUserServiceImpl.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * 检查通知公告授权用户是否存在
 */
public boolean checkAuthorityUser(String noticeId, String userid) {
    CriteriaQuery cq = new CriteriaQuery(TSNoticeAuthorityUser.clreplaced);
    cq.eq("user.id", userid);
    cq.eq("noticeId", noticeId);
    cq.add();
    List<TSNoticeAuthorityUser> rlist = this.getListByCriteriaQuery(cq, false);
    if (rlist.size() == 0) {
        return false;
    } else {
        return true;
    }
}

19 View Complete Implementation : WeixinExpandconfigController.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * easyui AJAX请求数据
 *
 * @param request
 * @param response
 * @param dataGrid
 * @param user
 */
@RequestMapping(params = "datagrid")
public void datagrid(WeixinExpandconfigEnreplacedy weixinExpandconfig, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(WeixinExpandconfigEnreplacedy.clreplaced, 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);
}

18 View Complete Implementation : WeixinLinksucaiServiceImpl.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * 按微信账号邮编及共享方式查询
 * @param <T>
 * @return
 */
public <T> List<T> getLinksucaiList() {
    CriteriaQuery cq = new CriteriaQuery(WeixinLinksucaiEnreplacedy.clreplaced);
    cq.eq("accountid", ResourceUtil.getShangJiaAccountId());
    cq.eq("shareStatus", WeiXinOpenConstants.SUCAI_SHARE_STATUS);
    cq.add(cq.or(cq.and(cq, 1, 2), cq, 0));
    Criteria criteria = cq.getDetachedCriteria().getExecutableCriteria(getSession());
    List<T> list = criteria.list();
    return list;
}

18 View Complete Implementation : JfromOrderController.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * easyui AJAX请求数据
 *
 * @param request
 * @param response
 * @param dataGrid
 * @param user
 */
@RequestMapping(params = "datagrid")
public void datagrid(JfromOrderEnreplacedy jfromOrder, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(JfromOrderEnreplacedy.clreplaced, dataGrid);
    // 查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, jfromOrder);
    try {
        String sql = SuperQueryUtil.getComplxSuperQuerySQL(request);
        if (oConvertUtils.isNotEmpty(sql)) {
            cq.add(Restrictions.sqlRestriction(" id in (" + sql + ")"));
        }
    // 自定义追加查询条件
    } catch (Exception e) {
        e.printStackTrace();
        throw new BusinessException(e.getMessage());
    }
    cq.add();
    this.jfromOrderService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
}

18 View Complete Implementation : MultiUploadController.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * easyui AJAX请求数据
 *
 * @param request
 * @param response
 * @param dataGrid
 * @param user
 */
@RequestMapping(params = "datagrid")
public void datagrid(MultiUploadEnreplacedy multiUpload, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(MultiUploadEnreplacedy.clreplaced, dataGrid);
    // 查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, multiUpload, request.getParameterMap());
    try {
    // 自定义追加查询条件
    } catch (Exception e) {
        throw new BusinessException(e.getMessage());
    }
    cq.add();
    this.multiUploadService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
}

18 View Complete Implementation : TsBlackListController.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * easyui AJAX请求数据
 *
 * @param request
 * @param response
 * @param dataGrid
 * @param user
 */
@RequestMapping(params = "datagrid")
public void datagrid(TsBlackListEnreplacedy tsBlackList, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(TsBlackListEnreplacedy.clreplaced, dataGrid);
    // 查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, tsBlackList, request.getParameterMap());
    try {
    // 自定义追加查询条件
    } catch (Exception e) {
        throw new BusinessException(e.getMessage());
    }
    cq.add();
    this.tsBlackListService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
}

18 View Complete Implementation : JformGraphreportHeadController.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * easyui AJAX请求数据
 *
 * @param request
 * @param response
 * @param dataGrid
 * @param
 */
@RequestMapping(params = "datagrid")
public void datagrid(JformGraphreportHeadEnreplacedy jformGraphreportHead, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(JformGraphreportHeadEnreplacedy.clreplaced, dataGrid);
    // 查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, jformGraphreportHead);
    try {
    // 自定义追加查询条件
    } catch (Exception e) {
        throw new BusinessException(e.getMessage());
    }
    cq.add();
    this.jformGraphreportHeadService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
}

18 View Complete Implementation : SuperQueryMainController.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * easyui AJAX请求数据
 *
 * @param request
 * @param response
 * @param dataGrid
 * @param user
 */
@RequestMapping(params = "datagrid")
public void datagrid(SuperQueryMainEnreplacedy superQueryMain, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(SuperQueryMainEnreplacedy.clreplaced, dataGrid);
    // 查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, superQueryMain);
    try {
        // 自定义追加查询条件
        String sql = SuperQueryUtil.getComplxSuperQuerySQL(request);
        if (oConvertUtils.isNotEmpty(sql)) {
            cq.add(Restrictions.sqlRestriction(" id in (" + sql + ")"));
        }
    } catch (Exception e) {
        throw new BusinessException(e.getMessage());
    }
    cq.add();
    this.superQueryMainService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
}

18 View Complete Implementation : TSCompanyPositionController.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * easyui AJAX请求数据
 *
 * @param request
 * @param response
 * @param dataGrid
 * @param user
 */
@RequestMapping(params = "datagrid")
public void datagrid(TSCompanyPositionEnreplacedy tSCompanyPosition, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(TSCompanyPositionEnreplacedy.clreplaced, dataGrid);
    // 查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, tSCompanyPosition, request.getParameterMap());
    try {
    // 自定义追加查询条件
    } catch (Exception e) {
        throw new BusinessException(e.getMessage());
    }
    cq.add();
    this.tSCompanyPositionService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
}

18 View Complete Implementation : TSDictTableConfigController.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * easyui AJAX请求数据
 *
 * @param request
 * @param response
 * @param dataGrid
 * @param user
 */
@RequestMapping(params = "datagrid")
public void datagrid(TSDictTableConfigEnreplacedy tSDictTableConfig, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(TSDictTableConfigEnreplacedy.clreplaced, dataGrid);
    // 查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, tSDictTableConfig, request.getParameterMap());
    try {
    // 自定义追加查询条件
    } catch (Exception e) {
        throw new BusinessException(e.getMessage());
    }
    cq.add();
    this.tSDictTableConfigService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
}

18 View Complete Implementation : InterroleServiceImpl.java
Copyright Apache License 2.0
Author : zhangdaiscott
public Set<String> getOperationCodesByRoleIdAndruleDataId(String roleId, String interfaceId) {
    Set<String> operationCodes = new HashSet<String>();
    InterroleEnreplacedy role = commonDao.get(InterroleEnreplacedy.clreplaced, roleId);
    CriteriaQuery cq1 = new CriteriaQuery(InterroleInterfaceEnreplacedy.clreplaced);
    cq1.eq("interroleEnreplacedy.id", role.getId());
    cq1.eq("interfaceEnreplacedy.id", interfaceId);
    cq1.add();
    List<InterroleInterfaceEnreplacedy> rFunctions = getListByCriteriaQuery(cq1, false);
    if (null != rFunctions && rFunctions.size() > 0) {
        InterroleInterfaceEnreplacedy tsRoleInterface = rFunctions.get(0);
        if (null != tsRoleInterface.getDataRule()) {
            String[] operationArry = tsRoleInterface.getDataRule().split(",");
            for (int i = 0; i < operationArry.length; i++) {
                operationCodes.add(operationArry[i]);
            }
        }
    }
    return operationCodes;
}

18 View Complete Implementation : NoticeAuthorityRoleServiceImpl.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * 检查通知公告授权角色是否存在
 */
public boolean checkAuthorityRole(String noticeId, String roleid) {
    CriteriaQuery cq = new CriteriaQuery(TSNoticeAuthorityRole.clreplaced);
    // 查询条件组装器
    cq.eq("role.id", roleid);
    cq.eq("noticeId", noticeId);
    cq.add();
    List<TSNoticeAuthorityRole> rlist = this.getListByCriteriaQuery(cq, false);
    if (rlist.size() == 0) {
        return false;
    } else {
        return true;
    }
}

18 View Complete Implementation : UserNoPageController.java
Copyright Apache License 2.0
Author : zhangdaiscott
@RequestMapping(params = "datagridNoPage")
public void datagridNoPage(TSUser user, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(TSUser.clreplaced, dataGrid);
    // 查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, user);
    Short[] userstate = new Short[] { Globals.User_Normal, Globals.User_ADMIN };
    cq.in("status", userstate);
    cq.add();
    this.systemService.getDataGridReturn(cq, false);
    TagUtil.datagrid(response, dataGrid);
}

18 View Complete Implementation : RoleController.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * easyuiAJAX请求数据
 *
 * @param request
 * @param response
 * @param dataGrid
 * @param user
 */
@RequestMapping(params = "roleGrid")
public void roleGrid(TSRole role, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(TSRole.clreplaced, dataGrid);
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, role);
    cq.add();
    this.systemService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
    ;
}

18 View Complete Implementation : WeixinAccountController.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * easyui AJAX请求数据
 *
 * @param request
 * @param response
 * @param dataGrid
 * @param user
 */
@RequestMapping(params = "datagrid")
public void datagrid(WeixinAccountEnreplacedy weixinAccount, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(WeixinAccountEnreplacedy.clreplaced, dataGrid);
    // 查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, weixinAccount, request.getParameterMap());
    cq.eq("userName", ResourceUtil.getSessionUserName().getUserName());
    try {
    // 自定义追加查询条件
    } catch (Exception e) {
        throw new BusinessException(e.getMessage());
    }
    cq.add();
    this.weixinAccountService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
}

18 View Complete Implementation : WeixinLinksucaiServiceImpl.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * 按微信账号邮编及共享方式查询
 * @param <T>
 * @return
 */
public <T> List<T> getLinksucaiListForSelect(String likeName) {
    CriteriaQuery cq = new CriteriaQuery(WeixinLinksucaiEnreplacedy.clreplaced);
    cq.eq("accountid", ResourceUtil.getShangJiaAccountId());
    cq.eq("shareStatus", WeiXinOpenConstants.SUCAI_SHARE_STATUS);
    if (oConvertUtils.isNotEmpty(likeName)) {
        cq.like("name", "%" + likeName + "%");
        cq.add(cq.and(cq.and(cq.or(cq, 1, 2), cq, 0), cq, 3));
    } else {
        cq.add(cq.or(cq.and(cq, 1, 2), cq, 0));
    }
    cq.addOrder("createDate", SortDirection.desc);
    Criteria criteria = cq.getDetachedCriteria().getExecutableCriteria(getSession());
    List<T> list = criteria.list();
    return list;
}

17 View Complete Implementation : JeecgDemoExcelController.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * easyui AJAX请求数据
 *
 * @param request
 * @param response
 * @param dataGrid
 * @param user
 */
@RequestMapping(params = "datagrid")
public void datagrid(JeecgDemoExcelEnreplacedy jeecgDemoExcel, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(JeecgDemoExcelEnreplacedy.clreplaced, dataGrid);
    // 查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, jeecgDemoExcel, request.getParameterMap());
    try {
    // 自定义追加查询条件
    } catch (Exception e) {
        throw new BusinessException(e.getMessage());
    }
    cq.add();
    this.jeecgDemoExcelService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
}

17 View Complete Implementation : JformOrderMainController.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * easyui AJAX请求数据
 *
 * @param request
 * @param response
 * @param dataGrid
 * @param user
 */
@RequestMapping(params = "customerDatagrid")
public void customerDatagrid(JformOrderCustomerEnreplacedy jformCustomer, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(JformOrderCustomerEnreplacedy.clreplaced, dataGrid);
    if (jformCustomer.getFkId() == null || "".equals(jformCustomer.getFkId())) {
    } else {
        // 查询条件组装器
        org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, jformCustomer);
        cq.add();
        this.jformOrderMainService.getDataGridReturn(cq, true);
    }
    TagUtil.datagrid(response, dataGrid);
}

17 View Complete Implementation : MutiLangSqlCriteriaUtil.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * 组装查询条件:对多语言字段进行 查询条件的组装
 * @param fieldLangKeyList 待查询字段对应的语言key列表
 * @param cq 查询条件实体 - CriteriaQuery
 * @param fieldName 待查询字段名称
 * @param fieldValue 待查询字段值 - 页面传入
 */
public static void replacedembleCondition(List<String> fieldLangKeyList, CriteriaQuery cq, String fieldName, String fieldValue) {
    Map<String, String> fieldLangMap = new HashMap<String, String>();
    for (String nameKey : fieldLangKeyList) {
        String name = MutiLangUtil.getLang(nameKey);
        fieldLangMap.put(nameKey, name);
    }
    if ("*".equals(fieldValue)) {
        fieldValue = "**";
    }
    List<String> paramValueList = new ArrayList<String>();
    for (Map.Entry<String, String> entry : fieldLangMap.entrySet()) {
        String fieldLangKey = entry.getKey();
        String fieldLangValue = entry.getValue();
        if (fieldValue.startsWith("*") && fieldValue.endsWith("*")) {
            if (fieldLangValue.contains(fieldValue.substring(1, fieldValue.length() - 1))) {
                paramValueList.add(fieldLangKey);
            }
        } else if (fieldValue.startsWith("*")) {
            if (fieldLangValue.endsWith(fieldValue.substring(1))) {
                paramValueList.add(fieldLangKey);
            }
        } else if (fieldValue.endsWith("*")) {
            if (fieldLangValue.startsWith(fieldValue.substring(0, fieldValue.length() - 1))) {
                paramValueList.add(fieldLangKey);
            }
        } else {
            if (fieldLangValue.equals(fieldValue)) {
                paramValueList.add(fieldLangKey);
            }
        }
    }
    if (paramValueList.size() == 0) {
        // 设置一个错误的key值。
        paramValueList.add("~!@#$%_()*&^");
    }
    cq.in(fieldName, paramValueList.toArray());
    cq.add();
}

17 View Complete Implementation : CgFormIndexController.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * easyui AJAX请求数据
 *
 * @param request
 * @param response
 * @param dataGrid
 * @param user
 */
@RequestMapping(params = "datagrid")
public void datagrid(CgFormIndexEnreplacedy cgFormIndex, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(CgFormIndexEnreplacedy.clreplaced, dataGrid);
    // 查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, cgFormIndex, request.getParameterMap());
    try {
    // 自定义追加查询条件
    } catch (Exception e) {
        throw new BusinessException(e.getMessage());
    }
    cq.add();
    this.cgFormIndexService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
}

17 View Complete Implementation : TSFillRuleController.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * easyui AJAX请求数据
 *
 * @param request
 * @param response
 * @param dataGrid
 * @param user
 */
@RequestMapping(params = "datagrid")
public void datagrid(TSFillRuleEnreplacedy tSFillRule, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(TSFillRuleEnreplacedy.clreplaced, dataGrid);
    // 查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, tSFillRule, request.getParameterMap());
    try {
    // 自定义追加查询条件
    } catch (Exception e) {
        throw new BusinessException(e.getMessage());
    }
    cq.add();
    this.tSFillRuleService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
}

17 View Complete Implementation : CgformFtlServiceImpl.java
Copyright Apache License 2.0
Author : zhangdaiscott
@Override
public String getUserFormFtl(String id) {
    CriteriaQuery cq = new CriteriaQuery(CgformFtlEnreplacedy.clreplaced);
    cq.eq("cgformId", id);
    cq.eq("ftlStatus", "1");
    cq.add();
    List<CgformFtlEnreplacedy> list = this.getListByCriteriaQuery(cq, false);
    if (list.size() == 1) {
        return list.get(0).getFtlContent();
    }
    return null;
}

17 View Complete Implementation : NoticeController.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * easyui AJAX请求数据
 *
 * @param request
 * @param response
 * @param dataGrid
 * @param user
 */
@RequestMapping(params = "datagrid2")
public void datagrid2(TSNotice tSNotice, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(TSNotice.clreplaced, dataGrid);
    // 查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, tSNotice, request.getParameterMap());
    try {
    // 自定义追加查询条件
    } catch (Exception e) {
        throw new BusinessException(e.getMessage());
    }
    cq.add();
    this.noticeService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
}

17 View Complete Implementation : TSSmsController.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * easyui AJAX请求数据
 *
 * @param request
 * @param response
 * @param dataGrid
 * @param user
 */
@RequestMapping(params = "datagrid")
public void datagrid(TSSmsEnreplacedy tSSms, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(TSSmsEnreplacedy.clreplaced, dataGrid);
    // 查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, tSSms, request.getParameterMap());
    try {
    // 自定义追加查询条件
    } catch (Exception e) {
        throw new BusinessException(e.getMessage());
    }
    cq.add();
    this.tSSmsService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
}

17 View Complete Implementation : DemoController.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * 下拉联动跳转
 */
@RequestMapping(params = "select")
public ModelAndView select(HttpServletRequest request) {
    // 新闻
    CriteriaQuery cq2 = new CriteriaQuery(TSFunction.clreplaced);
    cq2.eq("functionLevel", Globals.Function_Leave_ONE);
    cq2.add();
    List<TSFunction> funList = systemService.getListByCriteriaQuery(cq2, true);
    request.setAttribute("funList", funList);
    return new ModelAndView("jeecg/demo/base/AJAX/select");
}

17 View Complete Implementation : IconController.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * easyuiAJAX请求数据
 *
 * @param request
 * @param response
 * @param dataGrid
 */
@RequestMapping(params = "datagrid")
public void datagrid(TSIcon icon, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(TSIcon.clreplaced, dataGrid);
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, icon);
    cq.add();
    this.systemService.getDataGridReturn(cq, true);
    // 先把数据库的byte存成图片到临时目录,再给每个TsIcon设置目录路径
    IconImageUtil.convertDataGrid(dataGrid, request);
    TagUtil.datagrid(response, dataGrid);
}

17 View Complete Implementation : WeixinLong2shortController.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * easyui AJAX请求数据
 *
 * @param request
 * @param response
 * @param dataGrid
 * @param user
 */
@RequestMapping(params = "datagrid")
public void datagrid(WeixinLong2shortEnreplacedy weixinLong2short, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(WeixinLong2shortEnreplacedy.clreplaced, dataGrid);
    // 查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, weixinLong2short, request.getParameterMap());
    try {
    // 自定义追加查询条件
    } catch (Exception e) {
        throw new BusinessException(e.getMessage());
    }
    cq.add();
    this.weixinLong2shortService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
}

16 View Complete Implementation : JformOrderMainController.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * easyui AJAX请求数据
 *
 * @param request
 * @param response
 * @param dataGrid
 * @param user
 */
@RequestMapping(params = "datagrid")
public void datagrid(JformOrderMainEnreplacedy jformOrderMain, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(JformOrderMainEnreplacedy.clreplaced, dataGrid);
    // 查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, jformOrderMain);
    try {
    // 自定义追加查询条件
    } catch (Exception e) {
        throw new BusinessException(e.getMessage());
    }
    cq.add();
    this.jformOrderMainService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
}

16 View Complete Implementation : HqlGenerateUtil.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * 自动生成查询条件HQL(扩展区间查询功能)
 *
 * @param cq
 * @param searchObj
 * @param parameterMap
 *            request参数集合,封装了所有查询信息
 */
public static void installHql(CriteriaQuery cq, Object searchObj, Map<String, String[]> parameterMap) {
    installHqlJoinAlias(cq, searchObj, getRuleMap(), parameterMap, "");
    try {
        String json = null;
        if (StringUtil.isNotEmpty(cq.getDataGrid().getSqlbuilder())) {
            json = cq.getDataGrid().getSqlbuilder();
        } else if (parameterMap != null && StringUtil.isNotEmpty(parameterMap.get("sqlbuilder"))) {
            json = parameterMap.get("sqlbuilder")[0];
        }
        if (StringUtil.isNotEmpty(json)) {
            List<QueryCondition> list = JSONHelper.toList(json, QueryCondition.clreplaced);
            String sql = getSql(list, "", searchObj.getClreplaced());
            LogUtil.debug("DEBUG sqlbuilder:" + sql);
            // TODO 此用法在多表关联查询,两个表存在相同字段的时候,会存在问题(hibernate维护的实体关系)
            cq.add(Restrictions.sqlRestriction(sql));
        }
    } catch (Exception e) {
        e.printStackTrace();
    }
    cq.add();
}

16 View Complete Implementation : InterroleController.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * easyuiAJAX请求数据
 *
 * @param request
 * @param response
 * @param dataGrid
 */
@RequestMapping(params = "roleGrid")
public void roleGrid(InterroleEnreplacedy role, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(InterroleEnreplacedy.clreplaced, dataGrid);
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, role);
    // 自己写的工具类 , 与HqlGenerateUtil 一样,改变实体类
    // InterfaceHqlUtil.installHql(cq, role);
    cq.add();
    this.systemService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
}

16 View Complete Implementation : DemoController.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * demo页面跳转
 */
@RequestMapping(params = "demoIframe")
public ModelAndView demoIframe(HttpServletRequest request) {
    CriteriaQuery cq = new CriteriaQuery(TSDemo.clreplaced);
    cq.isNull("TSDemo.id");
    cq.add();
    List<TSDemo> demoList = systemService.getListByCriteriaQuery(cq, false);
    request.setAttribute("demoList", demoList);
    return new ModelAndView("jeecg/demo/base/demoIframe");
}

16 View Complete Implementation : UserController.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * easyuiAJAX用户列表请求数据
 * @param request
 * @param response
 * @param dataGrid
 */
@RequestMapping(params = "datagrid")
public void datagrid(TSUser user, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(TSUser.clreplaced, dataGrid);
    // 查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, user);
    Short[] userstate = new Short[] { Globals.User_Normal, Globals.User_ADMIN, Globals.User_Forbidden };
    cq.in("status", userstate);
    cq.add();
    this.systemService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
}

16 View Complete Implementation : WeixinCmsSiteController.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * easyui AJAX请求数据
 *
 * @param request
 * @param response
 * @param dataGrid
 * @param user
 */
@RequestMapping(params = "datagrid")
public void datagrid(WeixinCmsSiteEnreplacedy weixinCmsSite, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(WeixinCmsSiteEnreplacedy.clreplaced, dataGrid);
    // 查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, weixinCmsSite, request.getParameterMap());
    cq.eq(ACCOUNTID, ResourceUtil.getWeiXinAccountId());
    try {
    // 自定义追加查询条件
    } catch (Exception e) {
        throw new BusinessException(e.getMessage());
    }
    cq.add();
    this.weixinCmsSiteService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
}

15 View Complete Implementation : JformOrderMain2Controller.java
Copyright Apache License 2.0
Author : zhangdaiscott
/**
 * easyui AJAX请求数据
 *
 * @param request
 * @param response
 * @param dataGrid
 * @param user
 */
@RequestMapping(params = "datagrid")
public void datagrid(JformOrderMain2Enreplacedy jformOrderMain2, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(JformOrderMain2Enreplacedy.clreplaced, dataGrid);
    // 查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, jformOrderMain2);
    try {
        // 自定义追加查询条件
        String sql = SuperQueryUtil.getComplxSuperQuerySQL(request);
        if (oConvertUtils.isNotEmpty(sql)) {
            cq.add(Restrictions.sqlRestriction(" id in (" + sql + ")"));
        }
    } catch (Exception e) {
        throw new BusinessException(e.getMessage());
    }
    cq.add();
    this.jformOrderMain2Service.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
}