accountjdialog.java

来自「Store Manager」· Java 代码 · 共 375 行 · 第 1/2 页

                .addContainerGap())
        );
        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(jTabbedPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 318, Short.MAX_VALUE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(26, 26, 26))
        );

        pack();
    }// </editor-fold>//GEN-END:initComponents
    
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
    try {
        startDate = jDatePicker1.getSelectedDate();
        endDate = jDatePicker2.getSelectedDate();
    } catch (ParseException ex) {
        startDate = new Date(0);
        endDate = new Date();
    }
    endDate = new Date(endDate.getTime() + 3600 * 24000);
    saleQuery.setParameter("startDate", startDate);
    saleQuery.setParameter("endDate", endDate);
    stockQuery.setParameter("startDate", startDate);
    stockQuery.setParameter("endDate", endDate);
    saleList = saleQuery.getResultList();
    stockList = stockQuery.getResultList();
    updateTable();
}//GEN-LAST:event_jButton1ActionPerformed


/**
 * 获取用来显示收入的表格模型
 * @return 用来显示收入的表格模型
 */
public DefaultTableModel getSaleTableModel() {
    Vector columnName=new Vector();
    columnName.add("销售单据编号");
    columnName.add("收入");
    columnName.add("实际收入");
    columnName.add("欠收");
    columnName.add("时间");
    Vector content=new Vector();
    saleMoneySum = 0;
    getMoneySum = 0;
    
    for( Sale s : saleList) {
        Vector row = new Vector();
        double getMoney = s.getGetMoney().doubleValue();
        double oweGetMoney = s.getOweGetMoney().doubleValue();
        double saleMoney = oweGetMoney + getMoney;
        saleMoneySum += saleMoney;
        getMoneySum += getMoney;
        row.add(s.getSaleID());
        row.add(String.format("%.2f", saleMoney));
        row.add(String.format("%.2f", getMoney));
        row.add(String.format("%.2f", oweGetMoney));
        row.add(new SimpleDateFormat().format(s.getSaleTime()));
        content.add(row);
    }
    // 添加总计行
    Vector row = new Vector();
    row.add("总计");
    row.add(String.format("%.2f", saleMoneySum));
    row.add(String.format("%.2f", getMoneySum));
    content.add(row);
    
    DefaultTableModel saleTableModel=new DefaultTableModel(content,columnName){
        public boolean isCellEditable(int row, int col) {
            return false;
        }
    };
    return saleTableModel;
}

/**
 * 获取用来显示支出的表格模型
 * @return 用来显示支出的表格模型
 */
public DefaultTableModel getStockTableModel() {
    Vector columnName=new Vector();
    columnName.add("进货单据编号");
    columnName.add("支出");
    columnName.add("实际支出");
    columnName.add("欠支");
    columnName.add("时间");
    Vector content=new Vector();
    stockMoneySum = 0;
    giveMoneySum = 0;
    for( Stock s : stockList) {
        Vector row = new Vector();
        double giveMoney = s.getGiveMoney().doubleValue();
        double oweGiveMoney = s.getOweGiveMoney().doubleValue();
        double stockMoney = giveMoney + oweGiveMoney;
        stockMoneySum += stockMoney;
        giveMoneySum += giveMoney;
        
        row.add(s.getStockID());
        row.add(String.format("%.2f", stockMoney));
        row.add(String.format("%.2f", giveMoney));
        row.add(String.format("%.2f", oweGiveMoney));
        row.add(new SimpleDateFormat().format(s.getStockTime()));
        content.add(row);
    }
    // 添加总计行
    Vector row = new Vector();
    row.add("总计");
    row.add(String.format("%.2f", stockMoneySum));
    row.add(String.format("%.2f", giveMoneySum));
    content.add(row);
    DefaultTableModel stockItemTableModel=new DefaultTableModel(content,columnName){
        public boolean isCellEditable(int row, int col) {
            return false;
        }
    };
    return stockItemTableModel;
}

/**
 * 更新表格
 */
private void updateTable(){
    jTable1.setModel(getSaleTableModel());
    jTable2.setModel(getStockTableModel());
    setCount();
}

/**
 * 更新统计信息
 */
private void setCount() {
    jTextField1.setText(String.format("%.2f", saleMoneySum - stockMoneySum));
    jTextField2.setText(String.format("%.2f", getMoneySum - giveMoneySum));
}
/**
 * @param args the command line arguments
 */
public static void main(String args[]) {
    java.awt.EventQueue.invokeLater(new Runnable() {
        public void run() {
            AccountJDialog dialog = new AccountJDialog(new javax.swing.JFrame(), true);
            dialog.addWindowListener(new java.awt.event.WindowAdapter() {
                public void windowClosing(java.awt.event.WindowEvent e) {
                    System.exit(0);
                }
            });
            dialog.setVisible(true);
        }
    });
}

    // Variables declaration - do not modify//GEN-BEGIN:variables
    private javax.persistence.EntityManager em;
    private javax.swing.JButton jButton1;
    private com.sunking.swing.JDatePicker jDatePicker1;
    private com.sunking.swing.JDatePicker jDatePicker2;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JPanel jPanel2;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JScrollPane jScrollPane2;
    private javax.swing.JTabbedPane jTabbedPane1;
    private javax.swing.JTable jTable1;
    private javax.swing.JTable jTable2;
    private javax.swing.JTextField jTextField1;
    private javax.swing.JTextField jTextField2;
    private java.util.List<Sale> saleList;
    private javax.persistence.Query saleQuery;
    private java.util.List<Stock> stockList;
    private javax.persistence.Query stockQuery;
    // End of variables declaration//GEN-END:variables
    java.util.Date startDate = new Date(new Date().getTime() - 3600 * 24000);
    java.util.Date endDate = new Date();
    double saleMoneySum = 0;
    double getMoneySum = 0;
    double stockMoneySum = 0;
    double giveMoneySum = 0;
}