detelindent.cpp

短信猫: 1确认短信Modem未连接电源

// DetelIndent.cpp : implementation file
//

#include "stdafx.h"
#include "短信群发.h"
#include "DetelIndent.h"
#include "into.h"
#include "IndentDialog.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDetelIndent dialog


CDetelIndent::CDetelIndent(CWnd* pParent /*=NULL*/)
	: CDialog(CDetelIndent::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDetelIndent)
	m_messageStr = _T("");
	m_endTime1 = COleDateTime::GetCurrentTime();
	m_endDay1 = COleDateTime::GetCurrentTime();
	m_startDay1 = COleDateTime::GetCurrentTime();
	m_startTime1 = COleDateTime::GetCurrentTime();
	m_id=-1;
	//}}AFX_DATA_INIT
}


void CDetelIndent::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDetelIndent)
	DDX_Text(pDX, IDC_MESSAGE_EDIT, m_messageStr);
	DDX_DateTimeCtrl(pDX, IDC_ENDTIME1, m_endTime1);
	DDX_DateTimeCtrl(pDX, IDC_ENDDAY1, m_endDay1);
	DDX_DateTimeCtrl(pDX, IDC_STARTDAY1, m_startDay1);
	DDX_DateTimeCtrl(pDX, IDC_STARTTIME1, m_startTime1);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDetelIndent, CDialog)
	//{{AFX_MSG_MAP(CDetelIndent)
	ON_BN_CLICKED(IDC_DEL_INDENT, OnDelIndent)
	ON_BN_CLICKED(IDC_MODIFY_INDENT, OnModifyIndent)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDetelIndent message handlers


void CDetelIndent::OnDelIndent() 
{
	CADORecordset record1,record2;
	BOOL ret;
	int id;

	if (m_id==-1)
	{
		return;
	}

	ret=record1.Open(db.m_pConnection,"ORDERS",CADORecordset::openTable);

	if(ret)
	{
		while(!record1.IsEof())
		{
			record1.GetFieldValue("ID",id);
			if(id==m_id)
			{
				record1.Delete();
				record1.Update();
			}
			record1.MoveNext();
		}
	}
	

	ret=record2.Open(db.m_pConnection,"PHONENUMBER",CADORecordset::openTable);

	if (ret)
	{
		while(!record2.IsEof())
		{
			record2.GetFieldValue("ORDERID",id);
			if(id==m_id)
			{
				record2.Delete();
				record2.Update();
			}
			record2.MoveNext();
		}
	}

	record1.Close;
	record2.Close();

	CIndentDialog * theIndent=(CIndentDialog *) GetParent()->GetParent();
	theIndent->printList();	
	
	AfxMessageBox("删除订单成功!");

	m_messageStr.Empty();
	UpdateData(FALSE);

}

void CDetelIndent::OnModifyIndent() 
{
 	BOOL ret;
 	CADORecordset record1;
 	int id;
 	CString strBeginDay  = _T("");
 	CString strBeginTime = _T("");
 	CString strEndDay    = _T("");
 	CString strEndTime   = _T("");
 	CString strStartTime = _T("");
 	CString strOverTime  = _T("");
 	CString strSql       = _T("");
 	
 	UpdateData(TRUE);
 	ret=pub.LengthCheck2(m_messageStr,140);
 	if(!ret)
 	{
 		AfxMessageBox("短信的长度最大为140 !");
 		return;
 	}
 	if(m_messageStr.IsEmpty())
 	{
 		AfxMessageBox("信息内容是空!");
 		return;
 	}
 	ret=pub.TimeCheck(m_startDay1,m_endDay1);
 	if(ret)
 	{
 		if (m_endDay1==m_startDay1)
 		{
 			ret=pub.TimeCheck(m_startTime1,m_endTime1);
 			if (!ret)
 			{
 				return;
 			}
 		}
 	}
 	else
 	{
 		return;
 	} 	
 	strBeginDay  = m_startDay1.Format("%Y-%m-%d");
 	strBeginTime = m_startTime1.Format("%H:%M");
 	strEndDay    = m_endDay1.Format("%Y-%m-%d");
 	strEndTime   = m_endTime1.Format("%H:%M");
 	
 	strStartTime.Format("'%s %s' , 'yyyy-mm-dd hh24:mi:ss' ",strBeginDay,strBeginTime);
 	strOverTime.Format("'%s %s' , 'yyyy-mm-dd hh24:mi:ss' ",strEndDay,strEndTime);
 	
 	strSql.Format("update ORDERS set ORDERSTART = to_date(%s) , ORDEREND = to_date(%s) , CONTENT = '%s' where ID = '%d'",strStartTime,strOverTime,m_messageStr,m_id);
 //	strSql.Format("insert into ORDERS (ID, ORDERSTART, ORDEREND, CONTENT) values (%d, to_date(%s), to_date(%s), '%s' )",m_id,strStartTime,strOverTime,m_strMessage);
 	
 	ret=record1.Open(db.m_pConnection,strSql,0);
 	if(ret)
 	{
 		m_messageStr.Empty();
		m_startDay1=COleDateTime::GetCurrentTime();
		m_endDay1=COleDateTime::GetCurrentTime();
		m_endTime1=COleDateTime::GetCurrentTime();
		m_startTime1=COleDateTime::GetCurrentTime();
 		UpdateData(FALSE);
 		CIndentDialog * theIndent=(CIndentDialog *) GetParent()->GetParent();
 		theIndent->printList();
		AfxMessageBox("订单修改成功!");
 	}
 	else
 	{
 		AfxMessageBox("更新数据失败!");
 		return;
 	}
 	record1.Close();
}