menuinfo.java

以一个酒店的进销存系统为例

package com.csbook.restaurant;

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

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: </p>
 * @author pengtao
 * @version 1.0
 */

public class MenuInfo extends JDialog {
  JPanel panel1 = new JPanel();
  BorderLayout borderLayout1 = new BorderLayout();
  Database database1 = new Database();
  ParameterRow selectedRoom = new ParameterRow();
  Column column1 = new Column();
  private String roomNo="";
  Column column7 = new Column();
  Column column9 = new Column();
  JPanel jPanel1 = new JPanel();
  JPanel jPanel2 = new JPanel();
  JPanel jPanel3 = new JPanel();
  JPanel jPanel4 = new JPanel();
  JLabel jLabel1 = new JLabel();
  Column column3 = new Column();
  Column column4 = new Column();
  Column column6 = new Column();
  Column column8 = new Column();
  Column column11 = new Column();
  Column column12 = new Column();
  JLabel jLabel2 = new JLabel();
  JComboBox foodName = new JComboBox();
  JLabel jLabel3 = new JLabel();
  JTextField foodAmount = new JTextField();
  JLabel jLabel4 = new JLabel();
  JTextField discount = new JTextField();
  JLabel jLabel5 = new JLabel();
  FlowLayout flowLayout1 = new FlowLayout();
  GridLayout gridLayout1 = new GridLayout(2,4);
  JTextField remark = new JTextField();
  JButton addFood = new JButton();
  JPanel jPanel5 = new JPanel();
  TableScrollPane tableScrollPane1 = new TableScrollPane();
  BorderLayout borderLayout2 = new BorderLayout();
  JPanel jPanel6 = new JPanel();
  private String operator,customer,tel,curDate;

