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

#include <vcl.h>
#pragma hdrstop

#include "Unit1.h"
#include "Unit2.h"
#include "Unit3.h"
#include "Unit5.h"
//---------------------------------------------------------------------------
#pragma package(smart_init)
#pragma resource "*.dfm"
TForm5 *Form5;
//---------------------------------------------------------------------------
__fastcall TForm5::TForm5(TComponent* Owner)
        : TForm(Owner)
{
}
//---------------------------------------------------------------------------


void __fastcall TForm5::Button1Click(TObject *Sender)
{
bool FindResult=false;
Form1->IBTable2->Cancel();


if(Edit1->Text=="")
ShowMessage("請確認(rèn)輸入不為空");
else FindResult=FindByStu_NO(Edit1->Text);
Form5->Close();
}
//---------------------------------------------------------------------------

void __fastcall TForm5::Button2Click(TObject *Sender)
{
Close();
}
//---------------------------------------------------------------------------

bool TForm5::FindByStu_NO(String str)
{
  int i,n;
  n=DM1->IBTable2->RecordCount;
  Form1->IBTable2->First();
  for(i=0;i<n;i++)
  {

          if (Form1->IBTable2->FieldByName("STU_NO")->AsInteger==StrToInt(str))
          break;
          Form1->IBTable2->Next();

  }
  if(i==n)
  {
          ShowMessage("沒找到需要得數(shù)據(jù)，請確認(rèn)輸入是否正確");
  }
  else
  Close();
}
//-------------------------------------------------------------------
bool TForm5::FindByName(String str)
{
    int i,n;
    String Temp;
    char buff[10];
    n=Form1->IBTable2->RecordCount;
    Form1->IBTable2->First();
    for(i=0;i<n;i++)
    {
            Temp=Form1->IBTable2->FieldByName("NAME")->AsString;
           // sprintf(buff,"%s",Temp);
        
            if (Temp==str)
            return 1;
            Form1->IBTable2->Next();
       
    }
    if(i==n)
    {
            ShowMessage("沒找到需要得數(shù)據(jù)，請確認(rèn)輸入是否正確");
    }
    else
    Close();
}