开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > Java编程 > JavaScript > 查看源码
JF_view_query_kcmx_hk.java
资源名称：Appjxc.rar　[点击查看]
上传用户：whbcdz
上传日期：2008-08-04
资源大小：7683k
文件大小：15k
源码类别：

JavaScript

开发平台：

Java

JF_view_query_kcmx_hk.java：源码内容
  1. package appjxc.view;
  3. import java.awt.*;
  5. import javax.swing.*;
  6. import java.awt.BorderLayout;
  7. import java.awt.Font;
  8. import java.awt.Dimension;
  9. import javax.swing.border.Border;
  10. import java.util.Calendar;
  11. import java.util.Locale;
  12. import javax.swing.event.ChangeEvent;
  13. import javax.swing.event.ChangeListener;
  14. import javax.swing.table.TableColumnModel;
  15. import javax.swing.table.DefaultTableModel;
  16. import java.awt.event.ActionEvent;
  17. import java.awt.event.ActionListener;
  18. import java.awt.event.ItemEvent;
  19. import java.awt.event.ItemListener;
  20. import appjxc.model.Obj_BuyDetaile;
  21. import appjxc.model.Obj_SellDetaile;
  22. import appjxc.model.Obj_SellMain;
  24. public class JF_view_query_kcmx_hk extends JInternalFrame {
  25.     BorderLayout borderLayout1 = new BorderLayout();
  26.     JPanel jPanel1 = new JPanel();
  27.     GridLayout gridLayout1 = new GridLayout();
  28.     JPanel jPanel2 = new JPanel();
  29.     JPanel jPanel3 = new JPanel();
  30.     FlowLayout flowLayout1 = new FlowLayout();
  31.     JCheckBox jCheckBox1 = new JCheckBox();
  32.     JLabel jLabel1 = new JLabel();
  33.     JComboBox jCid = new JComboBox();
  34.     JComboBox jCysf = new JComboBox();
  35.     JTextField jTvalue = new JTextField();
  36.     JCheckBox jCheckBox2 = new JCheckBox();
  37.     JLabel jLabel2 = new JLabel();
  38.     JLabel jLabel3 = new JLabel();
  39.     JLabel jLabel4 = new JLabel();
  40.     JLabel jLabel6 = new JLabel();
  41.     FlowLayout flowLayout2 = new FlowLayout();
  42.     Border border1 = BorderFactory.createLineBorder(UIManager.getColor(
  43.             "ToolBar.dockingForeground"), 2);
  44.     Border border2 = BorderFactory.createLineBorder(Color.magenta, 1);
  45.     JButton jByes = new JButton();
  46.     JScrollPane jScrollPane1 = new JScrollPane();
  47.     JTable jTable1 = new JTable();
  48.     JFormattedTextField jFormattedTextField1 = new JFormattedTextField();
  49.     JFormattedTextField jFormattedTextField2 = new JFormattedTextField();
  50.     DefaultTableModel tableModel = null;
  51.     String[] name = {"khbh","hkje"};
  52.     int _idIndex ,_ysfIndex ;
  53.     public JF_view_query_kcmx_hk() {
  54.         _idIndex = 0 ;
  55.         _ysfIndex = 0 ;
  56.         try {
  57.             buildTable();
  58.             jbInit();
  59.         } catch (Exception exception) {
  60.             exception.printStackTrace();
  61.         }
  62.     }
  63.     public void setjSpinner(){
  64.     }
  66.     private void jbInit() throws Exception {
  67.         jFormattedTextField1.setEnabled(false);
  68.         jFormattedTextField2.setEnabled(false);
  69.         border1 = BorderFactory.createLineBorder(Color.red, 1);
  70.         jCheckBox1.setSelected(true);
  71.         jCheckBox2.setSelected(false);
  72.         jCysf.addItem("like");
  73.         jCysf.addItem(">");
  74.         jCysf.addItem("<");
  75.         jCysf.addItem(">=");
  76.         jCysf.addItem("<=");
  78.         jCid.addItem("客户编号");
  79.         jCid.addItem("回款金额");
  80.         //jCid.addItem("销售数量");
  83.         getContentPane().setLayout(borderLayout1);
  84.         jCheckBox2.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
  85.         jCheckBox2.setToolTipText("");
  86.         jCheckBox2.setText("回款日期");
  87.         jCheckBox2.addChangeListener(new JF_view_query_kcmx_hk_jCheckBox2_changeAdapter(this));
  88.         jLabel2.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
  89.         jLabel2.setText("起始日期:");
  90.         jLabel3.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
  91.         jLabel3.setText("终止日期:");
  92.         jLabel4.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
  93.         jLabel4.setText("运算符:");
  94.         jLabel6.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
  95.         jLabel6.setText("数值:");
  96.         flowLayout1.setHgap(8);
  97.         jPanel3.setLayout(flowLayout2);
  98.         flowLayout2.setHgap(8);
  99.         jCheckBox1.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
  100.         jLabel1.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
  101.         jCid.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
  102.         jCid.setPreferredSize(new Dimension(97, 23));
  103.         jCid.addItemListener(new JF_view_query_kcmx_hk_jCid_itemAdapter(this));
  104.         jPanel2.setBorder(border1);
  105.         jPanel3.setBorder(border2);
  106.         jTvalue.setPreferredSize(new Dimension(156, 24));
  107.         jCysf.setPreferredSize(new Dimension(53, 23));
  108.         jCysf.addItemListener(new JF_view_query_kcmx_hk_jCysf_itemAdapter(this));
  109.         jByes.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
  110.         jByes.setText("查询");
  111.         jByes.addActionListener(new JF_view_query_kcmx_hk_jByes_actionAdapter(this));
  112.         jFormattedTextField1.setPreferredSize(new Dimension(139, 24));
  113.         jFormattedTextField2.setPreferredSize(new Dimension(139, 24));
  114.         this.setClosable(true);
  115.         this.getContentPane().add(jPanel1, java.awt.BorderLayout.NORTH);
  116.         jPanel2.setLayout(flowLayout1);
  117.         jCheckBox1.setText("查询条件");
  118.         jLabel1.setText("选择字段:");
  119.         jPanel1.add(jPanel2);
  120.         jPanel2.add(jCheckBox1);
  121.         jPanel2.add(jLabel1);
  122.         jPanel2.add(jCid);
  123.         jPanel2.add(jLabel4);
  124.         jPanel2.add(jCysf);
  125.         jPanel2.add(jLabel6);
  126.         jPanel2.add(jTvalue);
  128.         jPanel1.add(jPanel3);
  129.         jPanel3.add(jCheckBox2);
  130.         jPanel3.add(jLabel2);
  131.         jPanel3.add(jFormattedTextField1);
  132.         jPanel3.add(jLabel3);
  133.         jPanel3.add(jFormattedTextField2);
  134.         jPanel3.add(jByes);
  135.         this.getContentPane().add(jScrollPane1, java.awt.BorderLayout.CENTER);
  136.         jScrollPane1.getViewport().add(jTable1);
  137.         gridLayout1.setColumns(1);
  138.         gridLayout1.setRows(2);
  139.         jPanel1.setLayout(gridLayout1);
  141.         this.setSize(750,550);
  142.         this.setVisible(true);
  143.         UIManager.setLookAndFeel("javax.swing.plaf.metal.MetalLookAndFeel");
  144.         SwingUtilities.updateComponentTreeUI(this);
  145.     }
  146.     public void buildTable(){//"药品名称","药品批号","规格","产地","单位",,"零售价","有效期至"
  147.         String[] tname = {"销售单据号","客户编号","销售金额","销售数量","实收金额","回款金额","回款日期"};
  148.         java.util.Vector vname = new java.util.Vector();
  149.         for (int i = 0 ; i < tname.length ; i++){
  150.             vname.addElement(tname[i]);
  151.         }
  152.         tableModel = new DefaultTableModel(vname,0);
  153.         jTable1.setModel(tableModel);
  154.         TableColumnModel tcm = jTable1.getColumnModel();
  156.     }
  158.     public static void main(String[] args) {
  159.         JF_view_query_kcmx_hk jf_query_view = new JF_view_query_kcmx_hk();
  160.     }
  162.     public void jCheckBox2_stateChanged(ChangeEvent e) {
  163.         if(jCheckBox2.isSelected()){
  164.             jFormattedTextField1.setEnabled(true);
  165.             jFormattedTextField2.setEnabled(true);
  166.             long nCurrentTime = System.currentTimeMillis();
  167.             java.util.Calendar calendar = java.util.Calendar.getInstance(new
  168.                     Locale("CN"));
  169.             calendar.setTimeInMillis(nCurrentTime);
  170.             int year = calendar.get(Calendar.YEAR);
  171.             int month = calendar.get(Calendar.MONTH) + 1;
  172.             int day = calendar.get(Calendar.DAY_OF_MONTH);
  173.             String mm, dd;
  174.             if (month < 10) {
  175.                 mm = "0" + String.valueOf(month);
  176.             } else {
  177.                 mm = String.valueOf(month);
  178.             }
  179.             if (day < 10) {
  180.                 dd = "0" + String.valueOf(day);
  181.             } else {
  182.                 dd = String.valueOf(day);
  183.             }
  185.           //  System.out.println(year + "-" + mm + "-" + dd);
  186.             java.sql.Date date = java.sql.Date.valueOf(year + "-" + mm + "-" +
  187.                     dd);
  188.             jFormattedTextField1.setText(String.valueOf(date));
  189.             jFormattedTextField2.setText(String.valueOf(date));
  191.         }else{
  192.             jFormattedTextField1.setEnabled(false);
  193.             jFormattedTextField2.setEnabled(false);
  194.             jFormattedTextField1.setText(String.valueOf(""));
  195.              jFormattedTextField2.setText(String.valueOf(""));
  196.         }
  198.     }
  200.     public void jByes_actionPerformed(ActionEvent e) {
  201.         if (jCheckBox1.isSelected()){
  202.            if (jTvalue.getText().trim().length() <= 0){
  203.                JOptionPane.showMessageDialog(null, "请输入查询数值!!", "提示",
  204.                                              JOptionPane.ERROR_MESSAGE);
  205.                jTvalue.requestFocus();
  206.                return;
  207.           }
  208.        }
  210.        String[] tname = {"销售单据号","客户编号","销售金额","销售数量","实收金额","回款金额","回款日期"};
  211.         java.util.Vector vname = new java.util.Vector();
  212.         for (int i = 0 ; i < tname.length ; i++){
  213.             vname.addElement(tname[i]);
  214.         }
  215.         tableModel = new DefaultTableModel(vname,0);
  216.         jTable1.setModel(tableModel);
  219.         String whereStr = null,queryStr = null;
  220.         System.out.println(_ysfIndex);
  221.         if(jCheckBox1.isSelected() && !jCheckBox2.isSelected()){
  222.             if (jTvalue.getText().trim().length() <= 0){
  223.                 JOptionPane.showMessageDialog(null, "请输入查询数值!!", "提示",
  224.                                               JOptionPane.ERROR_MESSAGE);
  225.                 jTvalue.requestFocus();
  226.                 return;
  227.             }
  228.             if (_ysfIndex == 0){
  229.                whereStr = name[_idIndex] + " " + jCysf.getSelectedItem() + " '" +
  230.                           jTvalue.getText().trim() + "%'";
  231.             }else{
  232.               whereStr = name[_idIndex] + " " + jCysf.getSelectedItem() + " '" +
  233.                      jTvalue.getText().trim() + "'";
  234.             }
  236.         }else if(jCheckBox1.isSelected()&& jCheckBox2.isSelected()){
  237.             if (jTvalue.getText().trim().length() <= 0){
  238.                 JOptionPane.showMessageDialog(null, "请输入查询数值!!", "提示",
  239.                                               JOptionPane.ERROR_MESSAGE);
  240.                 jTvalue.requestFocus();
  241.                 return;
  242.             }
  243.             java.sql.Date date1,date2 ;
  244.             try{
  245.                 date1 = java.sql.Date.valueOf(jFormattedTextField1.getText().trim());
  246.                 date2 = java.sql.Date.valueOf(jFormattedTextField2.getText().trim());
  247.                 System.out.println("date1 = " + date1 + "; date2 = " + date2);
  248.                 jFormattedTextField1.setText(String.valueOf(date1));
  249.                 jFormattedTextField2.setText(String.valueOf(date2));
  250.                 if (date1.after(date2)){
  251.                     JOptionPane.showMessageDialog(null,"输入的起始日期不能小于终止日期!!!","系统提示",JOptionPane.ERROR_MESSAGE);
  252.                     return;
  253.                 }
  254.             }catch(java.lang.NumberFormatException formate){
  255.                 JOptionPane.showMessageDialog(null,"输入的日期有误!!!n" + formate.getMessage(),"系统提示",JOptionPane.ERROR_MESSAGE);
  256.                 return;
  257.             }
  258.             if (_ysfIndex == 0){
  259.                whereStr = name[_idIndex] + " " + jCysf.getSelectedItem() + " '" +
  260.                           jTvalue.getText().trim() + "%' and hkrq >= '" + date1 + "' and hkrq <= '" + date2 + "'";
  261.             }else{
  262.                 whereStr = name[_idIndex] + " " + jCysf.getSelectedItem() + " '" +
  263.                    jTvalue.getText().trim() + "' and hkrq >= '" + date1 + "' and hkrq <= '" + date2 + "'";
  264.             }
  266.         }else if(!jCheckBox1.isSelected() && jCheckBox2.isSelected()){
  267.             java.sql.Date date1,date2 ;
  268.             try{
  269.                 date1 = java.sql.Date.valueOf(jFormattedTextField1.getText().trim());
  270.                 date2 = java.sql.Date.valueOf(jFormattedTextField2.getText().trim());
  271.                 System.out.println("date1 = " + date1 + "; date2 = " + date2);
  272.                 jFormattedTextField1.setText(String.valueOf(date1));
  273.                 jFormattedTextField2.setText(String.valueOf(date2));
  274.                 if (date1.after(date2)){
  275.                     JOptionPane.showMessageDialog(null,"输入的起始日期不能小于终止日期!!!","系统提示",JOptionPane.ERROR_MESSAGE);
  276.                     return;
  277.                 }
  278.             }catch(java.lang.NumberFormatException formate){
  279.                 JOptionPane.showMessageDialog(null,"输入的日期有误!!!n" + formate.getMessage(),"系统提示",JOptionPane.ERROR_MESSAGE);
  280.                 return;
  281.             }
  282.             whereStr = " hkrq >= '" + date1 + "' and hkrq <= '" + date2 + "'";
  284.         }else if(!jCheckBox1.isSelected() && !jCheckBox2.isSelected()){
  285.             return;
  286.         }
  287.         queryStr = " from Obj_SellMain where " + whereStr + " and qssts = 'T'" ;
  288.         System.out.println(queryStr);
  289.         java.util.List list = appjxc.dao.AdapterDao.QueryObject(queryStr);
  290.         if (list.size() <= 0){
  291.             JOptionPane.showMessageDialog(null,"没有找到满足条件的数据!!","系统提示",JOptionPane.INFORMATION_MESSAGE);
  292.             return;
  293.         }
  294.         int rowcount = jTable1.getRowCount();
  296.         System.out.println("list.size() = " + list.size());
  297.         java.util.Iterator iterator = list.iterator();
  298.         //DefaultTableModel table = new DefaultTableModel();
  299.         while(iterator.hasNext()){
  300.             Obj_SellMain buy = (Obj_SellMain)iterator.next();
  301.             java.util.Vector vdata = new java.util.Vector();
  302.             vdata.addElement(buy.getXsdjh());
  303.             vdata.addElement(buy.getKhbh());
  304.             vdata.addElement(String.valueOf(buy.getXsje()));
  305.             vdata.addElement(String.valueOf(buy.getXszs()));
  306.             vdata.addElement(String.valueOf(buy.getSsje()));
  307.             vdata.addElement(String.valueOf(buy.getHkje()));
  308.             vdata.addElement(buy.getHkrq());
  310.             tableModel.addRow(vdata);
  311.         }
  312.         jTable1.setModel(tableModel);
  313.         jTable1.setRowHeight(20);
  314.     }
  316.     public void jCid_itemStateChanged(ItemEvent e) {
  317.         _idIndex = jCid.getSelectedIndex();
  318.     }
  320.     public void jCysf_itemStateChanged(ItemEvent e) {
  321.         _ysfIndex = jCysf.getSelectedIndex();
  322.     }
  323. }
  326. class JF_view_query_kcmx_hk_jByes_actionAdapter implements ActionListener {
  327.     private JF_view_query_kcmx_hk adaptee;
  328.     JF_view_query_kcmx_hk_jByes_actionAdapter(JF_view_query_kcmx_hk adaptee) {
  329.         this.adaptee = adaptee;
  330.     }
  332.     public void actionPerformed(ActionEvent e) {
  333.         adaptee.jByes_actionPerformed(e);
  334.     }
  335. }
  338. class JF_view_query_kcmx_hk_jCid_itemAdapter implements ItemListener {
  339.     private JF_view_query_kcmx_hk adaptee;
  340.     JF_view_query_kcmx_hk_jCid_itemAdapter(JF_view_query_kcmx_hk adaptee) {
  341.         this.adaptee = adaptee;
  342.     }
  344.     public void itemStateChanged(ItemEvent e) {
  345.         adaptee.jCid_itemStateChanged(e);
  346.     }
  347. }
  350. class JF_view_query_kcmx_hk_jCysf_itemAdapter implements ItemListener {
  351.     private JF_view_query_kcmx_hk adaptee;
  352.     JF_view_query_kcmx_hk_jCysf_itemAdapter(JF_view_query_kcmx_hk adaptee) {
  353.         this.adaptee = adaptee;
  354.     }
  356.     public void itemStateChanged(ItemEvent e) {
  357.         adaptee.jCysf_itemStateChanged(e);
  358.     }
  359. }
  362. class JF_view_query_kcmx_hk_jCheckBox2_changeAdapter implements ChangeListener {
  363.     private JF_view_query_kcmx_hk adaptee;
  364.     JF_view_query_kcmx_hk_jCheckBox2_changeAdapter(JF_view_query_kcmx_hk adaptee) {
  365.         this.adaptee = adaptee;
  366.     }
  368.     public void stateChanged(ChangeEvent e) {
  369.         adaptee.jCheckBox2_stateChanged(e);
  370.     }
  371. }