adratedlg.cpp

本程序是一个宾馆程控电话系统

// AdrateDlg.cpp : implementation file
//

#include "stdafx.h"
#include "tel2006.h"
#include "AdrateDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CAdrateDlg dialog


CAdrateDlg::CAdrateDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CAdrateDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CAdrateDlg)
	m_strAdrate = _T("");
	//}}AFX_DATA_INIT
	//m_manager = new CDataManager();
}


void CAdrateDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAdrateDlg)
	DDX_Control(pDX, IDC_COMBO, m_combo);
	DDX_Text(pDX, IDC_EDIT_ADRATE, m_strAdrate);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CAdrateDlg, CDialog)
	//{{AFX_MSG_MAP(CAdrateDlg)
	ON_BN_CLICKED(IDC_OK_BUTTON, OnOkButton)
	ON_BN_CLICKED(IDC_CANCEL_BUTTON, OnCancelButton)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CAdrateDlg message handlers

void CAdrateDlg::OnOkButton() 
{
	// TODO: Add your control notification handler code here
	UpdateData(true);
	CString strTypeID;
	m_combo.GetLBText(m_combo.GetCurSel(),strTypeID);
	strTypeID = strTypeID.Left(2);
	ModifyData(strTypeID,m_strAdrate);
	AfxMessageBox("设置成功");
}

void CAdrateDlg::OnCancelButton() 
{
	// TODO: Add your control notification handler code here
	m_AdoConn.ExitConnect();
	//delete(m_manager);
	CDialog::OnCancel();
}

BOOL CAdrateDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_AdoConn.OnInitADOConn(".");
	m_combo.SetCurSel(0);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CAdrateDlg::ModifyData(CString strTypeID,CString strAdrate)
{
	CString strSQL("");

	try
	{
	//ADOConn m_AdoConn;
	//m_AdoConn.OnInitADOConn(m_strDataBase);
	//strSQL.Format("Delete from R_TelPhone where T_Number = '%s'",strNumber);
	strSQL.Format("update R_TelRate SET T_Adrate1 = '%s' WHERE T_TypeID ='%s'",strAdrate,strTypeID);
	
	_bstr_t vSQL =strSQL;
	m_AdoConn.ExecuteSQL(vSQL);
	}
	catch (_com_error e) 
	{
		CString errormessage;
		errormessage.Format("自定义错误信息3:%s",e.ErrorMessage());
		AfxMessageBox(errormessage);///显示错误信息
	}
}

BOOL CAdrateDlg::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)
		{
			UINT nID = GetFocus()->GetDlgCtrlID();
			switch(nID)
			{
			//case IDOK:
			//	break;
			case IDC_OK_BUTTON :
				OnOkButton();
				break;
			default:
				NextDlgCtrl();
			
			return TRUE;
			}
		}
	}
	return CDialog::PreTranslateMessage(pMsg);
}