returnticketjpanel.java

客运售票管理信息系统

/*
 * ReturnTicketJPanel.java
 *
 * Created on 2009年1月11日, 下午7:20
 */

package passengertransportmis;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Timestamp;

import org.jdesktop.application.Action;

/**
 *
 * @author  Degree41
 * 当进入退票界面时，与扫描器关联，扫描车票的条形码，得到车票id，触发scan()函数，
 * 然后查询数据库得到次车票信息，此处采取硬编码，使用车票id：1002 1231892844000 1
 */
public class ReturnTicketJPanel extends javax.swing.JPanel {

    /** Creates new form ReturnTicketJPanel */
    public ReturnTicketJPanel() {
        initComponents();
        //硬编码
        this.scan();
    }

    @Action
    public void confirm() {
    	//添加原因
    	if(this.reasonTextArea.getText().isEmpty())
    		this.ti.setReturn_reason("");
    	else{
    		this.ti.setReturn_reason(this.reasonTextArea.getText());
    	}
    	
    	//添加操作员id
    	this.ti.setReturn_operator_id(PassengerTransportMISApp.getUserInfo()[0]);
    	
    	String sql = "insert into ticket_return values ('" + this.ti.getId() + "','"
					+ this.ti.getReturn_reason() + "',"
					+ this.ti.getReturn_rate() + "," 
					+ "now()" + ",'" + this.ti.getReturn_operator_id() + "')";
		int i = Database.executeUpdate(stmt, sql);
		if (i == 1) {
			javax.swing.JOptionPane.showMessageDialog(this,
					"退票成功！", "提示", 1/* infomation */);
			this.returnInitState();		
		} else
			javax.swing.JOptionPane.showMessageDialog(this,
					"退票失败，请正确操作，请求管理员查看日志信息，维护系统！", "错误", 0/* erroe */);
	}
    
     
    @Action
    public void cancel() {
    	ti = new TicketInfo();
    	this.returnInitState();
    }
    
    public void scan(){
    	String id = "1002 1231892844000 1";
    	this.ti.setId(id);
    	this.getTicketInfo(id);
    }
    
