jf_view_query_kcmx_hk.java

医药进销存管理系统 对医药公司的进销存进行管理

                    dd);
            jFormattedTextField1.setText(String.valueOf(date));
            jFormattedTextField2.setText(String.valueOf(date));

        }else{
            jFormattedTextField1.setEnabled(false);
            jFormattedTextField2.setEnabled(false);
            jFormattedTextField1.setText(String.valueOf(""));
             jFormattedTextField2.setText(String.valueOf(""));
        }

    }

    public void jByes_actionPerformed(ActionEvent e) {
        if (jCheckBox1.isSelected()){
           if (jTvalue.getText().trim().length() <= 0){
               JOptionPane.showMessageDialog(null, "请输入查询数值!!", "提示",
                                             JOptionPane.ERROR_MESSAGE);
               jTvalue.requestFocus();
               return;
          }
       }

       String[] tname = {"销售单据号","客户编号","销售金额","销售数量","实收金额","回款金额","回款日期"};
        java.util.Vector vname = new java.util.Vector();
        for (int i = 0 ; i < tname.length ; i++){
            vname.addElement(tname[i]);
        }
        tableModel = new DefaultTableModel(vname,0);
        jTable1.setModel(tableModel);


        String whereStr = null,queryStr = null;
        System.out.println(_ysfIndex);
        if(jCheckBox1.isSelected() && !jCheckBox2.isSelected()){
            if (jTvalue.getText().trim().length() <= 0){
                JOptionPane.showMessageDialog(null, "请输入查询数值!!", "提示",
                                              JOptionPane.ERROR_MESSAGE);
                jTvalue.requestFocus();
                return;
            }
            if (_ysfIndex == 0){
               whereStr = name[_idIndex] + " " + jCysf.getSelectedItem() + " '" +
                          jTvalue.getText().trim() + "%'";
            }else{
              whereStr = name[_idIndex] + " " + jCysf.getSelectedItem() + " '" +
                     jTvalue.getText().trim() + "'";
            }

        }else if(jCheckBox1.isSelected()&& jCheckBox2.isSelected()){
            if (jTvalue.getText().trim().length() <= 0){
                JOptionPane.showMessageDialog(null, "请输入查询数值!!", "提示",
                                              JOptionPane.ERROR_MESSAGE);
                jTvalue.requestFocus();
                return;
            }
            java.sql.Date date1,date2 ;
            try{
                date1 = java.sql.Date.valueOf(jFormattedTextField1.getText().trim());
                date2 = java.sql.Date.valueOf(jFormattedTextField2.getText().trim());
                System.out.println("date1 = " + date1 + "; date2 = " + date2);
                jFormattedTextField1.setText(String.valueOf(date1));
                jFormattedTextField2.setText(String.valueOf(date2));
                if (date1.after(date2)){
                    JOptionPane.showMessageDialog(null,"输入的起始日期不能小于终止日期!!!","系统提示",JOptionPane.ERROR_MESSAGE);
                    return;
                }
            }catch(java.lang.NumberFormatException formate){
                JOptionPane.showMessageDialog(null,"输入的日期有误!!!\n" + formate.getMessage(),"系统提示",JOptionPane.ERROR_MESSAGE);
                return;
            }
            if (_ysfIndex == 0){
               whereStr = name[_idIndex] + " " + jCysf.getSelectedItem() + " '" +
                          jTvalue.getText().trim() + "%' and hkrq >= '" + date1 + "' and hkrq <= '" + date2 + "'";
            }else{
                whereStr = name[_idIndex] + " " + jCysf.getSelectedItem() + " '" +
                   jTvalue.getText().trim() + "' and hkrq >= '" + date1 + "' and hkrq <= '" + date2 + "'";
            }

        }else if(!jCheckBox1.isSelected() && jCheckBox2.isSelected()){
            java.sql.Date date1,date2 ;
            try{
                date1 = java.sql.Date.valueOf(jFormattedTextField1.getText().trim());
                date2 = java.sql.Date.valueOf(jFormattedTextField2.getText().trim());
                System.out.println("date1 = " + date1 + "; date2 = " + date2);
                jFormattedTextField1.setText(String.valueOf(date1));
                jFormattedTextField2.setText(String.valueOf(date2));
                if (date1.after(date2)){
                    JOptionPane.showMessageDialog(null,"输入的起始日期不能小于终止日期!!!","系统提示",JOptionPane.ERROR_MESSAGE);
                    return;
                }
            }catch(java.lang.NumberFormatException formate){
                JOptionPane.showMessageDialog(null,"输入的日期有误!!!\n" + formate.getMessage(),"系统提示",JOptionPane.ERROR_MESSAGE);
                return;
            }
            whereStr = " hkrq >= '" + date1 + "' and hkrq <= '" + date2 + "'";

        }else if(!jCheckBox1.isSelected() && !jCheckBox2.isSelected()){
            return;
        }
        queryStr = " from Obj_SellMain where " + whereStr + " and qssts = 'T'" ;
        System.out.println(queryStr);
        java.util.List list = appjxc.dao.AdapterDao.QueryObject(queryStr);
        if (list.size() <= 0){
            JOptionPane.showMessageDialog(null,"没有找到满足条件的数据!!","系统提示",JOptionPane.INFORMATION_MESSAGE);
            return;
        }
        int rowcount = jTable1.getRowCount();

        System.out.println("list.size() = " + list.size());
        java.util.Iterator iterator = list.iterator();
        //DefaultTableModel table = new DefaultTableModel();
        while(iterator.hasNext()){
            Obj_SellMain buy = (Obj_SellMain)iterator.next();
            java.util.Vector vdata = new java.util.Vector();
            vdata.addElement(buy.getXsdjh());
            vdata.addElement(buy.getKhbh());
            vdata.addElement(String.valueOf(buy.getXsje()));
            vdata.addElement(String.valueOf(buy.getXszs()));
            vdata.addElement(String.valueOf(buy.getSsje()));
            vdata.addElement(String.valueOf(buy.getHkje()));
            vdata.addElement(buy.getHkrq());

            tableModel.addRow(vdata);
        }
        jTable1.setModel(tableModel);
        jTable1.setRowHeight(20);
    }

    public void jCid_itemStateChanged(ItemEvent e) {
        _idIndex = jCid.getSelectedIndex();
    }

    public void jCysf_itemStateChanged(ItemEvent e) {
        _ysfIndex = jCysf.getSelectedIndex();
    }
}


