timetosend.cpp

网络短息平台的开发与设计

// TimeToSend.cpp : implementation file
//

#include "stdafx.h"
#include "Send.h"
#include "senddb.h"
#include "user.h"
#include "TimeToSend.h"

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

/////////////////////////////////////////////////////////////////////////////
// CTimeToSend dialog


CTimeToSend::CTimeToSend(CWnd* pParent /*=NULL*/)
	: CDialog(CTimeToSend::IDD, pParent)
{
	//{{AFX_DATA_INIT(CTimeToSend)
	m_Date = 0;
	m_Time = 0;
	m_Phone = _T("");
	m_Content = _T("");
	//}}AFX_DATA_INIT
}


void CTimeToSend::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CTimeToSend)
	DDX_Control(pDX, IDC_LIST1, m_ListBx);
	DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER1, m_Date);
	DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER2, m_Time);
	DDX_Text(pDX, IDC_EDIT1, m_Phone);
	DDX_Text(pDX, IDC_EDIT4, m_Content);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CTimeToSend, CDialog)
	//{{AFX_MSG_MAP(CTimeToSend)
	ON_LBN_SELCHANGE(IDC_LIST1, OnSelchangeList1)
	ON_BN_CLICKED(IDC_UPDATE, OnUpdate)
	ON_BN_CLICKED(IDC_DELETE, OnDelete)
	ON_BN_CLICKED(IDC_ADD, OnAdd)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CTimeToSend message handlers

BOOL CTimeToSend::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	FillListBox();
	m_Date=CTime::GetCurrentTime();
    m_Time=CTime::GetCurrentTime();
	UpdateData(FALSE);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CTimeToSend::FillListBox()
{
	m_ListBx.ResetContent();
	int nIndex;
	CDatabase db;
	CSendDb *pSendSet=NULL;
	if(db.Open("SendMessage"))
	{
			pSendSet=new CSendDb();
			pSendSet->Open();
			while(!pSendSet->IsEOF())
			{
			if(!pSendSet->m_isSend)
			{
				CUser *pUser=new CUser();
				pUser->Phone=pSendSet->m_Phone;
				pUser->Content=pSendSet->m_Content;
			 	pUser->Time=pSendSet->m_Time;
				pUser->ID=pSendSet->m_ID;
				nIndex=m_ListBx.AddString(pSendSet->m_Phone);
                m_ListBx.SetItemDataPtr(nIndex,pUser);
			}
                pSendSet->MoveNext();
			
			}
			pSendSet->Close();
			delete pSendSet;
			db.Close();

	}
}

void CTimeToSend::OnSelchangeList1() 
{
	int nIndex=m_ListBx.GetCurSel();
	if(nIndex!=LB_ERR)
	{
		CUser *pUser=(CUser *)m_ListBx.GetItemDataPtr(nIndex);
		m_Content=pUser->Content;
		m_Date=pUser->Time;
		m_Time=pUser->Time;			
		m_Phone=pUser->Phone;
	    UpdateData(FALSE);
	}

	

}

void CTimeToSend::OnUpdate() 
{
    UpdateData();
	int nIndex=m_ListBx.GetCurSel();
	if(nIndex!=LB_ERR)
	{

	    CUser *pUser=(CUser *)m_ListBx.GetItemDataPtr(nIndex);
	    CDatabase db;
		CSendDb *pSendSet=NULL;
        if(db.Open("SendMessage"))
		{		
			pSendSet=new CSendDb();
			CString strSQL;
			strSQL="select * from MessageSend where ID=";
			char buf[10];
            ltoa(pUser->ID,buf,10);
			strSQL+=buf;
			pSendSet->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
			pSendSet->Edit();
			CTime time=CTime(m_Date.GetYear(),m_Date.GetMonth(),m_Date.GetDay(),m_Time.GetHour(),m_Time.GetMinute(),m_Time.GetSecond());
			pSendSet->m_Content=m_Content;
			pSendSet->m_Phone=m_Phone;
			pSendSet->m_Time=time;
			if(AfxMessageBox("是否要修改该字段值？",MB_OKCANCEL)==IDOK)
				{	
				    pSendSet->Update();
					m_ListBx.DeleteString(nIndex);
					m_ListBx.InsertString(nIndex,m_Phone);
					m_ListBx.SetItemDataPtr(nIndex,pUser);
				    pUser->Content=m_Content;
					pUser->Phone=m_Phone;
					pUser->Time=time;

				}
			else pSendSet->CancelUpdate();
			pSendSet->Close();
			delete pSendSet;
		}
		db.Close();
 	}
}

void CTimeToSend::OnDelete() 
{

	UpdateData();
	int nIndex=m_ListBx.GetCurSel();
	if(nIndex!=LB_ERR)
	{

	    CUser *pUser=(CUser *)m_ListBx.GetItemDataPtr(nIndex);
	    CDatabase db;
		CSendDb *pSendSet=NULL;
        if(db.Open("SendMessage"))
		{		
			pSendSet=new CSendDb();
			CString strSQL;
			strSQL="select * from MessageSend where ID=";
			char buf[10];
            ltoa(pUser->ID,buf,10);
			strSQL+=buf;
			pSendSet->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
			pSendSet->Delete();
			pSendSet->Close();
			delete pSendSet;
		}
		delete pUser;
		m_ListBx.DeleteString(nIndex);
		db.Close();
 	}
	m_Date=CTime::GetCurrentTime();
    m_Time=CTime::GetCurrentTime();
	m_Phone=m_Content="";
	UpdateData(FALSE);
}

void CTimeToSend::OnAdd() 
{

		UpdateData();
	    CDatabase db;	
		CSendDb *pSendSet=NULL;
		if(db.Open("SendMessage"))
		{
			pSendSet=new CSendDb();
			pSendSet->Open();
			CTime time=CTime(m_Date.GetYear(),m_Date.GetMonth(),m_Date.GetDay(),m_Time.GetHour(),m_Time.GetMinute(),m_Time.GetSecond());
			pSendSet->AddNew();
			pSendSet->m_Phone=m_Phone;
            pSendSet->m_Content=m_Content;
			pSendSet->m_Time=time;
			pSendSet->Update();
			CUser *pUser=new CUser();
			pUser->Phone=pSendSet->m_Phone;
			pUser->Content=pSendSet->m_Content;
		 	pUser->Time=pSendSet->m_Time;
			pUser->ID=pSendSet->m_ID;
			int nIndex;
			nIndex=m_ListBx.AddString(pSendSet->m_Phone);
            m_ListBx.SetItemDataPtr(nIndex,pUser);
			delete pSendSet;
			db.Close();
			MessageBox("添加成功！");
		}
}