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

Examples of org.jeecgframework.core.common.hibernate.qbc.CriteriaQuery

51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
   * 地域列表
   */
  @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");//这个是全国最高级
      }
   
    cq.addOrder("territorySort", SortDirection.asc);
    cq.add();
    List<TSTerritory> territoryList = systemService.getListByCriteriaQuery(cq, false);
    List<TreeGrid> treeGrids = new ArrayList<TreeGrid>();
    TreeGridModel treeGridModel = new TreeGridModel();
    treeGridModel.setIcon("");
    treeGridModel.setTextField("territoryName");
View Full Code Here
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
   * 地域父级下拉菜单
   */
  @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();
    List<TSTerritory> territoryList = systemService.getListByCriteriaQuery(cq, false);
    List<ComboTree> comboTrees = new ArrayList<ComboTree>();
    ComboTreeModel comboTreeModel = new ComboTreeModel("id", "territoryName", "TSTerritorys");
    comboTrees = systemService.ComboTree(territoryList, comboTreeModel, null);
    return comboTrees;
View Full Code Here
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
   * @param response
   * @param dataGrid
   */
  @RequestMapping(params = "datagrid")
  public void datagrid(TSUser user,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(TSUser.class, 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, true);
    TagUtil.datagrid(response, dataGrid);
  }
View Full Code Here
422
423
424
425
426
427
428
429
430
   * @param response
   * @param dataGrid
   */
  @RequestMapping(params = "datagridRole")
  public void datagridRole(HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(TSRole.class, dataGrid);
    this.systemService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
  }
View Full Code Here
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
   */
  @RequestMapping(params = "datagridUser")
  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));
      if (roleUsers.size() > 0) {
        for (TSRoleUser tRoleUser : roleUsers) {
          userid += tRoleUser.getTSUser().getId() + ",";
        }
      }
      cq.in("userid", oConvertUtils.getInts(userid.split(",")));
      cq.add();
    }
    this.systemService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
  }
View Full Code Here
562
563
564
565
566
567
568
569
570
   * @param response
   * @param dataGrid
   */
  @RequestMapping(params = "datagridDepart")
  public void datagridDepart(HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(TSDepart.class, dataGrid);
    systemService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
  }
View Full Code Here
578
579
580
581
582
583
584
585
586
587
588
589
590
591
   */
  @RequestMapping(params = "test")
  public void test(HttpServletRequest request, HttpServletResponse response) {
    String jString = request.getParameter("_dt_json");
    DataTables dataTables = new DataTables(request);
    CriteriaQuery cq = new CriteriaQuery(TSUser.class, dataTables);
    String username = request.getParameter("userName");
    if (username != null) {
      cq.like("userName", username);
      cq.add();
    }
    DataTableReturn dataTableReturn = systemService.getDataTableReturn(cq, true);
    TagUtil.datatable(response, dataTableReturn, "id,userName,mobilePhone,TSDepart_departname");
  }
View Full Code Here
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
   * @param response
   * @param dataGrid
   */
  @RequestMapping(params = "testSearch")
  public void testSearch(TSUser user, HttpServletRequest request,HttpServletResponse response,DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(TSUser.class, dataGrid);
    if(user.getUserName()!=null){
      cq.like("userName", user.getUserName());
    }
    if(user.getRealName()!=null){
      cq.like("realName", user.getRealName());
    }
    cq.add();
    this.systemService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
  }
View Full Code Here
101
102
103
104
105
106
107
108
109
   */

  @RequestMapping(params = "datagrid")
  public void datagrid(HttpServletRequest request,
      HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(TSFunction.class, dataGrid);
    this.systemService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
  }
View Full Code Here
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
   */

  @RequestMapping(params = "opdategrid")
  public void opdategrid(HttpServletRequest request,
      HttpServletResponse response, DataGrid dataGrid) {
    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
TOP

Related Classes of org.jeecgframework.core.common.hibernate.qbc.CriteriaQuery

  • org.hibernate.criterion.Criterion
  • org.jeecgframework.web.cgform.controller.button.CgformButtonController
  • org.jeecgframework.web.cgform.controller.button.CgformButtonSqlController
  • org.jeecgframework.web.cgform.controller.cgformftl.CgformFtlController
  • org.jeecgframework.web.cgform.controller.config.CgFormHeadController
  • org.jeecgframework.web.cgform.controller.enhance.CgformEnhanceJsController
  • org.jeecgframework.web.cgreport.controller.core.CgreportConfigHeadController
  • org.jeecgframework.web.demo.controller.test.CourseController
  • org.jeecgframework.web.demo.controller.test.DemoController
  • org.jeecgframework.web.demo.controller.test.JeecgBlobDataController
    • Copyright © 2018 www.massapicom. 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.