telephonelistdlg.cpp

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

// telephoneListDlg.cpp : implementation file
//

#include "stdafx.h"
#include "fee.h"
#include "telephoneListDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CtelephoneListDlg dialog
extern unsigned int telelistcmd;  //telelistcmd=1:modify,telelistcmd=2:deletle

CtelephoneListDlg::CtelephoneListDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CtelephoneListDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CtelephoneListDlg)
	m_strtelelistaddress = _T("");
	m_strtelelistbank = _T("");
	m_strtelelistbankaccount = _T("");
	m_strtelelistkind = _T("");
	m_strtelelistname = _T("");
	m_strtelelistnum = _T("");
	m_strteleliststatus = _T("");
	//}}AFX_DATA_INIT
}


void CtelephoneListDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CtelephoneListDlg)
	DDX_Text(pDX, IDC_EDIT_TELELIST_ADR, m_strtelelistaddress);
	DDX_Text(pDX, IDC_EDIT_TELELIST_BANK, m_strtelelistbank);
	DDX_Text(pDX, IDC_EDIT_TELELIST_BANKACCOUNT, m_strtelelistbankaccount);
	DDX_Text(pDX, IDC_EDIT_TELELIST_KIND, m_strtelelistkind);
	DDX_Text(pDX, IDC_EDIT_TELELIST_NAME, m_strtelelistname);
	DDX_Text(pDX, IDC_EDIT_TELELIST_NUM, m_strtelelistnum);
	DDX_Text(pDX, IDC_EDIT_TELELIST_STATUS, m_strteleliststatus);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CtelephoneListDlg, CDialog)
	//{{AFX_MSG_MAP(CtelephoneListDlg)
	ON_BN_CLICKED(ID_TELELISTBOTTON_MODIFY, OnTelelistbottonModify)
	ON_BN_CLICKED(ID_TELELISTBOTTON_DELETE, OnTelelistbottonDelete)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CtelephoneListDlg message handlers

void CtelephoneListDlg::OnTelelistbottonModify() 
{
	HRESULT result;

	// TODO: Add your control notification handler code here
	CString strSql,strTemp;
	CString oldaddr,oldbank,oldbankaccount,oldkind,oldname,oldnum,oldstatus;

	oldaddr=m_strtelelistaddress;
	oldbank=m_strtelelistbank;
	oldbankaccount=m_strtelelistbankaccount;
	oldkind=m_strtelelistkind;
	oldname=m_strtelelistname;
	oldnum=m_strtelelistnum;
	oldstatus=m_strteleliststatus;

	UpdateData(TRUE);
	strSql.Format("select * from telephone where telephoneCode='%s'"\
		,m_strtelelistnum);
	CFeeApp* pApp=(CFeeApp *)AfxGetApp();
	strSql.Format("select * from telephone where telephoneName='%s'\
		and telephoneAddress='%s'and telephoneCode='%s'\
		and telephoneKind='%s' and telephoneStatus='%s'\
		and telephoneFeeBank='%s' and telephoneFeeAccount='%s'",\
		oldname,oldaddr,oldnum,oldkind,oldstatus,oldbank,oldbankaccount);
	result=pApp->m_pjifeiRecordset->Open(strSql.AllocSysString(),
		pApp->m_pjifeiConnection.GetInterfacePtr(),
		adOpenDynamic,adLockOptimistic,adCmdText);
	if (!SUCCEEDED(result))
	{
		AfxMessageBox("can't open telephone table");
	}
	if(!pApp->m_pjifeiRecordset->adoEOF)
	{
		strTemp=m_strtelelistname;
		if (strTemp=="")
			strTemp="NULL";
		pApp->m_pjifeiRecordset->PutCollect("telephoneName",_variant_t(strTemp));
		strTemp=m_strtelelistaddress;
		if (strTemp=="")
			strTemp="NULL";
		pApp->m_pjifeiRecordset->PutCollect("telephoneAddress",_variant_t(strTemp));
		strTemp=m_strtelelistnum;
		if (strTemp=="")
			strTemp="NULL";
		pApp->m_pjifeiRecordset->PutCollect("telephoneCode",_variant_t(strTemp));
		strTemp=m_strtelelistkind;
		if (strTemp=="")
			strTemp="NULL";
		pApp->m_pjifeiRecordset->PutCollect("telephoneKind",_variant_t(strTemp));
		strTemp=m_strteleliststatus;
		if (strTemp=="")
			strTemp="NULL";
		pApp->m_pjifeiRecordset->PutCollect("telephoneStatus",_variant_t(strTemp));
		strTemp=m_strtelelistbank;
		if (strTemp=="")
			strTemp="NULL";
		pApp->m_pjifeiRecordset->PutCollect("telephoneFeeBank",_variant_t(strTemp));
		strTemp=m_strtelelistbankaccount;
		if (strTemp=="")
			strTemp="NULL";
		pApp->m_pjifeiRecordset->PutCollect("telephoneFeeAccount",_variant_t(strTemp));
		pApp->m_pjifeiRecordset->Update();
	}
	pApp->m_pjifeiRecordset->Close();
	AfxMessageBox("Modified successfully");
	CDialog::OnOK();
}

