smsado.h

使用短信猫可以实现短信的群发

// SMSADO.h: interface for the CSMSADO class.
//
//////////////////////////////////////////////////////////////////////

#pragma warning(disable:4146)

#if !defined(AFX_SMSADO_H__6E3D494C_7E2A_4F47_8CEB_C879BD74BCDA__INCLUDED_)
#define AFX_SMSADO_H__6E3D494C_7E2A_4F47_8CEB_C879BD74BCDA__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000

#ifndef IMPORT_ADO_COM
#define IMPORT_ADO_COM
#import "msado15.dll" no_namespace rename("EOF","rsEOF")
//C:\Program Files\Common Files\System\ado\msado15.dll
#endif

typedef _RecordsetPtr SQLRECORDSET; //记录集智能指针 取别名 其实记录集智能指针,是一个对象只不过是重载了->操作符
typedef _ConnectionPtr SQLCONNECT; //连接智能指针 取别名
typedef SYSTEMTIME DBDATETIME;

class CSMSADO  
{
public:
	BOOL m_IsAdoConSuc;
	CSMSADO();
	virtual ~CSMSADO();

	HRESULT ConnectServer(CString pServerName,CString pUserName,CString pPassWord);
	SQLRECORDSET ExecuteWithRecordset(CString SQLStr);
	int GetIntegerFieldVal(SQLRECORDSET prs, CString pFieldName);
	double GetDoubleFieldVal(SQLRECORDSET prs, CString pFieldName);

	DBDATETIME GetDateTimeFeildVal(SQLRECORDSET prs,CString pFieldName);
	CString CSMSADO::GetDateTimeFeildTextValue(SQLRECORDSET prs,CString pFieldName);

	CString GetTextFieldVal(SQLRECORDSET rs,CString fieldName);
	CString GetDataTimeText(DBDATETIME dataTime);
	long ExecuteWithoutRecordset(CString SQLStr);
	void CloseConnect();
	BOOL IsConnection();
	HRESULT ConCommitTrans();
	
	SQLCONNECT m_Connection;

};

#endif // !defined(AFX_SMSADO_H__6E3D494C_7E2A_4F47_8CEB_C879BD74BCDA__INCLUDED_)