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

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

101
102
103
104
105
106
107
108
109
110
111
  @RequestMapping(params = "setPTerritory")
  @ResponseBody
  public List<ComboTree> setPTerritory(HttpServletRequest request, ComboTree comboTree) {
    CriteriaQuery cq = new CriteriaQuery(TSTerritory.class);
    if (comboTree.getId() != null) {
      cq.eq("TSTerritory.id", comboTree.getId());
    }
    if (comboTree.getId() == null) {
      cq.isNull("TSTerritory");
    }
    cq.add();
View Full Code Here
507
508
509
510
511
512
513
514
515
516
517
  public void datagridUser(HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    String departid = request.getParameter("departid");
    String roleid = request.getParameter("roleid");
    CriteriaQuery cq = new CriteriaQuery(TSUser.class, dataGrid);
    if (departid.length() > 0) {
      cq.eq("TDepart.departid", oConvertUtils.getInt(departid, 0));
      cq.add();
    }
    String userid = "";
    if (roleid.length() > 0) {
      List<TSRoleUser> roleUsers = systemService.findByProperty(TSRoleUser.class, "TRole.roleid", oConvertUtils.getInt(roleid, 0));
View Full Code Here
123
124
125
126
127
128
129
130
131
132
133
    CriteriaQuery cq = new CriteriaQuery(TSOperation.class, dataGrid);
    // ----------------------------------------------------------------
    // ----------------------------------------------------------------
    String functionId = oConvertUtils.getString(request
        .getParameter("functionId"));
    cq.eq("TSFunction.id", functionId);
    cq.add();
    // ----------------------------------------------------------------
    // ----------------------------------------------------------------
    this.systemService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
View Full Code Here
345
346
347
348
349
350
351
352
353
354
355
    String selfId = request.getParameter("selfId");
    if(selfId != null){
      cq.notEq("id", selfId);
    }
    if (treegrid.getId() != null) {
      cq.eq("TSFunction.id", treegrid.getId());
    }
    if (treegrid.getId() == null) {
      cq.isNull("TSFunction");
    }
    cq.addOrder("functionOrder", SortDirection.asc);
View Full Code Here
148
149
150
151
152
153
154
155
156
157
158
  @RequestMapping(params = "typeGrid")
  public void typeGrid(HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    String typegroupid = request.getParameter("typegroupid");
    String typename = request.getParameter("typename");
    CriteriaQuery cq = new CriteriaQuery(TSType.class, dataGrid);
    cq.eq("TSTypegroup.id", typegroupid);
    cq.like("typename", typename);
    cq.add();
    this.systemService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
  }
View Full Code Here
191
192
193
194
195
196
197
198
199
200
201
  public List<TreeGrid> typeGridTree(HttpServletRequest request, TreeGrid treegrid) {
    CriteriaQuery cq;
    List<TreeGrid> treeGrids = new ArrayList<TreeGrid>();
    if (treegrid.getId() != null) {
      cq = new CriteriaQuery(TSType.class);
      cq.eq("TSTypegroup.id", treegrid.getId().substring(1));
      cq.add();
      List<TSType> typeList = systemService.getListByCriteriaQuery(cq, false);
      for (TSType obj : typeList) {
        TreeGrid treeNode = new TreeGrid();
        treeNode.setId("T"+obj.getId());
View Full Code Here
511
512
513
514
515
516
517
518
519
520
521
  @RequestMapping(params = "setPFunction")
  @ResponseBody
  public List<ComboTree> setPFunction(HttpServletRequest request, ComboTree comboTree) {
    CriteriaQuery cq = new CriteriaQuery(TSDepart.class);
    if (StringUtil.isNotEmpty(comboTree.getId())) {
      cq.eq("TSPDepart.id", comboTree.getId());
    }
    // ----------------------------------------------------------------
    // ----------------------------------------------------------------
    if (StringUtil.isEmpty(comboTree.getId())) {
      cq.isNull("TSPDepart.id");
View Full Code Here
625
626
627
628
629
630
631
632
633
634
635
  @RequestMapping(params = "setAuthority")
  @ResponseBody
  public List<ComboTree> setAuthority(TSRole role, HttpServletRequest request, ComboTree comboTree) {
    CriteriaQuery cq = new CriteriaQuery(TSFunction.class);
    if (comboTree.getId() != null) {
      cq.eq("TFunction.functionid", oConvertUtils.getInt(comboTree.getId(), 0));
    }
    if (comboTree.getId() == null) {
      cq.isNull("TFunction");
    }
    cq.add();
View Full Code Here
721
722
723
724
725
726
727
728
729
730
731
  @ResponseBody
  public List<TreeGrid> setOperate(HttpServletRequest request, TreeGrid treegrid) {
    String roleid = request.getParameter("roleid");
    CriteriaQuery cq = new CriteriaQuery(TSFunction.class);
    if (treegrid.getId() != null) {
      cq.eq("TFunction.functionid", oConvertUtils.getInt(treegrid.getId(), 0));
    }
    if (treegrid.getId() == null) {
      cq.isNull("TFunction");
    }
    cq.add();
View Full Code Here
889
890
891
892
893
894
895
896
897
898
899
  @RequestMapping(params = "documentList")
  public void documentList(HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(TSDocument.class, dataGrid);
    String typecode = oConvertUtils.getString(request.getParameter("typecode"));
    cq.createAlias("TSType", "TSType");
    cq.eq("TSType.typecode", typecode);
    cq.add();
    this.systemService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
  }
 
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.