DataModuleUnit.h

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

#ifndef DataModuleUnitH
#define DataModuleUnitH
//---------------------------------------------------------------------------
#include <Classes.hpp>
#include <Controls.hpp>
#include <StdCtrls.hpp>
#include <Forms.hpp>
#include <ADODB.hpp>
#include <DB.hpp>
//---------------------------------------------------------------------------
class TDataModule1 : public TDataModule
{
__published:	// IDE-managed Components
        TADOConnection *ADOConnection;
        TADOQuery *WeightADOQuery;
        TADOQuery *AgeADOQuery;
        TADOQuery *BeltADOQuery;
        TADOQuery *PlayersADOQuery;
        TADOQuery *ResultsADOQuery;
        TADOQuery *TestADOQuery;
        void __fastcall DataModuleCreate(TObject *Sender);
private:	// User declarations
public:		// User declarations
        __fastcall TDataModule1(TComponent* Owner);
        int GetWeights(TStringList *sl, AnsiString age); //ïîëó÷àåì ñïèñîê âåñîâûõ èç áàçû (îíè ñâÿçàíû ñ âîçðàñòîì)
        int GetAges(TStringList *sl); //ïîëó÷àåì ñïèñîê âîçðàñòíûõ èç áàçû
        int GetBelts(TStringList *sl); //ïîëó÷àåì ñïèñîê ïîÿñîâ èç áàçû
        int GetInfoFromDB(TADOQuery *query, AnsiString fieldName ,TStringList *sl, AnsiString age = NULL);   // îáùàÿ ïðîöåäóðà ïîëó÷åíèÿ äàííûõ èç ÁÄ
        int GetNamesFromDB(TStringList *sl, AnsiString age, AnsiString belt, AnsiString weight); //ïîëó÷åíèå ñïèñêà èìåí áîðöîâ èç ÁÄ
        int WriteResultsToDB(AnsiString pl1, AnsiString scores1, AnsiString pl2,
                AnsiString scores2, AnsiString winner,
                AnsiString winreason, AnsiString TimeToEnd,
                AnsiString age, AnsiString belt, AnsiString weight); //çàïèñü ðåçóëüòàòîâ ñõâàòêè â ÁÄ
        int TestDBConnection(); //òåñòèðîâàíèå ñîåäèíåíèÿ ñ ÁÄ

};
//---------------------------------------------------------------------------
extern PACKAGE TDataModule1 *DataModule1;
//---------------------------------------------------------------------------
#endif