Examples of CgFormHeadEntity


Examples of org.jeecgframework.web.cgform.entity.config.CgFormHeadEntity

 
  public void sortSubTableStr(CgFormHeadEntity entity) {
    if (entity == null)
      return;
    CgFormHeadEntity main = null;
    List<CgFormFieldEntity> columns = entity.getColumns();
    for (CgFormFieldEntity fieldE : columns) {
      String mainT = fieldE.getMainTable();
      String mainF = fieldE.getMainField();
      if (!StringUtil.isEmpty(mainT) && !StringUtil.isEmpty(mainF)) {
        CgFormHeadEntity mainE = this.getCgFormHeadByTableName(mainT);
        if (mainE == null) {
          continue;
        }
        main = mainE;
      }
    }
    if(main==null){
      return;
    }
    String subTableStr = main.getSubTableStr();
    if(StringUtils.isNotEmpty(subTableStr)){
      String [] subTables = subTableStr.split(",");
      if (subTables.length <= 1)
        return;
      List<CgFormHeadEntity> subList = new ArrayList<CgFormHeadEntity>();
      for(String subTable : subTables){
        CgFormHeadEntity sub = this.getCgFormHeadByTableName(subTable);
        subList.add(sub);
      }
      Collections.sort(subList, new Comparator<CgFormHeadEntity>() {
        public int compare(CgFormHeadEntity arg0, CgFormHeadEntity arg1) {
          Integer tabOrder0 = arg0.getTabOrder();
          if (tabOrder0 == null) {
            tabOrder0 = 0;
          }
          Integer tabOrder1 = arg1.getTabOrder();
          if (tabOrder1 == null) {
            tabOrder1 = 0;
          }
          return tabOrder0.compareTo(tabOrder1);
        }
      });
      subTableStr = "";
      for (CgFormHeadEntity sub : subList) {
        subTableStr += sub.getTableName() + ",";
      }
      subTableStr = subTableStr.substring(0, subTableStr.length() - 1);
      main.setSubTableStr(subTableStr);
      this.updateTable(main, "sign");
    }
View Full Code Here

Examples of org.jeecgframework.web.cgform.entity.config.CgFormHeadEntity

   * @param tableName 表名
   * @param data 添加的数据map
   */
 
  public int insertTable(String tableName, Map<String, Object> data) {
    CgFormHeadEntity cgFormHeadEntity = cgFormFieldService.getCgFormHeadByTableName(tableName);
    fillInsertSysVar(data);
    keyAdapter(cgFormHeadEntity,data);
    dataAdapter(tableName,data);
    String comma = "";
    StringBuffer insertKey = new StringBuffer();
    StringBuffer insertValue = new StringBuffer();
    for (Entry<String, Object> entry : data.entrySet()) {
      // 判断key是否为表配置的属性
      if(isContainsFieled(tableName,entry.getKey())){
        //插入SQL语法,兼容多数据库,去掉单引号
        insertKey.append(comma  + entry.getKey());
        if(entry.getValue()!=null&&entry.getValue().toString().length()>0){
          insertValue.append(comma + ":"+entry.getKey());
        }else{
          insertValue.append(comma + "null");
        }
        comma = ", ";
     
      }
    }
    String sql = "INSERT INTO " + tableName + " (" + insertKey + ") VALUES (" + insertValue + ")";
    Object key = this.executeSqlReturnKey(sql,data);
    if(key!=null&&key instanceof Long){
      data.put("id", key);
    }
    if(cgFormHeadEntity!=null){
      executeSqlExtend(cgFormHeadEntity.getId(),"add",data);
    }
    return 1;
  }
View Full Code Here

Examples of org.jeecgframework.web.cgform.entity.config.CgFormHeadEntity

   */
  @Ehcache
  public Map<String, Object> getFtlFormConfig(String tableName, String version) {
    Map<String, Object> data = new HashMap<String, Object>();
    Map<String, Object> field = new HashMap<String, Object>();
    CgFormHeadEntity head = this.getCgFormHeadByTableName(tableName,
        version);
    data.put("head", head);
    if (head.getJformType() == CgAutoListConstant.JFORM_TYPE_MAIN_TALBE) {
      CgSubTableVO subtableVo = new CgSubTableVO();
      String subTableStr = head.getSubTableStr();
      if (StringUtils.isNotEmpty(subTableStr)) {
        String[] subTables = subTableStr.split(",");
        List<Map<String, Object>> subTalbeFieldList = new ArrayList<Map<String, Object>>();
        List<Map<String, Object>> subTalbeHiddenFieldList = new ArrayList<Map<String, Object>>();
        for (String subTable : subTables) {
          subTalbeFieldList = this
              .getCgFormFieldByTableName(subTable);
          subTalbeHiddenFieldList = this
              .getCgFormHiddenFieldByTableName(subTable);
          CgFormHeadEntity subhead = this
              .getCgFormHeadByTableName(subTable);
          subtableVo = new CgSubTableVO();
          subtableVo.setHead(subhead);
          subtableVo.setFieldList(subTalbeFieldList);
          subtableVo.setHiddenFieldList(subTalbeHiddenFieldList);
View Full Code Here

Examples of org.jeecgframework.web.cgform.entity.config.CgFormHeadEntity

    if(id instanceof java.lang.String){
      sqlBuffer.append(" where id='").append(id).append("'");
    }else{
      sqlBuffer.append(" where id=").append(id);
    }
    CgFormHeadEntity cgFormHeadEntity = cgFormFieldService.getCgFormHeadByTableName(tableName);
    int num = this.executeSql(sqlBuffer.toString(), data);
   
    if(cgFormHeadEntity!=null){
      executeSqlExtend(cgFormHeadEntity.getId(),"update",data);
    }
    return num;
  }
View Full Code Here

Examples of org.jeecgframework.web.cgform.entity.config.CgFormHeadEntity

   * @param tableName 表单名称
   * @return
   */
  public Object getPkValue(String tableName) {
    Object pkValue = null;
    CgFormHeadEntity  cghead = cgFormFieldService.getCgFormHeadByTableName(tableName);
    String dbType = DBTypeUtil.getDBType();
    String pkType = cghead.getJformPkType();
    String pkSequence = cghead.getJformPkSequence();
    if(StringUtil.isNotEmpty(pkType)&&"UUID".equalsIgnoreCase(pkType)){
      pkValue = UUIDGenerator.generate();
    }else if(StringUtil.isNotEmpty(pkType)&&"NATIVE".equalsIgnoreCase(pkType)){
      if(StringUtil.isNotEmpty(dbType)&&"oracle".equalsIgnoreCase(dbType)){
        OracleSequenceMaxValueIncrementer incr = new OracleSequenceMaxValueIncrementer(dataSource, "HIBERNATE_SEQUENCE")
View Full Code Here

Examples of org.jeecgframework.web.cgform.entity.config.CgFormHeadEntity

   
    private Object getObject(String name) throws IOException {
      PathMatchingResourcePatternResolver patternResolver = new PathMatchingResourcePatternResolver();
      if(name.lastIndexOf(".ftl")==-1){//判断是否为include的模板
        //如果是主表直接走一对多模板
        CgFormHeadEntity head = cgFormFieldService.getCgFormHeadByTableName(name);
        if(head==null)return null;
      if(head.getJformType()==CgAutoListConstant.JFORM_TYPE_MAIN_TALBE){
        Resource[] resources = patternResolver.getResources(TEMPLET_ONE_MANY);
          InputStreamReader inputStreamReader =null;
          if (resources != null && resources.length > 0) { 
             inputStreamReader = new InputStreamReader(resources[0].getInputStream(),"UTF-8");
          }
View Full Code Here

Examples of org.jeecgframework.web.cgform.entity.config.CgFormHeadEntity

        ls_id=ids.substring(0, ids.indexOf(","));
      }
      else{
        ls_id = ids;
      }
      CgFormHeadEntity cgFormHeadEntity = cgFormVersionDao.getCgFormById(ls_id);
      //update by duanqilu 2013-12-05 增加多表单导出功能
      //MigrateForm.createFile(request,cgFormHeadEntity.getTableName())
      String ls_filename = cgFormHeadEntity.getTableName();// 创建文件
      String destFileDir = ResourceUtil.getSystempPath()+"/"+ls_filename;
      MigrateForm.generateXmlDataOutFlieContent(dbTables, destFileDir);
      ls_filename = MigrateForm.zip(null, "", destFileDir); // 压缩文件
      // 文件下载
      File file = new File(ls_filename);
View Full Code Here

Examples of org.jeecgframework.web.cgform.entity.config.CgFormHeadEntity

  @Ehcache
  public Map<String, Object> queryConfigs(String tableName,String jversion) {
    //step.1 要返回的配置数据
    Map<String, Object> configs = new HashMap<String,Object>();
    //step.2 获取动态表配置
    CgFormHeadEntity tableEntity = null;
    try{
      tableEntity = tablePropertyService.findByProperty(CgFormHeadEntity.class, "tableName", tableName).get(0);
      loadConfigs(configs,tableEntity);
    }catch (Exception e) {
      e.printStackTrace();
View Full Code Here

Examples of org.jeecgframework.web.cgform.entity.config.CgFormHeadEntity

  @SuppressWarnings("unchecked")
 
  public boolean delete(String table, Object id) {
    try{
      CgFormHeadEntity head = cgFormFieldService.getCgFormHeadByTableName(table);
      Map<String,Object> data  = dataBaseService.findOneForJdbc(table, id.toString());
      if(data!=null){
        //打印测试
          Iterator it=data.entrySet().iterator();
          while(it.hasNext()){
            Map.Entry entry=(Map.Entry)it.next();
              Object ok=entry.getKey();
              Object ov=entry.getValue()==null?"":entry.getValue();
              org.jeecgframework.core.util.LogUtil.info("name:"+ok.toString()+";value:"+ov.toString());
          }
        data = CommUtils.mapConvert(data);
        dataBaseService.executeSqlExtend(head.getId(), "delete", data);
      }
      //step.1 删除表
      StringBuilder deleteSql = new StringBuilder();
      deleteSql.append("DELETE FROM "+table+" WHERE id = ?");
      if(!QueryParamUtil.sql_inj(id.toString())){
        commonService.executeSql(deleteSql.toString(), id);
      }
      //step.2 判断是否有明细表,进行连带删除
      String[] subTables = head.getSubTableStr()==null?new String[0]:head.getSubTableStr().split(",");
      for(String subTable:subTables){
        Map<String, CgFormFieldEntity>  fields = cgFormFieldService.getAllCgFormFieldByTableName(subTable);
        String subFkField = null;
        Iterator it = fields.keySet().iterator();
        for(;it.hasNext();){
View Full Code Here

Examples of org.jeecgframework.web.cgform.entity.config.CgFormHeadEntity

      //如果是主表,则进入一对多模型
      List<CgFormHeadEntity> subTableList = new ArrayList<CgFormHeadEntity>();
      if(StringUtil.isNotEmpty(cgFormHead.getSubTableStr())){
        String[] subTables = cgFormHead.getSubTableStr().split(",");
        for(String subTable :subTables){
          CgFormHeadEntity subHead = cgFormFieldService.getCgFormHeadByTableName(subTable);
          subTableList.add(subHead);
          entityNameMap.put(subHead.getTableName(), JeecgReadTable.formatFieldCapital(subHead.getTableName()));
        }
      }
      request.setAttribute("subTableList", subTableList);
      returnModelAndView = "jeecg/cgform/generate/one2many";
    }
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.