panel.java~4~

银行信用评估系统

    column22.setSqlType(4);
    column82.setCaption("其他婚姻状况");
    column82.setColumnName("OtherMarry");
    column82.setDataType(com.borland.dx.dataset.Variant.INT);
    column82.setSchemaName("dbo");
    column82.setTableName("UserList");
    column82.setServerColumnName("OtherMarry");
    column82.setSqlType(4);
    column83.setCaption("研究生以上");
    column83.setColumnName("GraduateS");
    column83.setDataType(com.borland.dx.dataset.Variant.INT);
    column83.setSchemaName("dbo");
    column83.setTableName("UserList");
    column83.setServerColumnName("GraduateS");
    column83.setSqlType(4);
    column84.setCaption("本科");
    column84.setColumnName("UnGraduateS");
    column84.setDataType(com.borland.dx.dataset.Variant.INT);
    column84.setSchemaName("dbo");
    column84.setTableName("UserList");
    column84.setServerColumnName("UnGraduateS");
    column84.setSqlType(4);
    column85.setCaption("大专");
    column85.setColumnName("Junior");
    column85.setDataType(com.borland.dx.dataset.Variant.INT);
    column85.setSchemaName("dbo");
    column85.setTableName("UserList");
    column85.setServerColumnName("Junior");
    column85.setSqlType(4);
    column86.setCaption("中专 高中");
    column86.setColumnName("Intermediate");
    column86.setDataType(com.borland.dx.dataset.Variant.INT);
    column86.setSchemaName("dbo");
    column86.setTableName("UserList");
    column86.setServerColumnName("Intermediate");
    column86.setSqlType(4);
    column87.setCaption("其他学历情况");
    column87.setColumnName("OtherKnowledge");
    column87.setDataType(com.borland.dx.dataset.Variant.INT);
    column87.setSchemaName("dbo");
    column87.setTableName("UserList");
    column87.setServerColumnName("OtherKnowledge");
    column87.setSqlType(4);
    column88.setCaption("常住户口");
    column88.setColumnName("Cregistered");
    column88.setDataType(com.borland.dx.dataset.Variant.INT);
    column88.setSchemaName("dbo");
    column88.setTableName("UserList");
    column88.setServerColumnName("Cregistered");
    column88.setSqlType(4);
    column89.setCaption("临时户口");
    column89.setColumnName("Lregistere");
    column89.setDataType(com.borland.dx.dataset.Variant.INT);
    column89.setSchemaName("dbo");
    column89.setTableName("UserList");
    column89.setServerColumnName("Lregistere");
    column89.setSqlType(4);
    column90.setCaption("自有住房");
    column90.setColumnName("HaveHouse");
    column90.setDataType(com.borland.dx.dataset.Variant.INT);
    column90.setSchemaName("dbo");
    column90.setTableName("UserList");
    column90.setServerColumnName("HaveHouse");
    column90.setSqlType(4);
    column91.setCaption("贷款购房");
    column91.setColumnName("LoanBuyHouse");
    column91.setDataType(com.borland.dx.dataset.Variant.INT);
    column91.setSchemaName("dbo");
    column91.setTableName("UserList");
    column91.setServerColumnName("LoanBuyHouse");
    column91.setSqlType(4);
    column92.setCaption("租用公房");
    column92.setColumnName("RentHouse");
    column92.setDataType(com.borland.dx.dataset.Variant.INT);
    column92.setSchemaName("dbo");
    column92.setTableName("UserList");
    column92.setServerColumnName("RentHouse");
    column92.setSqlType(4);
    column93.setCaption("其他住宅 情况");
    column93.setColumnName("OtherHouse");
    column93.setDataType(com.borland.dx.dataset.Variant.INT);
    column93.setSchemaName("dbo");
    column93.setTableName("UserList");
    column93.setServerColumnName("OtherHouse");
    column93.setSqlType(4);
    queryDataSet1.setColumns(new Column[] {column2, column4, column6, column8, column10, column12, column14, column16, column18, column20, column22,
        column82, column83, column84, column85, column86, column87, column88, column89, column90, column91, column92, column93});
    queryDataSet2.setColumns(new Column[] {column23, column25, column27, column29, column31, column33, column35, column37, column39, column41, column43,
        column45, column47, column49, column51, column53});
    queryDataSet2.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database2, "SELECT ProfessionThing.ID,ProfessionThing.Gwy,ProfessionThing.Jshys,ProfessionThing.Jrhls,ProfessionT" +
      "hing.Jrhjz,ProfessionThing.Qyzhgszy,ProfessionThing.Qtzy,ProfessionThing.Gz5n,ProfessionThing.Gz3_5n," +
      "ProfessionThing.Gz1_3n,ProfessionThing.Gzxy1n,ProfessionThing.Tjys,ProfessionThing.Cj,ProfessionThing" +
      ".Kj,ProfessionThing.Ybgjgb,ProfessionThing.Qtgjgb,ProfessionThing.Zfzjl,ProfessionThing.Bmjl,Professi" +
      "onThing.Ybqygb,ProfessionThing.Qtqyzy,ProfessionThing.Gj,ProfessionThing.Zj,ProfessionThing.Cjj,Profe" +
      "ssionThing.Mei,ProfessionThing.Ysr10000,ProfessionThing.Ysr8000,ProfessionThing.Ysr5000,ProfessionThi" +
      "ng.Ysr4000,ProfessionThing.Ysr3000,ProfessionThing.Ysr2000,ProfessionThing.Ysr1000,ProfessionThing.Ys" +
      "rxy1000 FROM CCES.dbo.ProfessionThing", null, true, Load.ALL));
    column24.setColumnName("ID");
    column24.setDataType(com.borland.dx.dataset.Variant.INT);
    column24.setRowId(true);
    column24.setSchemaName("dbo");
    column24.setTableName("ProfessionThing");
    column24.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column24.setServerColumnName("ID");
    column24.setSqlType(4);
    column26.setCaption("公务员");
    column26.setColumnName("Gwy");
    column26.setDataType(com.borland.dx.dataset.Variant.INT);
    column26.setSchemaName("dbo");
    column26.setTableName("ProfessionThing");
    column26.setServerColumnName("Gwy");
    column26.setSqlType(4);
    column28.setCaption("教师 医生");
    column28.setColumnName("Jshys");
    column28.setDataType(com.borland.dx.dataset.Variant.INT);
    column28.setSchemaName("dbo");
    column28.setTableName("ProfessionThing");
    column28.setServerColumnName("Jshys");
    column28.setSqlType(4);
    column30.setCaption("金融 律师");
    column30.setColumnName("Jrhls");
    column30.setDataType(com.borland.dx.dataset.Variant.INT);
    column30.setSchemaName("dbo");
    column30.setTableName("ProfessionThing");
    column30.setServerColumnName("Jrhls");
    column30.setSqlType(4);
    column32.setCaption("军人 记者");
    column32.setColumnName("Jrhjz");
    column32.setDataType(com.borland.dx.dataset.Variant.INT);
    column32.setSchemaName("dbo");
    column32.setTableName("ProfessionThing");
    column32.setServerColumnName("Jrhjz");
    column32.setSqlType(4);
    column34.setCaption("企业主 公司职员");
    column34.setColumnName("Qyzhgszy");
    column34.setDataType(com.borland.dx.dataset.Variant.INT);
    column34.setSchemaName("dbo");
    column34.setTableName("ProfessionThing");
    column34.setServerColumnName("Qyzhgszy");
    column34.setSqlType(4);
    column36.setCaption("其他职业");
    column36.setColumnName("Qtzy");
    column36.setDataType(com.borland.dx.dataset.Variant.INT);
    column36.setSchemaName("dbo");
    column36.setTableName("ProfessionThing");
    column36.setServerColumnName("Qtzy");
    column36.setSqlType(4);
    column38.setCaption("现单位5年以上");
    column38.setColumnName("Gz5n");
    column38.setDataType(com.borland.dx.dataset.Variant.INT);
    column38.setSchemaName("dbo");
    column38.setTableName("ProfessionThing");
    column38.setServerColumnName("Gz5n");
    column38.setSqlType(4);
    column40.setCaption("现单位3-5年");
    column40.setColumnName("Gz3_5n");
    column40.setDataType(com.borland.dx.dataset.Variant.INT);
    column40.setSchemaName("dbo");
    column40.setTableName("ProfessionThing");
    column40.setServerColumnName("Gz3_5n");
    column40.setSqlType(4);
    column42.setCaption("现单位1-3年");
    column42.setColumnName("Gz1_3n");
    column42.setDataType(com.borland.dx.dataset.Variant.INT);
    column42.setSchemaName("dbo");
    column42.setTableName("ProfessionThing");
    column42.setServerColumnName("Gz1_3n");
    column42.setSqlType(4);
    column44.setCaption("现单位1年内");
    column44.setColumnName("Gzxy1n");
    column44.setDataType(com.borland.dx.dataset.Variant.INT);
    column44.setSchemaName("dbo");
    column44.setTableName("ProfessionThing");
    column44.setServerColumnName("Gzxy1n");
    column44.setSqlType(4);
    column46.setCaption("机关厅局级以上");
    column46.setColumnName("Tjys");
    column46.setDataType(com.borland.dx.dataset.Variant.INT);
    column46.setSchemaName("dbo");
    column46.setTableName("ProfessionThing");
    column46.setServerColumnName("Tjys");
    column46.setSqlType(4);
    column48.setCaption("机关处级");
    column48.setColumnName("Cj");
    column48.setDataType(com.borland.dx.dataset.Variant.INT);
    column48.setSchemaName("dbo");
    column48.setTableName("ProfessionThing");
    column48.setServerColumnName("Cj");
    column48.setSqlType(4);
    column50.setCaption("机关科级");
    column50.setColumnName("Kj");
    column50.setDataType(com.borland.dx.dataset.Variant.INT);
    column50.setSchemaName("dbo");
    column50.setTableName("ProfessionThing");
    column50.setServerColumnName("Kj");
    column50.setSqlType(4);
    column52.setCaption("机关一般干部");
    column52.setColumnName("Ybgjgb");
    column52.setDataType(com.borland.dx.dataset.Variant.INT);
    column52.setSchemaName("dbo");
    column52.setTableName("ProfessionThing");
    column52.setServerColumnName("Ybgjgb");
    column52.setSqlType(4);
    column94.setCaption("机关其他干部");
    column94.setColumnName("Qtgjgb");
    column94.setDataType(com.borland.dx.dataset.Variant.INT);
    column94.setSchemaName("dbo");
    column94.setTableName("ProfessionThing");
    column94.setServerColumnName("Qtgjgb");
    column94.setSqlType(4);
    column95.setCaption("企业正副经理");
    column95.setColumnName("Zfzjl");
    column95.setDataType(com.borland.dx.dataset.Variant.INT);
    column95.setSchemaName("dbo");
    column95.setTableName("ProfessionThing");
    column95.setServerColumnName("Zfzjl");
    column95.setSqlType(4);
    column96.setCaption("企业部门经理");
    column96.setColumnName("Bmjl");
    column96.setDataType(com.borland.dx.dataset.Variant.INT);
    column96.setSchemaName("dbo");
    column96.setTableName("ProfessionThing");
    column96.setServerColumnName("Bmjl");
    column96.setSqlType(4);
    column97.setCaption("企业一般干部");
    column97.setColumnName("Ybqygb");
    column97.setDataType(com.borland.dx.dataset.Variant.INT);
    column97.setSchemaName("dbo");
    column97.setTableName("ProfessionThing");
    column97.setServerColumnName("Ybqygb");
    column97.setSqlType(4);
    column98.setCaption("企业其他干部");
    column98.setColumnName("Qtqyzy");
    column98.setDataType(com.borland.dx.dataset.Variant.INT);
    column98.setSchemaName("dbo");
    column98.setTableName("ProfessionThing");
    column98.setServerColumnName("Qtqyzy");
    column98.setSqlType(4);
    column99.setCaption("职称高级");
    column99.setColumnName("Gj");
    column99.setDataType(com.borland.dx.dataset.Variant.INT);
    column99.setSchemaName("dbo");
    column99.setTableName("ProfessionThing");
    column99.setServerColumnName("Gj");
    column99.setSqlType(4);
    column100.setCaption("职称中级");
    column100.setColumnName("Zj");
    column100.setDataType(com.borland.dx.dataset.Variant.INT);
    column100.setSchemaName("dbo");
    column100.setTableName("ProfessionThing");
    column100.setServerColumnName("Zj");
    column100.setSqlType(4);
    column101.setCaption("职称初级");
    column101.setColumnName("Cjj");
    column101.setDataType(com.borland.dx.dataset.Variant.INT);
    column101.setSchemaName("dbo");
    column101.setTableName("ProfessionThing");
    column101.setServerColumnName("Cjj");
    column101.setSqlType(4);
    column102.setCaption("无职称");
    column102.setColumnName("Mei");
    column102.setDataType(com.borland.dx.dataset.Variant.INT);
    column102.setSchemaName("dbo");
    column102.setTableName("ProfessionThing");
    column102.setServerColumnName("Mei");
    column102.setSqlType(4);
    column103.setCaption("个人月收入10000以上");
    column103.setColumnName("Ysr10000");
    column103.setDataType(com.borland.dx.dataset.Variant.INT);
    column103.setSchemaName("dbo");
    column103.setTableName("ProfessionThing");
    column103.setServerColumnName("Ysr10000");
    column103.setSqlType(4);
    column104.setCaption("个人月收入8000-10000");
    column104.setColumnName("Ysr8000");
    column104.setDataType(com.borland.dx.dataset.Variant.INT);
    column104.setSchemaName("dbo");
    column104.setTableName("ProfessionThing");
    column104.setServerColumnName("Ysr8000");
    column104.setSqlType(4);
    column105.setCaption("个人月收入5000-8000");
    column105.setColumnName("Ysr5000");
    column105.setDataType(com.borland.dx.dataset.Variant.INT);
    column105.setSchemaName("dbo");
    column105.setTableName("ProfessionThing");
    column105.setServerColumnName("Ysr5000");
    column105.setSqlType(4);
    column106.setCaption("个人月收入4000-5000");
    column106.setColumnName("Ysr4000");
    column106.setDataType(com.borland.dx.dataset.Variant.INT);
    column106.setSchemaName("dbo");
    column106.setTableName("ProfessionThing");
    column106.setServerColumnName("Ysr4000");
    column106.setSqlType(4);
    column107.setCaption("个人月收入3000-4000");
    column107.setColumnName("Ysr3000");
    column107.setDataType(com.borland.dx.dataset.Variant.INT);
    column107.setSchemaName("dbo");
    column107.setTableName("ProfessionThing");
    column107.setServerColumnName("Ysr3000");
    column107.setSqlType(4);
    column108.setCaption("个人月收入2000-3000");
    column108.setColumnName("Ysr2000");
    column108.setDataType(com.borland.dx.dataset.Variant.INT);
    column108.setSchemaName("dbo");
    column108.setTableName("ProfessionThing");
    column108.setServerColumnName("Ysr2000");
    column108.setSqlType(4);
    column109.setCaption("30\t个人月收入1000-2000");
    column109.setColumnName("Ysr1000");