bookfine.cpp

全面剖析图书馆管理的内容

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

#include <vcl.h>
#pragma hdrstop

#include "BookFine.h"
//---------------------------------------------------------------------------
#pragma package(smart_init)
#pragma link "Parent"
#pragma resource "*.dfm"
TfmBookFine *fmBookFine;
//---------------------------------------------------------------------------
__fastcall TfmBookFine::TfmBookFine(TComponent* Owner)
    : TfmParent(Owner)
{
    this->szCondition1 = "读者编号";
    this->szCondition2 = "读者条码";
    this->szCondition3 = "图书编号";
    // 设置查询条件
    this->SetSeekEditStatus();
    // 和以前的窗体不一样,我们在这里打开Table1
    Table1->Active = true;
    // 设置可以操作
    Panel2->Enabled = true;
    lblCount->Caption = "记录数: " + IntToStr(Table1->RecordCount) ;
}
//---------------------------------------------------------------------------
void __fastcall TfmBookFine::btFineClick(TObject *Sender)
{
    if(Table1->FieldByName("罚款编号")->AsString == "")
        return;
    TQuery* pQuery = new TQuery(NULL);
    AnsiString sql;
    pQuery->DatabaseName = "db";
    sql = "update 图书罚款 set 实收金额=";
    sql += Edit4->Text + ", 是否交款=1 where 罚款编号='";
    sql += Table1->FieldByName("罚款编号")->AsString;
    sql += "'";
    pQuery->SQL->Add(sql);
    pQuery->ExecSQL();
    delete pQuery;
    // 更新显示
    BitBtn1Click(NULL);
}
//---------------------------------------------------------------------------
void __fastcall TfmBookFine::BitBtn1Click(TObject *Sender)
{
    // 注意这里的代码
    // 因为DBGrid只显示没有归还的数据
    // 所以要继承搜索按钮
    // 添加filter属性
    TfmParent::BitBtn1Click(Sender);
    AnsiString szFilter;
    szFilter = Table1->Filter;
    if(szFilter.Length()>0)
       szFilter += " and ";
    szFilter += "是否交款=0";
    Table1->Filtered = false;
    Table1->Filter = szFilter;
    Table1->Filtered = true;
    lblCount->Caption = "记录数: " + IntToStr(Table1->RecordCount) ;
}
//---------------------------------------------------------------------------
void __fastcall TfmBookFine::Table1AfterScroll(TDataSet *DataSet)
{
    Edit4->Text = Table1->FieldByName("应罚金额")->AsString;
}
//---------------------------------------------------------------------------