#pragma once
#include "MBAMDBConnect.h"
#include "MsgFolder.h"
#include "MsgOwner.h"
#include "MsgAttachment.h"
#include "MsgProperty.h"
#include "Msg.h"
#include "STKMsgRow.h"
// STKMsgRowSet command target

class AFX_EXT_CLASS CSTKMsgRowSet : public CObject
{
public:
	CSTKMsgRowSet();
	virtual ~CSTKMsgRowSet();
	void operator = ( const CSTKMsgRowSet &Item );
// Attributers
public:
private:
	CMBAMDBConnect		*m_pDBConnect;
	int					m_nType;	

	CString				m_strStartDate;		// ÏûÏ¢¿ªÊ¼ÈÕÆÚ
	CString				m_strEndDate;		// ÏûÏ¢µÄ½áÊøÈÕÆÚ

	CMsgs				*m_pMsgs;
	CMsgFolders			*m_pMsgFolders;
	CMsgAttachments		*m_pMsgAttachments;
// Operations
public:
	void		CleanDataSet( );
// IAMRowSet
public:
	bool		SetMsgFilterDate( CString strStartDate, CString strEndDate );
	bool		Prev( );
	bool		GetItemValueStr( CString strItemName, CString &strData );
	bool		GetItemValue( CString strItemName, VARIANT &vData );
	bool		GetRow( CSTKMsgRow *pSTKRow );
	bool		Next( );
	bool		Top( );
	bool		MoveTo( long nPos );

	bool		ListFolder( long nParentFolderID, long &nCount );
	
	bool		ListTalking3( CString strUser, long nLimitCount,long &nCount, BOOL bTimeAsc = FALSE   );
	bool		ListTalking2( CString strUser, long nLimitCount,long &nCount, BOOL bTimeAsc = FALSE   );
	bool		ListTalking( CString strUser, long &nCount,bool bOnlyAttachmentMsg = false,bool bGroupSend = false, BOOL bTimeAsc = FALSE   );
	bool		SetDBConnect( CMBAMDBConnect *pDBConnect );
	bool		ListSearchingTalking( CString strUser, CString strKey,bool bOnlyAttachmentMsg, long &nCount,bool bGroupSend = false, BOOL bTimeAsc = FALSE   );
	bool		ListRecordCount( long &nCount  );
	bool		ListTalkingAllMsg( CString strUser, long &nCount, BOOL bTimeAsc = FALSE   );
	bool		ListSearchingTalkingAllMsg( CString strUser, CString strKey, long &nCount,BOOL bTimeAsc = FALSE   );
	bool		ListReceiveBoxMsg( CString strUser,CString strUserName,CString strContentKey, int nAttach,long &nCount );
	bool		ListSendBoxMsg( CString strUser,CString strUserName,CString strContentKey, int nAttach,long &nCount );
	bool		ListFavBoxMsg( CString strSender,CString strUserName, CString strContentKey,int nFavFolder,long &nCount );
	bool		ListSyncBoxMsg( CString strStartDate,long &nCount );
	bool		ListSysBoxMsg( long &nCount);
	bool		ListSearchingTalkingMsg( CString strUser, CString strKey, long &nCount,BOOL bTimeAsc = FALSE   );

	bool		ListAttachments( CString strUser,CString strUserName, CString strKey ,long &nCount  );
};