Пример #1
0
  private static HashMap queryRetailMeas(String[] invids, String pk_corp) throws BusinessException {

    String currency = new SysInitBO().getPkValue(pk_corp, "BD301");
    StringBuffer sql =
        new StringBuffer("select distinct cinvbasdocid as cinvbasid ,cmeasdocid as pk_measdoc  ");
    sql.append(" from prm_tariffcurlist prm ,  bd_invmandoc man ");
    // sql.append(" left outer join bd_convert con on
    // bas.pk_invbasdoc=con.pk_invbasdoc ");
    sql.append(
        " where prm.cinventoryid=man.pk_invmandoc and man.pk_corp='"
            + pk_corp
            + "' and prm.ccurrencyid='"
            + currency
            + "'"
            + SQLUtil.formInSQL("man.pk_invbasdoc", invids));

    HashMap hmData = new HashMap();
    ArrayList alinv = null;
    try {
      InvVO[] voInvs = (InvVO[]) new SmartDMO().selectBySql(sql.toString(), InvVO.class);

      if (voInvs != null && voInvs.length > 0) {
        for (int i = 0; i < voInvs.length; i++) {

          if (!hmData.containsKey(voInvs[i].getCinvbasid())) {

            hmData.put(voInvs[i].getCinvbasid(), voInvs[i].getPk_measdoc());
          }
        }
      }
    } catch (Exception e) {
      throw new BusinessException();
    }
    return hmData;
  }
Пример #2
0
  private static HashMap queryInvVos(String[] invids) throws BusinessException {
    StringBuffer sql =
        new StringBuffer(
            "select bas.pk_invbasdoc as cinvbasid, bas.invcode ,bas.pk_measdoc as pk_measdoc,assistunit,con.pk_measdoc as cassistunitid ,con.mainmeasrate  ");
    sql.append(" from bd_invbasdoc bas ");
    sql.append("  left outer join bd_convert con on bas.pk_invbasdoc=con.pk_invbasdoc ");
    sql.append(" where 1=1 " + SQLUtil.formInSQL("bas.pk_invbasdoc", invids));

    HashMap hmData = new HashMap();
    ArrayList alinv = null;
    try {
      InvVO[] voInvs = (InvVO[]) new SmartDMO().selectBySql(sql.toString(), InvVO.class);

      if (voInvs != null && voInvs.length > 0) {
        for (int i = 0; i < voInvs.length; i++) {
          if (hmData.containsKey(voInvs[i].getCinvbasid())) {
            alinv = (ArrayList) hmData.get(voInvs[i].getCinvbasid());
          } else {
            alinv = new ArrayList();
            hmData.put(voInvs[i].getCinvbasid(), alinv);
          }

          alinv.add(voInvs[i]);
        }
      }
    } catch (Exception e) {
      throw new BusinessException();
    }
    return hmData;
  }
Пример #3
0
  public static void convertFreeValue(String pk_corp, IFreeField[] voItems)
      throws BusinessException {

    if (voItems == null || voItems.length == 0) return;

    HashMap<String, String> hmInv = new HashMap<String, String>();
    for (int i = 0; i < voItems.length; i++) {
      String invid = voItems[i].getInvBasID();
      hmInv.put(invid, invid);
    }

    String[] invids = new String[hmInv.size()];
    hmInv.keySet().toArray(invids);

    String sql =
        " select pk_invbasdoc,bas.free1,bas.free2,bas.free3,bas.free4,bas.free5 from bd_invbasdoc bas where  coalesce(bas.free1,bas.free2,bas.free3,bas.free4,bas.free5,'ZZ') !='ZZ' ";
    sql = sql + SQLUtil.formInSQL("pk_invbasdoc", invids);

    Object[] values = null;
    try {
      values = new SmartDMO().selectBy2(sql);
    } catch (Exception e) {
      SCMEnv.out(e);
      throw new BusinessException(e.getMessage());
    }

    FreeVO voFree = null;
    HashMap<String, FreeVO> hmFree = new HashMap<String, FreeVO>();
    if (values != null) {
      for (int i = 0; i < values.length; i++) {
        Object[] itemValues = (Object[]) values[i];

        voFree = new FreeVO();
        voFree.setPk_invbasdoc((String) itemValues[0]);
        voFree.setVfreeid1((String) itemValues[1]);
        voFree.setVfreeid2((String) itemValues[2]);
        voFree.setVfreeid3((String) itemValues[3]);
        voFree.setVfreeid4((String) itemValues[4]);
        voFree.setVfreeid5((String) itemValues[5]);

        hmFree.put(voFree.getPk_invbasdoc(), voFree);
      }
    }

    HashMap hmPara = getParaFreeAndPosMap(pk_corp);

    for (int i = 0; i < voItems.length; i++) {
      String invid = voItems[i].getInvBasID();
      Object[] ncvalues = new Object[5];
      Object[] retailvalues = voItems[i].getRetailFreeValue();

      if (hmFree.containsKey(invid)) {
        voFree = (FreeVO) hmFree.get(invid);

        int count = 0;
        for (int j = 0; j < 5; j++) {
          String key = (String) voFree.getAttributeValue("vfreeid" + String.valueOf(j + 1));
          if (key != null) count = count + 1;
          if (hmPara.containsKey(key)) {
            ncvalues[j] = retailvalues[((Integer) hmPara.get(key)).intValue() - 1];
          } else ncvalues[j] = null;
          if (ncvalues[j] != null) count = count - 1;
        }

        voItems[i].setNCFreeValue(ncvalues);

        if (count != 0) throw new BusinessException("请检查自由项值的正确性!");

      } else voItems[i].setNCFreeValue(null);
    }
  }