whcollection_frm.java

库存管理信息系统

    column7.setSqlType(4);
    column8.setColumnName("出库数量");
    column8.setDataType(com.borland.dx.dataset.Variant.BIGDECIMAL);
    column8.setTableName("whgoods");
    column8.setServerColumnName("osamount");
    column8.setSqlType(4);
    column9.setAgg(new com.borland.dx.dataset.AggDescriptor( (String[])null,
        "入库数量", new com.borland.dx.dataset.SumAggOperator()));
    column9.setCalcType(com.borland.dx.dataset.CalcType.AGGREGATE);
    column9.setColumnName("入库总");
    column9.setDataType(com.borland.dx.dataset.Variant.BIGDECIMAL);
    column9.setPreferredOrdinal(13);
    column9.setServerColumnName("NewColumn1");
    column9.setSqlType(0);
    column10.setAgg(new com.borland.dx.dataset.AggDescriptor( (String[])null,
        "出库数量", new com.borland.dx.dataset.SumAggOperator()));
    column10.setCalcType(com.borland.dx.dataset.CalcType.AGGREGATE);
    column10.setColumnName("出库总");
    column10.setDataType(com.borland.dx.dataset.Variant.BIGDECIMAL);
    column10.setPreferredOrdinal(14);
    column10.setServerColumnName("NewColumn2");
    column10.setSqlType(0);
    column11.setCalcType(com.borland.dx.dataset.CalcType.CALC);
    column11.setColumnName("期价");
    column11.setDataType(com.borland.dx.dataset.Variant.BIGDECIMAL);
    column11.setPreferredOrdinal(15);
    column11.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column11.setServerColumnName("NewColumn1");
    column11.setSqlType(0);
    column12.setCalcType(com.borland.dx.dataset.CalcType.CALC);
    column12.setColumnName("入价");
    column12.setDataType(com.borland.dx.dataset.Variant.BIGDECIMAL);
    column12.setPreferredOrdinal(16);
    column12.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column12.setServerColumnName("NewColumn2");
    column12.setSqlType(0);
    column13.setCalcType(com.borland.dx.dataset.CalcType.CALC);
    column13.setCaption("NewColumn1");
    column13.setColumnName("出价");
    column13.setDataType(com.borland.dx.dataset.Variant.BIGDECIMAL);
    column13.setPreferredOrdinal(17);
    column13.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column13.setServerColumnName("NewColumn1");
    column13.setSqlType(0);
    column14.setAgg(new com.borland.dx.dataset.AggDescriptor( (String[])null,
        "期价", new com.borland.dx.dataset.SumAggOperator()));
    column14.setCalcType(com.borland.dx.dataset.CalcType.AGGREGATE);
    column14.setColumnName("期价总");
    column14.setDataType(com.borland.dx.dataset.Variant.BIGDECIMAL);
    column14.setPreferredOrdinal(18);
    column14.setServerColumnName("NewColumn1");
    column14.setSqlType(0);
    column15.setAgg(new com.borland.dx.dataset.AggDescriptor( (String[])null,
        "入价", new com.borland.dx.dataset.SumAggOperator()));
    column15.setCalcType(com.borland.dx.dataset.CalcType.AGGREGATE);
    column15.setColumnName("入价总");
    column15.setDataType(com.borland.dx.dataset.Variant.BIGDECIMAL);
    column15.setPreferredOrdinal(20);
    column15.setServerColumnName("NewColumn2");
    column15.setSqlType(0);
    column16.setAgg(new com.borland.dx.dataset.AggDescriptor( (String[])null,
        "出库价格", new com.borland.dx.dataset.SumAggOperator()));
    column16.setCalcType(com.borland.dx.dataset.CalcType.AGGREGATE);
    column16.setColumnName("出价总");
    column16.setDataType(com.borland.dx.dataset.Variant.BIGDECIMAL);
    column16.setPreferredOrdinal(19);
    column16.setServerColumnName("NewColumn1");
    column16.setSqlType(0);
    jTextField1.setText("");
    column17.setCalcType(com.borland.dx.dataset.CalcType.CALC);
    column17.setColumnName("单库存");
    column17.setDataType(com.borland.dx.dataset.Variant.BIGDECIMAL);
    column17.setPreferredOrdinal(21);
    column17.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column17.setServerColumnName("NewColumn1");
    column17.setSqlType(0);
    column18.setAgg(new com.borland.dx.dataset.AggDescriptor(new String[] {
        "货物代码"}
        , "单库存", new com.borland.dx.dataset.SumAggOperator()));
    column18.setCalcType(com.borland.dx.dataset.CalcType.AGGREGATE);
    column18.setColumnName("库存总");
    column18.setDataType(com.borland.dx.dataset.Variant.BIGDECIMAL);
    column18.setPreferredOrdinal(22);
    column18.setServerColumnName("NewColumn1");
    column18.setSqlType(0);
    contentPane.add(jScrollPane1, new XYConstraints(19, 37, 179, 330));
    contentPane.add(jLabel1, new XYConstraints(20, 13, 137, -1));
    contentPane.add(jLabel2, new XYConstraints(222, 16, 208, -1));
    contentPane.add(tableScrollPane1, new XYConstraints(214, 69, 379, 224));
    contentPane.add(jPanel1, new XYConstraints(214, 292, 379, 75));
    jPanel1.add(jLabel6, new XYConstraints(294, 2, -1, -1));
    jPanel1.add(jLabel7, new XYConstraints(8, 46, -1, -1));
    jPanel1.add(jdbTextField5, new XYConstraints(171, 43, 74, -1));
    jPanel1.add(jdbTextField6, new XYConstraints(268, 43, 74, -1));
    jPanel1.add(jLabel3, new XYConstraints(8, 22, -1, -1));
    jPanel1.add(jLabel4, new XYConstraints(98, 2, -1, -1));
    jPanel1.add(jLabel5, new XYConstraints(198, 2, -1, -1));
    jPanel1.add(jdbTextField2, new XYConstraints(171, 19, 74, -1));
    jPanel1.add(jdbTextField3, new XYConstraints(268, 19, 74, -1));
    jPanel1.add(jdbTextField1, new XYConstraints(71, 19, 74, -1));
    jPanel1.add(jdbTextField4, new XYConstraints(71, 43, 74, -1));
    contentPane.add(jPanel2, new XYConstraints(214, 38, 379, 32));
    jPanel2.add(jLabel9, new XYConstraints(236, 8, -1, -1));
    jPanel2.add(jdbTextField7, new XYConstraints(286, 5, 79, -1));
    jPanel2.add(jLabel8, new XYConstraints(7, 8, -1, -1));
    jPanel2.add(jTextField1, new XYConstraints(61, 5, 75, -1));
    jPanel2.add(jButton1, new XYConstraints(141, 6, 60, 21));
    contentPane.add(jButton2, new XYConstraints(508, 376, -1, -1));
    tableScrollPane1.getViewport().add(jdbTable1, null);
    jScrollPane1.getViewport().add(jTree1, null);
    queryDataSet1.addCalcFieldsListener(new
        WhCollection_Frm_queryDataSet1_calcFieldsAdapter(this));
    queryDataSet1.setColumns(new Column[] {column2, column6, column7, column8,
                             column3, column4, column5, column9, column10,
                             column11, column12, column13,
                             column14, column16, column15, column17, column18});
  }

  //Overridden so we can exit when window is closed
  protected void processWindowEvent(WindowEvent e) {
    super.processWindowEvent(e);
    if (e.getID() == WindowEvent.WINDOW_CLOSING) {
      this.dispose();
    }
  }

  void jButton2_actionPerformed(ActionEvent e) {
    this.dispose();
  }

  void jButton1_actionPerformed(ActionEvent e) {
    int goodsid = Integer.parseInt(jTextField1.getText());
    TreePath selPath = jTree1.getAnchorSelectionPath();
    int selRow = jTree1.getRowForPath(selPath);
    if (selRow == 0) {
      queryDataSet1.close();
      String sql =
          "SELECT w.GoodsId as \"货物代码\",g.GName as \"名称\" ,g.GStyle as \"型号\",g.GUnit " +
          "as \"计量单位\",w.OrgPrice as \"期初单价\",w.OrgAmount as \"期初数量\",w.isprice as \"入库单价\"," +
          "w.isamount as \"入库数量\",w.osprice as \"出库价格\",w.osamount as \"出库数量\",w.WhId " +
          "as \"库房\",w.WsId as \"货位\" FROM whgoods w,GoodsInfo g where g.goodsid=w.goodsid and w.goodid='" +
          goodsid + "'";
      queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(
          database1,
          sql, null, true,
          Load.ALL));
      queryDataSet1.refresh();

    }
    else if (selRow > 0) {

      String nodeStr = selPath.getPathComponent(1).toString();
      int whidEnd = nodeStr.indexOf("]");
      String whid = nodeStr.substring(1, whidEnd);
      queryDataSet1.close();
      String sql = null;
      if (selPath.getPathCount() == 2) {
        sql =
            "SELECT w.GoodsId as \"货物代码\",g.GName as \"名称\" ,g.GStyle as \"型号\",g.GUnit " +
            "as \"计量单位\",w.OrgPrice as \"期初单价\",w.OrgAmount as \"期初数量\",w.isprice as \"入库单价\"," +
            "w.isamount as \"入库数量\",w.osprice as \"出库价格\",w.osamount as \"出库数量\",w.WhId " +
            "as \"库房\",w.WsId as \"货位\" FROM whgoods w,GoodsInfo g where g.goodsid=w.goodsid and w.whid='" +
            whid + "' and w.goodsid='" + goodsid + "'";

      }
      else if (selPath.getPathCount() == 3) {
        String node2Str = selPath.getPathComponent(2).toString();
        int wsidEnd = nodeStr.indexOf("]");
        String wsid = node2Str.substring(1, wsidEnd);
        sql =
            "SELECT w.GoodsId as \"货物代码\",g.GName as \"名称\" ,g.GStyle as \"型号\",g.GUnit " +
            "as \"计量单位\",w.OrgPrice as \"期初单价\",w.OrgAmount as \"期初数量\",w.isprice as \"入库单价\"," +
            "w.isamount as \"入库数量\",w.osprice as \"出库价格\",w.osamount as \"出库数量\",w.WhId " +
            "as \"库房\",w.WsId as \"货位\" FROM whgoods w,GoodsInfo g where g.goodsid=w.goodsid and w.whid='" +
            whid + "' and w.wsid='" + wsid + "' and w.goodsid='" + goodsid +
            "'";

      }
      queryDataSet1.setQuery(new com.borland.dx.sql.dataset.
                             QueryDescriptor(database1, sql, null, true,
                                             Load.ALL));
      queryDataSet1.refresh();
    }

  }

  void queryDataSet1_calcFields(ReadRow changedRow, DataRow calcRow,
                                boolean isPosted) {
    calcRow.setBigDecimal("期价",
                          changedRow.getBigDecimal("期初单价").multiply(
        changedRow.
        getBigDecimal("期初数量")));
    calcRow.setBigDecimal("入价",
                          changedRow.getBigDecimal("入库单价").multiply(
        changedRow.
        getBigDecimal("入库数量")));
    calcRow.setBigDecimal("出价",
                          changedRow.getBigDecimal("出库价格").multiply(
        changedRow.
        getBigDecimal("出库数量")));
    calcRow.setBigDecimal("单库存",
                          changedRow.getBigDecimal("期初数量").add(changedRow.
        getBigDecimal("入库数量").subtract(changedRow.getBigDecimal("出库数量"))));
  }
}

class WhCollection_Frm_jButton2_actionAdapter
    implements java.awt.event.ActionListener {
  WhCollection_Frm adaptee;

  WhCollection_Frm_jButton2_actionAdapter(WhCollection_Frm adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}

class WhCollection_Frm_queryDataSet1_calcFieldsAdapter
    implements com.borland.dx.dataset.CalcFieldsListener {
  WhCollection_Frm adaptee;

  WhCollection_Frm_queryDataSet1_calcFieldsAdapter(WhCollection_Frm adaptee) {
    this.adaptee = adaptee;
  }

  public void calcFields(ReadRow changedRow, DataRow calcRow,
                         boolean isPosted) {
    adaptee.queryDataSet1_calcFields(changedRow, calcRow, isPosted);
  }
}

class WhCollection_Frm_jButton1_actionAdapter
    implements java.awt.event.ActionListener {
  WhCollection_Frm adaptee;

  WhCollection_Frm_jButton1_actionAdapter(WhCollection_Frm adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }

}