selectincomesumframe.java

Athena酒店小组_Athena酒店管理系统

/*
 * SelectIncomeSumFrame.java
 *
 * Created on 2007年6月19日, 下午8:36
 */

package frames;

import java.text.ParseException;
import java.util.*;
import javax.swing.*;
import module.*;
import helper.*;
import java.text.DateFormat;
import minco.*;
/**
 *
 * @author  Minco
 */
public class SelectIncomeSumFrame extends javax.swing.JInternalFrame {
    
    /** Creates new form SelectIncomeSumFrame */
    public SelectIncomeSumFrame() {
        initComponents();
    }
    
    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    // <editor-fold defaultstate="collapsed" desc=" 生成的代码 ">//GEN-BEGIN:initComponents
    private void initComponents() {
        IncomeTableScrollPane = new javax.swing.JScrollPane();
        incomeTableScrollPane = new javax.swing.JScrollPane();
        incomeTable = new javax.swing.JTable();
        jPanel1 = new javax.swing.JPanel();
        jLabel1 = new javax.swing.JLabel();
        TSTextField = new javax.swing.JTextField();
        showButton = new javax.swing.JButton();

        setClosable(true);
        setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
        setIconifiable(true);
        setMaximizable(true);
        setTitle("\u67e5\u8be2\u6536\u652f\u8bb0\u5f55");
        incomeTable.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {

            },
            new String [] {
                "日期", "客房部营业额", "餐饮部营业额", "娱乐部营业额", "库存成本", "税金", "管理及人事成本"
            }
        ) {
            Class[] types = new Class [] {
                java.lang.Object.class, java.lang.Double.class, java.lang.Double.class, java.lang.Double.class, java.lang.Double.class, java.lang.Double.class, java.lang.Double.class
            };
            boolean[] canEdit = new boolean [] {
                false, false, false, false, false, false, false
            };

            public Class getColumnClass(int columnIndex) {
                return types [columnIndex];
            }

            public boolean isCellEditable(int rowIndex, int columnIndex) {
                return canEdit [columnIndex];
            }
        });
        incomeTableScrollPane.setViewportView(incomeTable);

        IncomeTableScrollPane.setViewportView(incomeTableScrollPane);

        jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createEtchedBorder(), "\u6309\u65e5\u671f\u67e5\u8be2(\u7a7a\u4e3a\u663e\u793a\u5168\u90e8\u8bb0\u5f55):"));
        jLabel1.setText("\u65e5\u671f\uff1a");

        showButton.setText("\u67e5\u8be2");
        showButton.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                showButtonActionPerformed(evt);
            }
        });

        javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
        jPanel1.setLayout(jPanel1Layout);
        jPanel1Layout.setHorizontalGroup(
            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup()
                .addContainerGap(18, Short.MAX_VALUE)
                .addComponent(jLabel1)
                .addGap(23, 23, 23)
                .addComponent(TSTextField, javax.swing.GroupLayout.PREFERRED_SIZE, 128, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(18, 18, 18)
                .addComponent(showButton)
                .addContainerGap())
        );
        jPanel1Layout.setVerticalGroup(
            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel1Layout.createSequentialGroup()
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel1)
                    .addComponent(showButton)
                    .addComponent(TSTextField, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(layout.createSequentialGroup()
                        .addGap(104, 104, 104)
                        .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addGroup(layout.createSequentialGroup()
                        .addContainerGap()
                        .addComponent(IncomeTableScrollPane, javax.swing.GroupLayout.PREFERRED_SIZE, 526, javax.swing.GroupLayout.PREFERRED_SIZE)))
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(IncomeTableScrollPane, javax.swing.GroupLayout.PREFERRED_SIZE, 314, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap(29, Short.MAX_VALUE))
        );
        pack();
    }// </editor-fold>//GEN-END:initComponents

    private void showButtonActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_showButtonActionPerformed
	//设置Table格式
	incomeTable.getTableHeader().setReorderingAllowed(false);
	incomeTable.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
	TableHelper.clearTable(incomeTable);
	//获取部门信息
	IncomeSumAccess da = new IncomeSumAccess(Resource.getDBResource());
        if(TSTextField.getText().equals("")){
	ArrayList<IncomeSum> dis = da.getAllIncomeSum();
	for(IncomeSum di : dis)
	{
	    Object[] objs = new Object[]
	    {
		di.getStatTime(),
		di.getRoomTurnover(),
                di.getDiningRoomTurnover(),
                di.getEntertainmentTurnover(),
                di.getRepertoryCost(),
                di.getTex(),
                di.getManageCost()
	    };
	    TableHelper.addToTable(incomeTable, objs);
	}
        }else{
           String[] str= TSTextField.getText().split("-");
           int i1,i2,i3;
           i1=Integer.parseInt(str[0]);
           i2=Integer.parseInt(str[1]);
           i3=Integer.parseInt(str[2]);
           i1-=1900;
           i2--;        
            java.sql.Date date=new java.sql.Date(i1,i2,i3);         
        //    JOptionPane.showMessageDialog(null, date.toString(), "错误", JOptionPane.ERROR_MESSAGE);
        IncomeSum di=da.getIncomeSumByTime(date);
	    Object[] objs = new Object[]
	    {
		di.getStatTime(),
		di.getRoomTurnover(),
                di.getDiningRoomTurnover(),
                di.getEntertainmentTurnover(),
                di.getRepertoryCost(),
                di.getTex(),
                di.getManageCost()
	    };
	    TableHelper.addToTable(incomeTable, objs);
        }
// TODO 将在此处添加您的处理代码：
    }//GEN-LAST:event_showButtonActionPerformed
    
    
    // 变量声明 - 不进行修改//GEN-BEGIN:variables
    private javax.swing.JScrollPane IncomeTableScrollPane;
    private javax.swing.JTextField TSTextField;
    private javax.swing.JTable incomeTable;
    private javax.swing.JScrollPane incomeTableScrollPane;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JButton showButton;
    // 变量声明结束//GEN-END:variables
    
}