//---------------------------------------------------------------------
#include <vcl.h>
#pragma hdrstop

#include "UChaXun2.h"
//---------------------------------------------------------------------
#pragma resource "*.dfm"
TChaXun2 *ChaXun2;

//---------------------------------------------------------------------
String CutSpace(char *Str)
{
  String s;
  s="";
  while(*Str)
  {
    if((*Str!=' ')&&(*Str!='　')) s=s+(*Str);
    Str++;
  }
  return s;
}
__fastcall TChaXun2::TChaXun2(TComponent* AOwner)
	: TForm(AOwner)
{
}
//---------------------------------------------------------------------



void __fastcall TChaXun2::Button2Click(TObject *Sender)
{
 IsOk=0;
 Close();
}
//---------------------------------------------------------------------------



void __fastcall TChaXun2::Button1Click(TObject *Sender)
{
  String s;
  IsOk=1;
  s="";
  cmdSQL="select* from 公共設施使用 " ;

  if(edBH8->Text!="") s=" 設施編號 = '"+edBH8->Text+"'" ;
    if(edMC3->Text!="")
    {
     if(s!="") s=s+" and ";
     if(CheckBox1->Checked) s=s+" 使用人員名稱 like '%"+edMC3->Text+"%'";
      else s=s+" 使用人員名稱 ='"+edMC3->Text+"'";
     }
     if(s!="") cmdSQL=cmdSQL=cmdSQL+" where " + s;
     Close();
}

//---------------------------------------------------------------------------

void __fastcall TChaXun2::edBH8KeyDown(TObject *Sender, WORD &Key,
      TShiftState Shift)
{
  if(Key==13)  ActiveControl=edMC3;       
}
//---------------------------------------------------------------------------

void __fastcall TChaXun2::edMC3KeyDown(TObject *Sender, WORD &Key,
      TShiftState Shift)
{
  if(Key==13)  ActiveControl=Button1;
}
//---------------------------------------------------------------------------

void __fastcall TChaXun2::edBH8Exit(TObject *Sender)
{
  edBH8->Text=CutSpace(edBH8->Text.c_str());        
}
//---------------------------------------------------------------------------

void __fastcall TChaXun2::edMC3Exit(TObject *Sender)
{
  edMC3->Text=CutSpace(edMC3->Text.c_str());        
}
//---------------------------------------------------------------------------