void CtelephoneListDlg::OnCancel() 
{
	// TODO: Add extra cleanup here
	
	CDialog::OnCancel();
}

void CtelephoneListDlg::OnTelelistbottonDelete() 
{
	// TODO: Add your control notification handler code here
	HRESULT result;

	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	
	CString strSql,strTemp;
	CString oldaddr,oldbank,oldbankaccount,oldkind,oldname,oldnum,oldstatus;

	oldaddr=m_strtelelistaddress;
	oldbank=m_strtelelistbank;
	oldbankaccount=m_strtelelistbankaccount;
	oldkind=m_strtelelistkind;
	oldname=m_strtelelistname;
	oldnum=m_strtelelistnum;
	oldstatus=m_strteleliststatus;

	CFeeApp* pApp=(CFeeApp *)AfxGetApp();
	strSql.Format("select * from telephone where telephoneName='%s'\
		and telephoneAddress='%s'and telephoneCode='%s'\
		and telephoneKind='%s' and telephoneStatus='%s'\
		and telephoneFeeBank='%s' and telephoneFeeAccount='%s'",\
		oldname,oldaddr,oldnum,oldkind,oldstatus,oldbank,oldbankaccount);
	result=pApp->m_pjifeiRecordset->Open(strSql.AllocSysString(),
		pApp->m_pjifeiConnection.GetInterfacePtr(),
		adOpenDynamic,adLockOptimistic,adCmdText);
	if (!SUCCEEDED(result))
	{
		AfxMessageBox("can't open telephone table");
	}
	if(!pApp->m_pjifeiRecordset->adoEOF)
	{
	}
	else
	{
		pApp->m_pjifeiRecordset->Close();
		AfxMessageBox("The record does not exist");
		return ;
	}
	pApp->m_pjifeiRecordset->Close();

	strSql.Format("delete * from telephone where telephoneName='%s'\
		and telephoneAddress='%s'and telephoneCode='%s'\
		and telephoneKind='%s' and telephoneStatus='%s'\
		and telephoneFeeBank='%s' and telephoneFeeAccount='%s'",\
		oldname,oldaddr,oldnum,oldkind,oldstatus,oldbank,oldbankaccount);
	result=pApp->m_pjifeiRecordset->Open(strSql.AllocSysString(),
		pApp->m_pjifeiConnection.GetInterfacePtr(),
		adOpenDynamic,adLockOptimistic,adCmdText);
	if (!SUCCEEDED(result))
	{
		AfxMessageBox("can't open telephone table");
	}
	AfxMessageBox("Deleted successfully");
	CDialog::OnOK();
	
}