oscollection_frm.java~43~

库存管理信息系统

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 OsCollection_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 OsCollection_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 OutStorage.OsId as \"单据编号\",OutStorage.OsTime as \"出库时间\",OutStorage.Charger " +
      "as \"出库人\",OutStorage.Remarks as \"出库备注\" FROM KcglSys.dbo.OutStorage", null, true, Load.ALL));
    queryDataSet1.addNavigationListener(new OsCollection_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 OsGoods.Osid ,OsGoods.GoodsId as \"货物代码\",OsGoods.ClientId as " +
      "\"销售方\",OsGoods.OsAmount as \"数量\",OsGoods.OsPrice as \"单价\",OsGoods.WhId " +
      "as \"库房\",OsGoods.WsId as \"货位\" from KcglSys.dbo.OsGoods", null, true, Load.ALL));
    queryDataSet2.addNavigationListener(new OsCollection_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 OsCollection_Frm_jButton1_actionAdapter(this));
    jTextField1.setText("");
    jPanel2.setBorder(BorderFactory.createLineBorder(Color.black));
    jPanel2.setLayout(xYLayout3);
    jLabel2.setText("数量总计：");
    jLabel3.setText("金额总计：");
    jButton2.setText("返回");
    jButton2.addActionListener(new OsCollection_Frm_jButton2_actionAdapter(this));
    column1.setAgg(new com.borland.dx.dataset.AggDescriptor(new String[] {"OSID"}, "数量", 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[] {"OSID"}, "价格总计", 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[] {"Osid"}, false, false, false));
    queryDataSet2.addCalcFieldsListener(new OsCollection_Frm_queryDataSet2_calcFieldsAdapter(this));
    queryDataSet2.setColumns(new Column[] {column4, column1, column3, column5});
  }

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

  void jButton1_actionPerformed(ActionEvent e) {
    int id = Integer.parseInt(jTextField1.getText());
    ResultSet rs = null;
    //实例化ConnectDBBean
    ConnectDBBean conndb = new ConnectDBBean();
    //设置sql查询语句
    String sql =
        "SELECT OsId as '单据编号',OsTime as '出库时间',Charger"+
        " as '出库人',Remarks as '出库备注' FROM OutStorage where osid='" +
        id + "'";
    try {
      rs = conndb.executeQuery(sql); //执行查询
      //清空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 OsCollection_Frm_jButton1_actionAdapter
    implements java.awt.event.ActionListener {
  OsCollection_Frm adaptee;

  OsCollection_Frm_jButton1_actionAdapter(OsCollection_Frm adaptee) {
    this.adaptee = adaptee;
  }

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

class OsCollection_Frm_queryDataSet1_navigationAdapter implements com.borland.dx.dataset.NavigationListener {
  OsCollection_Frm adaptee;

  OsCollection_Frm_queryDataSet1_navigationAdapter(OsCollection_Frm adaptee) {
    this.adaptee = adaptee;
  }
  public void navigated(NavigationEvent e) {
    adaptee.queryDataSet1_navigated(e);
  }
}

class OsCollection_Frm_queryDataSet2_navigationAdapter implements com.borland.dx.dataset.NavigationListener {
  OsCollection_Frm adaptee;

  OsCollection_Frm_queryDataSet2_navigationAdapter(OsCollection_Frm adaptee) {
    this.adaptee = adaptee;
  }
  public void navigated(NavigationEvent e) {
    adaptee.queryDataSet2_navigated(e);
  }
}

class OsCollection_Frm_queryDataSet2_calcFieldsAdapter implements com.borland.dx.dataset.CalcFieldsListener {
  OsCollection_Frm adaptee;

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

class OsCollection_Frm_jButton2_actionAdapter implements java.awt.event.ActionListener {
  OsCollection_Frm adaptee;

  OsCollection_Frm_jButton2_actionAdapter(OsCollection_Frm adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}