// STKMsgRowSet.cpp : implementation file
|
//
|
|
#include "stdafx.h"
|
#include "mbamdb.h"
|
#include "STKMsgRowSet.h"
|
#include "MBAMDBFun.h"
|
|
// STKMsgRowSet
|
|
CSTKMsgRowSet::CSTKMsgRowSet()
|
{
|
m_pDBConnect = NULL;
|
m_nType = ROWTYPE_NONE;
|
m_pMsgs = NULL;
|
m_pMsgFolders = NULL;
|
}
|
|
CSTKMsgRowSet::~CSTKMsgRowSet()
|
{
|
CleanDataSet( );
|
}
|
|
void CSTKMsgRowSet::operator = ( const CSTKMsgRowSet &Item )
|
{
|
m_nType = Item.m_nType;
|
m_strStartDate = Item.m_strStartDate;
|
|
m_strEndDate = Item.m_strEndDate;
|
m_pDBConnect = Item.m_pDBConnect;
|
m_pMsgs = Item.m_pMsgs;
|
m_pMsgFolders = Item.m_pMsgFolders;
|
}
|
|
void CSTKMsgRowSet::CleanDataSet( )
|
{
|
switch ( m_nType )
|
{
|
case ROWTYPE_MSG:
|
if(m_pMsgs)
|
delete m_pMsgs;
|
m_pMsgs = NULL;
|
break;
|
case ROWTYPE_MSGFOLDER:
|
if(m_pMsgFolders)
|
delete m_pMsgFolders;
|
m_pMsgFolders = NULL;
|
break;
|
case ROWTYPE_FOLDERMGR:
|
delete m_pMsgAttachments;
|
m_pMsgAttachments = NULL;
|
break;
|
}
|
|
m_nType = ROWTYPE_NONE;
|
}
|
|
bool CSTKMsgRowSet::SetDBConnect( CMBAMDBConnect *pDBConnect )
|
{
|
m_pDBConnect = pDBConnect;
|
|
return true;
|
}
|
bool CSTKMsgRowSet::ListTalking3( CString strUser,long nLimitCount, long &nCount, BOOL bTimeAsc/* = FALSE */ )
|
{
|
nCount = 0;
|
if ( strUser.IsEmpty() )
|
return false;
|
if ( !m_pDBConnect || !m_pDBConnect->IsOpenDB() )
|
return false;
|
CleanDataSet();
|
|
m_pDBConnect->AddRef();
|
m_pMsgs = new CMsgs( m_pDBConnect);
|
|
CHighTime tmHigh;
|
SYSTEMTIME tmSystem;
|
|
// Set Filter
|
if ( !m_strStartDate.IsEmpty() && tmHigh.ParseDateTime( m_strStartDate ) )
|
{
|
tmHigh.GetAsSystemTime( tmSystem );
|
if ( tmSystem.wSecond < 0 )
|
tmSystem.wSecond = 0;
|
|
m_pMsgs->m_tmStartDate = COleDateTime( tmSystem.wYear, tmSystem.wMonth, tmSystem.wDay,
|
tmSystem.wHour, tmSystem.wMinute, tmSystem.wSecond );
|
}
|
if ( !m_strEndDate.IsEmpty() && tmHigh.ParseDateTime( m_strEndDate ) )
|
{
|
tmHigh.GetAsSystemTime( tmSystem );
|
if ( tmSystem.wSecond < 0 )
|
tmSystem.wSecond = 0;
|
|
m_pMsgs->m_tmEndDate = COleDateTime( tmSystem.wYear, tmSystem.wMonth, tmSystem.wDay,
|
tmSystem.wHour, tmSystem.wMinute, tmSystem.wSecond );
|
}
|
|
int nMsgCount(0);
|
|
nMsgCount = m_pMsgs->ListTalking3( m_pDBConnect->m_strLogin, strUser,nLimitCount, bTimeAsc );
|
if ( nMsgCount <= 0 )
|
{
|
delete m_pMsgs;
|
m_pMsgs = NULL;
|
return true;
|
}
|
m_nType = ROWTYPE_MSG;
|
m_pMsgs->GetData( );
|
nCount = nMsgCount;
|
return true;
|
}
|
bool CSTKMsgRowSet::ListTalking2( CString strUser,long nLimitCount, long &nCount, BOOL bTimeAsc/* = FALSE */ )
|
{
|
nCount = 0;
|
if ( strUser.IsEmpty() )
|
return false;
|
if ( !m_pDBConnect || !m_pDBConnect->IsOpenDB() )
|
return false;
|
CleanDataSet();
|
|
m_pDBConnect->AddRef();
|
m_pMsgs = new CMsgs( m_pDBConnect);
|
|
CHighTime tmHigh;
|
SYSTEMTIME tmSystem;
|
|
// Set Filter
|
if ( !m_strStartDate.IsEmpty() && tmHigh.ParseDateTime( m_strStartDate ) )
|
{
|
tmHigh.GetAsSystemTime( tmSystem );
|
if ( tmSystem.wSecond < 0 )
|
tmSystem.wSecond = 0;
|
|
m_pMsgs->m_tmStartDate = COleDateTime( tmSystem.wYear, tmSystem.wMonth, tmSystem.wDay,
|
tmSystem.wHour, tmSystem.wMinute, tmSystem.wSecond );
|
}
|
if ( !m_strEndDate.IsEmpty() && tmHigh.ParseDateTime( m_strEndDate ) )
|
{
|
tmHigh.GetAsSystemTime( tmSystem );
|
if ( tmSystem.wSecond < 0 )
|
tmSystem.wSecond = 0;
|
|
m_pMsgs->m_tmEndDate = COleDateTime( tmSystem.wYear, tmSystem.wMonth, tmSystem.wDay,
|
tmSystem.wHour, tmSystem.wMinute, tmSystem.wSecond );
|
}
|
|
int nMsgCount(0);
|
|
nMsgCount = m_pMsgs->ListTalking2( m_pDBConnect->m_strLogin, strUser,nLimitCount, bTimeAsc );
|
if ( nMsgCount <= 0 )
|
{
|
delete m_pMsgs;
|
m_pMsgs = NULL;
|
return true;
|
}
|
m_nType = ROWTYPE_MSG;
|
m_pMsgs->GetData( );
|
nCount = nMsgCount;
|
return true;
|
}
|
|
bool CSTKMsgRowSet::ListTalking( CString strUser, long &nCount,bool bOnlyAttachmentMsg, bool bGroupSend, BOOL bTimeAsc/* = FALSE */ )
|
{
|
//CMBAMDBFun::WriteDBErrToFile(_T("CSTKMsgRowSet::ListTalking 1"));
|
nCount = 0;
|
if ( strUser.IsEmpty() )
|
return false;
|
if ( !m_pDBConnect || !m_pDBConnect->IsOpenDB() )
|
return false;
|
CleanDataSet();
|
// CMBAMDBFun::WriteDBErrToFile(_T("CSTKMsgRowSet::ListTalking 2"));
|
m_pDBConnect->AddRef();
|
m_pMsgs = new CMsgs( m_pDBConnect);
|
|
CHighTime tmHigh;
|
SYSTEMTIME tmSystem;
|
|
// Set Filter
|
if ( !m_strStartDate.IsEmpty() && tmHigh.ParseDateTime( m_strStartDate ) )
|
{
|
tmHigh.GetAsSystemTime( tmSystem );
|
if ( tmSystem.wSecond < 0 )
|
tmSystem.wSecond = 0;
|
|
m_pMsgs->m_tmStartDate = COleDateTime( tmSystem.wYear, tmSystem.wMonth, tmSystem.wDay,
|
tmSystem.wHour, tmSystem.wMinute, tmSystem.wSecond );
|
}
|
if ( !m_strEndDate.IsEmpty() && tmHigh.ParseDateTime( m_strEndDate ) )
|
{
|
tmHigh.GetAsSystemTime( tmSystem );
|
if ( tmSystem.wSecond < 0 )
|
tmSystem.wSecond = 0;
|
|
m_pMsgs->m_tmEndDate = COleDateTime( tmSystem.wYear, tmSystem.wMonth, tmSystem.wDay,
|
tmSystem.wHour, tmSystem.wMinute, tmSystem.wSecond );
|
}
|
int nMsgCount(0);
|
nMsgCount = m_pMsgs->ListTalking( m_pDBConnect->m_strLogin, strUser,bOnlyAttachmentMsg, bGroupSend, bTimeAsc );
|
if ( nMsgCount <= 0 )
|
{
|
delete m_pMsgs;
|
m_pMsgs = NULL;
|
return true;
|
}
|
m_nType = ROWTYPE_MSG;
|
//CMBAMDBFun::WriteDBErrToFile(_T("CSTKMsgRowSet::ListTalking 3"));
|
m_pMsgs->GetData( );
|
//CMBAMDBFun::WriteDBErrToFile(_T("CSTKMsgRowSet::ListTalking 4"));
|
nCount = nMsgCount;
|
|
return true;
|
}
|
bool CSTKMsgRowSet::ListRecordCount( long &nCount )
|
{
|
nCount = 0;
|
switch ( m_nType )
|
{
|
case ROWTYPE_MSG:
|
if ( m_pMsgs )
|
nCount = m_pMsgs->ListRecordCount();
|
break;
|
case ROWTYPE_MSGFOLDER:
|
if ( m_pMsgFolders )
|
nCount = m_pMsgFolders->ListRecordCount();
|
break;
|
case ROWTYPE_FOLDERMGR:
|
if ( m_pMsgAttachments )
|
nCount = m_pMsgAttachments->ListRecordCount();
|
break;
|
default:
|
return false;
|
break;
|
}
|
|
return true;
|
}
|
bool CSTKMsgRowSet::Top( )
|
{
|
switch ( m_nType )
|
{
|
case ROWTYPE_MSG:
|
if ( m_pMsgs && !m_pMsgs->MoveFirst() )
|
return false;
|
break;
|
case ROWTYPE_MSGFOLDER:
|
if ( m_pMsgFolders && !m_pMsgFolders->MoveFirst() )
|
return false;
|
break;
|
case ROWTYPE_FOLDERMGR:
|
if ( !m_pMsgAttachments->MoveFirst() )
|
return false;
|
break;
|
default:
|
return false;
|
break;
|
}
|
|
return true;
|
}
|
|
bool CSTKMsgRowSet::Prev()
|
{
|
switch ( m_nType )
|
{
|
case ROWTYPE_MSG:
|
if ( m_pMsgs && !m_pMsgs->MovePrev() )
|
return false;
|
break;
|
case ROWTYPE_MSGFOLDER:
|
if ( m_pMsgFolders && !m_pMsgFolders->MovePrev() )
|
return false;
|
break;
|
case ROWTYPE_FOLDERMGR:
|
if ( !m_pMsgAttachments->MovePrev() )
|
return false;
|
break;
|
|
default:
|
return false;
|
break;
|
break;
|
}
|
|
return true;
|
}
|
|
bool CSTKMsgRowSet::Next( )
|
{
|
switch ( m_nType )
|
{
|
case ROWTYPE_MSG:
|
if ( m_pMsgs && !m_pMsgs->MoveNext() )
|
return false;
|
break;
|
case ROWTYPE_MSGFOLDER:
|
if ( m_pMsgFolders && !m_pMsgFolders->MoveNext() )
|
return false;
|
break;
|
case ROWTYPE_FOLDERMGR:
|
if ( !m_pMsgAttachments->MoveNext() )
|
return false;
|
break;
|
|
default:
|
return false;
|
break;
|
}
|
|
return true;
|
}
|
|
bool CSTKMsgRowSet::MoveTo( long nPos )
|
{
|
switch ( m_nType )
|
{
|
case ROWTYPE_MSG:
|
if ( m_pMsgs && !m_pMsgs->MoveTo( nPos ) )
|
return false;
|
break;
|
case ROWTYPE_MSGFOLDER:
|
if ( m_pMsgFolders && !m_pMsgFolders->MoveTo( nPos ) )
|
return false;
|
break;
|
case ROWTYPE_FOLDERMGR:
|
if ( !m_pMsgAttachments->MoveTo( nPos ) )
|
return false;
|
break;
|
|
default:
|
return false;
|
break;
|
}
|
|
return true;
|
}
|
|
bool CSTKMsgRowSet::GetRow( CSTKMsgRow *pSTKRow )
|
{
|
if ( !pSTKRow )
|
return false;
|
|
pSTKRow->m_pAConnect = m_pDBConnect;
|
|
if ( m_nType == ROWTYPE_MSG )
|
pSTKRow->m_pCursor = m_pMsgs;
|
else if ( m_nType == ROWTYPE_MSGFOLDER )
|
pSTKRow->m_pCursor = m_pMsgFolders;
|
else if ( m_nType == ROWTYPE_FOLDERMGR )
|
pSTKRow->m_pCursor = m_pMsgAttachments;
|
return true;
|
}
|
bool CSTKMsgRowSet::GetItemValueStr( CString strItemName, CString &strData )
|
{
|
CString strValue = _T( "" );
|
CString strName = strItemName;
|
if ( strName.IsEmpty() )
|
return false;
|
|
switch ( m_nType )
|
{
|
case ROWTYPE_MSG:
|
{
|
if ( !m_pMsgs )
|
return false;
|
|
m_pMsgs->GetData( );
|
if ( !((*m_pMsgs).GetItemValue( strName, strValue )) )
|
return false;
|
}
|
break;
|
case ROWTYPE_MSGFOLDER:
|
{
|
if ( !m_pMsgFolders )
|
return false;
|
|
m_pMsgFolders->GetData( );
|
if ( !((*m_pMsgFolders).GetItemValue( strName, strValue )) )
|
return false;
|
}
|
break;
|
case ROWTYPE_FOLDERMGR:
|
{
|
if ( !m_pMsgAttachments )
|
return false;
|
|
m_pMsgAttachments->GetData( );
|
if ( !((*m_pMsgAttachments).GetItemValue( strName, strValue )) )
|
return false;
|
}
|
break;
|
default:
|
return false;
|
break;
|
}
|
|
strData = strValue;
|
return true;
|
}
|
bool CSTKMsgRowSet::GetItemValue( CString strItemName, VARIANT &vData )
|
{
|
vData.vt = VT_EMPTY;
|
|
CString strName = strItemName;
|
if ( strName.IsEmpty() )
|
return false;
|
|
COleVariant oleData;
|
|
switch ( m_nType )
|
{
|
case ROWTYPE_MSG:
|
{
|
if ( !m_pMsgs )
|
return false;
|
|
m_pMsgs->GetData( );
|
if ( !((*m_pMsgs).GetItemValue( strName, oleData )) )
|
return false;
|
}
|
break;
|
case ROWTYPE_MSGFOLDER:
|
{
|
if ( !m_pMsgFolders )
|
return false;
|
|
m_pMsgFolders->GetData( );
|
if ( !((*m_pMsgFolders).GetItemValue( strName, oleData )) )
|
return false;
|
}
|
break;
|
case ROWTYPE_FOLDERMGR:
|
{
|
if ( !m_pMsgAttachments )
|
return false;
|
|
m_pMsgAttachments->GetData( );
|
if ( !((*m_pMsgAttachments).GetItemValue( strName, oleData )) )
|
return false;
|
}
|
break;
|
default:
|
return false;
|
break;
|
}
|
|
vData = oleData;
|
return true;
|
}
|
|
bool CSTKMsgRowSet::SetMsgFilterDate( CString strStartDate, CString strEndDate )
|
{
|
m_strStartDate = strStartDate;
|
m_strEndDate = strEndDate;
|
|
return true;
|
}
|
bool CSTKMsgRowSet::ListSearchingTalking( CString strUser, CString strKey,bool bOnlyAttachmentMsg, long &nCount,bool bGroupSend, BOOL bTimeAsc )
|
{
|
nCount = 0;
|
if ( strUser.IsEmpty() )
|
return false;
|
if ( !m_pDBConnect || !m_pDBConnect->m_bOpenDB )
|
return false;
|
CleanDataSet();
|
|
m_pDBConnect->AddRef();
|
m_pMsgs = new CMsgs( m_pDBConnect );
|
|
CHighTime tmHigh;
|
SYSTEMTIME tmSystem;
|
|
// Set Filter
|
if ( !m_strStartDate.IsEmpty() && tmHigh.ParseDateTime( m_strStartDate ) )
|
{
|
tmHigh.GetAsSystemTime( tmSystem );
|
if ( tmSystem.wSecond < 0 )
|
tmSystem.wSecond = 0;
|
|
m_pMsgs->m_tmStartDate = COleDateTime( tmSystem.wYear, tmSystem.wMonth, tmSystem.wDay,
|
tmSystem.wHour, tmSystem.wMinute, tmSystem.wSecond );
|
}
|
if ( !m_strEndDate.IsEmpty() && tmHigh.ParseDateTime( m_strEndDate ) )
|
{
|
tmHigh.GetAsSystemTime( tmSystem );
|
if ( tmSystem.wSecond < 0 )
|
tmSystem.wSecond = 0;
|
|
m_pMsgs->m_tmEndDate = COleDateTime( tmSystem.wYear, tmSystem.wMonth, tmSystem.wDay,
|
tmSystem.wHour, tmSystem.wMinute, tmSystem.wSecond );
|
}
|
|
int nMsgCount(0);
|
|
nMsgCount = m_pMsgs->ListSearchingTalking( m_pDBConnect->m_strLogin, strUser,strKey,bOnlyAttachmentMsg,bGroupSend, bTimeAsc );
|
if ( nMsgCount <= 0 )
|
{
|
delete m_pMsgs;
|
m_pMsgs = NULL;
|
return true;
|
}
|
m_pMsgs->GetData( );
|
|
m_nType = ROWTYPE_MSG;
|
nCount = nMsgCount;
|
|
return true;
|
}
|
|
bool CSTKMsgRowSet::ListFolder( long nParentFolderID, long &nCount )
|
{
|
nCount = 0;
|
//if ( nParentFolderID < 0 )
|
// return false;
|
if ( !m_pDBConnect || !m_pDBConnect->m_bOpenDB )
|
return false;
|
CleanDataSet();
|
m_pDBConnect->AddRef();
|
m_pMsgFolders = new CMsgFolders(m_pDBConnect );
|
int nMsgCount(0);
|
nMsgCount = m_pMsgFolders->ListFolder( nParentFolderID );
|
/*if ( nMsgCount <= 0 )
|
{
|
delete m_pMsgFolders;
|
m_pMsgFolders = NULL;
|
return true;
|
}
|
m_pMsgFolders->GetData( )*/;
|
m_nType = ROWTYPE_MSGFOLDER;
|
nCount = nMsgCount;
|
return true;
|
}
|
|
bool CSTKMsgRowSet::ListTalkingAllMsg( CString strUser, long &nCount, BOOL bTimeAsc/* = FALSE */ )
|
{
|
nCount = 0;
|
if ( strUser.IsEmpty() )
|
return false;
|
if ( !m_pDBConnect || !m_pDBConnect->IsOpenDB() )
|
return false;
|
CleanDataSet();
|
// CMBAMDBFun::WriteDBErrToFile(_T("CSTKMsgRowSet::ListTalking 2"));
|
m_pDBConnect->AddRef();
|
m_pMsgs = new CMsgs( m_pDBConnect);
|
|
CHighTime tmHigh;
|
SYSTEMTIME tmSystem;
|
|
// Set Filter
|
if ( !m_strStartDate.IsEmpty() && tmHigh.ParseDateTime( m_strStartDate ) )
|
{
|
tmHigh.GetAsSystemTime( tmSystem );
|
if ( tmSystem.wSecond < 0 )
|
tmSystem.wSecond = 0;
|
|
m_pMsgs->m_tmStartDate = COleDateTime( tmSystem.wYear, tmSystem.wMonth, tmSystem.wDay,
|
tmSystem.wHour, tmSystem.wMinute, tmSystem.wSecond );
|
}
|
if ( !m_strEndDate.IsEmpty() && tmHigh.ParseDateTime( m_strEndDate ) )
|
{
|
tmHigh.GetAsSystemTime( tmSystem );
|
if ( tmSystem.wSecond < 0 )
|
tmSystem.wSecond = 0;
|
|
m_pMsgs->m_tmEndDate = COleDateTime( tmSystem.wYear, tmSystem.wMonth, tmSystem.wDay,
|
tmSystem.wHour, tmSystem.wMinute, tmSystem.wSecond );
|
}
|
int nMsgCount(0);
|
nMsgCount = m_pMsgs->ListTalkingAllMsg( m_pDBConnect->m_strLogin, strUser, bTimeAsc );
|
if ( nMsgCount <= 0 )
|
{
|
delete m_pMsgs;
|
m_pMsgs = NULL;
|
return true;
|
}
|
m_nType = ROWTYPE_MSG;
|
//CMBAMDBFun::WriteDBErrToFile(_T("CSTKMsgRowSet::ListTalking 3"));
|
m_pMsgs->GetData( );
|
//CMBAMDBFun::WriteDBErrToFile(_T("CSTKMsgRowSet::ListTalking 4"));
|
nCount = nMsgCount;
|
|
return true;
|
}
|
bool CSTKMsgRowSet::ListSearchingTalkingAllMsg( CString strUser, CString strKey, long &nCount, BOOL bTimeAsc )
|
{
|
nCount = 0;
|
if ( strUser.IsEmpty() )
|
return false;
|
if ( !m_pDBConnect || !m_pDBConnect->m_bOpenDB )
|
return false;
|
CleanDataSet();
|
|
m_pDBConnect->AddRef();
|
m_pMsgs = new CMsgs( m_pDBConnect );
|
|
CHighTime tmHigh;
|
SYSTEMTIME tmSystem;
|
|
// Set Filter
|
if ( !m_strStartDate.IsEmpty() && tmHigh.ParseDateTime( m_strStartDate ) )
|
{
|
tmHigh.GetAsSystemTime( tmSystem );
|
if ( tmSystem.wSecond < 0 )
|
tmSystem.wSecond = 0;
|
|
m_pMsgs->m_tmStartDate = COleDateTime( tmSystem.wYear, tmSystem.wMonth, tmSystem.wDay,
|
tmSystem.wHour, tmSystem.wMinute, tmSystem.wSecond );
|
}
|
if ( !m_strEndDate.IsEmpty() && tmHigh.ParseDateTime( m_strEndDate ) )
|
{
|
tmHigh.GetAsSystemTime( tmSystem );
|
if ( tmSystem.wSecond < 0 )
|
tmSystem.wSecond = 0;
|
|
m_pMsgs->m_tmEndDate = COleDateTime( tmSystem.wYear, tmSystem.wMonth, tmSystem.wDay,
|
tmSystem.wHour, tmSystem.wMinute, tmSystem.wSecond );
|
}
|
|
int nMsgCount(0);
|
|
nMsgCount = m_pMsgs->ListSearchingTalkingAllMsg( m_pDBConnect->m_strLogin, strUser,strKey, bTimeAsc );
|
if ( nMsgCount <= 0 )
|
{
|
delete m_pMsgs;
|
m_pMsgs = NULL;
|
return true;
|
}
|
m_pMsgs->GetData( );
|
|
m_nType = ROWTYPE_MSG;
|
nCount = nMsgCount;
|
|
return true;
|
}
|
bool CSTKMsgRowSet::ListReceiveBoxMsg( CString strUser,CString strUserName, CString strContentKey, int nAttach,long &nCount )
|
{
|
nCount = 0;
|
if ( !m_pDBConnect || !m_pDBConnect->IsOpenDB() )
|
return false;
|
CleanDataSet();
|
m_pDBConnect->AddRef();
|
m_pMsgs = new CMsgs( m_pDBConnect);
|
CHighTime tmHigh;
|
SYSTEMTIME tmSystem;
|
// Set Filter
|
if ( !m_strStartDate.IsEmpty() && tmHigh.ParseDateTime( m_strStartDate ) )
|
{
|
tmHigh.GetAsSystemTime( tmSystem );
|
if ( tmSystem.wSecond < 0 )
|
tmSystem.wSecond = 0;
|
|
m_pMsgs->m_tmStartDate = COleDateTime( tmSystem.wYear, tmSystem.wMonth, tmSystem.wDay,
|
tmSystem.wHour, tmSystem.wMinute, tmSystem.wSecond );
|
}
|
if ( !m_strEndDate.IsEmpty() && tmHigh.ParseDateTime( m_strEndDate ) )
|
{
|
tmHigh.GetAsSystemTime( tmSystem );
|
if ( tmSystem.wSecond < 0 )
|
tmSystem.wSecond = 0;
|
|
m_pMsgs->m_tmEndDate = COleDateTime( tmSystem.wYear, tmSystem.wMonth, tmSystem.wDay,
|
tmSystem.wHour, tmSystem.wMinute, tmSystem.wSecond );
|
}
|
|
int nMsgCount(0);
|
nMsgCount = m_pMsgs->ListReceiveBoxMsg( strUser,strUserName,strContentKey, nAttach );
|
if ( nMsgCount <= 0 )
|
{
|
delete m_pMsgs;
|
m_pMsgs = NULL;
|
return true;
|
}
|
m_nType = ROWTYPE_MSG;
|
m_pMsgs->GetData( );
|
nCount = nMsgCount;
|
return true;
|
}
|
|
bool CSTKMsgRowSet::ListSendBoxMsg( CString strUser,CString strUserName, CString strContentKey, int nAttach,long &nCount )
|
{
|
nCount = 0;
|
if ( !m_pDBConnect || !m_pDBConnect->IsOpenDB() )
|
return false;
|
CleanDataSet();
|
m_pDBConnect->AddRef();
|
m_pMsgs = new CMsgs( m_pDBConnect);
|
CHighTime tmHigh;
|
SYSTEMTIME tmSystem;
|
// Set Filter
|
if ( !m_strStartDate.IsEmpty() && tmHigh.ParseDateTime( m_strStartDate ) )
|
{
|
tmHigh.GetAsSystemTime( tmSystem );
|
if ( tmSystem.wSecond < 0 )
|
tmSystem.wSecond = 0;
|
|
m_pMsgs->m_tmStartDate = COleDateTime( tmSystem.wYear, tmSystem.wMonth, tmSystem.wDay,
|
tmSystem.wHour, tmSystem.wMinute, tmSystem.wSecond );
|
}
|
if ( !m_strEndDate.IsEmpty() && tmHigh.ParseDateTime( m_strEndDate ) )
|
{
|
tmHigh.GetAsSystemTime( tmSystem );
|
if ( tmSystem.wSecond < 0 )
|
tmSystem.wSecond = 0;
|
|
m_pMsgs->m_tmEndDate = COleDateTime( tmSystem.wYear, tmSystem.wMonth, tmSystem.wDay,
|
tmSystem.wHour, tmSystem.wMinute, tmSystem.wSecond );
|
}
|
|
int nMsgCount(0);
|
nMsgCount = m_pMsgs->ListSendBoxMsg( strUser,strUserName,strContentKey, nAttach );
|
if ( nMsgCount <= 0 )
|
{
|
delete m_pMsgs;
|
m_pMsgs = NULL;
|
return true;
|
}
|
m_nType = ROWTYPE_MSG;
|
m_pMsgs->GetData( );
|
nCount = nMsgCount;
|
return true;
|
}
|
|
bool CSTKMsgRowSet::ListFavBoxMsg( CString strSender,CString strUserName, CString strContentKey, int nFavFolder,long &nCount )
|
{
|
nCount = 0;
|
if ( !m_pDBConnect || !m_pDBConnect->IsOpenDB() )
|
return false;
|
CleanDataSet();
|
m_pDBConnect->AddRef();
|
m_pMsgs = new CMsgs( m_pDBConnect);
|
CHighTime tmHigh;
|
SYSTEMTIME tmSystem;
|
// Set Filter
|
if ( !m_strStartDate.IsEmpty() && tmHigh.ParseDateTime( m_strStartDate ) )
|
{
|
tmHigh.GetAsSystemTime( tmSystem );
|
if ( tmSystem.wSecond < 0 )
|
tmSystem.wSecond = 0;
|
|
m_pMsgs->m_tmStartDate = COleDateTime( tmSystem.wYear, tmSystem.wMonth, tmSystem.wDay,
|
tmSystem.wHour, tmSystem.wMinute, tmSystem.wSecond );
|
}
|
if ( !m_strEndDate.IsEmpty() && tmHigh.ParseDateTime( m_strEndDate ) )
|
{
|
tmHigh.GetAsSystemTime( tmSystem );
|
if ( tmSystem.wSecond < 0 )
|
tmSystem.wSecond = 0;
|
|
m_pMsgs->m_tmEndDate = COleDateTime( tmSystem.wYear, tmSystem.wMonth, tmSystem.wDay,
|
tmSystem.wHour, tmSystem.wMinute, tmSystem.wSecond );
|
}
|
|
int nMsgCount(0);
|
nMsgCount = m_pMsgs->ListFavBoxMsg(strSender,strUserName,strContentKey, nFavFolder );
|
if ( nMsgCount <= 0 )
|
{
|
delete m_pMsgs;
|
m_pMsgs = NULL;
|
return true;
|
}
|
m_nType = ROWTYPE_MSG;
|
m_pMsgs->GetData( );
|
nCount = nMsgCount;
|
return true;
|
}
|
bool CSTKMsgRowSet::ListSyncBoxMsg( CString strStartDate,long &nCount )
|
{
|
nCount = 0;
|
if ( !m_pDBConnect || !m_pDBConnect->IsOpenDB() )
|
return false;
|
CleanDataSet();
|
m_pDBConnect->AddRef();
|
m_pMsgs = new CMsgs( m_pDBConnect);
|
CHighTime tmHigh;
|
int nMsgCount(0);
|
nMsgCount = m_pMsgs->ListSyncBoxMsg(strStartDate);
|
if ( nMsgCount <= 0 )
|
{
|
delete m_pMsgs;
|
m_pMsgs = NULL;
|
return true;
|
}
|
m_nType = ROWTYPE_MSG;
|
m_pMsgs->GetData( );
|
nCount = nMsgCount;
|
return true;
|
}
|
bool CSTKMsgRowSet::ListSysBoxMsg( long &nCount)
|
{
|
nCount = 0;
|
if ( !m_pDBConnect || !m_pDBConnect->IsOpenDB() )
|
return false;
|
CleanDataSet();
|
m_pDBConnect->AddRef();
|
m_pMsgs = new CMsgs( m_pDBConnect);
|
CHighTime tmHigh;
|
SYSTEMTIME tmSystem;
|
// Set Filter
|
if ( !m_strStartDate.IsEmpty() && tmHigh.ParseDateTime( m_strStartDate ) )
|
{
|
tmHigh.GetAsSystemTime( tmSystem );
|
if ( tmSystem.wSecond < 0 )
|
tmSystem.wSecond = 0;
|
|
m_pMsgs->m_tmStartDate = COleDateTime( tmSystem.wYear, tmSystem.wMonth, tmSystem.wDay,
|
tmSystem.wHour, tmSystem.wMinute, tmSystem.wSecond );
|
}
|
if ( !m_strEndDate.IsEmpty() && tmHigh.ParseDateTime( m_strEndDate ) )
|
{
|
tmHigh.GetAsSystemTime( tmSystem );
|
if ( tmSystem.wSecond < 0 )
|
tmSystem.wSecond = 0;
|
|
m_pMsgs->m_tmEndDate = COleDateTime( tmSystem.wYear, tmSystem.wMonth, tmSystem.wDay,
|
tmSystem.wHour, tmSystem.wMinute, tmSystem.wSecond );
|
}
|
|
int nMsgCount(0);
|
nMsgCount = m_pMsgs->ListSysBoxMsg( );
|
if ( nMsgCount <= 0 )
|
{
|
delete m_pMsgs;
|
m_pMsgs = NULL;
|
return true;
|
}
|
m_nType = ROWTYPE_MSG;
|
m_pMsgs->GetData( );
|
nCount = nMsgCount;
|
return true;
|
}
|
|
bool CSTKMsgRowSet::ListAttachments( CString strUser,CString strUserName, CString strKey ,long &nCount )
|
{
|
nCount = 0;
|
if ( !m_pDBConnect || !m_pDBConnect->IsOpenDB() )
|
return false;
|
CleanDataSet();
|
m_pDBConnect->AddRef();
|
m_pMsgAttachments = new CMsgAttachments( m_pDBConnect);
|
CHighTime tmHigh;
|
SYSTEMTIME tmSystem;
|
// Set Filter
|
if ( !m_strStartDate.IsEmpty() && tmHigh.ParseDateTime( m_strStartDate ) )
|
{
|
tmHigh.GetAsSystemTime( tmSystem );
|
if ( tmSystem.wSecond < 0 )
|
tmSystem.wSecond = 0;
|
|
m_pMsgAttachments->m_tmStartDate = COleDateTime( tmSystem.wYear, tmSystem.wMonth, tmSystem.wDay,
|
tmSystem.wHour, tmSystem.wMinute, tmSystem.wSecond );
|
}
|
if ( !m_strEndDate.IsEmpty() && tmHigh.ParseDateTime( m_strEndDate ) )
|
{
|
tmHigh.GetAsSystemTime( tmSystem );
|
if ( tmSystem.wSecond < 0 )
|
tmSystem.wSecond = 0;
|
|
m_pMsgAttachments->m_tmEndDate = COleDateTime( tmSystem.wYear, tmSystem.wMonth, tmSystem.wDay,
|
tmSystem.wHour, tmSystem.wMinute, tmSystem.wSecond );
|
}
|
|
int nMsgCount(0);
|
nMsgCount = m_pMsgAttachments->ListAttachments(strUser,strUserName,strKey);
|
if ( nMsgCount <= 0 )
|
{
|
delete m_pMsgs;
|
m_pMsgs = NULL;
|
return true;
|
}
|
m_nType = ROWTYPE_FOLDERMGR;
|
m_pMsgAttachments->GetData( );
|
nCount = nMsgCount;
|
return true;
|
}
|
bool CSTKMsgRowSet::ListSearchingTalkingMsg( CString strUser, CString strKey, long &nCount, BOOL bTimeAsc )
|
{
|
nCount = 0;
|
if ( strUser.IsEmpty() )
|
return false;
|
if ( !m_pDBConnect || !m_pDBConnect->m_bOpenDB )
|
return false;
|
CleanDataSet();
|
|
m_pDBConnect->AddRef();
|
m_pMsgs = new CMsgs( m_pDBConnect );
|
|
CHighTime tmHigh;
|
SYSTEMTIME tmSystem;
|
|
// Set Filter
|
if ( !m_strStartDate.IsEmpty() && tmHigh.ParseDateTime( m_strStartDate ) )
|
{
|
tmHigh.GetAsSystemTime( tmSystem );
|
if ( tmSystem.wSecond < 0 )
|
tmSystem.wSecond = 0;
|
|
m_pMsgs->m_tmStartDate = COleDateTime( tmSystem.wYear, tmSystem.wMonth, tmSystem.wDay,
|
tmSystem.wHour, tmSystem.wMinute, tmSystem.wSecond );
|
}
|
if ( !m_strEndDate.IsEmpty() && tmHigh.ParseDateTime( m_strEndDate ) )
|
{
|
tmHigh.GetAsSystemTime( tmSystem );
|
if ( tmSystem.wSecond < 0 )
|
tmSystem.wSecond = 0;
|
|
m_pMsgs->m_tmEndDate = COleDateTime( tmSystem.wYear, tmSystem.wMonth, tmSystem.wDay,
|
tmSystem.wHour, tmSystem.wMinute, tmSystem.wSecond );
|
}
|
|
int nMsgCount(0);
|
|
nMsgCount = m_pMsgs->ListSearchingTalkingMsg( m_pDBConnect->m_strLogin, strUser,strKey, bTimeAsc );
|
if ( nMsgCount <= 0 )
|
{
|
delete m_pMsgs;
|
m_pMsgs = NULL;
|
return true;
|
}
|
m_pMsgs->GetData( );
|
|
m_nType = ROWTYPE_MSG;
|
nCount = nMsgCount;
|
|
return true;
|
}
|
