whcollection_frm.java~35~

库存管理信息系统

    jdbTextField5.setText("");
    jdbTextField5.setColumnName("入价总");
    jdbTextField5.setDataSet(queryDataSet1);
    jdbTextField6.setText("");
    jdbTextField6.setColumnName("出价总");
    jdbTextField6.setDataSet(queryDataSet1);
    column5.setAgg(new com.borland.dx.dataset.AggDescriptor( (String[])null,
        "期初数量", new com.borland.dx.dataset.SumAggOperator()));
    column5.setCalcType(com.borland.dx.dataset.CalcType.AGGREGATE);
    column5.setColumnName("期数总");
    column5.setDataType(com.borland.dx.dataset.Variant.BIGDECIMAL);
    column5.setPreferredOrdinal(12);
    column5.setServerColumnName("NewColumn1");
    column5.setSqlType(0);
    column6.setColumnName("期初数量");
    column6.setDataType(com.borland.dx.dataset.Variant.BIGDECIMAL);
    column6.setTableName("whgoods");
    column6.setServerColumnName("OrgAmount");
    column6.setSqlType(4);
    column7.setColumnName("入库数量");
    column7.setDataType(com.borland.dx.dataset.Variant.BIGDECIMAL);
    column7.setTableName("whgoods");
    column7.setServerColumnName("isamount");
    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);
    jTextField2.setText("jTextField2");
    jTextField3.setText("jTextField3");
    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(jButton2, new XYConstraints(509, 391, -1, -1));
    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(jTextField2, new XYConstraints(221, 376, 103, -1));
    contentPane.add(jTextField3, new XYConstraints(340, 374, 111, -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) {


    TreePath selPath = jTree1.getAnchorSelectionPath();
    int selRow = jTree1.getRowForPath(selPath);
    jTextField2.setText(selPath.toString());
    jTextField3.setText(selRow + "");

  }

  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);
  }
}