selectmaterial.cpp

C++Builder6下的一个生产管理系统

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

#include <vcl.h>
#pragma hdrstop

#include "selectmaterial.h"
//---------------------------------------------------------------------------
#pragma package(smart_init)
#pragma resource "*.dfm"
TfmSelectMat *fmSelectMat;
//-------------------------------------------------------
__fastcall TfmSelectMat::TfmSelectMat(TComponent* Owner)
    : TForm(Owner)
{
}
//-------------------------------------------------------
void __fastcall TfmSelectMat::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 = "拼音编码 = '" + Edit3->Text + "*' and ";
    // 清除最后多余的and
    szFilter = szFilter.SubString(1,szFilter.Length()-5);
    Table1->Filter = szFilter;
    Table1->Filtered = true;
}
//-------------------------------------------------------
void __fastcall TfmSelectMat::DBGrid1KeyUp(TObject *Sender, WORD &Key,
      TShiftState Shift)
{
    DBGrid1DblClick(NULL);
}
//-------------------------------------------------------
void __fastcall TfmSelectMat::DBGrid1DblClick(TObject *Sender)
{
    this->Close();
}
//-------------------------------------------------------