    /** 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.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
    private void initComponents() {
  
        jLabel1 = new javax.swing.JLabel();
        ticketIdTextField = new javax.swing.JTextField();
        jLabel2 = new javax.swing.JLabel();
        beginPointTextField = new javax.swing.JTextField();
        jLabel3 = new javax.swing.JLabel();
        endPointTextField = new javax.swing.JTextField();
        jLabel4 = new javax.swing.JLabel();
        ticketFareTextField = new javax.swing.JTextField();
        isInsurancedCheckBox = new javax.swing.JCheckBox();
        jLabel5 = new javax.swing.JLabel();
        jScrollPane1 = new javax.swing.JScrollPane();
        reasonTextArea = new javax.swing.JTextArea();
        jLabel6 = new javax.swing.JLabel();
        deductComboBox = new javax.swing.JComboBox();
        jLabel7 = new javax.swing.JLabel();
        returnFareTextField = new javax.swing.JTextField();
        confirmButton = new javax.swing.JButton();
        cancelButton = new javax.swing.JButton();

        org.jdesktop.application.ResourceMap resourceMap = org.jdesktop.application.Application.getInstance(passengertransportmis.PassengerTransportMISApp.class).getContext().getResourceMap(ReturnTicketJPanel.class);
        jLabel1.setFont(resourceMap.getFont("jLabel1.font")); // NOI18N
        jLabel1.setText(resourceMap.getString("jLabel1.text")); // NOI18N
        jLabel1.setName("jLabel1"); // NOI18N

        ticketIdTextField.setFont(resourceMap.getFont("jLabel1.font")); // NOI18N
        ticketIdTextField.setText(resourceMap.getString("ticketIdTextField.text")); // NOI18N
        ticketIdTextField.setEnabled(false);
        ticketIdTextField.setName("ticketIdTextField"); // NOI18N

        jLabel2.setFont(resourceMap.getFont("jLabel1.font")); // NOI18N
        jLabel2.setText(resourceMap.getString("jLabel2.text")); // NOI18N
        jLabel2.setName("jLabel2"); // NOI18N

        beginPointTextField.setFont(resourceMap.getFont("jLabel1.font")); // NOI18N
        beginPointTextField.setText(resourceMap.getString("beginPointTextField.text")); // NOI18N
        beginPointTextField.setEnabled(false);
        beginPointTextField.setName("beginPointTextField"); // NOI18N

        jLabel3.setFont(resourceMap.getFont("jLabel1.font")); // NOI18N
        jLabel3.setText(resourceMap.getString("jLabel3.text")); // NOI18N
        jLabel3.setName("jLabel3"); // NOI18N

        endPointTextField.setFont(resourceMap.getFont("jLabel1.font")); // NOI18N
        endPointTextField.setText(resourceMap.getString("endPointTextField.text")); // NOI18N
        endPointTextField.setEnabled(false);
        endPointTextField.setName("endPointTextField"); // NOI18N

        jLabel4.setFont(resourceMap.getFont("jLabel1.font")); // NOI18N
        jLabel4.setText(resourceMap.getString("jLabel4.text")); // NOI18N
        jLabel4.setName("jLabel4"); // NOI18N

        ticketFareTextField.setFont(resourceMap.getFont("jLabel1.font")); // NOI18N
        ticketFareTextField.setText(resourceMap.getString("ticketFareTextField.text")); // NOI18N
        ticketFareTextField.setEnabled(false);
        ticketFareTextField.setName("ticketFareTextField"); // NOI18N

        isInsurancedCheckBox.setFont(resourceMap.getFont("jLabel1.font")); // NOI18N
        isInsurancedCheckBox.setText(resourceMap.getString("isInsurancedCheckBox.text")); // NOI18N
        isInsurancedCheckBox.setEnabled(false);
        isInsurancedCheckBox.setName("isInsurancedCheckBox"); // NOI18N
        jLabel5.setFont(resourceMap.getFont("jLabel6.font")); // NOI18N
        jLabel5.setText(resourceMap.getString("jLabel5.text")); // NOI18N
        jLabel5.setName("jLabel5"); // NOI18N

        jScrollPane1.setName("jScrollPane1"); // NOI18N

        reasonTextArea.setColumns(20);
        reasonTextArea.setFont(resourceMap.getFont("jLabel6.font")); // NOI18N
        reasonTextArea.setRows(5);
        reasonTextArea.setName("reasonTextArea"); // NOI18N
        jScrollPane1.setViewportView(reasonTextArea);

        jLabel6.setFont(resourceMap.getFont("jLabel6.font")); // NOI18N
        jLabel6.setText(resourceMap.getString("jLabel6.text")); // NOI18N
        jLabel6.setName("jLabel6"); // NOI18N

        deductComboBox.setFont(resourceMap.getFont("deductComboBox.font")); // NOI18N
        deductComboBox.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "100%", "80%" }));
        deductComboBox.setName("deductComboBox"); // NOI18N
        deductComboBox.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
            	deductComboBoxActionPerformed(evt);
            }
        });
        

        jLabel7.setFont(resourceMap.getFont("confirmButton.font")); // NOI18N
        jLabel7.setText(resourceMap.getString("jLabel7.text")); // NOI18N
        jLabel7.setName("jLabel7"); // NOI18N

        returnFareTextField.setFont(resourceMap.getFont("confirmButton.font")); // NOI18N
        returnFareTextField.setText(resourceMap.getString("returnFareTextField.text")); // NOI18N
        returnFareTextField.setEnabled(false);
        returnFareTextField.setName("returnFareTextField"); // NOI18N

        javax.swing.ActionMap actionMap = org.jdesktop.application.Application.getInstance(passengertransportmis.PassengerTransportMISApp.class).getContext().getActionMap(ReturnTicketJPanel.class, this);
        confirmButton.setAction(actionMap.get("confirm")); // NOI18N
        confirmButton.setFont(resourceMap.getFont("confirmButton.font")); // NOI18N