mscollection_frm.java

库存管理信息系统

package KcglSys;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import com.borland.jbcl.layout.*;
import com.borland.dx.sql.dataset.*;
import com.borland.dbswing.*;
import java.sql.*;
import com.borland.dx.dataset.*;

/**
 * <p>Title: 库存管理信息系统</p>
 * <p>Description: 库存管理信息系统，企业好帮手</p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: ios</p>
 * @author dragon
 * @version 1.0
 */

public class MsCollection_Frm
    extends JFrame {
  JPanel contentPane;
  XYLayout xYLayout1 = new XYLayout();
  Database database1 = new Database();
  QueryDataSet queryDataSet1 = new QueryDataSet();
  TableScrollPane tableScrollPane1 = new TableScrollPane();
  JdbTable jdbTable1 = new JdbTable();
  TableScrollPane tableScrollPane2 = new TableScrollPane();
  JdbTable jdbTable2 = new JdbTable();
  QueryDataSet queryDataSet2 = new QueryDataSet();
  JPanel jPanel1 = new JPanel();
  JLabel jLabel1 = new JLabel();
  XYLayout xYLayout2 = new XYLayout();
  JTextField jTextField1 = new JTextField();
  JButton jButton1 = new JButton();
  JPanel jPanel2 = new JPanel();
  JLabel jLabel2 = new JLabel();
  XYLayout xYLayout3 = new XYLayout();
  JLabel jLabel3 = new JLabel();
  JButton jButton2 = new JButton();
  Column column1 = new Column();
  JdbTextField jdbTextField1 = new JdbTextField();
  Column column3 = new Column();
  Column column4 = new Column();
  Column column5 = new Column();
  JdbTextField jdbTextField2 = new JdbTextField();

  //Construct the frame
  public MsCollection_Frm() {
    enableEvents(AWTEvent.WINDOW_EVENT_MASK);
    try {
      jbInit();
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }

  //Component initialization
  private void jbInit() throws Exception {
    contentPane = (JPanel)this.getContentPane();
    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT MsId as \"单据编号\",MoveTime as \"调库时间\",Charger as \"调库人\",Remarks " +
      "as \"调库备注\"  FROM KcglSys.dbo.MoveStorage", null, true, Load.ALL));
    queryDataSet1.addNavigationListener(new
        MsCollection_Frm_queryDataSet1_navigationAdapter(this));
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor(
        "jdbc:odbc:KcglSys", "sa", "sa", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
    contentPane.setLayout(xYLayout1);
    this.setResizable(false);
    this.setSize(new Dimension(601, 399));
    this.setTitle("调库盘点");
    tableScrollPane1.setBorder(BorderFactory.createLineBorder(Color.black));
    jdbTable1.setDataSet(queryDataSet1);
    queryDataSet2.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT MsGoods.MsId as \"单据编号\",MsGoods.GoodsId as \"货物代码\",MsGoods.OldWhId " +
      "as \"源库房\",MsGoods.OldWsId as \"货位\",MsGoods.NewWhId as \"目标库房\",MsGoods.NewWsId " +
      "as \"货位\",MsGoods.MsPrice as \"单价\",MsGoods.MsAmount as \"数量\" FROM KcglSys.dbo.MsGoods", null, true, Load.ALL));
    queryDataSet2.addNavigationListener(new
        MsCollection_Frm_queryDataSet2_navigationAdapter(this));
    jdbTable2.setDataSet(queryDataSet2);
    tableScrollPane2.setBorder(BorderFactory.createLineBorder(Color.black));
    jPanel1.setBorder(BorderFactory.createLineBorder(Color.black));
    jPanel1.setLayout(xYLayout2);
    jLabel1.setText("编号：");
    jButton1.setText("查询");
    jButton1.addActionListener(new MsCollection_Frm_jButton1_actionAdapter(this));
    jTextField1.setText("");
    jPanel2.setBorder(BorderFactory.createLineBorder(Color.black));
    jPanel2.setLayout(xYLayout3);
    jLabel2.setText("数量总计：");
    jLabel3.setText("金额总计：");
    jButton2.setText("返回");
    jButton2.addActionListener(new MsCollection_Frm_jButton2_actionAdapter(this));
    column1.setAgg(new com.borland.dx.dataset.AggDescriptor(new String[] {"单据编号"}, "数量", new com.borland.dx.dataset.SumAggOperator()));
    column1.setAlignment(com.borland.dx.text.Alignment.RIGHT |
                         com.borland.dx.text.Alignment.BOTTOM);
    column1.setCalcType(com.borland.dx.dataset.CalcType.AGGREGATE);
    column1.setColumnName("总计");
    column1.setDataType(com.borland.dx.dataset.Variant.BIGDECIMAL);
    column1.setPreferredOrdinal(7);
    column1.setServerColumnName("NewColumn1");
    column1.setSqlType(0);
    jdbTextField1.setText("jdbTextField1");
    jdbTextField1.setColumnName("总计");
    jdbTextField1.setDataSet(queryDataSet2);
    column3.setCalcType(com.borland.dx.dataset.CalcType.CALC);
    column3.setColumnName("价格总计");
    column3.setDataType(com.borland.dx.dataset.Variant.BIGDECIMAL);
    column3.setPreferredOrdinal(8);
    column3.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column3.setServerColumnName("NewColumn1");
    column3.setSqlType(0);
    column4.setColumnName("数量");
    column4.setDataType(com.borland.dx.dataset.Variant.BIGDECIMAL);
    column4.setSchemaName("dbo");
    column4.setTableName("IsGoods");
    column4.setServerColumnName("IsAmount");
    column4.setSqlType(4);
    column5.setAgg(new com.borland.dx.dataset.AggDescriptor(new String[] {"单据编号"}, "价格总计", 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(9);
    column5.setServerColumnName("NewColumn1");
    column5.setSqlType(0);
    jdbTextField2.setText("");
    jdbTextField2.setColumnName("价格汇总");
    jdbTextField2.setDataSet(queryDataSet2);
    contentPane.add(tableScrollPane1, new XYConstraints(12, 17, 190, 293));
    contentPane.add(tableScrollPane2, new XYConstraints(211, 17, 379, 293));
    contentPane.add(jPanel1, new XYConstraints(12, 312, 190, 35));
    jPanel1.add(jLabel1, new XYConstraints(9, 7, -1, -1));
    jPanel1.add(jButton1, new XYConstraints(113, 4, 60, 23));
    jPanel1.add(jTextField1, new XYConstraints(44, 4, 59, -1));
    contentPane.add(jPanel2, new XYConstraints(211, 311, 379, 35));
    jPanel2.add(jLabel2, new XYConstraints(10, 8, -1, -1));
    jPanel2.add(jLabel3, new XYConstraints(134, 8, -1, -1));
    jPanel2.add(jdbTextField1, new XYConstraints(60, 4, 65, -1));
    jPanel2.add(jdbTextField2, new XYConstraints(184, 4, 65, -1));
    jPanel2.add(jButton2,   new XYConstraints(302, 7, -1, 21));
    tableScrollPane2.getViewport().add(jdbTable2, null);
    tableScrollPane1.getViewport().add(jdbTable1, null);
    queryDataSet2.setMasterLink(new com.borland.dx.dataset.MasterLinkDescriptor(queryDataSet1, new String[] {"单据编号"}, new String[] {"单据编号"}, false, false, false));
    queryDataSet2.addCalcFieldsListener(new
        MsCollection_Frm_queryDataSet2_calcFieldsAdapter(this));
    queryDataSet2.setColumns(new Column[] {column1, column3, column5, column4});
  }

  //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 jButton1_actionPerformed(ActionEvent e) {
    int id = Integer.parseInt(jTextField1.getText());
    ResultSet rs = null;
    //实例化ConnectDBBean
    ConnectDBBean conndb = new ConnectDBBean();
    //设置sql查询语句
    String sql =
        "SELECT MsId as '单据编号',MoveTime as '调库时间',Charger" +
        " as '调库人',Remarks as '调库备注' FROM MoveStorage where msid='" +
        id + "'";
    try {
      rs = conndb.executeQuery(sql); //执行查询
      if (rs.next()) {
        //清空jdbTable1中存放的结果集queryDataSet1
        queryDataSet1.close();
        //按选定所选的部门进行查询

        queryDataSet1.setQuery(new com.borland.dx.sql.dataset.
                               QueryDescriptor(database1, sql, null, true,
                                               Load.ALL));
        //将queryDataSet1装入jdbTable中
        queryDataSet1.refresh();
      }
    }
    catch (Exception ex) {
      System.err.println("sql error!");
    }

  }

  void queryDataSet1_navigated(NavigationEvent e) {
  }

  void queryDataSet2_navigated(NavigationEvent e) {
  }

  void queryDataSet2_calcFields(ReadRow changedRow, DataRow calcRow,
                                boolean isPosted) {
    calcRow.setBigDecimal("价格总计",
                          changedRow.getBigDecimal("单价").multiply(changedRow.
        getBigDecimal("数量")));
  }

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

}

