query6_0.cpp

校园刷卡系统

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

#include <vcl.h>
#pragma hdrstop

#include "Query6_0.h"
//---------------------------------------------------------------------------
#pragma package(smart_init)
#pragma resource "*.dfm"

extern void HISQuery(TQuery*qPtr,String&s,bool b);
extern bool isInteger(AnsiString str,bool minus);

TQueryForm6_0 *TQueryForm6_0;
//---------------------------------------------------------------------------
__fastcall TQueryForm6_0::TQueryForm6_0(TComponent* Owner)
        : TForm(Owner)
{
}
//---------------------------------------------------------------------------

void __fastcall TQueryForm6_0::LabeledEdit1KeyDown(TObject *Sender, WORD &Key,
      TShiftState Shift)
{
if(Key==13)
{
if(LabeledEdit1->Text!="")
{
if(isInteger(LabeledEdit1->Text,false))
{
String s=LabeledEdit1->Text;
String sql="select * from Employee where empID='"+s+"'";
HISQuery(Query1,sql,true);
if(Query1->IsEmpty())
{ShowMessage("此工号不存在！");Query1->Close();}
}
else
{ShowMessage("工号非法，必须是整型数！");}
}
else{ShowMessage("工号不能为空！");}
}
}
//---------------------------------------------------------------------------