selectreader.cpp

C++ Builder数据库开发经典案例解析 示例程序都是在C++ Builder 6.0（Enterprise）和SQL Server 2000个人版下调试通过的

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

#include <vcl.h>
#pragma hdrstop

#include "SelectReader.h"
//---------------------------------------------------------------------------
#pragma package(smart_init)
#pragma link "Parent"
#pragma resource "*.dfm"
TfmSelectReader *fmSelectReader;
//---------------------------------------------------------------------------
__fastcall TfmSelectReader::TfmSelectReader(TComponent* Owner)
    : TForm(Owner)
{
    m_szReaderCode = "";
}
//---------------------------------------------------------------------------
void __fastcall TfmSelectReader::BitBtn1Click(TObject *Sender)
{
    Table1->Filter = "";
    AnsiString szFilter;
    // 设置条件
    if(!Edit1->Text.IsEmpty())
        szFilter = "条形码 = '" + Edit1->Text + "*' and ";
    if(!Edit2->Text.IsEmpty())
        szFilter = "编号 = '" + Edit2->Text + "*' and ";
    if(!Edit3->Text.IsEmpty())
        szFilter = "书名 = '" + Edit1->Text + "*' and ";
}
//---------------------------------------------------------------------------

void __fastcall TfmSelectReader::Edit3KeyPress(TObject *Sender, char &Key)
{
    if(Key == 13)
        BitBtn1->Click() ;
    // 将焦点放置到DBGrid，以便选择
    DBGrid1->SetFocus();
}
//---------------------------------------------------------------------------
void __fastcall TfmSelectReader::DBGrid1KeyPress(TObject *Sender, char &Key)
{
    // 回车选择图书
    if(Key == 13)
    {
        m_szReaderCode = Table1->FieldByName("编号")->AsString;
        this->Close();
    }

}
//---------------------------------------------------------------------------
void __fastcall TfmSelectReader::DBGrid1DblClick(TObject *Sender)
{
    DBGrid1KeyPress(NULL, 13);
}
//---------------------------------------------------------------------------