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

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


    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


   * @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

  @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

  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

   * @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

   * @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

  @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

   * @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

   * 权限列表
   */
  @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

   * @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

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.