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
19
View Complete Implementation : TSSmsTemplateController.java
Copyright Apache License 2.0
Author : zhangdaiscott
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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);
}