class JF_view_query_kcmx_hk_jByes_actionAdapter implements ActionListener {
    private JF_view_query_kcmx_hk adaptee;
    JF_view_query_kcmx_hk_jByes_actionAdapter(JF_view_query_kcmx_hk adaptee) {
        this.adaptee = adaptee;
    }

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


class JF_view_query_kcmx_hk_jCid_itemAdapter implements ItemListener {
    private JF_view_query_kcmx_hk adaptee;
    JF_view_query_kcmx_hk_jCid_itemAdapter(JF_view_query_kcmx_hk adaptee) {
        this.adaptee = adaptee;
    }

    public void itemStateChanged(ItemEvent e) {
        adaptee.jCid_itemStateChanged(e);
    }
}


class JF_view_query_kcmx_hk_jCysf_itemAdapter implements ItemListener {
    private JF_view_query_kcmx_hk adaptee;
    JF_view_query_kcmx_hk_jCysf_itemAdapter(JF_view_query_kcmx_hk adaptee) {
        this.adaptee = adaptee;
    }

    public void itemStateChanged(ItemEvent e) {
        adaptee.jCysf_itemStateChanged(e);
    }
}


class JF_view_query_kcmx_hk_jCheckBox2_changeAdapter implements ChangeListener {
    private JF_view_query_kcmx_hk adaptee;
    JF_view_query_kcmx_hk_jCheckBox2_changeAdapter(JF_view_query_kcmx_hk adaptee) {
        this.adaptee = adaptee;
    }

    public void stateChanged(ChangeEvent e) {
        adaptee.jCheckBox2_stateChanged(e);
    }
}