  public MenuInfo(Frame frame, String title, boolean modal,String room,String customer,String tel,String operator) {
    super(frame, title, modal);
    this.roomNo=room;
    this.operator=operator;
    Calendar ca=Calendar.getInstance();
    this.curDate=ca.get(Calendar.YEAR)+"-"+(ca.get(Calendar.MONTH)+1)+"-"+ca.get(Calendar.DAY_OF_MONTH);
    this.operator=operator;
    this.customer=customer;
    try {
      jbInit();
      pack();
    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }

  private void jbInit() throws Exception {
    panel1.setLayout(borderLayout1);
    column1.setCaption("ROOM");
    column1.setColumnName("curRoom");
    column1.setCurrency(false);
    column1.setDataType(com.borland.dx.dataset.Variant.STRING);
    column1.setServerColumnName("NewColumn1");
    column1.setSqlType(0);
    column2.setColumnName("curDate");
    column2.setDataType(com.borland.dx.dataset.Variant.STRING);
    column2.setServerColumnName("NewColumn1");
    column2.setSqlType(0);
    selectedRoom.setColumns(new Column[] {column1, column2});
    selectedRoom.setString("curRoom",roomNo);
    selectedRoom.setString("curDate",curDate);
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Restaurant", "user", "user", false, "com.microsoft.jdbc.sqlserver.SQLServerDriver"));
    column7.setCaption("折扣");
    column7.setColumnName("discount");
    column7.setDataType(com.borland.dx.dataset.Variant.DOUBLE);
    column7.setSchemaName("dbo");
    column7.setTableName("sales");
    column7.setWidth(5);
    column7.setServerColumnName("discount");
    column7.setSqlType(6);
    column9.setCaption("已付帐");
    column9.setColumnName("paid");
    column9.setDataType(com.borland.dx.dataset.Variant.BOOLEAN);
    column9.setSchemaName("dbo");
    column9.setTableName("sales");
    column9.setWidth(5);
    column9.setServerColumnName("paid");
    column9.setSqlType(-7);
    jLabel1.setText("备注:");
    column3.setCaption("订单编号");
    column3.setColumnName("No");
    column3.setDataType(com.borland.dx.dataset.Variant.INT);
    column3.setRowId(true);
    column3.setSchemaName("DBO");
    column3.setTableName("SALES");
    column3.setWidth(8);
    column3.setServerColumnName("No");
    column3.setSqlType(4);
    column3.setHidden(true);
    column4.setCaption("食品名称");
    column4.setColumnName("FOOD");
    column4.setDataType(com.borland.dx.dataset.Variant.STRING);
    column4.setPrecision(30);
    column4.setSchemaName("DBO");
    column4.setTableName("SALES");
    column4.setWidth(10);
    column4.setServerColumnName("FOOD");
    column4.setSqlType(1);
    column6.setCaption("数量");
    column6.setColumnName("AMOUNT");
    column6.setDataType(com.borland.dx.dataset.Variant.INT);
    column6.setSchemaName("DBO");
    column6.setTableName("SALES");
    column6.setWidth(5);
    column6.setServerColumnName("AMOUNT");
    column6.setSqlType(4);
    column8.setCaption("折扣率");
    column8.setColumnName("DISCOUNT");
    column8.setDataType(com.borland.dx.dataset.Variant.DOUBLE);
    column8.setSchemaName("DBO");
    column8.setTableName("SALES");
    column8.setWidth(5);
    column8.setServerColumnName("DISCOUNT");
    column8.setSqlType(6);
    column11.setCalcType(com.borland.dx.dataset.CalcType.NO_CALC);
    column11.setCaption("已付帐");
    column11.setColumnName("PAID");
    column11.setDataType(com.borland.dx.dataset.Variant.BOOLEAN);
    column11.setDefault("");
    column11.setSchemaName("DBO");
    column11.setTableName("SALES");
    column11.setWidth(8);
    column11.setServerColumnName("PAID");
    column11.setSqlType(-7);
    column12.setCaption("备注");
    column12.setColumnName("REMARK");
    column12.setDataType(com.borland.dx.dataset.Variant.STRING);
    column12.setPrecision(100);
    column12.setSchemaName("DBO");
    column12.setTableName("SALES");
    column12.setWidth(12);
    column12.setServerColumnName("REMARK");
    column12.setSqlType(1);
    jPanel3.setLayout(flowLayout1);
    jLabel2.setText("订单信息");
    jLabel3.setText("食品名称:");
    jLabel4.setText("数量:");
    jLabel5.setText("折扣:");
    jPanel2.setLayout(gridLayout1);
    foodAmount.setText("");
    remark.setText("");
    discount.setText("");
    addFood.setText("添加订菜");
    addFood.addActionListener(new MenuInfo_addFood_actionAdapter(this));
    jPanel1.setLayout(borderLayout2);
    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT SALES.SALESNO,SALES.OPERATOR,SALES.CUSTOMER,SALES.FOOD,SALES.AMOUNT,SALES.DISCOUNT,SALES.PAID," +
      "SALES.CONSUMEDATE,SALES.REMARK FROM RESTAURANT.DBO.SALES WHERE SALES.ROOM=:curRoom AND SALES.PAID=0 " +
      "AND SALES.CONSUMEDATE>=CAST(:curDate AS datetime)", selectedRoom, true, Load.ALL));
    jdbTable1.setDataSet(queryDataSet1);
    column5.setCaption("订单编号");
    column5.setColumnName("salesNo");
    column5.setDataType(com.borland.dx.dataset.Variant.INT);
    column5.setRowId(true);
    column5.setSchemaName("DBO");
    column5.setTableName("SALES");
    column5.setServerColumnName("salesNo");
    column5.setSqlType(4);
    column5.setHidden(true);
    column10.setCaption("订单编号");
    column10.setColumnName("SALESNO1");
    column10.setDataType(com.borland.dx.dataset.Variant.INT);
    column10.setSchemaName("DBO");
    column10.setTableName("SALES");
    column10.setServerColumnName("SALESNO");
    column10.setSqlType(4);
    column13.setCaption("业务员");
    column13.setColumnName("OPERATOR");
    column13.setDataType(com.borland.dx.dataset.Variant.STRING);
    column13.setPrecision(25);
    column13.setSchemaName("DBO");
    column13.setTableName("SALES");
    column13.setServerColumnName("OPERATOR");
    column13.setSqlType(1);
    column14.setCaption("顾客");
    column14.setColumnName("CUSTOMER");
    column14.setDataType(com.borland.dx.dataset.Variant.STRING);
    column14.setPrecision(30);
    column14.setSchemaName("DBO");
    column14.setTableName("SALES");
    column14.setServerColumnName("CUSTOMER");
    column14.setSqlType(1);
    column15.setCaption("酒菜");