smsoperate.cpp

Web URL 解析程序服务器端

#include "SMSOperate.h"

bool CSMSOperate::PutRecvSMS(const RECVSM rsm)
{
	if(NULL == m_pDB) return false;
	if(NULL == &rsm) return false;

	string strSQL;
	if(rsm.strProvider == "0")//china union
	{
		strSQL = "INSERT INTO platform.tblRecvsms(recvID,sournum,destnum,dcs,content,ProvinceId,LinkID) ";
		strSQL += "VALUES (platform.SQRECVSMS_ID.nextval, '"+rsm.strSourNum+"', '"+rsm.strDestNum+"', 8, '"+rsm.strContent+"', 250, '"+rsm.strLinkID+"')";	
	}
	else if(rsm.strProvider == "1")//china mobile
	{
		strSQL = "INSERT INTO platform.tblRecvsmsCM(recvID,SrcTerminalId,DestId,MsgContentGB,ProvinceId,LinkID) ";
		strSQL += "VALUES (platform.SQRecvSMSCM_id.nextval, '"+rsm.strSourNum+"', '"+rsm.strDestNum+"',  '"+rsm.strContent+"', 150, '"+rsm.strLinkID+"')";
	}
	else
		return false;
	
	m_pDB->TransStart();
	if(m_pDB->Update(strSQL))
	{
		m_pDB->TransCommit();
		return true;
	}
	else
	{
		m_pDB->TransRollback();
		return false;
	}
}