#pragma once

#include "CursorBase.h"
#include "dbCursor.h"
#include "MBAMDBConnect.h"

// CCrowdMsgItem command target
class AFX_EXT_CLASS CCrowdMsgItem : public CCursorBase
{
public:
	CCrowdMsgItem();
	virtual ~CCrowdMsgItem();
public:
	CString			m_strID;
	CString			m_strCrowdID;
	CString			m_strCrowdName;
	CString			m_strSubject;
	CString			m_strSender;
	CString			m_strSenderName;		// Sender Name
	COleDateTime	m_tmDate;				// Send Date
	long			m_nReadState;			// ¶ÁÏûÏ¢µÄ״̬£¬Ä¬ÈÏΪûÓÐ
	long			m_nMsgFlag;
	long			m_nCharset;				// ×Ö·û¼¯
	CString			m_strContentType;		// È磺Text
	long			m_nContentSize;
	CString			m_strContent;
	CString			m_strContentText;
// Operations
public:
	void			Clear();
	virtual	BOOL	GetItemValue( CString strName, CString &strValue )
					{ return CCursorBase::GetItemValue( strName, strValue ); }
	virtual	BOOL	GetItemValue( CString strName, COleVariant &varData );

	BOOL	InsertRecord( CDBConnect *pAConnect);
	BOOL	UpdateRecord(CDBConnect *pAConnect );
};
class AFX_EXT_CLASS CCrowdMsgs : public CdbCursor, public CCrowdMsgItem
{
public:
	CCrowdMsgs( CMBAMDBConnect *pAConnect );
	virtual ~CCrowdMsgs();
	void operator =( const CCrowdMsgs& item );
public:
		// ¹ýÂËÌõ¼þ
	COleDateTime		m_tmStartDate;		// ¹ýÂËÌõ¼þ¿ªÊ¼ÈÕÆÚ
	COleDateTime		m_tmEndDate;		// ¹ýÂËÌõ¼þ½áÊøÈÕÆÚ
	int					m_nReaded;			// ¹ýÂËÌõ¼þÊÇ·ñÒѶÁ -1 ²»ÉèÌõ¼þ  >0 ÒѶÁµÄ  =0 δ¶Á	
	int					m_nListMsgType;		// ÏÔʾÏûÏ¢ÐÅÏ¢µÄÀàÐÍ
// Operations
public:

	void			InitFilter( );
	int				ListUnreadMsg();
	void			SetCrowdMsgReadState(CString  strCrowdID  );
	int				ListCrowdAll2(CString  strCrowdID,long nLimitCount,  BOOL bTimeAsc = FALSE );
	int				ListCrowdAll(CString  strCrowdID, BOOL bTimeAsc = FALSE );
	int				ListSearchCrowdAll(CString  strCrowdID, CString strKey, BOOL bTimeAsc = FALSE );
	int				ListSearchCrowdMsgBox(CString  strCrowdID, CString strKey, BOOL bTimeAsc = FALSE );
	int				ListSpMsgID( LPCTSTR lpszMsgID );
	BOOL			DoSaveCrowdMsg( CCrowdMsgItem *pMsg );
	long			ListRecordCount(  );
	BOOL			UpldateLastContactDate( CString strID, CString strName, CString strLastDate, CString strSubject);
public:
	virtual bool	GetData( );
	void	InitMsgData( );
	bool	GetMsgData( );
	bool	GetMsgAdminData( );

};