コード例 #1
0
  public ExcelVO initExcelRefInfo(Map valueMap) {
    // TODO Auto-generated method stub
    ExcelVO evo = new ExcelVO();
    evo.setParentVO(ProjDecisionVO.class.getName());

    ExcelHeadMessage excelHeadMessage = new ExcelHeadMessage();
    excelHeadMessage.setBiaoTi("采购决策");
    excelHeadMessage.setBiaoSize(14);
    excelHeadMessage.setBold(true);

    MulHeadMessage mhm = new MulHeadMessage();
    mhm.setHeadMessage("采购方案");
    excelHeadMessage.addMulHeadMessage(mhm);
    mhm.setBiaoSize(10);
    mhm.setBold(true);
    mhm.setRowWidth(10);

    mhm = new MulHeadMessage();
    mhm.setHeadMessage("项目编码");
    excelHeadMessage.addMulHeadMessage(mhm);
    mhm.setBiaoSize(10);
    mhm.setBold(true);
    mhm.setRowWidth(10);

    mhm = new MulHeadMessage();
    mhm.setHeadMessage("项目名称");
    excelHeadMessage.addMulHeadMessage(mhm);
    mhm.setBiaoSize(10);
    mhm.setBold(true);
    mhm.setRowWidth(10);

    mhm = new MulHeadMessage();
    mhm.setHeadMessage("采购方式");
    excelHeadMessage.addMulHeadMessage(mhm);
    mhm.setBiaoSize(10);
    mhm.setBold(true);
    mhm.setRowWidth(10);

    mhm = new MulHeadMessage();
    mhm.setHeadMessage("预算金额(元)");
    excelHeadMessage.addMulHeadMessage(mhm);
    mhm.setBiaoSize(10);
    mhm.setBold(true);
    mhm.setRowWidth(13);

    mhm = new MulHeadMessage();
    mhm.setHeadMessage("制单日期");
    excelHeadMessage.addMulHeadMessage(mhm);
    mhm.setBiaoSize(10);
    mhm.setBold(true);
    mhm.setRowWidth(13);

    evo.setExcelHeadMessage(excelHeadMessage);

    evo.setPShowPageName("采购决策");

    String[] pShowFileds = {"采购方案", "项目编码", "项目名称", "采购方式", "预算金额(元)", "制单日期"};

    String[] pGetFileds = {
      ProjDecisionVO.PK_XY_PROJ_MAIN,
      ProjDecisionVO.PK_XY_PROJ_MAIN,
      ProjDecisionVO.PK_XY_PROJ_MAIN,
      ProjDecisionVO.PK_XY_PROJ_MAIN,
      ProjDecisionVO.PK_XY_PROJ_MAIN,
      ProjDecisionVO.OPERATEDATE
    };

    evo.setParentGetFields(pGetFileds);
    evo.setParentShowFields(pShowFileds);

    String[] sPageName = {"确认明细", "专家信息", "评分汇总", "推荐供应商"};
    String[] m_items = {
      ProjItemProdCfmVO.class.getName(),
      ProjExpertSubVO.class.getName(),
      ExpertEvalResultVO.class.getName(),
      ProjItemSupCfmVO.class.getName()
    };

    evo.setItemShowPageName(sPageName);
    evo.setM_itemVos(m_items);

    List<String[]> showName = new ArrayList<String[]>();
    List<String[]> getName = new ArrayList<String[]>();

    // 确认明细信息

    String[] sShowName1 = {"产品/服务名称", "规格", "目录外产品", "单位", "数量", "有关说明"};
    String[] sGetName1 = {
      ProjItemProdCfmVO.PK_DA_PROD,
      ProjItemProdCfmVO.PK_DA_PROD,
      ProjItemProdCfmVO.PROJ_REQ_DESC,
      ProjItemProdCfmVO.PROD_UNIT,
      ProjItemProdCfmVO.PROD_QUANTITY,
      ProjItemProdCfmVO.MESSAGE
    };

    showName.add(sShowName1);
    getName.add(sGetName1);

    // 专家信息
    String[] sShowName2 = {"专家姓名", "所属机构", "所属部门", "专家分类", "专家抽取方式", "联系电话", "EMAIL"};
    String[] sGetName2 = {
      ProjExpertSubVO.PK_DA_EXPERT_MAIN,
      ProjExpertSubVO.PK_DA_EXPERT_MAIN,
      ProjExpertSubVO.PK_DA_EXPERT_MAIN,
      ProjExpertSubVO.PK_DA_EXPERT_MAIN,
      ProjExpertSubVO.EXPERT_SEL_MODE,
      ProjExpertSubVO.PK_DA_EXPERT_MAIN,
      ProjExpertSubVO.PK_DA_EXPERT_MAIN
    };

    showName.add(sShowName2);
    getName.add(sGetName2);

    // 推荐供应商

    String[] sShowName4 = {"是否推荐", "供应商名称", "供应商类型", "推荐为中标供应商理由"};
    String[] sGetName4 = {
      ProjItemSupCfmVO.IS_HIT_SUPPLIER,
      ProjItemSupCfmVO.PK_SUPPLIER,
      ProjItemSupCfmVO.SUPPLIER_TYPE,
      ProjItemSupCfmVO.REASON
    };

    showName.add(sShowName4);
    getName.add(sGetName4);

    evo.putIsQueryMap(ProjItemProdCfmVO.class.getName(), new Boolean(false));
    evo.putIsQueryMap(ProjExpertSubVO.class.getName(), new Boolean(false));
    evo.putIsQueryMap(ExpertEvalResultVO.class.getName(), new Boolean(false));
    evo.putIsQueryMap(ProjItemSupCfmVO.class.getName(), new Boolean(false));

    // 产品信息设置
    setProdMes(evo);

    // 专家信息设置
    setExpertMess(evo);

    setSupplierMes(evo);

    evo.setItemGetFields(getName);
    evo.setItemShowFields(showName);

    return evo;
  }