servermodule.h

停车场用

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

#ifndef ServerModuleH
#define ServerModuleH
//---------------------------------------------------------------------------
#include <Classes.hpp>
#include <Controls.hpp>
#include <StdCtrls.hpp>
#include <Forms.hpp>
#include <ADODB.hpp>
#include <Db.hpp>
#include <DBTables.hpp>
//---------------------------------------------------------------------------
class TServerDataModule : public TDataModule
{
__published:	// IDE-managed Components
        TADOConnection *m_ADOConnection;
        TADOQuery *m_RecordADOQuery;
        TADOQuery *m_OtherADOQuery;
        TADOQuery *m_InADOQuery;
        TADOQuery *m_EditADOQuery;
        TADOQuery *m_IODataADOQuery;
private:	// User declarations
public:		// User declarations
    __fastcall TServerDataModule(TComponent* Owner);
};
//---------------------------------------------------------------------------
extern TServerDataModule *ServerDataModule;

//打开ADO数据库
extern int OpenADODatabase(void);
//打开Access数据库
extern int OpenAccessDatabase(char *pszFile);
//关闭Access数据库
extern void CloseADODatabase(void);

//获取数据库记录表
extern TDataSet *GetRecordQuery(void);
//获取数据库编辑表
extern TDataSet  *GetEditQuery(void);
//获取数据库主表
extern TDataSet  *GetMainQuery(void);
//获取数据库其它表
extern TDataSet  *GetOtherQuery(void);
//获取停车场内车辆记录表
extern TDataSet *GetParkInQuery(void);
//获取刷卡进出记录表
extern TDataSet *GetIODataQuery(void);

//断开数据库连接
extern int DisableRecordTable(void);
//恢复数据库连接
extern int EnableRecordTable(void);

//设置打开Record表
extern int OpenRecordTable(void);
//设置打开Record表用于添加
extern int OpenMainTable(void);

//查询Record表
extern int QueryADORecordTable(char *pszWhere,char *pszOrder);
//用OtherADOQuery元件查询一个表
extern int OpenOtherQuery(char *pszTable,char *pszWhere,char *pszOrder);
//用OtherADOQuery元件删除一个表中记录
extern int EmptyOtherQuery(char *pszTable,char *pszWhere);
//用EditADOQuery元件查询一个表中记录
extern int OpenEditQuery(char *pszTable,char *pszWhere,char *pszOrder);
//---------------------------------------------------------------------------
#endif