queryorderform.cpp

使用短信猫可以实现短信的群发

// QueryOrderForm.cpp : implementation file
//

#include "stdafx.h"
#include "sms.h"
#include "QueryOrderForm.h"

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

/////////////////////////////////////////////////////////////////////////////
// CQueryOrderForm dialog


CQueryOrderForm::CQueryOrderForm(CWnd* pParent /*=NULL*/)
	: CDialog(CQueryOrderForm::IDD, pParent)
{
	//{{AFX_DATA_INIT(CQueryOrderForm)
	m_StartDate = COleDateTime::GetCurrentTime();
	m_StartTime = COleDateTime::GetCurrentTime();
	m_EndDate = COleDateTime::GetCurrentTime();
	m_EndTime = COleDateTime::GetCurrentTime();
	m_OrderFormContent = _T("");
	//}}AFX_DATA_INIT
}


void CQueryOrderForm::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CQueryOrderForm)
	DDX_DateTimeCtrl(pDX, IDC_START_DATE, m_StartDate);
	DDX_DateTimeCtrl(pDX, IDC_START_TIME, m_StartTime);
	DDX_DateTimeCtrl(pDX, IDC_END_DATE, m_EndDate);
	DDX_DateTimeCtrl(pDX, IDC_END_TIME, m_EndTime);
//	DDX_Text(pDX, IDC_ORDER_FORM_CONTENT, m_OrderFormContent);
	DDV_MaxChars(pDX, m_OrderFormContent, 140);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CQueryOrderForm, CDialog)
	//{{AFX_MSG_MAP(CQueryOrderForm)
	ON_BN_CLICKED(IDC_Search, OnSearch)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CQueryOrderForm message handlers

void CQueryOrderForm::OnSearch() 
{
	// TODO: Add your control notification handler code here
	UpdateData(); //将窗口的内容更新到于之关连的对象或值中去 
	COleDateTime startDateTime(m_StartDate.GetYear(),
								m_StartDate.GetMonth(),
								m_StartDate.GetDay(),
								m_StartTime.GetHour(),
								m_StartTime.GetMinute(),
								m_StartTime.GetSecond());
	
	COleDateTime endDateTime(m_EndDate.GetYear(),
								m_EndDate.GetMonth(),
								m_EndDate.GetDay(),
								m_EndTime.GetHour(),
								m_EndTime.GetMinute(),
								m_EndTime.GetSecond());
	
	TRACE("Start %d %d %d %d %d %d\n",m_StartDate.GetYear(),m_StartDate.GetMonth(),m_StartDate.GetDay(),\
		m_StartTime.GetHour(),m_StartTime.GetMinute(),m_StartTime.GetSecond());
	
	TRACE("End %d %d %d %d %d %d\n",m_EndDate.GetYear(),m_EndDate.GetMonth(),m_EndDate.GetDay(),\
		m_EndTime.GetHour(),m_EndTime.GetMinute(),m_EndTime.GetSecond());
	
	if(startDateTime >= endDateTime)
	{
		AfxMessageBox("结束时间必须大于开始时间");
		return;
	}
	
	
	//////////////////////////////////////////////////////////////////////////
	///数据库操作
	//////////////////////////////////////////////////////////////////////////
	CSMSApp * pCSMSApp=(CSMSApp *)AfxGetApp();//取得App类对象的指针
	CSMSADO &Ado=pCSMSApp->m_SMSAdo;
	
	//这里判断数据连接是否连接成功
	if(!Ado.IsConnection())
	{
		MessageBox("连接数据库出错\n请重新设置Oracle相关信息");
		return;
	}
	

	
	CString sql;
	long isRecordSet=0;
	int id=((COrderFormManager *)(GetParent()->GetParent()))->m_id;
	sql.Empty();//清空查询语句
	//插入定单
	sql.Format("select * from orders where \
		orderstart>=to_Date('%d-%d-%d %d:%d:%d','YYYY-MM-DD HH24:MI:SS') and \
		orderend<=to_Date('%d-%d-%d %d:%d:%d','YYYY-MM-DD HH24:MI:SS')",
		startDateTime.GetYear(),startDateTime.GetMonth(),startDateTime.GetDay(),
		startDateTime.GetHour(),startDateTime.GetMinute(),startDateTime.GetSecond(),
		endDateTime.GetYear(),endDateTime.GetMonth(),endDateTime.GetDay(),
		endDateTime.GetHour(),endDateTime.GetMinute(),endDateTime.GetSecond());
	
	TRACE("%s\n",sql);

	SQLRECORDSET rs=Ado.ExecuteWithRecordset(sql);
	
	((COrderFormManager *)(GetParent()->GetParent()))->ShowOrderFormListFromRecordset(rs);
//	m_OrderFormContent.Empty();
	
	UpdateData(FALSE);//将变量的内容更新到于之关加的窗口上

}

BOOL CQueryOrderForm::PreTranslateMessage(MSG* pMsg) 
{
	// TODO: Add your specialized code here and/or call the base class
	if (pMsg->message == WM_KEYDOWN)
	{	
		if (pMsg->wParam == VK_RETURN)	return TRUE;
		if (pMsg->wParam == VK_ESCAPE)	return TRUE;
	} 
	return CDialog::PreTranslateMessage(pMsg);
}