inoutsum.cpp

供销存软件

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

#include <vcl.h>
#pragma hdrstop

#include "inoutSum.h"
#include "DataModule.h"
//---------------------------------------------------------------------------
#pragma package(smart_init)
#pragma resource "*.dfm"
TioSumForm *ioSumForm;
//---------------------------------------------------------------------------
__fastcall TioSumForm::TioSumForm(TComponent* Owner)
        : TForm(Owner)
{
}
//---------------------------------------------------------------------------
void __fastcall TioSumForm::searchBtnClick(TObject *Sender)
{
        DM->ADOQ->Close();
        DM->ADOQ->SQL->Clear();
        DM->ADOQ->SQL->Add("select * from 应收应付明细表 where 结算单号 is null");
        DM->ADOQ->Open();
        double sum=0;
        while(!DM->ADOQ->Eof)
        {
                   sum+=DM->ADOQ->FieldByName("结余金额")->AsString.Trim().ToDouble();
                   DM->ADOQ->Next();
        }
        Sum->Caption=sum;
}
//---------------------------------------------------------------------------

void __fastcall TioSumForm::closeBtnClick(TObject *Sender)
{
        
        Close();
}
//---------------------------------------------------------------------------

void __fastcall TioSumForm::FormClose(TObject *Sender,
      TCloseAction &Action)
{
       DM->ADOQ->Close();
}
//---------------------------------------------------------------------------