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

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

283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
    String businessKey = oConvertUtils.getString(request.getParameter("businessKey"));
    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)) {
      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
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
   * @param user
   */

  @RequestMapping(params = "datagrid")
  public void datagrid(CgreportConfigHeadEntity cgreportConfigHead,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(CgreportConfigHeadEntity.class, 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);
  }
View Full Code Here
86
87
88
89
90
91
92
93
94
95
96
  @RequestMapping(params = "datagrid")
  public void datagrid(CgFormHeadEntity cgFormHead,
      HttpServletRequest request, HttpServletResponse response,
      DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(CgFormHeadEntity.class,
        dataGrid);
    // 查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq,
        cgFormHead);
    this.cgFormFieldService.getDataGridReturn(cq, true);
View Full Code Here
334
335
336
337
338
339
340
341
342
343
344
345
346
  public List<CgFormFieldEntity> getColumnList(CgFormHeadEntity cgFormHead,String type,
      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());
    }else{
View Full Code Here
74
75
76
77
78
79
80
81
82
83
84
   * @param user
   */

  @RequestMapping(params = "datagrid")
  public void datagrid(JeecgNoteEntity jeecgNote,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(JeecgNoteEntity.class, dataGrid);
    //查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, jeecgNote);
    this.jeecgNoteService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
  }
View Full Code Here
231
232
233
234
235
236
237
238
239
   * @param user
   */

  @RequestMapping(params = "datagrid")
  public void datagrid(HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(JpPersonEntity.class, dataGrid);
    this.jpPersonService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
  }
View Full Code Here
142
143
144
145
146
147
148
149
150
151
152
  @SuppressWarnings("unchecked")
  @RequestMapping(params = "datagrid")
  public void datagrid(CgformFtlEntity cgformFtl, HttpServletRequest request,
      HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(CgformFtlEntity.class, dataGrid);
    // 查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq,
        cgformFtl, request.getParameterMap());
    this.cgformFtlService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
View Full Code Here
177
178
179
180
181
182
183
184
185
186
187
   * @param user
   */

  @RequestMapping(params = "datagrid")
  public void datagrid(JeecgDemo jeecgDemo,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(JeecgDemo.class, dataGrid);
    //查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, jeecgDemo,request.getParameterMap());
    this.jeecgDemoService.getDataGridReturn(cq, true);
    String total_salary = String.valueOf(jeecgDemoService.findOneForJdbc("select sum(salary) as ssum from jeecg_demo").get("ssum"));
    /*
 
View Full Code Here
196
197
198
199
200
201
202
203
204
   * 权限列表
   */
  @RequestMapping(params = "combox")
  @ResponseBody
  public List<JeecgDemo> combox(HttpServletRequest request, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(JeecgDemo.class);
    List<JeecgDemo> ls = this.jeecgDemoService.getListByCriteriaQuery(cq, false);
    return ls;
  }
View Full Code Here
75
76
77
78
79
80
81
82
83
   * @param user
   */

  @RequestMapping(params = "datagrid")
  public void datagrid(HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(JeecgOrderMainEntity.class, dataGrid);
    this.jeecgOrderMainService.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.