Package org.jeecgframework.core.common.hibernate.qbc

Examples of org.jeecgframework.core.common.hibernate.qbc.CriteriaQuery.eq()

284
285
286
287
288
289
290
291
292
293
294
    String subclassname = oConvertUtils.getString(request.getParameter("subclassname"));// 子类类名
    String type = oConvertUtils.getString(request.getParameter("typename"));
    String code = oConvertUtils.getString(request.getParameter("typecode"));
    String filekey = oConvertUtils.getString(request.getParameter("filekey"));
    CriteriaQuery cq = new CriteriaQuery(MyClassLoader.getClassByScn(subclassname), dataGrid);
    cq.eq("businessKey", businessKey);
    if (StringUtil.isNotEmpty(type)) {
      cq.createAlias("TBInfotype", "TBInfotype");
      cq.eq("TBInfotype.typename", type);
    }
    if (StringUtil.isNotEmpty(filekey)) {
View Full Code Here
287
288
289
290
291
292
293
294
295
296
297
    String filekey = oConvertUtils.getString(request.getParameter("filekey"));
    CriteriaQuery cq = new CriteriaQuery(MyClassLoader.getClassByScn(subclassname), dataGrid);
    cq.eq("businessKey", businessKey);
    if (StringUtil.isNotEmpty(type)) {
      cq.createAlias("TBInfotype", "TBInfotype");
      cq.eq("TBInfotype.typename", type);
    }
    if (StringUtil.isNotEmpty(filekey)) {
      cq.eq("id", filekey);
    }
    if (StringUtil.isNotEmpty(code)) {
View Full Code Here
290
291
292
293
294
295
296
297
298
299
300
    if (StringUtil.isNotEmpty(type)) {
      cq.createAlias("TBInfotype", "TBInfotype");
      cq.eq("TBInfotype.typename", type);
    }
    if (StringUtil.isNotEmpty(filekey)) {
      cq.eq("id", filekey);
    }
    if (StringUtil.isNotEmpty(code)) {
      cq.createAlias("TBInfotype", "TBInfotype");
      cq.eq("TBInfotype.typecode", code);
    }
View Full Code Here
294
295
296
297
298
299
300
301
302
303
304
    if (StringUtil.isNotEmpty(filekey)) {
      cq.eq("id", filekey);
    }
    if (StringUtil.isNotEmpty(code)) {
      cq.createAlias("TBInfotype", "TBInfotype");
      cq.eq("TBInfotype.typecode", code);
    }
    cq.add();
    this.systemService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
  }
View Full Code Here
335
336
337
338
339
340
341
342
343
344
345
      HttpServletRequest req) {
   
    List<CgFormFieldEntity> columnList = new ArrayList<CgFormFieldEntity>();
    if (StringUtil.isNotEmpty(cgFormHead.getId())) {
      CriteriaQuery cq = new CriteriaQuery(CgFormFieldEntity.class);
      cq.eq("table.id", cgFormHead.getId());
      cq.add();
      columnList = cgFormFieldService
          .getListByCriteriaQuery(cq, false);
      //对字段列按顺序排序
      Collections.sort(columnList,new FieldNumComparator());
View Full Code Here
95
96
97
98
99
100
101
102
103
104
105
    }
    if(null != entity.getCode()) {
      HqlGenerateUtil.installHql(cq, entity);
    }
    if (treegrid.getId() != null) {
      cq.eq("parent.id", treegrid.getId());
    } else {
      cq.isNull("parent");
    }
    cq.add();
    List<TreeGrid> list = jeecgMatterBomService.getListByCriteriaQuery(cq, false);
View Full Code Here
380
381
382
383
384
385
386
387
388
389
390
      HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(TSFunction.class, dataGrid);
    String id = oConvertUtils.getString(request.getParameter("id"));
    cq.isNull("TSFunction");
    if (id != null) {
      cq.eq("TSFunction.id", id);
    }
    cq.add();
    List<TSFunction> functionList = systemService.getListByCriteriaQuery(
        cq, false);
    List<TreeGrid> treeGrids = new ArrayList<TreeGrid>();
View Full Code Here
402
403
404
405
406
407
408
409
410
411
412
    CriteriaQuery cq = new CriteriaQuery(TSFunction.class);
    if(null != request.getParameter("selfId")){
      cq.notEq("id", request.getParameter("selfId"));
    }
    if (comboTree.getId() != null) {
      cq.eq("TSFunction.id", comboTree.getId());
    }
    if (comboTree.getId() == null) {
      cq.isNull("TSFunction");
    }
    cq.add();
View Full Code Here
53
54
55
56
57
58
59
60
61
62
63
  @RequestMapping(params = "territoryGrid")
  @ResponseBody
  public List<TreeGrid> territoryGrid(HttpServletRequest request, TreeGrid treegrid) {
    CriteriaQuery cq = new CriteriaQuery(TSTerritory.class);
      if (treegrid.getId() != null) {
        cq.eq("TSTerritory.id", treegrid.getId());
      }
      if (treegrid.getId() == null) {
        cq.eq("TSTerritory.id","1");//这个是全国最高级
      }
   
View Full Code Here
56
57
58
59
60
61
62
63
64
65
66
    CriteriaQuery cq = new CriteriaQuery(TSTerritory.class);
      if (treegrid.getId() != null) {
        cq.eq("TSTerritory.id", treegrid.getId());
      }
      if (treegrid.getId() == null) {
        cq.eq("TSTerritory.id","1");//这个是全国最高级
      }
   
    cq.addOrder("territorySort", SortDirection.asc);
    cq.add();
    List<TSTerritory> territoryList = systemService.getListByCriteriaQuery(cq, false);
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.