balancetimesetdlg.cpp

VC6.0环境下编写的一个交换机计费程序。

// balancetimesetDlg.cpp : implementation file
//

#include "stdafx.h"
#include "fee.h"
#include "balancetimesetDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CbalancetimesetDlg dialog


CbalancetimesetDlg::CbalancetimesetDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CbalancetimesetDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CbalancetimesetDlg)
	m_strbalanceendday = _T("");
	m_strbalanceendmonth = _T("");
	m_strbalanceendyear = _T("");
	m_strbalancestartday = _T("");
	m_strbalancestartmonth = _T("");
	m_strbalancestartyear = _T("");
	//}}AFX_DATA_INIT
}


void CbalancetimesetDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CbalancetimesetDlg)
	DDX_CBString(pDX, IDC_COMBO_BALANCE_ENDDAY, m_strbalanceendday);
	DDX_CBString(pDX, IDC_COMBO_BALANCE_ENDMONTH, m_strbalanceendmonth);
	DDX_CBString(pDX, IDC_COMBO_BALANCE_ENDYEAR, m_strbalanceendyear);
	DDX_CBString(pDX, IDC_COMBO_BALANCE_STARTDAY, m_strbalancestartday);
	DDX_CBString(pDX, IDC_COMBO_BALANCE_STARTMONTH, m_strbalancestartmonth);
	DDX_CBString(pDX, IDC_COMBO_BALANCE_STARTYEAR, m_strbalancestartyear);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CbalancetimesetDlg, CDialog)
	//{{AFX_MSG_MAP(CbalancetimesetDlg)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CbalancetimesetDlg message handlers

void CbalancetimesetDlg::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(TRUE);
	CString strSql;
	HRESULT result;

	CFeeApp* pApp=(CFeeApp *)AfxGetApp();
	strSql.Format("select * from balancetimeset ");
	result=pApp->m_pjifeiRecordset->Open(strSql.AllocSysString(),
		pApp->m_pjifeiConnection.GetInterfacePtr(),
		adOpenDynamic,adLockOptimistic,adCmdText);
	if (!SUCCEEDED(result))
	{
		AfxMessageBox("can't open feetele table");
	}
	if(!pApp->m_pjifeiRecordset->adoEOF)
	{
		pApp->m_pjifeiRecordset->PutCollect("balancestartyear",_variant_t(m_strbalancestartyear));
		pApp->m_pjifeiRecordset->PutCollect("balancestartmonth",_variant_t(m_strbalancestartmonth));
		pApp->m_pjifeiRecordset->PutCollect("balancestartday",_variant_t(m_strbalancestartday));
		pApp->m_pjifeiRecordset->PutCollect("balanceendyear",_variant_t(m_strbalanceendyear));
		pApp->m_pjifeiRecordset->PutCollect("balanceendmonth",_variant_t(m_strbalanceendmonth));
		pApp->m_pjifeiRecordset->PutCollect("balanceendday",_variant_t(m_strbalanceendmonth));
		pApp->m_pjifeiRecordset->Update();
	}
	else
	{
		pApp->m_pjifeiRecordset->AddNew();
		pApp->m_pjifeiRecordset->PutCollect("balancestartyear",_variant_t(m_strbalancestartyear));
		pApp->m_pjifeiRecordset->PutCollect("balancestartmonth",_variant_t(m_strbalancestartmonth));
		pApp->m_pjifeiRecordset->PutCollect("balancestartday",_variant_t(m_strbalancestartday));
		pApp->m_pjifeiRecordset->PutCollect("balanceendyear",_variant_t(m_strbalanceendyear));
		pApp->m_pjifeiRecordset->PutCollect("balanceendmonth",_variant_t(m_strbalanceendmonth));
		pApp->m_pjifeiRecordset->PutCollect("balanceendday",_variant_t(m_strbalanceendmonth));
		pApp->m_pjifeiRecordset->Update();
	}
	pApp->m_pjifeiRecordset->Close();

	CDialog::OnOK();
}