package com.jbaptech.accp.netbar.client;

import javax.swing.*;
import java.awt.BorderLayout;
import java.awt.Rectangle;

public class CardQueryPanel extends JPanel{
  BorderLayout borderLayout1 = new BorderLayout();
   JSplitPane jSplitPane1 = new JSplitPane();
   JPanel jPanel1 = new JPanel();
   JScrollPane jScrollPane1 = new JScrollPane();
   JLabel jLabel1 = new JLabel();
   JLabel jLabel2 = new JLabel();
//   TableScrollPane tableScrollPane1 = new TableScrollPane();
//   JdbTable jdbTable1 = new JdbTable();
//   Database database1 = new Database();

   public CardQueryPanel(NetBarFeeMangementFrame mFrame1,int ID) {
     try {
       Frame1 = mFrame1;
       CardID = ID;
       jbInit();
     }
     catch(Exception ex) {
       ex.printStackTrace();
     }
   }
   void jbInit() throws Exception {
     this.setLayout(borderLayout1);
     jSplitPane1.setOrientation(JSplitPane.VERTICAL_SPLIT);
     jPanel1.setLayout(null);

     jLabel1.setFont(new java.awt.Font("Serif", 0, 16));
     jLabel1.setText("卡號：");
     jLabel1.setBounds(new Rectangle(140, 20, 65, 25));

     jLabel2.setText(Integer.toString(CardID));
     jLabel2.setBounds(new Rectangle(205, 20, 55, 25));
 /*    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select CardId,ComputerID,BeginTime,EndTime from dbo.Event where CardID = "+CardID, null, true, Load.ALL));
  */

 /*
     database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:microsoft:sqlserver://keweixing:1433;DatabaseName=dbbar", "sa", "", false, "com.microsoft.jdbc.sqlserver.SQLServerDriver"));

     queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT CardID, ComputerID, BeginTime, EndTime FROM Event WHERE CardID = 12345678", null, true, Load.ALL));
     jdbTable1.setDataSet(queryDataSet1);
     column1.setCaption("卡號");
     column1.setColumnName("CardID");
     column1.setDataType(com.borland.dx.dataset.Variant.INT);
     column1.setTableName("Event");
     column1.setServerColumnName("CardID");
     column1.setSqlType(4);
     column2.setCaption("機器號");
     column2.setColumnName("ComputerID");
     column2.setDataType(com.borland.dx.dataset.Variant.INT);
     column2.setTableName("Event");
     column2.setServerColumnName("ComputerID");
     column2.setSqlType(4);
     column3.setCaption("開始時間");
     column3.setColumnName("BeginTime");
     column3.setDataType(com.borland.dx.dataset.Variant.TIME);
     column3.setTableName("Event");
     column3.setServerColumnName("BeginTime");
     column3.setSqlType(93);
     column4.setCaption("結束時間");
     column4.setColumnName("EndTime");
     column4.setDataType(com.borland.dx.dataset.Variant.TIME);
     column4.setTableName("Event");
     column4.setServerColumnName("EndTime");
     column4.setSqlType(93);
     this.add(jSplitPane1, BorderLayout.CENTER);
     jSplitPane1.add(jPanel1, JSplitPane.LEFT);
     jPanel1.add(jLabel1, null);
     jPanel1.add(jLabel2, null);
     jSplitPane1.add(jScrollPane1, JSplitPane.RIGHT);
     jScrollPane1.getViewport().add(tableScrollPane1, null);
     tableScrollPane1.getViewport().add(jdbTable1, null);
     jSplitPane1.setDividerLocation(60);
     queryDataSet1.setColumns(new Column[] {column1, column2, column3, column4});
     Frame1.login_false();
     Frame1.SetCardID(0);
  */
   }

   private NetBarFeeMangementFrame Frame1;
   private int CardID;
//   QueryDataSet queryDataSet1 = new QueryDataSet();
//   Column column1 = new Column();
//   Column column2 = new Column();
//   Column column3 = new Column();
//  Column column4 = new Column();

}