#ifndef CCustom_h
#define CCustom_h

#include  "afxdb.h"
class CAccountInfo {
public:
	CAccountInfo();
	~CAccountInfo();
	BOOL Create(HDBC hdbc, CString Tablename);
	void Close();
	BOOL GetBP(CString address);
public:
	HDBC m_hdbc;
    HSTMT m_hstmt;
	CString m_table;
	SQLCHAR szUid[11];
};

class CSwitchInfo {
public:
	CSwitchInfo();
	~CSwitchInfo();
	BOOL Create(HDBC hdbc, CString Tablename);
	void Close();
	BOOL GetSwitch(CString uid);
public:
	HDBC m_hdbc;
    HSTMT m_hstmt;
	CString m_table;
    int m_mailswitch;
	int m_mailfilter;
	int m_mailservice;
	int m_format;
	char m_station[5];
	char m_zone[5];
};

class CFilterInfo {
public:
	CFilterInfo();
	~CFilterInfo();
	BOOL Create(HDBC hdbc, CString Tablename);
	void Close();
	BOOL GetFilter(CString uid,CString address);
public:
	HDBC m_hdbc;
    HSTMT m_hstmt;
	CString m_table;
	char szAddress[50];
	int m_filter;

};

class CMailInfo {
public:
	CMailInfo();
	~CMailInfo();
	BOOL Create(HDBC hdbc, CString Tablename);
	void Close();
	BOOL InsertInfo(LPSTR szUid,int service,char* station, char* zone,char* info);
public:
	HDBC m_hdbc;
	HSTMT m_hstmt;
	CString m_table;
};

#endif