class MsCollection_Frm_jButton1_actionAdapter
    implements java.awt.event.ActionListener {
  MsCollection_Frm adaptee;

  MsCollection_Frm_jButton1_actionAdapter(MsCollection_Frm adaptee) {
    this.adaptee = adaptee;
  }

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

class MsCollection_Frm_queryDataSet1_navigationAdapter
    implements com.borland.dx.dataset.NavigationListener {
  MsCollection_Frm adaptee;

  MsCollection_Frm_queryDataSet1_navigationAdapter(MsCollection_Frm adaptee) {
    this.adaptee = adaptee;
  }

  public void navigated(NavigationEvent e) {
    adaptee.queryDataSet1_navigated(e);
  }
}

class MsCollection_Frm_queryDataSet2_navigationAdapter
    implements com.borland.dx.dataset.NavigationListener {
  MsCollection_Frm adaptee;

  MsCollection_Frm_queryDataSet2_navigationAdapter(MsCollection_Frm adaptee) {
    this.adaptee = adaptee;
  }

  public void navigated(NavigationEvent e) {
    adaptee.queryDataSet2_navigated(e);
  }
}

class MsCollection_Frm_queryDataSet2_calcFieldsAdapter
    implements com.borland.dx.dataset.CalcFieldsListener {
  MsCollection_Frm adaptee;

  MsCollection_Frm_queryDataSet2_calcFieldsAdapter(MsCollection_Frm adaptee) {
    this.adaptee = adaptee;
  }

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

class MsCollection_Frm_jButton2_actionAdapter
    implements java.awt.event.ActionListener {
  MsCollection_Frm adaptee;

  MsCollection_Frm_jButton2_actionAdapter(MsCollection_Frm adaptee) {
    this.adaptee = adaptee;
  }

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