adomanager.cpp

短信群发系统

// AdoManager.cpp: implementation of the CAdoManager class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "notesendsystem.h"
#include "AdoManager.h"

#ifdef _DEBUG
#undef THIS_FILE
static char THIS_FILE[]=__FILE__;
#define new DEBUG_NEW
#endif

//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////

CAdoManager::CAdoManager()
{
	m_connect = NULL;
}

CAdoManager::~CAdoManager()
{
	if(  m_connect )
		m_connect->Close();
}

BOOL CAdoManager::InitInstance()
{
	try
	{
		m_connect.CreateInstance(__uuidof(Connection));
	}
	catch ( _com_error e )
	{
		CString errormessage;
		errormessage.Format("连接数据库失败!\r\n错误信息:%s",e.ErrorMessage());
		TRACE(errormessage);
		return FALSE;
	}
	return TRUE;
}

BOOL CAdoManager::ConnectDb(CString &connectstr)
{
	m_connect.CreateInstance(__uuidof(Connection));
	try
	{
		m_connect->Open((_bstr_t)connectstr, "", "", adModeUnknown);
	}
	catch(_com_error e)
	{
		CString strError;
		strError.Format("警告:打开连接发生异常.错误信息%s",e.ErrorMessage());
		AfxMessageBox(strError);
		return FALSE;
	}
	return TRUE;
}

BOOL CAdoManager::GetRecordSet(CString &SqlCommand, CAdoRecordSet& rec)
{
	_RecordsetPtr ptr;
	try
	{
		ptr = m_connect->Execute((_bstr_t)SqlCommand, NULL, adCmdText);
		rec.SetRecord(ptr);
		if (ptr->adoEOF) {
			return 2;
		}
	}
	catch ( _com_error e )
	{
		CString errormessage;
		errormessage.Format("AdoConect->GetRecordSet!\r\n错误信息:%s",e.ErrorMessage());
		TRACE(errormessage);
		return FALSE;
	}
	return TRUE;
}

BOOL CAdoManager::ExecuteCmd(CString &SqlCommand)
{
	try
	{	
		_CommandPtr pCmd(__uuidof(Command));
		pCmd->put_ActiveConnection(_variant_t((IDispatch*)m_connect));
		pCmd->CommandText=SqlCommand.AllocSysString();
		pCmd->Execute(NULL,NULL,adCmdText);
	}
	catch (_com_error e)
	{
		CString errormessage;
		errormessage.Format("SQL语句失败!\r\n错误信息:%s",e.ErrorMessage());
		AfxMessageBox(errormessage);
		return FALSE;
	}
	return TRUE;
}

//添加帐户
BOOL CAdoManager::AddAccount(CString &user, CString &pwd, int &type, COleDateTime &time)
{
	CString			command;
	CString			str;
	str = time.Format("%Y-%m-%d %H:%M:%S");
	command.Format("insert into Users values('%s', '%s', '%d', '%s')",user,pwd,type,str);
	return ExecuteCmd(command);
}

//修改密码
BOOL CAdoManager::AmendPwd(CString &user, CString &newpwd)
{
	CString			command;
	command.Format("update Users set Passwd='%s' where UserName='%s'", newpwd, user);
	return ExecuteCmd(command);
}

//修改一个用户的权限
BOOL CAdoManager::AmendAccType(CString &user, int &account_type)
{
	CString			command;
	command.Format("update Users set Authority='%d' where UserName='%s'", account_type, user);
	return ExecuteCmd(command);
}

//删除帐户
BOOL CAdoManager::DelAccount(CString &user)
{
	CString			command;
	command.Format("delete from Users where UserName='%s'", user);
	return ExecuteCmd(command);
}

//添加订单
BOOL CAdoManager::AddOrder(CString &start_time, CString &end_time, CString &content)
{
	CString			command;
	command.Format("insert into Orders values('%s', '%s', '%s')", start_time, end_time, content);
	return ExecuteCmd(command);
}

//修改订单
BOOL CAdoManager::AmendOrder(CString &start_time, CString &end_time, CString &content, int &ID)
{
	CString			command;
	command.Format("update Orders set OrderStart='%s',OrderEnd='%s',Content='%s' where ID='%d'", start_time, end_time, content, ID);
	return ExecuteCmd(command);
}

//删除订单
BOOL CAdoManager::DelOrder(int &OrderId)
{
	CString			command;
	command.Format("delete from Orders where ID='%d'", OrderId);
	return ExecuteCmd(command);
}

//添加号码
BOOL CAdoManager::AddPhoneNo(int &order_id, CString &no)
{
	CString			command;
	command.Format("insert into PhoneNumber values('%d', '%s')", order_id, no);
	return ExecuteCmd(command);
}


//接收信息
BOOL CAdoManager::SaveRecvMsg(CString &phone_no, CString &content, CString &timestr)
{
	CString			command;
	command.Format("insert into ReceivedLog values('%s', '%s', '%s')", phone_no, content , timestr);
	return ExecuteCmd(command);
}

//保存发送信息
BOOL CAdoManager::SaveSendMsg(int &orderId, CString &sendtime, int &sendState, CString &content, CString &phoneNo)
{
	CString			command;
	command.Format("insert into SendLog values('%d', '%s', '%d', '%s', '%s')", orderId, sendtime , sendState, content, phoneNo);
	return ExecuteCmd(command);
}