String mainTable = codeParamEntityIn.getTableName();

      //主表的智能表单配置

      GenerateEntity mainG = new GenerateEntity();

      mainG.setProjectPath(subTableListEntity.getProjectPath());

      getCgformConfig(mCgFormHead, mainG);

      //step.4 填充子表的所有智能表单配置

      Map<String,GenerateEntity> subsG = new HashMap<String,GenerateEntity>();

      List<SubTableEntity>  subTabParamIn = subTableListEntity.getSubTabParamIn();

      for(SubTableEntity po:subTabParamIn){

        String sTableName = po.getTableName();

        String[] foreignKeys =getForeignkeys(colums);

        po.setForeignKeys(foreignKeys);

        GenerateEntity subG = new GenerateEntity();

        getCgformConfig(cgSubHead, subG);

        subG.setEntityName(po.getEntityName());

            List cghead = new ArrayList();

            i=1;

            while(rs.next())

            {

                cghead.add(head);

                i++;

            }

            root.put("cghead", cghead);

   * @author tanghan 2013-7-28

   */

  private void repairCgFormField() {

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

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

    CgFormFieldEntity jform_order_main_id = new CgFormFieldEntity();

    jform_order_main_id.setFieldName("id");

    jform_order_main_id.setTable(jform_order_main);

    jform_order_main_id.setFieldLength(0);

    jform_order_main_id.setIsKey("Y");

    jform_order_main_id.setIsNull("N");

    jform_order_main_id.setIsQuery("N");

    jform_order_main_id.setIsShow("N");

    jform_order_main_id.setIsShowList("N");

    jform_order_main_id.setShowType("text");

    jform_order_main_id.setLength(36);

    jform_order_main_id.setType("string");

    jform_order_main_id.setOrderNum(0);

    jform_order_main_id.setPointLength(0);

    jform_order_main_id.setQueryMode("single");

    jform_order_main_id.setContent("主键");

    jform_order_main_id.setCreateBy("admin");

    jform_order_main_id.setCreateDate(new Date());

    jform_order_main_id.setCreateName("管理员");

    jform_order_main_id.setDictField("");

    jform_order_main_id.setDictTable("");

    jform_order_main_id.setMainTable("");

    jform_order_main_id.setMainField("");

    commonDao.saveOrUpdate(jform_order_main_id);

    CgFormFieldEntity jform_order_main_order_code = new CgFormFieldEntity();

    jform_order_main_order_code.setFieldName("order_code");

    jform_order_main_order_code.setTable(jform_order_main);

    jform_order_main_order_code.setFieldLength(0);

    jform_order_main_order_code.setIsKey("N");

    jform_order_main_order_code.setIsNull("Y");

    jform_order_main_order_code.setIsQuery("Y");

    jform_order_main_order_code.setIsShow("Y");

    jform_order_main_order_code.setIsShowList("Y");

    jform_order_main_order_code.setShowType("text");

    jform_order_main_order_code.setLength(50);

    jform_order_main_order_code.setType("string");

    jform_order_main_order_code.setOrderNum(1);

    jform_order_main_order_code.setPointLength(0);

    jform_order_main_order_code.setQueryMode("single");

    jform_order_main_order_code.setContent("订单号");

    jform_order_main_order_code.setCreateBy("admin");

    jform_order_main_order_code.setCreateDate(new Date());

    jform_order_main_order_code.setCreateName("管理员");

    jform_order_main_order_code.setDictField("");

    jform_order_main_order_code.setDictTable("");

    jform_order_main_order_code.setMainTable("");

    jform_order_main_order_code.setMainField("");

    commonDao.saveOrUpdate(jform_order_main_order_code);

    CgFormFieldEntity jform_order_main_order_date = new CgFormFieldEntity();

    jform_order_main_order_date.setFieldName("order_date");

    jform_order_main_order_date.setTable(jform_order_main);

    jform_order_main_order_date.setFieldLength(0);

    jform_order_main_order_date.setIsKey("N");

    jform_order_main_order_date.setIsNull("Y");

    jform_order_main_order_date.setIsQuery("Y");

    jform_order_main_order_date.setIsShow("Y");

    jform_order_main_order_date.setIsShowList("Y");

    jform_order_main_order_date.setShowType("date");

    jform_order_main_order_date.setLength(20);

    jform_order_main_order_date.setType("Date");

    jform_order_main_order_date.setOrderNum(2);

    jform_order_main_order_date.setPointLength(0);

    jform_order_main_order_date.setQueryMode("single");

    jform_order_main_order_date.setContent("订单日期");

    jform_order_main_order_date.setCreateBy("admin");

    jform_order_main_order_date.setCreateDate(new Date());

    jform_order_main_order_date.setCreateName("管理员");

    jform_order_main_order_date.setDictField("");

    jform_order_main_order_date.setDictTable("");

    jform_order_main_order_date.setMainTable("");

    jform_order_main_order_date.setMainField("");

    commonDao.saveOrUpdate(jform_order_main_order_date);

    CgFormFieldEntity jform_order_main_order_money = new CgFormFieldEntity();

    jform_order_main_order_money.setFieldName("order_money");

    jform_order_main_order_money.setTable(jform_order_main);

    jform_order_main_order_money.setFieldLength(0);

    jform_order_main_order_money.setIsKey("N");

    jform_order_main_order_money.setIsNull("Y");

    jform_order_main_order_money.setIsQuery("Y");

    jform_order_main_order_money.setIsShow("Y");

    jform_order_main_order_money.setIsShowList("Y");

    jform_order_main_order_money.setShowType("text");

    jform_order_main_order_money.setLength(10);

    jform_order_main_order_money.setType("double");

    jform_order_main_order_money.setOrderNum(3);

    jform_order_main_order_money.setPointLength(3);

    jform_order_main_order_money.setQueryMode("single");

    jform_order_main_order_money.setContent("订单金额");

    jform_order_main_order_money.setCreateBy("admin");

    jform_order_main_order_money.setCreateDate(new Date());

    jform_order_main_order_money.setCreateName("管理员");

    jform_order_main_order_money.setDictField("");

    jform_order_main_order_money.setDictTable("");

    jform_order_main_order_money.setMainTable("");

    jform_order_main_order_money.setMainField("");

    commonDao.saveOrUpdate(jform_order_main_order_money);

    CgFormFieldEntity jform_order_main_content = new CgFormFieldEntity();

    jform_order_main_content.setFieldName("content");

    jform_order_main_content.setTable(jform_order_main);

    jform_order_main_content.setFieldLength(0);

    jform_order_main_content.setIsKey("N");

    jform_order_main_content.setIsNull("Y");

    jform_order_main_content.setIsQuery("Y");

    jform_order_main_content.setIsShow("Y");

    jform_order_main_content.setIsShowList("Y");

    jform_order_main_content.setShowType("text");

    jform_order_main_content.setLength(255);

    jform_order_main_content.setType("string");

    jform_order_main_content.setOrderNum(4);

    jform_order_main_content.setPointLength(0);

    jform_order_main_content.setQueryMode("single");

    jform_order_main_content.setContent("备注");

    jform_order_main_content.setCreateBy("admin");

    jform_order_main_content.setCreateDate(new Date());

    jform_order_main_content.setCreateName("管理员");

    jform_order_main_content.setDictField("");

    jform_order_main_content.setDictTable("");

    jform_order_main_content.setMainTable("");

    jform_order_main_content.setMainField("");

    commonDao.saveOrUpdate(jform_order_main_content);

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

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

    CgFormFieldEntity jform_leave_id = new CgFormFieldEntity();

    jform_leave_id.setFieldName("id");

    jform_leave_id.setTable(jform_leave);

    jform_leave_id.setFieldLength(0);

    jform_leave_id.setIsKey("Y");

    jform_leave_id.setIsNull("N");

    jform_leave_id.setIsQuery("N");

    jform_leave_id.setIsShow("N");

    jform_leave_id.setIsShowList("N");

    jform_leave_id.setShowType("text");

    jform_leave_id.setLength(36);

    jform_leave_id.setType("string");

    jform_leave_id.setOrderNum(0);

    jform_leave_id.setPointLength(0);

    jform_leave_id.setQueryMode("single");

    jform_leave_id.setContent("主键");

    jform_leave_id.setCreateBy("admin");

    jform_leave_id.setCreateDate(new Date());

    jform_leave_id.setCreateName("管理员");

    jform_leave_id.setDictField("");

    jform_leave_id.setDictTable("");

    jform_leave_id.setMainTable("");

    jform_leave_id.setMainField("");

    commonDao.saveOrUpdate(jform_leave_id);

    CgFormFieldEntity jform_leave_title = new CgFormFieldEntity();

    jform_leave_title.setFieldName("title");

    jform_leave_title.setTable(jform_leave);

    jform_leave_title.setFieldLength(0);

    jform_leave_title.setIsKey("N");

    jform_leave_title.setIsNull("N");

    jform_leave_title.setIsQuery("N");

    jform_leave_title.setIsShow("Y");

    jform_leave_title.setIsShowList("Y");

    jform_leave_title.setShowType("text");

    jform_leave_title.setLength(50);

    jform_leave_title.setType("string");

    jform_leave_title.setOrderNum(1);

    jform_leave_title.setPointLength(0);

    jform_leave_title.setQueryMode("single");

    jform_leave_title.setContent("请假标题");

    jform_leave_title.setCreateBy("admin");

    jform_leave_title.setCreateDate(new Date());

    jform_leave_title.setCreateName("管理员");

    jform_leave_title.setDictField("");

    jform_leave_title.setDictTable("");

    jform_leave_title.setMainTable("");

    jform_leave_title.setMainField("");

    commonDao.saveOrUpdate(jform_leave_title);

    CgFormFieldEntity jform_leave_people = new CgFormFieldEntity();

    jform_leave_people.setFieldName("people");

    jform_leave_people.setTable(jform_leave);

    jform_leave_people.setFieldLength(0);

    jform_leave_people.setIsKey("N");

    jform_leave_people.setIsNull("N");

    jform_leave_people.setIsQuery("Y");

    jform_leave_people.setIsShow("Y");

    jform_leave_people.setIsShowList("Y");

    jform_leave_people.setShowType("text");

    jform_leave_people.setLength(20);

    jform_leave_people.setType("string");

    jform_leave_people.setOrderNum(2);

    jform_leave_people.setPointLength(0);

    jform_leave_people.setQueryMode("single");

    jform_leave_people.setContent("请假人");

    jform_leave_people.setCreateBy("admin");

    jform_leave_people.setCreateDate(new Date());

    jform_leave_people.setCreateName("管理员");

    jform_leave_people.setDictField("");

    jform_leave_people.setDictTable("");

    jform_leave_people.setMainTable("");

    jform_leave_people.setMainField("");

    commonDao.saveOrUpdate(jform_leave_people);

    CgFormFieldEntity jform_leave_sex = new CgFormFieldEntity();

    jform_leave_sex.setFieldName("sex");

    jform_leave_sex.setTable(jform_leave);

    jform_leave_sex.setFieldLength(0);

    jform_leave_sex.setIsKey("N");

    jform_leave_sex.setIsNull("N");

    jform_leave_sex.setIsQuery("Y");

    jform_leave_sex.setIsShow("Y");

    jform_leave_sex.setIsShowList("Y");

    jform_leave_sex.setShowType("list");

    jform_leave_sex.setLength(10);

    jform_leave_sex.setType("string");

    jform_leave_sex.setOrderNum(3);

    jform_leave_sex.setPointLength(0);

    jform_leave_sex.setQueryMode("single");

    jform_leave_sex.setContent("性别");

    jform_leave_sex.setCreateBy("admin");

    jform_leave_sex.setCreateDate(new Date());

    jform_leave_sex.setCreateName("管理员");

    jform_leave_sex.setDictField("sex");

    jform_leave_sex.setDictTable("");

    jform_leave_sex.setMainTable("");

    jform_leave_sex.setMainField("");

    commonDao.saveOrUpdate(jform_leave_sex);

    CgFormFieldEntity jform_leave_begindate = new CgFormFieldEntity();

    jform_leave_begindate.setFieldName("begindate");

    jform_leave_begindate.setTable(jform_leave);

    jform_leave_begindate.setFieldLength(0);

    jform_leave_begindate.setIsKey("N");

    jform_leave_begindate.setIsNull("N");

    jform_leave_begindate.setIsQuery("N");

    jform_leave_begindate.setIsShow("Y");

    jform_leave_begindate.setIsShowList("Y");

    jform_leave_begindate.setShowType("date");

    jform_leave_begindate.setLength(0);

    jform_leave_begindate.setType("Date");

    jform_leave_begindate.setOrderNum(4);

    jform_leave_begindate.setPointLength(0);

    jform_leave_begindate.setQueryMode("group");

    jform_leave_begindate.setContent("请假开始时间");

    jform_leave_begindate.setCreateBy("admin");

    jform_leave_begindate.setCreateDate(new Date());

    jform_leave_begindate.setCreateName("管理员");

    jform_leave_begindate.setDictField("");

    jform_leave_begindate.setDictTable("");

    jform_leave_begindate.setMainTable("");

    jform_leave_begindate.setMainField("");

    commonDao.saveOrUpdate(jform_leave_begindate);

    CgFormFieldEntity jform_leave_enddate = new CgFormFieldEntity();

    jform_leave_enddate.setFieldName("enddate");

    jform_leave_enddate.setTable(jform_leave);

    jform_leave_enddate.setFieldLength(0);

    jform_leave_enddate.setIsKey("N");

    jform_leave_enddate.setIsNull("N");

    jform_leave_enddate.setIsQuery("N");

    jform_leave_enddate.setIsShow("Y");

    jform_leave_enddate.setIsShowList("Y");

    jform_leave_enddate.setShowType("datetime");

    jform_leave_enddate.setLength(0);

    jform_leave_enddate.setType("Date");

    jform_leave_enddate.setOrderNum(5);

    jform_leave_enddate.setPointLength(0);

    jform_leave_enddate.setQueryMode("group");

    jform_leave_enddate.setContent("请假结束时间");

    jform_leave_enddate.setCreateBy("admin");

    jform_leave_enddate.setCreateDate(new Date());

    jform_leave_enddate.setCreateName("管理员");

    jform_leave_enddate.setDictField("");

    jform_leave_enddate.setDictTable("");

    jform_leave_enddate.setMainTable("");

    jform_leave_enddate.setMainField("");

    commonDao.saveOrUpdate(jform_leave_enddate);

    CgFormFieldEntity jform_leave_hol_dept = new CgFormFieldEntity();

    jform_leave_hol_dept.setFieldName("hol_dept");

    jform_leave_hol_dept.setTable(jform_leave);

    jform_leave_hol_dept.setFieldLength(0);

    jform_leave_hol_dept.setIsKey("N");

    jform_leave_hol_dept.setIsNull("N");

    jform_leave_hol_dept.setIsQuery("N");

    jform_leave_hol_dept.setIsShow("Y");

    jform_leave_hol_dept.setIsShowList("Y");

    jform_leave_hol_dept.setShowType("list");

    jform_leave_hol_dept.setLength(32);

    jform_leave_hol_dept.setType("string");

    jform_leave_hol_dept.setOrderNum(7);

    jform_leave_hol_dept.setPointLength(0);

    jform_leave_hol_dept.setQueryMode("single");

    jform_leave_hol_dept.setContent("所属部门");

    jform_leave_hol_dept.setCreateBy("admin");

    jform_leave_hol_dept.setCreateDate(new Date());

    jform_leave_hol_dept.setCreateName("管理员");

    jform_leave_hol_dept.setDictField("id");

    jform_leave_hol_dept.setDictTable("t_s_depart");

    jform_leave_hol_dept.setDictText("departname");

    jform_leave_hol_dept.setMainTable("");

    jform_leave_hol_dept.setMainField("");

    commonDao.saveOrUpdate(jform_leave_hol_dept);

    CgFormFieldEntity jform_leave_hol_reson = new CgFormFieldEntity();

    jform_leave_hol_reson.setFieldName("hol_reson");

    jform_leave_hol_reson.setTable(jform_leave);

    jform_leave_hol_reson.setFieldLength(0);

    jform_leave_hol_reson.setIsKey("N");

    jform_leave_hol_reson.setIsNull("N");

    jform_leave_hol_reson.setIsQuery("N");

    jform_leave_hol_reson.setIsShow("Y");

    jform_leave_hol_reson.setIsShowList("Y");

    jform_leave_hol_reson.setShowType("text");

    jform_leave_hol_reson.setLength(255);

    jform_leave_hol_reson.setType("string");

    jform_leave_hol_reson.setOrderNum(8);

    jform_leave_hol_reson.setPointLength(0);

    jform_leave_hol_reson.setQueryMode("single");

    jform_leave_hol_reson.setContent("请假原因");

    jform_leave_hol_reson.setCreateBy("admin");

    jform_leave_hol_reson.setCreateDate(new Date());

    jform_leave_hol_reson.setCreateName("管理员");

    jform_leave_hol_reson.setDictField("");

    jform_leave_hol_reson.setDictTable("");

    jform_leave_hol_reson.setMainTable("");

    jform_leave_hol_reson.setMainField("");

    commonDao.saveOrUpdate(jform_leave_hol_reson);

    CgFormFieldEntity jform_leave_dep_leader = new CgFormFieldEntity();

    jform_leave_dep_leader.setFieldName("dep_leader");

    jform_leave_dep_leader.setTable(jform_leave);

    jform_leave_dep_leader.setFieldLength(0);

    jform_leave_dep_leader.setIsKey("N");

    jform_leave_dep_leader.setIsNull("N");

    jform_leave_dep_leader.setIsQuery("N");

    jform_leave_dep_leader.setIsShow("Y");

    jform_leave_dep_leader.setIsShowList("Y");

    jform_leave_dep_leader.setShowType("text");

    jform_leave_dep_leader.setLength(20);

    jform_leave_dep_leader.setType("string");

    jform_leave_dep_leader.setOrderNum(9);

    jform_leave_dep_leader.setPointLength(0);

    jform_leave_dep_leader.setQueryMode("single");

    jform_leave_dep_leader.setContent("部门审批人");

    jform_leave_dep_leader.setCreateBy("admin");

    jform_leave_dep_leader.setCreateDate(new Date());

    jform_leave_dep_leader.setCreateName("管理员");

    jform_leave_dep_leader.setDictField("");

    jform_leave_dep_leader.setDictTable("");

    jform_leave_dep_leader.setMainTable("");

    jform_leave_dep_leader.setMainField("");

    commonDao.saveOrUpdate(jform_leave_dep_leader);

    CgFormFieldEntity jform_leave_content = new CgFormFieldEntity();

    jform_leave_content.setFieldName("content");

    jform_leave_content.setTable(jform_leave);

    jform_leave_content.setFieldLength(0);

    jform_leave_content.setIsKey("N");

    jform_leave_content.setIsNull("N");

    jform_leave_content.setIsQuery("N");

    jform_leave_content.setIsShow("Y");

    jform_leave_content.setIsShowList("Y");

    jform_leave_content.setShowType("text");

    jform_leave_content.setLength(255);

    jform_leave_content.setType("string");

    jform_leave_content.setOrderNum(10);

    jform_leave_content.setPointLength(0);

    jform_leave_content.setQueryMode("single");

    jform_leave_content.setContent("部门审批意见");

    jform_leave_content.setCreateBy("admin");

    jform_leave_content.setCreateDate(new Date());

    jform_leave_content.setCreateName("管理员");

    jform_leave_content.setDictField("");

    jform_leave_content.setDictTable("");

    jform_leave_content.setMainTable("");

    jform_leave_content.setMainField("");

    commonDao.saveOrUpdate(jform_leave_content);

    CgFormFieldEntity jform_leave_day_num = new CgFormFieldEntity();

    jform_leave_day_num.setFieldName("day_num");

    jform_leave_day_num.setTable(jform_leave);

    jform_leave_day_num.setFieldLength(120);

    jform_leave_day_num.setIsKey("N");

    jform_leave_day_num.setIsNull("Y");

    jform_leave_day_num.setIsQuery("N");

    jform_leave_day_num.setIsShow("Y");

    jform_leave_day_num.setIsShowList("Y");

    jform_leave_day_num.setShowType("text");

    jform_leave_day_num.setLength(10);

    jform_leave_day_num.setType("int");

    jform_leave_day_num.setOrderNum(6);

    jform_leave_day_num.setPointLength(0);

    jform_leave_day_num.setQueryMode("single");

    jform_leave_day_num.setContent("请假天数");

    jform_leave_day_num.setCreateBy("admin");

    jform_leave_day_num.setCreateDate(new Date());

    jform_leave_day_num.setCreateName("管理员");

    jform_leave_day_num.setDictField("");

    jform_leave_day_num.setDictTable("");

    jform_leave_day_num.setMainTable("");

    jform_leave_day_num.setMainField("");

    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.class, "tableName", "jform_order_customer")

        .get(0);

    CgFormFieldEntity jform_order_customer_id = new CgFormFieldEntity();

    jform_order_customer_id.setFieldName("id");

    jform_order_customer_id.setTable(jform_order_customer);

    jform_order_customer_id.setFieldLength(0);

    jform_order_customer_id.setIsKey("Y");

    jform_order_customer_id.setIsNull("N");

    jform_order_customer_id.setIsQuery("N");

    jform_order_customer_id.setIsShow("N");

    jform_order_customer_id.setIsShowList("N");

    jform_order_customer_id.setShowType("text");

    jform_order_customer_id.setLength(36);

    jform_order_customer_id.setType("string");

    jform_order_customer_id.setOrderNum(0);

    jform_order_customer_id.setPointLength(0);

    jform_order_customer_id.setQueryMode("single");

    jform_order_customer_id.setContent("主键");

    jform_order_customer_id.setCreateBy("admin");

    jform_order_customer_id.setCreateDate(new Date());

    jform_order_customer_id.setCreateName("管理员");

    jform_order_customer_id.setDictField("");

    jform_order_customer_id.setDictTable("");

    jform_order_customer_id.setMainTable("");

    jform_order_customer_id.setMainField("");

    commonDao.saveOrUpdate(jform_order_customer_id);

    CgFormFieldEntity jform_order_customer_name = new CgFormFieldEntity();

    jform_order_customer_name.setFieldName("name");

    jform_order_customer_name.setTable(jform_order_customer);

    jform_order_customer_name.setFieldLength(0);

    jform_order_customer_name.setIsKey("N");

    jform_order_customer_name.setIsNull("Y");

    jform_order_customer_name.setIsQuery("Y");

    jform_order_customer_name.setIsShow("Y");

    jform_order_customer_name.setIsShowList("Y");

    jform_order_customer_name.setShowType("text");

    jform_order_customer_name.setLength(32);

    jform_order_customer_name.setType("string");

    jform_order_customer_name.setOrderNum(1);

    jform_order_customer_name.setPointLength(0);

    jform_order_customer_name.setQueryMode("single");

    jform_order_customer_name.setContent("客户名");

    jform_order_customer_name.setCreateBy("admin");

    jform_order_customer_name.setCreateDate(new Date());

    jform_order_customer_name.setCreateName("管理员");

    jform_order_customer_name.setDictField("");

    jform_order_customer_name.setDictTable("");

    jform_order_customer_name.setMainTable("");

    jform_order_customer_name.setMainField("");

    commonDao.saveOrUpdate(jform_order_customer_name);

    CgFormFieldEntity jform_order_customer_money = new CgFormFieldEntity();

    jform_order_customer_money.setFieldName("money");

    jform_order_customer_money.setTable(jform_order_customer);

    jform_order_customer_money.setFieldLength(0);

    jform_order_customer_money.setIsKey("N");

    jform_order_customer_money.setIsNull("Y");

    jform_order_customer_money.setIsQuery("Y");

    jform_order_customer_money.setIsShow("Y");

    jform_order_customer_money.setIsShowList("Y");

    jform_order_customer_money.setShowType("text");

    jform_order_customer_money.setLength(10);

    jform_order_customer_money.setType("double");

    jform_order_customer_money.setOrderNum(2);

    jform_order_customer_money.setPointLength(2);

    jform_order_customer_money.setQueryMode("group");

    jform_order_customer_money.setContent("单价");

    jform_order_customer_money.setCreateBy("admin");

    jform_order_customer_money.setCreateDate(new Date());

    jform_order_customer_money.setCreateName("管理员");

    jform_order_customer_money.setDictField("");

    jform_order_customer_money.setDictTable("");

    jform_order_customer_money.setMainTable("");

    jform_order_customer_money.setMainField("");

    commonDao.saveOrUpdate(jform_order_customer_money);

    CgFormFieldEntity jform_order_customer_fk_id = new CgFormFieldEntity();

    jform_order_customer_fk_id.setFieldName("fk_id");

    jform_order_customer_fk_id.setTable(jform_order_customer);

    jform_order_customer_fk_id.setFieldLength(120);

    jform_order_customer_fk_id.setIsKey("N");

    jform_order_customer_fk_id.setIsNull("N");

    jform_order_customer_fk_id.setIsQuery("Y");

    jform_order_customer_fk_id.setIsShow("N");

    jform_order_customer_fk_id.setIsShowList("N");

    jform_order_customer_fk_id.setShowType("text");

    jform_order_customer_fk_id.setLength(36);

    jform_order_customer_fk_id.setType("string");

    jform_order_customer_fk_id.setOrderNum(5);

    jform_order_customer_fk_id.setPointLength(0);

    jform_order_customer_fk_id.setQueryMode("single");

    jform_order_customer_fk_id.setContent("外键");

    jform_order_customer_fk_id.setCreateBy("admin");

    jform_order_customer_fk_id.setCreateDate(new Date());

    jform_order_customer_fk_id.setCreateName("管理员");

    jform_order_customer_fk_id.setDictField("");

    jform_order_customer_fk_id.setDictTable("");

    jform_order_customer_fk_id.setMainTable("jform_order_main");

    jform_order_customer_fk_id.setMainField("id");

    commonDao.saveOrUpdate(jform_order_customer_fk_id);

    CgFormFieldEntity jform_order_customer_telphone = new CgFormFieldEntity();

    jform_order_customer_telphone.setFieldName("telphone");

    jform_order_customer_telphone.setTable(jform_order_customer);

    jform_order_customer_telphone.setFieldLength(120);

    jform_order_customer_telphone.setIsKey("N");

    jform_order_customer_telphone.setIsNull("Y");

    jform_order_customer_telphone.setIsQuery("Y");

    jform_order_customer_telphone.setIsShow("Y");

    jform_order_customer_telphone.setIsShowList("Y");

    jform_order_customer_telphone.setShowType("text");

    jform_order_customer_telphone.setLength(32);

    jform_order_customer_telphone.setType("string");

    jform_order_customer_telphone.setOrderNum(4);

    jform_order_customer_telphone.setPointLength(0);

    jform_order_customer_telphone.setQueryMode("single");

    jform_order_customer_telphone.setContent("电话");

    jform_order_customer_telphone.setCreateBy("admin");

    jform_order_customer_telphone.setCreateDate(new Date());

    jform_order_customer_telphone.setCreateName("管理员");

    jform_order_customer_telphone.setDictField("");

    jform_order_customer_telphone.setDictTable("");

    jform_order_customer_telphone.setMainTable("");

    jform_order_customer_telphone.setMainField("");

    commonDao.saveOrUpdate(jform_order_customer_telphone);

    CgFormFieldEntity jform_order_customer_sex = new CgFormFieldEntity();

    jform_order_customer_sex.setFieldName("sex");

    jform_order_customer_sex.setTable(jform_order_customer);

    jform_order_customer_sex.setFieldLength(120);

    jform_order_customer_sex.setIsKey("N");

    jform_order_customer_sex.setIsNull("Y");

    jform_order_customer_sex.setIsQuery("Y");

    jform_order_customer_sex.setIsShow("Y");

    jform_order_customer_sex.setIsShowList("Y");

    jform_order_customer_sex.setShowType("radio");

    jform_order_customer_sex.setLength(4);

    jform_order_customer_sex.setType("string");

    jform_order_customer_sex.setOrderNum(3);

    jform_order_customer_sex.setPointLength(0);

    jform_order_customer_sex.setQueryMode("single");

    jform_order_customer_sex.setContent("性别");

    jform_order_customer_sex.setCreateBy("admin");

    jform_order_customer_sex.setCreateDate(new Date());

    jform_order_customer_sex.setCreateName("管理员");

    jform_order_customer_sex.setDictField("sex");

    jform_order_customer_sex.setDictTable("");

    jform_order_customer_sex.setMainTable("");

    jform_order_customer_sex.setMainField("");

    commonDao.saveOrUpdate(jform_order_customer_sex);

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

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

        0);

    CgFormFieldEntity jform_order_ticket_id = new CgFormFieldEntity();

    jform_order_ticket_id.setFieldName("id");

    jform_order_ticket_id.setTable(jform_order_ticket);

    jform_order_ticket_id.setFieldLength(120);

    jform_order_ticket_id.setIsKey("Y");

    jform_order_ticket_id.setIsNull("N");

    jform_order_ticket_id.setIsQuery("N");

    jform_order_ticket_id.setIsShow("N");

    jform_order_ticket_id.setIsShowList("N");

    jform_order_ticket_id.setShowType("checkbox");

    jform_order_ticket_id.setLength(36);

    jform_order_ticket_id.setType("string");

    jform_order_ticket_id.setOrderNum(0);

    jform_order_ticket_id.setPointLength(0);

    jform_order_ticket_id.setQueryMode("single");

    jform_order_ticket_id.setContent("主键");

    jform_order_ticket_id.setCreateBy("admin");

    jform_order_ticket_id.setCreateDate(new Date());

    jform_order_ticket_id.setCreateName("管理员");

    jform_order_ticket_id.setDictField("");

    jform_order_ticket_id.setDictTable("");

    jform_order_ticket_id.setMainTable("");

    jform_order_ticket_id.setMainField("");

    commonDao.saveOrUpdate(jform_order_ticket_id);

    CgFormFieldEntity jform_order_ticket_ticket_code = new CgFormFieldEntity();

    jform_order_ticket_ticket_code.setFieldName("ticket_code");

    jform_order_ticket_ticket_code.setTable(jform_order_ticket);

    jform_order_ticket_ticket_code.setFieldLength(120);

    jform_order_ticket_ticket_code.setIsKey("N");

    jform_order_ticket_ticket_code.setIsNull("N");

    jform_order_ticket_ticket_code.setIsQuery("Y");

    jform_order_ticket_ticket_code.setIsShow("Y");

    jform_order_ticket_ticket_code.setIsShowList("Y");

    jform_order_ticket_ticket_code.setShowType("text");

    jform_order_ticket_ticket_code.setLength(100);

    jform_order_ticket_ticket_code.setType("string");

    jform_order_ticket_ticket_code.setOrderNum(1);

    jform_order_ticket_ticket_code.setPointLength(0);

    jform_order_ticket_ticket_code.setQueryMode("single");

    jform_order_ticket_ticket_code.setContent("航班号");

    jform_order_ticket_ticket_code.setCreateBy("admin");

    jform_order_ticket_ticket_code.setCreateDate(new Date());

    jform_order_ticket_ticket_code.setCreateName("管理员");

    jform_order_ticket_ticket_code.setDictField("");

    jform_order_ticket_ticket_code.setDictTable("");

    jform_order_ticket_ticket_code.setMainTable("");

    jform_order_ticket_ticket_code.setMainField("");

    commonDao.saveOrUpdate(jform_order_ticket_ticket_code);

    CgFormFieldEntity jform_order_ticket_tickect_date = new CgFormFieldEntity();

    jform_order_ticket_tickect_date.setFieldName("tickect_date");

    jform_order_ticket_tickect_date.setTable(jform_order_ticket);

    jform_order_ticket_tickect_date.setFieldLength(120);

    jform_order_ticket_tickect_date.setIsKey("N");

    jform_order_ticket_tickect_date.setIsNull("N");

    jform_order_ticket_tickect_date.setIsQuery("Y");

    jform_order_ticket_tickect_date.setIsShow("Y");

    jform_order_ticket_tickect_date.setIsShowList("Y");

    jform_order_ticket_tickect_date.setShowType("datetime");

    jform_order_ticket_tickect_date.setLength(10);

    jform_order_ticket_tickect_date.setType("Date");

    jform_order_ticket_tickect_date.setOrderNum(2);

    jform_order_ticket_tickect_date.setPointLength(0);

    jform_order_ticket_tickect_date.setQueryMode("single");

    jform_order_ticket_tickect_date.setContent("航班时间");

    jform_order_ticket_tickect_date.setCreateBy("admin");

    jform_order_ticket_tickect_date.setCreateDate(new Date());

    jform_order_ticket_tickect_date.setCreateName("管理员");

    jform_order_ticket_tickect_date.setDictField("");

    jform_order_ticket_tickect_date.setDictTable("");

    jform_order_ticket_tickect_date.setMainTable("");

    jform_order_ticket_tickect_date.setMainField("");

    commonDao.saveOrUpdate(jform_order_ticket_tickect_date);

    CgFormFieldEntity jform_order_ticket_fck_id = new CgFormFieldEntity();

    jform_order_ticket_fck_id.setFieldName("fck_id");

    jform_order_ticket_fck_id.setTable(jform_order_ticket);

    jform_order_ticket_fck_id.setFieldLength(120);

    jform_order_ticket_fck_id.setIsKey("N");

    jform_order_ticket_fck_id.setIsNull("N");

    jform_order_ticket_fck_id.setIsQuery("N");

    jform_order_ticket_fck_id.setIsShow("N");

    jform_order_ticket_fck_id.setIsShowList("N");

    jform_order_ticket_fck_id.setShowType("text");

    jform_order_ticket_fck_id.setLength(36);

    jform_order_ticket_fck_id.setType("string");

    jform_order_ticket_fck_id.setOrderNum(3);

    jform_order_ticket_fck_id.setPointLength(0);

    jform_order_ticket_fck_id.setQueryMode("single");

    jform_order_ticket_fck_id.setContent("外键");

    jform_order_ticket_fck_id.setCreateBy("admin");

    jform_order_ticket_fck_id.setCreateDate(new Date());

    jform_order_ticket_fck_id.setCreateName("管理员");

    jform_order_ticket_fck_id.setDictField("");

    jform_order_ticket_fck_id.setDictTable("");

    jform_order_ticket_fck_id.setMainTable("jform_order_main");

    jform_order_ticket_fck_id.setMainField("id");

    commonDao.saveOrUpdate(jform_order_ticket_fck_id);

    // 表单[价格认证机构统计表] - 字段清单

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

    CgFormFieldEntity jform_price1_id = new CgFormFieldEntity();

    jform_price1_id.setFieldName("id");

    jform_price1_id.setTable(jform_price1);

    jform_price1_id.setFieldLength(0);

   * @Description 修复智能表单Head数据库

   * @author tanghan 2013-7-28

   */

  private void repairCgFormHead() {

    // order_main.setJsPlugIn("0");

    // order_main.setSqlPlugIn("0");

    commonDao.saveOrUpdate(order_main);

    // leave.setJsPlugIn("0");

    // leave.setSqlPlugIn("0");

    commonDao.saveOrUpdate(leave);

//    cgreport_head.setTableName("jform_cgreport_head");

//    cgreport_head.setIsTree("N");

//    cgreport_head.setIsPagination("Y");

//    cgreport_head.setIsCheckbox("N");

//    cgreport_head.setQuerymode("single");

//    cgreport_head.setIsDbSynch("N");

//    cgreport_head.setContent("动态报表配置抬头");

//    cgreport_head.setCreateBy("admin");

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

    /*

     * cgreport_head.setJsPlugIn("$(function(){"+"\r\n" +

     * "$(\"body\").append(\"<link href=\\\"plug-in/lhgDialog/skins/default.css\\\" rel=\\\"stylesheet\\\" id=\\\"lhgdialoglink\\\">\");"

     * +"\r\n" +

     * "var $btn = $(\"<div class=\\\"ui_buttons\\\"  style=\\\"display:inline-block;\\\"><input style=\\\"position: relative;top: -8px;\\\" class=\\\"ui_state_highlight\\\" type=\\\"button\\\" value=\\\"sql解析\\\"        id=\\\"sqlAnalyze\\\" /></div>\");"

     * +"\r\n" +"$(\"#cgr_sql\").after($btn);"+"\r\n"

     * +"$btn.click(function(){"+"\r\n" +" $.ajax({"+"\r\n"

     * +"     url:\"cgReportController.do?getFields\","+"\r\n"

     * +"    data:{sql:$(\"#cgr_sql\").val()},"+"\r\n"

     * +"   type:\"Post\","+"\r\n" +"    dataType:\"json\","+"\r\n"

     * +"    success:function(data){"+"\r\n"

     * +"      if(data.status==\"success\"){"+"\r\n"

     * +"         $(\"#add_jform_cgreport_item_table\").empty();"+"\r\n"

     * +"      $.each(data.datas,function(index,e){"+"\r\n" +

     * "        var $tr = $(\"#add_jform_cgreport_item_table_template tr\").clone();"

     * +"\r\n" +"      $tr.find(\"td:eq(1) :text\").val(e);"+"\r\n"

     * +"       $tr.find(\"td:eq(2) :text\").val(index);"+"\r\n"

     * +"       $tr.find(\"td:eq(3) :text\").val(e);"+"\r\n"

     * +"       $(\"#add_jform_cgreport_item_table\").append($tr);"+"\r\n"

     * +"      }); "+"\r\n"

     * +"    resetTrNum(\"add_jform_cgreport_item_table\");"+"\r\n"

     * +"    }"+"\r\n" +"  }"+"\r\n" +"  });"+"\r\n" +" });"+"\r\n" +"});");

     * cgreport_head.setSqlPlugIn("0");

     */

//    cgreport_head.setJformVersion("87");

//    cgreport_head.setJformType(2);

//    cgreport_head.setRelationType(0);

//    cgreport_head.setSubTableStr("jform_cgreport_item");

//    /* cgreport_head.setSqlPlugIn("select * from t_s_user"); */

//

//    commonDao.saveOrUpdate(cgreport_head);

//

//    CgFormHeadEntity cgreport_item = new CgFormHeadEntity();

//    cgreport_item.setTableName("jform_cgreport_item");

//    cgreport_item.setIsTree("N");

//    cgreport_item.setIsPagination("Y");

//    cgreport_item.setIsCheckbox("N");

//    cgreport_item.setQuerymode("single");

//    cgreport_item.setIsDbSynch("N");

//    cgreport_item.setContent("动态报表配置明细");

//    cgreport_item.setCreateBy("admin");

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

//    /*

//     * cgreport_item.setJsPlugIn("0"); cgreport_item.setSqlPlugIn("0");

//     */

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

//    cgreport_item.setJformVersion("12");

//    cgreport_item.setJformType(3);

//    cgreport_item.setRelationType(0);

//    commonDao.saveOrUpdate(cgreport_item);

    /*

     * customer.setJsPlugIn("alert(' hello world ');");

     * customer.setSqlPlugIn("0");

     */

    commonDao.saveOrUpdate(customer);

    /*

     * ticket.setJsPlugIn(

     * "$(\"input/[name=\'name\']\").change( function() { \r\n 这里可以写些验证代码 \r\n  var name = $(\"#name\").val();  \r\nalert(name);});"

     * ); ticket.setSqlPlugIn("0");

     */

    commonDao.saveOrUpdate(ticket);

    /*

     * price1.setJsPlugIn("0"); price1.setSqlPlugIn("0");

     */

    commonDao.saveOrUpdate(price1);

  }