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

#include <vcl.h>
#pragma hdrstop

#include "BookReturn.h"
//---------------------------------------------------------------------------
#pragma package(smart_init)
#pragma link "Parent"
#pragma resource "*.dfm"
TfmBookReturn *fmBookReturn;
//---------------------------------------------------------------------------
__fastcall TfmBookReturn::TfmBookReturn(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 TfmBookReturn::btReturnClick(TObject *Sender)
{
    if(Table1->FieldByName("借閱編號")->AsString == "")
        return;
    //判斷是否過期，如果過期提示輸入罰款金額
    TDateTime dt,dt1;
    dt = dt.CurrentDate();
    dt1 = Table1->FieldByName("應還時間")->AsString;
    AnsiString NewString = "0";
    if(dt>dt1)
    {
        // 獲得罰款金額
        if (!InputQuery("歸還的圖書已過期,請輸入罰款金額,取消不罰款", "提示", NewString))
            NewString = "0";

    }
    TQuery* pQuery = new TQuery(NULL);
    AnsiString sql;
    pQuery->DatabaseName = "db";
    sql = "exec sf_圖書歸還 ";
    sql += Table1->FieldByName("借閱編號")->AsString;
    sql += "," + NewString;
    pQuery->SQL->Add(sql);
    pQuery->ExecSQL();
    delete pQuery;
    // 更新顯示
    BitBtn1Click(NULL);
}
//---------------------------------------------------------------------------
void __fastcall TfmBookReturn::BitBtn1Click(TObject *Sender)
{
    // 注意這里的代碼
    // 因為DBGrid只顯示沒有歸還的數據
    // 所以要繼承搜索按鈕
    // 添加filter屬性
    TfmParent::BitBtn1Click(Sender);
    AnsiString szFilter;
    szFilter = Table1->Filter;
    if(szFilter.Length()>0)
       szFilter += " and ";
    szFilter += "狀態='未還'";
    Table1->Filtered = false;
    Table1->Filter = szFilter;
    Table1->Filtered = true;
    lblCount->Caption = "記錄數: " + IntToStr(Table1->RecordCount) ;
}
//---------------------------------------------------------------------------