List<CgFormFieldEntity> columnsList = new ArrayList<CgFormFieldEntity>();

        for (int k = 0; k < list.size(); k++) {

          Columnt columnt = list.get(k);

          String fieldName = columnt.getFieldDbName();

              .toLowerCase());

          if (StringUtil.isNotEmpty(columnt.getFiledComment()))

          else

          if("id".equalsIgnoreCase(fieldName)){

            String[] pkTypeArr = {"java.lang.Integer","java.lang.Long"};

            String idFiledType = columnt.getFieldType();

            if(Arrays.asList(pkTypeArr).contains(idFiledType)){

              //如果主键是数字类型,则设置为自增长

              cgFormHead.setJformPkType("NATIVE");

            }else{

              //否则设置为UUID

              cgFormHead.setJformPkType("UUID");

            }

          }

          if ("java.lang.Integer".equalsIgnoreCase(columnt.getFieldType())){

          }else if ("java.lang.Long".equalsIgnoreCase(columnt.getFieldType())) {

          } else if ("java.util.Date".equalsIgnoreCase(columnt.getFieldType())) {

          } else if ("java.lang.Double".equalsIgnoreCase(columnt.getFieldType())

              ||"java.lang.Float".equalsIgnoreCase(columnt.getFieldType())) {

          } else if ("java.math.BigDecimal".equalsIgnoreCase(columnt.getFieldType())) {

          } else if (columnt.getFieldType().contains("blob")) {

            columnt.setCharmaxLength(null);

          } else {

          }

          if (StringUtil.isNotEmpty(columnt.getCharmaxLength())) {

            if (Long.valueOf(columnt.getCharmaxLength()) >= 3000) {

              try{//有可能长度超出int的长度

              }catch(Exception e){}

            } else {

                  .getCharmaxLength()));

            }

          } else {

            if (StringUtil.isNotEmpty(columnt.getPrecision())) {

                  .getPrecision()));

            }

            //update-begin--Author:zhangdaihao  Date:20140212 for：[001]oracle下number类型，数据库表导出表单，默认长度为0同步失败

            else{

              }

            }

            //update-end--Author:zhangdaihao  Date:20140212 for：[001]oracle下number类型，数据库表导出表单，默认长度为0同步失败

            if (StringUtil.isNotEmpty(columnt.getScale()))

                  .getScale()));

          }

          columnsList.add(cgFormField);

        }

          .getListByCriteriaQuery(cq, false);

      //对字段列按顺序排序

      Collections.sort(columnList,new FieldNumComparator());

    }else{

      columnList.add(field);

    }

    return columnList;

  }

  private CgFormFieldDao cgFormFieldDao;

 

  public synchronized void updateTable(CgFormHeadEntity t, String sign) {

    boolean databaseFieldIsChange = false;

    for (int i = 0; i < t.getColumns().size(); i++) {

      column = t.getColumns().get(i);

        continue;

      }

      // 设置checkbox的值

      PublicUtil.judgeCheckboxValue(column,

          "isNull,isShow,isShowList,isQuery,isKey");

        databaseFieldIsChange = true;

        this.save(column);

      } else {

            column.getId());

        if (!databaseFieldIsChange && databaseFieldIsChange(c, column)) {

          databaseFieldIsChange = true;

        }

        try {

  public void saveTable(CgFormHeadEntity cgFormHead) {

    cgFormHead.setJformVersion("1");

    cgFormHead.setIsDbSynch("N");

    cgFormHead.setId((String) this.getSession().save(cgFormHead));

    for (int i = 0; i < cgFormHead.getColumns().size(); i++) {

      column = cgFormHead.getColumns().get(i);

      PublicUtil.judgeCheckboxValue(column,

          "isNull,isShow,isShowList,isQuery,isKey");

      this.save(column);

    }

  }

   */

 

  public void saveTable(CgFormHeadEntity cgFormHead, String a) {

    cgFormHead.setId((String) this.getSession().save(cgFormHead));

    for (int i = 0; i < cgFormHead.getColumns().size(); i++) {

      column = cgFormHead.getColumns().get(i);

      PublicUtil.judgeCheckboxValue(column,

          "isNull,isShow,isShowList,isQuery,isKey");

      this.save(column);

    }

  }

      Object key = it.next();

      //根据表单配置的字段名 获取 前台数据

      Object beforeV = data.get(key.toString().toLowerCase());

      //获取字段配置-字段类型

      //根据类型进行值的适配

      if("date".equalsIgnoreCase(type)){

        //日期->java.util.Date

        Object newV = null;

        try {

          if("datetime".equalsIgnoreCase(dateType)){

            newV = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").parse(String.valueOf(beforeV));

          }else if("date".equalsIgnoreCase(dateType)){

            newV = new SimpleDateFormat("yyyy-MM-dd").parse(String.valueOf(beforeV));

          }

  public String createTableSQL(CgFormHeadEntity cgFormHead) {

    StringBuilder sb = new StringBuilder();

    sb.append("CREATE TABLE ");

    sb.append(cgFormHead.getTableName()+" (");

    Collections.sort(cgFormHead.getColumns(), new FieldNumComparator());

    String idField = "";

    Collections.sort(cgFormHead.getColumns(),new FieldNumComparator());

    for(int i = 0;i<cgFormHead.getColumns().size();i++){

      if(i>0){agoColumn = cgFormHead.getColumns().get(i-1);}

      column = cgFormHead.getColumns().get(i);

      sb.append(getColumnPorperty(column,agoColumn,false));

      }

    }

    sb.append(" PRIMARY KEY ("+idField.substring(0, idField.length()-1)+")");

    sb.append(") ENGINE=InnoDB DEFAULT CHARSET=utf8;");

    return sb.toString();

    Map<String, Object> fieldMap =  DbTableUtil.getColumnMap(jdbcTemplate.queryForList(sql));

    StringBuilder sb = new StringBuilder();

    sb.append(createChangeTableSql(cgFormHead));

    String idField = "";

    //step1 :对列进行排序

    Collections.sort(cgFormHead.getColumns(),new FieldNumComparator());

    for(int i = 0;i<cgFormHead.getColumns().size();i++){

      if(i>0){agoColumn = cgFormHead.getColumns().get(i-1);}

      column = cgFormHead.getColumns().get(i);

      //step2 :判断是否有这个字段  有 更新  没有 添加

        sb.append(createUpdateColumnSql(column,agoColumn));

      }else{

        sb.append(createAddColumnSql(column,agoColumn));

      }

      }

     

    }

    //step3 :查看还剩余的字段,说明已经被删除了,删除掉

     Collection<Object> c = fieldMap.values();

        if("jform_hidden_field".equals(thStr)){

          inputStr = getHiddenForm(hiddenFielList);

        }else{

          if(fieldMap.get(thStr)!=null){

              inputStr = FormHtmlUtil.getFormHTML(cgFormFieldEntity);

              inputStr +="<span class=\"Validform_checktip\">&nbsp;</span>";

            }

          }

        }

  private void repairCgFormField() {

    // 表单[订单主信息] - 字段清单

    CgFormHeadEntity jform_order_main = commonDao.findByProperty(

        CgFormHeadEntity.class, "tableName", "jform_order_main").get(0);

    commonDao.saveOrUpdate(jform_order_main_id);

    commonDao.saveOrUpdate(jform_order_main_order_code);

    commonDao.saveOrUpdate(jform_order_main_order_date);

    commonDao.saveOrUpdate(jform_order_main_order_money);

    commonDao.saveOrUpdate(jform_order_main_content);

    // 表单[请假单] - 字段清单

    CgFormHeadEntity jform_leave = commonDao.findByProperty(

        CgFormHeadEntity.class, "tableName", "jform_leave").get(0);

    commonDao.saveOrUpdate(jform_leave_id);

    commonDao.saveOrUpdate(jform_leave_title);

    commonDao.saveOrUpdate(jform_leave_people);

    commonDao.saveOrUpdate(jform_leave_sex);

    commonDao.saveOrUpdate(jform_leave_begindate);

    commonDao.saveOrUpdate(jform_leave_enddate);

    commonDao.saveOrUpdate(jform_leave_hol_dept);

    commonDao.saveOrUpdate(jform_leave_hol_reson);

    commonDao.saveOrUpdate(jform_leave_dep_leader);

    commonDao.saveOrUpdate(jform_leave_content);

    commonDao.saveOrUpdate(jform_leave_day_num);

    // 表单[动态报表配置抬头] - 字段清单

//    CgFormHeadEntity jform_cgreport_head = commonDao.findByProperty(

//        CgFormHeadEntity.class, "tableName", "jform_cgreport_head")

//        .get(0);

//    CgFormFieldEntity jform_cgreport_head_id = new CgFormFieldEntity();

//    // begin - 动态报表配置的js增强

//    String cgReportFormId = jform_cgreport_head.getId();

//    CgformEnhanceJsEntity cgReportJs = new CgformEnhanceJsEntity();

//    cgReportJs.setCgJsType("form");

//    cgReportJs

//        .setCgJs(new BigInteger(

//            "242866756E6374696F6E28297B0D0A242822626F647922292E617070656E6428223C6C696E6B20687265663D5C22706C75672D696E2F6C68674469616C6F672F736B696E732F64656661756C742E6373735C222072656C3D5C227374796C6573686565745C222069643D5C226C68676469616C6F676C696E6B5C223E22293B0D0A766172202462746E203D202428223C64697620636C6173733D5C2275695F627574746F6E735C2220207374796C653D5C22646973706C61793A696E6C696E652D626C6F636B3B5C223E3C696E707574207374796C653D5C22706F736974696F6E3A2072656C61746976653B746F703A202D3870783B5C2220636C6173733D5C2275695F73746174655F686967686C696768745C2220747970653D5C22627574746F6E5C222076616C75653D5C2273716CBDE2CEF65C22202020202020202069643D5C2273716C416E616C797A655C22202F3E3C2F6469763E22293B0D0A242822236367725F73716C22292E6166746572282462746E293B0D0A2462746E2E636C69636B2866756E6374696F6E28297B0D0A20242E616A6178287B0D0A202020202075726C3A2263675265706F7274436F6E74726F6C6C65722E646F3F6765744669656C6473222C0D0A20202020646174613A7B73716C3A242822236367725F73716C22292E76616C28297D2C0D0A09747970653A22506F7374222C0D0A2020202064617461547970653A226A736F6E222C0D0A20202020737563636573733A66756E6374696F6E2864617461297B0D0A202020202020696628646174612E7374617475733D3D227375636365737322297B0D0A202020202020202020242822236164645F6A666F726D5F63677265706F72745F6974656D5F7461626C6522292E656D70747928293B0D0A202020202020242E6561636828646174612E64617461732C66756E6374696F6E28696E6465782C65297B0D0A202020202020202076617220247472203D20242822236164645F6A666F726D5F63677265706F72745F6974656D5F7461626C655F74656D706C61746520747222292E636C6F6E6528293B0D0A2020202020202474722E66696E64282274643A6571283129203A7465787422292E76616C2865293B0D0A202020202020202474722E66696E64282274643A6571283229203A7465787422292E76616C28696E646578293B0D0A202020202020202474722E66696E64282274643A6571283329203A7465787422292E76616C2865293B0D0A20202020202020242822236164645F6A666F726D5F63677265706F72745F6974656D5F7461626C6522292E617070656E6428247472293B0D0A2020202020207D293B200D0A20202020726573657454724E756D28226164645F6A666F726D5F63677265706F72745F6974656D5F7461626C6522293B0D0A202020207D656C73657B0D0A0909242E6D657373616765722E616C6572742827B4EDCEF3272C646174612E6461746173293B0D0A097D0D0A20207D0D0A20207D293B0D0A207D293B0D0A7D293B",

//            16).toByteArray());

//    cgReportJs.setFormId(cgReportFormId);

//    commonDao.saveOrUpdate(cgReportJs);

//    // end - 动态报表配置的js增强

//    jform_cgreport_head_id.setFieldName("id");

//    jform_cgreport_head_id.setTable(jform_cgreport_head);

//    jform_cgreport_head_id.setFieldLength(120);

//    jform_cgreport_head_id.setIsKey("Y");

//    jform_cgreport_head_id.setIsNull("N");

//    jform_cgreport_head_id.setIsQuery("N");

//    jform_cgreport_head_id.setIsShow("N");

//    jform_cgreport_head_id.setIsShowList("N");

//    jform_cgreport_head_id.setShowType("checkbox");

//    jform_cgreport_head_id.setLength(36);

//    jform_cgreport_head_id.setType("string");

//    jform_cgreport_head_id.setOrderNum(0);

//    jform_cgreport_head_id.setPointLength(0);

//    jform_cgreport_head_id.setQueryMode("single");

//    jform_cgreport_head_id.setContent("主键");

//    jform_cgreport_head_id.setCreateBy("admin");

//    jform_cgreport_head_id.setCreateDate(new Date());

//    jform_cgreport_head_id.setCreateName("管理员");

//    jform_cgreport_head_id.setDictField("");

//    jform_cgreport_head_id.setDictTable("");

//    jform_cgreport_head_id.setMainTable("");

//    jform_cgreport_head_id.setMainField("");

//    commonDao.saveOrUpdate(jform_cgreport_head_id);

//

//    CgFormFieldEntity jform_cgreport_head_code = new CgFormFieldEntity();

//    jform_cgreport_head_code.setFieldName("code");

//    jform_cgreport_head_code.setTable(jform_cgreport_head);

//    jform_cgreport_head_code.setFieldLength(120);

//    jform_cgreport_head_code.setIsKey("N");

//    jform_cgreport_head_code.setIsNull("N");

//    jform_cgreport_head_code.setIsQuery("Y");

//    jform_cgreport_head_code.setIsShow("Y");

//    jform_cgreport_head_code.setIsShowList("Y");

//    jform_cgreport_head_code.setShowType("text");

//    jform_cgreport_head_code.setLength(36);

//    jform_cgreport_head_code.setType("string");

//    jform_cgreport_head_code.setOrderNum(1);

//    jform_cgreport_head_code.setPointLength(0);

//    jform_cgreport_head_code.setQueryMode("single");

//    jform_cgreport_head_code.setContent("编码");

//    jform_cgreport_head_code.setCreateBy("admin");

//    jform_cgreport_head_code.setCreateDate(new Date());

//    jform_cgreport_head_code.setCreateName("管理员");

//    jform_cgreport_head_code.setDictField("");

//    jform_cgreport_head_code.setDictTable("");

//    jform_cgreport_head_code.setMainTable("");

//    jform_cgreport_head_code.setMainField("");

//    commonDao.saveOrUpdate(jform_cgreport_head_code);

//

//    CgFormFieldEntity jform_cgreport_head_name = new CgFormFieldEntity();

//    jform_cgreport_head_name.setFieldName("name");

//    jform_cgreport_head_name.setTable(jform_cgreport_head);

//    jform_cgreport_head_name.setFieldLength(120);

//    jform_cgreport_head_name.setIsKey("N");

//    jform_cgreport_head_name.setIsNull("N");

//    jform_cgreport_head_name.setIsQuery("Y");

//    jform_cgreport_head_name.setIsShow("Y");

//    jform_cgreport_head_name.setIsShowList("Y");

//    jform_cgreport_head_name.setShowType("text");

//    jform_cgreport_head_name.setLength(100);

//    jform_cgreport_head_name.setType("string");

//    jform_cgreport_head_name.setOrderNum(2);

//    jform_cgreport_head_name.setPointLength(0);

//    jform_cgreport_head_name.setQueryMode("single");

//    jform_cgreport_head_name.setContent("名称");

//    jform_cgreport_head_name.setCreateBy("admin");

//    jform_cgreport_head_name.setCreateDate(new Date());

//    jform_cgreport_head_name.setCreateName("管理员");

//    jform_cgreport_head_name.setDictField("");

//    jform_cgreport_head_name.setDictTable("");

//    jform_cgreport_head_name.setMainTable("");

//    jform_cgreport_head_name.setMainField("");

//    commonDao.saveOrUpdate(jform_cgreport_head_name);

//

//    CgFormFieldEntity jform_cgreport_head_cgr_sql = new CgFormFieldEntity();

//    jform_cgreport_head_cgr_sql.setFieldName("cgr_sql");

//    jform_cgreport_head_cgr_sql.setTable(jform_cgreport_head);

//    jform_cgreport_head_cgr_sql.setFieldLength(120);

//    jform_cgreport_head_cgr_sql.setIsKey("N");

//    jform_cgreport_head_cgr_sql.setIsNull("N");

//    jform_cgreport_head_cgr_sql.setIsQuery("Y");

//    jform_cgreport_head_cgr_sql.setIsShow("Y");

//    jform_cgreport_head_cgr_sql.setIsShowList("Y");

//    jform_cgreport_head_cgr_sql.setShowType("textarea");

//    jform_cgreport_head_cgr_sql.setLength(2000);

//    jform_cgreport_head_cgr_sql.setType("string");

//    jform_cgreport_head_cgr_sql.setOrderNum(3);

//    jform_cgreport_head_cgr_sql.setPointLength(0);

//    jform_cgreport_head_cgr_sql.setQueryMode("single");

//    jform_cgreport_head_cgr_sql.setContent("查询数据SQL");

//    jform_cgreport_head_cgr_sql.setCreateBy("admin");

//    jform_cgreport_head_cgr_sql.setCreateDate(new Date());

//    jform_cgreport_head_cgr_sql.setCreateName("管理员");

//    jform_cgreport_head_cgr_sql.setDictField("");

//    jform_cgreport_head_cgr_sql.setDictTable("");

//    jform_cgreport_head_cgr_sql.setMainTable("");

//    jform_cgreport_head_cgr_sql.setMainField("");

//    commonDao.saveOrUpdate(jform_cgreport_head_cgr_sql);

//

//    CgFormFieldEntity jform_cgreport_head_content = new CgFormFieldEntity();

//    jform_cgreport_head_content.setFieldName("content");

//    jform_cgreport_head_content.setTable(jform_cgreport_head);

//    jform_cgreport_head_content.setFieldLength(120);

//    jform_cgreport_head_content.setIsKey("N");

//    jform_cgreport_head_content.setIsNull("N");

//    jform_cgreport_head_content.setIsQuery("Y");

//    jform_cgreport_head_content.setIsShow("Y");

//    jform_cgreport_head_content.setIsShowList("Y");

//    jform_cgreport_head_content.setShowType("textarea");

//    jform_cgreport_head_content.setLength(1000);

//    jform_cgreport_head_content.setType("string");

//    jform_cgreport_head_content.setOrderNum(4);

//    jform_cgreport_head_content.setPointLength(0);

//    jform_cgreport_head_content.setQueryMode("single");

//    jform_cgreport_head_content.setContent("描述");

//    jform_cgreport_head_content.setCreateBy("admin");

//    jform_cgreport_head_content.setCreateDate(new Date());

//    jform_cgreport_head_content.setCreateName("管理员");

//    jform_cgreport_head_content.setDictField("");

//    jform_cgreport_head_content.setDictTable("");

//    jform_cgreport_head_content.setMainTable("");

//    jform_cgreport_head_content.setMainField("");

//    commonDao.saveOrUpdate(jform_cgreport_head_content);

//

//    // 表单[动态报表配置明细] - 字段清单

//    CgFormHeadEntity jform_cgreport_item = commonDao.findByProperty(

//        CgFormHeadEntity.class, "tableName", "jform_cgreport_item")

//        .get(0);

//    CgFormFieldEntity jform_cgreport_item_id = new CgFormFieldEntity();

//    jform_cgreport_item_id.setFieldName("id");

//    jform_cgreport_item_id.setTable(jform_cgreport_item);

//    jform_cgreport_item_id.setFieldLength(120);

//    jform_cgreport_item_id.setIsKey("Y");

//    jform_cgreport_item_id.setIsNull("N");

//    jform_cgreport_item_id.setIsQuery("N");

//    jform_cgreport_item_id.setIsShow("N");

//    jform_cgreport_item_id.setIsShowList("N");

//    jform_cgreport_item_id.setShowType("checkbox");

//    jform_cgreport_item_id.setLength(36);

//    jform_cgreport_item_id.setType("string");

//    jform_cgreport_item_id.setOrderNum(0);

//    jform_cgreport_item_id.setPointLength(0);

//    jform_cgreport_item_id.setQueryMode("single");

//    jform_cgreport_item_id.setContent("主键");

//    jform_cgreport_item_id.setCreateBy("admin");

//    jform_cgreport_item_id.setCreateDate(new Date());

//    jform_cgreport_item_id.setCreateName("管理员");

//    jform_cgreport_item_id.setDictField("");

//    jform_cgreport_item_id.setDictTable("");

//    jform_cgreport_item_id.setMainTable("");

//    jform_cgreport_item_id.setMainField("");

//    commonDao.saveOrUpdate(jform_cgreport_item_id);

//

//    CgFormFieldEntity jform_cgreport_item_field_name = new CgFormFieldEntity();

//    jform_cgreport_item_field_name.setFieldName("field_name");

//    jform_cgreport_item_field_name.setTable(jform_cgreport_item);

//    jform_cgreport_item_field_name.setFieldLength(120);

//    jform_cgreport_item_field_name.setIsKey("N");

//    jform_cgreport_item_field_name.setIsNull("Y");

//    jform_cgreport_item_field_name.setIsQuery("N");

//    jform_cgreport_item_field_name.setIsShow("Y");

//    jform_cgreport_item_field_name.setIsShowList("Y");

//    jform_cgreport_item_field_name.setShowType("text");

//    jform_cgreport_item_field_name.setLength(36);

//    jform_cgreport_item_field_name.setType("string");

//    jform_cgreport_item_field_name.setOrderNum(1);

//    jform_cgreport_item_field_name.setPointLength(0);

//    jform_cgreport_item_field_name.setQueryMode("single");

//    jform_cgreport_item_field_name.setContent("字段名");

//    jform_cgreport_item_field_name.setCreateBy("admin");

//    jform_cgreport_item_field_name.setCreateDate(new Date());

//    jform_cgreport_item_field_name.setCreateName("管理员");

//    jform_cgreport_item_field_name.setDictField("");

//    jform_cgreport_item_field_name.setDictTable("");

//    jform_cgreport_item_field_name.setMainTable("");

//    jform_cgreport_item_field_name.setMainField("");

//    commonDao.saveOrUpdate(jform_cgreport_item_field_name);

//

//    CgFormFieldEntity jform_cgreport_item_order_num = new CgFormFieldEntity();

//    jform_cgreport_item_order_num.setFieldName("order_num");

//    jform_cgreport_item_order_num.setTable(jform_cgreport_item);

//    jform_cgreport_item_order_num.setFieldLength(120);

//    jform_cgreport_item_order_num.setIsKey("N");

//    jform_cgreport_item_order_num.setIsNull("Y");

//    jform_cgreport_item_order_num.setIsQuery("N");

//    jform_cgreport_item_order_num.setIsShow("Y");

//    jform_cgreport_item_order_num.setIsShowList("Y");

//    jform_cgreport_item_order_num.setShowType("text");

//    jform_cgreport_item_order_num.setLength(10);

//    jform_cgreport_item_order_num.setType("int");

//    jform_cgreport_item_order_num.setOrderNum(2);

//    jform_cgreport_item_order_num.setPointLength(0);

//    jform_cgreport_item_order_num.setQueryMode("single");

//    jform_cgreport_item_order_num.setContent("字段序号");

//    jform_cgreport_item_order_num.setCreateBy("admin");

//    jform_cgreport_item_order_num.setCreateDate(new Date());

//    jform_cgreport_item_order_num.setCreateName("管理员");

//    jform_cgreport_item_order_num.setDictField("");

//    jform_cgreport_item_order_num.setDictTable("");

//    jform_cgreport_item_order_num.setMainTable("");

//    jform_cgreport_item_order_num.setMainField("");

//    commonDao.saveOrUpdate(jform_cgreport_item_order_num);

//

//    CgFormFieldEntity jform_cgreport_item_s_mode = new CgFormFieldEntity();

//    jform_cgreport_item_s_mode.setFieldName("s_mode");

//    jform_cgreport_item_s_mode.setTable(jform_cgreport_item);

//    jform_cgreport_item_s_mode.setFieldLength(120);

//    jform_cgreport_item_s_mode.setIsKey("N");

//    jform_cgreport_item_s_mode.setIsNull("Y");

//    jform_cgreport_item_s_mode.setIsQuery("N");

//    jform_cgreport_item_s_mode.setIsShow("Y");

//    jform_cgreport_item_s_mode.setIsShowList("Y");

//    jform_cgreport_item_s_mode.setShowType("list");

//    jform_cgreport_item_s_mode.setLength(10);

//    jform_cgreport_item_s_mode.setType("string");

//    jform_cgreport_item_s_mode.setOrderNum(5);

//    jform_cgreport_item_s_mode.setPointLength(0);

//    jform_cgreport_item_s_mode.setQueryMode("single");

//    jform_cgreport_item_s_mode.setContent("查询模式");

//    jform_cgreport_item_s_mode.setCreateBy("admin");

//    jform_cgreport_item_s_mode.setCreateDate(new Date());

//    jform_cgreport_item_s_mode.setCreateName("管理员");

//    jform_cgreport_item_s_mode.setDictField("searchmode");

//    jform_cgreport_item_s_mode.setDictTable("");

//    jform_cgreport_item_s_mode.setMainTable("");

//    jform_cgreport_item_s_mode.setMainField("");

//    commonDao.saveOrUpdate(jform_cgreport_item_s_mode);

//

//    CgFormFieldEntity jform_cgreport_item_replace_va = new CgFormFieldEntity();

//    jform_cgreport_item_replace_va.setFieldName("replace_va");

//    jform_cgreport_item_replace_va.setTable(jform_cgreport_item);

//    jform_cgreport_item_replace_va.setFieldLength(120);

//    jform_cgreport_item_replace_va.setIsKey("N");

//    jform_cgreport_item_replace_va.setIsNull("Y");

//    jform_cgreport_item_replace_va.setIsQuery("N");

//    jform_cgreport_item_replace_va.setIsShow("Y");

//    jform_cgreport_item_replace_va.setIsShowList("Y");

//    jform_cgreport_item_replace_va.setShowType("text");

//    jform_cgreport_item_replace_va.setLength(36);

//    jform_cgreport_item_replace_va.setType("string");

//    jform_cgreport_item_replace_va.setOrderNum(6);

//    jform_cgreport_item_replace_va.setPointLength(0);

//    jform_cgreport_item_replace_va.setQueryMode("single");

//    jform_cgreport_item_replace_va.setContent("取值表达式");

//    jform_cgreport_item_replace_va.setCreateBy("admin");

//    jform_cgreport_item_replace_va.setCreateDate(new Date());

//    jform_cgreport_item_replace_va.setCreateName("管理员");

//    jform_cgreport_item_replace_va.setDictField("");

//    jform_cgreport_item_replace_va.setDictTable("");

//    jform_cgreport_item_replace_va.setMainTable("");

//    jform_cgreport_item_replace_va.setMainField("");

//    commonDao.saveOrUpdate(jform_cgreport_item_replace_va);

//

//    CgFormFieldEntity jform_cgreport_item_dict_code = new CgFormFieldEntity();

//    jform_cgreport_item_dict_code.setFieldName("dict_code");

//    jform_cgreport_item_dict_code.setTable(jform_cgreport_item);

//    jform_cgreport_item_dict_code.setFieldLength(120);

//    jform_cgreport_item_dict_code.setIsKey("N");

//    jform_cgreport_item_dict_code.setIsNull("Y");

//    jform_cgreport_item_dict_code.setIsQuery("N");

//    jform_cgreport_item_dict_code.setIsShow("Y");

//    jform_cgreport_item_dict_code.setIsShowList("Y");

//    jform_cgreport_item_dict_code.setShowType("text");

//    jform_cgreport_item_dict_code.setLength(36);

//    jform_cgreport_item_dict_code.setType("string");

//    jform_cgreport_item_dict_code.setOrderNum(7);

//    jform_cgreport_item_dict_code.setPointLength(0);

//    jform_cgreport_item_dict_code.setQueryMode("single");

//    jform_cgreport_item_dict_code.setContent("字典Code");

//    jform_cgreport_item_dict_code.setCreateBy("admin");

//    jform_cgreport_item_dict_code.setCreateDate(new Date());

//    jform_cgreport_item_dict_code.setCreateName("管理员");

//    jform_cgreport_item_dict_code.setDictField("");

//    jform_cgreport_item_dict_code.setDictTable("");

//    jform_cgreport_item_dict_code.setMainTable("");

//    jform_cgreport_item_dict_code.setMainField("");

//    commonDao.saveOrUpdate(jform_cgreport_item_dict_code);

//

//    CgFormFieldEntity jform_cgreport_item_s_flag = new CgFormFieldEntity();

//    jform_cgreport_item_s_flag.setFieldName("s_flag");

//    jform_cgreport_item_s_flag.setTable(jform_cgreport_item);

//    jform_cgreport_item_s_flag.setFieldLength(120);

//    jform_cgreport_item_s_flag.setIsKey("N");

//    jform_cgreport_item_s_flag.setIsNull("Y");

//    jform_cgreport_item_s_flag.setIsQuery("N");

//    jform_cgreport_item_s_flag.setIsShow("Y");

//    jform_cgreport_item_s_flag.setIsShowList("Y");

//    jform_cgreport_item_s_flag.setShowType("list");

//    jform_cgreport_item_s_flag.setLength(2);

//    jform_cgreport_item_s_flag.setType("string");

//    jform_cgreport_item_s_flag.setOrderNum(8);

//    jform_cgreport_item_s_flag.setPointLength(0);

//    jform_cgreport_item_s_flag.setQueryMode("single");

//    jform_cgreport_item_s_flag.setContent("是否查询");

//    jform_cgreport_item_s_flag.setCreateBy("admin");

//    jform_cgreport_item_s_flag.setCreateDate(new Date());

//    jform_cgreport_item_s_flag.setCreateName("管理员");

//    jform_cgreport_item_s_flag.setDictField("yesorno");

//    jform_cgreport_item_s_flag.setDictTable("");

//    jform_cgreport_item_s_flag.setMainTable("");

//    jform_cgreport_item_s_flag.setMainField("");

//    commonDao.saveOrUpdate(jform_cgreport_item_s_flag);

//

//    CgFormFieldEntity jform_cgreport_item_cgrhead_id = new CgFormFieldEntity();

//    jform_cgreport_item_cgrhead_id.setFieldName("cgrhead_id");

//    jform_cgreport_item_cgrhead_id.setTable(jform_cgreport_item);

//    jform_cgreport_item_cgrhead_id.setFieldLength(120);

//    jform_cgreport_item_cgrhead_id.setIsKey("N");

//    jform_cgreport_item_cgrhead_id.setIsNull("Y");

//    jform_cgreport_item_cgrhead_id.setIsQuery("N");

//    jform_cgreport_item_cgrhead_id.setIsShow("N");

//    jform_cgreport_item_cgrhead_id.setIsShowList("N");

//    jform_cgreport_item_cgrhead_id.setShowType("text");

//    jform_cgreport_item_cgrhead_id.setLength(36);

//    jform_cgreport_item_cgrhead_id.setType("string");

//    jform_cgreport_item_cgrhead_id.setOrderNum(9);

//    jform_cgreport_item_cgrhead_id.setPointLength(0);

//    jform_cgreport_item_cgrhead_id.setQueryMode("single");

//    jform_cgreport_item_cgrhead_id.setContent("外键");

//    jform_cgreport_item_cgrhead_id.setCreateBy("admin");

//    jform_cgreport_item_cgrhead_id.setCreateDate(new Date());

//    jform_cgreport_item_cgrhead_id.setCreateName("管理员");

//    jform_cgreport_item_cgrhead_id.setDictField("");

//    jform_cgreport_item_cgrhead_id.setDictTable("");

//    jform_cgreport_item_cgrhead_id.setMainTable("jform_cgreport_head");

//    jform_cgreport_item_cgrhead_id.setMainField("id");

//    commonDao.saveOrUpdate(jform_cgreport_item_cgrhead_id);

//

//    CgFormFieldEntity jform_cgreport_item_field_txt = new CgFormFieldEntity();

//    jform_cgreport_item_field_txt.setFieldName("field_txt");

//    jform_cgreport_item_field_txt.setTable(jform_cgreport_item);

//    jform_cgreport_item_field_txt.setFieldLength(120);

//    jform_cgreport_item_field_txt.setIsKey("N");

//    jform_cgreport_item_field_txt.setIsNull("Y");

//    jform_cgreport_item_field_txt.setIsQuery("N");

//    jform_cgreport_item_field_txt.setIsShow("Y");

//    jform_cgreport_item_field_txt.setIsShowList("Y");

//    jform_cgreport_item_field_txt.setShowType("text");

//    jform_cgreport_item_field_txt.setLength(1000);

//    jform_cgreport_item_field_txt.setType("string");

//    jform_cgreport_item_field_txt.setOrderNum(3);

//    jform_cgreport_item_field_txt.setPointLength(0);

//    jform_cgreport_item_field_txt.setQueryMode("single");

//    jform_cgreport_item_field_txt.setContent("字段文本");

//    jform_cgreport_item_field_txt.setCreateBy("admin");

//    jform_cgreport_item_field_txt.setCreateDate(new Date());

//    jform_cgreport_item_field_txt.setCreateName("管理员");

//    jform_cgreport_item_field_txt.setDictField("");

//    jform_cgreport_item_field_txt.setDictTable("");

//    jform_cgreport_item_field_txt.setMainTable("");

//    jform_cgreport_item_field_txt.setMainField("");

//    commonDao.saveOrUpdate(jform_cgreport_item_field_txt);

//

//    CgFormFieldEntity jform_cgreport_item_field_type = new CgFormFieldEntity();

//    jform_cgreport_item_field_type.setFieldName("field_type");

//    jform_cgreport_item_field_type.setTable(jform_cgreport_item);

//    jform_cgreport_item_field_type.setFieldLength(120);

//    jform_cgreport_item_field_type.setIsKey("N");

//    jform_cgreport_item_field_type.setIsNull("Y");

//    jform_cgreport_item_field_type.setIsQuery("N");

//    jform_cgreport_item_field_type.setIsShow("Y");

//    jform_cgreport_item_field_type.setIsShowList("Y");

//    jform_cgreport_item_field_type.setShowType("list");

//    jform_cgreport_item_field_type.setLength(10);

//    jform_cgreport_item_field_type.setType("string");

//    jform_cgreport_item_field_type.setOrderNum(4);

//    jform_cgreport_item_field_type.setPointLength(0);

//    jform_cgreport_item_field_type.setQueryMode("single");

//    jform_cgreport_item_field_type.setContent("字段类型");

//    jform_cgreport_item_field_type.setCreateBy("admin");

//    jform_cgreport_item_field_type.setCreateDate(new Date());

//    jform_cgreport_item_field_type.setCreateName("管理员");

//    jform_cgreport_item_field_type.setDictField("fieldtype");

//    jform_cgreport_item_field_type.setDictTable("");

//    jform_cgreport_item_field_type.setMainTable("");

//    jform_cgreport_item_field_type.setMainField("");

//    commonDao.saveOrUpdate(jform_cgreport_item_field_type);

    // 表单[订单客户信息] - 字段清单

    CgFormHeadEntity jform_order_customer = commonDao.findByProperty(

        CgFormHeadEntity.class, "tableName", "jform_order_customer")

        .get(0);

    commonDao.saveOrUpdate(jform_order_customer_id);

    commonDao.saveOrUpdate(jform_order_customer_name);

    commonDao.saveOrUpdate(jform_order_customer_money);

    commonDao.saveOrUpdate(jform_order_customer_fk_id);

    commonDao.saveOrUpdate(jform_order_customer_telphone);

    commonDao.saveOrUpdate(jform_order_customer_sex);

    // 表单[订单机票信息] - 字段清单

    CgFormHeadEntity jform_order_ticket = commonDao.findByProperty(

        CgFormHeadEntity.class, "tableName", "jform_order_ticket").get(

        0);